Type your summary here Suppose you have a table X with the following data and you want to search for a particular string in its columns. SQL...

Trying to get answer for this from Gurus like Thomas Kyte and Jonathan Lewis. SHARED POOL LATCHING in LIBRARY CACHE. Why is it bad? Shared p...

What to do if the hotbackup database crashes during the hotbackup? When this happens the tablespaces are going to be in an inconsistent stat...

Use DBMS_STATS to gather Oracle dictionary statistics. DBMS_STATS is the preferred and recommended method as it is more complete that the AN...

Find the partition with the maximum HIGH_VALUE and see if you need to add new RANGE partitions which use date partitioning. I hear Oracle 1...