-
编辑 删除
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...
