Author: Admin

select c.sid, c.serial#, f.spid as osprocess, c.username, a.object_id, b.object_name, c.program, c.status, d.name, c.osuser, e.sql_text, DBMS_ROWID.ROWID_CREATE(1, c.ROW_WAIT_OBJ#, c.ROW_WAIT_FILE#, c.ROW_WAIT_BLOCK#, c.ROW_WAIT_ROW# ) locked_rowid from v$Locked_object a, All_objects b, v$session c, audit_actions d, v$sqlarea e, v$process f where a.object_id=b.data_object_id and a.session_id =c.sid(+) and c.command=d.action and c.row_wait_obj# != -1 and c.sql_id=e.sql_id and c.paddr = f.addr;

************************************** **** Building Our Own Namespaces ***** ************************************** The USERENV namespace does store extensive information, but the power of SYS_CONTEXT does not stop there. You can also create secured namespaces and store context in them for retrieval within a session or across the instance. For example, if I create a new namespace via the CREATE…

Read More “Building Our Own Namespaces with “Create Context”” »

Note : 1011899.6 – Roles and Creating Stored Objects / Views Note : 180028.1 – Set up a Secure Access to Application Data within a Database: DBAs, Schemas and Users.

========================= Test case On 29-SEP-2005 ========================= Original Statement: INSERT INTO pvm SELECT * FROM pvm1; Source table : pvm1 has 2.3 million rows. If statement executes normally it will take long time to execute. So i modified following statement and 2.3 Million rows processed in Approx 30 seconds. 10:39:11 CIF@CIF:-> set feedback 1 10:39:11 CIF@CIF:->…

Read More “Test Case for Inserting Multiple (2.3 Million rows in 26 Seconds)” »