#DBA_HIST_SEG_STAT可以看出对象的使用趋势, construct the following SQL query to increase the amount of database objects in each time period, where Db_block_changes_delta is the number of blocksSelectc.snap_id, To_char (C.end_interval_time,'YYYY-MM-DD') Snap_time, A.owner, a.object_name, A.object_type, B.db_block_changes_delta fromdba_objects A, (Selectsnap_id, obj#, Db_block_changes_delta fromDba_hist_seg_statwhereDb_block_changes_delta> 20000 Order bysnap_iddesc, Db_block_changes_deltadesc) b, Dba_hist_snapshot cwhereA.object_id =b.obj# andObject_type= 'TABLE' andb.snap_id=c.snap_idOrder byDb_block_changes_delta #下面的SQL查询出某个时间段内, database object changes in size, units to convert to GBSelectA.object_name, To_char (C.end_interval_time,'YYYY-MM-DD') Snap_time,sum(B.db_block_changes_delta)/ 1024x768 / 1024x768GB fromdba_objects A, (Selectsnap_id, obj#, Db_block_changes_delta fromDba_hist_seg_statwhereDb_block_changes_delta> 20000 Order bysnap_iddesc, Db_block_changes_deltadesc) b, Dba_hist_snapshot cwhereA.object_id =b.obj# andObject_type= 'TABLE' andb.snap_id=c.snap_idGroup byA.object_name, C.end_interval_timeOrder byGB
A brief introduction to the next Dba_hist_seg_stat. The Dba_hist_seg_stat view records the changes in the segment since the database instance was started, and the data for that view is from V$segstat Column Datatype NULL Description snap_id number Unique Snapshot ID DBID number Database ID for the snapshot instance_number number INSTANCE number for the SNAPSH OT ts# number tablespace number obj# number Dictionary object number dataobj# number Data object n Umber logical_reads_total Number Cumulative value for LOGICAL READS logical_reads_delta number DELTA value For logical reads Buffer_busy_waits_total number cumulative value for BUFFER BUSY WAITS Buffer_busy_waits_delta Number Delta value for buffer busy waits Db_block_changes_total number cumulative value in DB BLOCK change s Db_block_changes_delta number DELTA value for DB BLOCK changes physical_reads_total number cumulative VA Lue for physical reads Physical_reads_delta number DELTA value for physical reads Physical_writes_total number Cumulative value for physical writes Physical_writes_delta number DELTA value for physical writes Physical_r Eads_direct_total number cumulative value for physical reads DIRECT physical_reads_direct_delta number Delt A value for physical reads direct physical_writes_direct_total number cumulative value for physical writes direct Physical_writes_direct_delta number DELTA value for physical writes DIRECT itl_waits_total number Cumulati ve value for ITL waits Itl_waits_delta number DELTA value for ITL waits row_lock_waits_total number Cumula tive value for row lock waits Row_lock_waits_delta number DELTA value for row lock waits Gc_cr_blocks_served_tota L number cumulative value for global cache CR blocks served Gc_cr_blocks_served_delta number DELTA value fo R Global Cache CR blocks served gc_cu_blocks_served_total number cumulative value for global cache current blocks Served Gc_cu_blocks_serVed_delta number DELTA value for global cache current blocks served gc_buffer_busy_total number cumulative Value for global cache buffer busy Gc_buffer_busy_delta number DELTA value for global cache buffer busy Gc_cr_blo Cks_received_total number cumulative value for global cache CR blocks RECEIVED Gc_cr_blocks_received_delta Numbe R Delta value for global cache CR blocks received gc_cu_blocks_received_total number cumulative value for Glo Bal cache Current Blocks received Gc_cu_blocks_received_delta number DELTA value to global cache current blocks R eceived space_used_total Number Cumulative value for SPACE used Space_used_delta number DELTA value for SP Ace used space_allocated_total number cumulative value for SPACE allocated Space_allocated_delta number De LTA value for space allocated table_scans_total number cumulative value for TABLE SCANS Table_scans_delta Numbe R Delta value for tAble Scans
Oracle Table change Trend tracking record