ERROR: ccr.oracle.com installing Oracle Agent

If you are installing Oracle Grid Control agent in silent mode and got this error below:


Checking Temp space: must be greater than 150 MB. Actual 52640 MB Passed
Checking swap space: must be greater than 150 MB. Actual 5686 MB Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2011-02-04_04-04-02PM. Please wait ...ERROR: ccr.oracle.com


Run the installation again adding the "-y" parameter like this:

./agentDownload.linux -b /u01/agent11g -y



Best Regards,
Paulo Portugal

Using Flash Cash on Tables with Exadata

When creating tables to use Exadata Flash Cash use the sintaxe below:

CREATE TABLE tab1 (col1 number)
PARTITION BY RANGE (col1)
(PARTITION p1 VALUES LESS THAN (1000)
STORAGE (CELL_FLASH_CACHE KEEP),
PARTITION p2 VALUES LESS THAN (2000)
STORAGE (CELL_FLASH_CACHE NONE),
PARTITION p3 VALUES LESS THAN (3000)
STORAGE (CELL_FLASH_CACHE DEFAULT));


You can also use ALTER TABLE or ALTER INDEX as follows:

ALTER INDEX idx1 STORAGE (CELL_FLASH_CACHE KEEP);


Best Regards,
Paulo Portugal

Table compression in 11gR2 Databases and Exadata

If you need to create a compress table for an OLTP system use the syntax below:

create table TAB_1(
col1 number,
col2 varchar2(30))
COMPRESS FOR OLTP;

If you need to create a compress table for Direct Load use the command below:

create table TAB_2 (
col1 number,
col2 varchar2(30))
COMPRESS BASIC;


Now you want to compress for Exadata Machine. For warehouse compression use:

CREATE TABLE tab_1 (
col1 number,
col2 varchar2(30))
COMPRESS FOR QUERY [ LOW | HIGH ] ;

For Online Archival Compression use:

CREATE TABLE tab_1 (
col1 number,
col2 varchar2(30))
COMPRESS FOR ARCHIVE [ LOW | HIGH ] ;


Best Regards,
Paulo Portugal

Exadata Smart Scan - CELL_OFFLOAD_PLAN_DISPLAY parameter

If you want to control whether the offload status is show in execution plan set the parameter as below:

ALTER SYSTEM OR SESSION SET CELL_OFFLOAD_PLAN_DISPLAY=ALWAYS;

The value options for this parameter are:
AUTO -> display the predicate if cell is present and table is on the cell
ALWAYS -> always show
NEVER -> never show offload status


Some views that can be used to gather cell statistics information:

V$SQLAREA
V$SQLSTATS
V$SQLAREA_PLAN_HASH
V$SQLSTATS_PLAN_HASH


on columns like :

IO_CELL_OFFLOAD_ELIGIBLE_BYTES
IO_CELL_OFFLOAD_RETURNED_BYTES



Best Regards,
Paulo Portugal