SQL Memory Management in Oracle9i

Summary: Oracle9i introduces an automatic, adaptive SQL-memory manager for concurrent sort/hash operators under finite memory and volatile workloads. Its allocation architecture and algorithms replace brittle DBA tuning, with experiments demonstrating improved robustness and performance. (summarized by gpt-5.6-luna on Jul 24 2026)

Paper ID: hfafe54752e290dfe
Venue: VLDB
Year: 2002
Pagerank: 9.9624689e-05
Overall Rank: 1,659 | 88.85%
DOI: 10.1016/B978-155860869-6/50095-0

Incoming Non-self Citations Over Time

Authors

1. Benoît Dageville (Oracle)
2. Mohamed Zait (Oracle)

BibTeX Citation

@article{dageville_vldb02,
        title = {{SQL Memory Management in Oracle9i}},
        author = {Dageville, Benoît and Zait, Mohamed},
        journal = {PVLDB},
        series = {{VLDB} '02},
        doi = {10.1016/B978-155860869-6/50095-0},
        url = {https://doi.org/10.1016/B978-155860869-6/50095-0},
        year = {2002}
}

Incoming Citations (Sorted by Pagerank)

Showing 17 of 17 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
508	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00017089907
598	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.00015761263
1,047	Chain: Operator Scheduling for Memory Minimization in Data Stream Systems	2003	SIGMOD	0.00012308922
1,289	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00011162479
2,231	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	8.7982985e-05
3,590	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	7.1865343e-05
4,045	Adaptive Query Processing in the Looking Glass	2005	CIDR	6.8328968e-05
7,070	E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model	2025	VLDB	5.6080535e-05
7,598	SageDB: An Instance-Optimized Data Analytics System	2022	VLDB	5.4871733e-05
8,620	Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines	2024	SIGMOD	5.301557e-05
8,983	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	5.2433703e-05
9,566	Saving Private Hash Join	2025	VLDB	5.1571823e-05
10,248	Accelerating Analytics with Dynamic In-Memory Expressions	2016	VLDB	5.0525742e-05
10,580	MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration	2026	SIGMOD	4.9793485e-05
10,946	Why We Created Yet Another Memory Framework: Understanding MGA’s Role in Next-Gen Database Systems	2026	VLDB	4.9793485e-05
11,498	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	4.9793485e-05
13,074	Computing Frequent Itemsets Inside Oracle 10G	2004	VLDB	4.9793485e-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
1	4,234	Adaptive Statistics in Oracle 12c	2017	VLDB
2	12,911	Managing Query Compilation Memory Consumption to Improve DBMS Throughput	2007	CIDR
3	998	What happens during a Join? Dissecting CPU and Memory Optimization Effects	2000	VLDB
4	1,384	Query Processing in Main Memory Database Management Systems	1986	SIGMOD
5	5,983	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB
6	2,038	Write-limited sorts and joins for persistent memory	2014	VLDB
7	9,784	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR
8	4,469	Memory-Adaptive External Sorting	1993	VLDB
9	4,615	Distributed Architecture of Oracle Database In-memory	2015	VLDB
10	4,260	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB