1. Working with Oracle Smart View for Office
  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, WebView2 Runtime Version, .NET Framework Versions

      Note:

      • If Microsoft Edge WebView2 Runtime is installed, then a version number is displayed in WebView2 Runtime Version. See the WebView2 Runtime option in the Smart View Options group in the next step to enable or disable WebView2.
      • If WebView2 Runtime is not installed, then WebView2 Runtime Version displays None and the WebView2 Runtime option is not displayed in the Smart View Options group.

      Note:

      Smart View uses the following Dynamic Link Library files (DLLs) to implement certain functionalities:
      • BIPlusConnector.dll: This is used to manage functionalities such as extensions, reports, search, cell actions, and drill-through in new sheet.
      • Profiler.dll: This is used to manage diagnostics.
      • HsSpread.dll: This is used to manage the spreading functionality.
      • SVAPPH.dll: This is used to manage Web launch from Smart View.

      You can view the release version and registration status. If a DLL is registered correctly, the status appears as "Registered". For example, 24.100 / Registered. If a DLL is not registered correctly, the status appears as "Not Registered" and the functionalities it manages may not work properly. In such cases, you must re-install Smart View using administrator privileges. This instruction is also displayed in the Fix/Update/Help Link column.

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

        • 11001—Internet Explorer 11 compatibility

        • 10001—Internet Explorer 10 compatibility

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

      • Compatibility—Manage the compatibility of forms and regular ad hoc grids between Smart View for Office and Smart View for Office (Mac and Browser). The default value is Disabled.

        • To enable compatibility, click in the Fix/Update/Help Link column, select Enable, and then click Update Settings.
        • To disable compatibility, click in the Fix/Update/Help Link column, select Disable, and then click Update Settings.

        For more information, see Working Compatibly on Forms and Ad Hoc Grids Between Smart View and Smart View (Mac and Browser).

      • WebView2 Runtime—Select an option to enable or disable the installed version of Microsoft Edge WebView2 Runtime:

        • Enable for UI—When enabled, WebView2 is used by Smart View to assist with some authentication scenarios at login. During runtime, Smart View detects the presence of WebView2 Runtime installed on the machine and launches the WebView2-based dialog to host the login page. Webview2 also works in conjunction with the Microsoft Edge browser to display the wizard when importing reports from Financial Reporting (cloud and on-premises).

        • Enable for All—This is the default setting. Works with the authentication scenarios described in Enable for UI, and also enables WebView2 for networking. This option is recommended for use in diagnosing connection issues.

        • Disable—Select to disable WebView2.

        Whether enabled or disabled, the installed WebView2 Runtime version is displayed in WebView2 Runtime Version in the Version Information group; if WebView2 Runtime is not installed, then WebView2 Runtime Version displays None (see the previous step).

        For WebView2 requirements, see Microsoft Edge WebView2 Support in the Oracle Smart View for Office Readme.

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

  5. Optional: 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.

    When you select Recommended Settings, a dialog is displayed showing you the settings that will be changed. Click Yes in the dialog. Then, click Update Settings to save the changes.

    Note:

    Once you click Recommended Settings, the button is disabled. If you then make further changes to the settings in the Health Check dialog, the button remains disabled. To use the Recommended Settings button again, you must close and then reopen the Health Check dialog.

  6. Optional: Click Export to Excel to export the Health Check information to a new Excel spreadsheet.
  7. Click Close to close the Health Check dialog box.
  8. Restart Excel and log in.