Interested to Buy Any Domain ? << Click Here >> for more details...
In packages the source code is compiled into p code ? how
do we describe the p code
- 3 Answers
- 7126 Views
- I also Faced
- E-Mail Answers
Answer Posted / swapna
After compiling procedures,functions and triggers(in new
versions only),Those will be stored in the form of p-code
(after parsing) in SGA(System Global Area).
The advantage of p-code is Since it was there in SGA which
can be shared by all,Whenever you execute procedure or
function,It won't be recompiled.It uses already compiled p-
code.So,time can be saved.
| Is This Answer Correct ? | 2 Yes | 0 No |
Post New Answer View All Answers
What information is needed to connect sql*plus an oracle server?
What are its different types of dbms?
Is a view faster than a stored procedure?
How do I start sql profiler?
What is the use of prepared statement?
Why do we use view in sql?
what is log shipping? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
explain the delete statements in sql
What is Histogram?
Explain what is an index?
what are sequences
Can we use commit inside a trigger?
What is benefit of creating memory optimized table?
why does the selected column have to be in the group by clause or part of an aggregate function? : Sql dba
