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: 8915
Venue: VLDB
Year: 2002
Pagerank: 0.00010471365
Overall Rank: 1,810 | 87.43%
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
661	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00018488168
760	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.00017003914
1,136	Chain: Operator Scheduling for Memory Minimization in Data Stream Systems	2003	SIGMOD	0.00013745517
1,816	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00010438512
3,105	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	7.5567226e-05
4,216	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	6.3448176e-05
4,618	Adaptive Query Processing in the Looking Glass	2005	CIDR	6.039398e-05
7,676	E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model	2025	VLDB	4.6770108e-05
8,434	SageDB: An Instance-Optimized Data Analytics System	2022	VLDB	4.5077955e-05
8,624	Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines	2024	SIGMOD	4.4786127e-05
8,795	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	4.4446768e-05
9,898	Accelerating Analytics with Dynamic In-Memory Expressions	2016	VLDB	4.2559233e-05
10,093	MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration	2026	SIGMOD	4.1905499e-05
10,643	Saving Private Hash Join	2025	VLDB	4.1905499e-05
10,934	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.1905499e-05
12,600	Computing Frequent Itemsets Inside Oracle 10G	2004	VLDB	4.1905499e-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,566	Adaptive Statistics in Oracle 12c	2017	VLDB	6.073045e-05
12,436	Managing Query Compilation Memory Consumption to Improve DBMS Throughput	2007	CIDR	4.1905499e-05
1,077	What happens during a Join? Dissecting CPU and Memory Optimization Effects	2000	VLDB	0.00014224986
1,337	Query Processing in Main Memory Database Management Systems	1986	SIGMOD	0.00012515176
5,547	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB	5.4452585e-05
2,257	Write-limited sorts and joins for persistent memory	2014	VLDB	9.1808674e-05
9,466	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR	4.3314303e-05
4,736	Memory-Adaptive External Sorting	1993	VLDB	5.9537256e-05
4,887	Distributed Architecture of Oracle Database In-memory	2015	VLDB	5.8498783e-05
5,184	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB	5.6360141e-05