English

Problem: Unable to select features from a DBTheme in ArcView

Description

When viewing SDE layers in ArcView, features cannot be selected.

Cause

A possible cause is the shared_pool_size parameter in the Oracle configuration file is set too small.

Solution or Workaround

  1. Open the initorcl.ora file located in the <Oracle install directory>/database/ folder in a text editor.
  2. Scroll down to the following portion of the file.

    shared_pool_size = 3500000 # INITIAL 
    # shared_pool_size = 3500000 # SMALL
    # shared_pool_size = 5000000 # MEDIUM
    # shared_pool_size = 9000000 # LARGE

  3. Change the shared_pool_size value to either 5000000 or 9000000. It should now look like. . .

    shared_pool_size = 9000000 # INITIAL 
    # shared_pool_size = 3500000 # SMALL
    # shared_pool_size = 5000000 # MEDIUM
    # shared_pool_size = 9000000 # LARGE

  4. Save the file and close the text editor.