Performing a Health Check On Your System

You can perform a "health check" on your system to optimize performance.

With the Health Check, you can also get information about your machine, such as certain registry settings, Microsoft Office version, Oracle Smart View for Office version, and the extensions you have installed.

Note:

The Health Check feature is only available when using Smart View with Excel.

To perform a health check:

  1. From the Smart View Panel in Excel, click the arrow next to Help, and then select Health Check.

  2. Review or update the information in the Health Check dialog box.

    The following information about your system is displayed. You cannot edit this information.

    • Version Information—Operating System, Excel Version, Smart View Version, Internet Explorer Version
    • Hardware Information—RAM Memory, Processor, Smart View Installed Drive Space
    • Excel Add-ins—Depends on the Excel add-ins that are installed
    • COM Add-ins—Depends on the COM add-ins that are installed

    Some of the following information can be changed. If you change any settings, click Update Settings to apply the changes.

    • Registry Information

      • HTTP session timeouts can occur when working with large queries that take a long time to run, or when you are experiencing slower internet connections. To reduce timeout occurrences, you can set the following timeout values:

        • KeepAlive Timeout—The default value is 900 seconds. To change the value, click in the Fix/Update/Info column, enter a new value, and then click Update Settings.
        • Receive Timeout—The default value is 900 seconds. To change the value, click in the Fix/Update/Info column, enter a new value, and then click Update Settings.
        • ServerInfo Timeout—The default value is 900 seconds. To change the value, click in the Fix/Update/Info column, enter a new value, and then click Update Settings.

        Note:

        If you change any of the timeout values, you must restart all Microsoft Office applications in order for the new value to be applied.
      • USER Process Handle Quota—Read only. The number of process handles. Process handles regulate Oracle Smart View for Office’s access to system resources.

      • These options are related to system display:

        • Current Resolution—Read only. The current resolution of the system display.

        • Enable Per Process System DPI—Windows 10 Display Settings only. For drag-and-drop to work correctly if you use Office applications at a scaling level different than 100%, select Enable. The default value is Disabled.

          If you're using a high DPI display as your primary monitor and a regular DPI display as your extended monitor, drag and drop may not work on the extended regular DPI display monitor. This is due to mouse drivers giving incorrect coordinates for mouse actions, resulting in faulty drag-and-drop behavior.

    • Smart View Options
      • Undo Buffer—The number of Undo and Redo actions permitted on an operation. The default value is 9. To change the value, click in the Fix/Update/Info column, enter a new value, and then click Update Settings. You can enter a value between 1 and 100. (See Using Undo and Redo).
      • Improve Metadata Storage—This option pertains to interoperability between different versions of Smart View. It allows for more efficient storage of internal data structures.

        The default value is "Checked." If all users in your organization are on Smart View 9.3.1.6 or higher, then this option should always be checked.

        When this option is "Unchecked," two copies of metadata are maintained for compatibility purposes, which may result in slower overall performance. Uncheck this option in the following situations:

        • You send an Excel workbook to users on Smart View releases earlier than 9.3.1.6, or to users on Microsoft Office 2002 and earlier, regardless of the Smart View release.
        • You open a workbook sent from users on Smart View releases earlier than 9.3.1.6, or from users on Microsoft Office 2002 and earlier, regardless of the Smart View release.

        Note: If you change this option to "Unchecked,"the value in the Fix/Update/Help Link column changes to "Fix." If you are having issues with your system and want to optimize performance, you should "fix" this setting by changing the value back to "Checked."

    • Graphic Setting

      The following two options improve the user experience by helping to reduce flickering in Microsoft Office:

      • Disable Windows Transitions on Addin Task Panes—The default value is "Enabled." To disable this option, click in the Fix/Update/Help Link column, select Disable, and then click Update Settings.

        Note: If you change this option to "Disabled," the value in the value in the Fix/Update/Help Link column changes to "Fix." If you are having issues with your system and want to optimize performance, you should "fix" this setting by changing the value back to "Enabled."

      • Disable Animations—This setting disables Office animations. The default value is "Enabled." To disable this option, click in the Fix/Update/Help Link column, select Disable, and then click Update Settings.

        Note: If you change this option to "Disabled," the value in the value in the Fix/Update/Help Link column changes to "Fix". If you are having issues with your system and want to optimize performance, you should "fix" this setting by changing the value back to "Enabled."

  3. Optional: Click Export to Excel to export the Health Check information to a new Excel spreadsheet.

  4. Click Close to close the Health Check dialog box.

Note:

If you change any of the information in the Health Check dialog box, and want to get back to the default values, click Recommended Settings. A dialog box displays the recommended settings. To accept these settings, click OK.