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

Is sqlexception checked or unchecked?

972

How do you update a value in sql?

1047

What is difference between table and view?

1063

What is oracle sql developer?

1062

The in operator may be used if you know the exact value you want to return for at least one of the columns.

1136

what is a tablespace? : Sql dba

1057

what is the difference between sql and t-sql? : Transact sql

1089

Why do we use function in pl sql?

1065

What is file based approach?

945

how to calculate the difference between two dates? : Sql dba

1064

Explain what is table in a database?

1062

How do you run a query?

995

How do I use google cloud in sql?

1093

Can sql function call stored procedure?

1025

How do I save a stored procedure?

1011