SQL Memory Management in Oracle9i

Summary: Analyzes Oracle9i SQL memory management, where sort/hash-join operators need in-memory work areas and share limited memory. Shows DBA-driven tuning is brittle under unpredictable workloads, arguing for a fair, efficient memory allocation strategy. (summarized by gpt-5-nano on Feb 09 2026)

Paper ID: 8914
Venue: VLDB
Year: 2002
Pagerank: 0.0001047003
Overall Rank: 1,810 | 87.41%
DOI: -

Incoming Non-self Citations Over Time

Authors

1. Benoît Dageville
2. Mohamed Zait

Incoming Citations (Sorted by Pagerank)

Showing 16 of 16 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
663	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00018469455
765	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.00017016449
1,136	Chain: Operator Scheduling for Memory Minimization in Data Stream Systems	2003	SIGMOD	0.00013760154
1,827	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00010390548
3,114	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	7.5451724e-05
4,240	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	6.3318228e-05
4,617	Adaptive Query Processing in the Looking Glass	2005	CIDR	6.0446738e-05
8,186	E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model	2025	VLDB	4.5651684e-05
8,442	SageDB: An Instance-Optimized Data Analytics System	2022	VLDB	4.5120602e-05
8,627	Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines	2024	SIGMOD	4.4829101e-05
8,798	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	4.4489415e-05
9,899	Accelerating Analytics with Dynamic In-Memory Expressions	2016	VLDB	4.2600049e-05
10,093	MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration	2026	SIGMOD	4.1945683e-05
10,635	Saving Private Hash Join	2025	VLDB	4.1945683e-05
10,931	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.1945683e-05
12,591	Computing Frequent Itemsets Inside Oracle 10G	2004	VLDB	4.1945683e-05

Outgoing Citations (Sorted by Pagerank)

Showing 0 of 0 cited papers.

Citations counted here include only citations to other VLDB/SIGMOD/CIDR/PODS papers in this database.

Rank	Cited Paper	Year	Venue	Pagerank

Semantically Similar Papers

Overall Rank	Paper	Year	Venue	Pagerank
4,571	Adaptive Statistics in Oracle 12c	2017	VLDB	6.0773174e-05
12,427	Managing Query Compilation Memory Consumption to Improve DBMS Throughput	2007	CIDR	4.1945683e-05
1,079	What happens during a Join? Dissecting CPU and Memory Optimization Effects	2000	VLDB	0.00014233415
1,309	Query Processing in Main Memory Database Management Systems	1986	SIGMOD	0.00012660929
5,539	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB	5.4503121e-05
2,451	Write-limited sorts and joins for persistent memory	2014	VLDB	8.7856313e-05
9,464	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR	4.3355852e-05
4,741	Memory-Adaptive External Sorting	1993	VLDB	5.95905e-05
4,891	Distributed Architecture of Oracle Database In-memory	2015	VLDB	5.8516672e-05
5,186	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB	5.6400929e-05