- 论坛徽章:
- 0
|
SQL> select text from dba_views where view_name='SM$TS_FREE';
TEXT
--------------------------------------------------------------------------------
select tablespace_name, sum(bytes) bytes from dba_free_space
group by tables
SQL> select tablespace_name, sum(bytes) bytes from dba_segmentS
2 group by tablespace_name;
TABLESPACE_NAME BYTES
------------------------------ ----------
SYSTEM 510197760
USERS 3080192
TBS_1 196608
SYSAUX 433586176
EXAMPLE 79953920
UNDOTBS1 17104896
6 rows selected.
SQL> show linesize
linesize 80
SQL> set linesize 100
SQL> show linesize
linesize 100
SQL> select text from dba_views where view_name='SM$TS_FREE';
TEXT
--------------------------------------------------------------------------------
select tablespace_name, sum(bytes) bytes from dba_free_space
group by tables
SQL> desc dba_views;
Name Null? Type
----------------------------------------------------- -------- ------------------------------------
OWNER NOT NULL VARCHAR2(30)
VIEW_NAME NOT NULL VARCHAR2(30)
TEXT_LENGTH NUMBER
TEXT LONG
TYPE_TEXT_LENGTH NUMBER
TYPE_TEXT VARCHAR2(4000)
OID_TEXT_LENGTH NUMBER
OID_TEXT VARCHAR2(4000)
VIEW_TYPE_OWNER VARCHAR2(30)
VIEW_TYPE VARCHAR2(30)
SUPERVIEW_NAME VARCHAR2(30)
SQL> show long
long 80
SQL> set long 200
SQL> show long
long 200
SQL> select text from dba_views where view_name='SM$TS_FREE';
TEXT
--------------------------------------------------------------------------------
select tablespace_name, sum(bytes) bytes from dba_free_space
group by tablespace_name
SQL>
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u1/38775/showart_475100.html |
|