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 |
How to use in conditions in oracle?
1.What is inline function in oracle and its purpose? 2.What is the equivalent operator for "different from pattern" in oracle? 3. If you define a variable in oracle, how it will be available? [a. Until database shut down b. Until table deleted c. until session get expired]
How to load a large xml file?
which clause we are not used in where clause?
What is the relation of a user account and a schema in oracle?
What is BBED in Oracle?
What do you mean by merge in oracle?
what is the syntax of DROP command?
Whats the benefit of dbms_stats over analyze?
How many types of synonyms in Oracle?
What is the function of Redo Log ?
What is an oracle user role?