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

Can we use view in stored procedure?

523

Is oracle and sql same?

584

What is AUTH_ID and AUTH_USER in pl/sql ?

1705

What are the sql aggregate functions?

614

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

573

What are the 3 modes of parameter?

692

what is the difference between blob and text? : Sql dba

540

What is trigger in pl sql with examples?

529

how many groups of data types? : Sql dba

578

what is a control file ? : Sql dba

590

How many types of functions are there in sql?

513

what are the differences between public, private, protected, static, transient, final and volatile? : Sql dba

565

Mention what are different methods to trace the pl/sql code?

570

Is sql open source?

553

Explain the uses of database trigger.

666