What are the factors causing the reparsing of SQL statements
in SGA?
Answers were Sorted based on User's Feedback
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 ? | 1 Yes | 0 No |
Answer / nishi
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 are the database links ?
what is difference between DBMS and RDBMS?
What is the maximum number of triggers that can be applied to a single table?
SELECT * FROM (SELECT TITLE FROM MOVIE ORDER BY RANK DESC) WHERE ROWNUM > 4; when i run the above query .it produces output as NO ROWS SELECTED.why ?plz any one help me
how table is defined in plsql table? how can i select column from plsql table? can i use select * from plsql table type?
what happened to the global index when I truncate the data in one of the partition?
What is the difference difference between $ORACLE_HOME and $ORACLE_BASE.
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
write a query that displays every Friday in a year with date?
What are the components of Physical database structure of Oracle Database?
Explain what are clusters?
What privilege is needed for a user to create tables in oracle?