cjysdw2000-CSDN博客

转载 11gR1 optimizer key changes

What the new 11gR1 RDBMS changes benefit our application, you can read the article for a taste[@more@]Architecture...

2009-12-17 03:15:11 165

转载 SQL PERFORMANCE ANALYZER, a great tool for upgrade testing tuning and benchmark check

Changes that affect SQL execution plans, such as upgrading a database or addingnew indexes, can severely impact SQ...

2009-07-28 07:00:21 165

转载 ASCII in oracle, masking power on

ASCII: function converts a single character to its corresponding ASCII code.[@more@]CHARASCIICHARASCIICHARASCIINul...

2009-02-05 01:55:00 103

转载 On Dynamic Sampling

There are two ways to use dynamic sampling: The OPTIMIZER_DYNAMIC_SAMPLING parameter can be set at the database in...

2009-01-24 04:12:50 109

转载 tnsping: NL-00605: national language initialization failed sqlplus Error 5

wbiadm@wbidevrk1p:[/home/wbiadm]# tnspingNL-00605: national language initialization failedNL-00605: national langu...

2009-01-06 07:15:11 223

转载 push_pred, a powerful hint to speed up you inline view query 10X times

when we need to use it:Instructs the optimizer to push a join predicate into the view.condition: non-mergeable vie...

2008-08-12 06:22:23 363

转载 A taste of SQL Performance Analyzer in oracle 11g

we got a case when trying to change a table property, before we need to do thorough testing by collecting all rela...

2008-08-02 03:31:12 125

转载 steps to do real time apply in oracle 11g

the feature can make 11g standby database more powerful and flexible[@more@]real time apply:before:check log file:...

2008-07-23 07:48:48 129

转载 ORA-00604,ORA-01115,ORA-01110,ORA-27091,ORA-27072,IBM AIX RISC System/6000 Error

ORA-00604: error occurred at recursive SQL level 1ORA-01115: IO error reading block from file 1 (block # 81)ORA-01...

2008-05-02 07:06:27 553

转载 A more detailed threshold we should monitor on UNIX side

this is an example of SUN solaris data, it may be a bit different on other platform.FYI:[@more@]The iostat output ...

2008-04-22 04:49:44 91

转载 V$sort_usage, where is the definition?

GV$SORT_USAGEyou may need it sometimes when your temp gets blew without any reason during the nite :-)[@more@]sele...

2008-01-22 02:20:52 107

转载 ORA-00600: internal error code, arguments: [qkaffsindex3], [], [], [], [], [], [], []

SQL> select * from V$version;BANNER----------------------------------------------------------------Oracle Datab...

2007-11-20 07:35:29 330

转载 best practice of rebuild your partition table local index online by using: "update indexes"

The following operations support the UPDATE INDEXES clause:ADD PARTITION | SUBPARTITIONCOALESCE PARTITION | SUBPAR...

2007-11-16 09:25:20 117

转载 X$ table, how many you know?

X$ Table This is a summary list of X$ table definitions. The last revision was for Oracle 7.3.2, however, the list...

2007-10-27 02:23:14 230

转载 how to use oidpasswd to admin your AS/OID account

got an issue that my orcladmin account was not able to login. Here is the approach to reset it:donot get panic whe...

2007-10-21 22:46:13 143

转载 appworx nutshell:

2007-09-18 01:40:54 109

转载 stream step-by-step

no time to read the manual but want to taste how stream works. here is what you can go through in 30min.[@more@]st...

2007-09-15 09:42:34 154

转载 rman and archive log variable and meanings:

archivelog format：(9i,10g)%s log sequence number%S log sequence number, zero filled%t thread number%T thread numbe...

2007-09-06 03:01:08 81

转载 system tuning and analysis:

The areas you'll want to review and monitor on your database server using Unix utilities are:CPU performance. How ...

2007-09-03 16:48:43 164

转载 SUID and SGID: -rwsr-xr-x Unix file permission

Everybody handling a Unix operating system would very well know what chmod 777 means. That the owner, group and th...

2007-09-01 06:48:21 134

cjysdw2000的博客