weixin_43965939的博客

--创建用户并指定表空间 create tablespace testTablespace datafile 'D:\oracle\esunnet.dbf' size 10m autoextend on; create user testUser identified by testUser#1234 default tablespace esunnet; grant sysdba to t...

性能优化。 ` 查询数据库中的连接信息。其中SQL_COMMAND 是可以释放进程的sql语句: select A.SID,B.SPID,A.SERIAL#,a.lockwait,A.USERNAME,A.OSUSER,a.logon_time,a.last_call_et/3600 LAST_HOUR,A.STATUS, ‘orakill ‘||sid||’ ‘||spid ...

USE [Esunnet] GO /****** Object: Trigger [dbo].[triggerOnEvaluation] Script Date: 2014/8/21 0:24:53 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO --create trigger checkAgentLogGroup --a...