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 a clob in sql?

969

What are the different operators available in sql?

963

How many subqueries can be nested in a statement?

935

Are views faster than queries?

923

What is offset in sql query?

1073

What is the starting oracle error number? What is meant by forward declaration in functions?

940

give the syntax of grant and revoke commands? : Sql dba

1090

i have some prob lem to tell me about my self in interview first round ...

2116

What is primary key in db?

936

How exception is different from error?

971

Explain how exception handling is done in advance pl/sql?

958

What is snowflake sql?

1013

How do you use a while loop in pl sql?

942

What are the sql versions?

896

What are pl/sql cursors?

991