| What is a PIN? [message #65137] |
Sun, 16 May 2004 16:40  |
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  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
