-
编辑 删除
aa
http://www.eygle.com/archives/2012/05/oracle_sqlid_hash_value.htmlOracle SQLID 与 Hash_value 算法及转换这两者可以相互转换，在Oracle 10g中，提供了一个包函数，用于转换：SQL> select sql_id,hash_v...
-
编辑 删除
use of sysaux tablespace
SQL> SELECT D.TABLESPACE_NAME, 2 SPACE || 'M' "SUM_SPACE(M)", 3 BLOCKS "SUM_BLOCKS", 4 SPACE - NVL (FREE_SPACE, 0) || 'M' "USED_SPACE(M)", 5 ROU...
-
编辑 删除
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 import.2.Only object privileges granted by the import schema will be imported.3.a full exp...
-
编辑 删除
hard/soft parse
Troubleshooting: Tuning the Shared Pool and Tuning Library Cache Latch Contention [ID 62143.1]Hard ParseIf a new SQL statement is issued which does not exist in the shared pool then this h...
-
编辑 删除
OPT_PARAM Hint
OPT_PARAM Hint [ID 377333.1] Applies to: Oracle Database - Enterprise Edition - Version 10.2.0.1 to 11.2.0.3 [Release 10.2 to 11.2]Information in this document applies to any platform.Go...
-
编辑 删除
v$sql中的LAST_ACTIVE_TIME是解析sql的时间
http://docs.oracle.com/cd/E11882_01/server.112/e25513/dynviews_3043.htm#REFRN30246LAST_LOAD_TIMETime at which the query plan was loaded into the library cacheLAST_ACTIVE_TIMETIme at which the ...
-
编辑 删除
install instant client
[root@ol354t1123 ~]# useradd -m -g oinstall -G dba oraClient[root@ol354t1123 ~]# passwd oraClientChanging password for user oraClient.New UNIX password:BAD PASSWORD: it is based on a dictionary wordR...
-
编辑 删除
create job(gather_stats)
http://docs.oracle.com/cd/B19306_01/server.102/b14211/stats.htm#i4128214.2.1 GATHER_STATS_JOBOptimizer statistics are automatically gathered with the job GATHER_STATS_JOB. This job gathers statistics ...
-
编辑 删除
window 下默认链接到指定的数据库
配置环境变量path 和ORACLE_HOME ORACLE_HOME:C:\oracle\product\10.2.0\db_1path :C:\oracle\product\10.2.0\db_1;........path环境变量中ORACLE_HOME一定在最前面 通过上面的配置在cmd中执行 sqlp...
-
编辑 删除
10g-11g psu
KROWN：132780Oracle Recommended Patches -- Oracle Database [ID 756671.1] 11.2.0.1 Patch Set Updates - List of Fixes in each PSU [ID 1340010.1]Document Version Download link 12419378 11.2.0.1....
-
编辑 删除
rebuild index 时的并行度与表空间free size 的关系
SQL> alter index intest rebuild tablespace test1 parallel(degree 2);Index altered.SQL> alter index intest rebuild tablespace test1 parallel(degree 3);Index altered.SQL> alter index intest rebuild tabl...
-
编辑 删除
os kill session
专有服务模式*******session 16*******SQL> select count(*) from utest.tab1; COUNT(*)----------2SQL> select * from tab1; ID----------21开始一个...
-
编辑 删除
安装patch
1.关闭数据库shutdown immediate 1.解压patch文件[oracle@～ 11.2.0]$ unzip p14402980_112030_Linux-x86-64.zip 2.进入patch目录下[oracle@～ 11.2.0]$ cd 14402980 3.安装patch[oracle@...
-
编辑 删除
查看进程信息和进程对应的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.addr; select owner, job_name, session_id, slave_os_process_id, running_i...
-
编辑 删除
查看隐藏参数
SELECT ksppinm, ksppstvl, ksppdesc FROM x$ksppi x, x$ksppcv y WHERE x.indx = y.indx AND ksppinm = '_eliminate_common_subexpr'; note:315631.1 A1: The hidden parameters start with a...
-
编辑 删除
动态注册监听
动态注册1.确定service_names 和 instance_name 两个参数的值QL> show parameter service_namesNAME &nb...
-
编辑 删除
收集global partition index 统计信息
在以下版本中使用dbms_stats 收集的信息有误Oracle 9i Release 2 (9.2.0)Oracle Database 10g Release 1(10.1.0)原因是有bugBUG:3491127在Oracle Database 10g Release 2(10.2.0)中修复SQL> create table test&...
-
编辑 删除
开启em
开启em[oracle@dbserver ~]$ emctl start dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.2.0Copyright (c) 1996, 2010 Oracle Corporation. All rights reserved.https://dbserver...
-
编辑 删除
分区索引的logging属性
创建没指定logging_clause 的分区索引SQL> CREATE INDEX prod_idx ON hash_products(category_id) LOCAL STORE IN (tbs_01, test_space);Index created.查看 user_indexes 视图的logging值是空，user_indexes...
-
编辑 删除
修改归档模式
查看归档模式SQL> archive log list修改归档模式SQL> startup mountSQL> alter database archivelog;SQL> alter database open;SQL> archive log listDatabase log mode  ...
