Search

Top 60 Oracle Blogs

Recent comments

March 2013

Listing Exadata storage cells and their configuration info from V$CELL_CONFIG

If you attended my Exadata hacking session today, you saw me using the cellver.sql script which lists some basic configuration info about the currently connected storage cells:

Listing Exadata storage cells and their configuration info from V$CELL_CONFIG

If you attended my Exadata hacking session today, you saw me using the cellver.sql script which lists some basic configuration info about the currently connected storage cells:
SQL> @exadata/cellver
Show Exadata cell versions from V$CELL_CONFIG....
CELLNAME CELLSRV_VERSION FLASH_CACHE_MODE CPU_COUNT UPTIME KERNEL_VERSION MAKE_MODEL
-------------------- -------------------- -------------------- ---------- -------------------- ------------------------------ --------------------------------------------------
192.168.12.10 11.2.3.2.1 WriteBack 24 8 days, 2:07 2.6.32-400.11.1.el5uek Oracle Corporation SUN FIRE X4270 M2 SERVER SAS
192.168.12.11 11.2.3.2.1 WriteBack 24 8 days, 2:06 2.

Listing Exadata storage cells and their configuration info from V$CELL_CONFIG

If you attended my Exadata hacking session today, you saw me using the cellver.sql script which lists some basic configuration info about the currently connected storage cells:
SQL> @exadata/cellver
Show Exadata cell versions from V$CELL_CONFIG....
CELLNAME CELLSRV_VERSION FLASH_CACHE_MODE CPU_COUNT UPTIME KERNEL_VERSION MAKE_MODEL
-------------------- -------------------- -------------------- ---------- -------------------- ------------------------------ --------------------------------------------------
192.168.12.10 11.2.3.2.1 WriteBack 24 8 days, 2:07 2.6.32-400.11.1.el5uek Oracle Corporation SUN FIRE X4270 M2 SERVER SAS
192.168.12.11 11.2.3.2.1 WriteBack 24 8 days, 2:06 2.

OIC(A) again

Issues with OICA/OIC (OPTIMIZER_INDEX_COST_ADJ/OPTIMIZER_INDEX_CACHING) parameters have already been mentioned many times. Recently I’ve noticed one more and I think I didn’t see this case somewhere else on the Internet so I’ll share it.


Here’s a simple table T1 holding 1M rows with the indexed column X having 10 distinct values:

Join Jonathan Lewis for a discussion of Delphix

tires

Kicking the Tires on Delphix

Live webcast: Jonathan Lewis  – An Oracle Expert’s Look at the Delphix Technology

Jonathan Lewis came out to the Delphix offices in Menlo Park, CA to kick the tires on our product for a week.

Virtual IOUG Collaborate 13 for Only $299

class="l-submain">
class="l-submain-h g-html i-cf">

https://www.pythian.com/blog/wp-content/uploads/IOUG20-360x161.png 360w" sizes="(max-width: 300px) 100vw, 300px" />For only $299, you can access Virtual IOUG Collaborate 13 individually or set up a conference room at your company for the whole team. There will be two tracks broadcasted, so if you have demand for both tracks, it makes sense to purchase two access passes and setup two tracks broadcasted in parallel in your office so that members of your team can individually choose what to attend.

Next OakTable 2012 video is online

Hi,

This time Alex Gorbachev presentation about ASM failures - next videos on the way.

Next OakTable 2012 video is online

Hi,

This time Alex Gorbachev presentation about ASM failures - next videos on the way.

Share, share, share…

Sometimes there are these days that I need to remember why…