Interested to Buy Any Domain ? << Click Here >> for more details...
What are the factors causing the reparsing of SQL statements
in SGA?
- 2 Answers
- 5297 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
What is transaction control statement and how many types of transaction control statement in Oracle?
How do I start tns listener?
How to create a table index in oracle?
Explain about the analyze command in oracle?
How to select some rows from a table in oracle?
Explain an index segment?
What is a tns file?
Tab A A B ------ 1 A 2 B 3 C Tab B A B ----- 4 D 5 E 6 F Generate the value into B table from A table. Only table A has the value. Write the SQL query to get B table value.
Why do I get java.lang.abstractmethoderror when trying to load a blob in the db?
1) WIll all the user get the DEFAULT profile, if their current profile got deleted at any point of time? 2) What are the Situation we need to MOVE the TABLE between T.spaces? 3) What is the use of MOVING the TABLE between SCHEMA'S? 4) What are the Table Clause, Segment Clause and the Datafile Clause which will override each other? 5) Explain SORT_AREA_SIZE of Tempfile to make UNIFORM SIZE
what are the advantages of running a database in archive log mode?
What are the ways tablespaces can be managed and how do they differ?
Why packages are used in oracle?
What is the data pump export utility?
How to name query output columns in oracle?
