Re: How could you tell if an applicaiton will run in Standard Edition

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Sat, 16 Jun 2007 11:03:01 +0100
Message-ID: <7765c8970706160303u7e10ab51v778c532efe3bea65@mail.gmail.com>

Partitioning would be an extra special case wouldn't it since you'd need a partitioning license as well.

You could look at DBA_FEATURE_USAGE_STATISTICS if the app has been running a while.

My take is that most (like over 70%) of applications will run just fine on SE. Mostly people don't write code that uses AQ etc etc.

On 6/16/07, Michael Kline <mkline1_at_comcast.net> wrote:
>
> Has anyone come up with a set of queries that will determine if an
> application will run in standard edition.
>
>
>
> One query may be to determine if there really ARE any partitions or
> something like that.
>
>
>
> I've got a client with some rather "plain" small database, and may well
> work in Standard Edition, but how can I be sure?
>
>
>
> Thanks.
>
>
>
> Michael Kline
>
> Midlothian, VA 23112
>
> O: 804.744.1545
>
> Fax: 804.763.0114
>
>
>

-- 
Niall Litchfield
Oracle DBA
http://www.orawin.info

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

Received on Sat Jun 16 2007 - 05:03:01 CDT