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.