Recover data of table from FLASHBACK


In this post , we are going to explain how can you recover the data of a table from the past timestamp with FLASHBACK on

Top "ForeGround Wait Events" from AWR history

This post describe the SQL to fetch "Top 5 Fore-Ground Wait Events" from history of Oracle database which can be used to analyze the performance of database while a defined time interval.

Top SQL by "Physical Reads" from AWR history


This post describe the SQL to fetch TOP SQL by Physical Reads from Historical per AWR Snapshots from history of Oracle database which can be used to analyse the performance of database while a defined time interval.

Top SQL by "Elapsed Time" reads from AWR history

This post describe the SQL to fetch "TOP SQL by Elapsed Time" from history of Oracle database which can be used to analyse the performance of database while a defined time interval.

Segmentation Fault During Duplicate From Active Database

Scope:
This post explains the solution to resolve the SEGMENT FAULT error message while Duplicate database from source using RMAN Duplicate method.

Symptoms:
channel ORA_DISK_1: starting datafile copy
copying current control file
Oracle instance started

How to find bind variable name and value of a SQL Id


Scope:

Some times it is required by a DBA to find explain plan of a query which might be responsible for bad performance of your database.

Top SQL by Logical reads from AWR history

Scope: 

This blog shared method to fetch TOP sqls from history of Oracle database which can be used to analyse the performance of database while a defined time interval.


Search