ITPub博客

1.儿子1岁1一个月零一天学会自己走路，不用辅助。2.2009年圣诞节，有意识的叫爸爸。3.2010年3月7日，会叫妈妈老了，写几个字记录一下。[@more@]

这是在数据库升级到10.2.0.4以后做分析时碰到的问题。[@more@] Subject: Getting ORA-01476 during execution of DBMS_STATS.GATHER_SCHEMA_STATS Doc ID: 464440.1 Type: PROBLEM Modified Date : 30-MAR-2009 Status: MODERATED In this Document Symptoms Cause Solution This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review. Applies to: Oracle Server - Enterp

这篇文章，在于提醒不要用system,sys用户去创建其他schema的索引。[@more@]ORA-20000 While Executing dbms_stats.gather_schema_stats [ID 309834.1] 修改时间 08-NOV-2007 类型 PROBLEM 状态 MODERATED In this Document Symptoms Cause SolutionThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to: Oracle Server - Enterprise Edition - Version: 9.2.0.5This problem can occur on any

http://www.oracle.com/technology/pub/articles/10gdba/week5_10gdba.html[@more@]Oracle Database 10g: The Top 20 Features for DBAs Join Oracle Magazine's 2003 "DBA of the Year" Arup Nanda over the next 20 weeks as he presents his list of the top Oracle Database 10g features for database administrators Follow along! Download Oracle Database 10gWeek 5Flashback Table Reinstating an accidentally dropped table is effortless using the Flashback Table feature in Oracle Database 10g Here's a scen

具体解决方法如下：rman>list incarnation;rman>reset database incanation to..;[@more@]RMAN: Point-in-Time Recovery of a Backup From Before Last Resetlogs [ID 1070453.6] 修改时间 30-JUN-2009 类型 PROBLEM 状态 PUBLISHED "Checked for relevance on 30-Jun-2009" Problem Description: ==================== You would like to restore a database to a point-in-time, but the backup being used is from before the last resetlogs. The problem is that when a database is opene

利用AWR的awrddrpt.sql，我们可以比较不同日期的相同时间段的数据库性能。具体可以参考：http://www.5ienet.com/note/html/ash_awr/oracle-create-awr-different-report.shtml这里要说明的是，如果数据库设的是/3gb /PAE,就不会设db_cache_size这个参数，而是db_block_buffer*db_block_size,在这种情况下，oracle就不会认识这种格式。已经从metalink的反馈中得知这是一个bug,所报的错误是：ERROR at line 1:ORA-01476: divisor is equal to zeroORA-06512: at "SYS.DBMS_SWRF_REPORT_INTERNAL", line 9515ORA-06512: at "S

用以下方法就可以在另一台机器将dump文件导出--- in centmsq3 --- (target database)CREATE DIRECTORY dump_dir01 AS '/data/oracle/centmsq3/';GRANT READ,WRITE ON DIRECTORY dump_dir01 TO export;grant create database link to export;connect export/123 create database link centqprf_exp connect to export identified by export using 'centqprf';command:expdp export/export directory=dump_dir01 schemas=stddata_suplr dumpfile=prod_stddata_suplr.dmp logfile=prod_centmsq3_stddata_suplr.log network_link=centqprf_

在测试库上insert一张大表，报undo不够，加上空间不够，就像flashback回去，但shutdown immediate的时候又不想等那么长的时间，就abort了。结果发现：ORA-38760: This database instance failed to turn on flashback database以下是解决方法：[@more@]1.先flashback：SQL> FLASHBACK DATABASE TO RESTORE POINT WMOS_GOLD_COPY;Flashback complete.2.SQL> alter database flashback off;Database altered.3.SQL> alter database open resetlogs;alter database open resetlogs*ERROR at line 1:ORA-38760: This database instan

