The eNVy Database ToolKit provides the mean by which detailed statistical trend analysis can be performed on ORACLE (VAX , ALPHA and ITANIUM) databases. The ToolKit...
... can significantly reduce elapsed dataabase load time, thereby reducing the overall system and database downtime due to UNLOAD/RELOAD procedures.
... can significantly improve day-to-day transaction performance.
... saves time! Significantly improves the productivity of the database administration team.
... does away with manual PC spreadsheet data entry. It's like having and additional DBA on staff.
... simplifies the database administration process regardless of the number of databases.
... enables the DBA to be proactive instead of reactive by anticipating and identifying dataabase and system constraints and requirements ahead of time.
- Calculates dataabase Space Management Thresholds
- Reduces Reload time by as much as 1/3 or more
- Provides the downsizing of storage areas with a variety of block/page values
- Provides easy, effective management of 1 or 1000 databases
- Automatically creates DCL command procedures to implement ToolKit changes
Threshold Calculations.
Provides a summary and detailed report on optimized SPAM threshold values for improved transaction performance, and provides a DCL procedure to implement them.
"What If" capability.
Flexible and tailorable for easy run-time modification. Supports default parameter files for database and storage area configurations.
Data export capability.
Data conversiono to DIF (Data Interchange Format) to generate and print comparative and usage graphs from PC spreadsheets.
Minimizes administration DCL programming.
Generates customized DCL command procedures to modify SPAM thresholds, database creation procedures and DBO.
Upsize/Downsize.
Provides modeling capability to preview disk requirements when changing database parameters: block/page, allocation fill-factor utilization.
Foreign command.
Implemented as an easy, qualifier-controlled command line; installed via VMSInstal.
The eNVy Database ToolKit provides the mean by which detailed statistical trend analysis can be performed on ORACLE (VAX , ALPHA and ITANIUM) databases. The ToolKit...
... can significantly reduce elapsed dataabase load time, thereby reducing the overall system and database downtime due to UNLOAD/RELOAD procedures.
... can significantly improve day-to-day transaction performance.
... saves time! Significantly improves the productivity of the database administration team.
... does away with manual PC spreadsheet data entry. It's like having and additional DBA on staff.
... simplifies the database administration process regardless of the number of databases.
... enables the DBA to be proactive instead of reactive by anticipating and identifying dataabase and system constraints and requirements ahead of time.
- Calculates dataabase Space Management Thresholds
- Reduces Reload time by as much as 1/3 or more
- Provides the downsizing of storage areas with a variety of block/page values
- Provides easy, effective management of 1 or 1000 databases
- Automatically creates DCL command procedures to implement ToolKit changes
Threshold Calculations.
Provides a summary and detailed report on optimized SPAM threshold values for improved transaction performance, and provides a DCL procedure to implement them.
"What If" capability.
Flexible and tailorable for easy run-time modification. Supports default parameter files for database and storage area configurations.
Data export capability.
Data conversiono to DIF (Data Interchange Format) to generate and print comparative and usage graphs from PC spreadsheets.
Minimizes administration DCL programming.
Generates customized DCL command procedures to modify SPAM thresholds, database creation procedures and DBO.
Upsize/Downsize.
Provides modeling capability to preview disk requirements when changing database parameters: block/page, allocation fill-factor utilization.
Foreign command.
Implemented as an easy, qualifier-controlled command line; installed via VMSInstal.