-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
Shows a way to find if table was truncated, using object_id, data_object_id one can tell possibly if the table was… READ MORE
Using OPatch with lsinventory and bugs_fixed options one can list the PSU patches installed in ORACLE_HOME Example: localhost:/home/oracle $ $ORACLE_HOME/OPatch/opatch… READ MORE
On AIX ran into the following issue where sqlplus generated the following error when using local connection (bequeath). scott@localhost:/home/scott:$ sqlplus… READ MORE
There are 2 types of DBCC TRACEON (session or global). Session trace is turned on that session only and global… READ MORE
Shows how to flush buffer cache and v$bh, you may only want to do this on Dev or Test enviornment… READ MORE
There are various methods of displaying execution plan. Here is few of them. 1) Using EXPLAIN PLAN and setting STATEMENT_ID… READ MORE
|
By setting the parameter “AUDIT_TRAIL” to “DB” or “OS”, one can enable auditing in the database. To change the value… READ MORE
Compares refreshing materialized view with NOLOGGING 1) Refresh Materialized view with NOLOGGING -- Capture redo size before refreshing materialized view… READ MORE
# Capture amount of redo logs generated when table is created in UNRECOVERABLE SQL> select vs.name, vm.value from v$mystat vm,… READ MORE
Scenario 1) Default transaction using AUTONOMOUS TRANSACTION and checking records in table called APP_LOG at each step. The store procedure… READ MORE
Example of how AUTONOMOUS_TRANSACTION, it allows one to isolate a DML statements, the DML statements with the AUTONOMOUS transaction are… READ MORE
Examples of using “SAVEPOINT” and “ROLLBACK TO” SQL> select * from scott.test; no rows selected SQL> insert into scott.test values… READ MORE
To get the location of SQLServer Agent log file, the log file is called SQLAGENT.out DECLARE @oem_errorlog nvarchar(255) EXECUTE master.dbo.xp_instance_regread… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 