keeping the pl/sql blocks in keep pool in sga that is called pinning of p

How to improve the performance of a pl/sq stored procedures
or functions or triggers and packages ?

Question Posted / shakir

Answer Posted / shakir

keeping the pl/sql blocks in keep pool in sga that is
called pinning of packages

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

what is cross join? : Sql dba

1008

what are tables and fields? : Sql dba

1067

What is the usage of the distinct keyword?

1228

How can we store rows in PL/SQL using array?

1230

What is a data definition language?

1152

What are sql constraints?

1187

Is inner join same as self join?

1128

What is the primary use of normalization?

1020

Is sql database free?

987

What does the acronym acid stand for in database management?

1046

What is the difference between clustered and non-clustered index in sql?

1021

How do I restart sql?

981

What is a primary key? Explain

991

what are aggregate and scalar functions? : Sql dba

1068

What is the use of %rowtype?

1050