OraFAQ Forum: Performance Tuning » SQL Sharing Problem (STB_OBJECT

Home » RDBMS Server » Performance Tuning » SQL Sharing Problem (STB_OBJECT_MISMATCH)

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

SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269299]

Fri, 21 September 2007 09:56

hongfei.wang
Messages: 2
Registered: September 2007
Location: Canada

Junior Member

I am doing SQL tuning on a 10g database; and I found a SQL sharing problem. I investigated it from v$sqlarea and v$sql_shared_cursor and found the following problem:

SQL_ID ADDRESS CHILD_ADDRESS CHILD_NUMBER U S O O S L S E B P
------------- ---------------- ---------------- ------------ - - - - - - - - - -
I S T A B D L T R I I R L I O S M U T N F A I T D L D B P C S R P T M B M R O P
- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -
M F L
- - -

at793ypzd07qc 00000005BC96DCA0 00000005BC12B5F8 826 N N N N N N N N N N
N N N N N N N N N N N N N N N N N N N N N N N N N N N N N N Y N N N N N N N N N
N N N

The cursor mismatched reason is STB_OBJECT_MISMATCH - STB object different (now exists). I don't understand it at all; and I don't even know what STB is. Does anybody has better idea? Thanks in advance.

Report message to a moderator

Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269317 is a reply to message #269299]

Fri, 21 September 2007 12:13

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

HUH?
I must be going senile because I have no idea what the question really is.

Please read & follow posting guidelines as stated in #1 STICKY post at the top of this forum.

Report message to a moderator

Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269321 is a reply to message #269317]

Fri, 21 September 2007 12:30

Michel Cadot
Messages: 68658
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Quote:

Please read & follow posting guidelines as stated in #1 STICKY post at the top of this forum.

This IS the better idea. topic solved. Razz

Regards
Michel

Report message to a moderator

Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269324 is a reply to message #269299]

Fri, 21 September 2007 12:36

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

does this help?
http://www.psoug.org/reference/cursor_sharing.html

Report message to a moderator

Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269328 is a reply to message #269324]

Fri, 21 September 2007 13:05

hongfei.wang
Messages: 2
Registered: September 2007
Location: Canada

Junior Member

I understand the SQL sharing investigation process. My question is: What does STB_OBJECT_MISMATCH exactly mean? it's explained as 'STB has come into existence since cursor was compiled', but I don't even know what STB is.

Report message to a moderator

Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269330 is a reply to message #269299]

Fri, 21 September 2007 13:10

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>I don't even know what STB is.
If it makes you feel any better, I can't find a (clear) definition of it either; even on Metalink.

Report message to a moderator

Previous Topic:	0ra-1920
Next Topic:	Variance in -Row Source Generation, Explain Plan and statspack

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri May 31 19:13:23 CDT 2024