Home » RDBMS Server » Performance Tuning » shared pool, invalidations and creation indexes ??
shared pool, invalidations and creation indexes ?? [message #191721] Thu, 07 September 2006 22:42
tridentadm
Messages: 142
Registered: March 2006
Senior Member
Reloads to Pins > 1% for shared Pool

if not then 'Shared Parsed areas are Invalidated'

and suggested solution is to 'Create Indexes'

I read this in Ora9i Perf Tuning Book.

Can someone give me why the suggested solution is to 'Create Indexes'
Previous Topic: ORA-01652 - Temporary Tablespace problems!!
Next Topic: column to look for in v$system_event
Goto Forum:
  


Current Time: Wed Dec 04 17:59:09 CST 2024