Restore completed in percentage: very important TTITLE LEFT '% Completed. Aggregate is the overall progress:' SET LINE 132 SELECT opname, round(sofar/totalwork*100) "% Complete" FROM gv$session_longops WHERE opname LIKE 'RMAN%' AND totalwork != 0 AND sofar <> totalwork ORDER BY 1; TTITLE LEFT 'Channels waiting:' COL client_info FORMAT A15 TRUNC COL event FORMAT A20 TRUNC … Continue reading Checking how much restore is completed:
While working in the production or real world environment, you will see that second thing we check after the database is running is listner, as listner resolves the connection from the clients, today I am going to gather questions which will help us to understand the listner and clear the interviews......... what is listener in … Continue reading Oracle Listner
Name Description First Normal Form An entity is in First Normal Form (1NF) when all tables are two-dimensional with no repeating groups. A row is in first normal form (1NF) if all underlying domains contain atomic values only. 1NF eliminates repeating groups by putting each into a separate table and connecting them with a one-to-many … Continue reading Normalization
Tuesday, 21 February 2012 AWR REPORT ANALYSING 1.Introduction 1.1.Purpose of Document AWR (Automatic Workload Repository) Reports are very handy during performance tuning of the database. These reports provide clear picture of database side activities. Various useful data is nicely documented in different sections in readable format. It becomes necessity to understand these reports for teams … Continue reading AWR REPORT ANALYSING
Overview If you notice poor performance in your Oracle database Row Chaining and Migration may be one of several reasons, but we can prevent some of them by properly designing and/or diagnosing the database. Row Migration & Row Chaining are two potential problems that can be prevented. By suitably diagnosing, we can improve database performance. … Continue reading ROW Chaining and Migration
Enabling Dataguard Broker Observer I recently had occasion to research the use of the Dataguard Broker observer (Observer). The concept behind the Observer is to have a process running on a separate server that observes the Dataguard Broker on the primary and the standby. When there is a problem with the primary, the broker will initiate … Continue reading Dataguard Observer
Purpose of SQL Tuning : A SQL statement becomes a problem when it fails to perform according to a predetermined and measurable standard. After you have identified the problem, a typical tuning session has one of the following goals: Reduce user response time, which means decreasing the time between when a user issues a statement … Continue reading SQL Tuning……..
Difference between Role and Privilege in Oracle Database There is always some level of confusion between Role and Privilege in Oracle Database. It is important to understand their usage as both are assigned to user to access resources of database. Privilege can be compared with authentication. To access any website we should have a require … Continue reading Difference between roles and privileges: