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 coalesce sql?

977

What is informix sql?

963

Do foreign keys improve performance?

1007

What is sql resultset?

970

What is use of trigger?

908

What are triggers and its types?

1041

what are different types of collation sensitivity? : Sql dba

1057

What is implicit cursor in pl sql?

1071

what is the difference between union and union all? : Sql dba

1003

What is blind sql injection?

1046

what is transaction? : Sql dba

991

how to drop an existing table in mysql? : Sql dba

1026

what are tables and fields? : Sql dba

1031

What do you think about pl/sql?

1002

What is a primary key? Explain

960