What is a shared pool?
Answer / nishi
Memory area of oracle which consists of Library cache (recently executed sql and pl/sql statements) and Data Dictionary cache(recently used tables and indexes).
| Is This Answer Correct ? | 0 Yes | 0 No |
It's Urgent? How to IMPORT .xls & .txt file into ORACLE?
When does a Transaction end ?
Explain the use of ignore option in imp command.
Can you assign multiple query result rows to a variable?
What happens if recursive calls get out of control?
WHEN CURSOR MOVES FROM ONE FORM TO ANOTHER FORM, HOW MANY TRIGGER WILL BE FIRED AND WHAT ARE THEIR SEQUENCE?
how can we write trigger in trigger???????? can we write one trigger on two table???
What is the difference between online and offline backups?
What is Private Database Link ?
What are the Limitations of a CHECK Constraint ?
Table Has C1 And C2 Column If Exits any record in c1 then Update c2 record Otherwise insert new record in the C1 And C2 (Using Procedure)
What is system global area (sga) in oracle?