select distinct(b.file#), a.datafile_blocks*8192/1024/1024/1024 from RC_BACKUP_DATAFILE a,DF bwhere a.db_name='DB_NAME'and a.completion_time>=to_date('20090810','yyyymmdd')and a.completion_time<to_date('20090811','yyyymmdd')and a.creation_change#=b.create_scn order by b.file#[@more@]

来自metalink[@more@]Subject: How to Re-Organize a Table Online Doc ID: 177407.1 Type: BULLETIN Modified Date: 06-MAY-2009 Status: PUBLISHEDChecked for relevance on 06-May-2009PURPOSE Prior to Oracle9i, any table re-organizations and redefinitions forced the table to be offlined for the duration of the operation. From Oracle9i forward, table re-organizations and redefinitions can be performed online. This note explains how to reorganize a table online. NOTE: This note does not

DECLAREisClean BOOLEAN;BEGINisClean := FALSE;WHILE isClean=FALSELOOPisClean := dbms_repair.online_index_clean(dbms_repair.all_index_id, dbms_repair.lock_wait);dbms_lock.sleep(10);END LOOP;END;/[@more@]

select sum(datafile_blocks*block_size)/1024/1024 from RC_BACKUP_DATAFILEwhere db_name='abc'and completion_time>=to_date('20081001','yyyymmdd')and completion_time<to_date('20081002','yyyymmdd')[@more@]

当并发session在300左右时，用auto sga没有什么问题。但auto sga有一个bug。Bug 5201883.[@more@]Subject: Auto Sga: Not FreeDoc ID: 394026.1 Type: PROBLEMModified Date : 26-MAY-2008 Status: MODERATEDIn this DocumentSymptomsCauseSolutionReferencesThis document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process, and therefore has not been subject to an independent technical review.Applies to: Oracle Server - Enterprise Edition - Version: 10.2.0.2 to 10.2.0.3This problem can oc

以下是工作中对database flashback的一些设置经验：[@more@]1)Change the initialization Parmeter- init.ora.db_recovery_file_dest_size=20gdb_recovery_file_dest='/axptpharch/axptphq/flasharea'DB_FLASHBACK_RETENTION_TARGET=10080log_archive_dest_1='location=/oradb/arch'control_file_record_keep_time=14#log_archive_format=oradb_arc_%t_%s_%r.arcand comment out #log_archive_dest='/oradb/arch' 2)Starting database in flashback Mode:svr << EOFspool $spooltofile_tempshutdown immediate;startup mount;alter

主要遵从以下步骤：Transportable Tablespaces Steps:· Determine the source and target database oracle version( Source database version can not be more than target database version).· Verification of endian compatibilities of source and target and if there is any conversions required .· Check Database Character set and national Character set for compatibility between source and target.· Determine if there are external objects (external tables ,directory structures) need to moved separately to t

在做sql tuning时，可以引用虚拟索引技术而不用创建物理索引来进行tuning判断。sql>create index index_name on table_name(column_name) nosegment;在使用时，要这样才能生效：SQL> alter session set "_use_nosegment_indexes"=TRUE; [@more@]

以下内容为转载：[@more@]Oracle] Oracle 10G 中的"回收站"作者：Fenng 日期：11-Jan-2004 　出处：http://www.dbanotes.net版本：1.0 $29-Oct-2004$在Oracle 10g数据库中，引入了一个回收站(Recycle Bin)的数据库对象。 回收站，从原理上来说就是一个数据字典表，放置用户Drop掉的数据库对象信息。用户进行Drop操作的对象并没有被数据库删除，仍然会占用空间。除非是由于用户手工进行Purge或者因为存储空间不够而被数据库清掉。数据库有了这样的功能，能够减少很多不必要的麻烦。常常看到开发人员误把表删除，急急忙忙找DBA 来

关于awr report中db time的说明2008-08-12 16:39在10g的awr report出了个db time,这里做个简单的说明先摘录一些官方的说明：Oracle Database Performance Tuning Guide 10g Release 2 (10.2)B14211-01DB TimeAmount of elapsed time (in microseconds) spent performing Database user-level calls. This does not include the time spent on instance background processes such as PMON.The most important of the time model statistics is DB time. This statistics represents the total time spent in database calls and is a indi

2009的年28.回家前的一个晚上，点开CRI，无意中发现这个radio show。高晓松专访。http://english.cri.cn/4926/2008/12/30/44s437784.htm[@more@]

下班的地铁上，立着的扶手两边，是2对情侣。左边的年轻，缠绵，女孩儿在男孩深情款款送到嘴边的零食中陶醉。右边的中年，应该是夫妻。男人左手拉着吊环，女人在左边，双手环扣着男人拉环的左手。男人右手拉掉女人的那双手，一次，二次...女人生气，男人起初笑笑，然后扭头。我面前最终呈现的是一幅对比强烈的静态画面，左边，是交织的眼神，右边，却是2对平行线。女人最终生气的撞开眼前的人独自到门口，门开，2对人出门。我的耳机中，是钢琴曲雨的印记，琴声舒缓却每个音符在我的脑海。仿佛画外音。看着迈出门的两对，左边的很缠绵，以后