Home » Other » General » _xpl_peeked_binds_log_size: what does it mean?
_xpl_peeked_binds_log_size: what does it mean? [message #184077] Tue, 25 July 2006 03:54 Go to next message
orafaqer
Messages: 48
Registered: July 2006
Member
Good day everybody.
Parameter description
Can you explain me parameter semantics? thoughts, links, test cases are welcome Smile
Re: _xpl_peeked_binds_log_size: what does it mean? [message #184964 is a reply to message #184077] Sat, 29 July 2006 01:52 Go to previous messageGo to next message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
Well, this is an undocumented parameter. So, who knows? Here is my guess:

xpl = Explain Plan
peeked binds = bind variables collected from from SQL statements
log size = size of memory area in bytes
Re: _xpl_peeked_binds_log_size: what does it mean? [message #185178 is a reply to message #184964] Mon, 31 July 2006 07:06 Go to previous messageGo to next message
orafaqer
Messages: 48
Registered: July 2006
Member
Frank, thanks.
I couldn't guess about eXplain PLan. Maybe you're right. The only thing that confuse me is "explain plan does not peek at the bind variable" (c) Wolfgang Breitling
It's very interesting if I am able (or not) to see peeked bind variables (in views, fixed tables etc.)
Re: _xpl_peeked_binds_log_size: what does it mean? [message #185252 is a reply to message #185178] Mon, 31 July 2006 14:39 Go to previous message
Frank Naude
Messages: 4502
Registered: April 1998
Senior Member
This parameter is only available from Oracle 10.2.0 - your Oracle 9i document is not going to help a lot.

Looks like Oracle will support this in future. Who knows, maybe it will be a new feature of Oracle 11g!
Previous Topic: Daylight Saving Time
Next Topic: diff between v$ tables and DBA_ tables
Goto Forum:
  


Current Time: Sun Dec 04 10:44:35 CST 2016

Total time taken to generate the page: 0.10797 seconds