DBA Easy Control for Oracle 4.0

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.) Parallel execution of tasks reduces 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 for Oracle puts you in command of your databases and makes your job easier. Make sure you add DBA Easy Control to your software arsenal!

Say goodbye to endless night shifts spent in the server room! Farewell to degrading manual labor on archiving, transferring and recovering data. Bye-bye the sleepless after-hours! You will no longer have to spend all that time on performing general maintenance and routine operations on an Oracle database, however complex it is.

Hire an invisible assistant to monitor databases instead of you! DBA Easy Control for Oracle by DBA Inventions Ltd. is trained in minutes, and performs flawlessly once you tell it what to do. Being developed by professional database developers, DBA Easy Control is a highly educated and professionally trained assistant to a busy database administrator. It can monitor the Alert Log for errors, watch the free space based on your thresholds, keep an eye on access rights, look after the archive log area, and monitor many more important parameters for multiple databases.

Relax by off-loading routine operations to a prompt assistant! DBA Easy Control automates routine operations by preparing a SQL query to be performed manually or periodically by the system scheduler. Moving tables, sections and sub-sections, rebuilding indexes automatically, calculate space required for a moving, add and resize files, and do many more important tasks simultaneously thanks to concurrent parallel execution of the jobs.

See what’s going on at any time! DBA Easy Control enables instant access to important database information at any time. No more lengthy delays and no need to connect to each database to get an update on its status! DBA Easy Control provides information on free space in tables and extents, user roles and privileges as well as information on how they were obtained, current settings for system and object audit, dates of granting and revoking system and object roles and privileges, and many more. You can search information easily at many databases. The more databases you manage, the more valuable DBA Easy Control becomes as your irreplaceable assistant!

Hire a personal secretary with technical background! Being an accurate administrator, DBA Easy Control keeps change history log for all databases. Easy access to change history is indispensible when investigating carious issues on errors, malfunctions, access and security violations. DBA Easy Control keeps all documentation and manuals in a single repository, allowing all users of the system access these documents.

DBA Easy Control is not a human, and cannot be hired to do your job. You can’t pay it to do the work for you, but you can buy it to help you with your daily routine and make your work both easier and more effective.

Major Features:

1. Instant access to the necessary information

• The unique scheme of storing dictionary metadata in a separate repository and their analytical processing provide instantaneous (!) access to the necessary information about any of the used databases.
• The comfort of being able to instantly obtain the necessary information grows in a geometric progression as the number of managed databases increases. Regardless of the number of databases and their statuses (operational or not), it will take you seconds to find out what you need to start working without connecting to the database and running any queries!
  

2. Database monitoring

• Database registration and the start of the monitoring process take mere minutes. You don’t need to install any agents or configure any database scripts. No complex settings!
• If necessary, you can easily add your own monitoring scripts to the system, receive messages from other monitoring systems and configure the delivery of reports and notifications.
  

3. Automation of routine operations

• DBA Easy Control allows you to create a list of SQL expressions for each of the automated tasks and then run them manually or use the system task planner to run them at a specified time.
• The advantage of automation is obvious even if you have a relatively small number of tasks for user creation, distribution of access privileges and other regular tasks. All these tasks can be completed even by Oracle rookies that have no deep knowledge of SQL syntax and don’t even have passwords! It enables you to delegate tedious routine tasks to night shifters, which substantially cuts operation expenses and frees up a lot of personal and night :) time!
  

4. Change log

• An ability to see the log of database changes is vital for analyzing non-standard situations - crashes, unauthorized access, data and object corruption; for restoration of parameters and privileges; for creating various forecasts and so forth. The time accuracy of the logged information depends only on the selected monitoring frequency. No other audit settings needed!
  

5. Storage of documents and descriptions

• All documents are stored in a single system repository and can be accessed by all system users. All information about the database infrastructure is saved and updated automatically. All you need to do, if you wish, is to add comments that will stay in the system even if the database is not available or its structure is changed!
• The system is easy to install and use. Adding a database to the system does not require the installation of any agents. The created service schemes contain no objects and only have access to the data needed to perform the specified tasks.
• The system is based on a server-client architecture that facilitates team work and allows you to restrict access to representations and functional capabilities. The solution is scalable and supports a large number of databases.