loading
hello dummmy text
  • +91 9951696808
  • reachus@orskl.com
koncpt
  • Solutions
    • Data Pooling
    • Integrated Analytics
    • ML Engineering
    • Product Development
  • Upskill
    • Data Engineering
      • Big Data Engineering – Essentials
      • Big Data Engineering – Booster
      • Big Data Engineering – Advanced (Upcoming)
      • Big Data Engineering – Pro (Upcoming)
      • AWS for Data Engineers (Upcoming)
      • GCP for Data Engineers (Upcoming)
    • Advanced Analytics (Upcoming)
    • ML Engineering (Upcoming)
    • Programming
      • Python Fundamentals
      • SQL Foundation
      • Shell Scripting for Beginners
    • Oracle DBA
  • Blog
  • Tools
  • Opportunities
  • Reach us

Daily Archives: September 7, 2015

  1. Home
  2. 2015
  3. September
  4. 07
koncpt-img
07Sep
  • Performance tuning
  • 3 Comments
  • 928 views
EXPLAIN PLAN for multiple SQL statements

EXPLAIN PLAN is often used to generate execution plan of SQL statement or set of SQL statements. But we would always prefer to run EXPLAIN PLAN for each SQL statement and generate its execution plan using DBMS_XPLAN package and then pick up next SQL statement. But we can also run EXPLAIN PLAN for multiple SQL […]

Read More

Knowledge that can always keep your Inbox informed

Categories

  • Data Analytics (3)
  • Datapump (1)
  • General topics (7)
  • Network (1)
  • Performance tuning (13)
  • PL/SQL (1)
  • RAC (4)
  • Recovery (3)
  • RMAN (3)
  • Storage (3)
  • Tablespace management (2)

Recent Post

December 02, 2019
Build Simple Machine Learning Web Application using Python
March 01, 2019
Ways to identify if data is Normally Distributed
February 11, 2019
Will highly correlated variables impact Linear Regression?
January 09, 2018
Will Oracle 18c impact DBA roles in the market?

Tags

11gR2 Block size Cloud control file Correlated variables database datafile Data Science DBA jobs EXECUTION PLAN EXPLAIN PLAN Global Temporary Table Kernel parameters Kurtosis LBA Linear Regression LINUX Load Balancing Advisor Machine Learning Normal distribution Oracle Oracle 11g Oracle 11gR2 Oracle 18c Oracle Cloud Oracle database Oracle data blocks performance tuning PLAN_TABLE Python RAC RAID Recycle bin redo log RESULT CACHE SCAN listener Shared pool SHMALL SHMMAX SHMMNI SQL tuning SQL_ID Storage performance Table Web Application

Contact

  • RKP Mansion, 1-11-251/11, Beside Vasant Towers, Begumpet, Hyderabad, Telangana 500016.
  • +91 9951696808
  • reachus@orskl.com

Data Engineering

  • Big Data Engineering – Booster
  • Big Data Engineering – Advanced
  • Big Data Engineering – Pro
  • AWS for Data Engineers
  • GCP for Data Engineers

Advanced Analytics

  • Data Analytics
  • Data Science – Foundation

ML Engineering

  • Starter
  • Advanced

Programming

  • Shell Scripting for Beginners
  • SQL Foundation
  • Python Fundamentals
  • Oracle DBA
Copyright 2022 ORSKL All Rights Reserved.

Knowledge That Can Always Keep Your Inbox Informed