ITPub博客

https://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=137482.1PURPOSE This document explains the usage of Oracle Managed Files (OMF files) under different configurations. SCOPE & APPLICATION Users of Oracle Managed Files.OMF (Oracle Managed Files) Usage for Datafiles:===============================================You decide to manage your datafiles with OMF.*** **************************************************** Homogeneous Test : tablespace with OMF files only *** **

SQL> create table testa as select object_id,object_name,status from user_objects where rownum<101;SQL> create table testb as select * from testa where rownum<11;Table created.SQL> update testa set s...

ASMCMD> lsdg -cgH dgroup1      2  MOUNTED  EXTERN  N         512   4096  1048576    ...

用于check repair DISKGROUP用[@more@]#!/bin/shexport ORACLE_BASE=/oracle/appexport ORA_ASM_HOME=${ORACLE_BASE}/11gR1/dbexport ORACLE_SID=+ASM24function repair_dg(){sqlstr="alter diskgroup $2 check DISK "x=`expr $1 * 8`i=`expr $x - 8`if [ $1 -eq 9 ];then j=70else j=`expr $x - 1`fiwhile ((i<=j))do if [ $i -eq $j ];then flag=`printf '%04d' $i` sqlstr1=$sqlstr" DATA_"$flag ((i=i+1)) continue fi flag=`printf '%04d' $i` sqlstr=$sqlstr" $2_"$

ronon在执行入库任务时遇到这个事件,它是一个idle event.按通常的理解，idle event一般说明不了问题,但具体问题还要具体分析. 这样可以查到所有空闲事件grep -i "STATS$IDLE_EVENT" /oracle/app/11gR1/db/rdbms/admin/spctab.sql相关链接.[@more@]

DW由于下面kxfplsig_serial错误导致所有节点全部重启Thu Nov 19 17:55:08 2009Errors in file /oracle/app/admin/diag/rdbms/start/start12/trace/start12_lck0_2507.trc:ORA-00600: internal error code, arguments: [kxfplsig_serial], [], [], [], [], [], [], [], [], [], [], []LCK0 (ospid: 2507): terminating the instance due to error 480System state dump is made for local instanceSystem State dumped to trace file /oracle/app/admin/diag/rdbms/start/start12/trace/start12_diag_1944.trcInstance terminated by LCK0,

Bug 5402988: DATAPUMP EXPORT FAILS ORA-31655[@more@]SQL> select count(*) from database_block_corruption_bak2; COUNT(*)---------- 396540create directory dmpdir as '/home/oracle/kyte';expdp "sys/xxx@dwdbetl as sysdba" DUMPFILE=database_block_corruption_bak2.dmp DIRECTORY=dmpdir TABLES=(sys.database_block_corruption_bak2)日志如下:Export: Release 11.1.0.7.0 - 64bit Production on Thursday, 19 November, 2009 15:17:23Copyright (c) 2003, 2007, Oracle. All rights reserved.Connected to:

闲来无事,想算一下我们的dw有多少数据量(不看最大表记录条数，或总共有多少记录行),只看segment占用了多少bytesSQL> select sum(BLOCKS) from seg$;SUM(BLOCKS)----------- 1.9352E+10由于是8k的block,算下来有144.183635711669921875TB这不包括cf,redo,archive.基于oracle rac这个量级的数据量在亚洲不知能否进前10名? [@more@]

在ASM中，如果数据字典数据有不一致的地方，可能会引一系列问题:1. datafile resize时无法从asm diskgroup分配空间 diskgroup中的disk的free space显示是假的,实际上可能并不均衡,所以无法分配空间2,在diskgroup上做rebalance操作时，可能会导致asm instance中断.所以，有必要定期检查metadata是否有不一致的地方.check_diskgroup_clauseThe check_diskgroup_clause lets you verify the internal consistency of Automatic Storage Management disk group metadata. The disk group must be mounted. Automatic Storage Management di

Information to gather when diagnosing ASM space issues [ID 351117.1][@more@]Information to gather when diagnosing ASM space issues [ID 351117.1] 修改时间 26-SEP-2008 类型 TROUBLESHOOTING 状态 PUBLISHED In this Document Purpose Last Review Date Instructions for the Reader Troubleshooting DetailsApplies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7Information in this document applies to any platform.ASM 10.X.X.X PurposeThis is a guide to provide all the infor

