Home » RDBMS Server » Performance Tuning » SQL Sharing Problem (STB_OBJECT_MISMATCH)
SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269299] Fri, 21 September 2007 09:56 Go to next message
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.
Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269317 is a reply to message #269299] Fri, 21 September 2007 12:13 Go to previous messageGo to next message
BlackSwan
Messages: 25042
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.
Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269321 is a reply to message #269317] Fri, 21 September 2007 12:30 Go to previous messageGo to next message
Michel Cadot
Messages: 64122
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
Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269324 is a reply to message #269299] Fri, 21 September 2007 12:36 Go to previous messageGo to next message
BlackSwan
Messages: 25042
Registered: January 2009
Location: SoCal
Senior Member
does this help?
http://www.psoug.org/reference/cursor_sharing.html
Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269328 is a reply to message #269324] Fri, 21 September 2007 13:05 Go to previous messageGo to next message
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.
Re: SQL Sharing Problem (STB_OBJECT_MISMATCH) [message #269330 is a reply to message #269299] Fri, 21 September 2007 13:10 Go to previous message
BlackSwan
Messages: 25042
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.
Previous Topic: 0ra-1920
Next Topic: Variance in -Row Source Generation, Explain Plan and statspack
Goto Forum:
  


Current Time: Wed Dec 07 05:00:56 CST 2016

Total time taken to generate the page: 0.10907 seconds