Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL
statements in SGA?
- 1 Answers
- 4234 Views
- I also Faced
- E-Mail Answers
What are the factors causing the reparsing of SQL
statements in SGA?..
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 |
More Database Management Interview Questions
Can we store images in database?
What do you mean by entity type?
What do you understand by unique key?
What is a candidate key in a database?
What are types of dbms?
Define b-trees.
How do you create a database for an organization?
Why do we need database normalization?
What are the different stages in 'data warehousing'?
What is partial key?
How to schedule ssas database backup
is it sufficient to normalize a database up to 3NF?
Categories
-
Oracle (3253) - SQL Server (4518)
- MS Access (429)
- MySQL (1402)
- Postgre (483)
- Sybase (267)
- DB Architecture (141)
- DB Administration (291)
- DB Development (113)
- SQL PLSQL (3330)
- MongoDB (502)
- IBM Informix (50)
- Neo4j (82)
- InfluxDB (0)
- Apache CouchDB (44)
- Firebird (5)
- Database Management (1411)
- Databases AllOther (288)
