What are the factors causing the reparsing of SQL
statements in SGA?
- 1 Answers
- 3458 Views
- I also Faced
- E-Mail Answers
Answer / 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 |
How to deactivate triggers?
What are the steps involved in Database Shutdown ?
What is the role of tables in database?
Can we pass RECORD GROUP between FORMS ?
What are the components of a database management system?
How does index hunting help in improving query performance?
What are the various Database states.
Write about Transaction Management in Oracle 9i?
Explain the importance of database partitioning.
What is index hunting?
How do you copy a database?
What is a driver in programming?
-
Oracle (3239) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3312)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1391)
- Databases AllOther (288)
