Re: Exchanging product and test database on NT - how Do I change SID?

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message news:<ucb4miscpfpi1f_at_corp.supernews.com>...
> Changing the block size to 16k is, following previous discussions on this
> group not to buy you much, unless you have a true datawarehouse, and even in
> that case it is questionable, unless you exclusively have full table scans.

We've got a data warehouse with more or less one big table (full index scans) and lots of register tables. This table is cumulated in several ways to other big tables.
I'm sure that reorganizing some of these tables will improve also the performance.

I made a count(*) in both environment and with the same data and data structure in test-environment about 30 percent more speed.

I year ago we changed from 2048 to 8192 and not to 16384 against my explicit wishes. Now this consultancy enterprise, which started with 2048, is out of discussion.
I have only limited physical access to the server, so before before doing something I should really prepared, which sounds bad but sometimes has some benefit.

>
> You need to stop the databases, stopping the services involved also, then
> run an oradim -delete <service> in a *dos box* (if you do this interactively
> you will delete the database.
> Then perform magic by renaming the controlfiles and the init.ora and
> recreate the service.
>
> Of course, this might involve some reading the manual.
>

Thank you very much for this, I'll do the reading first.

> I'm not sure, assuming it is a *test* database, why it should be available
> 99.9%

Sorry, I meant the production database.

> Obviously locating the test database on the same server as the production
> database is a bad idea, as is continuing to run 8.0.5, which was desupported
> several years ago. Is Agfa that poor, it can't afford to upgrade to a
> current release?
>

Not my decision also. (Normally I don't use the test environment.) I work at a national sales organization of Agfa with a Data Warehouse for its special needs.

Greeting Harald Buesching. Received on Wed Apr 24 2002 - 01:42:59 CDT