• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

Oracle Performance Tuning

Oracle Performance Tuning  is very important part. It is not just the Oracle DBA responsibility ,it is also the responsibility of Oracle developers.Performance tuning should starts before Design and should be continuously tested. We need to have good Knowledge of Oracle Software working. Many times problems occurs as we are not aware of the working of the Oracle

In this section,We are presenting the Oracle performance tuning articles which will help you in solving the problems quickly

Tuning Tools

  1. Oracle Explain Plan
  2. Autotrace in Oracle
  3. Oracle Performance :sql_trace parameter and its impact
  4. How to turn on the trace in database and Format the trace file
  5. Sql tuning advisor

Performance Terms explained

  1. What is Logical I/O and Physical I/O in Oracle Database
  2. how to find session generating lots of redo
  3. What is IOPS and How to calculate it in oracle
  4. What is DB time and Average Active sessions, Active session in oracle
  5. Bind Variable in Oracle
  6. Automatic Database Diagnostic Monitor (ADDM)
  7. Active Session History(ASH)
  8. Automatic Workload Repository(AWR)
  9. Hanganalyze and system state dump
  10. Oracle waits events
  11. How to find which sid is doing full table scan

Optimizer

  1. New Optimizer Feature with 11g
  2. Optimizer hints
  3. find optimizer/database underscore parameter
  4. Optimizer Mode
  5. Join Methods in Oracle

Statistics

  1. Find indexes and assigned columns for a table
  2. How Table Monitoring and STATISTICS_LEVEL parameter are connected from 10g onwards
  3. How to check Stale statistics
  4. How to find table where statistics are locked

General Performance topics

  1. sql tuning in Oracle
  2. Nested Loop Join in Oracle
  3. Hash join in Oracle
  4. Oracle performance & tuning Quiz
  5. Oracle Index clustering factor
  6. How to turn on the SQL trace, 10046 event in Oracle database and trcsess, tkprof utility
  7. Incremental Statistics Gathering in 11g
  8. Useful scripts for Oracle Database
  9. Oracle table locks
  10. All Useful 11g Dynamic Performance Views
  11. How to find the waitevent History of the Oracle session
  12. Virtual Index in Oracle
  13. Oracle Performance tuning Glossary

We will keep adding the Knowledge article for Oracle Performance tuning . Please do subscribe to the blog to get the latest articles. Also Please do provide the Feedback

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • How to check Stale statistics
  • Java web start(JWS) in R12
  • How to delete the archive logs in Oracle
  • How to generate sql monitor report in Oracle
  • How to find the long running (longops session) in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us