Re: Oracle on Windows

Thanks to everyone.

Martin

>Your start menu entry for Oracle should contain a bunch of entries ...
>In 9i2 there was the Enterprise manager Console ... in 10XE there's a
>http-interface -- I guess 10g will have some administration interface?

Yep , I got it by using Start-Menu -Windows Assistance ( or something like that ,i'm at work right now) and see the databases Right click on the database and the Connect to the db. But where is the tables,viws, sorry I'm SQL Server DBA and just starting to learn Oracle , so please forgive me those questions

>9i2 Created 9 Services on this box here - 3 of which are actually
>running. :-)

>For 1000 Database instances there would be more like 2+1000 processes
>on windows.

So, if I delete the db , the 3 services will be deleted as well?

Thanks

"Martin T." <bilbothebagginsbab5_at_freenet.de> wrote in message news:1155113020.188659.310650_at_h48g2000cwc.googlegroups.com...
> sybrandb wrote:
>> Guitarator wrote:
>> > Uri Dimant wrote:
>> > > > Another question is , I created a new database by using DAC and
>> > > > it created
>> > > > three services on my computer , so if I have 1000 databases , will
>> > > > I see
>> > > > 1000*3 =3000 services? How can I delete/remove the new created
>> > > > database?
>> >
>> > > 9i2 Created 9 Services on this box here - 3 of which are actually
>> > > running. :-)
>> > > For 1000 Database instances there would be more like 2+1000 processes
>> > > on windows.
>> > Hummm Martin
>> > Hi
>> >
>> > I'm not right from you processes estimation. One Oracle instance run
>> > with a minimum of 7 processes. I think that you're talking about
>> > services....
>> >
>> > Regards
>> > Denis
>>
>> And on Winblows the processes are implemented as threads.
>> So there actually is only 1 OracleService<SID> process per database.
>>
> Guitarator - I was talking bout windows here. As Sybrand said, one
> process per database.
>
> 1 service = 1 process on windows per database instance.
> Then there will be an additional service(process) for TNSListener.
> Then there is a service Oracle<home>Agent -- though I dunno what it
> does. :)
>
> cheers,
> Martin
>
Received on Wed Aug 09 2006 - 04:33:40 CDT