Admin-Tasks

Admin Tasks
DAILY DBA CHECKLIST
Create Empty Database - Manually
Dropping Database
Suspending Database
Quiescing Database
Flashback-Database
Rename DB
Show Installed DB Components
Manually create XML DB
Enable-Disable Archive Log mode
General Database Admin
Change the SID of an Oracle database
Database Startup and Shutdown on Linux (automatic)
DBVERIFY
DBNEWID Utility
Managing Alert Thresholds
Data Dictionary and Dynamic Performance Views

Database Administration Authentication

Audit
Enable Audit
Audit
Manage Audit files

Automated Tasks
Automated Maintenance Tasks in Oracle 11g

Archive
Archive-Admin
Archive-Folder
Managing Archived Redo Logs


ADR
Maintenance & Log Tidy scripts
Tidy Oracle Logs
Purge Trace/Dump files
Purging trace and dump files with 11g ADRC
Cleanup Log/Trace files
Alert & Trace files - Monitor
Add Message to Alert/Trace files

Control file
ControlFileAdmin
CF-Structure-Usage
Management
Control File Recreate in Oracle Database

Clone
Clone Oracle Database Binaries
Cloning ORACLE_HOME
Cloning Oracle Home2

Data Pump
DataPump-Example1
DataPump-Example2
Oracle DataPump Utility 11.2.0.3
Oracle Data Pump (expdp, impdp) in Oracle Database 10g, 11g, 12c & 18c

Datafile
Managing Datafiles and Tempfiles

Flashback
Flashback Database


Logminer
LogMiner - Analyze Redo Log files

Managing Oracle DB Instance
Managing Oracle DB Instance

Patch
Patches Concept Online Patching - The good, the bad & the ugly
PatchConflict
List Patch
Online RDBMS Patching
Online Hot Patching
Opatch commands
How to check which PSU is installed
OPatch utility
OPATCH Utility (Oracle RDBMS Patching)
OPatch Utility and Commands

RBS

Redo
Maintaining Online Redo Log Files

Scheduler
DBMS_SCHEDULER
DBMS_SCHEDULER 11g Enhancements
List Jobs running
List Job Info
Show Jobs
Show Job Class Info
Show Windows Info
Scheduler Windows Group Info
List Scheduler Info
List Scheduler Jobs running
Show Scheduler Job Credentials

SQLNET
SQLNET.ORA
Setting up Oracle Net Services Tracing on the Client and Server



Resource Manager
Create Resource Plan
Create Resource Plan Directive
Enable Resource Plan
Enable Resource Plan Window
Schedule Resource Plan Window
Resource Manager
Resource Manager Enhancements 11g
Resource Active Plan

Scripts
Script Library

SQL Library
SQL Library

Explain Plan

Temp
Monitor Temp Space


Trace
Session Trace
User SQL Trace
Add Message to Alert/Trace files
Trace SQL Session - 10g

Tables
Populate Table with Volume Data

Tablespace
Managing Tablespaces
Managing Undo Tablespaces

Users

MISC
Populate Table with Volume Data
Hidden Parameters