Experience: is what you get soon after you need it.

Experience: is what you get soon after you need it.

****************I am authoring a Book on Oracle Database Cloud Services.......More details to follow.***************

Title : Oracle Database Cloud Revealed
Publisher : Apress
Release Date : June-2018


Rasul Allah (sal Allahu alaihi wa sallam) said: "Restore the trusts of those who trust you, and deal not falsely with him who deals falsely with you." [Abu Dawud, Tirmidhi]

I am certified Oracle Cloud Architect:
Oracle Cloud Infrastructure 2018 Certified Architect Associate
Oracle Cloud Infrastructure Classic 2018 Certified Architect Associate

Search This Blog

Friday, June 25, 2010

Monitor Table Usage

I used the below query to get the total physical reads/write by day:

select distinct
to_char(begin_interval_time,'mm/dd') c1,
sum(physical_reads_total) reads,
sum(physical_writes_total) writes
dba_hist_seg_stat s,
dba_hist_seg_stat_obj o
,dba_hist_snapshot sn
o.owner = 'SIEBEL'
s.obj# = o.obj#
sn.snap_id = s.snap_id
object_name = 'S_DOCK_TXN_LOG'
group by to_char(begin_interval_time,'mm/dd')
order by 1;

No comments: