dba:oracle:oracle_sql_querys:storage_management
Differences
This shows you the differences between two versions of the page.
Both sides previous revisionPrevious revisionNext revision | Previous revisionLast revisionBoth sides next revision | ||
oracle:oracle_sql_querys:storage_management [2018/10/10 08:23] – dodger | dba:oracle:oracle_sql_querys:storage_management [2022/02/11 11:36] – external edit 127.0.0.1 | ||
---|---|---|---|
Line 257: | Line 257: | ||
) | ) | ||
); | ); | ||
+ | </ | ||
+ | |||
+ | |||
+ | |||
+ | ==== Space DELTA of a table ==== | ||
+ | Based on AWR tables: | ||
+ | <code sql> | ||
+ | |||
+ | SELECT | ||
+ | h.BEGIN_INTERVAL_TIME | ||
+ | FROM | ||
+ | DBA_OBJECTS o, | ||
+ | DBA_HIST_SNAPSHOT h, | ||
+ | ( | ||
+ | SELECT | ||
+ | SNAP_ID, | ||
+ | TS#, | ||
+ | OBJ#, | ||
+ | SPACE_USED_DELTA | ||
+ | FROM | ||
+ | DBA_HIST_SEG_STAT | ||
+ | where SPACE_USED_DELTA >0 | ||
+ | ) s, | ||
+ | v$tablespace t | ||
+ | WHERE | ||
+ | s.OBJ# = o.OBJECT_ID | ||
+ | AND s.TS# = t.TS# | ||
+ | and | ||
+ | and | ||
+ | and s.SNAP_ID = h.SNAP_ID | ||
+ | ORDER BY | ||
+ | 1 desc | ||
+ | ; | ||
+ | |||
</ | </ | ||
Line 430: | Line 464: | ||
FROM V$ASM_DISK D, V$ASM_DISKGROUP G | FROM V$ASM_DISK D, V$ASM_DISKGROUP G | ||
WHERE D.GROUP_NUMBER=G.GROUP_NUMBER ; | WHERE D.GROUP_NUMBER=G.GROUP_NUMBER ; | ||
- | CLEAR COLUMNS; | + | |
</ | </ | ||