ITPub博客

KROWN：132780Oracle Recommended Patches -- Oracle Database [ID 756671.1] 11.2.0.1 Patch Set Updates - List of Fixes in each PSU [ID 1340010.1]Document Version Download link 12419378 11.2.0.1....

SQL> alter index intest rebuild tablespace test1 parallel(degree 2);Index altered.SQL> alter index intest rebuild tablespace test1 parallel(degree 3);Index altered.SQL> alter index intest rebuild tabl...

专有服务模式*******session 16*******SQL>  select count(*) from utest.tab1;  COUNT(*)----------2SQL> select * from tab1;        ID----------21开始一个...

1.关闭数据库shutdown immediate 1.解压patch文件[oracle@～ 11.2.0]$ unzip p14402980_112030_Linux-x86-64.zip 2.进入patch目录下[oracle@～ 11.2.0]$ cd 14402980 3.安装patch[oracle@...

 select s.type,p.spid,s.username,s.process,s.machine, s.program from  v$session s,v$process p where s.paddr=p.addr; select owner, job_name, session_id, slave_os_process_id, running_i...

 SELECT ksppinm, ksppstvl, ksppdesc FROM x$ksppi x, x$ksppcv y WHERE x.indx = y.indx AND ksppinm = '_eliminate_common_subexpr'; note:315631.1 A1: The hidden parameters start with a...

动态注册1.确定service_names 和 instance_name 两个参数的值QL> show parameter service_namesNAME                 &nb...

在以下版本中使用dbms_stats 收集的信息有误Oracle 9i Release 2 (9.2.0)Oracle Database 10g Release 1(10.1.0)原因是有bugBUG:3491127在Oracle Database 10g Release 2(10.2.0)中修复SQL> create table test&...

开启em[oracle@dbserver ~]$ emctl start dbconsoleOracle Enterprise Manager 11g Database Control Release 11.2.0.2.0Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.https://dbserver...

创建没指定logging_clause 的分区索引SQL> CREATE INDEX prod_idx ON hash_products(category_id) LOCAL STORE IN (tbs_01, test_space);Index created.查看 user_indexes 视图的logging值是空，user_indexes...

查看归档模式SQL> archive log list修改归档模式SQL> startup mountSQL> alter database archivelog;SQL> alter database open;SQL> archive log listDatabase log mode      &nbsp...

Increasing the Size of a Tablespacehttp://docs.oracle.com/cd/E11882_01/server.112/e25494/tspaces007.htm#BABDFCAE You can increase the size of a tablespace by either increasing the size of a dat...

安装 statspackSQL> create tablespace test_pace datafile '/ora10/base/oradata/tid002/test_pace01.dbf' size 250m extent management local autoallocate;Tablespace created.SQL> @spcreate.sql创建快照SQL...

跟踪sql语句开启一个新sessionSQL> exec dbms_session.set_sql_trace(true);PL/SQL procedure successfully completed.SQL>  insert into tab001 values (1000009,'a');1 row created.SQL> commit;Commit...

SQL> create table t01 as select * from dba_objects;Table created.手动创建快照SQL> exec DBMS_WORKLOAD_REPOSITORY.CREATE_SNAPSHOT ();PL/SQL procedure successfully completed.生成AWR报告SQL> @awrrptCur...

How To Implement OS Authentication in Web Forms for a Remote Database Authentication? [ID 577787.1]Configuring an External Service to Authenticate Users and Passwordshttp://docs.oracle.com/cd/E11882_...

SQL> select * from v$version;BANNER----------------------------------------------------------------Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - ProdSQL> show parameter global_namesNA...

ORACLE LIFETIME SUPPORT BROCHUREShttp://www.oracle.com/us/support/lifetime-support/lifetime-support-software-342730.html Oracle Lifetime Support Policy：Oracle Technology Productshttp://www.or...

set linesize 200 #每行最多显示200个字符，缺省为80set pagesize 0     #设置每页显示的行数，默认是24，设置成0表示不分页set numwidth 5     #设置number类型的长度，...

参考：17 Managing Partitioned Tables and Indexeshttp://docs.oracle.com/cd/B19306_01/server.102/b14231/partiti.htmManaging Indexeshttp://docs.oracle.com/cd/B19306_01/server.102/b14231/indexes.htm#i...