Answer Posted / sawant
The data dictionary cache is stored in an area in SGA called
the Shared SQL Pool. This will allow sharing of parsed
SQL statements among concurrent users.
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
What is the difference between alert log file and tarce file ?
What is primefaces used for?
How to put more than 1000 values into an oracle in clause?
Explain the difference between sql and oracle?
What is oracle update statement with inner join ?
I have a table called 'test' on source and target with same name, structure and data type but in a different column order. How can you setup replication for this table?
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What are a query and state the different types of queries and their uses?
Explain compound trigger in oracle?
How many types of cluster table in Oracle?
What is the order of defining local variables and sub procedures/functions?
is there a tool to trace queries, like profiler for sql server?
Explain the use of compress option in exp command.
How do I escape a reserved word in oracle?
What is the relationship among database, tablespace and data file?