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

2 Answers
5436 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 ?

1 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How to install oracle database 10g xe?

1020

What are the components of logical database structure in oracle database?

1088

What is Virtual Private Database in Oracle?

1091

What is a dynamic performance view in oracle?

994

What is recovery manager(rman) backup in Oracle?

1185

Is it possible to insert comments into sql statements return in the data model editor ?

2567

How to create an oracle testing table?

1071

What are the restrictions in a oracle read only transaction?

1038

What is a proxy object?

1068

what are the default admin accounts in Oracle 10g ?

970

What is oracle used for?

1026

Give the various exception types.

995

How to use like conditions in oracle?

1058

Why do you use stored procedures and state some of its disadvantages?

1028

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

1865