- 博客(16)
- 资源 (2)
- 收藏
- 关注
原创 learning v$ view->v$sysstat
V$SYSSTATV$SYSSTAT stores instance-wide statistics on resource usage, cumulative since the instance was started.Similar to V$SESSTAT
2011-09-30 08:57:19 848
原创 Oracle10g ASM tesing
according Oracle10gR1.Step.By.Step.by.Kamus CSS(Cluster Synchronization Services) # cd /etc/rc3.d[rc5.d]# ln -s ../init.d/oracleasm
2011-09-29 11:11:11 570
原创 can not use backspace button in sqlplus
before run sqlplus execute the #stty erase ^h
2011-09-29 08:58:56 620
原创 ORA-29701 :unable to connect to Cluster Manager
OS:Linux RHEL 4 AS Version:10.2.0.1SYMTOM:When startup the ASM instance, an error was encountered.CauseConnect to CM failed or
2011-09-28 13:45:04 967
原创 learning v$ view-> v$sqltext&v$sqlarea
V$SQLTEXTThis view contains the complete SQL text for the SQL statements in the shared pool.Note:V$SQLAREA only contains only the first 1000 characters.Useful Col
2011-09-28 08:49:40 762
原创 website
ORACLE ASMLIB http://www.oracle.com/technetwork/server-storage/linux/downloads/index-088143.html LINUX KERNELhttp://www.planetmir
2011-09-27 13:22:53 523
原创 learning v$ view-> v$sql & V$sql_plan
V$SQLA SQL statement can map to multiple cursors, because the objects referred to in the cursor can differ from user to user. If there a
2011-09-26 09:12:25 1196
原创 ORA-01185 logfile group number *** is invalid
SELECT *FROMv$controlfile_record_sectionWHERE TYPE='REDO LOG'; CHECK THE BELOW VALUES:records_total records_used
2011-09-23 12:46:57 1012
原创 learning v$ view-> v$process
V$PROCESSThis view contains information about all Oracle processes running on the system. It is used to relate the Oracle or operating s
2011-09-23 10:06:13 631
原创 learning v$ view-> v$session_wait
V$SESSION_WAITThis is a key view for finding bottlenecks. It tells what every session in the database is currently waiting for (or the l
2011-09-22 14:42:05 1037
原创 learning v$ view-v$session
Oracle9i Database Performance Tuning Guide and ReferenceV$SESSIONThis view has one row for every session connected to the database i
2011-09-22 10:36:04 534
转载 oracle 10g logical standby
http://otn.oracle.com/oramag/oracle/04-jul/o44tech_avail.htmlMake Recovery LogicalBy Darl KuhnUse Data Guard's logical standby dat
2011-09-19 16:46:47 651
原创 logical standby 同步缓慢
If there are a number of appliers that consistently have a status code of 16124, then there is a possibility of SQL Apply being delayed by
2011-09-19 15:52:12 893
原创 alter database recover to logical standby xxx no response
Physical Standby DB:RECOVER MANAGED STANDBY CANCEL;Primary DB:EXECUTE DBMS_LOGSTDBY.BUILD;
2011-09-17 16:13:03 830
原创 Oracle 10g->Grid Control Upload Error & Re-configuration
./emctl upload agentOracle Enterprise Manager 10g Release 4 Grid Control 10.2.0.4.0. Copyright (c) 1996, 2007 Oracle Corporation. All
2011-09-13 09:00:54 1327
原创 Clean Oracle related log file
#!/bin/sh#-------------KIN------------------------ListenerLogDir=/oracle/ora920/network/logexport ListenerLogDir for i in `/bin/ls
2011-09-08 15:09:12 445
空空如也
TA创建的收藏夹 TA关注的收藏夹
TA关注的人