Oracle Ride
  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Errors
  • Training
    • Registration
    • Feedback
  • Contact Me

Performance Tuning

Database Performance Tuning

Active Session History (ASH)

The Oracle wait event model was originally introduced in Oracle7. Wait event information is gathered by the Oracle MMON background process, stored in intermediate x$ structures in a circular SGA buffer, and later transferred to Oracle10g dba_hist tables. Oracle 10g introduced the Active Session History (ASH) as part of the Diagnostics and Tuning Read more…

By Ahmad, 2 years2 years ago
Database Performance Tuning

The Query Optimizer (the optimizer)

The Query Optimizer(the optimizer)     The query optimizer is built-in database software. The query optimizer attempts to generate the most efficient execution plan for a SQL statement. The query optimizer considers many factors related to the objects referenced and the conditions specified in the query. This determination is an Read more…

By Ahmad, 2 years2 years ago
Database Oracle12c Performance Tuning

Performance Impact Parameters in 12c R2

Tuning of the database is very challenging work for the DBA. For this DBA should use Proactive strategy for the database. In Proactive strategy dba should work on few things when they are creating database. We know that for database creation parameter file is required which contains parameters & its Read more…

By Ahmad, 4 years2 years ago
Database Oracle12c Performance Tuning

Configuring a Database for Performance

Tuning of the database is very challenging work for the DBA. These days client wants everything should be fast on the database. It is possible if DBA will use Proactive strategy for the database. For Proactive strategy, DBA should work on a few things when they are creating a database. Read more…

By Ahmad, 4 years2 years ago
Oracle ACE
Oracle ACE Associate
Awarded Top 60 Oracle Blogs
Recent Posts
  • ORA-12520: TNS listener could not find available handler for requested type of server
  • Oracle GoldenGate 21c(21.3.0) is out for use!
  • Oracle 21c has only CDB-PDB Architecture
Categories
  • Career (1)
  • Cloud (7)
  • Data Guard (3)
  • Database (104)
  • ERRORS (6)
  • GoldenGate (11)
  • Interview Questions (44)
  • Oracle12c (7)
  • Oracle19c (7)
  • Oracle20c (2)
  • Oracle21c (5)
  • Performance Tuning (4)
  • Personal (2)
  • RAC (6)

Riaz Ahmad Ansari is an Oracle Consultant, Speaker, Blogger, YouTuber & Mentor.

He is famous for Ahmad’s nickname in the IT industry.

He has many years of experience as a production Oracle DBA managing all operating system based Oracle Databases.

He started working with Oracle Database starting from Oracle 9i to 10g/11g/12c18c/19c.

He has hands-on experience in real-world Production environments.

He is skilled with Oracle technologies such as Core DBA work, Data Guard, RMAN, Backup & Recovery, RAC, Cloud Control, and Performance Tuning.

  • Email
    ahmad@oracleride.com
  • Phone
    +91 9648108988
Follow Me
  • whatsapp
  • linkedin
  • facebook
  • twitter
  • youtube

Copyright ©️ 2020 OracleRide. All Rights Reserved.


  • Home
  • About Me
  • Database
  • Cloud
  • GoldenGate
  • Errors
  • Training
  • Contact Me
Developed and Maintained by Demunix