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 11, 2015

  1. Home
  2. 2015
  3. September
  4. 11
koncpt-img
11Sep
  • Performance tuning
  • 1 Comment
  • 918 views
Ways of generating EXECUTION PLAN in Oracle Database

Generating EXECUTION PLAN from explain plan is the best method of reading the plan that optimizer defined for executing a SQL statement in Oracle Database. There are multiple ways of generating such execution plans, one is by running EXPLAIN PLAN and other from V$SQL_PLAN. In this blog, I am going to cover in detail about […]

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