ITPub博客

1． 以root用户修改/etc/lvmrc文件 对应需要做成共享的VG，先要求关闭其开机自动active的设置。你必须保证这些VG在SG启动的时候激活。        备份/etc/lvmrc文件   &n...

前天对Oracle 10g上一组表进行shrink space操作，其中一个表为Hash分区，6个global索引，大小约为5G。操作……5个小时后完成，archive空间满。处理……再用logminer查看archive log，大量的delete和insert操作，...

root@redhat7 root]# echo 1 > /proc/sys/net/ipv4/icmp_echo_ignore_all 如果要恢复，只要： [root@redhat7 root]# echo 0 > /proc/sys/net/ipv4/icmp_echo_ignore_all 即可，挺方便，不要去专门使用ipchains或者iptables了。 以root进入Linux系统，然后编辑文件icmp_echo_ignore_allvi /proc/sys/net/ipv4/icmp_echo_ignore_all将其值改为1后为禁止PING将其值改为0后为解除禁止PING[@more@]

1. 创建VPD策略用户VPD，测试用户ALEXSQL> create user vpd2 identified by vpd3 default tablespace users4 temporary tablespace temp5 /User created.SQL> create user alex2 identified by alex3 default tablespace users4 temporary tablespace temp5 /User created.[@more@]2. 给VPD，ALEX授权SQL> grant connect,resource to vpd,alex;Grant succeeded.SQL> grant execute on dbms_rls to vpd;Grant succeeded.SQL> grant select on scott.emp to alex,vpd;Grant succeeded.3. 在VPD用户下，创建策略规则表SQL>

1. 做一次RMAN的数据库全备C:>rman target /Recovery Manager: Release 10.2.0.1.0 - Production on 星期一 8月 27 13:58:37 2007Copyright (c) 1982, 2005, Oracle. All rights reserved.connected to target database: ALEX (DBID=1906837469)RMAN> run{2> allocate channel c1 type disk;3> backup full tag 'FullBackup' format 'd:ora_bakALEX_%U.dbf' database include current controlfile;4> sql 'alter system archive log current';5> release channel c1;6> }[@more@]released channel: ORA_DISK_1alloca

Event 10013 - Monitor Transaction RecoveryThis event can be used to trace transaction recovery during startup For example ALTER SESSION SET EVENTS'10013 trace name context forever, level 1';Event 10015 - Dump Undo Segment HeadersThis event can be used to dump undo segment headers before and after transaction recovery For example ALTER SESSION SET EVENTS'10015 trace name context forever, level 1';Event 10032 - Dump Sort StatisticsThis event can be used to dump sort statistics. Level 10 is the mos

10000 control file debug event, name 'control_file'10001 control file crash event110002 control file crash event210003 control file crash event310004 control file crash event410005 trace latch operations for debugging10006 testing - block recovery forced10007 log switch debug crash after new log select, thread %s10008 log switch debug crash after new log header write, thread %s10009 log switch debug crash after old log header write, thread %s10010 Begin Transaction10011 End Transaction10012 Abor

1. 创建测试用的BLOCK表空间SQL> create tablespace block2 datafile 'D:ORACLEPRODUCT10.2.0ORADATAALEXBLOCK.DBF'3 size 1M;Tablespace created.2. 创建测试用户SQL> create user alex2 identified by alex3 default tablespace block4 temporary tablespace temp;User created.SQL> alter user alex quota unlimited on block;User altered.SQL> grant connect,resource,dba to alex;Grant succeeded.[@more@]3. 插入数据SQL> conn alex/alexConnected.SQL> create table t as select * from dba_users;Table create

环境：HP-UX(11.11) ServiceGuard数据库：Oracle 10.2.0.3 RACalert_log中发现：ORA-1461 encountered when generating server alert SMG-3500METALINK中，说是Oracle的一个bug。造成这个问题的原因SMON进程在更新SMON_SCN_TIME表时，引发了ORA-1461错误。如果设置了EVENT：1461 TRACE NAME ERRORSTACK LEVEL 10，从后台SMON进程日志中可以看到下面的信息：ORA-01461: can bind a LONG value only for insert into a LONG column Current SQL statement for this session: update smon_scn_time set orig_thread=0, time_mp=:1, time_dp=:

25岁，对工作有一点点失望，再也没有了刚出道时的憧憬：有一点点茫然，我的未来在哪里？我应该做什么？前不见少年情怀、后不见锦绣前程，拔剑四顾心茫然，如同婚姻中的七年之痒，你的职业发展遭遇了“三年之痒”。 什么是“三年之痒”？就是在25岁左右的时候，无法找到自己的人生定位。 [@more@]“三年之痒”的症候包括 紧迫感　年轻就是本钱，长一岁，资本就会少一分，过了25岁，30岁转眼将至，不抓住现在的机会和年龄，往后不可想象。 焦虑感　飘来荡去绕了一大圈又回到起点，而青春已然不在的话，如何在竞争激烈的社会中生存下来？ 茫然

