The STREETS (offn) layer drawing very slowly.
You should check these things:
1. The Spatial index:
1) Go to GIS0020 form -> Street Gazetteer Manager.2) Select the base table (in this case NM_NAT_NSGN_OFFN_SDO).3) Press the [>] button on the right-hand side of the form.4) Select the SDO Metadata tab and check if a spatial index exists. If not press the [Rebuild index] button.5) If it does exist, press the [Rebuild index] too in order to rebuild it.
2. Refresh Metadata: go to GIS0020 form -> Street Gazetteer Manager
3. If that still doesn't work, drop and recreate the OFFN layers.