1<!--$Id: seq_stat.so,v 1.9 2007/06/22 16:57:17 bostic Exp $--> 2<!--Copyright (c) 1997,2008 Oracle. All rights reserved.--> 3<!--See the file LICENSE for redistribution information.--> 4<html> 5<head> 6<title>Berkeley DB: DB_SEQUENCE->stat</title> 7<meta name="description" content="Berkeley DB: An embedded database programmatic toolkit."> 8<meta name="keywords" content="embedded,database,programmatic,toolkit,btree,hash,hashing,transaction,transactions,locking,logging,access method,access methods,Java,C,C++"> 9</head> 10<body bgcolor=white> 11<table width="100%"><tr valign=top> 12<td> 13<b>DB_SEQUENCE->stat</b> 14</td> 15<td align=right> 16<a href="../api_c/api_core.html"><img src="../images/api.gif" alt="API"></a> 17<a href="../ref/toc.html"><img src="../images/ref.gif" alt="Ref"></a></td> 18</tr></table> 19<hr size=1 noshade> 20<tt> 21<b><pre> 22#include <db.h> 23<p> 24int 25DB_SEQUENCE->stat(DB_SEQUENCE *db, void *sp, u_int32_t flags); 26<p> 27int 28DB_SEQUENCE->stat_print(DB_SEQUENCE *db, u_int32_t flags); 29</pre></b> 30<hr size=1 noshade> 31<b>Description: DB_SEQUENCE->stat</b> 32<p>The DB_SEQUENCE->stat method creates a statistical structure and copies a 33pointer to it into user-specified memory locations. Specifically, if 34<b>sp</b> is non-NULL, a pointer to the statistics for the database are 35copied into the memory location to which it refers.</p> 36<p>Statistical structures are stored in allocated memory. If application-specific allocation 37routines have been declared (see <a href="../api_c/env_set_alloc.html">DB_ENV->set_alloc</a> for more 38information), they are used to allocate the memory; otherwise, the 39standard C library <b>malloc</b>(3) is used. The caller is 40responsible for deallocating the memory. To deallocate the memory, free 41the memory reference; references inside the returned memory need not be 42individually freed.</p> 43<p>In the presence of multiple threads or processes accessing an active 44sequence, the information returned by DB_SEQUENCE->stat may be out-of-date.</p> 45<p>The DB_SEQUENCE->stat method cannot be transaction-protected. For this reason, 46it should be called in a thread of control that has no open cursors or 47active transactions.</p> 48<p>The statistics are stored in a structure of type DB_SEQUENCE_STAT. The 49following fields will be filled in:</p> 50<br> 51<b>u_int32_t st_wait;</b><ul compact><li>The number of times a thread of control was forced to wait on the 52handle mutex.</ul> 53<b>u_int32_t st_nowait;</b><ul compact><li>The number of times that a thread of control was able to obtain handle 54mutex without waiting.</ul> 55<b>db_seq_t st_current;</b><ul compact><li>The current value of the sequence in the database.</ul> 56<b>db_seq_t st_value;</b><ul compact><li>The current cached value of the sequence.</ul> 57<b>db_seq_t st_last_value;</b><ul compact><li>The last cached value of the sequence.</ul> 58<b>db_seq_t st_min;</b><ul compact><li>The minimum permitted value of the sequence.</ul> 59<b>db_seq_t st_max;</b><ul compact><li>The maximum permitted value of the sequence.</ul> 60<b>int32_t st_cache_size;</b><ul compact><li>The number of values that will be cached in this handle.</ul> 61<b>u_int32_t st_flags;</b><ul compact><li>The flags value for the sequence.</ul> 62<br> 63<b>Parameters</b> <br> 64 <b>flags</b><ul compact><li>The <b>flags</b> parameter must be set by bitwise inclusively <b>OR</b>'ing together one or more 65of the following values: 66<br> 67<b><a name="DB_STAT_CLEAR">DB_STAT_CLEAR</a></b><ul compact><li>Reset statistics after printing their values.</ul> 68<br></ul> 69<br> 70<p>The DB_SEQUENCE->stat method may not be called before the <a href="../api_c/seq_open.html">DB_SEQUENCE->open</a> method has 71been called.</p> 72<p>The DB_SEQUENCE->stat method 73returns a non-zero error value on failure 74and 0 on success. 75</p> 76<hr size=1 noshade> 77<b>Description: DB_SEQUENCE->stat_print</b> 78<p>The DB_SEQUENCE->stat_print method prints diagnostic information to the output 79channel described by the <a href="../api_c/env_set_msgfile.html">DB_ENV->set_msgfile</a> method.</p> 80<b>Parameters</b> <br> 81 <b>flags</b><ul compact><li>The <b>flags</b> parameter must be set by bitwise inclusively <b>OR</b>'ing together one or more 82of the following values: 83<br> 84<b><a name="DB_STAT_CLEAR">DB_STAT_CLEAR</a></b><ul compact><li>Reset statistics after printing their values.</ul> 85<br></ul> 86<br> 87<hr size=1 noshade> 88<br><b>Class</b> 89<a href="../api_c/seq_class.html">DB_SEQUENCE</a> 90<br><b>See Also</b> 91<a href="../api_c/seq_list.html">Sequences and Related Methods</a> 92</tt> 93<table width="100%"><tr><td><br></td><td align=right> 94<a href="../api_c/api_core.html"><img src="../images/api.gif" alt="API"></a><a href="../ref/toc.html"><img src="../images/ref.gif" alt="Ref"></a> 95</td></tr></table> 96<p><font size=1>Copyright (c) 1996,2008 Oracle. All rights reserved.</font> 97</body> 98</html> 99