Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL
statements in SGA?
- 1 Answers
- 4081 Views
- I also Faced
- E-Mail Answers
Answer Posted / guest
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
Which database server is best?
What do you understand by fragmentation?
Which is fastest database?
What are its two major subsystems of r?
1.If we have a Salary coloumn in Staff entity with this description the salary must be monetary and >=$35450.00, how we can write it in into schemain SQL? 2. If we have Weight and Marks in Assessment entity and the Weight has the description of this it must be Non-zero percentage. And also the Marks attribute stores the maximum possible raw mark for assessment (e.g., 30), while Weight stores of the weight of this assessment for the paper as a whole (e.g., 10%). If Marks is not specified, then Weight is used for both. How we can convert this into schema in SQL????
Is driver a software?
Is there a database program for mac?
How do you create a blank database?
How easy is netlib to use?
What is the purpose of a model?
What are databases what are the uses of databases?
What is built_in Subprogram ?
What is a checkpoint in dbms?
What are vdl and sdl?
What are the two types of indexes and explain them in detail? Or what's the difference between clustered and non-clustered indexes?
