ITPub博客

检查点和日志的活动部分 SQL Server 2005 其他版本 SQL Server 2008 R2 SQL Server 2008 检查点将脏数据页从当前数据库的缓冲区高速缓存刷新到磁盘上。这最大限度地减少了数据库完整恢复时必须处理的活

C:>sqlplus scott/aaaaaaSQL*Plus: Release 11.1.0.6.0 - Production on Fri Aug 19 10:27:42 2011Copyright (c) 1982, 2007, Oracle. All rights reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - ProductionWith the Partitioning, OLAP, Data Mining and Real Application Testing optionsSQL> desc scott.dept Name Null? Type ----------------------------------------- -------- ---------------------------- DEPTNO

版本：hpux 11.31# bdfFilesystem kbytes used avail %used Mounted on/dev/vg00/lvol3 10485760 167728 10237488 2% //dev/vg00/lvol1 5242880 323008 4881520 6% /stand/dev/vg00/lvol8 8912896 4774920 4105728 54% /var/dev/vg00/lvol7 5373952 2948016 2407008 55% /usr/dev/vg00/oracle11g 20971520 7034750 13073407 35% /u02/dev/vg00/lvol4 6160384 1020184 5102024 17% /tmp/dev/vg00/lvol6 8257536 4998072 3234032 61% /opt/dev/vg00/lvol5 8192000

oracle环境为:oracle 11.2.0.2 SQL> set pages 1000SQL> set line 200SQL> spool /tmp/info.htmlSQL> set markup html onSQL> select JOB_NAME, SCHEDULE_NAME,START_DATE,REPEAT_INTERVAL from dba_SCHEDULER_JOBS;SQL> set markup html offSQL> spool off[@more@]

sp_helpconstraint tablename sp_helpindex tablename[@more@]

The Bequeath Protocol Adapter [ID 16653.1][@more@]

(1) Introduction to SQL*Net/Net8 on UNIX [ID 16652.1][@more@]

RAC Connection Redirected To Wrong Host/IP ORA-12545 [ID 364855.1] 修改时间 16-APR-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Cause Solution References Applies to: Oracle Net Services - Version: 9.2.0.8.0 to 11.1.0.7.0 - Release: 9.2 to 11.1Information in this document applies to any platform. Checked for relevance on 9-APR-2010. Symptoms When we try to connect to a RAC service nam

RAC的告警日志文件：枯荣长老(81637693) 2011-8-16 8:55:11CRS logs are in $ORA_CRS_HOME/log/<hostname>/crsd/CSS logs are in $ORA_CRS_HOME/log/<hostname>/cssd/EVM logs are in $ORA_CRS_HOME/log/<hostname>/evmd $ORA_CRS_HOME/evm/log/Resource specific logs are in $ORA_CRS_HOME/log/<hostname>/racg and the $ORACLE_HOME/log/<hostname>/racgSRVM logs are in $ORA_CRS_HOME/log/<hostname>/client and the $ORACLE_HOME/log/<hostname>/clientCluster Network Communication lo

alter system set RESOURCE_LIMIT=true; --立即生效添加一个oracle profile ，idle time 设置为1分钟新建一个user，赋予connect和resource 权限，此user使用刚刚建立的profile用此user登录sqlplus，不执行任何的命令，放置在那里即可select * from v$session where 条件是此用户，主要查看status列，一开始是inactive，后来是sniped等status状态变为sniped之后，去执行一条sql,就会报提示，SQL> select * from user_tables where 1=2;select * from user_tables where 1=2*第 1 行出现错误:ORA-02396: 超出最大空闲时间, 请重新连接此时

This issue is fixed in10.2.0.4 (Server Patch Set) 11.1.0.7 (Server Patch Set)[@more@]

select * from database_properties 能查询默认表空间类型，默认的临时表空间名称等select * from database_compatible_levelselect * from database_export_objects [@more@]

select * from dba_extentsDROP Datafile And Its Restrictions [ID 781225.1][@more@]k

DROP Datafile And Its Restrictions [ID 781225.1] 修改时间 22-MAR-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1Information in this document applies to any platform. Goal How to drop a datafile from a tablespace and what are its restrictions ?. Solution From 10g onwards we have a option to

修改时间 12-AUG-2011 类型 HOWTO 状态 PUBLISHED In this Document Goal Solution References Applies to: Oracle Server - Enterprise Edition - Version: 10.1.0.2 to 11.1.0.7 - Release: 10.1 to 11.1Information in this document applies to any platform. ***Checked for relevance on 27-Feb-2011*** Goal Is there any list of limits when configuring an ASM instance ? Solution ASM imposes the following limits:63 disk groups in a storage system10,0

ORA-15196 WITH ASM DISKS LARGER THAN 2TB [ID 736891.1]此问题是bug，此问题在The fix prevents using disks larger than 2TB and is included in the following patchsets: 10.2.0.4 11.1.0.7 被修复。准确的说，asm disk 大小超过2t并且在超过2t的空间中分配空间时报错ORA-15196[@more@]

Master Note for Automatic Storage Management (ASM) [ID 1187723.1] 修改时间 12-AUG-2011 类型 ANNOUNCEMENT 状态 PUBLISHED In this Document What is being announced? What do you need to do? Automatic Storage Management (ASM) Alerts: Automatic Storage Management (ASM) Concepts and Overview: Automatic Storage Management (ASM) Installation: Automatic Storage Management (ASM) Configuration: Auto

Diskgroup resource shows status offline after restart even it is mounted in ASM instance [ID 1065158.1] 修改时间 28-FEB-2010 类型 PROBLEM 状态 PUBLISHED In this Document Symptoms Changes Cause Solution References Applies to: Oracle Server - Enterprise Edition - Version: 11.2.0.1.0 - Release: 11.2Information in this document applies to any platform. Symptoms After restart the 11.2 HAS stack, the di

ALERT.LOG for ASM Shows "WARNING: failed to online diskgroup resource ora.GI.dg (unable to communicate with CRSD/OHASD)" [ID 1060920.1] 修改时间 12-AUG-2011 类型 PROBLEM 状态 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

select owner,constraint_name, constraint_type, table_name, delete_rule from DBA_constraints WHERE table_name='ZWKMZD'列delete_rule的返回结果若是为CASCADE ，就表示是级联删除[@more@]