Honcho-CSDN博客

原创 Welcome to visit my website：www.oracler.net

Welcome to visit my website：www.oracler.net

2012-06-16 15:43:46 781

原创 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 499

原创 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 1238

原创 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 386

原创 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 864

原创 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 1896

原创 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 579

原创 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 1871

原创 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 652 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 1057

原创 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 1573

原创 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 521

原创 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 403

原创 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 1061

原创 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 3367

原创 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 548

原创 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 630

原创 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 707

原创 Solve a ORA-00600 Error

2011-10-29 18:33:38 461

原创 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 1339

原创 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 565

原创 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 438

原创 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 312

原创 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 406

原创 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 719

原创 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 937

原创 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 708

原创 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 769

原创 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 519

原创 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 481

原创 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 709

原创 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 901 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 1412

原创 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 585

原创 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 338

原创 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 349

原创 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 392

原创 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 1925

原创 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 776

原创 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 3473

计算机网络课件 谢希仁

空空如也

计算机网络课件谢希仁