-
编辑 删除
eof
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
Linux创建文件系统并挂载的方法 -----dd
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
oracle 自动列值增加
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
create index online
避免锁[@more@]
-
编辑 删除
oracle10g中的bigfile tablespace
bigfile tablespace是Oracle10g的新特性。Bigfile tablespaces包含1个最大4G个blocks 的datafile。因此，使用8KBdata blocks 的bigfile tablespace 最大可以达到32TB。Bigfile tablespaces 常用于非常大的DB。 如果很大的DB有成千的 read/write datafiles, 那么checkpoints之类的操作将非常费时。如果用一个很大的datafile，减少datafiles的数量，将会提高效率。创建时使用BIGFILE关键字如下：CREATE BIGFILE TABLESPACE BIG_DEMODATAFILE '/ORADATA/PROD/BIG_DEMO.DBF' SIZE 25G;Smallfile tablespace是原Oracle tablesp
-
编辑 删除
linux 内存释放命令
# sync # echo 1 > /proc/sys/vm/drop_caches echo 2 > /proc/sys/vm/drop_caches echo 3 > /proc/sys/vm/drop_caches cache释放： To free pagecache: echo 1 > /proc/sys/vm/drop_caches To free dentries and inodes: echo 2 > /proc/sys/vm/drop_caches To free pagecache, dentries and inodes: echo 3 > /proc/sys/vm/drop_caches 说明，释放前最好sync一下，防止丢数据。 因为LINUX的内核机制，一般情况下不需要特意去释放已经使用的cache。这些cache起来的内容可以增加文件以及的读写
-
编辑 删除
recover database using backup controlfile利用archivelog files.
recover database using backup controlfile;1 指定日志: {<RET>=suggested | filename | AUTO | CANCEL}auto2 指定日志: {<RET>=suggested | filename | AUTO | CANCEL} cancel或者：2 指定日志: {<RET>=suggested | filename | AUTO | CANCEL}D:oracleproduct10.2.0oradatatestREDO01.LOG --filenamefilenameSQL> select status,group# from v$log;STATUS GROUP#---------------- ----------CURRENT 1INACTIVE 3INACTIVE 2[@more@]
-
编辑 删除
Oracle10g RAC环境下DataGuard备库搭建实例
为一个RAC搭建standby和单节点搭建方法基本一致，我们可以把RAC看成是一个单节点的数据库，只需要保证所有节点的日志能传送到备库即可。 一、在备库服务器安装ORACLE软件 只安装软件，不要创建数据库。ORACLE软件版本和主库保持一致。 二、修改主库参数 节点1执行： SQL> show parameter spfile NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ spfile string /dev/raw/raw14 节点2执行： SQL> show parameter spfile NAME TYPE VALUE ------------------
-
编辑 删除
Large SGA On Linux
Large SGA On Linux On 32-bit Linux the total SGA size is limited to around 2Gig. There are several ways to allocate more memory than this, but the most robust and scalable method requires the use of a shared memory file, like shmfs in RHEL 2.1 or ramfs in RHEL 3-5. This article presents the methods necessary to create very large buffer caches on Red Hat Enterprise Linux and its clones. Red Hat Enterprise Linux (RHEL) 2.1 Create a shared memory file system (shmfs)Enabling big
-
编辑 删除
执行计划出现BITMAP CONVERSION TO ROWIDS的解释!
BITMAP CONVERSION TO ROWIDS--------------------------------------------------------------------------------| Id | Operation | Name | Rows | Bytes | Cost (%CPU)| Time |-------------------------------------------------------------------------------------------------------------------| 0 | SELECT STATEMENT | | 16 | 944 | 139 (3)| 00:00:02 | | 1 | SORT GROUP BY | | 16 | 944 | 139 (3)| 00:00:02 | | 2 | NESTED LOOPS | | 16 | 944 | 138 (2)| 00:00:02 | | 3 | NESTED LOOPS | | 16 | 528 | 135 (3)| 00:00:02
-
编辑 删除
rman的level 0 1 2级备份有什么区别？
Level 0 级是各增量备份的基础，那level 1 与level 2有什么不同呢？ 分两种情况，incremental的和cumulitive的，前者备份跟自己同级或比自己级别低的，后者只备份比自己级别低的 前者：level1备份上一次level1或level0以来的变化，level2备份上一次level2或level1或level0以来的变化 后者：level1备份上一次level0以来的变化，level2备份上一次level1或level0以来的变化[@more@]
-
编辑 删除
oracle 检测脚本on linux
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
分区表大对象
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
Linux系统中增加Swap分区大小
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
shell大写转小写
for lowercase in `ls|grep -i '^gl'` do for uppercase in `ls $lowercase|tr [A-Z] [a-z]` do mv $lowercase $uppercase done done[@more@]
-
编辑 删除
oracle 索引什么时候重建和重建方法讨论
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
Rac11gR2 install On Linux
Table of Contents Rac11gR2OnLinux............................................................................................................................................1 1. Introduction........................................................................................................................................1 1.1. Overview of new concepts in 11gR2 Grid Infrastructure...................................................1 1.1.1. SCAN..................................................
-
编辑 删除
Oracle 10G RAC下OCR和Voting disk的管理
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.0001pt; mso-pagination:widow-orphan
-
编辑 删除
Clone EBS 11i on test47
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.
-
编辑 删除
Clone Madison 12R TEST application with customized data file location
Normal 0 7.8 pt 0 2 false false false MicrosoftInternetExplorer4 st1:*{behavior:url(#ieooui) } /* Style Definitions */ table.MsoNormalTable {mso-style-name:"Table Normal"; mso-tstyle-rowband-size:0; mso-tstyle-colband-size:0; mso-style-noshow:yes; mso-style-parent:""; mso-padding-alt:0cm 5.4pt 0cm 5.4pt; mso-para-margin:0cm; mso-para-margin-bottom:.
