Common Issues

Steps to Identify and Remove Table Fragmentation

In Oracle schema there are tables which has huge difference in actual size (size from User_segments) and expected size from user_tables (Num_rows*avg_row_length (in bytes)). This…

Read More »

How to find Table Fragmentation in Oracle Database

How to find Table Fragmentation in Oracle Database What is Oracle Table Fragmentation? If a table is only subject to inserts, there will not be…

Read More »

Adjusting The Password Expiration Policy

Adjusting The Password Expiration Policy Doing a default database installation will install a feature that all passwords will expire after 180 days. Unaware of that…

Read More »