Re: Basic Oracle Concepts + 10G Services

From: DA Morgan <damorgan_at_psoug.org>
Date: Thu, 28 Jul 2005 13:08:08 -0700
Message-ID: <1122581256.209287@yasure>

Mark C. Stock wrote:
> "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
> 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

Client server is dead. Think SOA ... I know another acronym ... but now it is about Service Oriented Architecture.

Take a look too at the following:

SELECT DISTINCT object_name
FROM all_arguments
WHERE object_name like '%SERVICE%';

SELECT DISTINCT table_name, column_name
FROM dba_tab_columns
WHERE column_name LIKE '%SERVICE%'
ORDER BY 1,2;

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)

Received on Thu Jul 28 2005 - 15:08:08 CDT