Skip to content

Philip McClarence

  • PostgreSQL
    • Aurora
    • Errors
    • How To – Postgres
  • MongoDB
  • MySQL
  • Cassandra
  • Hadoop
  • Oracle
    • Oracle Basics
    • Oracle News
    • Errors
    • Oracle Tasks
    • Oracle RAC
    • Oracle Tuning

oracle server process

How does Oracle Read Data

11/10/201211/10/2012 by Philip

Reading from the Oracle RDMS is done by the users server process Once a query is submitted, the users server process first determines if data is in the buffer cache of the SGA (System Global Area) memory area. If the data is not already in the buffer cache, Oracle reads the data from the data …

Read more

Categories Featured, Oracle Basics Tags buffer cache, oracle server process, system global area

Categories

  • Cloud (10)
    • AWS (10)
      • AWS Glue (4)
      • Lake Formation (2)
  • Data Warehousing (6)
  • Databases (885)
    • Big Data (3)
      • Cassandra (2)
      • Hadoop (1)
    • MongoDB (5)
    • MySQL (494)
      • Errors (490)
    • Oracle (208)
      • Errors (2)
      • Oracle Basics (35)
      • Oracle RAC (12)
      • Oracle Tasks (4)
      • Oracle Tuning (4)
    • PostgreSQL (338)
      • Aurora (12)
      • Errors (256)
      • How To – Postgres (45)
      • Postgres Performance Tuning (7)
    • RedShift (5)
  • Featured (11)
  • Self Improvement (3)
  • Tutorial (7)
  • Uncategorized (12)
  • Video (10)

Recent Posts

  • How to Manage MySQL Storage Engines: Selecting the Optimal Solution for Your Database Needs
  • How to Manage Schema Evolution in Aurora PostgreSQL for Seamless AWS Redshift Data Warehousing Integration
  • How to Manage Data Retention in AWS Data Warehouses: Best Practices for Compliance and Efficiency
  • How to Diagnose and Fix the ORA-01550 Error in a Distributed Transaction in Oracle
  • Diagnosing and Fixing the ORA-01288 Error in Oracle: Out of Transaction Table Slots for Distributed Transaction
  • How to Diagnose and Fix the ORA-02043 Transaction Rolled Back Error in Oracle
  • How to Diagnose and Fix the ORA-01776 Error in Oracle
  • How to Diagnose and Fix the ORA-01251 Error in Oracle
  • How to Diagnose and Fix the ORA-02041 Error in Oracle
  • Diagnosing and Fixing the ORA-01317 Error in Oracle
  • How to Diagnose and Fix ORA-01675 Error in Oracle
  • How to Diagnose and Fix the ORA-01969 Error in Oracle
  • Diagnosing and Fixing the ORA-01781 Error in Oracle
  • How to Diagnose and Fix the ORA-00352 Error in Oracle
  • How to Diagnose and Fix the ORA-01181 Error in Oracle
  • How to Diagnose and Fix the ORA-01782 Error in Oracle
  • How to Diagnose and Fix the ORA-00384 Error in Oracle
  • Diagnosing and Fixing the ORA-00960 Error in Oracle
  • How to Diagnose and Fix ORA-00384 Error in Oracle
  • How to Diagnose and Fix the ORA-00960 Error in Oracle
© 2025 Philip McClarence • Built with GeneratePress