Monday Sep 23, 2013

In-Memory in Oracle

  • Oracle TimesTen In-Memory Database
    Oracle TimesTen In-Memory Database, is a memory-optimized, stand-alone relational database that empowers applications with the responsiveness and high throughput required by today's real-time enterprises and industries such as telecommunications, capital markets, and defense. Deployed in the application or middle tier as an embedded database, TimesTen uses standard structured query language (SQL) to operate on databases that fit entirely in physical memory.

 

  • Oracle In-Memory Database Cache
    Oracle In-Memory Database Cache is an Oracle Database option that is ideal for caching performance-critical subsets of an Oracle database’s frequently accessed data for improved response time in the application tier. IMDB Cache uses TimesTen as its RDBMS engine. IMDB Cache offers applications the full generality and functionality of a relational database, the transparent maintenance of cache consistency with the Oracle database, and the real-time performance of an in-memory database.

 

  • Oracle In-Memory Parallel Execution
    Oracle In-Memory Parallel Execution (In-Memory PX) introduced in Oracle Database 11g Release 2, takes advantage of this large aggregated database buffer cache. By having PX servers access objects via the database buffer cache they can scan data at least 10 X faster than they can on disk.

 

  • Oracle Exalytics In-Memory Machine
    Oracle Exalytics In-Memory Machine is the first engineered system specifically designed to deliver high performance analysis, modeling, and planning. Built by using industry-standard hardware, Oracle’s BI software, and in-memory database technology, Oracle Exalytics is an optimized system that delivers answers to all your business questions with unmatched speed, intelligence, simplicity, and manageability.

 

  • Oracle Exadata X3 Database In-Memory Machine
    Oracle Exadata X3 Database In-Memory Machine can store up to hundreds of Terabytes of compressed user data in Flash and RAM memory, virtually eliminating the performance overhead of reads and writes to slow disk drives, making Exadata X3 systems the ideal database platforms for the varied and unpredictable workloads of cloud computing.

 

  • Oracle In-Memory Applications
    Oracle In-Memory Applications are new set of application tools that provides a bottoms-up approach to maximizing profit margins by enabling near real-time insight. Oracle In-Memory Applications are built ground up to leverage Oracle’s unique hardware and technology capabilities: Exadata’s industry-leading data storage technologies, Exalogic’s middle tier technology, and Exalytics’ in-memory applications, all connected using InfiniBand technology to deliver extreme performance.

 

  • Oracle Database In-Memory Option
    Oracle Database In-Memory option is a solution for accelerating database-driven business decision-making to real-time speeds. Unlike specialized approaches that are restricted to particular workloads or applications, the unique approach of Oracle Database In-Memory leverages a new in-memory column store format to speed up analytic, data warehousing, and reporting workloads, while also accelerating transaction processing (OLTP) workloads.

Tuesday Jul 23, 2013

Exadata X3 Database12c Update

Exadata Database Machine X3-2 Data Sheet New Jun 2013

• Oracle Database 11g and 12c.

Exadata Database Machine X3-8 Data Sheet New Jun 2013

• Oracle Database 11g and 12c

Oracle In-Memory Applications Whitepapers

      

EBS

OTM

VCP

HYPERION

FUSION APPLICATIONS

JDE

PSFT

SIEBEL

BI

Monday Dec 10, 2012

Oracle Database Appliance Now Certified by SAP

All SAP products based on SAP NetWeaver 7.x that are also certified for Oracle Database 11g Release 2 (single node or RAC) can now be used with the Oracle Database Appliance. RAC One Node is NOT supported.

Only Three-Tier SAP Installations. Only the Oracle database can run on the Oracle Database Appliance.

 No SAP instance can be deployed on the Oracle Database Appliance. SAP instances have to run on different middle-tier machines of any hardware architecture and operating system.

Central Services (ASCS and/or SCS) can be configured to run on the Oracle Database Appliance for Unicode installations of SAP.

SAP BR*Tools support is now available for the Oracle Database Appliance.

