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: Mon Dec 05 09:05:48 CST 2016

Total time taken to generate the page: 0.08375 seconds