[root@zydb]/#su - oracle
3004-500 User "oracle" does not exist.
[root@zydb]/#su - zyoracle
[YOU HAVE NEW MAIL]
$ pwd
/zyhome/oracle
$ vi userskz.sql
alter database datafile '/zyhome/oracle/oradata/ossdb1/users01.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users02.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users03.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users04.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users05.dbf' resize 24576M;
"userskz.sql" [New file] 6 lines, 510 characters
$ cat userskz.sql
alter database datafile '/zyhome/oracle/oradata/ossdb1/users01.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users02.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users03.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users04.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users05.dbf' resize 24576M;
alter database datafile '/zyhome/oracle/oradata/ossdb1/users06.dbf' resize 24576M;
$ ls
5496862 jre oradata product userskz.sql
admin jyc oui s.sql
doc oraInventory p5496862_92080_AIX64-5L.zip sqlnet.log
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Aug 28 09:36:48 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> set timing on
SQL> @userskz.sql
Database altered.
Elapsed: 00:00:40.00
Database altered.
Elapsed: 00:00:38.85
Database altered.
Elapsed: 00:00:38.64
Database altered.
Elapsed: 00:00:38.53
Database altered.
Elapsed: 00:00:40.00
Database altered.
Elapsed: 00:00:39.23
SQL> col file_name for a50
SQL> select file_name,sum(bytes)/1024/1024/1024,AUTOEXTENSIBLE from dba_data_files where tablespace_name='USERS' group by file_name,AUTOEXTENSIBLE;
FILE_NAME SUM(BYTES)/1024/1024/1024 AUT
-------------------------------------------------- ------------------------- ---
/zyhome/oracle/oradata/ossdb1/users01.dbf 24 YES
/zyhome/oracle/oradata/ossdb1/users02.dbf 24 NO
/zyhome/oracle/oradata/ossdb1/users03.dbf 24 NO
/zyhome/oracle/oradata/ossdb1/users04.dbf 24 NO
/zyhome/oracle/oradata/ossdb1/users05.dbf 24 NO
/zyhome/oracle/oradata/ossdb1/users06.dbf 24 NO
6 rows selected.
Elapsed: 00:00:00.01
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
$ df -gt
Filesystem GB blocks Used Free %Used Mounted on
/dev/hd4 5.00 2.99 2.01 60% /
/dev/hd2 5.00 2.42 2.58 49% /usr
/dev/hd9var 2.00 0.49 1.51 25% /var
/dev/hd3 2.00 0.14 1.86 7% /tmp
/dev/fwdump 1.00 0.00 1.00 1% /var/adm/ras/platform
/dev/hd1 0.25 0.00 0.25 1% /home
/proc - - - - /proc
/dev/hd10opt 1.00 0.48 0.52 48% /opt
/dev/zy_arc 50.00 0.01 49.99 1% /zyarchive
/dev/zy_ora 490.00 318.22 171.78 65% /zyhome
/dev/zy_redo 5.00 1.95 3.05 40% /zyredo
$ echo $ORACLE_SID
ossdb1
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Aug 28 09:44:04 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> cd jyc
SP2-0042: unknown command "cd jyc" - rest of line ignored.
SQL> exit
$ cd jyc
$ sqlplus /nolog
SQL*Plus: Release 9.2.0.8.0 - Production on Tue Aug 28 09:44:24 2012
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
SQL> conn /as sysdba
Connected.
SQL> @tbs
TABLESPACE_NAME SUM_SPACE(M) SUM_BLOCKS USED_SPACE(M) USED_RATE(%) FREE_SPACE(M)
------------------------------ ------------ ---------- ------------- ------------ -------------
EXAMPLE 136.88 17520 136.57 99.77 .31
XDB 45 5760 44.75 99.44 .25
TOOLS 31.25 4000 29.56 94.59 1.69
USERS 147456 18874368 110926.37 75.23 36529.63
CWMLITE 20 2560 15 75 5
DRSYS 20 2560 9.69 48.45 10.31
ODM 20 2560 9.56 47.8 10.44
KCGL 1000 128000 361.44 36.14 638.56
PERFSTAT 500 64000 162.81 32.56 337.19
SYSTEM 2000 256000 608.25 30.41 1391.75
UNDOTBS1 4000 512000 213.87 5.35 3786.13
TABLESPACE_NAME SUM_SPACE(M) SUM_BLOCKS USED_SPACE(M) USED_RATE(%) FREE_SPACE(M)
------------------------------ ------------ ---------- ------------- ------------ -------------
INDX 500 64000 .12 .02 499.88
TEMP 11650 1491200 0
13 rows selected.
SQL> exit
Disconnected from Oracle9i Enterprise Edition Release 9.2.0.8.0 - 64bit Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.8.0 - Production
$ exit
[root@zydb]/#exit
阅读(1274) | 评论(0) | 转发(0) |
