|
|
|
|
| |
File Size: 430 KB |
|
|
|
Software Description
|
It 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.
Oracle Quick Check 1.0 Main Features :
- 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 well test it with that version and publish updated support information.
|
Requirements | | Oracle Client 7.x or above |
Install Support | | Install and Uninstall |
Supported Languages | | English |
|
|
|
|
Note: Software piracy is theft. Using a Software crack, password, serial number, registration code or key
generator is illegal and prevents future Shareware development. To protect licenses of free downloads available on this download site, AllSoftFreeware.com does not provide any cracked versions, registration numbers, hacks, serial numbers, serial codes, keygen tools, cd keys or trainers.
Oracle Quick Check 1.0 Download Freeware
|
RSS
