DBA Easy Control 4.1.0.0

DBA Easy Control 4.1.0.0 designed to be a professional logging engine that keeps track of every event taking place in the system, useful for corporate security departments. DBA Easy Control is a unique versatile database management suite for Oracle DBMS administrators. The solution aggregates all the information that database administrators use on a daily basis for more efficient analysis and troubleshooting.

The great advantage of DBA Easy Control is that all the requested information is stored in a separate repository which is bound to specific objects and provides instantaneous access to the necessary information about any element in your databases. The list of typical tasks that DBA Easy Control facilitates includes, but is not limited to: creation and modification of users, scheduling a variety of SQL tasks, distribution of access rights, creation and extension of tablespaces, obtaining full database information (users, tablespaces), information about database events, technical documentation, scripts, history of privilege granting and revocation, statistical data and other essential information.

The powerful logging engine keeps track of every event taking place in the system, which is especially useful for corporate security departments controlling access to valuable data. The solution can also import notifications from external monitoring systems and distribute them among administrators for further processing. The SQL tasks subsystem allows you to automate the execution of resource-intensive jobs at the time of minimal workload (e.g. nights.)

Executing tasks in DBA Easy Control for Oracle will reduce idle time and their duration.
The client-server architecture of the solution implies that the data collection application uses an Oracle database to store statistical data. Therefore, if installed on a separate Oracle instance, it allows you to view database-specific information even if the database itself is currently unavailable. DBA Easy Control puts you in command of your databases and makes your job easier. Make sure you add DBA Easy Control to your software arsenal!

Major Features:

1. Instant access to the necessary information
2. Size of databases, their RO/RW parts, size of schemes
3. Free space in tablespaces, their free extents
4. User tablespaces, space occupied by objects
5. Object/system privileges of users/roles, reasons of granting
6. Sectioned objects, overall sizes, number of occupied/free partitions, growth tendencies
7. Partitions/subpartitions of partitioned tables and indexes
8. Users/roles possessing privileges for some objects, their statuses
9. Users with any system privileges (including privileges through roles)
10. Segments of specific tablespaces, their parameters
11. Current settings of the system and object audit
12. List of roles/privileges granted according to a certain document
13. List of hosts, databases on specific hosts
14. Description of users, their passwords, reasons for creation
15. Date of creation/removal of objects from the database
16. Dates of modification of initialization parameters, current and old values
17. Date of granting/revoking object/system privileges/roles
18. Dates of changes in the statuses of tablespaces
19. Internal assignment of one of the database sessions
20. Assignment of a remote job
21. List of scripts in a specific database and their purpose
22. Technical documentation on any database
23. Log of actions/crashes/incidents in any database
24. Database monitoring
25. Alert Log errors
26. Free space in tablespaces, notification by individual thresholds
27. Monitoring of segments (proximity of the maximum number of extents threshold and inability to extend)
28. Presence of free partitions in partitioned tables, notification by individual thresholds
29. Monitoring of index availability (partitions/subpartitions)
30. Monitoring of the privilege/role expiry terms
31. Presence of invalid objects in the database
32. Broken jobs
33. Logging options status
34. Archived Logs area, notification by individual thresholds
35. Monitoring of critical system events
36. Correctness of data scheme settings (correctness of possible location of segments and default parameters)
37. Automation of routine operations
38. Transfer of tables (partitions/subpartitions). Automatic detection of available tablespaces for transfer (by mask, taking account of statuses, availability of free space and previously planned jobs)
39. Automatic rebuilding of indexes invalidated during the transfer of tables or their partitions (subpartitions)
40. Calculation of the necessary space for transferring or rebuilding with respect to the index compression factor during the transfer and a full list of planned jobs
41. Quick creation of tablespaces, automatic naming
42. Adding and extending files, automatic naming
43. Splitting, exchange and removal of table partitions. Support of partitioning by various criteria (dates, intervals). Automatic creation of tables for exchange. Existence of global indexes is also taken into account
44. Granting and revocation of system or object privileges using lists.
45. Simultaneous assignment of corresponding privileges to base documents
46. User creation and editing. Simultaneous saving of the description, base document, password generation and saving
47. Conversion of tablespaces into RO/RW modes using lists
48. Parallel command execution (all table changes (e.g. transfer or splitting) during the first step, rebuilding of all related indexes on the second step). If the amount of work is significant and hardware resources are available, the system idle time is substantially decreased
49. Automatic recompilation of invalidated objects
50. Change log
    • Date of creation/deletion of users and roles, log of privilege changes.
    • Time of granting/revoking privileges, reasons for granting.
    • Values of initialization parameters, date of change.
    • Tablespace sizes, dates of status changes.
    • Time and date of database objects creation and deletion.
    • History of database operations performed in the system (granting of privileges, creation of tablespaces, etc.)
51. Warnings log (configurable storage time)
52. Internal and external descriptions of remote jobs
53. Connections to the database, with scheme descriptions, names of computers and applications
54. Storage of documents and descriptions
55. Storage of database descriptions, their versions, paths, etc.
56. Descriptions of users and their passwords stored in an encrypted form
57. Comments to the privilege being granted (including the preferred revoking date to be monitored)
58. Internal purpose of any of the database sessions
59. Assignment of any remote jobs
60. Comments to database files
61. Comments to tablespaces
62. Comments to warnings
63. Action, crash or incident logs for each database
64. Descriptions and texts of SQL and OS scripts, their relation to bases and hosts
65. Work documents and correspondence. Ability to bind documents to database objects (e.g. to privileges or users)
66. Technical and work documentation on any database
    

Enhancements

• New features and fixed bugs

Requirements:

• Oracle Client 8.0 and later