Re: Oracle Data Mining - Database Parameters

Beli wrote:

> Hi All,
>
> We have a 4 CPU, 8 GB RAM Sun Solaris Server here. Planning to use ODM
> 10.0.1. My mining table is expected to have around 4,00,000 rows and
> 60-70 columns. Have couple of queries,
>
> a)What should be thumb rules for tuning SGA related parameters and how
> do these differ from a normal Data Warehouse tuning set.
>
> b)How can one estimate number of cpu's and RAM requirement for a data
> mining exercise?
>
> Thanks,

1. Get the database up and running on a test box.
2. Issue the queries.
3. Learn to use AWR. (demo in Morgan's Library)

One does not tune in a vacuum ... one tunes based upon metrics. Right now, it appears, you have none.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)