本文从不绑定变量与绑定变量两种情况讨论柱状图的作用。一、不绑定变量的情况：考虑以下数据SQL> select owner,count(1) from th group by owner;OWNER COUNT(1)------------------------------ ----------SUK 1SYS 36216SYSTEM 1其中，在表的OWENR上建立有一个索引做普通分析后，执行查询SQL> analyze table th compute statistics;Table analyzedSQL> select * from th where owner='SYS';已选择36216行。[@more@]Execution Plan----------------------------------------------------------0 SELECT STATEMENT Optimizer=CHOO

1.继续前一篇的内容，查看db_file_multiblock_read_count对全表扫描读取blocks的变化SQL> create tablespace aluocp datafile '/disk3/oradata/oradata/ora7a/aluocp.dbf' size 100M 2 extent management local uniform size 256K; Tablespace created. SQL> alter table t move tablespace aluocp; Table altered. [@more@]SQL> select file_id,block_id,blocks from dba_extents where segment_name='T'; FILE_ID BLOCK_ID BLOCKS ---------- ---------- ---------- 4 9 32 4 41 32 4 73 32 SQL> show parameter read_count

1.创建测试用表TSQL> create table t as select * from dba_objects;Table created. 2.查看T表的Block号和Block数量SQL> select file_id,block_id,blocks from dba_extents where segment_name='T';[@more@]FILE_ID BLOCK_ID BLOCKS ---------- ---------- ---------- 3 5025 8 3 5033 8 3 5041 8 3 5049 8 3 5057 8 3 5065 8 3 5073 8 3 5081 8 3 5089 8 3 5097 8 10 rows selected. 3.开启10046 event trace跟踪当前sessionSQL> alter session set events '10046 trace name context forever,level 12';Session altered. 4.执行

1. 设置session变量：C:>set ORACLE_SID=TESTC:>set nls_date_format=yyyy-mm-dd hh24:mi:ss2. 做一次RMAN的全备：C:>rman target / nocatalog恢复管理器: 版本10.1.0.2.0 - ProductionCopyright (c) 1995, 2004, Oracle. All rights reserved.已连接到目标数据库 (未启动)[@more@]RMAN> startup mountOracle 例程已启动数据库已装载系统全局区域总计 125829120 字节Fixed Size 787788 字节Variable Size 108001972 字节Database Buffers 16777216 字节Redo Buffers 262144 字节RMAN> backup database;启动 backup 于 2007

准备工作:1.启用归档在主库上的每个节点都要设置，注：在一台机器设置归档时其他的节点实例都要关闭sqlplus /nologSQL>conn /as sysdbaSQL > alter system set log_archive_dest_1 = "location=<文件位置>"SQL > alter system set log_archive_format='arch_%t_%s_%r.arc' scope=spfile;SQL > shutdown immediateSQL> alter database archivelog;Database altered.SQL> archive log startStatement processed.SQL> alter database openDatabase altered.SQL> archive log listDatabase log mode

$ ipcs -mb IPC status from <running system> as of Mon Feb 19 14:48:26 EST 2001 T ID KEY MODE OWNER GROUP SEGSZ Shared Memory: m 105 0xf223dfc8 --rw-r----- ora816 dba 186802176[@more@]

1.查看数据库当前设置SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle9i Enterprise Edition Release 9.2.0.1.0 - ProductionPL/SQL Release 9.2.0.1.0 - ProductionCORE 9.2.0.1.0 ProductionTNS for 32-bit Windows: Version 9.2.0.1.0 - ProductionNLSRTL Version 9.2.0.1.0 - Production[@more@]SQL> show parameter nameNAME TYPE VALUE------------------------------------ ----------- -------------------db_file_name_convert stringdb_name string eyglevg

救急啊！我的环境：HP-UX＋Oracle10gRAC（ServiceGuard＋CRS）两个节点两个节点的private连接为100M网卡[/COLOR] 对等连接最近做数据迁移：在节点一上做IMP在节点二上做数据转换以上不是同时对一个表操作...

我的环境：Oracle 10.2.0.3 RAC我在做大数据量IMP（100G）的时候，crsd.bin狂吃CPU：CPU TTY    PID USERNAME PRI NI   SIZE    RES STATE    TIME %WCPU  %CP...

兄弟我现在有：环境：Oracle8.1.7.4 OPS一个range分区表：create table T(col_a date,col_b number,col_c number,col_d varchar2(20),....)分区键为col_a，现在按年份分了五个区。两个非前缀local索引：...