How to find Sessions generating high redo/archives in Oracle

Sometimes, database generates lot more archives than the normal. In this article I will show you how to find them. Below are the queries to drill down to the root cause and fix the issue.

If there is a drastic change in redo/archive generation run below queries.. Get the segment that experienced the most […]
Continue reading…

 

Which Oracle index is a good candidate for a rebuild

This script determines whether an index is a good candidate for a rebuild or for a bitmap index. All indexes for a given schema or for a subset of schema’s are analyzed (except indexes under SYS and SYSTEM) . Instructions Execution Environment:

Access Privileges: Requires DBA privileges in order to be executed. Usage:

[…]
Continue reading…