Showing Indexes with BR*Tools

Use

You can use BR*Tools  for Oracle to show information about indexes.

Procedure

...

       1.      Start the procedure using BRGUI or BRTOOLS, or from the command line:

Ў        BRGUI or BRTOOLS:

                                                  i.       Choose Segment management ® Additional segment functions  ® Show indexes.

BRGUI or BRTOOLS displays the menu BRSPACE main options for showing database information, where you specify the options with which you call BRSPACE.

                                                ii.       Set the required options:

Menu Entry

Equivalent BRSPACE

Command Option

BRSPACE profile (profile)

-p|-profile

Database user/password (user)

-u|-user

Database tablespace (tablespace)

-f dbshow -s|-tablespace

Database owner (owner)

-f dbshow -o|-owner

Database table (table)

-f dbshow -t|-table

Database index (index)

-f dbshow -i|-index

If required, you can enter the names of multiple objects in Database index or Database table by using wildcards. For more information, see “Selecting Objects“ in Segment Management with BR*Tools.

In Database tablespace and Database owner, you can specify multiple objects but you cannot use wildcards.

BRSPACE processes all the indexes in the specified tablespace(s), or all indexes belonging to the specified owner(s) or table(s).

                                               iii.       Choose Continue.

BRGUI or BRTOOLS displays a further menu, Additional BRSPACE options for showing database information, where you specify the additional options with which you call BRSPACE.

Menu Entry

Equivalent BRSPACE

Command Option

Create log file (log)

-f dbshow -l|-log

Confirmation mode (confirm)

-c|-confirm

Extended output (output)

-o|-output

Scrolling line count (scroll)

-s|-scroll

Message language (language)

-l|-language

BRSPACE command line (command)

This shows you the BRSPACE –f dbshow -c idinfo command that is to be executed using the current settings.

                                               iv.       Choose Continue

BRGUI or BRTOOLS prompts you to start BRSPACE.

                                                 v.       Choose Continue to start BRSPACE.

Ў        Command line:

...

Enter at least the following command:

brspace –f dbshow –c idinfo

You can enter more parameters if required. For more information, see BRSPACE -f dbshow.

BRSPACE starts and you see a message that includes Start of BRSPACE processing. From now on, BRSPACE writes a detail log if you set the option Create log file (parameter –l|-log).

If you started BRSPACE from the command line without the information class name (-c|-class) – that is, with brspace –f dbshow – BRSPACE displays the Show database information main menu.

Choose Show database segment information ® Show indexes.

       2.      If you have already entered a single index name, continue with step 4.

BRSPACE displays the List of database indexes:

List Entry

Meaning

Pos.

List sequence number

Owner

Table owner

Table

Table name

Index

Index name

Part.

Partitioned (yes / no)

Parts

Number of partitions for partitioned table

Paral.

Degree of parallelism

Tablespace

Tablespace name

Analyzed

Date last analyzed by update statistics

Rows

Number of rows

Space[KB]

Total space allocated to the index

Used[KB:%]

Used space in index: percentage of total space used

Data [KB:%]

Amount of data in index: percentage of total space for data

To see more information, select one or more indexes.

These examples only apply to input in character mode.

To select the first three entries in the list, enter 1-3.

To select the first and third entries, enter 1,3.

To select the first three entries and the fifth, enter 1-3,5.

To select all entries, enter 0.

BRSPACE displays Information about index:

List Entry

Meaning

Unique index (unique)

Unique index: yes or no

Bitmap index (bitmap)

Bitmap index: yes or no

Partitioned index (partitioned)

Partitioned index: yes or no

Number of partitions (partitions)

Number of partitions for partitioned index

Parallel degree (parallel)

Degree of parallelism

Table name (table)

Table name

Tablespace name (tablespace)

Tablespace name

Last analyzed (analyzed)

Date last analyzed by update statistics

Sample size (sample)

Sample size of update statistics

Number of rows (rows)

Number of rows

Allocated space in KB (space)

Total space allocated to the index

Used space in KB / % (used)

Used space in index: percentage of total space used

Pure data in KB / % (data)

Amount of data in index: percentage of total space for data

Next extent size (next)

Next extent size

Maximum number of extents (maxextents)

Maximum number of extents possible

       3.      If you specified multiple indexes, choose Continue to scroll through.

Results

If you set the option Create log file (parameter –l|-log), check the results in the BRSPACE logs.

·        The summary log space<DBSID>.logdisplays the return code.

·        The detail log s<encoded timestamp>.dbw displays the details.

For more information on how to view the logs with BR*Tools, see Showing Logs and Profiles with BR*Tools.