Pages
Home
INTERVIEW QUESTIONS
ORA-ERRORS
DBA DAILY SCRIPTS
DataPump
Dataguard
RAC
REFRESHES
ORACLE ONLINE DBA
Updates
Oracle: Query to find the 10 Largest Objects in DB
SELECT * FROM
(
select
SEGMENT_NAME,
SEGMENT_TYPE,
BYTES/1024/1024/1024 GB,
TABLESPACE_NAME
from
dba_segments
order by 3 desc
) WHERE
ROWNUM <= 10
0 comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2017
(1)
►
June
(1)
►
2014
(2)
►
January
(2)
▼
2013
(26)
►
July
(1)
►
May
(17)
►
April
(2)
▼
March
(5)
Oracle RAC Basic
Oracle: Query to find the 10 Largest Objects in DB
Oracle: DBMS_STATS Gather Statistics of Schema, Ta...
Create External Table from CSV File
How to find long running query in oracle?
►
February
(1)
►
2012
(28)
►
November
(28)
Followers
Home
DBA DAILY SCRIPTS
DataPump
ORA-ERRORS
INTERVIEW QUESTIONS
REFRESHES
Dataguard
RAC
Copyright ©
ORACLE ONLINE DBA
Developed By Pavan Yennampelli
0 comments:
Post a Comment