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

EXPLAIN PLAN

  1. Home
  2. Posts tagged "EXPLAIN PLAN"
14Apr
  • Performance tuning
  • 10 Comments
  • 1874 views
What exactly is PLAN_TABLE in Oracle Database?

Every user session on Oracle database will be able to access default table PLAN_TABLE to collect execution plan of a query from EXPLAIN PLAN command. But, how is this table available to all the users in the database and gets empty once you disconnect? Is this table available and created for every user logging into […]

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