What are the factors causing the reparsing of SQL statements
in SGA?
Answer / 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 |
How to sort the query output in oracle?
What are inner join and outer join?
What are main difference between Stored Procedure and Functions.
What is redo log?
How to recover a dropped index?
how to insert data into partitioned table partition done by Range partition
One Table having two rows with one colomn having values Like"Male" and "Female". how to upadte these values Like "Female" and "Male" in single update statement.
How many categories of data types?
What is execute immediate in oracle?
i have a question here... As of my knowledge, when we apply an index (b-tree)on a column, internally it arranges the data in b-tree format and do the fetching process correspondingly... and my quetion is... How a bit-map index arranges the data internally when applied on a column?IS it in b-tree format or whatelse?
What does `(+)` do in a where clause?
What is the difference between SQL and SQL Server?