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 are the functions of rdbms?
What is the first step in creating a database?
Define view, sequence and index in DBMS.
What are the limitations of rdbms?
Describe concurrency control.
What is the most used database?
Explain different types of Views ?
5 Answers HCL, Inbound Solutions,
How do you link a spreadsheet to a website?
Is sql a database?
Does google have a database program?
What methods is used to commit the changes made in DataSet object?
0 Answers Petranics Solutions,
What do you understand by sub-queries in sql?
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)