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
- 6947 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 is the difference between join and natural join?
what is the difference between $message and $$message? : Sql dba
Do we need to rebuild index after truncate?
what is oltp (online transaction processing)? : Sql dba
How do you write a complex sql query?
What are pl sql procedures?
What is clustered index in sql?
What is cte sql?
Which is faster truncate or drop?
how to escape special characters in sql statements? : Sql dba
What is difference between group by and partition by?
What is sql key?
What is rank () in sql?
what is the difference between where clause and having clause? : Sql dba
What is optimistic concurrency control? : Transact sql
