Answer Posted / rashid ansari
shared pool contain data dictionary and library
cache.oracle make a execution plan into sheared pool
| Is This Answer Correct ? | 1 Yes | 2 No |
Post New Answer View All Answers
What is save point in oracle database?
When do you get a .pll extension in oracle?
How to loop through a cursor variable?
What are ddl statements in oracle?
How to work with data objects interactively?
Explain the use of log option in exp command.
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How can I see all tables in oracle?
How to call a stored function in oracle?
Which is better Oracle or MS SQL? Why?
What are the built-in functions used for sending Parameters to forms ?
What are the execution control statements?
How to start instance with a minimal initialization parameter file?
What are the differences between date and timestamp in oracle?
What is Undo Management Advisor in Oracle?