Friday, February 14, 2014

Tables will inherit HCC compression from Tablespace

We are on the Exadata.
The idea: to create the tablespace with HCC and move tables there.
Will tables be HCC-compressed ? Will tables inherit the COMPRESS FOR from the tablespace ?

Today i did the test and answer is YES !

Test env: we have the table BILLS in the non-HCC tablespace.
I created the new tablespace:

SQL> create bigfile tablespace HCC blocksize 8k datafile '+DATAC1'
size 1344m autoextend on next 1344m maxsize unlimited
default COMPRESS FOR QUERY HIGH
extent management local uniform size 4m
segment space management auto;

Tablespace created.


SQL> create table BILLS_HCC tablespace HCC as select * from BILLS;

Table created.


SQL> select segment_name, bytes from dba_segments where segment_name like 'BILLS%';

SEGMENT_NAME             BYTES
------------ -----------------
BILLS              27313307648
BILLS_HCC           6954156032


SQL> select 27313307648/6954156032 from dual;

27313307648/6954156032
----------------------
  3.927623642943305187


SQL> select table_name, compression,compress_for from dba_tables where table_name like 'BILLS%';

TABLE_NAME       COMPRESS COMPRESS_FOR
---------------- -------- ------------
BILLS_HCC        ENABLED  QUERY HIGH
BILLS            DISABLED

SQL> set timing on
SQL> select count(*) from BILLS;

            COUNT(*)
--------------------
           146432303

Elapsed: 00:00:02.83
SQL> select count(*) from BILLS_HCC;

            COUNT(*)
--------------------
           146432303

Elapsed: 00:00:02.65

Thursday, February 13, 2014

Patchmgr hungs in the process of patching IB switches

As you know, the January 2014 Quarterly Full Stack Patch (QFSP) for Exadata contain new IB switches version - 2.1.3-4.
In many cases (my experience - 4 switches of 6) the command hungs:
./patchmgr -ibswitches -upgrade

It nothing do and wait something. We waited 1 hour and press Ctrl+C.
 
The SOLUTION is:

When you connect to Unix server the ssh daemon running on this server get your IP and try to resolve your IP into the name.
Such behavior is controlled by parameter UseDNS in /etc/ssh/sshd_config file.
By default the line look like:
#UseDNS=yes

Remove the # and change it to "no" :
UseDNS=no

And run patchmgr again !

Thursday, February 6, 2014

Is it acceptable / supported to install additional or 3rd party software on Exadata machines and how to check for conflicts?

The interesting note appeared on the MOS:

Is it acceptable / supported to install additional or 3rd party software on Exadata machines and how to check for conflicts? 
(Doc ID 1541428.1)

 In short:


Answer is a qualified yes (Customers can add software ONLY to the DB Nodes, never to the storage cells).
Items to consider before installing additional RPMS:
1) Customer installed software must not update any Exadata provided packages.
2) Customer is fully responsible for the additional software.
3) Future Exadata Software updates may remove customer installed packages or the upgrades may fail due to customer installed packages.
4) If a customer installed package is removed as part of an Exadata Software update, the customer is responsible for re-verifying the package and re-installing if needed.

 

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...