Home » RDBMS Server » Performance Tuning » tools for monitoring the load of the db (oracle 10g )
tools for monitoring the load of the db [message #484867] Fri, 03 December 2010 06:49 Go to next message
crocuta
Messages: 8
Registered: November 2010
Location: muenchen
Junior Member

hi

can anybody give me a hint which tools are avaible for monitoring
load of the database ?

thanks in advance
Re: tools for monitoring the load of the db [message #484869 is a reply to message #484867] Fri, 03 December 2010 07:11 Go to previous messageGo to next message
chris32680
Messages: 92
Registered: January 2006
Location: Charlotte
Member
Enterprise Manager
Re: tools for monitoring the load of the db [message #484907 is a reply to message #484869] Fri, 03 December 2010 13:03 Go to previous messageGo to next message
Littlefoot
Messages: 21806
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Spotlight?
Re: tools for monitoring the load of the db [message #484910 is a reply to message #484907] Fri, 03 December 2010 13:18 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
Your telephone.
Users will call when DB slows down.
Re: tools for monitoring the load of the db [message #559222 is a reply to message #484867] Fri, 29 June 2012 21:24 Go to previous message
alan.kendall@nfl.com
Messages: 163
Registered: June 2012
Location: Culver City, California
Senior Member
I monitor the average buffers processed per minute with the following.
ECSCDAP1P > @dba_hist_seg_stat_AVERAGE_LOGICAL_READS_PER_MINUTE.sql

DATE                 AVG_GIG_PER_MIN
-------------------- ---------------
2012-06-14 Thursday            821.3
2012-06-15 Friday              754.4
2012-06-16 Saturday            683.0
2012-06-17 Sunday              755.7
2012-06-18 Monday              818.2
2012-06-19 Tuesday             779.9
2012-06-20 Wednesday           873.4 Indexes rebuilt and then
2012-06-21 Thursday            369.3 processing falls the next day
2012-06-22 Friday              343.8
2012-06-23 Saturday            322.7
2012-06-24 Sunday              321.7
2012-06-25 Monday              367.4
2012-06-26 Tuesday             356.3
2012-06-27 Wednesday           358.5
2012-06-28 Thursday            334.8

ECSCDAP1P > list
  1  select to_char(c.BEGIN_INTERVAL_TIME,'YYYY-MM-DD Day') "DATE",
  2  sum(b.LOGICAL_READS_DELTA)*8192/1024/1024/1024/60/24 Avg_GIG_PER_min
  3  from dba_objects a,dba_hist_seg_stat b,sys.wRM$_SNAPSHOT c
  4  where a.object_id=b.OBJ#
  5  and c.snap_id=b.snap_id
  6  and c.begin_interval_time > trunc(sysdate-29)
  7  and c.begin_interval_time < trunc(sysdate)
  8  and b.instance_number=c.instance_number
  9  group by to_char(c.BEGIN_INTERVAL_TIME,'YYYY-MM-DD Day')
 10* order by to_char(c.BEGIN_INTERVAL_TIME,'YYYY-MM-DD Day')
Previous Topic: Performance issue
Next Topic: SGA related queries
Goto Forum:
  


Current Time: Thu Mar 28 07:00:42 CDT 2024