Oracle DBA

Alertlog
Alertlog
Archivelog
Archivelog
Auditing
Auditing
Backup - Recovery
Backup - Recovery
Database files
Database files
Database options
Database options
DB links
DB links
Dependencies
Dependencies
Dictionary
Dictionary
Exp-Imp Datapump
Exp-Imp Datapump
Jobs
Jobs
Mview
Mview
Networking
Networking
Objects
Objects
Parameters
Parameters
Redologs
Redologs
Roles - Grants
Roles - Grants
Rollback - Undo
Rollback - Undo
Segments
Segments
Sequences
Sequences
Sessions
Sessions
SGA
SGA
Tables
Tables
Tablespaces
Tablespaces
Temp
Temp
Toad
Toad
Transactions
Transactions
Upgrade
Upgrade
Users
Users

Last updated scripts

Recently added scripts to the site:

Duplicate database from active without backup  Added: 2013-09-18 08:30:11
Create oracle database manual (with script)  Added: 2013-06-25 20:26:49
RMAN-06004: ORACLE error from recovery catalog database  Added: 2012-07-23 19:15:35
Datafile segment space map  Added: 2012-06-29 10:45:56
Stop or kill a datapump job  Added: 2012-06-25 20:04:58
UDI-00052: incorrect Data Pump client for operation: EXPORT  Added: 2012-06-19 22:49:04
WARNING: inbound connection timed out (ORA-3136)  Added: 2012-06-19 10:00:28
ORA-39171: Job is experiencing a resumable wait  Added: 2012-04-25 04:08:17
ORA-01113: file 1 needs media recovery  Added: 2012-04-02 01:07:39
Toad slow connection as APPS to E-Business Suite  Added: 2011-12-10 21:16:40
Restore and Recover the damaged Database  Added: 2011-07-19 12:53:43
Toad with Windows 7 (64-bit)  Added: 2011-06-16 10:06:24
expdp stops with status DEFINING when export to NFS filesystem  Added: 2011-06-04 13:26:02
Find which media tapes have the latest backup  Added: 2011-05-20 14:52:49
Toad session browser filters  Added: 2011-05-20 13:39:12
Shared memory heapdump trace  Added: 2011-05-06 11:20:12
Find user object grants  Added: 2011-02-15 13:14:27
Backup time  Added: 2010-11-03 10:02:20
Resize all the database files  Added: 2010-10-20 16:38:29
Oracle Flash Cache  Added: 2010-09-17 20:46:35
SGA resizing history  Added: 2010-09-15 12:49:45
RESOURCE role and UNLIMITED TABLESPACE role  Added: 2010-07-06 21:10:48
Calculate export dmp size  Added: 2010-07-06 12:01:42
Manual upgrade Oracle 8i InterMedia to Oracle 9i  Added: 2010-03-21 10:25:25
Manual upgrade Oracle 8i to Oracle9i  Added: 2010-02-09 09:56:44
Large pool size and contents  Added: 2010-01-12 10:19:38
Alert log contents while cloning with RMAN  Added: 2009-11-11 15:04:58
Rman output script for creating DUPLICATE database  Added: 2009-11-11 14:54:48
Clone database with RMAN (Duplicate database)  Added: 2009-11-11 14:18:53
'IN' is not a valid integer value. TOAD and Oracle10g  Added: 2009-11-09 10:07:11
Categories
Oracle DBA-> (147)
  Alertlog (3)
  Archivelog (5)
  Auditing (1)
  Backup - Recovery (19)
  Database files (6)
  Database options (2)
  DB links (2)
  Dependencies (1)
  Dictionary (2)
  Exp-Imp Datapump (6)
  Jobs (2)
  Mview (2)
  Networking (3)
  Objects (7)
  Parameters (2)
  Redologs (6)
  Roles - Grants (2)
  Rollback - Undo (8)
  Segments (3)
  Sequences (2)
  Sessions (14)
  SGA (14)
  Tables (10)
  Tablespaces (10)
  Temp (4)
  Toad (5)
  Transactions (1)
  Upgrade (2)
  Users (3)
Oracle APPS DBA-> (66)
Exadata (1)
Performance Tuning-> (59)
Oracle Real Cases (24)
Oracle Errors (23)
Oracle SQL tricks (32)
Oracle RAC (3)
Oracle Security (8)
Filters
Search