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 |
What is a data type in a database?
What is concurrency control?
What is the difference between SQL and NoSQL databases
what do u mean by canvases and alerts?
What are databases what are the uses of databases?
What is correlated subquery in dbms?
What is metadata and why should I use it?
Is there some bulk load or other way to import a lot of data fast?
How to unzip a file in ssis?
How do queries work in a database?
Why is data modelling important?
What is 1nf?
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)