####################################################
TOP 5 LARGE SEGMENT GROWTH(OBJECT GROWTH)
####################################################
Please find the below query to identify the top 5 segments in an oracle database with resepective to its size.
col SEGMENT_NAME for a30
col owner for a20
col SEGMENT_TYPE for a20
SELECT * FROM
(
select
owner,
SEGMENT_NAME,
SEGMENT_TYPE,
BYTES/1024/1024/1024 GB,
TABLESPACE_NAME
from
dba_segments order by 4 desc
) WHERE
ROWNUM <= 5;
OWNER SEGMENT_NAME SEGMENT_TYPE GB TABLESPACE_NAME
-------------------- ------------------------------ -------------------- --------------- --------------------
ABC POI_ATNL_KIT_DATA_KT TABLE 634.56091308594 USERS
ABC POS_ATNL_DATA_BKP_KIT TABLE 477.84375 USERS
ABC POS_ADDTNL_DATA_ADD_KT_A TABLE 140.8427734375 USERS
XYZ AT_DW_SALES_RPT TABLE 114.28125 USERS
YXAD P_DATA_UDTC_BKLD TABLE 103.59356689453 USERS
TOP 5 LARGE SEGMENT GROWTH(OBJECT GROWTH)
####################################################
Please find the below query to identify the top 5 segments in an oracle database with resepective to its size.
col SEGMENT_NAME for a30
col owner for a20
col SEGMENT_TYPE for a20
SELECT * FROM
(
select
owner,
SEGMENT_NAME,
SEGMENT_TYPE,
BYTES/1024/1024/1024 GB,
TABLESPACE_NAME
from
dba_segments order by 4 desc
) WHERE
ROWNUM <= 5;
OWNER SEGMENT_NAME SEGMENT_TYPE GB TABLESPACE_NAME
-------------------- ------------------------------ -------------------- --------------- --------------------
ABC POI_ATNL_KIT_DATA_KT TABLE 634.56091308594 USERS
ABC POS_ATNL_DATA_BKP_KIT TABLE 477.84375 USERS
ABC POS_ADDTNL_DATA_ADD_KT_A TABLE 140.8427734375 USERS
XYZ AT_DW_SALES_RPT TABLE 114.28125 USERS
YXAD P_DATA_UDTC_BKLD TABLE 103.59356689453 USERS
1 comment:
Have your Gdax 2FA phone lost? Don’t panic. . This platform will help to solve your issue. The viewer has to make a call on our Gdax Support Number1-888-764-0492 and share the information. Our experts will get in touch with you to give the best solution to fix your problem. The tech team will have insight on the issue and give instant revert. The services are available 24/7. The user may contact to us for the concerned query on service number. To be assure or relief, you can grab the accurate knowledge from the skilled professionals by calling on the customer care number anytime from anywhere.
Post a Comment