1. User's Guide
  2. Smart View Diagnostics and Health Check
  3. Performing a Health Check On Your System

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 ribbon in Excel, click the arrow next to Help, and then select Health Check.

    The Health Check dialog is displayed.

  2. View the following system information; 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

  3. Update the following information as you require; if you change any settings, click Update Settings to apply the changes.

    Optionally, click Recommended Settings to set all options to those most optimal to Smart View.

    These are the editable settings:

    • 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 timeout values. (If you change any of the timeout values, you must restart all Microsoft Office applications in order for the new value to be applied.)

      • 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.

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

      • USER Process Handle Quota—Read only. The number of process handles. Process handles regulate Oracle Smart View for Office’s access to system resources.

      • 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.

      • Browser Emulation Mode—Adds the required registry key to all Office applications (Excel, Word, PowerPoint, Outlook) so that certain browser-based screens in Smart View and Smart View extensions render properly.

        Select the option that corresponds to your browser version:

        • 12001—Microsoft Edge

        • 11001—Internet Explorer 11

        • 10001—Internet Explorer 10

        • Disable

        This option is enabled by default and shows the value, Default.

    • 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."

  4. Click Update Settings to save the changes you've made

    If you select Recommended Settings, you must still click Update Settings to save the changes.

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

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

  7. Restart Excel and log in.

Tip:

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 Yes, then click Update Settings, then click Close, and then restart Excel.