ITPub博客

<strong><a href="http://www.itpub.net/thread-1940200-1-1.html">http://www.itpub.net/thread-1940200-1-1.html</a><br />Linux安装Oracle的时候回修改一些参数，参数的解释如下：<br />&nbsp;<br />修改操作系统内核参数</strong>vi /etc/sysctl.conf（三个节点上的hosts文件修改后完全相同）：<br />##kernel.shma...

<a href="http://www.itpub.net/thread-1938117-1-1.html">http://www.itpub.net/thread-1938117-1-1.html</a><br /><br />1. CHAR vs. VARCHAR2<br /><br />It's always a good idea to choose VARCHAR2, because CHAR appends spaces to the string shorter than<br />defined length wasting storage. There's no s...

SQL> show userUSER is "SCOTT"SQL> create table tt2(id int,dt date,datec varchar2(20));Table created.SQL> editWrote file afiedt.buf  1  begin  2  for i in 1..1000 loop  3  insert int...

<p>C:\Users\is_long_li&gt;sqlplus / as sysdba</p><p>SQL*Plus: Release 10.2.0.1.0 - Production on 星期二 10月 13 09:22:49 2015</p><p>Copyright (c) 1982, 2005, Oracle.&nbsp; All rights reserved.</p><p>ERROR:<br />ORA-01031: insufficient privileges<br />提示没有权限。<br />查看如下：...

<p>remap_tablespace多个的时候,如下两种方式都可以的。<br /><strong>remap_tablespace=users:tt2 remap_tablespace=tt1:tt3</strong><br /><strong>remap_tablespace=users:tt2,tt1:tt3</strong></p><p>C:\Users\Admin.LONG1-LI&gt;impdp tt3/tt3 directory=temp_dir dumpfile=scott.dmp remap_schema=scott:tt3 ...

<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$...