Re: "control file sequential read" on RAC

From: Alexander Fatkulin <afatkulin_at_gmail.com>
Date: Wed, 16 May 2007 01:38:34 +1100
Message-ID: <49d668000705150738y92911f7le6693be7f61b7a2e@mail.gmail.com>

Why not just do

select NVL(SUM(MAXBYTES-BYTES),0)

	from DBA_DATA_FILES
	where TABLESPACE_NAME=:B1
		and MAXBYTES <> 0

instead? You don't need a subquery here?...

---

>
> SELECT NVL(SUM(MAXBYTES-BYTES),0)
> FROM
> DBA_DATA_FILES WHERE FILE_ID IN (SELECT FILE_ID FROM DBA_DATA_FILES WHERE
> TABLESPACE_NAME=:B1 AND MAXBYTES <> 0)
>
>

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

Received on Tue May 15 2007 - 09:38:34 CDT