Oracle management
Manage all your Oracle databases from one place
Scops does the routine work of running many Oracle databases: it gathers statistics, compresses and archives old data, adds datafiles and sends alerts and reports. You use it from a browser.
Routine work that runs by itself
- Statistics: gathers stale and missing optimizer statistics inside the window that you set.
- Compression: moves the tables and indexes that you choose to the level that you set.
- Archiving: copies old rows to an archive database and, if you choose, deletes them from the source.
- Datafiles: adds space when a tablespace on ASM crosses your levels.
One rule for many databases
- Alert policies: which alerts check a group of databases and who gets the mail.
- Report policies: run reports on a group of databases and mail the results.
- Multi-SQL: run one statement on the databases that you select and compare the answers in one table.
Licenses and access
- License: see which Oracle packs and options your databases use, find new use and count the processor licenses.
- Users and roles: local or LDAP sign-in, with a role for each user.
- Audit Trail: each change to the security settings and critical data of Scops.
Questions
Does Scops change my databases?
Monitoring only reads. Add-ons such as Compression, Archiving and Statistics change only what you add to them, and need their own grants.
Does management need agents?
No. Nothing is installed on the database servers. Scops connects through the listener.
Which editions does it work with?
Enterprise Edition and Standard Edition 2, with no Oracle pack needed for monitoring on either.
Are these add-ons free?
Community runs Archiving on 1 table, and Compression and Statistics on 1 database, as a 30-day trial. For more, Archiving and Compression & Statistics are added to Professional.
Start
Open the live demo, or see pricing. See Policies, Archiving and Compression.