blog.contractoracle.com
Contract Oracle Limited is not affiliated to Oracle Corporation.
Blog Archive
►
2013
(17)
►
March
(1)
►
February
(11)
►
January
(5)
►
2011
(1)
►
October
(1)
►
2010
(22)
►
October
(2)
►
May
(2)
►
April
(1)
►
March
(7)
►
February
(4)
►
January
(6)
►
2009
(94)
►
December
(2)
►
November
(11)
►
October
(1)
►
September
(12)
►
August
(11)
►
July
(18)
►
June
(14)
►
May
(4)
►
April
(4)
►
March
(8)
►
February
(5)
►
January
(4)
▼
2008
(156)
►
December
(2)
►
November
(1)
►
October
(28)
►
September
(35)
▼
August
(90)
Copy an archivelog file from ASM to disk using RMA...
RAC node shutdown / startup
What do filesystemio_options and disk_asynch_io Do...
Oracle 10g proxy users
Using dbms_metadata.get_ddl
NLS_LANG diagnostics
Transportable tablespace
External table to select from Oracle listener log
External table to select from Oracle alert log
External table
UTL_FILE test
Drop all Oracle users created in the last year
Unusable indexes can't be skipped if they are a pr...
RMAN examples
Check for scheduled and running Discoverer jobs
Profile Options changes to enable diagnostics
Find the forms session holding a lock
Shared Pool Usage
UNDO tablespace usage
TEMP tablespace usage
# coalesce qmn queues
Check if a patch has been applied to Oracle Apps
Test URLS for Oracle Apps 11i
To speed up large patchsets or merge patches with ...
Use FNDCPASS to change passwords
java.lang.NoClassDefFoundError: oracle/apps/jtf/ca...
Kill all unix processes matching a string
WFRESGEN
Check for datafile corruption with dbverify
Manually compile a form using f45gen
Use ar25run to test a report
Run a script across multiple databases
dbms_jobs
Load a new workflow
Find Unsuccessful Logins in the last 24 hours
User rcp to copy a directory
Use RSYNC to synchronise two directories
Send a test email from Unix
Get explain plan for select statement
Identify concurrent requests using the most system...
Identify concurrent requests using a specific prin...
Create a public database link
Adpatch hotpatch
tar and gzip via a unix pipe to save space
ASM diagnostics statements.
Rollback a patch with opatch
create an spfile on ASM from a pfile in the OS
Reclaim space by purging the DBA Recycle Bin
Using kfed to debug raw devices used in ASM.
Test the impact of NOLOGGING on an Oracle Dataguar...
How to suspend and resume a running Oracle process...
Connect to a blocked instance using UR=A
Clone ORACLE_HOME
The ultimate Oracle performance tuning parameter.
Oracle profiles and password verification
Finding orphan mview log registrations
Copy archivelogs from ASM to OS
Catch system errors with an After Servererror trig...
Auditing the program logging into Oracle
Run CSSCAN to check Oracle characterset conversion...
Audit an Oracle user with a Logon Trigger
Enable Oracle Flashback
Using COMMIT_WRITE=BATCH,NOWAIT
Compressed Oracle Backup can be faster than Uncomp...
Auditing selects on a table in Oracle - including ...
Check which Oracle objects are dependant on a data...
To install Java in Oracle 10g
Open a Oracle Dataguard physical standby read-only...
Writing messages to the Oracle Alert Log
Selecting from the Oracle Alert Log
Oracle recommended DDL audit
delete files over 1 day old
Finding inactive users in Oracle
HTML Output from sqlplus
Index and Table Monitoring
Shrink a table
Read / Write test on Dataguard Standby using Flash...
Oracle External Password Store
Encrypted Data Pump
Transparent Data Encryption
Manual setup for Physical Dataguard
Log Miner
Switch from Physical Dataguard to Logical Dataguar...
Streams with Downstream Log Mining
Oracle Startup and Role Change Triggers
Manual Dataguard Switchover
Dataguard Diagnostics Select Statements
Setup Dataguard Broker
Split a Partition
Simple Oracle Streams Example
Saturday, August 16, 2008
Adpatch hotpatch
Apply a small patch without the need to enable maintenance mode.
adpatch options=hotpatch
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment