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

  • From: Mladen Gogala <gogala@xxxxxxxxxxxxx>
  • To: tanel.poder.003@xxxxxxx
  • Date: Thu, 07 Jul 2005 03:59:50 +0000

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


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

Other related posts: