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 (911)
    • Big Data (3)
      • Cassandra (2)
      • Hadoop (1)
    • MongoDB (5)
    • MySQL (519)
      • Errors (515)
    • Oracle (208)
      • Errors (2)
      • Oracle Basics (35)
      • Oracle RAC (12)
      • Oracle Tasks (4)
      • Oracle Tuning (4)
    • PostgreSQL (339)
      • Aurora (12)
      • Errors (256)
      • How To – Postgres (45)
      • Postgres Performance Tuning (8)
    • RedShift (5)
  • Featured (11)
  • Self Improvement (3)
  • Tutorial (7)
  • Uncategorized (12)
  • Video (10)

Recent Posts

  • pg_cron Guide: Scheduled Jobs, Monitoring & Gotchas
  • Aurora PostgreSQL Storage Architecture Explained
  • Postgres Time-Series Partition Maintenance, Done Right
  • pgvector Index Tuning: HNSW vs IVFFlat, Explained
  • Postgres Is Down: A 5-Minute Triage Tree
  • pg_cancel_backend vs pg_terminate_backend: Full Runbook
  • Postgres TOAST: A Practical Storage Checklist
  • Postgres Row-Level Security: A Multi-Tenant Playbook
  • Postgres Full-Text Search vs Elasticsearch: A Real Comparison
  • Fix “No pg_hba.conf Entry for Host” in Postgres
  • Postgres Wait Events: A Practical Triage Guide
  • Postgres Replication Lag Is Four Numbers, Not One
  • UUID vs BigInt Primary Keys in Postgres: Index Bloat Explained
  • How to Increase max_connections in Postgres Safely
  • PostgreSQL Transaction ID Wraparound: Cause and Fix
  • Postgres Free Space Map: Why Deletes Don’t Shrink Tables
  • Partition Pruning Isn’t Magic — Here’s When It Actually Works
  • Auto_explain PostgreSQL: Capture Slow Query Plans in Production
  • Postgres jsonb_array_elements: Turn JSON arrays into queryable rows inside SQL
  • Physical and logical replication solve different problems at different layers of
© 2026 Philip McClarence • Built with GeneratePress