Top Menu

• Home
• Articles
  • Oracle
    • Backup & Recovery
      • Duplicating Database using RMAN duplicate command
      • How to check Corruption in Database datafile
      • Backup and Recovery Examples
      • FlashBack Database Technology [Part-5]
      • FlashBack Database Technology [Part-4]
      • FlashBack Database Technology [Part-3]
      • FlashBack Database Technology [Part-2]
      • FlashBack Database Technology [Part-1]
      • Using RMAN Repository (Part-3)
      • Backup and recovery operations using RMAN (Part-2)
      • Introduction to RMAN [Part-1]
      • Understanding basic recovery strategy
      • Common questions, should know before starting backup and recovery process
      • Key data structures
      • Types of Backup
      • Introduction to backup and recovery
    • Performance Tuning
      • Tuning with Histograms
      • Tuning using Materilized Views
      • Tuning using SQL Plus AutoTrace
      • Tuning examples using TKPROF & SQL Trace (Part-2)
      • Tuning with TKPROF & SQL Trace (Part-1)
      • Explain Plan
      • Query Optimizer
      • Intoduction to oracle tuning
• Interview Questions
  • Oracle
    • Architecture
      • What is PMON process?
    • Backup & Recovery
      • What is inconsistant backup and When it can be happend and Why it performed?
      • Why more redos are generated when the database is in begin backup mode?
    • Performance Tuning
      • What is Full Outer Joins?
      • What is Outer Joins?
      • What is Cartesian Joins?
      • What is Sort Merge Joins?
      • What is Hash Joins?
      • What is Nested Loop Joins?
      • What are joins? How query optimizer executes join statements and chooses execution plan for join statement?
      • What are the different types of access path that can be followed by optimizer?
      • What is an access path for query optimizer?
      • What do you mean by Histograms?
      • What are optimizer statistics how can be collected?
      • What is optimizer mode SQL Hint and what does?
      • How optimizer mode can be change?
      • What do you mean by “Throughput” or “Best response Time”?
      • What operation query optimizer performs?
      • What are the types of query optimizer?
      • What is query optimizer and what does?
      • What is TKPROF?
      • What is SQL Trace?
      • How you run explain plan statement?
      • What is the explain plan? and what type of information explain plan contains?
      • What is the Explain plan statement advantage?
      • What is the Explain plan statement disadvantage?
      • What is the plan table? Describe its purpose?
      • How you can create plan table if plan table already not exists?
      • What are the important fields of plan table?
      • What are the methods can be used to display plan table output (Execution Plan)?
• Site Map