?
Solved

what is a descendant sub program? might be simple, but like to accurate meaning.

Posted on 2011-10-16
7
Medium Priority
?
417 Views
Last Modified: 2013-11-11
what is a descendant program? might be simple, but like to accurate meaning.
0
Comment
Question by:sakthikumar
  • 3
  • 2
5 Comments
 
LVL 7

Expert Comment

by:Jacobfw
ID: 36975856
I have not heard this term before.  Maybe you can provide the context and/or source that you found this reference.  It may just be another term for one more commonly used.
0
 

Author Comment

by:sakthikumar
ID: 36977516
I find it in the below definition of sub tree elapsed time.
I find this in the hierarchical profiler.


subtree_elapsed_time : Elapsed time in micorseconds, for
                        subordinate tree program, excluding time
                        spent in descesendant sub programs.
0
 
LVL 7

Accepted Solution

by:
Jacobfw earned 1500 total points
ID: 36977555
Sub Program - program code that is child of the current procedure
Decendent Sub Progrm - any grand child program code of the current procedure to possibly many levels of depth.

In this context, the subtree elapsed time only included down from the current procedure and does not included time spent in grand-child and grand-grand-child routines.
0
 

Author Comment

by:sakthikumar
ID: 36987842
suppose for eg:

create procedure process1 is
begin
process2;
end;

begin
process1;
end;

In the above, which is subprogram, descendant sub program.?
0
 

Author Closing Comment

by:sakthikumar
ID: 37099580
requested for attention, but no response from any one.
0

Featured Post

Transaction-level recovery for Oracle database

Veeam Explore for Oracle delivers low RTOs and RPOs with agentless transaction log backup and transaction-level recovery of Oracle databases. You can restore the database to a precise point in time, even to a specific transaction.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

How to Create User-Defined Aggregates in Oracle Before we begin creating these things, what are user-defined aggregates?  They are a feature introduced in Oracle 9i that allows a developer to create his or her own functions like "SUM", "AVG", and…
Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Suggested Courses

862 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question