Monitoring SGA Memory on Pluggable Database
The scripts must be run in SQL*Plus session since specific SQL*Plus functions are used. Scripts must be run as […]
GoldenGate Extract Abends with “Unable to lock file” Error For Trail File
Extract abends, reporting “Unable to lock file” or “response from Server/Collector. Examples: Unable to lock file “/h/remis/ggs/dirdat/em000002” (error 13, Permission […]
Transportable Tablespaces FAQs
Why use Transportable Tablespaces (TTS)? Up through 11gR2, “Oracle transportable tablespaces are the fastest way for moving large volumes […]
Oracle GoldenGate Best Practices: Creating History Tables
Oracle GoldenGates flexible architecture provides built-in functionality for the transformation of captured transactional data. This data manipulation may take place […]
Different Methods for Upgrading Databases
Following are different upgrade methods one can use to upgrade the database to the new Oracle Database 9i […]
More 11g R1 RAC Administration and Maintenance Tasks and Utilities
Backing up OCR: Oracle performs physical backup of OCR devices every 4 hours under the default backup directory […]
Some more 11g R1 RAC Administration and Maintenance Tasks and Utilities
Various Timeout Settings in Cluster: Disktimeout: Disk Latencies in seconds from node-to-Votedisk. Default Value is 200. (Disk IO) Misscount: Network […]
11g R1 RAC Administration and Maintenance Tasks and Utilities
Checking CRS Status: The below two commands are generally used to check the status of CRS. The first command […]
Oracle Background processes
You can see the Oracle background processes with this query: select * from v$session where type =’BACKGROUND’; Here are some […]
General RMAN FAQs
What is RMAN? RMAN is an Oracle Database client that performs backup and recovery tasks on databases and automates […]