Poor performance cross tablespaces

From: Brian Rasmusson <br_at_belle.dk>
Date: 1997/09/03
Message-ID: <340D291F.20017358@belle.dk>#1/1

This is a multi-part message in MIME format.
--------------58324E52354C0943B1C60F7B

Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit

Hi,

I have a database with two tablespaces owned by two different users:

User UA owns tablespace TA
User UB owns tablespace TB

When UA selects from tables in TA performance is good. When UA selects from tables in TB performance is bad. When UB selects from tables in TB performance is good.

Is there any way i can improve this, or is it just "how it is" in Oracle"?

regards,
Brian

--------------58324E52354C0943B1C60F7B

Content-Type: text/x-vcard; charset=us-ascii; name="vcard.vcf"
Content-Transfer-Encoding: 7bit
Content-Description: Card for Brian Rasmusson
Content-Disposition: attachment; filename="vcard.vcf"

begin:          vcard
fn:             Brian Rasmusson
n:              Rasmusson;Brian
org:            BELLE SYSTEMS A/S
adr:            Ahlgade 3M;;;Holbaek;;4300;Denmark
email;internet: br_at_belle.dk
title:          Software engineer
tel;work:       +45 5944 2500
tel;fax:        +45 5944 2588

x-mozilla-cpt: ;0
x-mozilla-html: FALSE
end: vcard

--------------58324E52354C0943B1C60F7B--
Received on Wed Sep 03 1997 - 00:00:00 CDT