Dropping account by itself while still connected?
I will connect as myself and then drop myself from the same session: -sh-3.2$ sqlplus miladin/xxxxx SQL*Plus: Release 11.1.0.6.0 – Production on Tue Jan 13 17:23:53 2009 Copyright (c) 1982, 2007, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 – 64bit Production With the Partitioning, Real Application Clusters, Oracle Label … Read more
Supported Backup, Restore and Recovery Operations using Third Party Snapshot Technologies
I live in Florida and there are many hurricanes every year.. So disaster recovery is important topic for me.And there is constant battle between Unix/Linux team or Storage team ( Storage Farmers ) and DBA’s when comes to restoring and recovering.Some company split tasks. Backup and restoring are part of a Unix/Linux team or farmers … Read more
Capturing binds.
Capturing bind information using v$sql_bind_capture, v$sql_bind_metadata Starting with 10g view v$sql_bind_capture displays bind variable metadata and values for a SQL cursor . Suppose to be faster than sql_trace or event 10046 at level 4 Demo: SQL> var test number SQL> exec :test :=10 PL/SQL procedure successfully completed. SQL> select * from scott.emp where deptno=:test; … Read more
Change on firing order on before trigger and FK delete cascade in 11g
Order of execution for 10g : Child trigger fire before master trigger. Order of execution for 11g: Master trigger fire before Child. According to Oracle starting with version 8.1 they collect all before statement triggers and fire before DML for all tables involved with delete with cascade.Order of execution is undefined .Same for multiple triggers on … Read more
