I've looked through the recent posts in this thread and I'm not sure what your latest question is.
VERY STRAIGHT QUESTION
Every SQL statement having parent cursor - If so ,
1. where can i trace all information about parent cursor for specific SQL statement ??
I tried with v$sqlarea - Nothing is there
" i never asked about what is curosr or difference between child cursor or parent cursor "
Thanks for this link.
I think , is my question not clear ?
What information are you looking for? The SQL statement should be in v$sql (unless it aged out)
what i know , " Parent cursor having sql_id , text of the sql statement " for specific sql statement.
>> Example : Here i can check some details for child_cursor >>
HR>SELECT SQL_ID , HASH_VALUE , CHILD_NUMBER , CHILD_ADDRESS , optimizer_mode , sql_text from v$sql where sql_text='select * from tab1 where no=1';
SQL_ID HASH_VALUE CHILD_NUMBER CHILD_AD OPTIMIZER_ SQL_TEXT
1bf26hh7fsa46 250357894 0 2D66EA0C ALL_ROWS select * from tab1 where no=1
1bf26hh7fsa46 250357894 1 2D673D50 ALL_ROWS select * from tab1 where no=1
Ques : Please see above red marked , can i get any information for parent_cursor ( like above mentioned example) ?
Thanks !!! - this is my only question ! that's it !
@someoneElse , @sb
I'm sorry for confusing forum volunteers .
okay , now i can understand. actually i misunderstood concept but Tom explained well : " Ask Tom &quot;What is a child cursor&quot; "
SQL_ID HASH_VALUE CHILD_NUMBER
1bf26hh7fsa46 250357894 0 <<< this IS the parent
1bf26hh7fsa46 250357894 1
Actually column_name IS "CHILD_NUMBER" - I considered both are child for "someone". so i was trying to find where is original_parent !
Is this answer : " 0 is always indicates parent cursor " followers are child !
If it is wrong please reply , ( right -please leave it ! )
Thanks SomeoneElse , sb , jgarry and all ;
@ SomeoneElse , @sb
If existing children can’t be reused (e.g. because of different size of bind variables, or because of different optimizer settings, or because of different NLS setting etc.),
there will be “HARD PARSE”
" because of different size of bind variables" - what does it mean ?
i saw some examples for bind variables - it's ok ! different size of bin variables - cant predict it , please clarify ..