Re: Basic Oracle Concepts + 10G Services

"DA Morgan" <damorgan_at_psoug.org> wrote in message news:1122577537.885552_at_yasure...
> Mark C. Stock wrote:

...
>> So more precisely, you connect as a user and each user has a schema. Once
>> connected you access your connection user's schema by default, but can
>> access any other user's schema (if privileges have been granted).
>>
>> ++ mcs
>
> And in 10g you connect to a service ... not a server. Take a good look
> at the last column in v$session in 10g.
>
> And for those that haven't peered under the covers of 10g ... try this:
>
> col service_name format a30
> col program format a30
> select service_name, program from v$session;
>
> Welcome to a very different Oracle.
> --
> Daniel A. Morgan
> http://www.psoug.org
> damorgan_at_x.washington.edu
> (replace x with u to respond)

interesting, here's a pretty basic 10g on XP install, plus HTMLDB with:

[_] a SQL*Plus user logged in locally
[_] a SQL*Plus user logged in with an explicit service name
[_] a TOAD user
[_] a mod_plsql application user (SCOTT)
[_] an HTMLDB user
[_] an iSQL*Plus user

SQL> select service_name, program, username   2 from v$session
  3 order by service_name, program, username;

SERVICE_NAME PROGRAM USERNAME

-------------------- -------------------- -------------------
SYS$BACKGROUND       ORACLE.EXE (CJQ0)
SYS$BACKGROUND       ORACLE.EXE (CKPT)
SYS$BACKGROUND       ORACLE.EXE (DBW0)
SYS$BACKGROUND       ORACLE.EXE (LGWR)
SYS$BACKGROUND       ORACLE.EXE (MMAN)
SYS$BACKGROUND       ORACLE.EXE (MMNL)
SYS$BACKGROUND       ORACLE.EXE (MMON)
SYS$BACKGROUND       ORACLE.EXE (PMON)
SYS$BACKGROUND       ORACLE.EXE (QMNC)
SYS$BACKGROUND       ORACLE.EXE (RECO)
SYS$BACKGROUND       ORACLE.EXE (SMON)
SYS$BACKGROUND       ORACLE.EXE (q000)
SYS$USERS            sqlplusw.exe         SCOTT
SYS$USERS
SYS$USERS

orcl                 Apache.exe           HTMLDB_PUBLIC_USER
orcl                 Apache.exe           SCOTT
orcl                 Apache.exe           SCOTT
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 OMS                  SYSMAN
orcl                 Toad.exe             SCOTT
orcl                 java.exe             OEX
orcl                 sqlplusw.exe         SCOTT

38 rows selected.

so, dan'l -- what's the added value and/or change in architecture?

++ mcs Received on Thu Jul 28 2005 - 14:41:22 CDT