Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4350 Views
- I also Faced
- E-Mail Answers
Answer / sawant
Due to insufficient Shared SQL pool size.
Monitor the ratio of the reloads takes place while
executing SQL statements. If the ratio is
greater than 1 then increase the SHARED_POOL_SIZE.
| Is This Answer Correct ? | 0 Yes | 0 No |
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?
can a view be updated?
what are views?
Explain the difference between a procedure and a function?
Design database draw er diagram for a certain scenario ?
0 Answers Keane India Ltd, TATA,
What is mean by Program Global Area (PGA) ?
State all possible different index configurations a table can possibly have?
what are pseudocolumns?
Difference between varchar and varchar2 data types?
You have 4 instances running on the same UNIX box. How can you determine which shared memory and semaphores are associated with which instance?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
How a tablespace is related to data files?
Oracle General 
