微尘 http://space.itpub.net/308563 记不住，就写下呗！ Copyright(C) 微尘 SupeSite/X-Space Sun, 12 Oct 2008 02:10:46 GMT Monitor Disk spcae Usage http://space.itpub.net/308563/viewspace-468206 #!/usr/bin/perl -w
use strict;
use DBI qw(:sql_types);
$ENV{"ORACLE_HOME"} = "/opt/oracle/product/9ir2";
 
my $dbh = DBI->connect( 'dbi:Oracle:dmsdb',
        &nbs...]]> blog xhailiang Tue, 07 Oct 2008 14:56:44 GMT differential incremental backups vs cumulative incremental backups http://space.itpub.net/308563/viewspace-374326 General

Differential backups were the next step in the evolution of backup strategies. A differential backup backs up only the files that changed since the last full back. For example, suppose you do a full backup on Sunday. On Monday you ba...]]> blog xhailiang Mon, 07 Jul 2008 14:22:48 GMT 郁闷 http://space.itpub.net/308563/viewspace-372003 http://seer.support.veritas.com/docs/239775.htm

http://seer.support.veritas.com/docs/274442.htm

]]> blog xhailiang Fri, 04 Jul 2008 23:35:05 GMT tuning veritas netbackup http://space.itpub.net/308563/viewspace-368819 NET_BUFFER_SZ, SIZE_DATA_BUFFERS and NUMBER_DATA_BUFFERS - how they work and how to configure them

http://seer.entsupport.symantec.com/docs/183702.htm

 

...]]> blog xhailiang Tue, 01 Jul 2008 21:52:18 GMT 11G ACL CONTROL LIST CONFIGURE http://space.itpub.net/308563/viewspace-364845 1.

begin
dbms_network_acl_admin.create_acl (
acl             => 'utlcontrol.xml',
description     => 'Normal Access',
principal  &nbs...]]> blog xhailiang Wed, 25 Jun 2008 17:22:42 GMT HP smart array 6400 overview http://space.itpub.net/308563/viewspace-364740 http://h20000.www2.hp.com/bc/docs/support/SupportManual/c00752371/c00752371.pdf]]> blog xhailiang Tue, 24 Jun 2008 21:34:45 GMT append hint with dblink http://space.itpub.net/308563/viewspace-351758 http://asktom.oracle.com/pls/asktom/f?p=100:11:0::::P11_QUESTION_ID:549493700346053658

 

A transaction containing a direct-path...]]> blog xhailiang Wed, 18 Jun 2008 16:51:46 GMT HOW TO FIND THE SESSION HOLDING A LIBRARY CACHE LOCK http://space.itpub.net/308563/viewspace-350636 Subject: HOW TO FIND THE SESSION HOLDING A LIBRARY CACHE LOCK   blog xhailiang Wed, 18 Jun 2008 14:05:00 GMT Oracle9ir2 Compress Table http://space.itpub.net/308563/viewspace-350581 http://www.oracle.com/technology/products/bi/pdf/o9ir2_compression_twp.pdf

http://forums12.itrc.hp.com/service/forums/questionanswer.do?admit=109447627+1213715623301+28353475&threadId=950771...]]> blog xhailiang Tue, 17 Jun 2008 23:28:56 GMT Will compressing indexes improve performance ? http://space.itpub.net/308563/viewspace-171900
Author's name: Jonathan Lewis

Author's Email: Jonathan@jlcomp.demon.co.uk
Date written: 26th Feb 2003


Oracle version(s): 8.1 - 9.2

Compressed indexes have been aroun...]]> blog xhailiang Tue, 03 Jun 2008 00:00:00 GMT How to migrate ODBC data sources http://space.itpub.net/308563/viewspace-324203 A. To migrate ODBC data sources, perform. the following steps:

  1. Start regedit.exe.
  2. Go to HKEY_LOCAL_MACHINE\SOFTWARE\ODBC\ODBC.INI, and highlight the ODBC.INI key in the left pane.
  3. From the Registry menu, select Export ...]]> blog xhailiang Thu, 29 May 2008 16:40:05 GMT LUN名詞解釋 http://space.itpub.net/308563/viewspace-310367 储区域网络）或 NAS （网络连接存储）环境中表示从一个或多个物理磁盘派
    生的虚拟实体。]]>     blog xhailiang Mon, 26 May 2008 18:51:50 GMT     紫川 http://space.itpub.net/308563/viewspace-234514 http://www.baidusn.cn/files/article/html/0/8/3588.html]]> blog xhailiang Fri, 11 Apr 2008 17:49:41 GMT How to Identify Resource Intensive SQL for Tuning收藏 http://space.itpub.net/308563/viewspace-227942 Subject: How to Identify Resource Intensive SQL for Tuning...]]> blog xhailiang Fri, 04 Apr 2008 00:07:17 GMT Example "Top SQL" queries from V$SQLAREA http://space.itpub.net/308563/viewspace-227941 From Metalink:note:235146.1
    The queries found here may be useful to Database Administrators,
    Application Developers, Oracle Support Engineers and generally
    anyone involved in an Oracle Database Performance ...]]>     blog xhailiang Fri, 04 Apr 2008 00:03:18 GMT     gam_server进程吃一颗CPU http://space.itpub.net/308563/viewspace-227938 OS版本Red Hat Enterprise Linux AS (v. 4)
    gam_server一直吃CPU 100%
    查到是一BUG，信息如下：

    BUG:

    oracle@host1:/opt/oracle$lsnrctl start
     
    LSNRCTL for Linux: Version 10.2.0.3.0 - Production on 03-APR-2008 10:2...]]> blog xhailiang Thu, 03 Apr 2008 10:41:11 GMT xxxx http://space.itpub.net/308563/viewspace-220568 名称解释：

    MOM： 面向消息的中间件（Message－Oriented Middleware）
    GUI： 图形用户界面（Graphic User Interface）
    PDL： 过程设计语言（Process Design Language）
    IDL： 接口定义语言(Interface Define Language)
    UML： 统一建模语言（Un...]]> blog xhailiang Tue, 01 Apr 2008 16:51:00 GMT MSSQL孤立帳號处理 http://space.itpub.net/308563/viewspace-219181 MSSQL Server 單個DB遷移時會發生孤立帳號問題，
    DB Version: 2000 SP4
    解決方法如下：（以下示例以dbname 為 xhl username 為xhltest演示）．
    運行sp_change_users_login　來查出孤立帳號．
    use xhl exec sp_change_users_login 'REPORT'
    分以下兩種情...]]>     blog xhailiang Sat, 29 Mar 2008 17:26:49 GMT     Client / Server / Interoperability Support Between Different Oracle Versions http://space.itpub.net/308563/viewspace-217040 Note:207303.1]]> blog xhailiang Mon, 24 Mar 2008 15:31:34 GMT 统一收集每台server的空间使用量 http://space.itpub.net/308563/viewspace-216918 简单的perl脚本从一台linux主机来统一收集每台SERVER disk空间使用量，用SHELL写一个可能更容易懂.
    1.在dmsdb  DB中添加一table 将所要收集的server添加到TAB_HOSTS 表中,栏位至少有ip hostname status（这个便于控制关停收集某台）
    2....]]>     blog xhailiang Sat, 22 Mar 2008 16:51:30 GMT     Features that Require the CBO http://space.itpub.net/308563/viewspace-214927 The following features require use of the CBO: