ITPub博客

DECLARE@USER_ID INT, @KILLCMD VARCHAR(100)-- 根据选择条件，选择出应该取消的进程DECLARE cur_lock CURSOR FORSELECT spid FROM master..sysprocessesWHEREblocked = 0AND spid IN (SELECT blocked FROM mas...

  IF   SERVERPROPERTY('ServerName')<>@@SERVERNAME     BEGIN     DECLARE   @srvname   sysname     SET   @srvname=@@SERVERNAME &nbsp...

use mastergocreate procedure sp_who_lockasbegindeclare @spid int,@bl int,@intTransactionCountOnEntry int,        @intRowcount    int,        @intCount...

select object_name(id) tablename,8*reserved/1024 reserved,rtrim(8*dpages/1024)+'Mb' used,8*(reserved-dpages)/1024 unused,8*dpages/1024-rows/1024*minlen/1024 free, rows,* from sysindexes wher...

sp_autostats 'table_name';

declare  @maxfrag DECIMALselect @maxfrag = 90--声明变量SET NOCOUNT ONDECLARE @tablename VARCHAR (128)DECLARE @execstr VARCHAR (255)DECLARE @objectid INTDECLARE @objectowner VARCHAR(255)DECLARE @i...

Different Upgrade Methods For Upgrading Your Database (Doc ID 419550.1)Things to Consider Before Upgrading to 11.2.0.3 Grid Infrastructure/ASM (Doc ID 1363369.1)Complete Checklist to Upgrade the D...

MySql实现远程连接   1、进入mysql，创建一个新用户root,密码为root：   格式：grant 权限 on 数据库名.表名 to 用户@登录主机 identified by "用户密码";      ...

[转载] http://wenson.iteye.com/blog/39066 一 、下载MySQL的安装文件　　安装MySQL需要下面两个文件：　　MySQL-server-4.0.16-0.i386.rpm　　MySQL-client-4.0.16-0.i386.rpm　　下载地址为：http...

作者：Mike.Xu 发表于: March 9, 2011 4:25 PM 转载时请务必以超链接形式标明文章 原始出处和作者信息及本版权声明。 链接：http://www.dbasky.net/archives/2011/03/mysql-5.html &n...

$ ps -ef |grep $ORACLE_SID|grep -v grep|awk '{print $2}' | xargs kill -9$ ipcs -m | grep oracle | awk '{print $2}' | xargs ipcrm shm

转载 http://blog.csdn.net/tianlesoftware/article/details/6307985

PurposeThis article describes similarities and differences between different features available for high availability and distributed systems. It contains comparison between multiple features...

表:alter table_name move tablespace new_tablespace;重建索引表分区:ALTER TABLE PART_TAB MOVE PARTITION "P_412823" TABLESPACE "HROLTPDATA412823" UPDATE INDEXES;索引:alter index indexname rebuild online;...

发现一个用户下统计信息没有生成,查询user_tab_modifications 发现变动信息也超过10%没有警告日志执行exec dbms_stats.gather_schema_stats(ownname => 'test',granularity => 'ALL',cascade => true);还是没有生成...

1. 采用高速的存储设备,提高读写能力，如：EMC 和NetApp， 2. 假如tab1表中的没有数据的话 DROP   TABLE   TAB1;CREATE   TABLE   TAB1   AS   SELECT   *   FRO...

In this DocumentPurposeScopeDetails Description Cause Expected behavior. Block Corruption. Overlapped Extents. Overlapped ASM extent. Oracle defect. Identify th...

在Oracle9i里，Oracle提供了一个内部事件，用以强制刷新Buffer Cache，其语法为:alter session set events 'immediate trace name flush_cache level 1';或者:alter session set events = 'immediate trace name...

分区:Select 'ALTER INDEX '|| index_name ||' rebuild partition ' || PARTITION_NAME || ' TABLESPACE ' || tablespace_name ||';' from USER_IND_PARTITIONS子分区:  S...

In this DocumentSymptomsCauseSolutionReferencesApplies to:Oracle Server - Enterprise Edition - Version 8.1.7.4 and laterInformation in this document applies to any platform.Applies to 8.1.7.4 onwards....