copx52138384-CSDN博客

转载 aa

http://www.eygle.com/archives/2012/05/oracle_sqlid_hash_value.htmlOracle SQLID 与 Hash_value 算法及转换这两者可以相互...

2013-06-22 14:06:03 87

转载 use of sysaux tablespace

SQL> SELECT D.TABLESPACE_NAME, 2 SPACE || 'M' "SUM_SPACE(M)", 3 BLOCKS "SUM_BLOCKS", 4 SPACE - ...

2013-04-08 13:15:31 112

转载 Missing Grants After Data Pump Import

1.Object privileges for which the import schema is the grantee will not be imported in a schema level im...

2013-03-27 09:28:25 120

转载 hard/soft parse

Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention [ID 62143.1]Hard ...

2013-03-06 15:56:11 95

转载 OPT_PARAM Hint

OPT_PARAM Hint [ID 377333.1]Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2...

2013-03-05 15:53:02 475

转载 v$sql中的LAST_ACTIVE_TIME是解析sql的时间

http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3043.htm#REFRN30246LAST_LOAD_TIMETime at ...

2013-01-23 14:09:13 1046

转载 install instant client

[root@ol354t1123 ~]# useradd -m -g oinstall -G dba oraClient[root@ol354t1123 ~]# passwd oraClientChanging passwo...

2013-01-09 17:06:30 127

转载 create job(gather_stats)

http://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#i4128214.2.1 GATHER_STATS_JOBOptimizer statistics ...

2013-01-09 17:01:47 111

转载 window 下默认链接到指定的数据库

配置环境变量path 和ORACLE_HOMEORACLE_HOME:C:\oracle\product\10.2.0\db_1path :C:\oracle\product\10.2.0\db_1;..........

2013-01-09 16:47:40 84

转载 10g-11g psu

KROWN：132780Oracle Recommended Patches -- Oracle Database [ID 756671.1]11.2.0.1 Patch Set Updates - List of...

2012-12-25 15:52:48 70

转载 rebuild index 时的并行度与表空间free size 的关系

SQL> alter index intest rebuild tablespace test1 parallel(degree 2);Index altered.SQL> alter index intest re...

2012-12-25 15:49:20 170

转载 os kill session

专有服务模式*******session 16*******SQL> select count(*) from utest.tab1; COUNT(*)----------2SQL> select...

2012-12-25 15:47:23 65

转载安装patch

1.关闭数据库shutdown immediate1.解压patch文件[oracle@～ 11.2.0]$ unzip p14402980_112030_Linux-x86-64.zip2.进入pa...

2012-10-14 13:59:00 774

转载查看进程信息和进程对应的job_name

select s.type,p.spid,s.username,s.process,s.machine, s.program from v$session s,v$process p where s.paddr=p.ad...

2012-10-12 11:37:51 552

转载查看隐藏参数

SELECT ksppinm, ksppstvl, ksppdesc FROM x$ksppi x, x$ksppcv y WHERE x.indx = y.indx AND ksppinm = '_eliminate_c...

2012-10-12 11:20:53 142

转载动态注册监听

动态注册1.确定service_names 和 instance_name 两个参数的值QL> show parameter service_namesNAME...

2012-10-10 13:55:04 74

转载收集global partition index 统计信息

在以下版本中使用dbms_stats 收集的信息有误Oracle 9i Release 2 (9.2.0)Oracle Database 10g Release 1(10.1.0)原因是有bugBUG:3491127...

2012-10-10 13:20:46 125

转载开启em

开启em[oracle@dbserver ~]$ emctl start dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.2.0Cop...

2012-09-06 14:44:25 109

转载分区索引的logging属性

创建没指定logging_clause 的分区索引SQL> CREATE INDEX prod_idx ON hash_products(category_id) LOCAL STORE IN (tbs_01, test_...

2012-09-06 09:11:09 509

转载修改归档模式

查看归档模式SQL> archive log list修改归档模式SQL> startup mountSQL> alter database archivelog;SQL> alter databas...

2012-09-04 17:24:03 75

转载扩展表空间

Increasing the Size of a Tablespacehttp://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces007.htm#BABDFCAE...

2012-09-04 16:24:07 62

转载生成statspack 报告

安装 statspackSQL> create tablespace test_pace datafile '/ora10/base/oradata/tid002/test_pace01.dbf' size 250m ex...

2012-09-04 16:00:55 191

转载 trace文件跟踪sql语句

跟踪sql语句开启一个新sessionSQL> exec dbms_session.set_sql_trace(true);PL/SQL procedure successfully completed.SQL...

2012-09-04 15:59:09 94

转载根据AWR报告中sql_id查看sql执行的时间段和对应的快照时间段

SQL> create table t01 as select * from dba_objects;Table created.手动创建快照SQL> exec DBMS_WORKLOAD_REPOSITORY....

2012-09-04 15:11:30 653

转载操作系统认证连接远程数据库

How To Implement OS Authentication in Web Forms for a Remote Database Authentication? [ID 577787.1]Configuring a...

2012-08-31 13:47:47 98

转载 DB LINK 的创建和连接时出现的问题

SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Dat...

2012-08-29 13:14:43 126

转载 Oracle Lifetime Support

ORACLE LIFETIME SUPPORT BROCHUREShttp://www.oracle.com/us/support/lifetime-support/lifetime-support-software-34273...

2012-08-27 15:49:56 50

转载 sqlplus 输出格式的设置

set linesize 200 #每行最多显示200个字符，缺省为80set pagesize 0 #设置每页显示的行数，默认是24，设置成0表示不分页set numwidth 5 #设置number类...

2012-08-24 16:55:34 533

转载创建分区表，索引的logging_clause

参考：17 Managing Partitioned Tables and Indexeshttp://docs.oracle.com/cd/B19306_01/server.102/b14231/partiti.htm...

2012-08-24 13:24:12 196

转载清除alert log

1.手动删除log_××.xml，删除文件后oracle会自动创建一个新的log.xml文件。2.使用ADRCI 工具也可以删除alert log。1.在OS中手动删除log_××.xml[oracle@dbse...

2012-08-14 19:53:37 731

转载有相同sql_id的sql语句

1.不同用户执行相同的sql语句1）在同一个数据库中执行'select * from tab01'[oracle@dbserver ~]$ sqlplus u1/u1...

2012-08-14 18:34:54 388

转载缩小表空间（缩小datafile）

1.如何缩小datafileALTER DATABASE DATAFILE '' RESIZE [K|M|G];用这个命令可以缩小datafile的size,从而缩小tablespace的size。2.如何确定resiz...

2012-08-09 20:35:04 233

copx52138384的博客