For more information about SAP on ODA, please refer:

Using SAP NetWeaver with the Oracle Database Appliance New Nov2012
Note 1760737 - SAP Software and Oracle Database Appliance (ODA)
Note 1785353 - ODA 11.2.0: Patches for 11.2.0.3

 

Sunday Nov 25, 2012

How to recreate spfile on Exadata?

  1. Copy spfile from the ASM diskgroup to local disk by using the ASMCMD command line tool.
     ASMCMD> pwd
    +DATA_DM01/EDWBASE
    ASMCMD> ls -l
    Type Redund Striped Time Sys Name
    Y CONTROLFILE/
    Y DATAFILE/
    Y ONLINELOG/
    Y PARAMETERFILE/
    Y TEMPFILE/
    N spfileedwbase.ora =>
    +DATA_DM01/EDWBASE/PARAMETERFILE/spfile.355.800017117
    ASMCMD> cp +DATA_DM01/EDWBASE/spfileedwbase.ora /home/oracle/spfileedwbase.ora.bak
  2. Copy the context from spfileedwbase.ora.bak to initedwbase.ora except garbled character.
  3. Using above initedwbase.ora, start one of the RAC instances to the mount phase. 
     SQL> startup mount pfile=/home/oracle/initedwbase.ora
  4. Ensure one of the database instances is mounted before attempting to recreate the spfile. 
    SQL> select INSTANCE_NAME,HOST_NAME,STATUS from v$instance;
    INSTANCE_NAME HOST_NAME  STATUS
    ------------- ---------  ------
    edwbase1      dm01db01   MOUNTED
  5. Create the new spfile.
    SQL> create spfile='+DATA_DM01/EDWBASE/spfileedwbase.ora' from pfile='/home/oracle/initedwbase.ora';
  6. ASMCMD will show that a new spfile has been created as the alias spfilerac2.ora is now pointing to a new spfile under the PARAMETER directory in ASM.
    ASMCMD> pwd
    +DATA_DM01/EDWBASE
    ASMCMD> ls -l
    Type Redund Striped Time Sys Name
    Y CONTROLFILE/
    Y DATAFILE/
    Y ONLINELOG/
    Y PARAMETERFILE/
    Y TEMPFILE/
    N spfilerac2.ora =>
    +DATA_DM01/EDWBASE/PARAMETERFILE/spfile.356.800013581
     
  7. Shutdown the instance and restart the database using srvctl using the newly created spfile.
    SQL> shutdown immediate
    ORA-01109: database not open
    Database dismounted.
    ORACLE instance shut down.
    SQL> exit
    [oracle@dm01db01 ~]$ srvctl start database -d edwbase
    [oracle@dm01db01 ~]$ srvctl status database -d edwbase
    Instance edwbase1 is running on node dm01db01
    Instance edwbase2 is running on node dm01db02
  8. ASMCMD will now show a number of spfiles exist in the PARAMETERFILE directory for this database. The spfile containing the parameter preventing startups
    should be removed from ASM.
    In this case the file spfile.355.800017117 can be removed because spfile.356.800013581 is the current spfile.
    ASMCMD> pwd
    +DATA_DM01/EDWBASE
    ASMCMD> cd PARAMETERFILE
    ASMCMD> ls -l
    Type Redund Striped Time Sys Name
    PARAMETERFILE UNPROT COARSE FEB 19 08:00:00 Y spfile.355.800017117
    PARAMETERFILE UNPROT COARSE FEB 19 08:00:00 Y spfile.356.800013581
    ASMCMD> rm spfile.355.800017117
    ASMCMD> ls
    spfile.356.800013581

Referenece: Recreating the Spfile for RAC Instances Where the Spfile is Stored in ASM [ID 554120.1]

Monday Oct 29, 2012

Exadata X3 Expandability Update

Exadata Database Machine X3-2 Data Sheet New 10/29/2012

Up to 18 racks can be connected without requiring additional InfiniBand switches.

Exadata Database Machine X3-8 Data Sheet New 10/24/2012

