title: Oracle TABLESPACE Allocation / Usage Performance Impact
body: <p><strong>TLDR? Skip to bullet points.</strong></p>
  
  <p>I've recently deployed a solution with an Oracle 11g DB at the backend to a test environment and performance is TERRIBLE - the system is inoperable. Performance was better in the lower-spec'd dev. environment. I appreciate this could be down to many, many things but the Oracle setup is currently in the firing line since its the component I'm least familiar with (and I'm running out of ideas).</p>
  
  <p>The DB was created using dbca. Simple SELECTS made directly against the DB in SQL Developer are OK, but going through our internal data access drivers which involve complex queries with lots of joins yields the poor performance. There are no network latency issues and the data access code is <em>fine</em>* elsewhere.</p>
  
  <p>*<em>albeit a bit chatty - a story for another day.</em></p>
  
  <p>To assist, I'd like info. on the following:</p>
  
  <ul>
  <li><p><strong>SQL Developer shows that tablespace usage of SYSTEM / SYSAUX is 99% (of 710Mb / 600Mb respectively). Could this have a performance impact?</strong></p></li>
  <li><p><strong>SQL Developer shows that the TEMP tablespace has usage NULL, allocated NULL, used NULL, free 0, datafiles NULL. I ran queries against the DB to show that the temp file exists and is online... I even dropped / recreated it, but still it appears NULL in the Manage Database screen. Is this normal behaviour? If not, could this have a performance impact?</strong></p></li>
  </ul>
  
  <p>Thanks in advance.</p>