Home » RDBMS Server » Server Administration » Child cursor
Child cursor [message #145187] Tue, 01 November 2005 11:27 Go to next message
troglodita2
Messages: 2
Registered: November 2005
Junior Member
In Oracle 9i Documentation, the column v$sqlarea.EXECUTIONS is defined as "Total number of executions, totalled over all the cursors", but what is a "child cursor" ?, when is generated ?.
Regards,
Troglo

Report message to a moderator

Re: Child cursor [message #145216 is a reply to message #145187] Tue, 01 November 2005 14:33 Go to previous message
mchadder
Messages: 224
Registered: May 2005
Location: UK
Senior Member
Hello.

Child cursors are best explained by an Tom Kyte example, specifically :

http://asktom.oracle.com/pls/ask/f?p=4950:8:16962785035435583605::NO::F4950_P8_DISPLAYID,F4950_P8_CRITERIA:9497064796920

Regards

Report message to a moderator

Previous Topic: Databases on solaris
Next Topic: recompile oracle binaries
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 10 12:24:25 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.