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 linq to sql?

1178

how to enter numeric values as hex numbers? : Sql dba

1100

Can you sum a count in sql?

1059

How to place comments in pl/sql?

1215

Are null values same as that of zero or a blank space?

1065

How do you delete duplicates in sql query using rowid?

989

What is java sql driver?

1182

What are pl sql data types?

1056

what is the difference between mysql_fetch_array and mysql_fetch_object? : Sql dba

1123

what are tables and fields? : Sql dba

1103

Can we edit a view in sql?

1041

Can a foreign key be a duplicate?

962

What is snowflake sql?

1127

How long does it take to learn pl sql?

1104

what are the disadvantages of mysql? : Sql dba

1208