Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4496 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 |
is there a tool to trace queries, like profiler for sql server?
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
What is open database communication (odbc) in oracle?
How do I decide when to use right joins/left joins or inner joins or how to determine which table is on which side?
How to get a list of all user accounts in the database?
Differentiate the standard purchase order,Blanket purchase agreement,Contract purchase agreement,Planned purchase order?
Why is oracle so popular?
How to sort output in descending order in oracle?
What is Library Cache in Oracle?
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
What is oracle server autotrace in oracle?
i can create a view with two columns from emp table,, later i need to add one more emp column to existing view.. what is query similarly add one more column to existing primary key constraint.. please give me the solutions
Oracle General 
