ITPub博客

今天绩效考核,心情十分沉重.我永远走不出一个圈.--所谓的突破.同时感谢07年帮忙过我的朋友![@more@]

[php]在看oracle 10g Administrator's guide中Clearing a Redo Log File这章节时有以下这么一段话If you want to clear an unarchived redo log that is needed to bring an offlinetablespace online, use the UNRE...

UNRECOVERABLE DATAFILE clause in the ALTER DATABASE CLEAR LOGFILE statement--在看oracle 10g Administrator's guide中Clearing a Redo Log File这章节时有以下这么一段话If you want to clear an unarchived re...

Archive log 有关(脑子不好,特写下记之)LOG_ARCHIVE_FORMAT%t is thread number%s is log sequence number%r is resetlogs ID

WESTLIFE_XU ,我的老朋友,也是oracle DBA.2006年由于pub年会举办时间和他所服务的公司年会时间正好冲突,所以未能参加,对于他来说是一个遗憾,对于我来说也是一个遗憾,因为网上认识好久,但从未能谋面.今年,也就是2007...

check约束在IMP时会产生冗余SQL> create table t(id number ,name char(4));Table created.SQL> insert into t values(1,'yxy');1 row created.SQL> commit;Commit complete.SQL> alter table t add check (id=0 or ...

shrink space 的整个过程就是在做delete和insert SQL> select segment_name,bytes/1024/1024 from dba_segments where segment_name='TEST_SHRINK'; SEGMENT_NAME BYTES/1024/1024-------------------- ------------...

Oracle 11g 锁特性增加 在Oracle Database 11g Release 1 (11.1) 中锁的增强如下1.Serializing Locks在Oracle 11g中允许DDL语句等待DML锁.就是说当进行DML操作时,如果DML操作还没有完成,DML所持有的锁还没有释放,这...

Overview During database creation, Oracle creates several default database users or schemas. This article attempts to provide some insight and explain each of these default database users/schemas. Ora...

关于字符集的几句话1. 输入时，如果Oracle客户端字符集跟Oracle服务器端字符集设置不一样，那么输入的字符就会做字符转换，最终以服务器端的字符集存入数据库2. 输入时，如果Oracle客户端字符集跟Oracle服务器端字符...

Oracle Partitioned TablesOracle Partitioned TablesVersion 10.2 GeneralPartition Related Data Dictionary Objectsindpart$indsubpart$partobj$tabpart$indpart_param$partlob$subpartcol$tabsubpart$DBA, ALL, ...

Oracle Partitioned TablesOracle Partitioned TablesVersion 10.2 GeneralPartition Related Data Dictionary Objectsindpart$indsubpart$partobj$tabpart$indpart_param$partlob$subpartcol$tabsubpart$DBA, ALL, ...

ORA - 1461 encountered when generating server alert SMG-3500METALINK中，说是Oracle的一个bug。 METALINK, said Oracle is a bug. 造成这个问题的原因SMON进程在更新SMON_SCN_TIME表时，引发了ORA-1461错误。 Th...

shrink space 的整个过程就是在做delete和insertSQL> select segment_name,bytes/1024/1024 from dba_segments where segment_name='TEST_SHRINK'; SEGMENT_NAME BYTES/1024/1024-------------------- -...

shrink space 的整个过程就是在做delete和insertSQL> select segment_name,bytes/1024/1024 from dba_segments where segment_name='TEST_SHRINK'; SEGMENT_NAME BYTES/1024/1024-------------------- -...

刚刚在一个朋友的BLOG上看到一个这样的错误,发生在alert.log和sqlnet.ora中.同时朋友还给出了解决方法,如下. 在alert.log中发现：Thu Aug 9 21:21:17 2007WARNING: inbound connection timed out (ORA-3136)2. 同时...

Don't overlook STATSPACK in Oracle 10g[@more@]I had the privilege last month of hearing Rich Niemiec of TUSC speak about performance tuning at the Dallas Oracle Users Group. One tip he gave us was just too good not to pass on, so here it is: STATSPACK is still alive and well in Oracle 10g.A lot of the excitement about performance tuning in Oracle 10g is about the new Automated Workload Repository (AWR) feature, and the proactive monitoring it provides through Automatic Database Diagnostic Monito

Don't overlook STATSPACK in Oracle 10gI had the privilege last month of hearing Rich Niemiec of TUSC speak about performance tuning at the Dallas Oracle Users Group. One tip he gave us was just too go...

本文从不绑定变量与绑定变量两种情况讨论柱状图的作用。一、不绑定变量的情况：考虑以下数据SQL> select owner,count(1) from th group by owner;OWNER COUNT(1)------------------------------ ----------SUK 1SYS ...

ORA-00600: internal error code, arguments: [rpidrv-3], [], [], [], [], [], [], []今天下午在一如生产DB中又遇见了ORA-600,详细如下Mon Jun 18 14:04:53 2007Errors in file /filedata/ora_log/FFV2PROD/udump/f...