Monthly Archives: November 2013

LIKE operator and Underscore

Performance problem to be expected with LIKE-operator and underscore character being part of the query parameter, see a new example: Assuming absolute majority of peoples are good, some are bad and few are ugly: select * from folks where personality_type … Continue reading

Posted in Uncategorized | Leave a comment

11g slow drop tablespace including contents and…

Slow 11g drop tablespace including contents and datafiles. Cause: Slow select with sql_id 7jrp85khm4tka: select from … INDCOMPART$, I_INDSUBPART_POBJSUBPART$, INDSUBPART$… Solution (looks like it helped): exec dbms_stats.gather_fixed_objects_stats; exec dbms_stats.gather_dictionary_stats; execute dbms_stats.gather_schema_stats(‘SYS’); alter system flush shared_pool; alter system flush shared_pool; alter … Continue reading

Posted in Uncategorized | Leave a comment