Scale by connecting multiple Exadata Database Machine X3-8 racks or Exadata Storage Expansion Racks. Up to 18 racks can be connected by simply connecting via InfiniBand cables. Larger configurations can be built with additional InfiniBand switches.


 

White Paper for SAP on Oracle Database Features & Options

SAP on Oracle Development Update New Oct2013

RAT for SAP

RAC for SAP

OCFS for SAP

DG for SAP

OEM for SAP

Partition for SAP

Security for SAP

ODV for SAP 

TDE for SAP 

AC for SAP

ASM for SAP

Monday Oct 15, 2012

Using CTAS & Exchange Partition Replace IAS for Copying Partition on Exadata

Usage Scenario:

Copy data&index from one partition to another partition in a partitioned table.

Solution:

  1. Create a partition definition
    Copy data from one partition to another partiton by 'Insert as select (IAS)'
  2. Create a nonpartitioned table by 'Create table as select (CTAS)'
    Convert a nonpartitioned table into a partition of partitoned table by exchangng their data segments.
    Rebuild unusable index

Exchange Partition Convertion

  1. Mutual convertion between a partition (or subpartition) and a nonpartitioned table
  2. Mutual convertion between a hash-partitioned table and a partition of a composite *-hash partitioned table
  3. Mutual convertiton a [range | list]-partitioned table into a partition of a composite *-[range | list] partitioned table.

Exchange Partition Usage Scenario

  1. High-speed data loading of new, incremental data into an existing partitioned table in DW environment
  2. Exchanging old data partitions out of a partitioned table, the data is purged from the partitioned table without actually being deleted and can be archived separately

Exchange Partition Syntax

ALTER TABLE schema.table EXCHANGE [PARTITION|SUBPARTITION] [partition|subprtition] WITH TABLE schema.table [INCLUDE|EXCLUDING] INDEX [WITH|WITHOUT] VALIDATION UPDATE [INDEXES|GLOBAL INDEXES]

INCLUDING | EXCLUDING INDEXES Specify INCLUDING INDEXES if you want local index partitions or subpartitions to be exchanged with the corresponding table index (for a nonpartitioned table) or local indexes (for a hash-partitioned table). Specify EXCLUDING INDEXES if you want all index partitions or subpartitions corresponding to the partition and all the regular indexes and index partitions on the exchanged table to be marked UNUSABLE. If you omit this clause, then the default is EXCLUDING INDEXES.

WITH | WITHOUT VALIDATION Specify WITH VALIDATION if you want Oracle Database to return an error if any rows in the exchanged table do not map into
partitions or subpartitions being exchanged. Specify WITHOUT VALIDATION if you do not want Oracle Database to check the proper mapping of rows in the exchanged table. If you omit this clause, then the default is WITH VALIDATION. 

UPADATE INDEX|GLOBAL INDEX Unless you specify UPDATE INDEXES, the database marks UNUSABLE the global indexes or all global index partitions on the table whose partition is being exchanged. Global indexes or global index partitions on the table being exchanged remain invalidated. (You cannot use UPDATE INDEXES for index-organized tables. Use UPDATE GLOBAL INDEXES instead.)

Exchanging Partitions&Subpartitions Notes

  1. Both tables involved in the exchange must have the same primary key, and no validated foreign keys can be referencing either of the tables unless the referenced
    table is empty.
  2.  When exchanging partitioned index-organized tables:
    – The source and target table or partition must have their primary key set on the same columns, in the same order.
    – If key compression is enabled, then it must be enabled for both the source and the target, and with the same prefix length.
    – Both the source and target must be index organized.
    – Both the source and target must have overflow segments, or neither can have overflow segments. Also, both the source and target must have mapping
    tables, or neither can have a mapping table.
    – Both the source and target must have identical storage attributes for any LOB columns. 

Sunday Oct 14, 2012

