SQL> select segment_name,partition_name,round
(bytes/1024/1024) from user_segments where segment_name
='STAT_SUBMIT_CENTER' and bytes/1024/1024>0.25 order by 3
desc;SEGMENT_NAME
PARTITION_NAME ROUND(BYTES/1024/1024)-------------------
------- ------------------------------ -----------
-----------STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051101
1722STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051021
1488STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051111
1440STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051121
1355STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051221
1335STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20050911
1309STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051211
1253STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051201
1247STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20050921
1198STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20060101
1151STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20060111
1068STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051001
1018STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20051011
865STAT_SUBMIT_CENTER
STAT_SUBMIT_CENTER_20060121 79614 rows
selected.
--------------------next---------------------
SQL> show parameter workNAME TYPE VALUE---
--------------------------------- ----------- ---------------------
---------workarea_size_policy
string AUTOSQL> show parameter
pgaNAME TYPE VALUE------------------------------------ ----------- ----------
--------------------pga_aggregate_target
big integer 209715200SQL> select * from dba_temp_files;FILE_NAME---------
---------------------------------------------------------------------------------------------------------------
FILE_ID TABLESPACE_NAME BYTES BLOCKS
STATUS RELATIVE_FNO AUT MAXBYTES MAXBLOCKS---------- ---
--------------------------- ---------- ---------- --------- ------------ --- ----------
----------INCREMENT_BY
USER_BYTES USER_BLOCKS------------ ---------- -----------
/bgdata/oracle/temp01.dbf 1
TEMP 3563061248 434944
AVAILABLE 1 YES 4294967296 524288 6400
3562012672 434816
--------------------next---------------------
阅读(192) | 评论(0) | 转发(0) |
