Oracle Scripts » Categories » Oracle Real Cases

Oracle Real Cases

An example of 1TB OLTP Unix database

Create a super user like DBA but with no administration power

Disable DDL from table (no alter, drop, truncate)

Find if you need to add new partitions

Find users other than SYS, with objects stored in the SYSTEM tablespace

How to install Oracle Apex 4.0.2 on Windows 2008 64bit server

Load data from one table to another(the faster way)

Monitor all blocking sessions and get email alerts

Monitor all database errors and get email alerts

Monitor tablespace free space and get email alerts

Mount NTFS usb drive to RedHat 5.5 linux

Multiple truncates taking too long

Naming filesystems example

Numa automatically enabled after upgrade to 10.2.0.4

ORA-29350: server version 9.2.0.8.0 incompatible with package

Press CTRL-C during drop of functional based index

Send emails from the database

Shared memory and semaphore segments

Shutdown Oracle database NORMAL without waiting forever

Tasks of Oracle background processes

Track table data changes (inserts, updates, deletes)

Truncate partitioned table very fast

Update a join view

Update or Delete a large table in a loop and commit very X rows

Result Pages: 1 Displaying 1 to 24 (of 24 scripts)

Categories

Oracle DBA-> (147)
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

Information

Ask for Free Support
About the Author
Buy Oracle Books
Privacy Notice