Top 10 - Biggest Tables and Indexes

Top 10 - Biggest Tables and Indexes

set lines 170
set pages 20
col owner      format a20
col object     format a30
col type       format a6
col tablespace format a20
col size_in_gb format 999,999.9
select * 
  from (select owner           owner,
               segment_name    object,
               segment_type    type,
               tablespace_name tablespace,
               round(bytes/1024/1024/1024,1) size_in_gb
          from dba_segments 
         where owner not in ('SYS','SYSTEM')
         order by bytes desc
       ) 
 where rownum < 11
 order by size_in_gb desc;

Oracle Database 12c Multitenant Architecture Overview

Oracle Database 12c Architecture Overview

Interesting 12c New Features

"I don't always build databases, but when I do, I prefer Oracle 12c."
 -The Most Interesting DBA in the World

Interesting 12c New Features

17-Jul-2013

• Multi-tenant Architecture
• CDB Container Database
• Common Users & Roles
• PDB Pluggable Database
• Local Users & Roles
• Up to 253 PDB's in a CDB
• Listener services for CDB and PDBs
• varchar2(32767)
• Auto Incrementing Identity Column
• Default column value can be sequence.nextval
• Fetch First and Offset syntax for top-N results
• Drop partition without "update global indexes"
• Move partition online
• CPU-Instance Fencing using "processor_group_name".  Used with Linux "control groups" or Solaris "resource pools".
• Grid Scheduler - Enterprise Job Scheduling
• DataPump timestamped logging (finally)
• DataPump export a view as table
• Application Continuity - It claims to mask db side failures to the app.
• New online operations (drop index, drop constraint, etc.)
• Invisible columns
• Move a datafile online (think online migration to ASM)
• Online Index DDL change via multiple indexes on the same column(s)
• DataGuard Max Availability performance enhancement. Standby doesn't wait for RFS to write redo to standby log(s).
• The "Far Sync" instance type, control and log files only. Data Guard transaction distributor for slow WAN's etc.
• RMAN runs native SQL
• PGA_AGGREGATE_LIMIT - to stop runaway process(es) & avoid node eviction.

18-Jul-2013

• Rebalance multiple ASM diskgroups simultaneously.
• ASM Flex server - decoupled from the database server

19-Jul-2013

• Datafiles on ACFS
• Flex Cluster - Hub/Leaf nodes.
• OCR Backup in ASM diskgroup (visible to all nodes)
• IPv6 support
• Auditing enabled by default (audit_admin role necessary to admin audit settings/data)
• Last Login
• sysbackup admin privilege for separation of duties for the backup user
• DBUA - Faster upgrades by using parallel operations (like adpatch?)
•