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 -d or -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 -d and -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 -d and -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
  • Owned by $NSTDBA:$NSTGROUP
  • Executable only by $NSTDBA
• Other files –
  • For all options
    • $ulib/msi_csh_to_sh
    • $ulib/libcore.sh
    • $ulib/libcore2.sh
    • $ulib/libdba2.sh
    • $ulib/libxsql.sh
  • For -d and -t
    • $CFGDIR/$MSI_RT_CFG
  • For -o
    • $top/env/adm_ora/etc/.lpprofile
• Log files –
  • For -d and -t
    • $mdilog/$ENVNAME.log
  • For -o
    • $msilog/dbms.log

Author

• NetSol Technologies, Inc. Report bugs to LeasePak Help Desk.

See Also

• Man pages –
  • db_restore