ITPub博客

关于字符集的几句话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...

裸设备和Oracle问答20例　1．什么叫做裸设备？　　裸设备，也叫裸分区（原始分区），是一种没有经过格式化，不被Unix通过文件系统来读取的特殊字符设备。它由应用程序负责对它进行读写操作。不经过文件系统的缓冲。2...

AIX Useful Commands compress -c file.txt > file.Z Create a compressed file. uuencode (infile) (extract-file-name) > (output file) Converts a binary file to an ASCII file for transfer by mode...

AIX基础教程AIX操作系统概述 一、AIX的性能和特点： 1、短小强干的内核和丰富的核外系统程序 AIX的设计者对系统的内核进行了精心设计，使之既简短又强干，可常驻内存。把凡是能从内核中分离出来的部分都从中分离出来...

昨天无意间在DB中发现如下问题SQL> select sid,username,machine,program from v$session where SCHEMANAME='SYS'; SID USERNAME MACHINE PROGRAM---------- --------------- -----...

前两天在系统的TOP SQL LIST中发现有这样一条SQL，拿了出来分析了一下。发现这条SQL的WHERE条件中对列使用了函数，这样会影响SQL性能。由于简单改写了一下性能大有好转。详细如下 原SQLSQL> select contract_idntfr,...

有一个备份完成的备份集，由于磁盘空间不足，每天早上都要把这些备份集下载了一台WINDOWS 机器上做备份、同时腾出空间给明天备份集用。1.ftp_auto.batftp -n -s:"D:scriptsdownload_bak.ftp"2.download_bak.ftpopen ...

进入安全模式，跟着进入 System32 目录，找到WgaTray.exe 和 wgalogon.dll 并把它们重命名为 WgaTray1.exe 和 wgalogon1.dll，重启电脑就可以禁止这个盗版提示信息。

SQL> alter system quiesce restricted;alter system quiesce restricted*ERROR at line 1:ORA-25507: resource manager has not been continuously onSQL> alter system quiesce restricted;alter system quiesce r...

session 1SQL> select sid from v$mystat where rownum=1; SID---------- 18 SQL>select /*+ parallel(a,4) */ * from temp_3006; print............ session 2 SQL> select sid,qcsid,ser...