ITPub博客

<p>SQL&gt; conn /as sysdba<br />Connected.<br />SQL&gt; <strong>@?/rdbms/admin/utlxplan.sql</strong></p><p>Table created.</p><p>SQL&gt; <strong>@?/sqlplus/admin/plustrce.sql</strong><br />SQL&gt;<br />SQL&gt; drop role plustrace;</p><p>Role dropped.</p><p>SQL&gt; create role pl...

select  ceil(no/13),max(no),min(no),count(*) from (select rownum as no,id from tt6) group by ceil(no/13) order by 1 asc

C:\Users\Admin.LONG1-LI>expdp scott/bruce123 directory=temp_dir dumpfile=tt_in.dmp EXCLUDE=TABLE:\"in(select table_name from user_tables whre table_name like 'TT%')\"Export: Release 10.2.0.1.0 - Production on Thursday, 24 September, 2015 10:48:56...

<p>C:\Users\Admin.LONG1-LI&gt;expdp scott/bruce123 directory=temp_dir dumpfile=tt_in.dmp EXCLUDE=TABLE:"IN ('TT1','TT2')"</p><p>Export: Release 10.2.0.1.0 - Production on Thursday, 24 September, 2015 10:34:25</p><p>Copyright (c) 2003, 2005, Oracle.&nbsp; All rights reserved.</p><p>Conn...

http://blog.chinaunix.net/uid-20185205-id-1972548.html

11g:select * from dba_temp_free_space;10g之前(包括10g)：select y.name,y.bytes/1024/1024 total_mb,(x.total_blocks*y.block_size)/1024/1024 used_mb,(y.bytes-x.total_blocks*y.block_size)/1024/1024 free_mb,round((x.total_blocks*y.block_size)/y.bytes,4)*100 pctfro...

<p>SQL&gt; alter system dump datafile 6 block min 1 block max 8;</p><p>System altered.</p><p>只能显示部分信息：<br />############################################<br />Start dump data blocks tsn: 4 file#: 6 minblk 1 maxblk 8<br />Block 1 (file header) not dumped: use dump file header com...

<p>改control_files这个参数的时候，需要注意格式，稍有不慎就会改错。<br />正确格式如下：</p><p>SQL&gt;<strong> alter system set control_files='E:\app\oracle\controlfile\control01.ctl','E:\app\oracle\controlfile\control02.ctl','E:\app\oracle\contr</strong><strong>olfile\control03.ctl' scope=spfi...

***alter system dump datafileselect * from v$session where username='SCOTT';select scott.tt1.*,dbms_rowid.rowid_relative_fno(rowid) fno,dbms_rowid.rowid_block_number(rowid) block,dbms_rowid.rowid_row_number(rowid) rowno from scott.tt1;SQL> alter system dump datafile ...

<p>从rac asm恢复到filesystem的时候，出现如上错误。</p><p>baidu结果&nbsp; <a href="http://blog.itpub.net/23135684/viewspace-626372/">http://blog.itpub.net/23135684/viewspace-626372/</a> </p><p>***************************************************************************************</p><p>...

1.将asm上面的数据库恢复到filesystem上面的时候，一直遇到如题的错误。很郁闷。2.在baidu之后发现restore controlfile需要crosscheck backup才可以。3.但是crosscheck backup也报错，没办法，就恢复了level=0 的backup database的前一天的control file备份。

<p>Follow is Oracle Wait Event Data Collection Simple Procedure(Database is 10g):<br /><br />create or replace procedure dc as</p><p>--------event comment<br />--59&nbsp;&nbsp; library cache lock<br />--64&nbsp;&nbsp; buffer busy waits<br />--115&nbsp; db file sequential read<br />--116...

一、准备一个物理卷 1、 你需要用作物理卷的硬盘必须被联接到系统并打开电源。用ioscan命令查找新硬盘的设备文件名。 #ioscan –funC disk -u 代表使用前一次扫描的结果 -k   only to...

Follow is Oracle Wait Event Data Collection Simple Procedure:create or replace procedure dc as--------event comment--59   library cache lock--64   buffer busy waits--115  db file sequential read--116  db file sca...

Oracle kill session script as below<br />singal instance:<br />select 'alter system kill session '''|| sid||','||serial# ||''';' from v$session where username='SCOTT';<br /><br />rac instance:<br />select 'alter system kill session '''||sid||','||serial#||',@'||inst_id||''' immediate;' from gv$...

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平台下，我们可以...