摘要：
Reverse Key IndexesCreating a reverse key index, compared to a standard index, reverses the bytes of each column indexed (except the rowid) while keep... 阅读全文
摘要：
首先:oracle有自动Job,进行shrink spaceSQL> select client_name,status from dba_autotask_client;CLIENT_NAME STATUS--------------------------------------... 阅读全文
摘要：
SQL> select department_namefrom hr.departments deptwhere department_id IN (select department_id from hr.employees emp); 2 3 DEPARTMENT_NAME-----... 阅读全文
摘要：
SQL> select substr(xx.acct_no,1,5) agent_org, xx.vou_kind,sum( xx.trans_amt) trans_amt from ( ... 阅读全文
摘要：
FIELD DESCRIPTION FOR VM MODE Procs r: The number of processes waiting for run time.表示运行队列,就是说多少个进程真的分配到CPU b: The number of processes i... 阅读全文
摘要：
sar -n DEV 1 10 -n { keyword [,...] | ALL } Report network statistics. IFACE Name of the network interface for which ... 阅读全文
摘要：
我们先来看看 library cache: mutex X 。 是个什么东西 The library cache mutex is acquired for similar purposes that the library cache latches were acquired in pr... 阅读全文
摘要：
SQL> conn cowork_czsh/cowork_czshConnected.SQL> set linesize 200SQL> set pagesize 200SQL> set autot traceSQL> select workitemhi0_.PERFORMER as col_0_0... 阅读全文
摘要：
This latch comes into play when user processes are attempting to access or update the cached data dictionary values.SolutionsProblem:To determine if t... 阅读全文
摘要：
TRANSLATE(expr, from_string, to_string)from_string 与 to_string 以字符为单位，对应字符一一替换。SQL> SELECT TRANSLATE('ab你好abcdefg', 'abcdefg', '1234567') AS NEW_STR ... 阅读全文