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: 9105
Venue: VLDB
Year: 2002
Pagerank: 9.9628446e-05
Overall Rank: 1,706 | 88.30%
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 16 of 16 citing papers.

Rank	Citing Paper	Year	Venue	Pagerank
523	Adaptive Self-Tuning Memory in DB2	2006	VLDB	0.00017133451
625	Automatic Performance Diagnosis and Tuning in Oracle	2005	CIDR	0.0001566968
1,027	Chain: Operator Scheduling for Memory Minimization in Data Stream Systems	2003	SIGMOD	0.00012563656
1,344	An Inquiry into Machine Learning-based Automatic Configuration Tuning Services on Real-World Database Management Systems	2021	VLDB	0.00011094717
2,298	GPTuner: A Manual-Reading Database Tuning System via GPT-Guided Bayesian Optimization	2024	VLDB	8.7886538e-05
3,586	Make Your Database System Dream of Electric Sheep: Towards Self-Driving Operation	2021	VLDB	7.2834069e-05
3,988	Adaptive Query Processing in the Looking Glass	2005	CIDR	6.9720123e-05
6,997	E2ETune: End-to-End Knob Tuning via Fine-tuned Generative Language Model	2025	VLDB	5.7300324e-05
8,323	SageDB: An Instance-Optimized Data Analytics System	2022	VLDB	5.4539294e-05
8,463	Limousine: Blending Learned and Classical Indexes to Self-Design Larger-than-Memory Cloud Storage Engines	2024	SIGMOD	5.4205593e-05
8,818	Resource-Adaptive Query Execution with Paged Memory Management	2025	CIDR	5.3637177e-05
10,053	Accelerating Analytics with Dynamic In-Memory Expressions	2016	VLDB	5.1685424e-05
10,384	MCTuner: Spatial Decomposition-Enhanced Database Tuning via LLM-Guided Exploration	2026	SIGMOD	5.093636e-05
10,888	Saving Private Hash Join	2025	VLDB	5.093636e-05
11,150	Proactive Resume and Pause of Resources for Microsoft Azure SQL Database Serverless	2024	SIGMOD	5.093636e-05
12,784	Computing Frequent Itemsets Inside Oracle 10G	2004	VLDB	5.093636e-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,277	Adaptive Statistics in Oracle 12c	2017	VLDB
2	12,621	Managing Query Compilation Memory Consumption to Improve DBMS Throughput	2007	CIDR
3	987	What happens during a Join? Dissecting CPU and Memory Optimization Effects	2000	VLDB
4	1,355	Query Processing in Main Memory Database Management Systems	1986	SIGMOD
5	5,863	Supporting Time-Constrained SQL Queries in Oracle	2007	VLDB
6	1,996	Write-limited sorts and joins for persistent memory	2014	VLDB
7	9,612	Memory Efficient Scheduling of Query Pipeline Execution	2022	CIDR
8	4,708	Memory-Adaptive External Sorting	1993	VLDB
9	4,560	Distributed Architecture of Oracle Database In-memory	2015	VLDB
10	4,416	Query Optimization in Oracle 12c Database In-Memory	2015	VLDB