adspace


  1. Categories >> Software >> Databases >> Oracle >> Oracle General
  2. Suggest New Category

What are the factors causing the reparsing of SQL statements
in SGA?

Question Posted / sawant

Answer Posted / sawant

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 ?    1 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to write a left outer join with the where clause in oracle?

1156

How to select all columns of all rows from a table in oracle?

1132

Please send me Informatica 8.1 certification dumps, my mail id mona85gupta@gmail.com

1956

What is oracle latest version?

1174

How to start an oracle instance?

1103

How to use values from other tables in update statements using oracle?

1158

Design database draw er diagram for a certain scenario ?

4656

How to put more than 1000 values into an oracle in clause?

1115