Oracle Scripts
»
Categories
»
Oracle Real Cases
Oracle Real Cases
Script+
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
Please Select
AD
DAILY
DWH
NP
SA
Search
Advanced Search
Information
Ask for Free Support
About the Author
Buy Oracle Books
Privacy Notice