OraFAQ Forum: General » _xpl_peeked_binds_log

Home » Other » General » _xpl_peeked_binds_log_size: what does it mean?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

_xpl_peeked_binds_log_size: what does it mean? [message #184077]

Tue, 25 July 2006 03:54

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

Report message to a moderator

Re: _xpl_peeked_binds_log_size: what does it mean? [message #184964 is a reply to message #184077]

Sat, 29 July 2006 01:52

Frank Naude
Messages: 4590
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

Report message to a moderator

Re: _xpl_peeked_binds_log_size: what does it mean? [message #185178 is a reply to message #184964]

Mon, 31 July 2006 07:06

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.)

Report message to a moderator

Re: _xpl_peeked_binds_log_size: what does it mean? [message #185252 is a reply to message #185178]

Mon, 31 July 2006 14:39

Frank Naude
Messages: 4590
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!

Report message to a moderator

Previous Topic:	Daylight Saving Time
Next Topic:	diff between v$ tables and DBA_ tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 20:32:01 CST 2025