Partition Table and Exadata Hybrid Columnar Compression (EHCC)

  • Create EHCC table
    • CREATE TABLE ... COMPRESS FOR [QUERY LOW|QUERY HIGH|ARCHIVE LOW|ARCHIVE HIGH];

      select owner,table_name,compress_for DBA_TABLES where compression = ‘ENABLED';
  • Convert Table/Partition/Subpartition to EHCC
    • Compress Table&Partition&Subpartition to EHCC:
      ALTER TABLE table_name MOVE COMPRESS FOR [QUERY LOW|QUERY HIGH|ARCHIVE LOW|ARCHIVE HIGH] [PARALLEL <dop>];
      ALTER TABLE table_name MOVE PARATITION partition_name COMPRESS FOR [QUERY LOW|QUERY HIGH|ARCHIVE LOW|ARCHIVE HIGH] [PARALLEL <dop>];
      ALTER TABLE table_name MOVE SUBPARATITION subpartition_name COMPRESS FOR [QUERY LOW|QUERY HIGH|ARCHIVE LOW|ARCHIVE HIGH] [PARALLEL <dop>];

      select owner,table_name,compress_for DBA_TABLES where compression = ‘ENABLED';
      select table_owner,table_name,partition_name,compress_for DBA_TAB_PARTITIONS where compression = ‘ENABLED’;
      select table_owner,table_name,subpartition_name,compress_for DBA_TAB_SUBPARTITIONS where compression = ‘ENABLED’;

    • Rebuild Unusable Index:
      select index_name from dba_indexes where status = 'UNUSABLE';
      select index_name,partition_name from dba_ind_partitions where status = 'UNUSABLE';
      select index_name,subpartition_name from dba_ind_subpartitions where status = 'UNUSABLE';

      ALTER INDEX index_name REBUILD [PARALLEL <dop>];
      ALTER INDEX index_name REBUILD PARTITION partition_name [PARALLEL <dop>];
      ALTER INDEX index_name REBUILD SUBPARTITION subpartition_name [PARALLEL <dop>];
  • Convert Table/Partition/Subpartition from EHCC to OLTP compression or uncompressed format:
    • Uncompress EHCC Table&Partition&Subpartition:
      ALTER TABLE table_name MOVE [NOCOMPRESS|COMPRESS for OLTP] [PARALLEL <dop>];
      ALTER TABLE table_name MOVE PARTITION partition_name [NOCOMPRESS|COMPRESS for OLTP] [PARALLEL <dop>];
      ALTER TABLE table_name MOVE SUBPARTITION subpartition_name [NOCOMPRESS|COMPRESS for OLTP] [PARALLEL <dop>];

      select owner,table_name,compress_for DBA_TABLES where compression = '';
      select table_owner,table_name,partition_name,compress_for DBA_TAB_PARTITIONS where compression = '';
      select table_owner,table_name,subpartition_name,compress_for DBA_TAB_SUBPARTITIONS where compression = '';
    • Rebuild Unusable Index:
      select index_name from dba_indexes where status = 'UNUSABLE';
      select index_name,partition_name from dba_ind_partitions where status = 'UNUSABLE';
      select index_name,subpartition_name from dba_ind_subpartitions where status = 'UNUSABLE';

      ALTER INDEX index_name REBUILD [PARALLEL <dop>];
      ALTER INDEX index_name REBUILD PARTITION partition_name [PARALLEL <dop>];
      ALTER INDEX index_name REBUILD SUBPARTITION subpartition_name [PARALLEL <dop>];

Friday Oct 12, 2012

SAP Software on Oracle Exadata X3

Note 1590515 - SAP Software and Oracle Exadata New v17 04.10.2012

Oracle Exadata Database Machine can be used in SAP environments when the following conditions are met:

  • Supported Oracle Exadata Database Machine models:
    • X2-2
    • X2-8
    • X3-2
    • X3-8

Wednesday Oct 10, 2012

Document Link about Database Features on Exadata

DBFS(Database File System) on Exadata

DBRM/IORM(Database Resource Manager, I/O Resource Manager) on Exadata 

EHCC(Exadata Hybrid Columnar Compression) on Exadata 
 
