Re: GETS vs. PINS

From: DNP <High.Flight_at_btinternet.com>
Date: 2000/05/11
Message-ID: <391A054D.4C01@btinternet.com>#1/1

Welcome to the world of performace tuning!

v$library cache is the relevant dyn. perf. view here.

If you look at v$librarycache, GETS means ''potential parsings of SQL statements' , GETHITS means 'realised that this SQL has been parsed already' , PINS means 'ok - this SQL was parsed before but is it actually still in the shared pool or has it been aged out'.

Lastly PINHITS means 'yes the parsed form was still in the shared SQL area'.

So high GETHITRATIO means good reuse of SQL per se, and high PINHITRAIO means that most of the parsed SQL is managing to stay in the shared pool section of the SGA.

David P.

Oracle Certified DBA.

Received on Thu May 11 2000 - 00:00:00 CDT