Skip to content

Oracle – Dataguard, set flashback ON|OFF

It may be required to set flashback off temporarily – To remove flashback log files to gain space in the flash recovery area – To import schemas without generating flashback log files Flashback cannot be… 

Oracle – Licensing

Oracle Licensing Oracle licensing is a relatively complex topic. The following links point to articles and documents that I have come across in my attempt to understand it. There are many potential scenarios, particularly with… 

Oracle – test a database link of a user as sys user

1. A database link exists in the current database owned by CURRENTSCHEMA user (you don’t know the password of the CURRENTSCHEMA user) The database link was created by the application owner as follows: CREATE DATABASE… 

Oracle – Unified Auditing Trail – AUDSYS

The AUDIT_TRAIL needs to be purged. Error may occur if USE_LAST_ARCH_TIMESTAMP => TRUE is used: ERROR at line 1: ORA-08180: no snapshot found based on specified time ORA-06512: at “SYS.DBMS_AUDIT_MGMT”, line 4425 ORA-06512: at “SYS.DBMS_AUDIT_MGMT”,… 

Oracle, Linux – Huge Pages

12c in alert log PAGESIZE AVAILABLE_PAGES EXPECTED_PAGES ALLOCATED_PAGES ERROR(s) Tue May 24 11:47:24 2014 4K Configured 4 4 NONE Tue May 24 11:47:24 2014 2048K 66805 1537 1537 NONE Example from above log extract: –… 

Oracle – Database Character Set

Important initialization parameter to be determined before database creation. select * from nls_database_parameters where parameter = ‘NLS_CHARACTERSET’ SELECT value$ FROM sys.props$ WHERE name = ‘NLS_CHARACTERSET’ ;

Oracle – Recyclebin

This will take into account subsequent sessions – without the DEFERRED option, the command will fail alter system set recyclebin=OFF DEFERRED SCOPE=BOTH; ———————————————————————— PURGE RECYCLEBIN; To remove all dropped objects from the recyclebin (system wide):… 

SQL Server – Kill Sessions

USE [master] GO DECLARE @dbName SYSNAME DECLARE @sqlCmd VARCHAR(MAX) SET @sqlCmd = ” SET @dbName = ” SELECT @sqlCmd = @sqlCmd + ‘KILL ‘ + CAST(session_id AS VARCHAR) + CHAR(13) FROM sys.dm_exec_sessions WHERE DB_NAME(database_id) =…