- 博客(43)
- 资源 (1)
- 收藏
- 关注
原创 Welcome to visit my website:www.oracler.net
Welcome to visit my website:www.oracler.net
2012-06-16 15:43:46
819
原创 How to identify blocks which cause latch contention on the 'cache buffers chains' latch
Possible hot blocks in the buffer cache normally can be identified by a high or rapid increasing wait count on the CACHE BUFFERS CHAINS latch.This latch is acquired when searching for data blocks cach
2012-01-16 00:03:42
522
原创 11g New Feature dbms_stats Pending and Published Statistics
Prior to Oracle 11g, the default behaviour was to make statistics available for the optimizer to use as soon as they were gathered.While statistics are required to enable the optimizer to generate o
2012-01-13 16:52:37
1302
原创 Display Locks and Gives the SID and Serial Number of the session to kill
This script displays locks and gives the SID and Serial Number of the session to kill. REM ------------------------------------------------------------------------ REM PURPOSE: REM The repo
2012-01-12 22:16:59
404
原创 How to Export and Import Oracle Database Statistics Information
Some times not convenient to the database for analyisis when the database have a large mount of data.There may be analyisis it on the test database first and then applied the statistics information t
2012-01-12 21:24:19
886
原创 Read Of Flashback Database Found Corrupted Data / Reread Found Valid Data
Today , customer reflect their a 10.2.0.4 database alert.log has following information:Thu Dec 1 17:19:14 2011Read of flashback database logfile 72, block 121492 found corrupted data.See trace
2011-12-14 16:55:14
1922
原创 ORA-03113 and Getting CLOB Value from XMLTYPE
The Quest Code Tester for Oracle development team is making more and more extensive use of the XMLTYPE datatype in the Oracle database. XML documents are a perfect fit for several requirements of Code
2011-12-08 17:40:18
597
原创 How to delete or rename listener.log based on Windows or Unix platforms
As the listener.log file grows, the DBA will want to either remove or rename this log file. If you have ever tried to remove or rename the listener.log file on Windows while the TNS listener process w
2011-12-06 13:03:18
1889
原创 Manual upgrade from 9i to 10g Release 2
This procedure describes the steps necessary to manually upgrade a database from 9.2.x to 10.2.x. It assumes that you have already installed 10g onto the server. Of course, it is essential that you ta
2011-11-15 10:22:53
674
1
原创 Convert Oracle 9i Single-Instance database to 10g RAC .
Recently took a Oracle 9i upgrade to 10 g RAC test, following brief records:1.View my current database versionSQL> select * from v$version;BANNER--------------------------------------------
2011-11-10 11:56:59
1077
原创 Convert 10g Single-Instance database to 10g RAC
1.Installation Clusterware and ASM instance[oracle@rac1 ~]$ crs_stat -tName Type Target State Host ------------------------------------------------------------
2011-11-08 15:30:01
1588
原创 Index Rebuild Using Job Scheduler
Indexes are the key element for any Database Tuning. In Oracle 10g, REBUILD ONLINE is one of the key features that makes it possible to reorganize theindexes during production time.An index shou
2011-11-07 15:23:04
538
原创 Some RAC Concepts
Oracle Clusterware consists of the following components:• Cluster Synchronization Services (CSS): manages cluster node membership• Cluster Ready Services (CRS): performs management operations and
2011-11-06 01:17:04
411
原创 Use cursor_sharing_exact refused to SQL variable binding
In the use cursor_sharing parameters, may cause some SQL children cursor too high, cause competition, the competition may include library cache lock of all kinds of Child Cursor distribution, release,
2011-11-05 16:44:44
1069
原创 ORA-06553: PLS-213: package STANDARD not accessible
Today a net friend reflected use DBCA create a instance ,when schedule to 2% emerged ORA-06553:PLS-213: package STANDARD not accessible.On matelink searched the following methods to solve the problem:
2011-11-05 10:36:20
3412
原创 Locked Sessions and Locked Objects
ROMPT Blocked and Blocker Sessionscol blocker_sid format 99999999999col blocked_sid format 99999999999col min_blocked format 99999999999col request format 9999999select /*+ ORDERED */block
2011-11-05 08:37:27
559
原创 Data Guard Switchover Unix shell script
The following Unix shell scripts can be used to automate the Data Guard Switchover process of a physical standby database.It is very important that the scripts are run in the correct order and on ri
2011-11-02 23:06:20
645
原创 DRM-Dynamic Resource Management
When using Real application Clusters (RAC), Each instance has its own SGA and buffer cache. RAC will ensure that these block changes are co-ordinated to maximize performance and to ensure data intergr
2011-11-02 00:19:01
727
原创 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
472
原创 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
1357
原创 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
581
原创 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
450
原创 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
328
原创 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
417
原创 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
728
原创 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
957
原创 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
740
原创 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
784
原创 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
494
原创 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
728
原创 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
916
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
1429
原创 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
605
原创 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
360
原创 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
403
原创 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
1958
原创 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
788
原创 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
3526
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人