ITPub博客

SQL&gt; variable job number;<br /><br />create job:<br />SQL&gt; begin<br />&nbsp; 2&nbsp; dbms_job.submit(:job,'dc;',sysdate,'sysdate+1/24/60/60');<br />&nbsp; 3&nbsp; end;<br />&nbsp; 4&nbsp; /<br />PL/SQL procedure successfully completed<br />&nbsp;<br />Executed in 0.297 seconds<br />j...

<p>create or replace trigger logoff_tri<br />before logoff on database<br />declare<br />logoff_sid varchar2(50);<br />logoff_datetime&nbsp; date :=sysdate;<br />begin<br />&nbsp; select sid into logoff_sid from v$mystat where rownum&lt;2;<br />&nbsp; insert into session_event_history<br /...

create new trigger如下：create or replace trigger logoff_tribefore logoff on databasedeclarelogoff_sid varchar2(50);logoff_datetime  date :=sysdate;begin  select sid into logoff_sid from v$mystat where rownum<2;  insert i...

LocalDB.bat:set PATH=E:\app\oracle\product\10.2.0\db_1\BIN;C:\Windows\System32;sc start OracleOraDb10g_home1TNSListenersc start OracleServiceBRUCEping localhost -n 15 >nullsnrctl statussqlplus / as sysdba @e:\app\SelectDB.sql @e:\lilong\plsql common use s...

对于我们日常的维护和分析来说，保存一份主机日常性能采集的数据是非常有必要的。可以让我们在事后查看需要查看的那段时间的主机资源使用情况，也可以据此，我们来做一份分析报告。1、AIX平台在AIX平台下，我们可以...

查看Linux服务器下的内存使用情况，可以使用命令free -m。注意此命令只在Linux下有效，在FreeBSD中没有此命令。命令如下所示：used：已经使用的内存数free：空闲的内存数shared：多个进程共享的内存总额-buffers...

<a href="http://down.51cto.com/data/238560">http://down.51cto.com/data/238560</a>&nbsp;

set pagesize 100set timing onselect x.tablespace_name,y.bytes/1024/1024 total_size_mb,x.bytes/1024/1024 free_size_mb,(y.bytes-x.bytes)/1024/1024 use_size_mb,round((y.bytes-x.bytes)/y.bytes,4)*100 usagefrom (select tablespace_name,sum(bytes) bytes from dba_free_space group...