Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 1 Answers
- 4316 Views
- I also Faced
- E-Mail Answers
Answer Posted / 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 |
Post New Answer View All Answers
How to view all columns in an existing table?
What is using clause and give example?
What privilege is needed for a user to delete rows from tables in another schema?
What are the various types of snapshots ?
What is a nvl function?
Explain oracle insert into command?
What is a snapshot log?
Can we store images in oracle database?
What is the maximum limit on the number of columns in a table?
HI Friends Myself Manoj,i am from bengaluru.i have 1 yr of exp in PLSQL but not upto the mark..now attending interviews but m not able to clear even 1 round..i have attended 3 interviews till today.purpose of writing this query is,i want to know the intreview topics that interviewer going to ask frequently,mainly SCENARIO based questions.IF anybody have any PLSQL projects please give it to me,it will helps me alot.Thanks for your patience.
What is the data type of dual table?
Explain the characteristics of oracle dba?
How many types of tables supported by oracle?
Is there any way to find out when one specific table/view/M-view is used last time. i.e. when one specific object is used in any SELECT statement.
How to start a new transaction in oracle?
