Home » RDBMS Server » Server Administration » Performance tuning
Performance tuning [message #52044] Thu, 27 June 2002 23:12 Go to next message
krishna
Messages: 141
Registered: October 1998
Senior Member
What are the tips for tuning
a)Shared pool
b)sort area size
c)data buffers
d)

Report message to a moderator

Re: Performance tuning [message #52095 is a reply to message #52044] Tue, 02 July 2002 06:29 Go to previous message
B
Messages: 327
Registered: August 1999
Senior Member
Depends on your objectives...
DB_BLOCK ... see physical reads, consistent gets and db block get ( v$systat )
SHARED POOL see Gets and misses ( v$row_cache and v$library_cache )
SORT AREA see sort ( disk ) and sort ( memory ) ( v$sysstat )

Report message to a moderator

Previous Topic: rollback segment for compute statistics
Next Topic: Automatic Process for Pinning Packages under WinNT/2K
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu Sep 19 13:47:53 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.