Oracle Consulting, Oracle Support and Oracle Training by Spyridon N. Kaparelis
Oracle
Oracle Scripts
(Search)
»
Categories
»
Oracle Real Cases
My Account
Categories
Free Oracle Support
(1)
Administration->
(120)
FlexCube
(4)
ORA errors
(14)
Oracle Application Server
(1)
Oracle APPS DBA->
(38)
Oracle APPS DBA jobs
(1)
Oracle Books
(18)
Oracle RAC
(3)
Oracle Real Cases
(29)
Oracle Security
(6)
Oracle SQL tricks
(32)
Other Oracle sites
(3)
Performance Tuning->
(53)
Site info
About Spyridon N. Kaparelis
Privacy Notice & Disclaimer
Buy Oracle APPS DBA Books
Ask for Free Oracle Support
Scripts+
'IN' is not a valid integer value. TOAD and Oracle10g
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)
Example on how to Encrypt-Decrypt data
Find if you need to add new partitions
Find other than SYS objects stored in SYSTEM tablespace
How to limit access to the database to certain hours
How to open database even though a datafile is missing
Load data from one table to another(the faster way)
Manual upgrade Oracle 8i InterMedia to Oracle 9i
Manual upgrade Oracle 8i to Oracle9i
Memory Notification: Library Cache Object loaded into SGA
Monitor all blocking sessions and get email alerts
Monitor all database errors and get email alerts
Monitor all DDL statements at the database
Monitor tablespace free space and get email alerts
Multiple truncates taking too long
Naming filesystems example
Numa automatically enabled after upgrade to 10.2.0.4
Open database not properly recovered _ALLOW_RESETLOGS_CORRUPTION
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
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
Displaying
1
to
29
(of
29
scripts)
Pages:
1
Reviews
No reviews recently
Read Latest Oracle News
Search at the site
Press Enter to search
Advanced Search
Search Error Messages
Oracle8i
Oracle9i
Oracle10g
Oracle11g
Search Oracle Docs
Metalink
Oracle8i
Oracle9i
Oracle10g
Oracle11g
Wednesday 08 September, 2010
Created by:
Spyridon N. Kaparelis
136627 page views since Tuesday 27 October, 2009
Oracle APPS DBA Kaparelis
|
Oracle RAC
|
Oracle PLSQL
|
Oracle Tips
| Oracle Consulting |
Oracle Metalink
| Oracle Support
Oracle Training
|
Oracle Certification
|
Oracle Articles
|
Oracle DBA
|
Oracle Magazine
|
Oracle User Groups
Oracle 7.3 Oracle 8 Oracle 8i Oracle9i Oracle10g Oracle11g EBS E-Business Suite 11.5.10 Oracle Apps Tuning Oracle SGA tuning sql tracing oracle session oracle errros ORA error ORA-600 Ora-00600 oracle jobs dba jobs apps dba jobs oracle experts oracle guru oracle oracle real application cluster oracle index oracle optimazation query oracle explain plan query optimization oracle I/O oracle memory tuning oracle xstress test oracle education oracle university oracle certification OCP OCA oracle support contracts oracle monitoring RAC interconnect developer oracle forms reports oracle application server Rman spyros dba oracle backup Veritas recovery catalog rcvcat oracle Σπυρίδων Καπαρέλης Ora-00600:[] Sp???d?? ?. ?apa????? oracle monitor daily operations free oracle support free consulting oracle seminars oracle arhitecture Unix linux HP-UX AIX Sun Solaris Windows TAR Service Request Metalink oracle disaster recovery oracle Data Guard Oracle Database Administrator Oracle Services low cost oracle support oracle patches upgrades apps dba spyros patch upgrade oracle opatch OUI export import oracle data pump ADDM ASM oracle OAS PGA shared pool ?p?st????? Oracle Application Server 10g consultans Oracle ERP CRM Apache WebUtil oracle 10g 11g 12g New Features Oracle courses development Oracle News forums Oracle Technical Docs FAQ Oracle Professionals Oracle DataCenter Data Center IT Oracle prices oracle software pricelist oracle carriers Oracle RDBMS Oracle Σπύρος Καπαρέλης Oracle Fusion Spiros Kaparelis oracle Spyros Kaparelis
