killdbs
edwards0307 · 共 36 篇文章
[置顶] listener errors
1.LSNRCTL for Linux: Version 10.2.0.1.0 - Production on 17-NOV-2011 06:50:23 Copyright (c) 1991, 2005, Oracle. All rights reserved. Message 1070 not found; No message file for product=network, facility=TNSTNS-12545: Message 12545 not found; No message file for product=network, facility=TNS TNS-1256…
2011-11-17 11:32 · oracle · 评论(0)
[置顶] manage controlfiles
a binary file 1.what's controlfiles Every Oracle Database has a control file, which is a small binary file that records the physical structure of the database.The database control file is a small binary file necessary for the database to start and operate successfully. A control file is updated con…
2011-11-15 14:53 · oracle · 评论(0)
[置顶] user_tab_modifications
USER_TAB_MODIFICATIONS describes modifications to all tables owned by the current user that have been modified since the last time statistics were gathered on the tables 1.SQL> select * from user_tab_modifications; no rows selected 2.SQL> insert into t values(1); 3.commit; 4.SQL> select * from user_t…
2011-11-15 10:40 · oracle · 评论(0)
from string get number data using pl/sql or sql
declare @aa varchar(80),----INFO列 @bb varchar(80) set @aa ='你好12按时地方' set @bb='' while PATINDEX('%[0-9]%',@aa)<>0 /*每次循环找出一个数字*/ begin set @bb = @bb+substring(@aa,PATINDEX('%[0-9]%',@aa),1)/*把找出来的数字进行相加*/ set @aa=substring(@aa,1,PATINDEX('%[0-9]%',@aa)-1)+ substring(@aa,PATINDEX('%[0-9]%',@aa)+1,le…
2012-02-16 17:32 · oracle · 评论(0)
SQL
1.select sal salary from emp; select sal as salary from emp; select sal as "salary" from emp; select comm "comm sal" from emp; column alias can not use where clause 2.DML select,insert,update,delete,merge DCL grant,revoke DDL create,drop,alter,rename,truncate DTL commit,rollback,savepoint 3.select …
2012-02-15 18:01 · oracle · 评论(0)
modify ip
1.netconfig 2./etc/sysconfig/network-scripts, find ifcfg-eth0,ifcfg-eth1.... modify IPADDR 3./etc/rc.d/init.d/network ifconfig eth0 hw ether 192.168.2.252 ifconfig eth0 192.168.2.252 netmask 255.255.255. last:service network restart
2012-02-10 17:45 · oracle · 评论(0)
MULTI dbwr or io slaves
thanks dukope of itpub. Consider Multiple Database Writer (DBWR) Processes or I/O Slaves Configuring multiple database writer processes, or using I/O slaves, is useful when the transaction rates are high or when the buffer cache size is so large that a single DBWn process cannot keep up with the lo…
2012-02-10 15:21 · oracle · 评论(0)
FAQS
1.How can I get the largest amount of physical reads by any query? select disk_reads, sql_text from v$sqlarea where disk_reads >1000 order by disk_reads desc ; 2. V$FIXED_TABLE This view displays all dynamic performance tables, views, and derived tables in the database 3.What is the difference betw…
2012-02-09 15:59 · oracle · 评论(0)
web
http://www.opensoftlab.com/index.php http://www.supportcenter.cn/viewthread.php?tid=55763 http://www.oracle.com/pls/db102/homepage?remark=tahiti http://www.dbapool.com/ oracle dba "oracle*dba" a b -c aORb site:oracle.com "java" oracle rac filetype:pdf inurl:jsp intitle:oracle dba "oracle dba" link:…
2012-02-09 10:26 · others · 评论(0)
web login
http://www.baidu.com/search/url_submit.html https://accounts.google.com/ServiceLogin?service=sitemaps&passive=1209600&continue=https://www.google.com/webmasters/tools/submit-url/?hl%3Dzh-CN%26continue%3D/addurl&followup=https://www.google.com/webmasters/tools/submit-url/?hl%3Dzh-CN%26continue%3D/ad…
2012-02-09 10:07 · others · 评论(0)
HOW TO STUDY ORACLE FROM Yong Huang
Assuming you want to study oracle database, specifically to prepare yourself as a DBA, not other products such as Apps or Developer Suite...] 1.0 Download from otn.oracle.com, or borrow CDs for, oracle server software enterprise edition. Make sure it's not any other lesser edition. Choose the OS yo…
2012-01-18 14:48 · oracle · 评论(0)
RMAN
1.components of the rman rman server process channel rman repository recovery catalog database 2.when using rman connected to target database,default having two rman server process.(one is establishing the connection for rman to database, the other is pool rman server process ) 3.in auto allocate c…
2012-01-14 17:07 · oracle · 评论(0)
INSTANCE and CRASH RECOVERY
1.type of checkpoint full checkpoint alter system checkpoint incrimental checkpoint(logfile switch) alter system switch logfile. partial checkpoint alter tablespace backup/online/offline 2.phases of instance recovery 1.chek asydatafiles. 2.cache rocovery(roll forward withredo),open database. 3.tran…
2012-01-12 10:12 · oracle · 评论(0)
STARTUP PFILE=
1.vi initdbs.ora spfile="/u01/oracle/dbs/spfilelsh" lock_sga=false 2.sqlplus /nolog conn /as sysdba startup pfile=initdbs.ora note: the values of the lock_sga in the initdbs.ora overridde the values of the spfilelsh.ora
2011-12-31 14:11 · oracle · 评论(0)
LEARN SHELL
1.ORACLE_SID=lsh 2.export ORACLE_SID 3.#!/bin/bash 4.Shell variables are un-typed and may contain integer or text,Number with a decimal point will be treated as text(3.14) 5.variable scope: local script or all session. when export variable, variable are used in subsequently. 6.$ORACLE_SID use varia…
2011-12-28 15:14 · shell · 评论(0)