September’s release of the DBA Bundle is now available: (It’s a combination of Aug+Sep releases)
dbdailychk.sh [For generating a database Health Check Report]:
– Added Memory utilization check feature, combining both RAM and SWAP in the calculation:
The following parameters need to be edited by the user to match the environment requirements:
CHECK_MEMORY=Y # REPORT LOW MEMORY USING BELOW TWO DEFINED THRESHOLDS COMBINED [OS]
USEDPHYSICALMEM_PCT=95 # THRESHOLD FOR RAM %UTILIZATION [OS]
USEDSWAPMEM_PCT=75 # THRESHOLD FOR SWAP SPACE %UTILIZATION [OS]
USEDPHYSICALMEM_PCT=95 # THRESHOLD FOR RAM %UTILIZATION [OS]
USEDSWAPMEM_PCT=75 # THRESHOLD FOR SWAP SPACE %UTILIZATION [OS]
How it works?
Low memory will get reported if both; RAM %USED is >=95% and SWAP space %USED is >=75%
Above thresholds are generic; feel free to change them as per your experience with your systems.
e.g. if you feel your system start to get slow when the RAM %USED reach 85% and SWAP space utilization hit 10%, then you edit those parameters like this:
USEDPHYSICALMEM_PCT=85
USEDPHYSICALMEM_PCT=85
USEDSWAPMEM_PCT=10
If you are not interested in getting notified about Memory high utilization, just disable this function by setting:
CHECK_MEMORY=N
CHECK_MEMORY=N
– Reorganized the script’s sections to make it easier for the user to edit and understand.
rebuild_table.sh [For rebuilding a table online]:
– Added the feature of rebuilding the table on a different tablespace.
– Enhanced the formatting of the outputs and the logfile.
For a detailed discussion on this script new features please visit: http://dba-tips.blogspot.com/2020/09/major-update-to-rebuild-table-script.html
parameter_val.sh [For viewing Normal & Hidden Parameters]
– User can view all NON-DEFAULT parameters.
– The user can list all the parameters on the instance.
user_ddl.sh [For generating User creation DDL statement]
– If the database version is 12c+ the script will automatically use dbms_metadata.get_ddl to generate the DDL (User creation + Privileges + showing quotas on tablespaces).
– Minor functionality enhancements and bug fixes included in these scripts:
export_data.sh [For exporting data]
– Fixed a directory creation bug.
dbalarm.sh [For database monitoring]
– Excluded the reporting of ORA-235 which triggers during the unlocking of the control file” as advised by MOS 2312580.1
rebuild_table.sh [For rebuilding a table online]:
– Correction of DBA_REDEFINITION_ERRORS query.
object_size.sh [For calculating the total object size]
– Enhanced the formatting of the outputs.
aliases_DBA_BUNDLE.sh [The main Bundle deployment script]
– Removed the constraint of extracting the bundle under User’s home directory, now the user is free to extract the bundle anywhere.
If you are new to the DBA Bundle, please visit below link to understand its functions:
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html
http://dba-tips.blogspot.com/2014/02/oracle-database-administration-scripts.html
DBA Bundle V6.0