lscpu Architecture: x86_64 CPU op-mode(s): 32-bit, 64-bit Byte Order: Little Endian CPU(s): 12 On-line CPU(s) list: 0-11 Thread(s) per core: 2 Core(s) per socket: 6 Socket(s): 1 NUMA node(s): 1 Vendor ID: GenuineIntel CPU family:… 

expdp “\/ as sysdba\” SCHEMAS=xyz,abc ….. FLASHBACK_TIME=systimestamp SQL> select current_scn from v$database; expdp “\/ as sysdba\” SCHEMAS=xyz,abc ….. FLASHBACK_SCN=nnnnnnnnnn where nnnnnnnnnn = current_scn from the previous query

Server Licensing Example

Must be done from an installed runInstaller (not from distribution) oracle@server1: ./runInstaller -silent -detachHome -invPtrLoc /etc/oraInst.loc ORACLE_HOME=”/oracle/product/112_64/ORCL” Starting Oracle Universal Installer… Checking swap space: must be greater than 500 MB. Actual 10111 MB Passed The… 

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: –… 

— 100 recursions maximum create function dbo.SplitString ( @str nvarchar(max), @separator char(1) ) returns table AS return ( with tokens(p, a, b) AS ( select cast(1 as bigint), cast(1 as bigint), charindex(@separator, @str) union all… 

select * from sys.dm_db_persisted_sku_features;

hdasah fd gffghh  

exec sp_msforeachdb ‘use [?]; SELECT ”?”, MAX(TotalSpaceMB) as MaxObjSizeMB FROM ( SELECT t.NAME AS TableName, i.name as indexName, (sum(a.total_pages) * 8) / 1024 as TotalSpaceMB FROM sys.tables t INNER JOIN sys.indexes i ON t.OBJECT_ID =…