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: Index Usage and SQL Tuning Question
Next Topic: other buffer pool .... cache sizes ??
Goto Forum:
  


Current Time: Wed Aug 23 18:26:58 CDT 2017

Total time taken to generate the page: 0.14597 seconds