- 博客(24)
- 资源 (1)
- 收藏
- 关注
原创 Solve a ORA-00600 Error
Today occasionally run into a ORA-00600 error:[oracle@honcho ~]$ sqlplus sys/oracle@honcho as sysdbaSQL*Plus: Release 10.2.0.1.0 – Production on Sat Oct 29 18:25:11 2011Copyright (c) 1982, 2005,
2011-10-29 18:33:38 473
原创 Oracle Enterprise Manager Cloud Control 12c Release 1 Installation on Oracle Linux
Enterprise Manager Cloud Control is the new name for what was previously know as Enterprise Manager Grid Control. Depending on the source of the material, you may still see the product described as Gr
2011-10-28 16:12:10 1358
原创 Check RMAN Backup Status
Scripts to check backup status and timings of database backups -This script will be run in the database, not the catalog. Login as sysdba -This script will report on all backups – full, increm
2011-10-24 23:56:19 582
原创 Downgrading a failed 11g Release 2 Upgrade - the easy way
One of the best practices before performing any database upgrade is to take a full backup before we start the upgrade process just in case the upgrade fails and we want to then restore the previous ve
2011-10-23 23:39:27 451
原创 Using the AWR History Tables to compare performance
Using the DBA_HIST AWR history tables, we can compare the top wait events between different days or different time periods.Let us assume that we find that batch jobs which are executed at night part
2011-10-20 13:59:34 329
原创 Monitor Data Guard Log Shipping
Note: This query needs to be run on the Primary database.SET PAGESIZE 124COL DB_NAME FORMAT A8COL HOSTNAME FORMAT A12COL LOG_ARCHIVE
2011-10-18 23:21:18 418
原创 Using TUNE_MVIEW and EXPLAIN_REWRITE to enable us to tune MV Fast Refreshes and Query Rewrites
We can use the DBMS_MVIEW.EXPLAIN_REWRITE package (which was first introduced in Oracle 9i if memory serves me right) to diagnose why Query
2011-10-17 23:09:26 730
原创 Oracle RAC Performance and Tuning specially gc cr multi block request wait
LMS process called as Lock Manager Server Process , also called the GCS (Global Cache Services) process. Main task of this process is to tra
2011-10-16 11:17:06 959
原创 How To Recover From Corrupted OCR Disk
It is very common where a DBA is left with corrupted OCR disk without having any good backup.The same situation was experienced by me few
2011-10-15 22:00:31 743
原创 Restoring Optimizer Statistics
In some cases we may find that gathering fresh statistics has led to the optimizer executing sub-optimal execution plans and we would like t
2011-10-15 00:07:45 785
原创 How to transport a tablespace from 10g ASM on Windows to 11g ASM on AIX
This example demonstrates how to transport a tablespace from a 10g ASM on Windows environment to 11g ASM on AIX environment using the DBMS_F
2011-10-13 23:08:01 533
原创 FLASHBACK INSTEAD OF DELAYING APPLYING OF LOGS ON STANDBY
If you have multiple standby sites, you may utilize the DELAY option in Data Guard to prevent physical/logical corruption or user errors in
2011-10-12 22:12:30 496
原创 Changing the database characterset from US7ASCII to WE8MSWIN1252
This note looks at the procedure for changing the characterset of a 10g database from US7ASCII to WE8MSWIN1252. Keep this in mind that in Or
2011-10-11 23:58:51 729
原创 11g Active Standby Database Automatic Block Corruption Repair
In addition to the real time query capability of the 11g Active Data Guard feature, we can also add to our high availability capability by u
2011-10-11 15:21:52 918 1
原创 11g Release 2 Rolling Upgrade using Transient Logical Standby database
This note illustrates how we can perform a rolling upgrade from Oracle 11g Release 1 to Oracle 11g Release 2 using a Transient Logical Stand
2011-10-10 00:29:16 1431
原创 Query the Oracle Alert Log using SQL commands
There are often times when you want to know what has been recorded in the database’s alert log, but may not want to or be able to log into t
2011-10-09 16:31:16 606
原创 Upgrading to Oracle Database 10g
Oracle has made the process of upgrading from Oracle8i or Oracle9idatabases simple by automating a large portion of the upgrade process.He
2011-10-08 16:48:27 365
原创 How to identify all the Corrupted Objects in the Database reported by RMAN
Step 1: Identify the corrupt blocksPopulate the v$database_block_corruption view with information of all the corrupted blocks by executin
2011-10-08 16:15:08 363
原创 Find statements that do not use bind variables
Using different sql statement where only some parameters differs (also known as not using bind variables) is know as the worst performance i
2011-10-07 22:53:51 405
原创 RMAN Troubleshooting Catalog Performance Issues
This note discusses what to look for when queries against the RMAN repository (whether in the controlfile or a catalog database) are perform
2011-10-07 20:59:36 1961
原创 How to Backup Different Release Databases with the Same Catalog Database
The purpose of this article is to explain how to set up different catalogs in the same database and manage all Oracle release database bac
2011-10-06 11:13:58 789
原创 RMAN Restore Performance
Quite often when considering RMAN restore performance, the first thing that springs to mind is the speed of the tape device, the media manag
2011-10-06 00:41:29 3529
原创 RMAN Backup Performance
An rman backup spawns many processes and when a backup is taking a long time to complete it can be difficult to determine the cause. This n
2011-10-06 00:09:40 1635
原创 Oracle Database 11g Release 2 New Features in Oracle Data Guard
Oracle Database 11g Release 2 New Features in Oracle Data GuardThe following new features are specific to SQL Apply in Oracle Data Guard
2011-10-04 23:26:35 816
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人