ASM Diskgroup Unbalanced, Dropping Disk Fails With ORA-15041, And Disk Becomes HUNG [ID 452897.1][@more@]ASM Diskgroup Unbalanced, Dropping Disk Fails With ORA-15041, And Disk Becomes HUNG [ID 452897.1]修改时间 13-MAR-2008 类型 PROBLEM 状态 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 E

SQL> alter database tempfile '/oracle/app/oradata/bic/temp01.dbf' resize 33G;alter database tempfile '/oracle/app/oradata/bic/temp01.dbf' resize 33G*ERROR at line 1:ORA-01144: File size (4325376 blocks) exceeds maximum of 4194303 blocks$oerr ora 114401144, 00000, "File size (%s blocks) exceeds maximum of %s blocks"// *Cause: Specified file size is larger than maximum allowable size value.// *Action: Specify a smaller size.在db_block_size=8192时，最大块数是4194303 大概是32GBSQL>

在遇到下述错时，如果是index,直接drop掉index重建就ok,如果是table一般有两种解决方法 (关于判断块所在对像的类型,见另一个贴子)[@more@]Wed Nov 18 15:16:17 2009Errors in file /oracle/app/admin/diag/rdbms/start/start10/trace/start10_p004_13490.trc (incident=2152710):ORA-01578: ORACLE 鏁版嵁鍧楁崯鍧?(鏂囦欢鍙?5782, 鍧楀彿 85299)ORA-01110: 鏁版嵁鏂囦欢 5782: '+NL02/start/datafile/isdh03m200907090'ORA-26040: 鏁版嵁鍧楁槸浣跨敤 NOLOGGING 閫夐」鍔犺浇鐨?Incident details in: /oracle/app/admin/diag/rdbms/start

今天ronon在etl帐号下创建下述过程,查询分区表的分区键数据类型,发现执行过程时出错, 而etl帐号是有dba角色的.关键点：在PL/SQL里面select 表的权限需要单独赋予的。即使你是DBA用户 (不能依赖于role-based privileges), 更深一层的原因以后给出.所以，语句中如果引用了其它帐号的对像，一定要注意这一点.[@more@]SQL> col GRANTEE for a10SQL> col GRANTED_ROLE for a15SQL> SQL> select grantee,GRANTED_ROLE,ADMIN_OPTION,DEFAULT_ROLE from DBA_ROLE_PRIVS where grantee in('ETL') order by grantee;GRANTEE GRANTED_ROL

it is possible for a query to allocate too much memory executing a hash join over large volumes of data with few distinct join key values. The impact on 64-bit systems is greater. This is not really a memory leak as the fix only makes the query to spill to disk earlier. Workaround: set "_pga_max_size" [@more@]https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=Bug%205947623%20-%20Excess%20PGA%20memory%20used%20

在执行hash group by 查询时,经常报not free slot伴随ORA-32695错误, 这是由于11.1.0.7中存在bug6471770 ,是由于大表hash join group by时超出了自动内存管理器分配的内存的限制.[@more@]在执行hash group by 查询时,经常报not free slot伴随ORA-32695错误, 这是由于11.1.0.7中存在bug6471770 https://support.oracle.com/CSP/ui/flash.html#tab=KBHome(page=KBHome&id=()),(page=KBNavigator&id=(bmDocTitle=Bug%206471770%20-%20ora-32690/OERI%20%5B32695%5D%20%5Bhash%20aggregation%20can't%20be%20done%5D%20from%20Hash%20

select fe.inst_id,       fe.fenum,       to_number(fe.fecrc_scn),       to_date(fe.fecrc_tim,'MM/DD/RR HH24:MI...

 REDHAT EL AS5 下 RAW 裸设备AS5 和AS4 的方法完全不同AS5设置重新启动自动挂载裸设备vi /etc/udev/rules.d/60-raw.rulesACTION=="add", KERNEL=="sdd1", RUN+="/bin/raw /dev/raw/raw1 %N"ACTION=="add", KE...

在configure时不用prefix指定安装路径root@C2C34_122_sles10:/usr/local/lib# ls -lht-rw-r--r-- 1 root root   97K Jun  3 13:46 libbind9.a-rw-r--r-- 1 root root  210K Jun  3 13:46 ...

admin@monitor_sh_201:/> find /data1 /data2 /data3 /data4 /data5 /data6 /data7 /data8 ! -path "/data1/DB_BAK_SYSTEM/*" ! -path "/data1/Binlog_Bak/*" -a -name "*20090527*.tgz" 上面，从/data1-->/d...