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 application trigger?

733

How long does it take to learn pl sql?

792

Can we call dml statement in function?

765

What is user in sql?

761

What is sql comments?

813

What is cold data?

678

Is it possible to update views?

711

how to enter characters as hex numbers? : Sql dba

747

Is progress software supports to ( pl/sql )?

717

What is a native sql query?

701

What is difference between hql and sql?

701

Is pl sql and postgresql same?

767

What are sql indexes?

740

What sql database should I use?

786

What is group function in sql?

750