1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
|
<?xml version="1.0" encoding="UTF-8" standalone="no"?>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8" />
<title>Selecting the Database File Size</title>
<link rel="stylesheet" href="gettingStarted.css" type="text/css" />
<meta name="generator" content="DocBook XSL Stylesheets V1.73.2" />
<link rel="start" href="index.html" title="Getting Started with the Oracle Berkeley DB SQL APIs" />
<link rel="up" href="configure.html" title="Chapter 3. Configuring the Berkeley DB SQL interface" />
<link rel="prev" href="configpage.html" title="Configuring the Database Page Size" />
<link rel="next" href="configcache.html" title="Configuring the In-Memory Cache" />
</head>
<body>
<div class="navheader">
<table width="100%" summary="Navigation header">
<tr>
<th colspan="3" align="center">Selecting the Database File Size</th>
</tr>
<tr>
<td width="20%" align="left"><a accesskey="p" href="configpage.html">Prev</a> </td>
<th width="60%" align="center">Chapter 3. Configuring the Berkeley DB SQL interface</th>
<td width="20%" align="right"> <a accesskey="n" href="configcache.html">Next</a></td>
</tr>
</table>
<hr />
</div>
<div class="sect1" lang="en" xml:lang="en">
<div class="titlepage">
<div>
<div>
<h2 class="title" style="clear: both"><a id="dbfilesize"></a>Selecting the Database File Size</h2>
</div>
</div>
</div>
<p>
Berkeley DB sets an upper bound on how large your database file size
is allowed to be. Any attempt to insert data into the database
that grows this file beyond this upper bound results in a
failure.
</p>
<p>
You can set the upper bound for your database file size using
<code class="literal">PRAGMA max_page_count</code>. Issue this PRAGMA
with no value to see what the current maximum database file is.
</p>
</div>
<div class="navfooter">
<hr />
<table width="100%" summary="Navigation footer">
<tr>
<td width="40%" align="left"><a accesskey="p" href="configpage.html">Prev</a> </td>
<td width="20%" align="center">
<a accesskey="u" href="configure.html">Up</a>
</td>
<td width="40%" align="right"> <a accesskey="n" href="configcache.html">Next</a></td>
</tr>
<tr>
<td width="40%" align="left" valign="top">Configuring the Database Page Size </td>
<td width="20%" align="center">
<a accesskey="h" href="index.html">Home</a>
</td>
<td width="40%" align="right" valign="top"> Configuring the In-Memory Cache</td>
</tr>
</table>
</div>
</body>
</html>
|
