Home » RDBMS Server » Performance Tuning » What is a PIN?
What is a PIN? [message #65137] Sun, 16 May 2004 16:40 Go to next message
IA
Messages: 91
Registered: March 2004
Member
Hi All,

 

I was looking at the performance tuning manual, in particular, the Shared Pool tuning section. The definition of a PIN is:

 

PINS: PIN requests for objects of this namespace

 

What does this really mean? Above definition mentioned "PIN requests". What are PIN requests?

 

Greatly appreciate an answer that is more understandable than the above definition.

 

Thanks .... IA
Re: What is a PIN? [message #65140 is a reply to message #65137] Sun, 16 May 2004 23:35 Go to previous messageGo to next message
Daljit Singh
Messages: 290
Registered: October 2003
Location: Texas
Senior Member
Hi,

GETS & PINS are two types of locks which oracle acquire at the time of parse & execute respectively. PINS basically related to execution, everytime a statement get executed the PINS lock is acquired by the oracle on that statement. In short PINS means total number of executions of statements.

Daljit Singh
Re: What is a PIN? [message #65144 is a reply to message #65140] Mon, 17 May 2004 18:00 Go to previous message
IA
Messages: 91
Registered: March 2004
Member
Hi Daljit,

Thanks very much for your feedback on all my questions.

IA
Previous Topic: Average IO Time
Next Topic: performance
Goto Forum:
  


Current Time: Fri Feb 23 01:06:21 CST 2024