Monday, February 24, 2014

How to enable block change tracking for faster incremental backups:

›
From Oracle 10g and onwards, you can enable block change tracking to speed up incremental backups. In short, "if change tracking is e...
Thursday, February 13, 2014

SQL: view memory parameter

›
set lines 200 set pages 100 col name format a30 col value format a40 select name from v$database / select name, value/1024/1024 "...

An easy way to find DML locks

›
The view DBA_DML_LOCKS is a convenient view to use if you want to identify locks caused by uncommited DML statements. Consider the follow...
Wednesday, February 12, 2014

How to work around ORA-14080: partition cannot be split along the specified high bound

›
Problem: My table had partitions for Jan 2014 and March 2014. Any attempt to split the overflow partition at this point will throw the err...

ORA-39726: unsupported add/drop column operation on compressed tables when attempting to drop column on a (previously) compressed table

›
My customer had a partitioned table that was previously compressed with FOR ALL OPERATIONS options. One of the developers wanted to drop a ...
Monday, February 10, 2014

Working with TIME ZONE information

›
To view the time zone settings for the database and your session: SELECT DBTIMEZONE, SESSIONTIMEZONE FROM DUAL; DBTIMEZONE SESSION...
Thursday, February 6, 2014

Which privileges are needed to execute DBMS_REDEFINITION package?

›
Execute privileges on the DBMS_REDEFINITION package are granted to EXECUTE_CATALOG_ROLE. In addition to having execute privileges on this ...