ITPub博客

[root@localhost ~]# mkdir -p ctgmq_deploy/version[root@localhost ~]# cd ctgmq_deploy/version[root@localhost version]# pwd/root/ctgmq_deploy/version[root@localhost version]# cd[root@localhost ~]# ll总用量 14108drwxr-xr-x 3 root root       20 3月  17 15:26 ctg...

Oracle Database - Enterprise Edition - Version 11.2.0.2 and laterCovers release 11.2The purpose of this note is to supplement the HAIP information available in Grid Infrastructure Redundant Interconnect and ora.cluster_interconnect.haip  QUESTIONS AND ANSWERSHighly Availa...

How to Create Oracle Database QoS Management Administrator Accounts[oracle@oratest1 bin]$ srvctl status oc4jOC4J is enabledOC4J is running on node oratest1[oracle@oratest1 bin]$ qosctl qosadmin -setpasswd qosadmin-bash: qosctl: command not found[oracle@oratest1 bin]$ iduid=1101(oracle) g...

Step by step guide on how to create a physical standby database using RMAN DUPLICATE FROM ACTIVE DATABASE command without shutting down the primary and using primary active database files (No need to take a backup)My Env config：Database Name :prod1Primary db_unique_name :prod1standby db_uni...

   When the WHERE clause of a query specifies multiple columns from a single table (multiple single column predicates), the relationship between the columns can strongly affect the combined selectivity for the column group.For example, consider the customers table in the SH schema. Th...

   Result Cache is a feature introduced in Oracle 11g which caches the results of a query in the shared pool.  It is ideal for a query that is used frequently and rarely changes.  Once the initial query has been cached, Oracle retrieves the result of the query from the cache,...

Convert Range-Partitioned Table To Interval-Range-Partitioned Table     first of all,Interval partitioning is an extension of range partitioning, where the system is able to create new partitions as they are required. The PARTITION BY RANGE clause is used in the normal ...

     Virtual columns can be indexed like any other non virtual columns. The index created is always a function based index. If the index is B-tree index, it is recognized as FUNCTION-BASED NORMAL. For bitmap indexes, it is recognized as FUNCTION-BASED BITMAP.SQL> col DATA_TY...

    Reference partitioning allows tables related by foreign keys to be logically equi-partitioned. The child table is partitioned using the same partitioning key as the parent table without having to duplicate the key columns. Partition maintenance operations performed on the ...

      上一篇我介绍和测试了oracle 11g版本引入的虚拟列新特性，本文继续测试分区键基于表的虚拟列：Prior releases of Oracle only allowed a table to be partitioned based on a physical column. Oracle 11g, with the addition of virtual columns, now allows a partition key based on ...

The syntax for defining a virtual column is listedbelow. column_name [datatype] [GENERATED ALWAYS] AS(expression) [VIRTUAL]If the datatype is omitted, it is determined based onthe result of the expression. The GENERATED ALWAYS and VIRTUAL keywords areprovided for clarity only.where...

First of all,How Recall?An end user recovers from erroneous transactions that were previously committed in the database. The undo data for the erroneous transactions is no longer available, but because the required historical information is available in the Flashback Data Archive, Flashback Query...

     You can encrypt any permanent tablespace to protect sensitive data. Tablespace encryption is completely transparent to your applications, so no application modification is necessary. Encrypted tablespaces primarily protect your data from unauthorized access by means oth...

      SQL Access Advisor index recommendations include bitmap, function-based, and B-tree indexes. A bitmap index offers a reduced response time for many types of ad hoc queries and reduced storage requirements compared to other indexing techniques. Bitmap indexes are ...

     In oracle 11g releases,oracle introduce a new feature,this is Direct NFS.Like as oracle 10g DIO,which  implies faster  performance and more scalable access to NFS storage located on NAS storage devices (accessible over TCP/IP...

lsdsk The lsdsk command lists ASM-visible disks. You can restrict the output to only those disks that match a pattern, which can include wildcard characters and slashes. You can run this command in either the connected mode or the non-connected mode. In the connected mode, the command retrieves d...

solution 1：srvctl relocate service -d -s -I;crsctl relocate resource $resource_name;solution 2：srvctl start nodeapps -n <node name>;like as:crs1:[resdb1:/oracle]$crs_stat -tName           Type           Target    State   &n...

My env as follows:OS:[root@ORACLERAC2 ~]# uname -aLinux ORACLERAC2 2.6.32-358.el6.x86_64 #1 SMP Tue Jan 29 11:47:41 EST 2013 x86_64 x86_64 x86_64 GNU/Linux[root@ORACLERAC2 ~]# cat /proc/version Linux version 2.6.32-358.el6.x86_64 (mockbuild@x86-022.build.eng.bos.redhat.com) (gcc version 4...

db版本信息：SQL*Plus: Release 10.2.0.4.0 - Production on Fri Jan 22 09:15:52 2016Copyright (c) 1982, 2007, Oracle.  All Rights Reserved.Connected to:Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit ProductionWith the Partitioning, Real Application Clusters, OLAP, Data Min...

<h2 class="km"><span style="line-height:1;font-size:16px;font-family:'Microsoft YaHei';">Applies to:</span></h2><span style="line-height:1;font-size:16px;font-family:'Microsoft YaHei';">Oracle Database - Enterprise Edition - Version 11.2.0.3 and later</span><br /><span style="line-height:1;font...