![](https://img-blog.csdnimg.cn/20201014180756926.png?x-oss-process=image/resize,m_fixed,h_64,w_64)
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 · 718 阅读 · 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 · 877 阅读 · 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 · 1911 阅读 · 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 · 585 阅读 · 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 · 1877 阅读 · 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 · 662 阅读 · 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 · 530 阅读 · 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 · 1065 阅读 · 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 · 3397 阅读 · 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 · 465 阅读 · 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 · 441 阅读 · 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 · 721 阅读 · 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 · 593 阅读 · 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 · 350 阅读 · 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 · 394 阅读 · 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 · 1944 阅读 · 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 · 2594 阅读 · 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 · 525 阅读 · 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 · 1269 阅读 · 0 评论