Dear Readers,
In this article, we will see TableSpace Menu Bar in SecureCRT .
TBS_FREE :
|
1 2 3 |
set linesize 130 set pagesize 1000 col tablespace format a30 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 |
select tablespace_name tablespace, round(sum(a.total1)/1048576, 0) Total, round(sum(a.total1)/1048576, 0)-round(sum(a.sum1)/1048576, 0) used, round(sum(a.sum1)/1048576, 0) free, round(((sum(a.sum1)/1048576)/(sum(a.total1)/1048576))*100, 0) pct_free, round(sum(a.maxb)/1048576, 0) largest, max(a.cnt) fragment from (select tablespace_name, 0 total1, sum(bytes) sum1, max(bytes) MAXB, count(bytes) cnt from dba_free_space group by tablespace_name union select tablespace_name, sum(bytes) total1, 0, 0, 0 from dba_data_files group by tablespace_name) a group by a.tablespace_name order by 5 desc; |
Out Put :
|
1 2 3 4 5 6 |
TABLESPACE TOTAL USED FREE PCT_FREE LARGEST FRAGMENT ------------------------------ ---------- ---------- ---------- ---------- ---------- ---------- USERS 5 2 3 65 3 1 UNDOTBS1 60 24 36 59 25 13 SYSAUX 730 690 40 5 38 14 SYSTEM 800 792 8 1 8 2 |
TBS_FILE :
|
1 2 3 4 |
set linesize 130 set pagesize 1000 set echo on col file_name format a80 |
|
1 2 3 4 |
select file_id,file_name, bytes/1048576 mb,AUTOEXTENSIBLE,MAXBYTES/1024/1024/1024 MAX_BYTES_GB from dba_data_files where tablespace_name='&tbs' order by substr(file_name,length(file_name)-5,6); |
SEGMENTBYNAME :
|
1 2 3 4 5 6 7 8 9 10 11 |
set ver off set trimspool on set lines 199 col owner for a15 col segment_name for a30 col segment_type for a25 col tablespace_name for a22 set pagesize 150 col part_name for a30 compu sum of size_mb on report break on report skip 2 |
|
1 2 3 4 5 |
select owner, segment_name,partition_name part_name, buffer_pool, segment_type, tablespace_name, extents, round(bytes/1024/1024) size_mb from dba_segments where segment_name like upper('&segname'); |
DBSIZE :
|
1 2 3 4 |
select sum(bytes)/1024/1024/1024 GB from dba_segments; GB ---------- 1.46954346 |
|
1 2 3 4 |
select sum(bytes)/1024/1024/1024 GB from dba_data_files; GB ---------- 1.55761719 |
|
1 2 3 4 |
select sum(bytes)/1024/1024/1024 GB from dba_temp_files; GB ---------- .05859375 |
Seg_With_Highest_IO_Reads :
|
1 2 3 4 |
set pagesize 200 set linesize 300 col segment_name format a40 col owner format a10 |
|
1 2 3 4 5 6 7 |
select segment_name,object_type,total_physical_reads from ( select owner||'.'||object_name as segment_name,object_type, value as total_physical_reads from v$segment_statistics where statistic_name in ('physical reads') order by total_physical_reads desc) where rownum <=10; |
Out Put :
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SEGMENT_NAME OBJECT_TYPE TOTAL_PHYSICAL_READS ---------------------------------------- ------------------ -------------------- SYS.REFCON$ TABLE 6665 SYS.OBJ$ TABLE 3057 SYS.TYPE$ TABLE 2728 SYS.SEG$ TABLE 2694 SYS.IDL_UB1$ TABLE 1803 SYS.I_OBJ5 INDEX 962 SYS.HISTGRM$ TABLE 958 SYS.I_OBJ1 INDEX 615 SYS.IDL_UB2$ TABLE 542 SYS.WRI$_OPTSTAT_HISTGRM_HISTORY TABLE PARTITION 462 |
Seg_With_Highest_IO_Writes :
|
1 2 3 4 |
set pagesize 200 set linesize 300 col segment_name format a40 col owner format a10 |
|
1 2 3 4 5 6 7 |
select segment_name,object_type,total_physical_reads from ( select owner||'.'||object_name as segment_name,object_type, value as total_physical_reads from v$segment_statistics where statistic_name in ('physical writes') order by total_physical_reads desc) where rownum <=10; |
Out Put :
|
1 2 3 4 5 6 7 8 9 10 11 12 |
SEGMENT_NAME OBJECT_TYPE TOTAL_PHYSICAL_READS ---------------------------------------- ------------------ -------------------- SYS.SYS_LOB0000010986C00001$$ LOB 38 SYS.SYS_LOB0000006450C00009$$ LOB PARTITION 32 SYS.WRH$_LATCH TABLE PARTITION 16 SYS.WRH$_SYSSTAT_PK INDEX PARTITION 15 SYS.COL_USAGE$ TABLE 14 SYS.WRH$_SYSSTAT TABLE PARTITION 14 SYS.WRH$_LATCH_PK INDEX PARTITION 14 SYS.WRH$_SYSTEM_EVENT_PK INDEX PARTITION 13 SYS.WRH$_SQLSTAT TABLE PARTITION 11 SYS.WRH$_SYSTEM_EVENT TABLE PARTITION 11 |
DF’s_With_Highest_IO :
|
1 2 3 |
col name format a40 set linesize 300 col name for a80 |
|
1 2 3 4 5 |
select * from ( select name,phyrds, phywrts,readtim,writetim from v$filestat a, v$datafile b where a.file#=b.file# order by readtim desc) where rownum <6; |
Out Put :
|
1 2 3 4 5 6 |
NAME PHYRDS PHYWRTS READTIM WRITETIM -------------------------------------------------------------------------------- ---------- ---------- ---------- ---------- /u01/app/oracle/oradata/ORCL/datafile/o1_mf_system_ht2r2y58_.dbf 37552 70 1039 8 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_sysaux_ht2r1twv_.dbf 55917 254 532 20 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_undotbs1_ht2r4dlm_.dbf 58 92 5 8 /u01/app/oracle/oradata/ORCL/datafile/o1_mf_users_ht2r4cfp_.dbf 150 0 1 0 |
SYSAUX_Contents :
|
1 |
SELECT occupant_name, space_usage_kbytes/1024 MB FROM V$SYSAUX_OCCUPANTS; |
Out Put :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 |
OCCUPANT_NAME MB ---------------------------------------------------------------- ------------------------------ LOGMNR 19.25 LOGSTDBY 1.5 SMON_SCN_TIME 25.75 AUDSYS 4 PL/SCOPE 1.5625 STREAMS 1 AUDIT_TABLES 0 XDB 68.5 AO 43.5625 XSOQHIST 43.5625 XSAMD 0 SM/AWR 61327.4375 SM/ADVISOR 76.875 SM/OPTSTAT 666.9375 SM/OTHER 335.9375 STATSPACK 0 SDO 98.6875 WM 7.1875 ORDIM .4375 ORDIM/ORDDATA 15.9375 ORDIM/ORDPLUGINS 0 ORDIM/SI_INFORMTN_SCHEMA 0 EM 0 TEXT 3.8125 ULTRASEARCH 0 ULTRASEARCH_DEMO_USER 0 EXPRESSION_FILTER 3.6875 EM_MONITORING_USER .875 TSM 0 SQL_MANAGEMENT_BASE 4.5625 AUTO_TASK .3125 JOB_SCHEDULER 4.5625 |
Owner_TBS_Report :
|
1 2 3 4 |
SET TERMOUT OFF; COLUMN current_instance NEW_VALUE current_instance NOPRINT; SELECT rpad(instance_name, 17) current_instance FROM v$instance; SET TERMOUT ON; |
Out Put :
|
1 2 3 4 5 |
PROMPT PROMPT +------------------------------------------------------------------------+ PROMPT | Report : Owner to Tablespace Report | PROMPT | Instance : ¤t_instance | PROMPT +------------------------------------------------------------------------+ |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 |
SET ECHO OFF SET FEEDBACK 6 SET HEADING ON SET LINESIZE 180 SET PAGESIZE 50000 SET TERMOUT ON SET TIMING OFF SET TRIMOUT ON SET TRIMSPOOL ON SET VERIFY OFF CLEAR COLUMNS CLEAR BREAKS CLEAR COMPUTES COLUMN owner FORMAT a20 HEADING "Owner" COLUMN tablespace_name FORMAT a30 HEADING "Tablespace Name" COLUMN segment_type FORMAT a18 HEADING "Segment Type" COLUMN bytes FORMAT 9,999,999,999,999 HEADING "Size (in Bytes)" COLUMN seg_count FORMAT 9,999,999,999 HEADING "Segment Count" BREAK ON report ON owner SKIP 2 COMPUTE sum LABEL "" OF seg_count bytes ON owner COMPUTE sum LABEL "Grand Total: " OF seg_count bytes ON report |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SELECT owner , tablespace_name , segment_type , sum(bytes) bytes , count(*) seg_count FROM dba_segments GROUP BY owner , tablespace_name , segment_type ORDER BY owner , tablespace_name , segment_type; |
Out Put :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 |
Owner Tablespace Name Segment Type Size (in Bytes) Segment Count -------------------- ------------------------------ ------------------ ------------------ -------------- SCOTT SYSTEM INDEX 131,072 2 SYSTEM TABLE 196,608 3 ******************** ------------------ -------------- 327,680 5 SYS SYSAUX CLUSTER 6,291,456 1 SYSAUX INDEX 8,141,406,208 443 SYSAUX INDEX PARTITION 20,977,745,920 3,409 SYSAUX LOB PARTITION 5,075,042,304 354 SYSAUX LOBINDEX 6,356,992 97 SYSAUX LOBSEGMENT 1,400,373,248 97 SYSAUX NESTED TABLE 393,216 6 SYSAUX SYSTEM STATISTICS 224,395,264 1 SYSAUX TABLE 6,472,794,112 1,046 SYSAUX TABLE PARTITION 23,922,540,544 2,743 SYSAUX TABLE SUBPARTITION 2,097,152 32 SYSTEM CLUSTER 217,448,448 9 SYSTEM INDEX 280,887,296 779 SYSTEM LOBINDEX 9,437,184 144 SYSTEM LOBSEGMENT 148,176,896 144 SYSTEM NESTED TABLE 655,360 10 SYSTEM ROLLBACK 458,752 1 SYSTEM TABLE 544,276,480 722 SYSTEM TABLE PARTITION 6,553,600 100 UNDOTBS1 TYPE2 UNDO 107,741,184 53 UNDOTBS2 TYPE2 UNDO 188,088,320 50 ******************** ------------------ -------------- 67,733,159,936 10,241 SYSTEM SYSAUX INDEX 1,769,472 27 SYSAUX INDEX PARTITION 4,456,448 68 SYSAUX LOBINDEX 720,896 8 SYSAUX LOBSEGMENT 10,354,688 8 SYSAUX TABLE 1,900,544 29 SYSAUX TABLE PARTITION 3,014,656 46 SYSTEM INDEX 9,043,968 138 SYSTEM LOBINDEX 917,504 14 SYSTEM LOBSEGMENT 917,504 14 SYSTEM TABLE 6,291,456 96 ******************** ------------------ -------------- 39,387,136 448 VINOD USERS INDEX 51,380,224 1 USERS TABLE 327,680 5 USERS TABLE PARTITION 394,264,576 13 ******************** ------------------ -------------- 445,972,480 19 |
Example_Add_DF:
|
1 2 3 |
--alter tablespace <TSNAME> add datafile '+DATA01' size1g; --alter tablespace <USERS> add datafile '+DATA01' autoextend on maxsize 20G; --alter tablespace <USERS> add datafile '+DATA' size 20G autoextend off; |
TBS_FREE_FOR_TS :
|
1 2 3 |
set linesize 130 set pagesize 1000 col tablespace format a30 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 |
select tablespace_name tablespace, round(sum(a.total1)/1048576, 0) Total, round(sum(a.total1)/1048576, 0)-round(sum(a.sum1)/1048576, 0) used, round(sum(a.sum1)/1048576, 0) free, round(((sum(a.sum1)/1048576)/(sum(a.total1)/1048576))*100, 0) pct_free, round(sum(a.maxb)/1048576, 0) largest, max(a.cnt) fragment from (select tablespace_name, 0 total1, sum(bytes) sum1, max(bytes) MAXB, count(bytes) cnt from dba_free_space where tablespace_name='&TS_Name' group by tablespace_name union select tablespace_name, sum(bytes) total1, 0, 0, 0 from dba_data_files where tablespace_name='&TS_Name' group by tablespace_name) a group by a.tablespace_name order by 5 desc; |
Out Put :
|
1 2 3 |
TABLESPACE TOTAL USED FREE PCT_FREE LARGEST FRAGMENT ------------------------------ ---------- ---------- ---------- ---------- ---------- ---------- USERS 2048 428 1620 79 1620 1 |
DF_CREATED_Date:
|
1 2 3 4 5 6 |
set linesize 300 set pagesize 100 col name for a100 alter session set nls_date_format='MM/DD/YYYY HH24:MI:SS'; select file#,name,CREATION_TIME,bytes/1024/1024/1024 from v$datafile where CREATION_TIME>sysdate-&No_of_Days order by CREATION_TIME desc; |
Out Put :
|
1 |
SQL> 2 Enter value for no_of_days: 300 |
|
1 2 3 4 |
FILE# NAME CREATION_TIME BYTES/1024/1024/1024 ---------- ---------------------------------------------------------------------------------------------------- ------------------- -------------------- 50 +DATA/ORCL1/DATAFILE/sysaux.297.1033312101 02/25/2020 15:08:21 10 49 +DATA/ORCL1/DATAFILE/sysaux.309.1032317659 02/14/2020 02:54:20 10 |
Resize_datafile:
|
1 2 3 4 5 6 7 8 |
set linesize 300 -- Please READ : Check the primary & stand by space in ASM or Filesystem, before resizing the datafile. -- select 'alter database datafile '''||file_name||''' resize 20G;' from dba_data_files where tablespace_name='&tablespace_name' and bytes/1024/1024/1024 <= 20; --alter database datafile '+DATA01/ORCL1/DATAFILE/user01' autoextend on maxsize 20g; ----select 'alter database datafile '''||file_name||''' autoextend on maxsize 20g;' from dba_data_files; --select 'alter database datafile '''||file_name||''' resize 20G;' from dba_data_files where tablespace_name='&tablespace_name' and bytes/1024/1024/1024 <= 20; --select 'alter database datafile '''||file_name||''' autoextend on maxsize 20g;' from dba_data_files where tablespace_name='&Tablespace_NAME'; ----select 'alter database datafile '''||file_name||''' autoextend on maxsize 20g;' from dba_data_files where tablespace_name='&Tablespace_NAME' and bytes/1024/1024/1024 <= 5; |
TBS_Properties :
|
1 2 |
set linesize 300 select TABLESPACE_NAME,SEGMENT_SPACE_MANAGEMENT,EXTENT_MANAGEMENT,ALLOCATION_TYPE from DBA_TABLESPACES; |
Out Put :
|
1 2 3 4 5 6 7 8 |
TABLESPACE_NAME SEGMEN EXTENT_MAN ALLOCATIO ------------------------------ ------ ---------- --------- SYSTEM MANUAL LOCAL SYSTEM SYSAUX AUTO LOCAL SYSTEM UNDOTBS1 MANUAL LOCAL SYSTEM TEMP MANUAL LOCAL UNIFORM UNDOTBS2 MANUAL LOCAL SYSTEM USERS AUTO LOCAL SYSTEM |
Make_DF_MaxSize_20g_AutoExt_on :
-Use Below Command with Caution
|
1 2 3 4 |
-- select file_name,MAXBYTES/1024/1024/1024 from dba_data_files; --select 'alter database datafile '''||file_name||''' autoextend on maxsize &Size_in_GB_EXAMPLE_10G;' from dba_data_files; --select 'alter database datafile '''||file_name||''' autoextend on maxsize &Size_in_GB_EXAMPLE_10G;' from dba_data_files where tablespace_name='&Tablespace_Name'; --select 'alter database datafile '''||file_name||''' autoextend on maxsize &Size_in_GB_EXAMPLE_10G;' from dba_data_files where tablespace_name='&Tablespace_Name' and (maxbytes/1024/1024/1024) < 20 ; |
Size_of_Schemas :
|
1 2 3 |
set linesize 300 set pagesize 100 select sum(bytes/1024/1024/1024),owner from dba_segments group by owner order by 1; |
Out Put :
|
1 2 3 4 5 6 7 |
SUM(BYTES/1024/1024/1024) OWNER ------------------------- ------------------ .415344238 VINOD 5.77716064 SCOTT 5.99926758 TEST 63.2357788 SYS 113.330139 XDEMO1 |
TBS_Segment’s_Size :
|
1 2 |
set linesize 300 SELECT TABLESPACE_NAME,SUM(BYTES)/1024/1024/1024 FROM DBA_SEGMENTS GROUP BY TABLESPACE_NAME ORDER BY 1; |
Out Put :
|
1 2 3 4 5 6 7 |
TABLESPACE_NAME SUM(BYTES)/1024/1024/1024 ------------------------------ ------------------------- SYSAUX 61.4666748 SYSTEM 1.14245605 UNDOTBS1 .099304199 UNDOTBS2 .250366211 USERS .417175293 |
Query to find how much space can be reclaimed from each datafile :
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 |
et linesize 1000 pagesize 0 feedback off trimspool on with hwm as ( -- get highest block id from each datafiles ( from x$ktfbue as we don't need all joins from dba_extents ) select /*+ materialize */ ktfbuesegtsn ts#,ktfbuefno relative_fno,max(ktfbuebno+ktfbueblks-1) hwm_blocks from sys.x$ktfbue group by ktfbuefno,ktfbuesegtsn ), hwmts as ( -- join ts# with tablespace_name select name tablespace_name,relative_fno,hwm_blocks from hwm join v$tablespace using(ts#) ), hwmdf as ( -- join with datafiles, put 5M minimum for datafiles with no extents select file_name,nvl(hwm_blocks*(bytes/blocks),5*1024*1024) hwm_bytes,bytes,autoextensible,maxbytes from hwmts right join dba_data_files using(tablespace_name,relative_fno) ) select case when autoextensible='YES' and maxbytes>=bytes then -- we generate resize statements only if autoextensible can grow back to current size '/* reclaim '||to_char(ceil((bytes-hwm_bytes)/1024/1024),999999) ||'M from '||to_char(ceil(bytes/1024/1024),999999)||'M */ ' ||'alter database datafile '''||file_name||''' resize '||ceil(hwm_bytes/1024/1024)||'M;' else -- generate only a comment when autoextensible is off '/* reclaim '||to_char(ceil((bytes-hwm_bytes)/1024/1024),999999) ||'M from '||to_char(ceil(bytes/1024/1024),999999) ||'M after setting autoextensible maxsize higher than current size for file ' || file_name||' */' end SQL from hwmdf where bytes-hwm_bytes>1024*1024 -- resize only if at least 1MB can be reclaimed order by bytes-hwm_bytes desc; |
Out Put :
|
1 2 3 4 |
/* reclaim 1006M from 1024M */ alter database datafile '+DATA/ORCL1/DATAFILE/test_uc_data01.294.1012054249' resize 19M; /* reclaim 1000M from 1024M */ alter database datafile '+DATA/ORCL1/DATAFILE/test_uc_index01.296.1012054255' resize 25M; /* reclaim 28M from 20480M after setting autoextensible maxsize higher than current size for file +DATA/ORCL1/DATAFILE/test_data01.305.1012586739 */ /* reclaim 10M from 23080M after setting autoextensible maxsize higher than current size for file +DATA/ORCL1/DATAFILE/undotbs1.263.1005927771 */ |
TBS_Free_With_Autoextend :
|
1 2 3 4 5 6 7 8 |
set feedback off set pagesize 100 set linesize 200 break on report compute sum of DF_CUR_USE_MB on report compute sum of AUTO_FREE_SPACE_MB on report col tablespace_name for a20 SET LINES 170 |
|
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 |
SELECT tablespace_name, ROUND(SUM(total_mb)) DF_MAX_MB, ROUND(SUM(total_mb)-SUM(free_mb)) DF_CUR_USE_MB, ROUND((SUM(total_mb)-SUM(free_mb))/SUM(total_mb)*100) DF_PCT_FULL, ROUND(SUM(max_mb)) MAX_AUTO_MB, ROUND(SUM(max_mb) - (SUM(total_mb)-SUM(free_mb))) AUTO_FREE_SPACE_MB, ROUND((SUM(total_mb)-SUM(free_mb))/SUM(max_mb)*100) AUTO_PCT_FULL FROM ( SELECT tablespace_name, SUM(bytes)/1024/1024 FREE_MB, 0 TOTAL_MB, 0 MAX_MB FROM dba_free_space GROUP BY tablespace_name UNION SELECT tablespace_name, 0 CURRENT_MB, SUM(bytes)/1024/1024 TOTAL_MB, SUM(DECODE(maxbytes,0,bytes, maxbytes))/1024/1024 MAX_MB FROM dba_data_files GROUP BY tablespace_name) GROUP BY tablespace_name; |
Out Put :
|
1 2 3 4 5 6 7 8 9 10 |
TABLESPACE_NAME DF_MAX_MB DF_CUR_USE_MB DF_PCT_FULL MAX_AUTO_MB AUTO_FREE_SPACE_MB AUTO_PCT_FULL -------------------- ---------- ------------- ----------- ----------- ------------------ ------------- TEST123 5120 103 2 5120 5017 2 SYSAUX 102400 62906 61 102400 39494 61 UNDOTBS1 53800 105 0 53800 53695 0 USERS 2048 428 21 2048 1620 21 SYSTEM 5120 1171 23 5120 3949 23 UNDOTBS2 43355 258 1 43355 43097 1 ------------- ------------------ sum 193101 745782 |
Chk_DF_Created_Date :
|
1 2 3 4 |
set linesize 300 col DF_NAME for a70 col TS_NAME for a30 select CREATION_TIME,FILE# ,STATUS,d.NAME DF_name,t.NAME TS_Name from v$datafile d,v$tablespace t where d.TS#=t.TS# and FILE#=&file_number; |
Out Put :
|
1 2 3 |
CREATION_ FILE# STATUS DF_NAME TS_NAME --------- ---------- ------- ---------------------------------------------------------------------- ------------------------------ 12-JUN-19 20 ONLINE +DATA/ORCL1/DATAFILE/wms_data01.286.1010784861 DATA01_TBS1 |
Segment_Sizes_for_Tablespace :
|
1 2 3 4 5 6 |
set linesize 300 col segment_name for a40 col TABLESPACE_NAME for a30 col SEGMENT_TYPE for a30 select SEGMENT_NAME,BYTES/1024/1024/1024 In_GB,TABLESPACE_NAME,SEGMENT_TYPE from dba_segments where TABLESPACE_NAME='&TABLESPACE_NAME' order by 2 desc; |
Out Put :
|
1 2 3 4 5 6 7 |
SEGMENT_NAME IN_GB TABLESPACE_NAME SEGMENT_TYPE ---------------------------------------- ---------- ------------------------------ ------------- SAR_CPU .051757813 TBS_DATA01 TABLE CPU_DATE_TIME .047851563 TBS_DATA01 INDEX DB_SIZE_HISTORY .000183105 TBS_DATA01 TABLE ARCHIVE_USAGE_HISTORY .000061035 TBS_DATA01 TABLE ARCHIVE_USAGE_HISTORY_PK .000061035 TBS_DATA01 INDEX |
seg_type_size :
|
1 |
select sum(bytes)/1024/1024/1024,SEGMENT_TYPE from dba_segments where owner='&OWNER' group by SEGMENT_TYPE; |
Out Put :
|
1 2 3 4 5 6 7 8 9 |
SUM(BYTES)/1024/1024/1024 SEGMENT_TYPE ------------------------- ------------------------------ .002624512 LOBINDEX .002929688 INDEX PARTITION 29.0627441 TABLE PARTITION 21.7182617 LOB PARTITION .29095459 LOBSEGMENT 22.7214355 TABLE 39.531189 INDEX |
Thank you for giving your valuable time to read the above information.
Follow us on
Website : www.ktexperts.com
Facebook Page : KTexperts
Linkedin Page : KT EXPERTS
Follow Me On
Linkedin :Venkat Vinod Kumar Siram
Note: Please test scripts in Non Prod before trying in Production.
Loading...
