Check Objects in Flashcache in Oracle Exadata

The Exadata Smart Flash Cache is a great Performance optimizer. The contents of the flash cache can be read fro m the cell servers on Exadata. But one of the restrictions on this is that it only lists the object id’s and not the name of the object. So that requires us to map those object ID’s to Object name in DBA_OBJECTS view. We can use Oracle’s very powerful dcli utility to colelct the object id’s from all cells and scp to the DB nodes and load it into an External table to join it with the DBA_OBJECTS view. 1. Firstly we have to add all cells to dcli utilitylist flashcache listcell chmod 700 mycommands.scl dcli -g cells.txt -l root -x mycommands.scl ## this will give output of commands put in file mycommands.scl from all cell nodes ## Incase if there is error with one key then drop and recreate that cells key[root@exatestceladm01 ~]# dcli -c exatestceladm01 --unkey -l root root@exatestceladm01’s password: exatestceladm01: ssh key dropped ## Rekey that cell root@exatestceladm01 ~]# dcli -g ./cells.txt -l root -k -s ‘-o StrictHostKeyChecking=no’ root@exatestceladm01’s password: exatestceladm01: ssh key added exatestceladm02: ssh key already exists exatestceladm03: ssh key already exists ————————————————————————– Configure DB nodes SSH using dcli command utility On Any Cell node create a text file in /root called db.txt exatestdbadm01 exatestdbadm02 chmod 700 db.txt

Most likely your database is an Orace RAC DB so create the same directory structure for the external table files on both nodes and make sure the clean file is SCP’ed to both compute nodes from the cell node.