Package-> Compiles and stores all the procedures and functions in SGA

What are the advantages of the packages

Question Posted / chandrasekar.ramasamy

Answer Posted / chandrasekar.ramasamy

Package-> Compiles and stores all the procedures and
functions in SGA (System Global Area), so the performance
will be high.

Is This Answer Correct ?

3 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can we rollback delete command?

989

What are sql indexes?

1002

What is the difference between stored procedure and view?

1020

What does inner join mean?

1169

Explain constraints in sql?

1049

What is a database event trigger?

1160

Explain foreign key in sql?

1027

What does rownum mean in sql?

1026

what are dynamic queries in t-sql? : Transact sql

1025

What are literals in sql server?

1171

what is single byte over head in oracle..?

2404

How can you view the errors encountered in a trigger?

962

What does count (*) do in sql?

1016

what is innodb? : Sql dba

1106

how do you tune the slow running queries in oracle db , explain the methodology

2800