Home » RDBMS Server » Performance Tuning » AWR Service Stats
AWR Service Stats [message #344058] Thu, 28 August 2008 12:49 Go to next message
lunaut
Messages: 6
Registered: July 2008
Junior Member
I am comparing two AWR reports, one from a bad period, and another from a good one. In the Service Statistics section, I saw the Physical Reads of SYS$BACKGROUND service in the bad day is 5 times of that of the good day. I wish to find
1) What users sessions are in SYS$BACKGROUND service?
2) What they are doing at that time?

Can any one help?

Thanks
Re: AWR Service Stats [message #344063 is a reply to message #344058] Thu, 28 August 2008 12:54 Go to previous message
Michel Cadot
Messages: 64151
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/create.htm#sthref468

Regards
Michel
Previous Topic: 10g Database Performance
Next Topic: memory in statspack
Goto Forum:
  


Current Time: Fri Dec 09 17:42:59 CST 2016

Total time taken to generate the page: 0.20586 seconds