Re: sql query taking too long

From: srivenu <srivenu_at_hotmail.com>
Date: 12 May 2004 00:33:31 -0700
Message-ID: <1a68177.0405112333.695d4da1@posting.google.com>

Why do you have so many free entries in (186168) FET$. Think this is a test database (with 5 tablespaces) and you had created and dropped several small objects. Try coalescing the tablespaces and give the query again. Also dont use very small extents for objects. regards
Srivenu Received on Wed May 12 2004 - 02:33:31 CDT