New Oracle 12c IO Outlier Views
With 12c Oracle provides a couple of new views that report IOs that take over 500ms. That 500ms threshold is […]
12c, Oracle, Oracle Database, Tuning
12c
12c, Oracle, Oracle Database
DBMS_SYSTEM reference
DBMS_SYSTEM pl/sql package does not seem to be documented and may not be supported by Oracle. Here’s where you can
12c, ASM
Oracle ASM 12.1.0.1 / 12c Maximum Disks and Disk Groups in ASM – Knowledge Needed For 1z0-068 OCE
511 disk groups 10,000 disks across all disk groups 128GB – The largest Oracle database datafile that can be created
12c
Keep hidden parameters after 12c upgrade with dbua
As a result of an enhancement request (Bug 10215520), from 11.2.0.3 onwards you can use the following method to keep
12c, RAC
Oracle RAC – For New Installs Load SSH Keys Into Memory Before Starting DBCA
For new installs load SSH keys into Memory before starting DBCA – to establish ssh equivalence In an Oracle RAC
12c, Oracle Database, SQLDeveloper
Using SQL Developer DBA Export Wizard to write PL/SQL DBMS_DATAPUMP exports for you
Simple enough: Go into SQL Developer DBA module Data Pump -> Create Export Wizard and get to the Summary/Finish page
12c
12c new features 12.1 & 12.2
Excuse my dust – work in progress Oracle 12.1 New Features Increased size to 32k for varchar2 Partial indexes on
12c, Oracle
Oracle 12c show all tablespaces and what container owns them
By default when you create a pluggable database / pdb a “USERS” tablespace is created if you don’t specify a
12c, Oracle
How to Rename a Pluggable Database Oracle 12c
How to Rename a Pluggable Database Oracle 12c How to rename a container (pluggable database). Step-By-Step 0.) Optional –
12c
Oracle 12c connecting to containers
General syntax is “alter session set container=<container name>;” or Generally: sqlplus user/pw@ip-hostname:port/service_name To verify service name do a “lnsrctl service”