Managing your database

Bring me home...

Space management

• LMT, ASSM, PCTFREE and PCTUSED

Database level management

• Cloning a database

SQL*NET stuff

• Net configuration for external procedure
• Closing db links
• Check db links

Roles, privileges and security

• Role and view creation
• Role based FGAC(Fine Grained Access Control)
• FGA(Fine Grained Auditing)

Dealing with LOB

• LOB problem with trigger

Synonym management

• Public synonym name resolution

Constraints management

• Constraints on views?
• Unique constraint summary
• Primary Key summary
• Avoid PK non-unique index maintainence
• Deferrable constraints
• Differences between a primary key and a unique constraint

Table management

• A closer look at CTAS(create table as select)

Index management

• Set index unusable

Memory management

• Online SGA management

Manage sorting

• V$SORT_SEGMENT and V$SORT_USAGE views

Backup and recovery

• Block level recovery

Misc

• Generate DDL with DBMS_METADATA