edwards0307
- 浏览: 25804 次
- 性别:
- 来自: 北京
-
最新评论
文章列表
[置顶] listener errors
- 博客分类：
- oracle
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= ...
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 ...
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> selec ...
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)+ substri ...
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,tru ...
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.252ifconfig eth0 192.168.2.252 netmask 255.255.255.
last:service network restart
thanks dukope of itpub.
Consider Multiple Database Writer (DBWR) Processes or I/O SlavesConfiguring 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 th ...
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 ...
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 -caORb
site:oracle.com "java"
oracle rac filetype:pdf
inurl ...
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%26 ...
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 you' ...
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 ...
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 ...
STARTUP PFILE=
- 博客分类：
- oracle
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
LEARN SHELL
- 博客分类：
- 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.
...