oracle和unix
文章平均质量分 62
qindalin
这个作者很懒,什么都没留下…
展开
-
about shared pool
select a.ksppinm , b.ksppstvl from x$ksppi a , x$ksppcv b where a.indx=b.indx and a.ksppinm like '%dsidx_count'_kghdsidx_count 参数决定了share pool 的sub pool的个数多用v$sqlstats 而不是v$sql 因为代价更小原创 2013-03-14 17:38:13 · 614 阅读 · 0 评论 -
a script to generate sqlldr control file
DECLARE str varchar2(100); u_name varchar2(100); tab_name varchar2(100); Type Tab_L is Table of Varchar2(100); T_Tab Tab_L := Tab_L('CORECAT.FISCAL_PERIOD','CRX_COR.CORPORATE_ACTION',原创 2013-07-08 11:09:26 · 570 阅读 · 0 评论 -
ogg sourceistable extract parameter files - as an etl tool
--FISCAL_PERIOD f_00ADD EXTRACT f_00, SOURCEISTABLEEXTRACT f_00USERID ggs_owner, PASSWORD ggs_ownerFORMATASCII, NONAMES, DELIMITER '|' ,NOQUOTE , NOHDRFIELDS, NULLISSPACEEXTFILE /oraarch/CN原创 2013-07-08 11:11:06 · 1461 阅读 · 0 评论 -
本地yum 库
vi /etc/yum.repos.d/base.repo[base]name=basebaseurl=file:///mnt/Server/enabled=1gpccheck=1gpgkey=file:///etc/pki/rpm-gpg/RPM-GPG-KEY-oracle # grub.conf generated by anaconda##原创 2013-05-13 13:52:14 · 537 阅读 · 0 评论 -
ora_rowscn & scn_to_timestamp
SQL> select ora_rowscn from tt;ORA_ROWSCN---------- 286928 286928 286928 286928 286928 286928 286928 286928 286928 28692810 rows selected.SQL>原创 2013-05-07 14:01:32 · 947 阅读 · 0 评论 -
updated
listener.oralistener=(description=(address_list=(address=(protocol=tcp)(port=1521)(host=ocm.localdomain)))listener1=(description=(address_list=(address=(protocol=tcp)(port=1421)(host=ocm.localdoma原创 2013-05-14 16:38:39 · 542 阅读 · 0 评论 -
trailing nulcols:difference between external table and sqlldr:create external table from controlfile
the table definiton :SQL> desc tt; Name Null? Type ----------------------------------------- -------- ---------------------------- A原创 2013-05-03 17:16:56 · 1213 阅读 · 0 评论 -
find & vi
After grid control sccessfully install on server db2 , I added listener1 using port 1821 and modified tnsnames.ora using the new listener.then the repostory couldn't be connected , I then go to sys原创 2013-04-14 17:20:06 · 603 阅读 · 0 评论 -
e2label , fstab, mkfs, partprobe, fdisk
[root@ocm raw]# cat /etc/fstabLABEL=/1 / ext3 defaults 1 1LABEL=/u01 /u01 ext3 defaults 1 2LABEL=/u02原创 2013-04-30 17:13:08 · 681 阅读 · 0 评论 -
manully typing the partiton table script is a hard work
CREATE TABLE sample_regional_sales (deptno number, item_no varchar2(20), txn_date date, txn_amount number, state varchar2(2)) PARTITION BY RANGE (txn_date) SUBPARTITION BY LIST (sta原创 2013-04-26 18:37:57 · 480 阅读 · 0 评论 -
remove a rac completely
to minimize the time for an virtual vmare server setup:cd /usr/local/bin/ and rm the three filesrm -rf /var/tmp/.oraclevi /etc/inittab remove the 3 bottom linescd /etc/init.d rm -rf i原创 2013-04-17 22:44:13 · 553 阅读 · 0 评论 -
pragma autonomous_transaction : restrict_references(<fuctionname>,wnds) and serially_resumable
pragma : serially_reusableSQL> CREATE PACKAGE pkg1 IS PRAGMA SERIALLY_REUSABLE; num NUMBER := 0; PROCEDURE init_pkg_state(n NUMBER); PROCEDURE print_pkg_state;END pkg1;/ 2原创 2013-04-17 17:25:46 · 677 阅读 · 0 评论 -
vmware workstation 9 rac vmx file setting . oifcfg
here I create scsi1:0 scsi1:1 scsc1:2 scsc1:3 scsc1:4 scsc1:5 disk on vmware workstation 9 and modified the vmx for both nodes by adding the following lines : the locking and sharedbus are the key转载 2013-04-15 21:05:32 · 1088 阅读 · 0 评论 -
rman clone db prerequests
as a prerequest for the duplicate database command is set log_file_name_convert and db_file_name_convert parameter for the auxiliary database init.ora file . another prerequest is modify the liste原创 2013-04-23 13:11:11 · 506 阅读 · 0 评论 -
resource manager tesing and explain
for the testing purpose , I assgin oracle user DD to batch group and QDL to oltp group , oltp can switch to batch group when switch condition are meet.two consume groups are batch and oltp .see co原创 2013-04-23 18:10:08 · 582 阅读 · 0 评论 -
grub install oracle linux on linux
firstly you should have the dvd iso file in some of the partition on the existing linux server , for me its in /dev/hda2 ,note : don't change the file name.mount -t iso9660 /iso/Enterprise-R5-U6-Ser原创 2013-04-23 13:50:32 · 654 阅读 · 0 评论 -
seamless physical dataguard creation and swichover
prerequest : primary database name is ocmdb , standby database's directory strutrue is different than primary (ocmdb,ocmdg) maximize protection mode1. create database2. alter database force loggin原创 2013-04-13 11:34:38 · 568 阅读 · 0 评论 -
aq_tm_processes
QMNC和Qnnn:高级队列QMNC进程对于AQ表来说就相当于CJQ0进程之于作业表。QMNC进程会监视高级队列,并警告从队列中删除等待消息的“出队进程”(dequeuer):已经有一个消息变为可用。QMNC和Qnnn还要负责队列传播(propagation),也就是说,能够将在一个数据库中入队(增加)的消息移到另一个数据库的队列中,从而实现出队(dequeueing)。Qnnn进转载 2013-03-15 23:22:19 · 8653 阅读 · 0 评论 -
how to install oracle linux 5 with paravirtual scsi controler over vmware exsi
this article is the preparation for the oracle exadata installation, as we know that it's so fast to install and do some work under os ORACLE linux 6 which default scsi controler is paravirtual scsi.原创 2013-12-30 02:26:03 · 826 阅读 · 0 评论