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 are the ansi data types supported in oracle?
normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
Can a formula column referred to columns in higher group ?
What the is the diff between local index and global index. give some example.
What is oracle join syntax?
What are the predefined tablespaces in a database?
What are the common oracle dba tasks?
When do we use group by clause in a sql query?
What is the order of defining local variables and sub procedures/functions?
What are the ways tablespaces can be managed and how do they differ?
Explain the features of oracle?
How translate command is different from replace?
Explain the difference between a procedure and a function? What do you understand by those terms?
How to view the tablespaces in the current database?