Re: Finally it is here (10gR2 installed and working ;)

On 07/06/2005 11:19:46 PM, Tanel P?der wrote:
> Hi,
>
> I've just installed 10gR2 on my Sony laptop with 512MB of memory, which is actually running WinXP - in which I have a VMWare machine running RHAS3.0.
> SQL> select count(*) from x$ksppi;
>
> COUNT(*)
> ----------
> 1385

Let me guess, now everything has become undocumented? That underscore is certainly a handy character. I hope that there is _@#$###! parameter, starting, of course, with the underscore.

>
> SQL> select count(*) from dict;
>
> COUNT(*)
> ----------
> 1870
>
> SQL> select count(*) from dba_tables where owner = 'SYS';
>
> COUNT(*)
> ----------
> 701

Ohmigod! I am trying to imagine.

>
> SQL> select count(*) from dba_objects;
>
> COUNT(*)
> ----------
> 50314

Do we need to do anything or are all conceivable objects already pre-created? Can this version read my mind?

>
> SQL> select count(*) from v$event_name;
>
> COUNT(*)
> ----------
> 874

Anjo Kolk created fairly large pile of paper by documenting <100 events in V7. I'm getting frightened.

>
> SQL> select count(*) from v$sysstat;
>
> COUNT(*)
> ----------
> 363
>
> SQL> select count(*) from v$lock_type;
>
> COUNT(*)
> ----------
> 155

Whatever has happened to 5 basic lock modes (1-6) and 10 "system locks"?

>
> SQL> select count(*) from v$reserved_words;
>
> COUNT(*)
> ----------
> 1129

What is the meaning of the word "is"? Is "sex" a reserved word? How about the word "inhale"?

>
>
> Let the party begin!!!
>

$ ls -l /backup/oradist
total 1813988

-rw-r--r--  1 oracle dba 478335981 Jul  6 23:01 10201_client_linux32.zip
-rw-r--r--  1 oracle dba 707784361 Jul  6 21:26 10201_companion_linux32.zip
-rw-r--r--  1 oracle dba 671373759 Jul  6 20:12 10201_database_linux32.zip

I'll wait for the weekend. I'm not running ES 3.0, I am running FC3. I'll need some luck.

-- 
Mladen Gogala
http://www.mgogala.com


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