RE: Performance Problems

From: Ebadi, Abdul <Abdul.Ebadi_at_Level3.com>
Date: Thu, 23 Mar 2006 12:01:32 -0700
Message-ID: <1E75D5C235242D4998C2277351948FA601859CCD@idc1exc0003.corp.global.level3.com>

Only 15 of 1600+ tablespaces are DMT including SYSTEM.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Michael McMullen Sent: Thursday, March 23, 2006 10:40 AM
To: oracle-l_at_freelists.org
Subject: Re: Performance Problems

Are the tablespace locally managed? If so, wouldn't the read from dba_data_files have to read from the datafile itself? I seem to remember this from an experiment I did once. Locally managed tablespace on a mount,
take the mount away. read from dba_data_files didn't work. Switch to dictionary managed and the repeat test and the select ran.

Mike
--

http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Thu Mar 23 2006 - 13:01:32 CST