ITPub博客

Oracle各个版本分区的变化11g新特性1.      引用分区 现在，可以根据表的引用约束条件中引用的此表的分区方法对表进行分区。? 分区键是通过现有的父/子关系解析的。? 分区键是由活动的主键和外键约束条件强制实施的。? 包含父/子关系的表可以通过从父...

VG 命令 显示卷组状态列出卷组细节: lsvg <vgname>列出卷组中的逻辑卷: lsvg -l <vgname>列出卷组中的物理卷: lsvg -p <vgname>增加卷组命令:smitty mkvg修改卷组属性smittychvg激活/解除卷组激活卷组（使其可用） varyonvg vg_name...

SELECT rowid,       DBMS_ROWID.Rowid_object(ROWID) "OBJECT",       DBMS_ROWID.Rowid_relative_fno(ROWID) "FILE",       DBMS_ROWID.Rowid_block_number(ROWID) "BLOCK",       DBMS_ROWID.Rowid_row_number(ROWID) "ROW"&nbsp...

JDBC-THINdriver supports Fast Connection Failover (FCF)JDBC-THIN驱动支持FCFJDBC-OCIdriver supports Transparent Application Failover (TAF)JDBC-OCI 支持TAFJDBC-THIN11gR2 supports Single Client Access Name (SCAN)JDBC-THIN11gR2支持 SCANJDBC-OCI 支持TAF 在DocID 2974...

10g可以用dbca 来配置TAF 11.2以后只能通过命令和EM方式来实现,命令方式试验结果如下:1 创建TAF服务srvctladd service -d orcl -s orcl_taf -r "orcl1,orcl2" -P BASIC2 启动TAF服务srvctlstart service -d orcl -s orcl_taf 3 修改service 参数...

  TOM 大师的show_space 存储过程脚本create or replace procedure show_space( p_segname_1 in varchar2,p_owner_1 in varchar2default user,p_type_1 in varchar2 default 'TABLE',p_space in varchar2 default 'AUTO',p_analyzed in varchar2default '...

Oracle Database - Enterprise Edition - Version 10.2.0.4 and laterInformation in this document applies to any platform.***Checked for relevance on 21-Jan-2014***SYMPTOMSOn : 10.2.0.4 version, STORAGEASM failed to start after server reboot, the disk group can not mount,If you try t...

安装从http://netperf.org/netperf/下载 netperfunzipnetperf-2.6.0.zipcd netperf-2.6.0./configureMakeMake install命令行参数netperf [global options]-- [test-specificoptions]这里我们只解释那些常用的命令行参数，其它的参数读者可以查询man手册。-H...

 1. Create pfile of lost database , from database alert.log startup messages.2. Startup database in nomount3. Get the controlfile number from db alert log , it will show while starting the database here in this eg. its 256eg., control_files='+DATA/orcl/controlfile/current.256.709676643'I...

KFOD KFOD 可以从系统级别发现ASM实例 及查看磁盘信息[grid@oracle10g~]$ kfod -help_asm_a/llow_only_raw_disks              KFOD allow only raw devices[_asm_allow_only_raw_disks=TRUE/(FALSE)]...

Flashback database  相关参数1  db_recovery_file_dest：指定闪回恢复区的位置2 db_recovery_file_dest_size：指定闪回恢复区的可用空间大小3 db_flashback_retention_target：指定数据库可以回退的时间，单位为分钟闪回日志保留策略1 如果闪回恢复区足够...

ORA-1122:database file %s failed verification checkORA-1110 : datafile : ORA-1207: ORA 1207 file is more recent thancontrol file 该错误表明:数据文件头部信息与控制文件信息部一致,数据文件头部CHECKPOINT大于controlfileCHECKPOINT,需要重建控制文件...

Disk groups specified in the ASM_DISKGROUPS initialization parameterDisk group used by Cluster Synchronization Services (CSS) for voting filesDisk groups used by Oracle Clusterware for Oracle Cluster Registry (OCR)Disk group used by th...

1.      Export/ Import

配置ORACLE RAC 由于盘符不一致造成失败是最常见的故障之一,所以在准备阶段检测各个节点的相同盘符对应的是不是同一个lun就是必须的一个步骤,判断是否是同一个的方法就是查询lun id 或wwid进行对比,以下总结了各种系统下查询lun ID的方法AIX方式一:# lscfg-l hdisk*   hdisk2  &nb...

Dead connections  ,但是进程再服务断依然在服务器断运行:(如防火墙Dead Connections,需要开启DCD 开启后(SQL*NET)会定期发送一个探测包到客户端,这个包将被丢弃,服务端会受到一个错误 开启sqlnet.ora文件中添加SQLNET.EXPIRE_TIME = 10INACTIVE Sessions保持连接并且进程状态是INACTIVE...

global cache cr request/gc current requestThe session is waiting for all pending lock operations on the lock elements (le) attached to a lock context to complete. The session sits in a loop until all requests are complete, and this wait event is effectively a poll interval while waiting.The event ...

临时表空间使用情况 A.tablespace_name , D.mb_total, (A.used_blocks * D.block_size) / / mb_used,SUM10241024FROM( B.name, C.block_size, (C.BYTES) / / mb_total v$tablespace B, v$tempfile C B.ts#= C.ts# B.name, C.block_size...

1.      最新OPatch下载地址https://updates.oracle.com/download/6880880.html2.      安装grid@node1~]$ /u01/app/11.2.0/grid/OPatch/opatch -helpInvokingOPatch 11.1.0.6.6 OracleInterim Patch Ins...

ADRCI 作用 ADR中的诊断数据2 查看Oracle Support诊断信息包含: incident ， problem， tracefiles, dumps, health monitor reports等帮助,展示adrci相关命令adrci>help  HELP [topic]   Available Topics:  &nbs...