Skip to Main Content
Forums

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index Rebuild VS analyze index-compute statics VS DBMS_STATS.GATHER_INDEX_S

user4295847Apr 1 2013 — edited Apr 4 2013
Hi ,

I have little doubt on below listed topics. Please explain me each topics and when we need to use for same. Can I use these all at a time ? WHat are advantages and disadvantages forthese topics ?

1) Index Rebuild and index rebuild online
2) analyze index-compute statics and validate strcture
3) DBMS_STATS.GATHER_INDEX_STATS
This post has been answered by Fran on Apr 4 2013
Jump to Answer

Comments

cormaco
Answer

You can try the Instance Viewer in SQL Developer:
SQL Developer Concepts and Usage (oracle.com)
The database instance viewer enables a DBA user to see a graphical representation of information about the instance associated with a connection. The types of information displayed include:
Database
Clients
Sessions
Processes (Counts, Execution Rate, Parse Rate, Open Cursors, Commit Rate)
Waits
Memory (DB Block Rate, Logical Reads, Allocation, Redo Generation)
Storage (Files, Redo Log)
DB CPU Ratio (database operations as a percentage of CPU activity)
Top SQL (provides performance metrics on SQL operations, which are sorted based on the CPU time required)
You can interact with the instance viewer display, including:
Panning the diagram by dragging it
Zooming the diagram in or out by using control-drag
Drilling down to a detailed display by hovering over graphical element to show a dark blue border and then double-clicking in that element
You can control the amount of history shown in graphs that include a time axis by using the Database: Instance Viewer preferences.

Marked as Answer by Ali Raza Memon · Jul 24 2022
Ali Raza Memon

Thanks for the detailed explanation. Do you know any open source one?

cormaco

Thanks for the detailed explanation. Do you know any open source one?
You are aware that SQL Developer is free (but not open source)?
Oracle SQL Developer - Oracle SQL Developer Releases
Oracle SQL Developer is a free graphical tool that enhances productivity and simplifies database development tasks.

kuljeet singh -

EM Express URL would serve the purpose.

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 2 2013
Added on Apr 1 2013
#general-database-discussions, #index
10 comments
248 views