PX(Paralle Execution) on Exadata

Partition on Exadata

FTP on Exadata

VNC on Exadata

  • Enable database hosts in Exadata Database Machine for using up2date or yum and vncserver [ID 1234710.1]  

XP(Exchange Partition) on Exadata

OGG(Oracle Golden Gate) on Exadata

BR(Backup & Recovery) on Exadata

OEM(Oracle Enterprise Manager) on Exadata

MAA(Maximum Availability Architecture) on Exadata

DG(Data Guard) on Exadata

Consolidation on Exadata

IB(InfiniBand) on Exadata

Sunday Sep 02, 2012

Errata of Expert Oracle Exadata Chinese Edition-深入理解 Oracle Exadata 勘误表

  • P10 因为这些CPU都属于Westmere系列,都内置支持AES解压加密功能,这实质上就提供了硬件支持的加密和解压解密
    Because these CPUs are in the Westmere family, they have built in AES encryption support, which essentially provides a
    hardware assist to encryption and decryption.
  • P39 特别是对于高压缩率的数据,所以还是决定将解压缩放到数据库存储服务器上完成。
    particularly with the higher levels of compression, the decision was made to do the decompression on the storage servers.
  • P101
     表名  压缩类型  压缩率  运行时间  运行时间比
     表名  压缩类型  实际压缩率  估算压缩率  错误率
     Table Name  Compress For

     Actual
    Compression
    Ratio

     Estimated
    Compression
    Ratio
     Error Percentage

  • P167 http://docs.oracle.com/cd/E11882_01/server.112/e25513/initparams187.htm#refrn10314
           
    http://docs.oracle.com/cd/E11882_01/server.112/e25523/parallel005.htm#VLDBG1491
  • P211 在11.2版本中,Clusterware 得到了极大的更新 (并改名为 Grid Infrastructure) 。
    Clusterware was heavily updated in version 11.2 (and renamed Grid Infrastructure).

  • P285 I/O相关指标接下来的问好分可能是R(读)或者W(写),紧跟着SWSM或者LG,分别代表小读写操作或大读写操作。
    For I/O-related metrics, the next part of the metric name may be R (for reads) or W (for writes) followed by SM or LG for small or large reads and writes.

  • P495 表14-6 最后一行  闪存盘 IOPS
                                       Flash Disk IOPS

 

Tuesday Jul 24, 2012

Notes for Applications on Engineered Systems

Exalogic for SAP

Exadata for SAP

SuperCluster for SAP

OEL for SAP

RAC for SAP

OEM for SAP

ASM for SAP

BR*Tools for ASM&Exadata

RAT for SAP

ACO for SAP

ODV for SAP

EBS on Exadata

  • Deploying Oracle E-Business Suite on Oracle Exalogic Elastic Cloud and Oracle Exadata Database Machine [Doc ID 1460742.1] New Sep2012
  • Migrating an Oracle E-Business Suite Database to Oracle Exadata Database Machine (Doc ID 1133355.1)
  • Oracle E-Business Suite Release 11i & R12 Patches Required with Oracle Database 11g Release 2 (11.2.0) on Exadata(Doc ID 1392527.1)

PS on Exadata

  • Tech Update - PeopleSoft Certifies 11gR2 RAC and Exadata V2 [ID 1081504.1]
  • Performance and Tuning for Oracle’s PeopleSoft HCM 9.1 HR Self Service on Oracle Exalogic/Exadata X2-2 Servers [ID 1384242.1]

Siebel on Exadata

  • Siebel On Exadata Recommendations [ID 1339734.1]
  • Performance Tuning Guidelines for Siebel CRM Application on Oracle Database [ID 781927.1]

JDE on Exadata

  • JD Edwards EnterpriseOne with the Sun Oracle Database Machine Performance Characterization (Doc ID 1188240.1)
About

Bandari Huang | Exadata Solution Consultant Phone: +86-21-2302-3838 | Mobile: +86-156-9213-8783 Oracle Exadata & Strategic Solutions Consulting, Great China

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today