OraFAQ Forum: Performance Tuning » performance tuning

Home » RDBMS Server » Performance Tuning » performance tuning (Oracle rdbms 11gR2 and #statspack)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

performance tuning [message #670855]

Mon, 30 July 2018 03:53

alanm
Messages: 284
Registered: March 2005

Senior Member

discovering the power of oracle statspack.

Available Tags

% of Busy CPU used for Instance:
Block changes:
consistent gets
CPU used by this session
DB time(s):
Physical reads:
Physical writes:
session logical reads

graphical analysis of statspack

Attachment: logical_reads.JPG
(Size: 62.99KB, Downloaded 2387 times)

[Updated on: Mon, 30 July 2018 03:54]

Report message to a moderator

[Message index]

		performance tuning By: alanm on Mon, 30 July 2018 03:53
		Re: performance tuning By: cookiemonster on Mon, 30 July 2018 04:13
		Re: performance tuning By: alanm on Mon, 30 July 2018 04:20
		Re: performance tuning By: Roachcoach on Mon, 30 July 2018 04:37

Previous Topic:	Sql query to get Max,min and max-1 row from a table
Next Topic:	Appropriate join to the desired output

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Apr 26 17:16:33 CDT 2024