What are the factors causing the reparsing of SQL statements
in SGA?
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 |
How to add a new column to an existing table in oracle?
How to convert a date to char in oracle? Give one example.
What is the meaning of recursive hints in oracle?
1) Does oracle have any table which contain all the exceptions and it's code internally?
How to increment dates by 1 in oracle?
Explain 1st, 2nd, 3rd normalization form of data base
when we are importing items in inventory, showing errors, Oracle support suggested us for running scripts & also suggested if we run scripts, iprocurement applicaation if is there it will show shared and if we go in future for iprocurement, it wont work. So kinldy suggest any functional solution.
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
how to retrieve daily sal from emp table in oracle 10g
Given two table employee and department EMP ---------------- empid deptid(fk) Dept --------------------- deptid(pk) deptname que-Write a query to find count of employee in each department. Expected Output- deptid countofEmployee --------------------------- 10 57 20 20 30 15
what is Single Byte Overhead...?
What is the cache hit ratio, what impact does it have on performance of an Oracle database and what is involved in tuning it?