Due to insufficient Shared SQL pool size. Monitor the ratio of the

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

Question Posted / sawant

1 Answers
4489 Views
I also Faced
E-Mail Answers

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 ?

0 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What is MTTR advisor in Oracle?

1142

Please explain compound trigger in oracle?

1111

What is Virtual Private Database in Oracle?

1151

Please explain joins in oracle?

1108

How to get last row id?

1058

What are the advantages of oracle?

1072

What are data pump export and import modes?

1113

How to unlock the sample user account in oracle?

1079

src name sex a,male b,female c,male d,female Required output : male female a,b c,d tried pivot but was not successfull select * from src pivot (max(name) for sex in ('MALE','FEMALE'));

1748

What are the differences between number and binary_float in oracle?

1150

How to connect asp pages to oracle servers?

1122

How to end the current transaction in oracle?

1072

What is the relationship among database, tablespace and data file?

1039

How to convert characters to dates in oracle?

1152

What is meant by joins?

1110