RE: Performance Problems
- From: "Ebadi, Abdul" <Abdul.Ebadi@xxxxxxxxxx>
- To: <ganstadba@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Thu, 23 Mar 2006 12:01:32 -0700
Only 15 of 1600+ tablespaces are DMT including SYSTEM.
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx] On Behalf Of Michael McMullen
Sent: Thursday, March 23, 2006 10:40 AM
To: oracle-l@xxxxxxxxxxxxx
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
--
//www.freelists.org/webpage/oracle-l
--
//www.freelists.org/webpage/oracle-l
Other related posts:
