Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4432 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 |
3. Display all the client numbers in the ORDER table. Remove duplicates.
How to create a new tablespace in oracle?
How to get a list of all background sessions in the database?
What is the difference between postgresql and oracle?
what is primary key?
What does COMMIT do ?
How can we manage the gap in a primary key column created by a sequence? Ex:a company has empno as primary key generated by a sequence and some employees leaves in between.What is the best way to manage this gap?
what is a cartition product?
What are a cluster and non-cluster index?
How to define a cusotmer as a supplier in ORACLE R12
I have a table emp. There is only one column in the table. In that , there are only three rows in that column. The value in the first row is 'A' and the value in the second row is 'B' and the third row is 'C'. Now, my question is , How will you write a select query to display the output as B C A Note: order by cannot be used coz it gives us output as CBA. But the output should be BCA.
How remove data files before opening a database?
Oracle General 
