Blog

What is a Storage Index? Storage Indexes are a feature unique to Oracle Exadata. A storage index is a memory-based structure that reduces the amount of physical IO required by the cell. A storage index keeps track of minimum and maximum values from query predicates and builds storage index regions based on usage.   The […]

What is a Storage Index? Storage Indexes are a feature unique to Oracle Exadata. A storage index is a memory-based structure that reduces the amount of physical IO required by the cell. A storage index keeps track of minimum and maximum values from query predicates and builds storage index regions based on usage.   The […]

Deferred COGS is a new feature introduced in Oracle E-Business Suite Release 12. The basic fundamentals behind the enhancement are that the COGS are now directly matched to the Revenue. Prior to this enhancement, the value of goods shipped from inventory were expensed to COGS upon ship confirm, despite the fact that revenue may not […]

In Oracle 11gR2, additional Exadata cell-related system events have been added to the normal system event-based dynamic performance views. There are 58 different cell-related or Flash Cache related wait events available: SQL> l 1 select name from v$statname 2* where name like ‘%cell%’ or name like ‘%flash cache%’ SQL> / cell physical IO interconnect bytes […]

With the release of EBS R12, Oracle has released some new features on how data is accessed through the applications and standard programs by the use of Multiple Organization Access Control (MOAC). MOAC allows you to create a security group which can contain many operating units and assign that to the User’s responsibility. All the […]

Recently on an Oracle EBS R12 project, the client had a requirement to enable the attachment functionality on one of the WIP forms.  I would like to share 4 steps that can be done to enable attachments to work on just about any Oracle EBS form. First, verify that you have the “Application Developer” responsibility […]

In Oracle 11gR2, additional Exadata cell-related system events have been added to the normal system event-based dynamic performance views. There are 58 different cell-related or Flash Cache related wait events available:   SQL> l 1 select name from v$statname 2* where name like ‘%cell%’ or name like ‘%flash cache%’ SQL> / cell physical IO interconnect […]

Cell Server Metrics Metrics are recorded observations of run-time properties and internal instrumentation values in the storage cell and its components, such as cells, cell disks, grid disks, etc. CellCLI> list metricdefinition where objectType=’CELLDISK’ <detail> CellCLI> list metricdefinition where objectType=’GRIDDISK’ <detail> The “detail” clause at the end of the listing will show additional details about […]

Using CELLCLI Each Exadata Storage cell can be monitored, configured, and maintained using the cellcli command line interface. To invoke the CLI, simply login to the Exadata cell as cellmonitor, celladmin, or root, and type “cellcli”. Within cellcli, a wide range of commands can be invoked to monitor the cell. Macintosh-7:~ jclarke$ ssh [email protected] [email protected]’s […]

Upgrading Exadata to 11.2.0.3 and Applying Bundle Patch 14 In this blog, I’ll walk you through the abbreviated steps to apply Bundle Patch 14 on our Exadata X2-2 Quarter Rack.  I say “abbreviated” because I’m simply going to bullet all the steps – this is no substitute for reading the various README files. For BP14, […]