2011年09月_jxzkin

12月 11月 10月 09月 08月

原创 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 823

原创 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 550

原创 can not use backspace button in sqlplus

before run sqlplus execute the #stty erase ^h

2011-09-29 08:58:56 592

原创 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 935

原创 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 728

原创 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 507

原创 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 1177

原创 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 987

原创 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 609

原创 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 1009

原创 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 505

转载 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 640

原创 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 870

原创 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 801

原创 Oracle 10g->Grid Control Upload Error & Re-configuration

2011-09-13 09:00:54 1303

原创 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 426

KAMUS ASM TESTING

KAMUS ASM TESTING KAMUS ASM TESTING

2011-10-12

data Guard Concepts and Administration

2011-08-31

空空如也

TA创建的收藏夹 TA关注的收藏夹

TA关注的人