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

Why is theta join required?

668

What is nosql example?

585

What can you do with pl sql?

569

Can we connect to postgresql using sql developer?

490

what is offset-fetch filter in tsql? : Transact sql

539

Is sql a backend language?

625

What is pl sql code?

593

What is pl sql in dbms?

508

What is bulk collect in pl sql?

535

What is query execution plan in sql?

571

How many types of literals are available in pl sql?

520

what is sql? : Sql dba

557

What is sql table?

524

What is pl/sql table? Why is it used?

562

What does select count (*) mean in sql?

555