Administration
文章平均质量分 78
Honcho
Love Life Love Oracle !
展开
-
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 阅读 · 0 评论 -
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 · 887 阅读 · 0 评论 -
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 · 1924 阅读 · 0 评论 -
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 · 598 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 · 677 阅读 · 1 评论 -
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 · 539 阅读 · 0 评论 -
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 · 1070 阅读 · 0 评论 -
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 · 3417 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 · 729 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 · 363 阅读 · 0 评论 -
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 阅读 · 0 评论 -
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 · 1960 阅读 · 0 评论 -
Database Change Notification
Database Change Notification is a feature that enables client applications to register queries with the database and receive notifications i原创 2011-09-20 13:31:30 · 2608 阅读 · 1 评论 -
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 阅读 · 0 评论 -
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 · 1305 阅读 · 0 评论