ITPub博客

1、设置keep池大小SYS@jzh>alter system set db_keep_cache_size=60m;System altered.2、创建测试表JZH@jzh>create table t as select * from dba_objects;Table created.3、查看执行计划JZH@jzh>select * from t;74756 rows selected.Statistics----------------------------------------------------------&nb...

CAUSEEvent 'KSV master wait' indicates the process on the RDBMS side is waiting for a reply from a process on the ASM side.   In 11g, the parameter cell_offload_processing is set to TRUE.  Although that is a parameter is not applicable for non-Exadata databases, it caused ASM to...

1、初始化数据JZH@jzh>create table t as select * from dba_objects;Table created.JZH@jzh>select count(*) from t;  COUNT(*)----------     74756JZH@jzh>select bytes/1024/1024 from dba_segments where segment_name='T';BYTES/1024/1024---------------        ...

1.创建CTXSYS用户以SYS用户执行以下脚本：SQL> connect SYS/password as SYSDBASQL> spool text_install.txtSQL> @?/ctx/admin/catctx.sql change_on_install SYSAUX TEMP NOLOCK各参数含义：change_on_install – 设置ctxsys用户密码SYSAUX – 调置ctxsys用户默认表空间TEMP – 设置ctxsys用户默认临时表空间LOCK...

lsdg中的Usable_file_MB 为什么是负值?Negative Values of USABLE_FILE_MB Due to the relationship between FREE_MB, REQUIRED_MIRROR_FREE_MB, and USABLE_FILE_MB, USABLE_FILE_MB can go negative. Although this is not necessarily a critical situation, it does mean that: Depending on the value of FREE_MB, you may not be able to create new files. The next failure may result in files with reduced redundancy. If USABLE_FILE_MB becomes negative, it is strongly recommended that you a

1、在数据库open的时候，直接删除users表空间中的数据库文件；SYS@jzh>select name from v$dbfile;NAME--------------------------------------------------------------------------------/u01/app/oracle/oradata/jzh/users01.dbf/u01/app/oracle/oradata/jzh/undotbs01.dbf/u01/app/oracle/oradata/jzh/sysaux01.d...

<span style="color:#000000;font-size:14px;">在11g之前的版本中需要我们手动去清理trace文件，11g可以使用工具ADRCI清理，默认情况下由MMON后台进程进行自动清理过期的trace文件，这里涉及两个参数：</span><br /><span style="color:#000000;font-size:14px;"></span><span style="color:#000000;font-size:14px;">LONG...

<span style="color:#000000;font-size:14px;">当克隆一个数据库到另外一台机器上，具有相同的数据库名称或者如果一个新的数据库名称是通过重建的控制文件，</span><br /><span style="color:#000000;font-size:14px;">那么需要改变DBBID，特别是如果是新的数据库在相同的rman catalog是注册。</span><br /><span style=...

1、创建cost目录(所有节点)[root@jzh1 ~]# mkdir -p /u01/app/11.2.0/grid/network/admin/cost2、创建ewallet.p12钱包[oracle@jzh1 ~]$ orapki wallet c...

1、创建测试表空间与用户SYS@TEST>create tablespace spa datafile '/u01/app/oracle/oradata/spa01.dbf' size 100M autoextend on;Tablespace created.

<span style="color:#000000;">The INTERVAL clause of the CREATE TABLE statement establishes interval partitioning for the table. <span style="background-color:#FFE500;">You must specify at least one range partition using the PARTITION clause</span>. The range partitioning key value determines the hig...

<span style="color:#000000;">1、删除或移除</span><span style="color:#000000;">oraInventory目录</span><br /><span style="color:#000000;"></span><span style="color:#000000;">[oracle@jzh5 app]$ mv oraInventory oraInventory_oraig</span><br /><span style="color:#000000;">2、</span><span style="color:#0...

1、创建测试表，初始化数据JZH@jzh>create table t (x number,y number);Table created.JZH@jzh>insert into t values (1,1);1 row created.JZH@jzh>insert into t values (1,1);1 row created.JZH@jzh>insert into t values (2,2);1 row created.JZH@jzh>commit;Commit complete.JZH@jzh>select * from t;&nbs...

测试将手动段管理表空间上的表通过在线重定义迁移至自动段管理表空间1、创建手动段管理表空间，自动段管理表空间SYS@jzh>create tablespace MSSM datafile '/u01/app/oracle/oradata/jzh/mssm01.dbf' size 10M segment space management manual;SYS@jzh>create tablespace ASSM datafile '/u01/app/oracle/oradata/jzh...

近日为某客户做数据库巡检，发现数据库recycle bin中有几千个被删除的对象，于是建议客户清理recycle bin中的对象，释放空间，客户问这些对象占用空间吗？存放在哪里的？这些被删除的对象当然是存放在硬盘上的，官方方档介绍recycle bin 如下：The recycle bin is actually a data dictionary table containing informati...

参考文档：https://blogs.oracle.com/Database4CN/entry/systemstate_dump_介绍    当数据库出现严重的性能问题或者hang了的时候，我们非常需要通过systemstate dump来知道进程在做什么，在等待什么，谁是资源的持有者，谁阻塞了别人。在出现上述问题时，及时收集systemstate dump非常有助于问题原因的分析。...

1、查看jzh用户下对象JZH@jzh>select * from tab;TNAME                          TABTYPE  CLUSTERID------------------------------ ------- ----------JZH1                       ...

enq:TM-contention等待的发生，发生TM锁争用的情况如下：        1、修改无索引外键(foreign key)的父键时    2、DML与DDL之间的TM争用    3、LOCK TABLE 引起的TM锁争用    4、direct load工作引起的TM锁争用模拟该等待事件1、创建两张测试表JZH@jzh>crea...

查询阻塞与被阻塞SQL语句，供参考：select b.sid,       a.sql_id,       a.sql_text,       a.hash_value,       b.username,       b.machine,       a.module,      ...

环境介绍单实例                                      RAC数据库OEL+Oracle 11.2.0.3               OEL+Oracle 11.2.0.31、备份单实例数据库run {backup as compressed backup...