-
编辑 删除
Oracle 10g Review
Oracle 10g Review 1.0 GENERAL INFORMATION 1.1 PurposeOracle Database 10g is the first database designed f...
-
编辑 删除
Oracle Solaris Server VMSTAT
Oracle Solaris Server VMSTAT Memory management in UNIXMost operating systems today possess what is commonly called virtual memory. In a virtual memory configuration it is possible to extend th...
-
编辑 删除
Oracle Automatic DBSTAT
Oracle Automatic DBSTATThe recommended approach to gathering statistics is to allow Oracle to automatically gather the statistics. Oracle gathers statistics on all database objects automatically and ...
-
编辑 删除
Global Temporary Tables
Global Temporary TablesCollect statistics Applications often use some form. of temporary data store for processes that are to complicated to complete in a single pass. Often, these temporary stores ...
-
编辑 删除
Oracle Sleep Time
Oracle Sleep Timedrop user usera cascade;drop user userb cascade;create user usera default tablespace users identified by abc123;grant create session to usera;grant resource to u...
-
编辑 删除
db file parallel write wait event
DB FILE PARALLEL WRITEThe db file parallel write wait event in last 24 hours. $ sqlplus /nologSQL*Plus: Release 10.2.0.1.0 - Production on Wed Feb 1 13:00:42 2012Copyright (c) 1982, 2005, Ora...
-
编辑 删除
Oracle Performance Tuing: BITMAP CONVERSION TO ROWID
TRSPRD performance analysis$ uname -aSunOS ctmtrs 5.10 Generic_144488-09 sun4u sparc SUNW,Sun-Fire-V445$ prtconf | grep MemoryMemory size: 8192 Megabytes$ cd /usr/sbin$ psrinfo -vStatus of vir...
-
编辑 删除
How to check database recovery status ORA-1195
DBA Notes: 2012/01/20Cheng Li(Database: Oracle 9i, OS: AIX) How to check database recovery status ORA-1195 Following is the meaning of the error messageError: ORA 1195 Text: onlin...
-
编辑 删除
Database Media Recovery Failure
DBA Notes: 2011/12/27Cheng Li(Database: Oracle 9i, OS: AIX) Database Media Recovery Failure Problem Description: We are using EMC BCV technique to perform. our recovery the same data ...
-
编辑 删除
How to housekeeping SYSAUX tablespace
DBA Notes: 2012/01/19 Cheng Li(Database: Oracle 10g, OS: Solaris) How to housekeeping SYSAUX tablespace Following Steps to perform. SYSAUX tablespaceSELECT * FROM dba_jobs WHERE owner...
-
编辑 删除
ORA-1146 tablespace is already in backup mode
DBA Notes: 2012/01/18Cheng Li(Database: Oracle 9i, OS: AIX) ORA-1146 tablespace is already in backup mode We meet alert error message ORA-1146 on a 9i database for a hot back-up.What w...
