ITPub博客

当数据库数据量很大的时候，使用增量备份来备份数据时，rman会走full scan来备份数据；当开启块跟踪功能后，rman只需要备份至上次备份以来的有变化的数据块就可以了，这很大的提高了备份的速度。

下面是我静默安装weblogic时参考的博客：http://blog.itpub.net/31394438/viewspace-2141505/在安装的过程中遇到的一些问题。[weblogic@yq weblogic]$ java -jar fmw_12.1.3.0.0_wls.jar  -silent -responseFile /weblogic/Oracle/Middleware/wls.rsp -invPtrLoc /home/weblogic/oraInst.locLauncher log f...

1. Reducing Waits / Wait times:The action to take depends on the lock type which is causing the most problems. It is beyond the scope of this reference note to look at the reasons for waits on each lock type - the most common lock waits are generally for:      TX &n...

Understanding and Tuning Buffer Cache and DBWR (Doc ID 62172.1)理解和调整BUFFER CACHE 以及 DBWR(database writer)当我们的数据库出现一下等待事件的时候，说明数据库性能已经受到了影响：--1）Latch contention for the 'cache buffers lru chain' or the "cache buffer chain" latch--2）Large "Aver...

到安装包解压的database目录下[oracle@yq response]$ pwd/oracle/database/response[oracle@yq response]$ lsdbca.rsp  db_install.rsp  netca.rsp[oracle@yq response]$ vi db_install.rsp #####修改以下参数########oracle.install.option=INSTALL_DB_SWONLYORACLE_HOSTNAME=yqUNIX_GROUP_NAME=oins...

1：操作系统要求如下所示，官方文档有system requirements，即必须满足操作系统要求才能打补丁，一般情况下很少有不满足条件。SystemRequirementsThefollowing are the system requirements for this patch set:OperatingSystemAsianux2.0Asianux3.0OracleEnterprise Linux 4.0/Oracle...

创建视图语法：CREATE [OR REPLACE] [{FORCE|NOFORCE}] VIEW view_nameAS SELECT  [WITH READ ONLY CONSTRAINT]

USER_SEGMENTS describes the storage allocated for the segments owned by the current user's objects. This view does not display the OWNER, HEADER_FILE, HEADER_BLOCK, or RELATIVE_FNO columns.USER_SEGMENTSUSER_SEGMENTS describes the storage allocated for the segments owned by the current user's obj...

GRANT SELECT ANY TABLE TO USERNAME;?  ...

利用DBMS_METADATA.GET_DDL，获取表的DDL语句

DBA_USERS_WITH_DEFPWD视图的作用是显示那些用户使用的是缺省口令SQL> set autotrace on SQL> select * from DBA_USERS_WITH_DEFPWD;USERNAME------------------------------DIPMDSYSXS$NULLSPATIAL_WFS_ADMIN_USRCTXSYSOLAPSYSOUTLNSPATIAL_CSW_ADMIN_USREXFSYSORACLE_OCMSCOTTUSERNAME------...

SQL> desc dba_users Name                                      Null?    Type ----------...

DBA_OBJECTS describes all objects in the database. Its columns are the same as those in "ALL_OBJECTS".在数据库查看该视图的字段SQL> desc dba_objects Name                Null     Type -------...

今天登录数据库的时候遇到无法连接到数据库实例的问题，具体如下：[oracle@yq ~]$ [oracle@yq ~]$ sqlplus / as sysdbaSQL*Plus: Release 11.2.0.3.0 Production on Mon May 22 04:22:14 2017Copyright (c) 1982, 2011, Oracle.  All rights reserved.Connected.SQL> SQL> SQL> SQL> exitDisconn...

ORACLE快速彻底Kill掉的会话 在ORACLE数据库当中，使用ALTER SYSTEM KILL SESSION 'sid,serial#'杀掉一个会话进程。  会话1： SQL> conn scott/scott Connected. SQL>  SQL>  SQL> update emp set empno=5566 where empno=7788; 1 row updated. ...

Oracle10.2.0.1 install onlinux6.4 Oracle10.2.0.1 install onlinux6.4 1、依赖包的检查[root@gyyum.repos.d]# rpm -q binutils compat-libstdc++-33 compat-libstdc++-33.i686elfutils-libelf elfutils-libelf-devel gcc gcc-c++ glibc glibc.i686 glibc-commonglibc-devel glibc-devel...

今天遇到一个连接192.168.56.102这个库报错 java.sql.SQLException: ORA-28040: No matching authentication protocol12C下查询此报错oralce:/oracle/db/app/12.1.0/db/network/admin> oerr ora 2804028040, 0000, "No matching authentication protocol"// *Cause:  There was no acceptable authenticati...

  yq:192.168.56.102yq01:192.168.56.109主库监听SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (ORACLE_HOME =/oracle/app/oracle/product/11.2.0/dbhome_1)      (SID_NAME = ORCL)    )  )...

停止数据库：[grid@yq ~]$ srvctl stop db -d orcl查看ip信息#public ip               192.168.56.120  lzl     eth0 192.168.56.123  yq      eth0 #virtual ip  &...

alter table test enable row movement;flashback table test  to timestamp to_timestamp('2017-05-22 04:12:30','yyyy-mm-dd HH24:MI:SS'); 时间为需要恢复到的时间节点SQL> create table test (id int);Table created.SQL> insert into test values(1);1 row created.SQL> update ...