• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar
Techgoeasy

Techgoeasy

Learn Oracle, PHP, HTML,CSS,Perl,UNIX shell scripts

  • Home
  • Oracle
    • Oracle database
    • Oracle Ebusiness Suite
    • Oracle weblogic
    • Oracle Performance Tuning
    • Oracle Hyperion
    • Oracle Cloud Tutorials
  • SQL
  • interview questions
  • Linux
  • PHP and HTML
  • Downloads
  • General

parallel processing

How Parallel execution works in Oracle database

July 13, 2020 by techgoeasy Leave a Comment

What is Parallel Execution in Oracle database Parallel execution in oracle allows a single SQL statement to be executed by a multiple processes executing concurrently on different CPU’s. It increases throughput by utilizing more resources (Memory, CPU & I/O).It uses a pool of instance background processes (query slaves) .Based on Parallel Execution you are able […]

Filed Under: Oracle, Oracle Database Tagged With: parallel processing

How to monitor parallel queries in oracle database

February 1, 2020 by techgoeasy Leave a Comment

Parallel execution is a important aspect of increasing throughput in oracle database.So often use Parallel execution in Oracle database. In this post, i will touch upon Important Parallel processing data dictionary views and How to monitor parallel queries in oracle database Parallel Processing Data Dictionary views In this section we are trying to give a […]

Filed Under: Oracle, Oracle Database Tagged With: parallel processing, Parallel Processing Data Dictionary views

Primary Sidebar



Subscribe to our mailing list

Enter your email address to subscribe to this blog and receive notifications of new posts by email

Recent Posts

  • Top Queries on Sql plan Management
  • Move SQL Baseline from One Database to Another in Oracle
  • How to drop the sql baseline in Oracle
  • how to create sql baseline from AWR repository without STS
  • how to create sql baseline from Sql tuning set in Oracle

Copyright © 2023 : TechGoEasy

  • Hire me
  • Privacy Policy
  • Contact Us
  • New? Start Here
  • About Us
x
x