扩展表空间

[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