LeasePak Man Pages
db_update_statistics
Name
- db_update_statistics – update LeasePak database (LLDB) statistics
Synopsis
-
db_update_statistics -d env_name [dbo_pwd] -
db_update_statistics -t env_name lp_table_name [dbo_pwd] -
db_update_statistics -o [dbo_pwd]
Description
- Updates statistics, selected and tuned for LLDBs, for an entire LLDB, a single LLDB table, or the Oracle data dictionary.
Options
-
option
-
-d– update statistics on entire LLDB. -
-t– update statistics on individual LeasePak table. -
-o– Oracle only: update statistics on Oracle data dictionary.
-
-
env_name – only used with option
-dor-t, LeasePak environment containing the LLDB the script will operate on. env_name must contain a valid LLDB. -
lp_table_name – only used with option
-t, the individual LLDB table the script will operate on. lp_table_name must be in the LLDB. - dbo_pwd – LeasePak database owner password; script will prompt for this if omitted.
Limitations
-
For
-dand-t, env_name must be a valid environment and contain a valid, populated LLDB. -
For
-t, lp_table_name must exist in the LLDB. -
For
-dand-t, env_name cannot be a visitor environment. -
For
-o, DBMS must be Oracle 11gR2.
Examples
-
db_update_statistics -d env_name [dbo_pwd]– update statistics on entire LLDB. Sample output (db_update_statistics run as part of db_restore):2025-08-21 15:28:40 db_update_statistics: Update statistics for all tables in database (prod)lpr_prod 2025-08-21 15:28:40 db_update_statistics: Running commands as database owner: lpr_prod 2025-08-21 15:29:03 db_update_statistics: End
-
db_update_statistics -t env_name lp_table_name [dbo_pwd]– update statistics on individual LLDB table. -
db_update_statistics -o [dbo_pwd]– Oracle only: update statistics on Oracle data dictionary.
Files
-
Source file –
$ubin/db_update_statistics -
Other files –
-
For all options
-
$ulib/msi_csh_to_sh -
$ulib/libcore.sh -
$ulib/libcore2.sh -
$ulib/libdba2.sh -
$ulib/libxsql.sh
-
-
For
-dand-t-
$CFGDIR/$MSI_RT_CFG
-
-
For
-o-
$top/env/adm_ora/etc/.lpprofile
-
-
For all options
-
Log files –
-
For
-dand-t-
$mdilog/$ENVNAME.log
-
-
For
-o-
$msilog/dbms.log
-
-
For
Author
- NetSol Technologies, Inc. Report bugs to LeasePak Help Desk.
See Also
- Man pages –
Glossary |
LeasePak Man Pages
© 2025 NETSOL Technologies. All rights reserved.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.
The information contained in this document is the sole property of NETSOL Technologies, Inc. Use of the information contained herein is restricted. Conditions of use are subject to change without notice. NETSOL Technologies, Inc. assumes no liability for any inaccuracy that may appear in this document nor does it have the obligation to update any of the information contained herein; the contents of this document do not constitute a promise or warranty. The software described in this document is furnished under license and may be used or copied only in accordance with the terms of said license. Unauthorized use, alteration, or reproduction of this document without the written consent of NETSOL Technologies, Inc. is prohibited.