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 |
Is google a database?
What is a logical backup ?
Can we use GO_BLOCK package in a PRE_TEXT_ITEM trigger ?
10 How to Handle Data Migration Between Different Databases?
Why do we need database management?
Explain the term entity set in dbms?
State at least four kinds of indexing?
How to Optimize Database Queries for Performance?
What are the objectives of rdbms?
What is a concurrency problem in dbms?
which is the best institute to learn Oracle DBA 10g/11g, please advise, someone?
What are 3 types of databases?
Oracle (3259)
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)