Partition & Index/Search Specs

Colin_Schmidt

Here are two ORACLE LRs that will report some of the specifications/settings of each Partition and Index.  The Search specs that are in the DTREE.EXTENDEDDATA are identical to the Index.  I haven't figured out yet how(specifically: WHERE) to report the Index Percentages and that may never happen. 

The Partition LR will report:  Partition Name, Server, Partition Mode (R/W, Update), Max Content, Max Metadata, % Full Warn, Start Rebalancing, Stop Rebalancing, Stop Adding.

The Index LR will report: Admin Server name, Name of the Index, Index Directory, Server Port, Port, & LogFIle & path.

I wrote these because sometimes I need to know some of this and with our 176 partitions, it can take more than a while, particular when even one is down.

If anyone has any hints for more related information, let the forum know.  I hope these help.

PartitionIndex_Spec-LiveReport.rpt

Colin_Schmidt

Here's an update to the Oracle LR that combines the Partition Mode (Read/Write, Update) along with the Index.  If we're on CS 10, it's no longer necessary to have some in "Update Only", but never the less, some of us do.  This will report the Index, index drives, Admin server, ports.  

One portion of the code checks if the Index name starts with "Enterprise" and has "Partition 1", "Partition 10" v. "Partition 001" or "Partition 010" (for sorting purposes.  If you have a different naming scheme, you'll have to adjust the code.  As always, there may be better ways at picking this information out.

I remove all single-quotes to clean it up, then parce it out.

Partition-n-Index-specs_LiveReport.rpt