Re: Will ROWID change during DB Runing??

Hans,
Thanks,
Here is the version info.

DB Server:

    OS: Solaris 2.8
    Oralce: ORACLE 8.1.7

App Server:

    OS: Solaris 2.7
    Oracle Lib: 8.1.6
    The application connect to the DB server via 100M intra network card.

There are four processes, each process have 6 threads, each thread connect to the DB with one seperate session.
There are about 240 x 2 query per second and 240 update per second. No insert and delete operations.

Regards,
Grant

"HansF" <News.Hans_at_telus.net> wrote in message news:pan.2004.12.31.15.40.25.364896_at_telus.net...
> On Fri, 31 Dec 2004 14:40:31 +0800, Grant Zhou wrote:
>
> > By the way,
> > From the Oracle 7 Server, SQL Language Ref. Manual:
> >
>
> Great stuff. Slightly out of date, as things have changed (a lot) since
> 1992, but still absolutely wonderful to see people referencing the
manuals.
>
>
> However, unless you are using Oracle Server 7, this information is
> obsolete. As of Oracle8, the ROWID has changed: the format has changed
> and the interpretation has changed. It has changed again with Oracle
> Database 10g.
>
> Best you give a description of the Operating System version and the Oracle
> database version.
>
> /Hans
>
>
Received on Mon Jan 03 2005 - 19:44:02 CST