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: May 19, 2016

  1. Home
  2. 2016
  3. May
  4. 19
koncpt-img
19May
  • Performance tuning
  • 32 Comments
  • 8174 views
Can you really flush Oracle SHARED_POOL?

One of the major player in the SGA is SHARED_POOL, without which we can say that there are no query executions. During some performance tuning trials, you would have used ALTER SYSTEM command to flush out the contents in SHARED_POOL. Do you really know what exactly this command cleans out? As we know that internally […]

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