Oracle Quick Check Welcome to Oracle Quick Check. An application designed to make your job as a DBA easier Oracle Quick Check will evaluate a large number of critical values and report back with a set of tuning recommendations. To help supplement the analysis, a report of your database is automatically emailed to dba@ensyncsolutions.com. Our DBA team will check over your report and contact you with additional details and steps needed make corrections.

How to use Oracle Quick Check

Connection Info

Username: the name of an Oracle scheme with enough privilege to read from the system tables. Usually this is the ‘SYSTEM’ or ‘SYS” user.
Password: the password to the username specified above.
Connection: the SQLnet connection string used to connect to a local or remote database.

Disk IO

Displays information on the data files.

Tablespace Free Space

Displays information on how much free space is left. Look for tablespaces with low space.

Table and Extent Information

Displays information on the tables and extents used.

Sorting

Displays information on sorts on disk and in emmory. Ideally all sorting should be performed in memory.

Memory Allocation

Displays information on how much memory is dedicated to the different pools and buffers.

Recovery

Displays information on the log buffers.

Cache Ratios

Displays information on the cache hit ratios for the common dictionary, command execution, and database block buffers. We want everything to be in memory. The first two ratios should have a low missed value. The buffer ration should be as close to 100% as we can get it.

Redo Logs

Displays information on the redo logs. Pay attention to the size.

Status Messages

Displays status messages from the program and provides a record of any errors encountered.

Connect

Connects to the database using the credential information supplied in the username, password, and connection fields.

Exit

Exits the application.

Help

Opens the help document.

Refresh

Updates the dialog using the existing connection information (re-runs the program using the existing connection).

Params

Lists the currently known Oracle parameters and their corresponding values. Want to find out what value a parameter is set to? Use this handy option.

Report

Displays the information found while examining the database. Information can be copied from this dialog and pasted into another application. This is the same information that will be included in the email sent for analysis.

Warnings

Re-displays the warning messages generated by the program.

About

Displays version and contact information.

How It Works

Oracle Quick Check (OQC) uses the Oracle Callable Interface (OCI) layer to connect into the database of your choice. This will function with any Oracle 7, 8, or 9 database. Once Oracle 10 is out we’ll test it with that version and publish updated support information

Support

For support, please contact us via email at dba@ensyncsolutions.com or phone us at 630.536.5222. We’ll be happy to answer your questions.