date:20030120

If I remember correctly (from a previous NT-life): v$process.spid maps to the NT 
thread_id. The thread(s) causing this can be found probably by looking at pstat or 
perfmon: here you can see the cpu consumption. Also you can probably deduce it from 
v$sesstat's 'cpu used by this session': it will be high compared to others (if it's 
just 1 runaway thread)..
regards,
Mario Broodbakker

-Original Message-
Sent: maandag 20 januari 2003 9:54
To: Multiple recipients of list ORACLE-L


In windows NT you cannot map the OS proces with v$session information. I hope
there is a way to get the thread information and map it to V$SESSION, but in
Task Manager it will only show as Oracle.exe for all the processes.

If you find out how to get the thread information and map it to v$session,
please let me know.

But the question is, are you having a problem with 100 CPU utilization? Is it
for short periods or it happens for long duration without much corresponding
DB activity?

Regards
Naveen

-Original Message-
Sent: Monday, January 20, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L


Hussain,

  Good advice. First thing to do is to identify WHICH process or thread is
using CPU. Once you have an OS identifier, check V$SESSION to see what it is
exactly. I would not have as dark a vision as Pankaj - I mean it is not
necessarily a virus or Trojan horse. I have seen quite a number of Oracle
processes (DBSNMP springs to mind, but it's not the only one) causing this
type of behaviour, and there is most often an easy workaround.

- Original Message -
From: Pankaj Agarwal [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Sun, 19 Jan 2003 22:48:53

Hi,

Check the processes runnning and identify the
process
which i resulting in 100% CPU utilization.

you can check it by pressing ctrl+shift+esc. There
will be a tab Processes. Under thi tab it will how
each process that i running on your machine. 

My own experience says it will a trojan or
something
like that which is cauing problem.

Hope thi resolves your problem, Goodluck

Pankaj

--- Hussain Ahmed Qadri [EMAIL PROTECTED] wrote:

 HI all
 We have a consistent problem of CPU utilization
 100%. We have had this
 problem since Saturday, but it automatically
 subsided, I mean went back to
 normal after a few hours, and remained normal on
 Sunday as well. But its
 back to 100% since morning, that is when the load
on
 the server has gone up
 again to 100% and over all work is non-existent. 

 Our machine is Compaq Proliant ML350, 900 MB ram,

 933 single Processor,
 Database size of roughly 5 GB. WINNT4.0, Oracle
 8.1.7.
 I have checked the temporary tablespaces, they
are
 normal.
 We have a 24x7 environment, a hospital, so please

 can you suggest the areas
 to look in to, its really very urgent.
 
 Regards,
 
 Hussain
 
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroul
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).



DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. 
Before opening attachments please check them for viruses and defects. MindTree 
Consulting Private Limited (MindTree) will not be responsible for any viruses or 
defects or any forwarded attachments emanating either from within MindTree or outside. 
If you have received this message by mistake please notify the sender by return  
e-mail and delete this message from your system. Any unauthorized use or dissemination 
of this message in whole or in part is strictly prohibited.  Please note that e-mails 
are susceptible to change and MindTree shall not be liable for any improper, untimely 
or incomplete transmission.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Naveen Nahata
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Broodbakker, Mario
  INET: [EMAIL

RE: iAS 903 902 install

2003-01-20 Thread Jenner Mike

Barbera,
I, too have not touch iAS in the real world.
I was on the 9iAS R2 Oracle course 2 weeks ago though (thew!!).

I remember the instructor saying that the proper releases are 901 and 902.
904 will be out in spring 2003. 
The version 903 is not a full release and contains just parts of 9iAS that
may be needed to install over 902. 
Sorry but I can't remember what reasons there may be for needing 903 so
check thoroughly.

-Original Message-
Sent: 17 January 2003 15:40
To: Multiple recipients of list ORACLE-L


List:
I'm touching iAS for the first time ever.  I don't
understand even basic stuff about it.

The install I have includes 9.0.2 and 9.0.3.  The
install says 9.0.3 is the first J2EE 1.3 compatible
release of Oracle9iAS.  ..blah blah..  Oracle9iAS
9.0.3 contains only the J2EE and Web Cache
Installation Type of Oracle9iAS and is compatible with
Oracle9iAS 9.0.2 infrastructures for clustering,
management, and security.

Do I need to install 9.0.2 and then install 9.0.3 on
top of it to get everyting I need?

We're currently in an evaluation phase.  Developers
want iAS to deploy forms, portal, and build apps with
java.

I have 9.0.3 installed, but don't really understand
what I have, and we're not able to launch a form.

Thanks for any help!
(This is the most frustrating, confusing product I've
ever seen)
Barb


__
Do you Yahoo!?
Yahoo! Mail Plus - Powerful. Affordable. Sign up now.
http://mailplus.yahoo.com
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Barbara Baker
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jenner Mike
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 100% CPU utilization, urgent

2003-01-20 Thread Foelz.Frank

If I remember correctly (from a previous NT-life): 
v$process.spid maps to the NT thread_id. 

no, they don't !!! (at least NT4 with a SQLNet connection to a DB Server)
(see my question I posted a few days ago)

 Frank   

Von: Broodbakker, Mario [mailto:[EMAIL PROTECTED]]
Gesendet am: Montag, 20. Januar 2003 11:34
An: Multiple recipients of list ORACLE-L
Betreff: RE: 100% CPU utilization, urgent

If I remember correctly (from a previous NT-life): 
v$process.spid maps to the NT thread_id. The thread(s) causing 
this can be found probably by looking at pstat or perfmon: 
here you can see the cpu consumption. Also you can probably 
deduce it from v$sesstat's 'cpu used by this session': it will 
be high compared to others (if it's just 1 runaway thread)..
regards,
Mario Broodbakker

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Oracle 9.2.0.2 performance problem

2003-01-20 Thread chao_ping

Juan Miranda,
It seems quite strange,there is little wait event in the statspack 
report, and you execution path should be the same on both platform, right? And is the 
data volumn the same in both platform?And does the time spent on fetch the result from 
server to your client different?Is the speed of your pc to linux and hp the same?






Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)

=== 2003-01-20 01:59:00 ,you wrote£º===

Hello

We have an serious performance problem on a DSS db.
We buy a new HP rp5405 (2x650Mhz, 4GB, ...) with HP UX 11.11

Oracle 9.2.0.2 tooks 30 min doing this query where an  Intel 2x1,4 Ghz tooks
9 min only.

We have in the HP losts of buffers(1,5GB), sga(200MB), pga(500MB), fast i/O
(EMC Clariom CX600)...
We try lost of parameters, but time is always the same.

Is there some bug in this release - platform ?
How can I get more data about this problem??

Thanks.

SELECT grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
   evpanc,evpgru,evpcli,evppai,evppro,evpume,
   to_date(evpano||'-'||evpmes||'-'||'01','-MM-DD') FECHA,
   sum(evppca) PPTO
FROM DW.SUPUESTOS
GROUP BY grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
   evpanc,evpgru,evpcli,evppai,evppro,evpume,
   evpano, evpmes

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --  --

Parse1  0.01   0.00  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch   445920   1748.651708.72   1554   1675 23
445919
--- --   -- -- -- --  --

total   445922   1748.661708.72   1554   1675 23
445919

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 90 (recursive depth: 1)


Execution Plan
--
   0  SELECT STATEMENT Optimizer=CHOOSE (Cost=4481 Card=464215 Byt
  es=32495050)

   10   SORT (GROUP BY) (Cost=4481 Card=464215 Bytes=32495050)
   21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=162 Card=464215
   Bytes=32495050)

Statistics
--
  0  recursive calls
 31  db block gets
   1675  consistent gets
   1577  physical reads
  0  redo size
9012743  bytes sent via SQL*Net to client
 208363  bytes received via SQL*Net from client
  29729  SQL*Net roundtrips to/from client
  0  sorts (memory)
  1  sorts (disk)
 445919  rows processed

= = = = = = = = = = = = = = = = = = = =




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: chao_ping
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Server specifications

Title: Server specifications





Hi all,
Can anyone tell me if there is any general guide line or benchmark, which tells us that for running a certain number of transactions in a specified time, or for a certain size of DB, the Server Configuration should be like what? 

And what is the way of finding (through a query or any tool for it) the number of transactions on a system in a specified time.

I have to convince my management that we need to upgrade our servers and I need such facts to back me up
Any help would be appreciated.


Regards,


Hussain

RE: Re: 100% CPU utilization, urgent

Title: RE: Re: 100% CPU utilization, urgent





When it happens, it happens consistently, for hours, non-stop. I hope there is a way to find out this information about the operating system process.

Thanks and regards


Hussain


-Original Message-
From: Naveen Nahata [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 1:54 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: 100% CPU utilization, urgent


In windows NT you cannot map the OS proces with v$session information. I hope
there is a way to get the thread information and map it to V$SESSION, but in
Task Manager it will only show as Oracle.exe for all the processes.


If you find out how to get the thread information and map it to v$session,
please let me know.


But the question is, are you having a problem with 100 CPU utilization? Is it
for short periods or it happens for long duration without much corresponding
DB activity?


Regards
Naveen


-Original Message-
Sent: Monday, January 20, 2003 1:59 PM
To: Multiple recipients of list ORACLE-L



Hussain,


 Good advice. First thing to do is to identify WHICH process or thread is
using CPU. Once you have an OS identifier, check V$SESSION to see what it is
exactly. I would not have as dark a vision as Pankaj - I mean it is not
necessarily a virus or Trojan horse. I have seen quite a number of Oracle
processes (DBSNMP springs to mind, but it's not the only one) causing this
type of behaviour, and there is most often an easy workaround.


- Original Message -
From: Pankaj Agarwal [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Sun, 19 Jan 2003 22:48:53

Hi,

Check the processes runnning and identify the
process
which i resulting in 100% CPU utilization.

you can check it by pressing ctrl+shift+esc. There
will be a tab Processes. Under thi tab it will how
each process that i running on your machine.

My own experience says it will a trojan or
something
like that which is cauing problem.

Hope thi resolves your problem, Goodluck

Pankaj

--- Hussain Ahmed Qadri [EMAIL PROTECTED] wrote:

 HI all
 We have a consistent problem of CPU utilization
 100%. We have had this
 problem since Saturday, but it automatically
 subsided, I mean went back to
 normal after a few hours, and remained normal on
 Sunday as well. But its
 back to 100% since morning, that is when the load
on
 the server has gone up
 again to 100% and over all work is non-existent.

 Our machine is Compaq Proliant ML350, 900 MB ram,

 933 single Processor,
 Database size of roughly 5 GB. WINNT4.0, Oracle
 8.1.7.
 I have checked the temporary tablespaces, they
are
 normal.
 We have a 24x7 environment, a hospital, so please

 can you suggest the areas
 to look in to, its really very urgent.

 Regards,

 Hussain

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroul
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).




DISCLAIMER:
This message (including attachment if any) is confidential and may be privileged. Before opening attachments please check them for viruses and defects. MindTree Consulting Private Limited (MindTree) will not be responsible for any viruses or defects or any forwarded attachments emanating either from within MindTree or outside. If you have received this message by mistake please notify the sender by return e-mail and delete this message from your system. Any unauthorized use or dissemination of this message in whole or in part is strictly prohibited. Please note that e-mails are susceptible to change and MindTree shall not be liable for any improper, untimely or incomplete transmission.

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Naveen Nahata
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

RE: Changed execution plans..

2003-01-20 Thread yanto

I read in one article, that if oracle
found there are more than 1 index can 
be used for our query indicate by first
column in index, oracle will use the latest index.
except we directly use index hint in our query.

hopes this help




--- Robert Freeman [EMAIL PROTECTED] wrote:
 Thanks Cary... I've actually considered most of
 those already. This isn't my
 database, I'm coming in to help someone else. In
 this case, the database
 schema was accidentally dropped, and recovered from
 an export. I'm wondering
 if the import might have created blocks that are
 packed more densely and
 that this might be the cause of the problem. I'm
 told the parameters are the
 same, that the physical structure is the same, they
 are not using stored
 outlines and the SQL has not been changed. No
 patches have been applied, so
 it's apples for apples with the exception of the
 statistics and, possibly,
 the data density. They have some old stored
 statistics that they generated
 pre-schema drop that they are supposed to send me,
 so I'm going to look at
 that tomorrow and run a 10053 trace on one of the
 changed queries and see
 what I can find. I was just wondering if I could be
 missing something
 obvious. Seems like that is just the way, it's
 the obvious things that
 get missed... :-)
 
 Thanks so much for your comments!
 
 RF
 
 -Original Message-
 Millsap
 Sent: Sunday, January 19, 2003 8:54 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Robert,
 
 Seven reasons I can think of include changes to:
 
 1. Oracle instance parameter values (changes when
 you edit the
 parameters, whether in the stored init.ora way, or
 via ALTER SYSTEM or
 ALTER SESSION commands)
 2. Database table and index statistics (changes,
 e.g., when you run
 dbms_stats.gather_database_stats)
 3. System CPU and I/O statistics (changes, e.g.,
 when you run
 dbms_stats.gather_system_stats)
 4. Database schema configuration (changes when you
 create/drop indexes,
 etc.)
 5. Stored outlines (changes when you create or
 reassign outlines)
 6. SQL text (changes when you manipulate the
 application SQL)
 7. Oracle query cost model (changes when you upgrade
 or patch your
 Oracle kernel)
 
 
 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com
 
 Upcoming events:
 - 2003 Hotsos Symposium, Feb 9-12 Dallas
 - RMOUG Training Days 2003, Mar 5-6 Denver
 - Hotsos Clinic 101, Mar 26-28 London
 
 
 -Original Message-
 Freeman
 Sent: Sunday, January 19, 2003 1:24 AM
 To: Multiple recipients of list ORACLE-L
 
 Hey Ya'all... (still got my southern roots even up
 here in Chicago!)
 
 Anyone want to throw in some possible reasons why an
 execution plan
 might
 change for a given table queryThis is on
 Oracle9iR2 on SUN. I've
 looked
 at the obvious causes:
 
 1. Object has changed - Appears not to have changed.
 2. Database parameters have changed - Appears that
 no parameters have
 changed.
 3. Statistics (data volumes, distribution,
 cardinality, etc) have
 changed -
 Still looking into this, but the volumes have not
 changed dramatically
 even
 if they have changed.
 4. Other physical database changes.
 
 None of these seem to apply. I've got a database
 that a few weeks ago
 were
 doing indexed
 lookups using a partitioned index on a partitioned
 table. Now, it seems
 that
 these queries
 are doing full table scans on this partitioned
 table. I'm still
 gathering up
 the details for the items above (e.g how much have
 the objects changed)
 and
 I'll probably run a 10053 trace on one of the bad
 queries to see what
 the
 optimizer is doing on Monday, but I'd like to just
 poll for some
 additional
 ideas. I *AM* getting partition elimination (thank
 goodness) but I've
 got
 two FTS on one partition of this table that are just
 killing it. They
 want
 to quantify the reason why this access has changed
 so I'm trying to
 think of
 what kinds of stuff I can look at to try to do this.
 
 I will add that this table was just rebuilt recently
 (through
 imp/exp)...
 can the change in row to block density make the
 difference h
 
 Any ideas??
 
 RF
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 --
 Author: Robert Freeman
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California-- Mailing list and web
 hosting services

-
 To REMOVE yourself from this mailing list, send an
 E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of
 'ListGuru') and in
 the message BODY, include a line containing: UNSUB
 ORACLE-L
 (or the name of mailing list you want to be removed
 from).  You may
 also send the HELP command for other information
 (like subscribing).
 
 --
 Please see the official ORACLE-L FAQ:
 http://www.orafaq.net
 --
 Author: Cary Millsap
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051
 http://www.fatcity.com
 San Diego, California

RE: Oracle 9.2.0.2 performance problem

2003-01-20 Thread Juan Miranda


Hello

We execute the query in the servers, so there is no NET problem (I think).
The data volume is exact (imported).
Execution path is the same, full-scan.

This is a very strange problem and is very important for us to solve it.
Thank´s

This is the plan of the windows db:
Execution Plan
--
   0  SELECT STATEMENT Optimizer=CHOOSE (Cost=5952 Card=465110 Byt
  es=32557700)

   10   SORT (GROUP BY) (Cost=5952 Card=465110 Bytes=32557700)
   21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=643 Card=465110
   Bytes=32557700)
Statistics
--
  0  recursive calls
  4  db block gets
   6679  consistent gets
  12866  physical reads
  0  redo size
   26428556  bytes sent via SQL*Net to client
3894740  bytes received via SQL*Net from client
  59454  SQL*Net roundtrips to/from client
  0  sorts (memory)
  1  sorts (disk)
 445919  rows processed


-Mensaje original-
De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de chao_ping
Enviado el: lunes, 20 de enero de 2003 12:19
Para: Multiple recipients of list ORACLE-L
Asunto: Re: Oracle 9.2.0.2 performance problem


Juan Miranda,
It seems quite strange,there is little wait event in the statspack 
report,
and you execution path should be the same on both platform, right? And is
the data volumn the same in both platform?And does the time spent on fetch
the result from server to your client different?Is the speed of your pc to
linux and hp the same?






Regards
zhu chao
msn:[EMAIL PROTECTED]
www.happyit.net
www.cnoug.org(China Oracle User Group)

=== 2003-01-20 01:59:00 ,you wrote£º===

Hello

We have an serious performance problem on a DSS db.
We buy a new HP rp5405 (2x650Mhz, 4GB, ...) with HP UX 11.11

Oracle 9.2.0.2 tooks 30 min doing this query where an  Intel 2x1,4 Ghz
tooks
9 min only.

We have in the HP losts of buffers(1,5GB), sga(200MB), pga(500MB), fast i/O
(EMC Clariom CX600)...
We try lost of parameters, but time is always the same.

Is there some bug in this release - platform ?
How can I get more data about this problem??

Thanks.

SELECT grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
   evpanc,evpgru,evpcli,evppai,evppro,evpume,
   to_date(evpano||'-'||evpmes||'-'||'01','-MM-DD') FECHA,
   sum(evppca) PPTO
FROM DW.SUPUESTOS
GROUP BY grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
   evpanc,evpgru,evpcli,evppai,evppro,evpume,
   evpano, evpmes

call count   cpuelapsed   disk  querycurrent
rows
--- --   -- -- -- --  -
-

Parse1  0.01   0.00  0  0  0
0
Execute  1  0.00   0.00  0  0  0
0
Fetch   445920   1748.651708.72   1554   1675 23
445919
--- --   -- -- -- --  -
-

total   445922   1748.661708.72   1554   1675 23
445919

Misses in library cache during parse: 1
Optimizer goal: CHOOSE
Parsing user id: 90 (recursive depth: 1)


Execution Plan
--
   0  SELECT STATEMENT Optimizer=CHOOSE (Cost=4481 Card=464215 Byt
  es=32495050)

   10   SORT (GROUP BY) (Cost=4481 Card=464215 Bytes=32495050)
   21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=162 Card=464215
   Bytes=32495050)

Statistics
--
  0  recursive calls
 31  db block gets
   1675  consistent gets
   1577  physical reads
  0  redo size
9012743  bytes sent via SQL*Net to client
 208363  bytes received via SQL*Net from client
  29729  SQL*Net roundtrips to/from client
  0  sorts (memory)
  1  sorts (disk)
 445919  rows processed

= = = = = = = = = = = = = = = = = = = =




--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: chao_ping
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Juan Miranda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

RE: 100% CPU utilization, urgent

Frank,

I'm pretty sure they do:

SQL select spid,program from v$process;

SPID  PROGRAM
- --
  PSEUDO
892   ORACLE.EXE
896   ORACLE.EXE
1044  ORACLE.EXE
528   ORACLE.EXE
616   ORACLE.EXE
792   ORACLE.EXE
300   ORACLE.EXE

From Pstat:

pid:6a8 pri: 8 Hnd:  206 Pf:  43673 Ws:  17828K oracle.exe
 tid pri Ctx Swtch StrtAddrUser Time  Kernel Time  State
 424   8   937 77E99264  0:00:00.020  0:00:01.281 Wait:Executive
 690   851 77E83775  0:00:00.000  0:00:00.020 Wait:UserRequest
 6f8   8 2 77E83775  0:00:00.000  0:00:00.000 Wait:UserRequest
 510   9 7 77E83775  0:00:00.000  0:00:00.000 Wait:UserRequest
 558   8 4 77E83775  0:00:00.000  0:00:00.010 Wait:DelayExecution
 450   971 77E83775  0:00:00.000  0:00:00.000 Wait:EventPairLow
 37c   8  8158 77E83775  0:00:00.220  0:00:00.861 Wait:UserRequest
 380   8   926 77E83775  0:00:00.020  0:00:00.090 Wait:UserRequest
 414   8  1040 77E83775  0:00:00.010  0:00:00.270 Wait:UserRequest
 210   9  1837 77E83775  0:00:00.040  0:00:00.080 Wait:UserRequest
 268   8   237 77E83775  0:00:00.420  0:00:00.150 Wait:UserRequest
 318   965 77E83775  0:00:00.010  0:00:00.040 Wait:UserRequest
 12c   9  6347 77E83775  0:02:30.826  0:00:00.821 Wait:UserRequest

The last tid (12c hex) equals to 300: that's my thread after running Jonathans world 
famous kill_cpu script.
You can checkout (after converting to dec) a few of the others too.
This was the case on NT4 and I just showed this on W2K
In perfmon you can find the thread_id in the Thread Object (don't confuse it with the 
perfmon's object_id!), and off course the cpu usage of the corresponding thread.

regards,
Mario
Btw I didn't see your earlier question, since I joined the list a few days ago, please 
send it to me if you want a more specific answer (or correct me if I'm wrong)

-Original Message-
Sent: maandag 20 januari 2003 12:39
To: Multiple recipients of list ORACLE-L


If I remember correctly (from a previous NT-life): 
v$process.spid maps to the NT thread_id. 

no, they don't !!! (at least NT4 with a SQLNet connection to a DB Server)
(see my question I posted a few days ago)

 Frank   

Von: Broodbakker, Mario [mailto:[EMAIL PROTECTED]]
Gesendet am: Montag, 20. Januar 2003 11:34
An: Multiple recipients of list ORACLE-L
Betreff: RE: 100% CPU utilization, urgent

If I remember correctly (from a previous NT-life): 
v$process.spid maps to the NT thread_id. The thread(s) causing 
this can be found probably by looking at pstat or perfmon: 
here you can see the cpu consumption. Also you can probably 
deduce it from v$sesstat's 'cpu used by this session': it will 
be high compared to others (if it's just 1 runaway thread)..
regards,
Mario Broodbakker

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Broodbakker, Mario
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Re: 100% CPU utilization, urgent

Title: RE: Re: 100% CPU utilization, urgent





Hi,


It's the Oracle.exe which is taking 100%. V$session tells me about the users connected to the database, but no the info about which user is taking what percentage of CPU. How can I identify which Oracle process (like DBSNMP or anyother) it is that is taking so much CPU?

By the way, I have been able to solve the problem, by increasing the Large_pool_size and sort_area_size parameters, and thank to Allah, its working fine since then. Anything else that I should do in light of this?

Regards,


Hussain


-Original Message-
From: Stephane Faroult [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 1:29 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Re: 100% CPU utilization, urgent


Hussain,


 Good advice. First thing to do is to identify WHICH process or thread is using CPU. Once you have an OS identifier, check V$SESSION to see what it is exactly. I would not have as dark a vision as Pankaj - I mean it is not necessarily a virus or Trojan horse. I have seen quite a number of Oracle processes (DBSNMP springs to mind, but it's not the only one) causing this type of behaviour, and there is most often an easy workaround.

- Original Message -
From: Pankaj Agarwal [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Sun, 19 Jan 2003 22:48:53

Hi,

Check the processes runnning and identify the
process
which i resulting in 100% CPU utilization.

you can check it by pressing ctrl+shift+esc. There
will be a tab Processes. Under thi tab it will how
each process that i running on your machine.

My own experience says it will a trojan or
something
like that which is cauing problem.

Hope thi resolves your problem, Goodluck

Pankaj

--- Hussain Ahmed Qadri [EMAIL PROTECTED] wrote:

 HI all
 We have a consistent problem of CPU utilization
 100%. We have had this
 problem since Saturday, but it automatically
 subsided, I mean went back to
 normal after a few hours, and remained normal on
 Sunday as well. But its
 back to 100% since morning, that is when the load
on
 the server has gone up
 again to 100% and over all work is non-existent.

 Our machine is Compaq Proliant ML350, 900 MB ram,

 933 single Processor,
 Database size of roughly 5 GB. WINNT4.0, Oracle
 8.1.7.
 I have checked the temporary tablespaces, they
are
 normal.
 We have a 24x7 environment, a hospital, so please

 can you suggest the areas
 to look in to, its really very urgent.

 Regards,

 Hussain

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroul
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

ORA-00955: name is already used by an existing object

2003-01-20 Thread Krishnaswamy, Ranganath

I have the following table in Oracle 8.1.7:

Name  Null?Type
-  --
DIENSTLEISTUNGSOBJEKTOID   VARCHAR2(23)
OID   NOT NULL VARCHAR2(23)
AUMESSWERTEVARCHAR2(23)
AUART  NUMBER(10)
BAUJAHRBEGINN  NUMBER(10)
BAUJAHRENDENUMBER(10)
BEZUGSNUMMER   NUMBER(10)
CHECKBOXMANUELLNUMBER(1)
ENTSPRAUSDRUCK NUMBER(10)
GETRIEBETYPVARCHAR2(10)
HERSTELLERTEXT VARCHAR2(18)
HUBRAUMCCM NUMBER(10)
HUBRAUMLITER   NUMBER
LEISTUNGKW NUMBER(10)
MINDESTOKTANZAHL   NUMBER(10)
MODELL VARCHAR2(20)
MODELLJAHR VARCHAR2(11)
MODELLVARNUMMERNUMBER(10)
MOTORCODE  VARCHAR2(18)
SPEZAUSRUESTUNGVARCHAR2(25)
ZYLINDERZAHL   NUMBER(10)
CLSTYPE   NOT NULL VARCHAR2(40)
MESSUNGSARTNUMBER(10)
ANZAHLTEILSCHAEDEN NUMBER(10)
BESICHTIGUNGSBEDINGUNGEN   VARCHAR2(23)
DURCHGEFUEHRTEREPARATUREN  VARCHAR2(23)
EINGEBAUTENTAUSCHAGGREGATKOPF  VARCHAR2(23)
ERSATZTEILEVARCHAR2(23)
FZALLGEMEINZUSTAND VARCHAR2(23)
GEBRAUCHSSCHADENKOPF   VARCHAR2(23)
KALKULATIONBETRAEGEVARCHAR2(23)
LACKAZTVARCHAR2(23)
LACKMATERIAL   VARCHAR2(23)
LACKIERUNG VARCHAR2(23)
LAUFLEISTUNG   VARCHAR2(23)
LOHNKOSTEN VARCHAR2(23)
MECHANIK   VARCHAR2(23)
NACHSCHADENVARCHAR2(23)
NOTWREPARATURKOSTENINCLMWSTNUMBER(1)
NOTWENDIGENTAUSCHAGGREGATKOPF  VARCHAR2(23)
REPARTURWEGVARCHAR2(23)
SCHADENDATEN   VARCHAR2(23)
SCHADENBESCHREIBUNGVARCHAR2(23)
SONSTIGEKALKDATEN  VARCHAR2(23)
UMBAUKOSTENVARCHAR2(23)
VERSCHLEISSSCHADENKOPF VARCHAR2(23)
VORGANGSDATEN  VARCHAR2(23)
VORSCHAEDENVARCHAR2(23)
ZUORDNUNG  VARCHAR2(23)
ZUSTANDVARCHAR2(23)
MESSWERTHERKUNFT   NUMBER(10)
MESSWERTLISTAKTIV  NUMBER(1)
FEHLENDETEILE  VARCHAR2(23)
BEWERTUNGERGEBNIS  VARCHAR2(23)
WERTKORREKTURENVARCHAR2(23)
BEMERKUNG  VARCHAR2(4000)
NUMMER VARCHAR2(40)
VORGANGVARCHAR2(40)
AUDATEXUEBERNEHMEN NUMBER(1)
BAUMUSTER  VARCHAR2(100)
HERSTELLER VARCHAR2(100)
NFZAUSSTATTUNG VARCHAR2(23)
RADSTAND1  NUMBER(10)
RADSTAND2  NUMBER(10)
VERKAUFSBEZEICHNUNGVARCHAR2(100)
FZALLGEMEINZUSTANDBEMERKUNGCLOB
FZALLGEMEINZUSTANDCBXCODE  NUMBER(10)
NICHTMITBEWERTETETEILE CLOB
EREIGNISCBXVARCHAR2(40)
FAHRER VARCHAR2(20)
FAHRERORT  VARCHAR2(30)
FAHRERSTRASSE  VARCHAR2(30)
HERGANGSSCHILDERUNGCLOB
HERGANGSSCHILDERUNGLTCBX   VARCHAR2(40)
NACHSCHADENANGABENCBX  VARCHAR2(40)
NACHSCHADENBEMERKUNG   CLOB
POLAUFNAHMEARTCBX

RE: Re: 100% CPU utilization, urgent

2003-01-20 Thread Jeremiah Wilton

On Mon, 20 Jan 2003, Hussain Ahmed Qadri wrote:

 It's the Oracle.exe which is taking 100%. V$session tells me about the users
 connected to the database, but no the info about which user is taking what
 percentage of CPU. How can I identify which Oracle process (like DBSNMP or
 anyother) it is that is taking so much CPU?

I don't know how to see the top CPU-using thread in Windows, but you
can get this from the database if you have TIMED_STATISTICS set to
TRUE.

Just query v$sesstat and join to v$statname by statistic# looking only
for 'CPU used by this session', and find out which sid is using the
most CPU BETWEEN QUERIES.  Alternately, you can get this info from the
same table since instance startup by dividing the statistics value by
the total lifetime of the session taken from from v$session.

I'll let you make the SQL.

--
Jeremiah Wilton
http://www.speakeasy.net/~jwilton


 --- Hussain Ahmed Qadri [EMAIL PROTECTED] wrote:
 
  We have a consistent problem of CPU utilization
  100%. We have had this
  problem since Saturday, but it automatically
  subsided, I mean went back to
  normal after a few hours, and remained normal on
  Sunday as well. But its
  back to 100% since morning, that is when the load
 on
  the server has gone up
  again to 100% and over all work is non-existent.
 
  Our machine is Compaq Proliant ML350, 900 MB ram,
 
  933 single Processor,
  Database size of roughly 5 GB. WINNT4.0, Oracle
  8.1.7.
  I have checked the temporary tablespaces, they
 are
  normal.
  We have a 24x7 environment, a hospital, so please
 
  can you suggest the areas
  to look in to, its really very urgent.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeremiah Wilton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: temp space

2003-01-20 Thread Chris Stephens

Title: temp space



after 
utilizing a pl/sql routine found on asktom.com we were able to catch the 
offending query that was consistently causing the 1652. (this isn't 
something that you can capture from the v$ views if the session has disconnected 
(at least i know of know way)) ...anyways the problem was that the 
relevant tables were not properly intexed and not the size of the temp 
space.

thank 
you for the suggestions though.

  -Original Message-From: Bernardus Deddy Hoeydiono 
  [mailto:[EMAIL PROTECTED]]Sent: Sunday, January 19, 2003 9:29 
  PMTo: Multiple recipients of list ORACLE-LSubject: RE: 
  temp space
  Hi 
  Chris,
  
  The 
  error ORA-1652 is because of the temporary tablespace for the corresponding 
  table is not enough. The temporary tablespace for the table normally assigned 
  when create the table. Or when create the user. If you're not define the 
  temporary tablespace when you create the table, the temporary tablespace will 
  follow the temporay tablespace that already assign in the user 
  creation.
  
  To 
  solve this problem, please resize the teporary tablespace.
  
  Thank's
  
  Bernardus Deddy Hoeydiono.
  
-Original Message-From: [EMAIL PROTECTED] 
[mailto:[EMAIL PROTECTED]]On Behalf Of Chris StephensSent: 
Friday, January 17, 2003 9:55 PMTo: Multiple recipients of list 
ORACLE-LSubject: temp space
anyone know how to identify the session that caused a 
ORA-1652? 
-thank you

RE: 100% CPU utilization, urgent

2003-01-20 Thread Chris Stephens

Title: 100% CPU utilization, urgent



we had 
a problem with cpu usage and it ended up being the 'intelligent' agent. 
...after some consideration we decide there wasn't any reason we HAD to have the 
agent running so we just shut it down.

...just a shot in the dark.

chris

  -Original Message-From: Hussain Ahmed Qadri 
  [mailto:[EMAIL PROTECTED]]Sent: Sunday, January 19, 2003 11:44 
  PMTo: Multiple recipients of list ORACLE-LSubject: 100% 
  CPU utilization, urgent
  HI all We have a consistent problem of 
  CPU utilization 100%. We have had this problem since Saturday, but it 
  automatically subsided, I mean went back to normal after a few hours, and 
  remained normal on Sunday as well. But its back to 100% since morning, that is 
  when the load on the server has gone up again to 100% and over all work is 
  non-existent. 
  Our machine is Compaq Proliant ML350, 900 MB ram, 933 single 
  Processor, Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7.
  I have checked the temporary tablespaces, they are 
  normal. We have a 24x7 environment, a hospital, so 
  please can you suggest the areas to look in to, its really very urgent. 
  
  Regards, 
  Hussain

RE: 100% CPU utilization, urgent

...and this:

SQL select sid,process from v$session;

   SID PROCESS
-- -
 1 892
 2 896
 3 1044
 4 528
 5 616
 6 792
 7 1676:932

(my sqlplus sid=7) the 1676:932 pair appears to be the 'process_id:thread_id' from the 
sqlplus.exe client program:

pid:68c pri: 8 Hnd:   78 Pf:  58549 Ws:   2068K sqlplus.exe
 tid pri Ctx Swtch StrtAddrUser Time  Kernel Time  State
 3a4   8 55171 77E99264  0:00:14.350  0:00:15.302 Wait:LpcReply

regards,
Mario Broodbakker


-Original Message-
Sent: maandag 20 januari 2003 12:39
To: Multiple recipients of list ORACLE-L


If I remember correctly (from a previous NT-life): 
v$process.spid maps to the NT thread_id. 

no, they don't !!! (at least NT4 with a SQLNet connection to a DB Server)
(see my question I posted a few days ago)

 Frank   

Von: Broodbakker, Mario [mailto:[EMAIL PROTECTED]]
Gesendet am: Montag, 20. Januar 2003 11:34
An: Multiple recipients of list ORACLE-L
Betreff: RE: 100% CPU utilization, urgent

If I remember correctly (from a previous NT-life): 
v$process.spid maps to the NT thread_id. The thread(s) causing 
this can be found probably by looking at pstat or perfmon: 
here you can see the cpu consumption. Also you can probably 
deduce it from v$sesstat's 'cpu used by this session': it will 
be high compared to others (if it's just 1 runaway thread)..
regards,
Mario Broodbakker

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Broodbakker, Mario
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Changed execution plans..

2003-01-20 Thread Deshpande, Kirti

Robert,
 Was imp run with default options? 
 The way it computes stats after table imports, may not be appropriate. 
 
- Kirti 

-Original Message-
Sent: Sunday, January 19, 2003 10:29 PM
To: Multiple recipients of list ORACLE-L


Thanks Cary... I've actually considered most of those already. This isn't my
database, I'm coming in to help someone else. In this case, the database
schema was accidentally dropped, and recovered from an export. I'm wondering
if the import might have created blocks that are packed more densely and
that this might be the cause of the problem. I'm told the parameters are the
same, that the physical structure is the same, they are not using stored
outlines and the SQL has not been changed. No patches have been applied, so
it's apples for apples with the exception of the statistics and, possibly,
the data density. They have some old stored statistics that they generated
pre-schema drop that they are supposed to send me, so I'm going to look at
that tomorrow and run a 10053 trace on one of the changed queries and see
what I can find. I was just wondering if I could be missing something
obvious. Seems like that is just the way, it's the obvious things that
get missed... :-)

Thanks so much for your comments!

RF

-Original Message-
Millsap
Sent: Sunday, January 19, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L


Robert,

Seven reasons I can think of include changes to:

1. Oracle instance parameter values (changes when you edit the
parameters, whether in the stored init.ora way, or via ALTER SYSTEM or
ALTER SESSION commands)
2. Database table and index statistics (changes, e.g., when you run
dbms_stats.gather_database_stats)
3. System CPU and I/O statistics (changes, e.g., when you run
dbms_stats.gather_system_stats)
4. Database schema configuration (changes when you create/drop indexes,
etc.)
5. Stored outlines (changes when you create or reassign outlines)
6. SQL text (changes when you manipulate the application SQL)
7. Oracle query cost model (changes when you upgrade or patch your
Oracle kernel)


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London


-Original Message-
Freeman
Sent: Sunday, January 19, 2003 1:24 AM
To: Multiple recipients of list ORACLE-L

Hey Ya'all... (still got my southern roots even up here in Chicago!)

Anyone want to throw in some possible reasons why an execution plan
might
change for a given table queryThis is on Oracle9iR2 on SUN. I've
looked
at the obvious causes:

1. Object has changed - Appears not to have changed.
2. Database parameters have changed - Appears that no parameters have
changed.
3. Statistics (data volumes, distribution, cardinality, etc) have
changed -
Still looking into this, but the volumes have not changed dramatically
even
if they have changed.
4. Other physical database changes.

None of these seem to apply. I've got a database that a few weeks ago
were
doing indexed
lookups using a partitioned index on a partitioned table. Now, it seems
that
these queries
are doing full table scans on this partitioned table. I'm still
gathering up
the details for the items above (e.g how much have the objects changed)
and
I'll probably run a 10053 trace on one of the bad queries to see what
the
optimizer is doing on Monday, but I'd like to just poll for some
additional
ideas. I *AM* getting partition elimination (thank goodness) but I've
got
two FTS on one partition of this table that are just killing it. They
want
to quantify the reason why this access has changed so I'm trying to
think of
what kinds of stuff I can look at to try to do this.

I will add that this table was just rebuilt recently (through
imp/exp)...
can the change in row to block density make the difference h

Any ideas??

RF

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Freeman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: MAX Length of Name for Table / Index ?

2003-01-20 Thread Deshpande, Kirti

Banarasi Babu,
 It is Oracle delivered (on UNIX platforms), shell script that takes the 'ORA ' as 
argument, to display the description and cause of an oracle error from the Error 
Message file. It is free and gets installed when you install Oracle software, and is 
located in $ORACLE_HOME/bin directory. The Error Message file is in 
$ORACLE_HOME/rdbms/mesg directory. 

- Kirti 

-Original Message-
Sent: Sunday, January 19, 2003 11:34 PM
To: Multiple recipients of list ORACLE-L


Hi kirti

what is this oerr utility. Where can i found that one...
Please give me details.

thanks in advance
Banarasi Babu

-Original Message-
Sent: Friday, January 17, 2003 7:34 PM
To: Multiple recipients of list ORACLE-L



1) 
SVRMGR create table A2345678901234567890123456789012345 (c number);
create table A234567890123456789012345678901234567890 (c number)
 *
ORA-00972: identifier is too long
SVRMGR !oerr ora 972
00972, 0, identifier is too long
// *Cause:  An identifier with more than 30 characters was specified.
// *Action:  Specify at most 30 characters.
SVRMGR 

You can try this test for an Index ;) 

2)
Larry  the gang decided that ;) 

- Kirti  

-Original Message-
Sent: Friday, January 17, 2003 5:59 AM
To: Multiple recipients of list ORACLE-L



What is the MAX possible Length of of Name for Table / Index ?

Why ?

Thanks

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: VIVEK_SHARMA
  INET: [EMAIL PROTECTED]

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Oracle SPID vs. NT PIDs (was :100% CPU utilization, urgent)

2003-01-20 Thread Foelz.Frank

Mario 

so how comes, that I am not able to find the corresponding SPID to my
NT-processes ???

I tried the following statement :


#
select
 substr(a.spid,1,5) pid,
 substr(b.sid,1,5) sid,
 substr(b.serial#,1,5) ser#,
 machine box,
 substr(b.username,1,10) username,
 -- b.server,
 substr(b.osuser,1,8) os_user,
 substr(b.program,1,30) program
 from v$session b, v$process a
 where
 b.paddr = a.addr
 and type='USER'
 order by spid;

## and I got :

PID   SID   SER#  BOX USERNAME
OS_USER  PROGRAM   
- - - --- --
 -
00111 5810121 networkname xx
xxx  C:\myexe.exe


###
(beware of wordwrap here)

If find the process myexe.exe on networkname in the taskmanager. It's PID is
: 478 (HEX 1DE). The database is on a separate server in the network.

None of the processes, running on the client could pointed to a SPID on the
server. ???


 Frank   


-Ursprüngliche Nachricht-
Von: Broodbakker, Mario [mailto:[EMAIL PROTECTED]]
Gesendet am: Montag, 20. Januar 2003 13:59
An: Multiple recipients of list ORACLE-L
Betreff: RE: 100% CPU utilization, urgent

Frank,

I'm pretty sure they do:

SQL select spid,program from v$process;

SPID  PROGRAM
- --
  PSEUDO
892   ORACLE.EXE
896   ORACLE.EXE
1044  ORACLE.EXE
528   ORACLE.EXE
616   ORACLE.EXE
792   ORACLE.EXE
300   ORACLE.EXE

From Pstat:

pid:6a8 pri: 8 Hnd:  206 Pf:  43673 Ws:  17828K oracle.exe
 tid pri Ctx Swtch StrtAddrUser Time  Kernel Time  State
 424   8   937 77E99264  0:00:00.020  0:00:01.281 Wait:Executive
 690   851 77E83775  0:00:00.000  0:00:00.020 Wait:UserRequest
 6f8   8 2 77E83775  0:00:00.000  0:00:00.000 Wait:UserRequest
 510   9 7 77E83775  0:00:00.000  0:00:00.000 Wait:UserRequest
 558   8 4 77E83775  0:00:00.000  0:00:00.010 
Wait:DelayExecution
 450   971 77E83775  0:00:00.000  0:00:00.000 Wait:EventPairLow
 37c   8  8158 77E83775  0:00:00.220  0:00:00.861 Wait:UserRequest
 380   8   926 77E83775  0:00:00.020  0:00:00.090 Wait:UserRequest
 414   8  1040 77E83775  0:00:00.010  0:00:00.270 Wait:UserRequest
 210   9  1837 77E83775  0:00:00.040  0:00:00.080 Wait:UserRequest
 268   8   237 77E83775  0:00:00.420  0:00:00.150 Wait:UserRequest
 318   965 77E83775  0:00:00.010  0:00:00.040 Wait:UserRequest
 12c   9  6347 77E83775  0:02:30.826  0:00:00.821 Wait:UserRequest

The last tid (12c hex) equals to 300: that's my thread after 
running Jonathans world famous kill_cpu script.
You can checkout (after converting to dec) a few of the others too.
This was the case on NT4 and I just showed this on W2K
In perfmon you can find the thread_id in the Thread Object 
(don't confuse it with the perfmon's object_id!), and off 
course the cpu usage of the corresponding thread.

regards,
Mario
Btw I didn't see your earlier question, since I joined the 
list a few days ago, please send it to me if you want a more 
specific answer (or correct me if I'm wrong)



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Foelz.Frank
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Changed execution plans..

Yes, be we recomputed statistics afterwards...

RF

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Monday, January 20, 2003 7:39 AM
To: Multiple recipients of list ORACLE-L


Robert,
 Was imp run with default options? 
 The way it computes stats after table imports, may not be appropriate. 
 
- Kirti 

-Original Message-
Sent: Sunday, January 19, 2003 10:29 PM
To: Multiple recipients of list ORACLE-L


Thanks Cary... I've actually considered most of those already. This isn't my
database, I'm coming in to help someone else. In this case, the database
schema was accidentally dropped, and recovered from an export. I'm wondering
if the import might have created blocks that are packed more densely and
that this might be the cause of the problem. I'm told the parameters are the
same, that the physical structure is the same, they are not using stored
outlines and the SQL has not been changed. No patches have been applied, so
it's apples for apples with the exception of the statistics and, possibly,
the data density. They have some old stored statistics that they generated
pre-schema drop that they are supposed to send me, so I'm going to look at
that tomorrow and run a 10053 trace on one of the changed queries and see
what I can find. I was just wondering if I could be missing something
obvious. Seems like that is just the way, it's the obvious things that
get missed... :-)

Thanks so much for your comments!

RF

-Original Message-
Millsap
Sent: Sunday, January 19, 2003 8:54 PM
To: Multiple recipients of list ORACLE-L


Robert,

Seven reasons I can think of include changes to:

1. Oracle instance parameter values (changes when you edit the
parameters, whether in the stored init.ora way, or via ALTER SYSTEM or
ALTER SESSION commands)
2. Database table and index statistics (changes, e.g., when you run
dbms_stats.gather_database_stats)
3. System CPU and I/O statistics (changes, e.g., when you run
dbms_stats.gather_system_stats)
4. Database schema configuration (changes when you create/drop indexes,
etc.)
5. Stored outlines (changes when you create or reassign outlines)
6. SQL text (changes when you manipulate the application SQL)
7. Oracle query cost model (changes when you upgrade or patch your
Oracle kernel)


Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com

Upcoming events:
- 2003 Hotsos Symposium, Feb 9-12 Dallas
- RMOUG Training Days 2003, Mar 5-6 Denver
- Hotsos Clinic 101, Mar 26-28 London


-Original Message-
Freeman
Sent: Sunday, January 19, 2003 1:24 AM
To: Multiple recipients of list ORACLE-L

Hey Ya'all... (still got my southern roots even up here in Chicago!)

Anyone want to throw in some possible reasons why an execution plan
might
change for a given table queryThis is on Oracle9iR2 on SUN. I've
looked
at the obvious causes:

1. Object has changed - Appears not to have changed.
2. Database parameters have changed - Appears that no parameters have
changed.
3. Statistics (data volumes, distribution, cardinality, etc) have
changed -
Still looking into this, but the volumes have not changed dramatically
even
if they have changed.
4. Other physical database changes.

None of these seem to apply. I've got a database that a few weeks ago
were
doing indexed
lookups using a partitioned index on a partitioned table. Now, it seems
that
these queries
are doing full table scans on this partitioned table. I'm still
gathering up
the details for the items above (e.g how much have the objects changed)
and
I'll probably run a 10053 trace on one of the bad queries to see what
the
optimizer is doing on Monday, but I'd like to just poll for some
additional
ideas. I *AM* getting partition elimination (thank goodness) but I've
got
two FTS on one partition of this table that are just killing it. They
want
to quantify the reason why this access has changed so I'm trying to
think of
what kinds of stuff I can look at to try to do this.

I will add that this table was just rebuilt recently (through
imp/exp)...
can the change in row to block density make the difference h

Any ideas??

RF

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Robert Freeman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Deshpande, Kirti
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message

Re: 100% CPU utilization, urgent


Create the view dba_nt_threads and query it, then run the monitor CPU per
session.  These are not my scripts --- I'm pretty sure that they were
posted here by others --- but I did not capture the information on who
originally wrote them.  My apologies.  HTH

--cr_dba_nt_threads.sql
-- run as sys
create or replace view
 dba_NT_threads
 as
 select
 p.spid ID_THREAD,
 p.background BACKGROUND,
 b.name NAME,
 s.sid SID,
 s.serial# SERIAL#,
 s.username USERNAME,
 s.status STATUS,
 s.osuser OSUSER,
 s.program PROGRAM
 from
 v$process p,
 v$bgprocess b,
 v$session s
 where
 s.paddr = p.addr
 and
 b.paddr(+) = p.addr;
create public synonym dba_nt_threads for dba_nt_threads;
create public synonym threads for dba_nt_threads;


-- monitor CPU per session
-- requires timed statistics on
col sid format 
SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE
FROM V$STATNAME s, V$SESSTAT v
WHERE s.NAME = 'CPU used by this session'
AND v.STATISTIC# = s.STATISTIC#


   

  Hussain Ahmed

  Qadri hussain   To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @skm.org.pk cc: 

  Sent by: rootSubject: 100% CPU utilization, urgent   

   

   

  01/20/2003 12:44 

  AM   

  Please respond   

  to ORACLE-L  

   

   





HI all
We have a consistent problem of CPU utilization 100%. We have had this
problem since Saturday, but it automatically subsided, I mean went back to
normal after a few hours, and remained normal on Sunday as well. But its
back to 100% since morning, that is when the load on the server has gone up
again to 100% and over all work is non-existent.


Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor,
Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7.


I have checked the temporary tablespaces, they are normal.
We have a 24x7 environment, a hospital, so please can you suggest the areas
to look in to, its really very urgent.


Regards,


Hussain








-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle Silent Installs and Response files...

2003-01-20 Thread Brian McGraw

Aha... Proof!

Here is a response file that I use for silent installs of the Oracle 817
client.  It installs the bare essentials that we use here - SQL*Plus,
JDBC Drivers, Net8 essentials, and the OCI layer - onto an individual
PC.

One interesting note:  I could not get the 817 installer to use the
response file correctly.  I believe there is a known bug (internally at
Oracle) stating that it will not work correctly in 8.1.7.  I was lucky
enough to get a great support person at Oracle to work with, and she
helped me figure out that my response file would work, with the 9.0.1
installer.

Enjoy... Feel free to improve on it or point out any errors...

Brian
--
| Brian McGraw /* DBA */  Infinity Insurance |
| mailto:[EMAIL PROTECTED] |
--

#
## ##
##Oracle8i 8.1.7 Appuser Install Response File Template##
## --- ##
## ##
## Copyright(c) Oracle Corporation 2000. All rights reserved.  ##
## ##
## Specify values for the variables listed below to customize  ##
## your installation.  ##
## ##
## Each variable is associated with a comment. The comment ##
## identifies the variable type.   ##
## ##
## Please specify the values in the following format:  ##
## ##
## Type Example##
## String   Sample Value ##
## Boolean  True or False  ##
## Number   1000   ##
## StringList   {String value 1,String Value 2}##
## ##
## The values that are given as Value Required need to be##
## specified for a silent installation to be successful.   ##
## ##
#

[GENERAL]

RESPONSEFILE_VERSION=1.7.0

[SESSION]

#---
--
# Name  : FROM_LOCATION
# Datatype  : String
# Description   : Complete path of the products.jar file from the
staging area
# containing products to install
# Valid values  : Full path ending in products.jar
# Example value : F:\stage\products.jar
# Default value : ..\stage\products.jar
# Mandatory : No
#---
--

FROM_LOCATION=..\..\817client\stage\products.jar

#---
--
# Name  : ORACLE_HOME
# Datatype  : String
# Description   : Full path of directory to use for installing Oracle
# products - the Oracle Home
# Valid values  : Directory path (existent or non-existent)
# Example value : D:\oracle\ora81
# Default value : drive with most available space:\oracle\ora81 OR
  last created ORACLE_HOME
# Mandatory : Yes
#---
--

ORACLE_HOME=c:\oracle\ora817

#---
--
# Name  : ORACLE_HOME_NAME
# Datatype  : String
# Description   : Identification of an Oracle Home.  Used in creating
# folders, services, icons.
# Valid values  : Name that begins with a letter and has no spaces
# Example value : OraHome81
# Mandatory : Yes
#---
--

ORACLE_HOME_NAME=ora817

#---
--
# Name  : TOPLEVEL_COMPONENT
# Datatype  : StringList
# Description   : Top-level product and version to install
  The format is of the form {Internal name,
version}
# Note  : DO NOT CHANGE THE DEFAULT VALUE.
# To install different top-level products, use one of
the
# other response file templates
# Mandatory : Yes
#---
--

TOPLEVEL_COMPONENT={oracle.client,8.1.7.0.0}

#---
--
# Name  : SHOW_SPLASH_SCREEN
# Datatype  : Boolean
# Description   : Set to true to show the initial splash screen of the
# installer
# Valid values  :

RE: Need an Oracle Check List

2003-01-20 Thread DENNIS WILLIAMS

Ken - Be sure to ask for the system password ;-)
Congratulations on the position. If I'm recalling correctly from your
previous posts, this is VERY welcome. The best suggestion is one I used
myself. At some point you'll sit down and go over the systems. That will
take about 30-minutes to 1 hour. You probably won't understand but a small
portion of the statements because it will all be new to you. Take a small
cassette recorder and record (with permission) the discussions of the
systems you will be taking over. Then that night play the tape back and type
up the conversation word-for-word. Then go over the transcript and make a
list of questions for the departing DBA. Then the next day ask about any
points that weren't clear when you reviewed the tape. In previous positions,
everything would seem clear at the time but the next day I would be pretty
hazy on the details. I used a tape recorder on my last job changeover and
didn't miss a thing.
 
Some other questions
1. Which people are most critical to my success in this position?
2. What issues are the most important?
3. What issues regularly arise which impact the quality of the systems?
4. What areas do I need to learn more?



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Sunday, January 19, 2003 9:04 PM
To: Multiple recipients of list ORACLE-L


It appears that I will be taking over an Oracle production DBA position in
about a week from another DBA.  I would like suggestions as to specifically
I should be looking for from this person.  Something like a check list.
Items that I need to specifically look at.
 
Thanks,
Ken Janusz, CPIM

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: [Replication] Altering Master Object at materialized view replication environment

2003-01-20 Thread Dennis Sorokin

Hello! 

 That's one of the nuances of MV replication. If you alter the  master
table,
 you have to drop and recreate the MV on the snapshot site. This is as
per Oracle's internal documentation.

:-(

 However, there is a trick. If you have created the MV using a prebuilt
 table, then you can have a workaround. 

[ ... ]

 Of course, there are several small but crucial steps to be followed. I
have
 described the procedure completely in
http://www.dbazine.com/nanda2.html .
 Hope this helps.

Thank you, it works. 
But it's reasonable only if a table size is huge ... or channel capacity
is small :-), so complete refresh becoms very expensive operation ... 

/sds

PS: About   http://www.dbazine.com/nanda2.html , imho, something wrong
in this sentence:
The table has two columns, COL1 NUMBER (9) and COL2 CHAR(1000), COL3
CHAR(900) ... 8-)




-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Dennis Sorokin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Changed execution plans..

Robert,

Just thought I'd ask, since it hasn't been mentioned in the thread
previously, but...

...has query performance worsened or improved, or is any change
unnoticeable?  What is the before- and after-readings for elapsed time?

After all, if the rows are packed more densely into the blocks, then
perhaps an FTS is not such a bad plan...

Also, don't forget that the import may have changed the physical order of
the rows in the table, so now the clustering factor of the various indexes
may have changed enough to the point where the CBO (correctly!) decided that
using the index for a RANGE SCAN may not be optimal.  Since CLUFAC is judged
on a scale between the DBA_TABLES.BLOCKS and DBA_TABLES.NUM_ROWS, even a
CLUFAC which hasn't changed much (due to the table being reimported with
rows in the same physical order) would still be greatly affected by a change
in DBA_TABLES.BLOCKS...

Thanks!

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, January 19, 2003 9:28 PM


 Thanks Cary... I've actually considered most of those already. This isn't
my
 database, I'm coming in to help someone else. In this case, the database
 schema was accidentally dropped, and recovered from an export. I'm
wondering
 if the import might have created blocks that are packed more densely and
 that this might be the cause of the problem. I'm told the parameters are
the
 same, that the physical structure is the same, they are not using stored
 outlines and the SQL has not been changed. No patches have been applied,
so
 it's apples for apples with the exception of the statistics and, possibly,
 the data density. They have some old stored statistics that they generated
 pre-schema drop that they are supposed to send me, so I'm going to look at
 that tomorrow and run a 10053 trace on one of the changed queries and see
 what I can find. I was just wondering if I could be missing something
 obvious. Seems like that is just the way, it's the obvious things that
 get missed... :-)

 Thanks so much for your comments!

 RF

 -Original Message-
 Millsap
 Sent: Sunday, January 19, 2003 8:54 PM
 To: Multiple recipients of list ORACLE-L


 Robert,

 Seven reasons I can think of include changes to:

 1. Oracle instance parameter values (changes when you edit the
 parameters, whether in the stored init.ora way, or via ALTER SYSTEM or
 ALTER SESSION commands)
 2. Database table and index statistics (changes, e.g., when you run
 dbms_stats.gather_database_stats)
 3. System CPU and I/O statistics (changes, e.g., when you run
 dbms_stats.gather_system_stats)
 4. Database schema configuration (changes when you create/drop indexes,
 etc.)
 5. Stored outlines (changes when you create or reassign outlines)
 6. SQL text (changes when you manipulate the application SQL)
 7. Oracle query cost model (changes when you upgrade or patch your
 Oracle kernel)


 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com

 Upcoming events:
 - 2003 Hotsos Symposium, Feb 9-12 Dallas
 - RMOUG Training Days 2003, Mar 5-6 Denver
 - Hotsos Clinic 101, Mar 26-28 London


 -Original Message-
 Freeman
 Sent: Sunday, January 19, 2003 1:24 AM
 To: Multiple recipients of list ORACLE-L

 Hey Ya'all... (still got my southern roots even up here in Chicago!)

 Anyone want to throw in some possible reasons why an execution plan
 might
 change for a given table queryThis is on Oracle9iR2 on SUN. I've
 looked
 at the obvious causes:

 1. Object has changed - Appears not to have changed.
 2. Database parameters have changed - Appears that no parameters have
 changed.
 3. Statistics (data volumes, distribution, cardinality, etc) have
 changed -
 Still looking into this, but the volumes have not changed dramatically
 even
 if they have changed.
 4. Other physical database changes.

 None of these seem to apply. I've got a database that a few weeks ago
 were
 doing indexed
 lookups using a partitioned index on a partitioned table. Now, it seems
 that
 these queries
 are doing full table scans on this partitioned table. I'm still
 gathering up
 the details for the items above (e.g how much have the objects changed)
 and
 I'll probably run a 10053 trace on one of the bad queries to see what
 the
 optimizer is doing on Monday, but I'd like to just poll for some
 additional
 ideas. I *AM* getting partition elimination (thank goodness) but I've
 got
 two FTS on one partition of this table that are just killing it. They
 want
 to quantify the reason why this access has changed so I'm trying to
 think of
 what kinds of stuff I can look at to try to do this.

 I will add that this table was just rebuilt recently (through
 imp/exp)...
 can the change in row to block density make the difference h

 Any ideas??

 RF

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Robert Freeman
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051

RE: XML with ORACLE

2003-01-20 Thread Harvey Neil

Title: 100% CPU utilization, urgent

The
book "Building Oracle XML Applications" by Steve Muench (published by O'reilly -
ISBN: 1565926919) is an great intro to working
with XML using Oracle.

-Original Message-From:
BanarasiBabu Tippa [mailto:[EMAIL PROTECTED]]Sent: 20
January 2003 08:44To: Multiple recipients of list
ORACLE-LSubject: XML with ORACLE

Hi
gurus

One
of my developerasked me to help in dealing with the database for XML
output.
I
know nothing about XML. Can anyone suggest some beginers documents for XML on
ORACLE.

Banarasi

--
This correspondence is confidential and is solely for the intended recipient(s). If you are not the intended recipient, you must not use, disclose, copy, distribute or retain this message or any part of it. If you are not the intended recipient please delete this correspondence from your system and notify the sender immediately.

No warranty is given that this correspondence is free from any virus. In keeping with good computer practice, you should ensure that it is actually virus free. E-mail messages may be subject to delays, non-delivery and unauthorised alterations therefore, information expressed in this message is not given or endorsed by Sx3 unless otherwise notified by our duly authorised representative independent of this message.

Sx3 is a trading name of Service and Systems Solutions Limited, a limited company registered in Northern Ireland under number NI 32979 whose registered office is at 120, Malone Road, Belfast, BT9 5HT.

Re: 100% CPU utilization, urgent

Title: 100% CPU utilization, urgent



It would be more appropriate to determine whether 
SMON is consuming all the CPU first, before sending someone onsome 
irrelevantwild-goose chase for "fragmented tablespaces".More 
effective to first look for basic facts than to go off chasing after any 
theoriesat this point; you might be right, but if you're wrong than 
a lot of time has been wasted and confusion sown...

---

Since the symptom is CPU usage, thenwe should 
look at some of the information about CPU usage that Oracle stores 
internally. Aquick and dirty starting point would be to query 
V$SESSTAT for the STATISTIC# related to the statistic "CPU used by this 
session", which you can find in V$STATNAME:

  SELECT S.SID, S.PROGRAM, 
  NVL(S.USERNAME, 'SYS'), S.TYPE, T.VALUEFROM 
  V$SESSION S, V$SESSTAT T, V$STATNAME NWHERE N.NAME = 
  'CPU used by this session'AND T.STATISTIC# = 
  N.STATISTIC#AND S.SID = 
  T.SIDORDER BY T.VALUE DESC;

Feel free to post the first 5-10 lines of output 
from this query back as a reply to the list, if you'd like us to help interpret 
it?

---

The very best approach is to take a STATSPACK 
level-5 (default level) reading during the period of 100% utilization and submit 
the resulting "sp_*.lst" file to http://www.oraperf.com for further 
analysis. If SMON is the culprit, then you'll see SQL statements consuming 
tons of time updating the FET$ and UET$ tables in the SYS schema. 
Otherwise, follow the hyperlinks to the "big" percentages to find out what is 
consuming most of the resources, especially CPU...

If you don't have STATSPACK installed, the next 
best thing would be to take a BSTAT/ESTAT report over the same time period when 
CPU is pegged at 100% and (again) submit that to www.oraperf.com to get the full YAPP 
report. However, BSTAT/ESTAT will not provide information about SQL 
statements, so you'll need to find that separately. Best to just install 
STATSPACK; there is plenty of information on MetaLink...

---

Also, Oracle is supposed to supply some utility called "Performance Monitor 
for Windows" which is supposed to be helpful on that platform. I searched 
MetaLink briefly but couldn't find explanatory information; perhaps the 
standard doc-set on "otn.oracle.com" would have something?
Hope this helps...

  - Original Message - 
  From: 
  Nikunj 
  Gupta 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, January 20, 2003 12:38 
  AM
  Subject: Re: 100% CPU utilization, 
  urgent
  
  Check for fragmented tablespaces... There are 
  chances that SMON is active and coalescing tablespaces. 
  
  
- Original Message - 
From: 
Naveen Nahata 
To: Multiple recipients of list ORACLE-L 

Sent: Sunday, January 19, 2003 10:48 
PM
Subject: RE: 100% CPU utilization, 
urgent

Hussain,

We 
have a similar environment and we also hit 100%CPU utilization at times. But 
we never face problem because of tht. the DB keeps working fine during 100% 
CPU utilization also.

Are you having a problem of logging into the DB 
during tht time?

Regards
Naveen

  -Original Message-From: Hussain Ahmed Qadri 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 11:14 
  AMTo: Multiple recipients of list ORACLE-LSubject: 
  100% CPU utilization, urgent
  HI all We have a consistent 
  problem of CPU utilization 100%. We have had this problem since Saturday, 
  but it automatically subsided, I mean went back to normal after a few 
  hours, and remained normal on Sunday as well. But its back to 100% since 
  morning, that is when the load on the server has gone up again to 100% and 
  over all work is non-existent. 
  Our machine is Compaq Proliant ML350, 900 MB ram, 933 
  single Processor, Database size of roughly 5 GB. WINNT4.0, Oracle 
  8.1.7.
  I have checked the temporary tablespaces, they are 
  normal. We have a 24x7 environment, a hospital, so 
  please can you suggest the areas to look in to, its really very 
  urgent. 
  Regards, 
  Hussain 

DISCLAIMER:This message (including attachment if any) is confidential 
and may be privileged. Before opening attachments please check them for 
viruses and defects. MindTree Consulting Private Limited (MindTree) will not 
be responsible for any viruses or defects or any forwarded attachments 
emanating either from within MindTree or outside. If you have received this 
message by mistake please notify the sender by return e-mail and delete this 
message from your system. Any unauthorized use or dissemination of this 
message in whole or in part is strictly prohibited. Please note that e-mails 
are susceptible to change and MindTree shall not be liable for any improper, 
untimely or incomplete transmission.

ORA-2289

2003-01-20 Thread Saira Somani

Hi all,

I'm new at this game and am running into this Oracle error in our
training environment. 

I have searched on the web and the archives but I am not sure about a
resolution to this issue. Any comments/insights would be appreciated.

After investigating the issue, I found that there is a crash when trying
to insert into temporary tables tmp_asn_ship,tmp_asn_ord and other
temporary tables. 

Here are the errors:

biora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_work_item_srl dbiora8x.cpp 05470   Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_work_load_err_srl dbiora8x.cpp 05470   Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_ship_srl dbiora8x.cpp 05470   Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_ord_srl dbiora8x.cpp 05470   Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_tare_srl dbiora8x.cpp 05470   Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_pack_srl dbiora8x.cpp 05470   Error code = 2289.
dbiora8x.cpp 05469 Couldn't execute : drop sequence
tt1462788_tmp_asn_item_srl dbiora8x.cpp 05470   Error code = 2289.

Here is the description of the 2289 error:

// *Cause: The specified sequence does not exist, or the user does
// not have the required privilege to perform this operation.
// *Action: Make sure the sequence name is correct, and that you have
//  the right to perform the desired operation on this sequence.

 CUNAME:cu4
 STATUS:-255
 NATERR:-1
 ERRMSG:
 PRGSQL:INSERT INTO tmp_asn_ship
values(?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,

Saira Somani
IT Support/Analyst
Hospital Logistics Inc.
[EMAIL PROTECTED]
 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Saira Somani
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Changed execution plans..

Oh, and to answer your question directly:

...has query performance worsened or improved, or is any change
 unnoticeable?  What is the before- and after-readings for elapsed time?

I do not have hard facts (old documented response times or execution plans)
to be able to
say for sure. What I do have is are statements that it is slower, much
slower. I do have the old statistics which they will be sending me. All in
all, I felt certain that it was the results of the import and after this
thread I'm feeling more confident about that assessment.

RF


Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Monday, January 20, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


Robert,

Just thought I'd ask, since it hasn't been mentioned in the thread
previously, but...

...has query performance worsened or improved, or is any change
unnoticeable?  What is the before- and after-readings for elapsed time?

After all, if the rows are packed more densely into the blocks, then
perhaps an FTS is not such a bad plan...

Also, don't forget that the import may have changed the physical order of
the rows in the table, so now the clustering factor of the various indexes
may have changed enough to the point where the CBO (correctly!) decided that
using the index for a RANGE SCAN may not be optimal.  Since CLUFAC is judged
on a scale between the DBA_TABLES.BLOCKS and DBA_TABLES.NUM_ROWS, even a
CLUFAC which hasn't changed much (due to the table being reimported with
rows in the same physical order) would still be greatly affected by a change
in DBA_TABLES.BLOCKS...

Thanks!

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, January 19, 2003 9:28 PM


 Thanks Cary... I've actually considered most of those already. This isn't
my
 database, I'm coming in to help someone else. In this case, the database
 schema was accidentally dropped, and recovered from an export. I'm
wondering
 if the import might have created blocks that are packed more densely and
 that this might be the cause of the problem. I'm told the parameters are
the
 same, that the physical structure is the same, they are not using stored
 outlines and the SQL has not been changed. No patches have been applied,
so
 it's apples for apples with the exception of the statistics and, possibly,
 the data density. They have some old stored statistics that they generated
 pre-schema drop that they are supposed to send me, so I'm going to look at
 that tomorrow and run a 10053 trace on one of the changed queries and see
 what I can find. I was just wondering if I could be missing something
 obvious. Seems like that is just the way, it's the obvious things that
 get missed... :-)

 Thanks so much for your comments!

 RF

 -Original Message-
 Millsap
 Sent: Sunday, January 19, 2003 8:54 PM
 To: Multiple recipients of list ORACLE-L


 Robert,

 Seven reasons I can think of include changes to:

 1. Oracle instance parameter values (changes when you edit the
 parameters, whether in the stored init.ora way, or via ALTER SYSTEM or
 ALTER SESSION commands)
 2. Database table and index statistics (changes, e.g., when you run
 dbms_stats.gather_database_stats)
 3. System CPU and I/O statistics (changes, e.g., when you run
 dbms_stats.gather_system_stats)
 4. Database schema configuration (changes when you create/drop indexes,
 etc.)
 5. Stored outlines (changes when you create or reassign outlines)
 6. SQL text (changes when you manipulate the application SQL)
 7. Oracle query cost model (changes when you upgrade or patch your
 Oracle kernel)


 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com

 Upcoming events:
 - 2003 Hotsos Symposium, Feb 9-12 Dallas
 - RMOUG Training Days 2003, Mar 5-6 Denver
 - Hotsos Clinic 101, Mar 26-28 London


 -Original Message-
 Freeman
 Sent: Sunday, January 19, 2003 1:24 AM
 To: Multiple recipients of list ORACLE-L

 Hey Ya'all... (still got my southern roots even up here in Chicago!)

 Anyone want to throw in some possible reasons why an execution plan
 might
 change for a given table queryThis is on Oracle9iR2 on SUN. I've
 looked
 at the obvious causes:

 1. Object has changed - Appears not to have changed.
 2. Database parameters have changed - Appears that no parameters have
 changed.
 3. Statistics (data volumes, distribution, cardinality, etc) have
 changed -
 Still looking into this, but the volumes have not changed dramatically
 even
 if they have changed.
 4. Other physical database changes.

 None of these seem to apply. I've got a database that a few weeks ago
 were
 doing indexed
 lookups using a partitioned index on a partitioned table. Now, it seems
 that
 these queries
 are doing full table scans on this partitioned table. I'm still
 gathering up
 the

RE: Changed execution plans..

Tim,

Thanks for your thoughts. I'm thinking that the import and the resulting
changes is likely the issue. 

RF

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Monday, January 20, 2003 8:44 AM
To: Multiple recipients of list ORACLE-L


Robert,

Just thought I'd ask, since it hasn't been mentioned in the thread
previously, but...

...has query performance worsened or improved, or is any change
unnoticeable?  What is the before- and after-readings for elapsed time?

After all, if the rows are packed more densely into the blocks, then
perhaps an FTS is not such a bad plan...

Also, don't forget that the import may have changed the physical order of
the rows in the table, so now the clustering factor of the various indexes
may have changed enough to the point where the CBO (correctly!) decided that
using the index for a RANGE SCAN may not be optimal.  Since CLUFAC is judged
on a scale between the DBA_TABLES.BLOCKS and DBA_TABLES.NUM_ROWS, even a
CLUFAC which hasn't changed much (due to the table being reimported with
rows in the same physical order) would still be greatly affected by a change
in DBA_TABLES.BLOCKS...

Thanks!

-Tim

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Sunday, January 19, 2003 9:28 PM


 Thanks Cary... I've actually considered most of those already. This isn't
my
 database, I'm coming in to help someone else. In this case, the database
 schema was accidentally dropped, and recovered from an export. I'm
wondering
 if the import might have created blocks that are packed more densely and
 that this might be the cause of the problem. I'm told the parameters are
the
 same, that the physical structure is the same, they are not using stored
 outlines and the SQL has not been changed. No patches have been applied,
so
 it's apples for apples with the exception of the statistics and, possibly,
 the data density. They have some old stored statistics that they generated
 pre-schema drop that they are supposed to send me, so I'm going to look at
 that tomorrow and run a 10053 trace on one of the changed queries and see
 what I can find. I was just wondering if I could be missing something
 obvious. Seems like that is just the way, it's the obvious things that
 get missed... :-)

 Thanks so much for your comments!

 RF

 -Original Message-
 Millsap
 Sent: Sunday, January 19, 2003 8:54 PM
 To: Multiple recipients of list ORACLE-L


 Robert,

 Seven reasons I can think of include changes to:

 1. Oracle instance parameter values (changes when you edit the
 parameters, whether in the stored init.ora way, or via ALTER SYSTEM or
 ALTER SESSION commands)
 2. Database table and index statistics (changes, e.g., when you run
 dbms_stats.gather_database_stats)
 3. System CPU and I/O statistics (changes, e.g., when you run
 dbms_stats.gather_system_stats)
 4. Database schema configuration (changes when you create/drop indexes,
 etc.)
 5. Stored outlines (changes when you create or reassign outlines)
 6. SQL text (changes when you manipulate the application SQL)
 7. Oracle query cost model (changes when you upgrade or patch your
 Oracle kernel)


 Cary Millsap
 Hotsos Enterprises, Ltd.
 http://www.hotsos.com

 Upcoming events:
 - 2003 Hotsos Symposium, Feb 9-12 Dallas
 - RMOUG Training Days 2003, Mar 5-6 Denver
 - Hotsos Clinic 101, Mar 26-28 London


 -Original Message-
 Freeman
 Sent: Sunday, January 19, 2003 1:24 AM
 To: Multiple recipients of list ORACLE-L

 Hey Ya'all... (still got my southern roots even up here in Chicago!)

 Anyone want to throw in some possible reasons why an execution plan
 might
 change for a given table queryThis is on Oracle9iR2 on SUN. I've
 looked
 at the obvious causes:

 1. Object has changed - Appears not to have changed.
 2. Database parameters have changed - Appears that no parameters have
 changed.
 3. Statistics (data volumes, distribution, cardinality, etc) have
 changed -
 Still looking into this, but the volumes have not changed dramatically
 even
 if they have changed.
 4. Other physical database changes.

 None of these seem to apply. I've got a database that a few weeks ago
 were
 doing indexed
 lookups using a partitioned index on a partitioned table. Now, it seems
 that
 these queries
 are doing full table scans on this partitioned table. I'm still
 gathering up
 the details for the items above (e.g how much have the objects changed)
 and
 I'll probably run a 10053 trace on one of the bad queries to see what
 the
 optimizer is doing on Monday, but I'd like to just poll for some
 additional
 ideas. I *AM* getting partition elimination (thank goodness) but I've
 got
 two FTS on one partition of this table that are just killing it. They
 want
 to quantify the reason why this access has changed so I'm trying to

RE: Oracle 9.2.0.2 performance problem

2003-01-20 Thread Gogala, Mladen

RAID is slower then normal disks. You're doing a full table scan.
Is it file system, raw devices? Get the file response times from 
v$filestat and see what are the disk response times. Turn on the
event 10046 and run tkprof with WAITS=YES and that will give you 
the events that your application is waiting on. Better yet, contact
Cary Milsap from  Hotsos and have him analyze your trace file. That
will give you everything I mentioned above, and with additional
clarifications. The address is http://www.hotsos.com

 -Original Message-
 From: Juan Miranda [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 20, 2003 7:35 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle 9.2.0.2 performance problem
 
 
 
 Hello
 
 We execute the query in the servers, so there is no NET 
 problem (I think).
 The data volume is exact (imported).
 Execution path is the same, full-scan.
 
 This is a very strange problem and is very important for us 
 to solve it.
 Thank´s
 
 This is the plan of the windows db:
 Execution Plan
 --
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=5952 Card=465110 Byt
   es=32557700)
 
10   SORT (GROUP BY) (Cost=5952 Card=465110 Bytes=32557700)
21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=643 Card=465110
Bytes=32557700)
 Statistics
 --
   0  recursive calls
   4  db block gets
6679  consistent gets
   12866  physical reads
   0  redo size
26428556  bytes sent via SQL*Net to client
 3894740  bytes received via SQL*Net from client
   59454  SQL*Net roundtrips to/from client
   0  sorts (memory)
   1  sorts (disk)
  445919  rows processed
 
 
 -Mensaje original-
 De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de chao_ping
 Enviado el: lunes, 20 de enero de 2003 12:19
 Para: Multiple recipients of list ORACLE-L
 Asunto: Re: Oracle 9.2.0.2 performance problem
 
 
 Juan Miranda,
   It seems quite strange,there is little wait 
 event in the statspack report,
 and you execution path should be the same on both platform, 
 right? And is
 the data volumn the same in both platform?And does the time 
 spent on fetch
 the result from server to your client different?Is the speed 
 of your pc to
 linux and hp the same?
 
 
 
 
 
 
 Regards
 zhu chao
 msn:[EMAIL PROTECTED]
 www.happyit.net
 www.cnoug.org(China Oracle User Group)
 
 === 2003-01-20 01:59:00 ,you wrote£º===
 
 Hello
 
 We have an serious performance problem on a DSS db.
 We buy a new HP rp5405 (2x650Mhz, 4GB, ...) with HP UX 11.11
 
 Oracle 9.2.0.2 tooks 30 min doing this query where an  Intel 
 2x1,4 Ghz
 tooks
 9 min only.
 
 We have in the HP losts of buffers(1,5GB), sga(200MB), 
 pga(500MB), fast i/O
 (EMC Clariom CX600)...
 We try lost of parameters, but time is always the same.
 
 Is there some bug in this release - platform ?
 How can I get more data about this problem??
 
 Thanks.
 
 SELECT grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
evpanc,evpgru,evpcli,evppai,evppro,evpume,
to_date(evpano||'-'||evpmes||'-'||'01','-MM-DD') FECHA,
sum(evppca) PPTO
 FROM DW.SUPUESTOS
 GROUP BY grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
evpanc,evpgru,evpcli,evppai,evppro,evpume,
evpano, evpmes
 
 call count   cpuelapsed   disk  querycurrent
 rows
 --- --   -- -- -- 
 --  -
 -
 
 Parse1  0.01   0.00  0  0  0
 0
 Execute  1  0.00   0.00  0  0  0
 0
 Fetch   445920   1748.651708.72   1554   1675 23
 445919
 --- --   -- -- -- 
 --  -
 -
 
 total   445922   1748.661708.72   1554   1675 23
 445919
 
 Misses in library cache during parse: 1
 Optimizer goal: CHOOSE
 Parsing user id: 90 (recursive depth: 1)
 
 
 Execution Plan
 --
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=4481 
 Card=464215 Byt
   es=32495050)
 
10   SORT (GROUP BY) (Cost=4481 Card=464215 Bytes=32495050)
21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=162 
 Card=464215
Bytes=32495050)
 
 Statistics
 --
   0  recursive calls
  31  db block gets
1675  consistent gets
1577  physical reads
   0  redo size
 9012743  bytes sent via SQL*Net to client
  208363  bytes received via SQL*Net from client
   29729  SQL*Net roundtrips to/from client
   0  sorts (memory)
   1  sorts (disk)
  445919  rows processed
 
 = = = = = = = = = = = = = = = = = = = =
 
 
 
 
 --
 Please see the official ORACLE-L FAQ:

RE: Server specifications

2003-01-20 Thread DENNIS WILLIAMS

Hussain - If I understand your situation correctly, you have an operational
system that you feel is inadequate to support the current load, and you wish
to receive some information that will help you prove that it is
inadequate? Is that accurate?
   It doesn't really happen that way. Your current server may be inadequate
for the current load. It may also simply be poorly tuned. I would suggest
you learn how to tune the system first. That way, if you find something,
you'll be a hero and save your organization money.
   I have found the STATSPACK utility that comes with Oracle to be very
good. And you don't have buy anything, just install it. It also reports the
number of transactions. Are you familiar with STATSPACK?


Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]  

-Original Message-
Sent: Monday, January 20, 2003 5:49 AM
To: Multiple recipients of list ORACLE-L



Hi all, 
Can anyone tell me if there is any general guide line or benchmark, which
tells us that for running a certain number of transactions in a specified
time, or for a certain size of DB, the Server Configuration should be like
what? 

And what is the way of finding (through a query or any tool for it) the
number of transactions on a system in a specified time.

I have to convince my management that we need to upgrade our servers and I
need such facts to back me up 
Any help would be appreciated. 

Regards, 

Hussain 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Need an Oracle Check List

My big thing would be backup and recovery and making sure I know how they
are doing it. Everything else you can ferret out over time if need be, but
if that database craters on day 2 and it takes you forever to recover it,
you are just not going to look good to management. 
I've seen a number of different backup strategies, and this includes
application oriented recovery needs as much as anything.

IMHO, backup and recovery is job #1 for a DBA. Everything else is secondary.

MO, YMMV

RF

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!



-Original Message-
Sent: Monday, January 20, 2003 8:50 AM
To: Multiple recipients of list ORACLE-L


Ken - Be sure to ask for the system password ;-)
Congratulations on the position. If I'm recalling correctly from your
previous posts, this is VERY welcome. The best suggestion is one I used
myself. At some point you'll sit down and go over the systems. That will
take about 30-minutes to 1 hour. You probably won't understand but a small
portion of the statements because it will all be new to you. Take a small
cassette recorder and record (with permission) the discussions of the
systems you will be taking over. Then that night play the tape back and type
up the conversation word-for-word. Then go over the transcript and make a
list of questions for the departing DBA. Then the next day ask about any
points that weren't clear when you reviewed the tape. In previous positions,
everything would seem clear at the time but the next day I would be pretty
hazy on the details. I used a tape recorder on my last job changeover and
didn't miss a thing.
 
Some other questions
1. Which people are most critical to my success in this position?
2. What issues are the most important?
3. What issues regularly arise which impact the quality of the systems?
4. What areas do I need to learn more?



Dennis Williams 
DBA, 40%OCP 
Lifetouch, Inc. 
[EMAIL PROTECTED] 

-Original Message-
Sent: Sunday, January 19, 2003 9:04 PM
To: Multiple recipients of list ORACLE-L


It appears that I will be taking over an Oracle production DBA position in
about a week from another DBA.  I would like suggestions as to specifically
I should be looking for from this person.  Something like a check list.
Items that I need to specifically look at.
 
Thanks,
Ken Janusz, CPIM

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: DENNIS WILLIAMS
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle SPID vs. NT PIDs (was :100% CPU utilization, urgent)

Frank,

Your query shows the Thread_id of the oracle foreground thread of the oracle.exe 
running on your database server.
The 'program' column shows the program name of the client program used on the client 
machine
v$session.process would (will) show the NTprocess_id:thread_id pair of the client 
program (on the client machine if running c/s) or if the client runs on unix, just the 
process_id of the client program.
example:

   SID PROGRAM  PROCESS
--  -
12 [EMAIL PROTECTED] (TNS V1-V3)615736
...
21 sqlplus.exe  780:1068

The (sid=21) sqlplus.exe is an NT version, the sid=12 sqlplus runs on the unix server. 
Both are connected to a unix server, but the process column does show the NT pid:tid 
combination, as it does on an NT machine, as I showed in my last mail.
This is 'pstat' output on my NT client:
pid:30c pri: 8 Hnd:  113 Pf:   1724 Ws:   6796K sqlplus.exe
 tid pri Ctx Swtch StrtAddrUser Time  Kernel Time  State
 42c   8   484 77E99264  0:00:00.110  0:00:00.360 Wait:LpcReply
 6c0   8 4 77E83775  0:00:00.000  0:00:00.000 Wait:UserRequest
 5d4   8 2 77E83775  0:00:00.000  0:00:00.000 Wait:DelayExecution

Where pid=30c, tid=42c matches the above v$session.process column.

I hope this clears it up.

regards,
Mario Broodbakker



-Original Message-
Sent: maandag 20 januari 2003 14:50
To: Multiple recipients of list ORACLE-L


Mario 

so how comes, that I am not able to find the corresponding SPID to my
NT-processes ???

I tried the following statement :


#
select
 substr(a.spid,1,5) pid,
 substr(b.sid,1,5) sid,
 substr(b.serial#,1,5) ser#,
 machine box,
 substr(b.username,1,10) username,
 -- b.server,
 substr(b.osuser,1,8) os_user,
 substr(b.program,1,30) program
 from v$session b, v$process a
 where
 b.paddr = a.addr
 and type='USER'
 order by spid;

## and I got :

PID   SID   SER#  BOX USERNAME
OS_USER  PROGRAM   
- - - --- --
 -
00111 5810121 networkname xx
xxx  C:\myexe.exe


###
(beware of wordwrap here)

If find the process myexe.exe on networkname in the taskmanager. It's PID is
: 478 (HEX 1DE). The database is on a separate server in the network.

None of the processes, running on the client could pointed to a SPID on the
server. ???


 Frank   


-Ursprüngliche Nachricht-
Von: Broodbakker, Mario [mailto:[EMAIL PROTECTED]]
Gesendet am: Montag, 20. Januar 2003 13:59
An: Multiple recipients of list ORACLE-L
Betreff: RE: 100% CPU utilization, urgent

Frank,

I'm pretty sure they do:

SQL select spid,program from v$process;

SPID  PROGRAM
- --
  PSEUDO
892   ORACLE.EXE
896   ORACLE.EXE
1044  ORACLE.EXE
528   ORACLE.EXE
616   ORACLE.EXE
792   ORACLE.EXE
300   ORACLE.EXE

From Pstat:

pid:6a8 pri: 8 Hnd:  206 Pf:  43673 Ws:  17828K oracle.exe
 tid pri Ctx Swtch StrtAddrUser Time  Kernel Time  State
 424   8   937 77E99264  0:00:00.020  0:00:01.281 Wait:Executive
 690   851 77E83775  0:00:00.000  0:00:00.020 Wait:UserRequest
 6f8   8 2 77E83775  0:00:00.000  0:00:00.000 Wait:UserRequest
 510   9 7 77E83775  0:00:00.000  0:00:00.000 Wait:UserRequest
 558   8 4 77E83775  0:00:00.000  0:00:00.010 
Wait:DelayExecution
 450   971 77E83775  0:00:00.000  0:00:00.000 Wait:EventPairLow
 37c   8  8158 77E83775  0:00:00.220  0:00:00.861 Wait:UserRequest
 380   8   926 77E83775  0:00:00.020  0:00:00.090 Wait:UserRequest
 414   8  1040 77E83775  0:00:00.010  0:00:00.270 Wait:UserRequest
 210   9  1837 77E83775  0:00:00.040  0:00:00.080 Wait:UserRequest
 268   8   237 77E83775  0:00:00.420  0:00:00.150 Wait:UserRequest
 318   965 77E83775  0:00:00.010  0:00:00.040 Wait:UserRequest
 12c   9  6347 77E83775  0:02:30.826  0:00:00.821 Wait:UserRequest

The last tid (12c hex) equals to 300: that's my thread after 
running Jonathans world famous kill_cpu script.
You can checkout (after converting to dec) a few of the others too.
This was the case on NT4 and I just showed this on W2K
In perfmon you can find the thread_id in the Thread Object 
(don't confuse it with the perfmon's object_id!), and off 
course the cpu usage of the corresponding thread.

regards,
Mario
Btw I didn't see your earlier question, since I joined the 
list a few

RE: 100% CPU utilization, urgent

Title: RE: 100% CPU utilization, urgent





Thanks for the script, I would like to know how would I interpret the VALUES column, I mean what does it stand for. If the value of CPU used for a particular SID is 2000, what does that mean? Is it the time, in 1/100 th of seconds of the total CPU time? Can you please help me understand this?

Thanks and regards


Hussain


-Original Message-
From: Thomas Day [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 7:00 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: 100% CPU utilization, urgent



Create the view dba_nt_threads and query it, then run the monitor CPU per
session. These are not my scripts --- I'm pretty sure that they were
posted here by others --- but I did not capture the information on who
originally wrote them. My apologies. HTH


--cr_dba_nt_threads.sql
-- run as sys
create or replace view
dba_NT_threads
as
select
p.spid ID_THREAD,
p.background BACKGROUND,
b.name NAME,
s.sid SID,
s.serial# SERIAL#,
s.username USERNAME,
s.status STATUS,
s.osuser OSUSER,
s.program PROGRAM
from
v$process p,
v$bgprocess b,
v$session s
where
s.paddr = p.addr
and
b.paddr(+) = p.addr;
create public synonym dba_nt_threads for dba_nt_threads;
create public synonym threads for dba_nt_threads;



-- monitor CPU per session
-- requires timed statistics on
col sid format 
SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE
FROM V$STATNAME s, V$SESSTAT v
WHERE s.NAME = 'CPU used by this session'
AND v.STATISTIC# = s.STATISTIC#



 

 Hussain Ahmed 

 Qadri hussain To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 

 @skm.org.pk cc: 

 Sent by: root urgent 

 

 

 01/20/2003 12:44 

 AM 

 Please respond 

 to ORACLE-L 

 

 




HI all
We have a consistent problem of CPU utilization 100%. We have had this
problem since Saturday, but it automatically subsided, I mean went back to
normal after a few hours, and remained normal on Sunday as well. But its
back to 100% since morning, that is when the load on the server has gone up
again to 100% and over all work is non-existent.



Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor,
Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7.



I have checked the temporary tablespaces, they are normal.
We have a 24x7 environment, a hospital, so please can you suggest the areas
to look in to, its really very urgent.



Regards,



Hussain









--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re: [Replication] Altering Master Object at materialized view replication environment

Dennis,

I am glad that it worked for you. Of course, it's useful if the table size
is big. In case of a small table, you would just drop and recreate the
snapshot.

Thanks for pointing out the typo.

Regards,

Arup

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 9:44 AM
replication environment


 Hello!

  That's one of the nuances of MV replication. If you alter the  master
 table,
  you have to drop and recreate the MV on the snapshot site. This is as
 per Oracle's internal documentation.

 :-(

  However, there is a trick. If you have created the MV using a prebuilt
  table, then you can have a workaround.

 [ ... ]

  Of course, there are several small but crucial steps to be followed. I
 have
  described the procedure completely in
 http://www.dbazine.com/nanda2.html .
  Hope this helps.

 Thank you, it works.
 But it's reasonable only if a table size is huge ... or channel capacity
 is small :-), so complete refresh becoms very expensive operation ...

 /sds

 PS: About   http://www.dbazine.com/nanda2.html , imho, something wrong
 in this sentence:
 The table has two columns, COL1 NUMBER (9) and COL2 CHAR(1000), COL3
 CHAR(900) ... 8-)




 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Dennis Sorokin
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Book Requested - Advanced SQL and tuning

2003-01-20 Thread Pardee, Roy E

It's not oracle-specific, but Celko's _SQL For Smarties_ is a great book on
advanced SQL.

http://www.amazon.com/exec/obidos/tg/detail/-/1558605762/qid=1043077107/sr=1
-1/ref=sr_1_1/102-5414817-8555301?v=glances=books

(pls watch for line-wrap.)

Cheers,

-Roy

Roy Pardee
Programmer/Analyst
SWFPAC Lockheed Martin IT
Extension 8487

-Original Message-
Sent: Sunday, January 19, 2003 3:49 PM
To: Multiple recipients of list ORACLE-L


Hi All,

A developer I work with has asked if there are any books which cover both
advanced SQL and SQL tuning in the one title.  Does anyone know of such a
book?

Essentially we have several developers here who know the basics of SQL but
want to understand how to write more advanced queries (I guess interesting
use of subqueries, decode functions, and some of the lesser used syntaxes
like intersect and minus).  They also want to learn some basic performance
tuning concepts - I guess learning about implicit conversion, the use of
hints, and what indexes can and can't be used to achieve might be a good
start.

Any and all suggestions are welcome.  The database can be assumed to be
Oracle (currently 8, perhaps 9 in the next year) since most tuning is
vendor specific.

Thanks,
 Mark.



   Privileged/Confidential information may be contained in this message.
  If you are not the addressee indicated in this message
   (or responsible for delivery of the message to such person),
you may not copy or deliver this message to anyone.
In such case, you should destroy this message and kindly notify the sender
   by reply e-mail or by telephone on (61 3) 9612-6999.
   Please advise immediately if you or your employer does not consent to
Internet e-mail for messages of this kind.
Opinions, conclusions and other information in this message
  that do not relate to the official business of
 Transurban City Link Ltd
 shall be understood as neither given nor endorsed by it.



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark Richard
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Pardee, Roy E
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

SQLplus question unusual behavior

2003-01-20 Thread John Shaw




I am trying to update a small table from a remote table with sqlplus 
9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table - 
howeverthat doesn't really happen.
Am I suffering from a severe lack of caffine oris this really 
odd?

SQL select count(*) from facility;

 
COUNT(*)-- 
0

SQL insert into facility (select * from facility@dev);

233 rows created.

SQL select count(*) from facility;

 
COUNT(*)-- 
0

SQL commit;

Commit complete.

SQL select count(*) from facility;

 
COUNT(*)-- 
0

RE: 100% CPU utilization, urgent

2003-01-20 Thread Koivu, Lisa

Title: RE: 100% CPU utilization, urgent





Thomas, thanks for your post. 


However I don't see where I can match the threads on NT to what I see in Task Manager. Am I missing something? 


To be more explicit, here's what I've got: 


SQL select * from dba_nt_threads;


ID_THREAD B NAME SID SERIAL# USERNAME STATUS OSUSER 
- - - - -- --  
3144 1 PMON 1 1 ACTIVE SYSTEM 
2436 1 DBW0 2 1 ACTIVE SYSTEM 
2972 1 LGWR 3 1 ACTIVE SYSTEM 
3172 1 CKPT 4 1 ACTIVE SYSTEM 
2976 1 SMON 5 1 ACTIVE SYSTEM 
3380 1 RECO 6 1 ACTIVE SYSTEM 
2840 11 1973 LISA ACTIVE lkoivu2 
900 12 2 DBSNMP INACTIVE SYSTEM 


8 rows selected.


I see no processes in task manager that correspond to any of the numbers listed in ID_THREAD. In fact my sessions script used to reference spid, but I took it out because I couldn't make sense of it on Windows.

Thanks for any insight. 


Lisa Koivu
Oracle Dogbarf Cleanerupper
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063




-Original Message-
From: Thomas Day [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: 100% CPU utilization, urgent




Create the view dba_nt_threads and query it, then run the monitor CPU per
session. These are not my scripts --- I'm pretty sure that they were
posted here by others --- but I did not capture the information on who
originally wrote them. My apologies. HTH


--cr_dba_nt_threads.sql
-- run as sys
create or replace view
dba_NT_threads
as
select
p.spid ID_THREAD,
p.background BACKGROUND,
b.name NAME,
s.sid SID,
s.serial# SERIAL#,
s.username USERNAME,
s.status STATUS,
s.osuser OSUSER,
s.program PROGRAM
from
v$process p,
v$bgprocess b,
v$session s
where
s.paddr = p.addr
and
b.paddr(+) = p.addr;
create public synonym dba_nt_threads for dba_nt_threads;
create public synonym threads for dba_nt_threads;



-- monitor CPU per session
-- requires timed statistics on
col sid format 
SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE
FROM V$STATNAME s, V$SESSTAT v
WHERE s.NAME = 'CPU used by this session'
AND v.STATISTIC# = s.STATISTIC#



 

 Hussain Ahmed 

 Qadri hussain To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 

 @skm.org.pk cc: 

 Sent by: root urgent 

 

 

 01/20/2003 12:44 

 AM 

 Please respond 

 to ORACLE-L 

 

 




HI all
We have a consistent problem of CPU utilization 100%. We have had this
problem since Saturday, but it automatically subsided, I mean went back to
normal after a few hours, and remained normal on Sunday as well. But its
back to 100% since morning, that is when the load on the server has gone up
again to 100% and over all work is non-existent.



Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor,
Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7.



I have checked the temporary tablespaces, they are normal.
We have a 24x7 environment, a hospital, so please can you suggest the areas
to look in to, its really very urgent.



Regards,



Hussain









-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Re: ORA-00955: name is already used by an existing object

2003-01-20 Thread Rachel Carmichael

off the top of my head, although I would expect a different error...
are there any foreign key references to the column?

Any other column  in any other table which has a column whose name
matches for the first 15-20 characters as this one?


--- Krishnaswamy, Ranganath
[EMAIL PROTECTED] wrote:
 I have the following table in Oracle 8.1.7:
 
 Name  Null?Type
 -  --
 DIENSTLEISTUNGSOBJEKTOID   VARCHAR2(23)
 OID   NOT NULL VARCHAR2(23)
 AUMESSWERTEVARCHAR2(23)
 AUART  NUMBER(10)
 BAUJAHRBEGINN  NUMBER(10)
 BAUJAHRENDENUMBER(10)
 BEZUGSNUMMER   NUMBER(10)
 CHECKBOXMANUELLNUMBER(1)
 ENTSPRAUSDRUCK NUMBER(10)
 GETRIEBETYPVARCHAR2(10)
 HERSTELLERTEXT VARCHAR2(18)
 HUBRAUMCCM NUMBER(10)
 HUBRAUMLITER   NUMBER
 LEISTUNGKW NUMBER(10)
 MINDESTOKTANZAHL   NUMBER(10)
 MODELL VARCHAR2(20)
 MODELLJAHR VARCHAR2(11)
 MODELLVARNUMMERNUMBER(10)
 MOTORCODE  VARCHAR2(18)
 SPEZAUSRUESTUNGVARCHAR2(25)
 ZYLINDERZAHL   NUMBER(10)
 CLSTYPE   NOT NULL VARCHAR2(40)
 MESSUNGSARTNUMBER(10)
 ANZAHLTEILSCHAEDEN NUMBER(10)
 BESICHTIGUNGSBEDINGUNGEN   VARCHAR2(23)
 DURCHGEFUEHRTEREPARATUREN  VARCHAR2(23)
 EINGEBAUTENTAUSCHAGGREGATKOPF  VARCHAR2(23)
 ERSATZTEILEVARCHAR2(23)
 FZALLGEMEINZUSTAND VARCHAR2(23)
 GEBRAUCHSSCHADENKOPF   VARCHAR2(23)
 KALKULATIONBETRAEGEVARCHAR2(23)
 LACKAZTVARCHAR2(23)
 LACKMATERIAL   VARCHAR2(23)
 LACKIERUNG VARCHAR2(23)
 LAUFLEISTUNG   VARCHAR2(23)
 LOHNKOSTEN VARCHAR2(23)
 MECHANIK   VARCHAR2(23)
 NACHSCHADENVARCHAR2(23)
 NOTWREPARATURKOSTENINCLMWSTNUMBER(1)
 NOTWENDIGENTAUSCHAGGREGATKOPF  VARCHAR2(23)
 REPARTURWEGVARCHAR2(23)
 SCHADENDATEN   VARCHAR2(23)
 SCHADENBESCHREIBUNGVARCHAR2(23)
 SONSTIGEKALKDATEN  VARCHAR2(23)
 UMBAUKOSTENVARCHAR2(23)
 VERSCHLEISSSCHADENKOPF VARCHAR2(23)
 VORGANGSDATEN  VARCHAR2(23)
 VORSCHAEDENVARCHAR2(23)
 ZUORDNUNG  VARCHAR2(23)
 ZUSTANDVARCHAR2(23)
 MESSWERTHERKUNFT   NUMBER(10)
 MESSWERTLISTAKTIV  NUMBER(1)
 FEHLENDETEILE  VARCHAR2(23)
 BEWERTUNGERGEBNIS  VARCHAR2(23)
 WERTKORREKTURENVARCHAR2(23)
 BEMERKUNG  VARCHAR2(4000)
 NUMMER VARCHAR2(40)
 VORGANGVARCHAR2(40)
 AUDATEXUEBERNEHMEN NUMBER(1)
 BAUMUSTER  VARCHAR2(100)
 HERSTELLER VARCHAR2(100)
 NFZAUSSTATTUNG VARCHAR2(23)
 RADSTAND1  NUMBER(10)
 RADSTAND2  NUMBER(10)
 VERKAUFSBEZEICHNUNGVARCHAR2(100)
 FZALLGEMEINZUSTANDBEMERKUNGCLOB
 FZALLGEMEINZUSTANDCBXCODE  NUMBER(10)
 NICHTMITBEWERTETETEILE CLOB
 EREIGNISCBXVARCHAR2(40)
 FAHRER VARCHAR2(20)
 FAHRERORT

Re: Need an Oracle Check List

2003-01-20 Thread KENNETH JANUSZ

Dennis:

Thanks very much for the suggestions.  They will help me a lot.  I have been
working on the position for about two months now.  It has everything I
want - Oracle DBA, manufacturing, large company, and only 14 miles from my
home.

I will be working for a small IT company but be on-site at their client.  I
should be signing my contract later this week and go to the client site next
Monday to start learning from the departing DBA who is going on to another
project.  The position will be contract-for-hire.

I'll be able to say who it is after I sign my contract.

Ken
Hugo, MN

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 8:49 AM


 Ken - Be sure to ask for the system password ;-)
 Congratulations on the position. If I'm recalling correctly from your
 previous posts, this is VERY welcome. The best suggestion is one I used
 myself. At some point you'll sit down and go over the systems. That will
 take about 30-minutes to 1 hour. You probably won't understand but a small
 portion of the statements because it will all be new to you. Take a small
 cassette recorder and record (with permission) the discussions of the
 systems you will be taking over. Then that night play the tape back and
type
 up the conversation word-for-word. Then go over the transcript and make a
 list of questions for the departing DBA. Then the next day ask about any
 points that weren't clear when you reviewed the tape. In previous
positions,
 everything would seem clear at the time but the next day I would be pretty
 hazy on the details. I used a tape recorder on my last job changeover and
 didn't miss a thing.

 Some other questions
 1. Which people are most critical to my success in this position?
 2. What issues are the most important?
 3. What issues regularly arise which impact the quality of the systems?
 4. What areas do I need to learn more?



 Dennis Williams
 DBA, 40%OCP
 Lifetouch, Inc.
 [EMAIL PROTECTED]

 -Original Message-
 Sent: Sunday, January 19, 2003 9:04 PM
 To: Multiple recipients of list ORACLE-L


 It appears that I will be taking over an Oracle production DBA position in
 about a week from another DBA.  I would like suggestions as to
specifically
 I should be looking for from this person.  Something like a check list.
 Items that I need to specifically look at.

 Thanks,
 Ken Janusz, CPIM

 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: DENNIS WILLIAMS
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).



-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: KENNETH JANUSZ
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Oracle 9.2.0.2 performance problem

Since you spend about all the time consuming CPU and not waiting I doubt wether you 
problem is wait related.
Maybe something changed in the fetch array size? maybe via a sqlplus glogin script? 
(if your using sqlplus, otherwise an array parameter in your app?)
What protocol are you using? You said you ran on the server, but does this mean you 
use a 'BEQ' connection (or an IPC or a TCP?)
What is your STRMSGSZ kernel setting?

regards,
Mario


-Original Message-
Sent: maandag 20 januari 2003 16:25
To: Multiple recipients of list ORACLE-L


RAID is slower then normal disks. You're doing a full table scan.
Is it file system, raw devices? Get the file response times from 
v$filestat and see what are the disk response times. Turn on the
event 10046 and run tkprof with WAITS=YES and that will give you 
the events that your application is waiting on. Better yet, contact
Cary Milsap from  Hotsos and have him analyze your trace file. That
will give you everything I mentioned above, and with additional
clarifications. The address is http://www.hotsos.com

 -Original Message-
 From: Juan Miranda [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 20, 2003 7:35 AM
 To: Multiple recipients of list ORACLE-L
 Subject: RE: Oracle 9.2.0.2 performance problem
 
 
 
 Hello
 
 We execute the query in the servers, so there is no NET 
 problem (I think).
 The data volume is exact (imported).
 Execution path is the same, full-scan.
 
 This is a very strange problem and is very important for us 
 to solve it.
 Thank´s
 
 This is the plan of the windows db:
 Execution Plan
 --
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=5952 Card=465110 Byt
   es=32557700)
 
10   SORT (GROUP BY) (Cost=5952 Card=465110 Bytes=32557700)
21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=643 Card=465110
Bytes=32557700)
 Statistics
 --
   0  recursive calls
   4  db block gets
6679  consistent gets
   12866  physical reads
   0  redo size
26428556  bytes sent via SQL*Net to client
 3894740  bytes received via SQL*Net from client
   59454  SQL*Net roundtrips to/from client
   0  sorts (memory)
   1  sorts (disk)
  445919  rows processed
 
 
 -Mensaje original-
 De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de chao_ping
 Enviado el: lunes, 20 de enero de 2003 12:19
 Para: Multiple recipients of list ORACLE-L
 Asunto: Re: Oracle 9.2.0.2 performance problem
 
 
 Juan Miranda,
   It seems quite strange,there is little wait 
 event in the statspack report,
 and you execution path should be the same on both platform, 
 right? And is
 the data volumn the same in both platform?And does the time 
 spent on fetch
 the result from server to your client different?Is the speed 
 of your pc to
 linux and hp the same?
 
 
 
 
 
 
 Regards
 zhu chao
 msn:[EMAIL PROTECTED]
 www.happyit.net
 www.cnoug.org(China Oracle User Group)
 
 === 2003-01-20 01:59:00 ,you wrote£º===
 
 Hello
 
 We have an serious performance problem on a DSS db.
 We buy a new HP rp5405 (2x650Mhz, 4GB, ...) with HP UX 11.11
 
 Oracle 9.2.0.2 tooks 30 min doing this query where an  Intel 
 2x1,4 Ghz
 tooks
 9 min only.
 
 We have in the HP losts of buffers(1,5GB), sga(200MB), 
 pga(500MB), fast i/O
 (EMC Clariom CX600)...
 We try lost of parameters, but time is always the same.
 
 Is there some bug in this release - platform ?
 How can I get more data about this problem??
 
 Thanks.
 
 SELECT grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
evpanc,evpgru,evpcli,evppai,evppro,evpume,
to_date(evpano||'-'||evpmes||'-'||'01','-MM-DD') FECHA,
sum(evppca) PPTO
 FROM DW.SUPUESTOS
 GROUP BY grupo,evpamb,evpdel,evpfor,evppr2,evppr3,evppr4,
evpanc,evpgru,evpcli,evppai,evppro,evpume,
evpano, evpmes
 
 call count   cpuelapsed   disk  querycurrent
 rows
 --- --   -- -- -- 
 --  -
 -
 
 Parse1  0.01   0.00  0  0  0
 0
 Execute  1  0.00   0.00  0  0  0
 0
 Fetch   445920   1748.651708.72   1554   1675 23
 445919
 --- --   -- -- -- 
 --  -
 -
 
 total   445922   1748.661708.72   1554   1675 23
 445919
 
 Misses in library cache during parse: 1
 Optimizer goal: CHOOSE
 Parsing user id: 90 (recursive depth: 1)
 
 
 Execution Plan
 --
0  SELECT STATEMENT Optimizer=CHOOSE (Cost=4481 
 Card=464215 Byt
   es=32495050)
 
10   SORT (GROUP BY) (Cost=4481 Card=464215 Bytes=32495050)
21 TABLE ACCESS (FULL) OF 'SUPUESTOS' (Cost=162 
 Card=464215

RE: 100% CPU utilization, urgent

2003-01-20 Thread Jeff Herrick



On Mon, 20 Jan 2003, Koivu, Lisa wrote:

 Thomas, thanks for your post.

 However I don't see where I can match the threads on NT to what I see in
 Task Manager.  Am I missing something?

 To be more explicit, here's what I've got:


Lisa,

The point you're missing is that Task Manager shows _processes_ and
the view is showing _threads_ . They're 2 distinct constructs.  In its
simplest sense a thread is an independently executing 'thread of
execution' from a main task. This is how you see one process for
ORACLE.EXE and its running multiple threads (PMON, SMON etc)
if you look at the process using a tool such as PVIEW or PSTAT.

Processes are spawned using the CreateProcess() API call and a process
then spins off multiple threads using another call such as
AfxBeginThread() (in C++). The threads all operate independently
of each other and the programmer must be careful when accessing
common areas of memory simultaneously by different threads. This is
why in a Dr. Watson dump you will see what each thread is doing
and one or more of them will usually be running WaitForSingleObject()
which is a WIN32 way of serializing access to shared _process_
memory.

Contrast this to the multi-process architecture that Oracle uses
on Unix. The shared memory stuctures are separate from each
individual _process_ and the processes use semaphores or
latches to serialize access to the external memory segment.

HTH

Jeff Herrick

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeff Herrick
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 100% CPU utilization, urgent

2003-01-20 Thread Koivu, Lisa

Title: RE: 100% CPU utilization, urgent





Thanks Rick. I knew there was something missing here. And if I'm not mistaken, it's my brain. I'll dig into it and see what I can learn with the brain cells I have left. 

Have a great afternoon.


Lisa


-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 11:42 AM
To: [EMAIL PROTECTED]; [EMAIL PROTECTED]
Subject: RE: 100% CPU utilization, urgent




Lisa,


To get info at the thread level and determine what thread within a process
is consuming the most CPU you have to use something like
performance monitor or Process Viewer.


Using Performance monitor you want to choose THREAD from the performance
object drop-down and choose ID Thread from the counter list..
In the instance list box you will see a separate line for each oracle
thread showing the instance # of the thread. You can choose any/all of the
threads
and then choose ADD. The value now in the performance monitor will show you
the actual thread ID that you can match to the SPID column
in V$PROCESS.


For ex.
SELECT s.*
FROM v$session s, v$process p
where p.spid='spid_in_perf_mon'
and p.addr=s.paddr;


Rick




 
 Koivu, Lisa 
 Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] 
 field.com cc: 
 Sent by: Subject: RE: 100% CPU utilization, urgent 
 [EMAIL PROTECTED] 
 
 
 01/20/2003 10:36 
 AM 
 Please respond to 
 ORACLE-L 
 
 





Thomas, thanks for your post.



However I don't see where I can match the threads on NT to what I see in
Task Manager. Am I missing something?



To be more explicit, here's what I've got:



SQL select * from dba_nt_threads;



ID_THREAD B NAME SID SERIAL# USERNAME
STATUS OSUSER
- - - - -- --
 
3144 1 PMON 1 1
ACTIVE SYSTEM
2436 1 DBW0 2 1
ACTIVE SYSTEM
2972 1 LGWR 3 1
ACTIVE SYSTEM
3172 1 CKPT 4 1
ACTIVE SYSTEM
2976 1 SMON 5 1
ACTIVE SYSTEM
3380 1 RECO 6 1
ACTIVE SYSTEM
2840 11 1973 LISA
ACTIVE lkoivu2
900 12 2 DBSNMP
INACTIVE SYSTEM



8 rows selected.



I see no processes in task manager that correspond to any of the numbers
listed in ID_THREAD. In fact my sessions script used to reference spid,
but I took it out because I couldn't make sense of it on Windows.



Thanks for any insight.



Lisa Koivu
Oracle Dogbarf Cleanerupper
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA 33063







-Original Message-
From: Thomas Day [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L
Subject: Re: 100% CPU utilization, urgent







Create the view dba_nt_threads and query it, then run the monitor CPU per
session. These are not my scripts --- I'm pretty sure that they were
posted here by others --- but I did not capture the information on who
originally wrote them. My apologies. HTH



--cr_dba_nt_threads.sql
-- run as sys
create or replace view
dba_NT_threads
as
select
p.spid ID_THREAD,
p.background BACKGROUND,
b.name NAME,
s.sid SID,
s.serial# SERIAL#,
s.username USERNAME,
s.status STATUS,
s.osuser OSUSER,
s.program PROGRAM
from
v$process p,
v$bgprocess b,
v$session s
where
s.paddr = p.addr
and
b.paddr(+) = p.addr;
create public synonym dba_nt_threads for dba_nt_threads;
create public synonym threads for dba_nt_threads;






-- monitor CPU per session
-- requires timed statistics on
col sid format 
SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE
FROM V$STATNAME s, V$SESSTAT v
WHERE s.NAME = 'CPU used by this session'
AND v.STATISTIC# = s.STATISTIC#








 Hussain Ahmed



 Qadri hussain To: Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]



 @skm.org.pk cc:



 Sent by: root urgent







 01/20/2003 12:44



 AM



 Please respond



 to ORACLE-L












HI all
We have a consistent problem of CPU utilization 100%. We have had this
problem since Saturday, but it automatically subsided, I mean went back to
normal after a few hours, and remained normal on Sunday as well. But its
back to 100% since morning, that is when the load on the server has gone up


again to 100% and over all work is non-existent.






Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor,
Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7.






I have checked the temporary tablespaces, they are normal.
We have a 24x7 environment, a hospital, so please can you suggest the areas


to look in to, its really very urgent.






Regards,






Hussain












--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
 INET: [EMAIL PROTECTED]



Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a

RE: 100% CPU utilization, urgent

2003-01-20 Thread Rick_Cale


Lisa,

To get info at the thread level and determine what thread within a process
is consuming the most CPU you have to use something like
performance monitor or Process Viewer.

Using Performance monitor you want to choose THREAD from the performance
object drop-down and choose ID Thread from the counter list..
In the instance list box you will see a separate line for each oracle
thread showing the instance # of the thread. You can choose any/all of the
threads
and then choose ADD. The value now in the performance monitor will show you
the actual thread ID that you can match to the SPID column
in V$PROCESS.

For ex.
SELECT s.*
FROM v$session s, v$process p
where p.spid='spid_in_perf_mon'
and p.addr=s.paddr;

Rick



   
  
Koivu, Lisa  
  
Lisa.Koivu@efair   To: Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]  
field.com  cc:
  
Sent by:Subject: RE: 100% CPU utilization, 
urgent
[EMAIL PROTECTED]   
  
   
  
   
  
01/20/2003 10:36   
  
AM 
  
Please respond to  
  
ORACLE-L   
  
   
  
   
  




Thomas, thanks for your post.


However I don't see where I can match the threads on NT to what I see in
Task Manager.  Am I missing something?


To be more explicit, here's what I've got:


SQL select * from dba_nt_threads;


ID_THREAD B NAMESIDSERIAL# USERNAME
STATUS   OSUSER
- - - - -- --
 
3144  1 PMON  1  1
ACTIVE   SYSTEM
2436  1 DBW0  2  1
ACTIVE   SYSTEM
2972  1 LGWR  3  1
ACTIVE   SYSTEM
3172  1 CKPT  4  1
ACTIVE   SYSTEM
2976  1 SMON  5  1
ACTIVE   SYSTEM
3380  1 RECO  6  1
ACTIVE   SYSTEM
2840 11   1973 LISA
ACTIVE   lkoivu2
900  12  2 DBSNMP
INACTIVE SYSTEM


8 rows selected.


I see no processes in task manager that correspond to any of the numbers
listed in ID_THREAD.  In fact my sessions script used to reference spid,
but I took it out because I couldn't make sense of it on Windows.


Thanks for any insight.


Lisa Koivu
Oracle Dogbarf Cleanerupper
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063






-Original Message-
Sent: Monday, January 20, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L






Create the view dba_nt_threads and query it, then run the monitor CPU per
session.  These are not my scripts --- I'm pretty sure that they were
posted here by others --- but I did not capture the information on who
originally wrote them.  My apologies.  HTH


--cr_dba_nt_threads.sql
-- run as sys
create or replace view
 dba_NT_threads
 as
 select
 p.spid ID_THREAD,
 p.background BACKGROUND,
 b.name NAME,
 s.sid SID,
 s.serial# SERIAL#,
 s.username USERNAME,
 s.status STATUS,
 s.osuser OSUSER,
 s.program PROGRAM
 from
 v$process p,
 v$bgprocess b,
 v$session s
 where
 s.paddr = p.addr
 and
 b.paddr(+) = p.addr;
create public synonym dba_nt_threads for dba_nt_threads;
create public synonym threads for dba_nt_threads;





-- monitor CPU per session
-- requires timed statistics on
col sid format 
SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE
FROM V$STATNAME s, V$SESSTAT v
WHERE s.NAME = 'CPU used by this session'
AND v.STATISTIC# = s.STATISTIC#







  Hussain Ahmed


  Qadri hussain   To:  Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]


  @skm.org.pk cc:


  Sent by: rooturgent






  01/20/2003 12:44


  AM

Americas Cup

2003-01-20 Thread Fowler, Kenneth R

Larry Ellison has spent 95 million (US) attempting to become the challenger
to Team New Zealand for the Americas Cup.  Unfortunately did not make the
grade...

http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html

Ken
_
Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346
Email: mailto:[EMAIL PROTECTED]



LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. 
It is intended for the addressee(s) only. Access to this E-mail by anyone else is 
unauthorized. If you are not an addressee, any disclosure or copying of the contents 
of this E-mail or any action taken (or not taken) in reliance on it is unauthorized 
and may be unlawful. If you are not an addressee, please inform the sender immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Fowler, Kenneth R
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: 100% CPU utilization, urgent

Title: RE: 100% CPU utilization, urgent

We seem to have switched emailthreads, but
the value from the VALUE column in the query onV$SESSTAT is centiseconds
of CPU consumed by the session. Although V$SESSTAT is not updated
continuously (but rather in "spurts"), you should see a clear trend in which
session is consuming the most CPU.

Whichever session is doing it, I would suggest
enabling SQL Trace (a.k.a. "the big hammer") on the session and running TKPROF
SORT=PRSELA,EXEELA,FCHELA against the raw ".trc" file produced...

...or use STATSPACK..or both...

- Original Message -
From:
Hussain Ahmed
Qadri
To: Multiple recipients of list ORACLE-L

Sent: Monday, January 20, 2003 8:24
AM
Subject: RE: 100% CPU utilization,
urgent

Thanks for the script, I would like to know how would I
interpret the VALUES column, I mean what does it stand for. If the value of
CPU used for a particular SID is 2000, what does that mean? Is it the time, in
1/100 th of seconds of the total CPU time? Can you please help me understand
this?
Thanks and regards
Hussain
-Original Message- From:
Thomas Day [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 7:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: 100% CPU utilization, urgent
Create the view dba_nt_threads and query it, then run the
monitor CPU per session. These are not my
scripts --- I'm pretty sure that they were posted here
by others --- but I did not capture the information on who originally wrote them. My apologies. HTH
--cr_dba_nt_threads.sql -- run as
sys create or replace view dba_NT_threads as select p.spid "ID_THREAD",
p.background "BACKGROUND", b.name "NAME", s.sid "SID",
s.serial# "SERIAL#", s.username "USERNAME", s.status
"STATUS", s.osuser "OSUSER", s.program "PROGRAM" from
v$process p, v$bgprocess
b, v$session s where s.paddr = p.addr
and b.paddr(+) =
p.addr; create public synonym dba_nt_threads for
dba_nt_threads; create public synonym threads for
dba_nt_threads;
-- monitor CPU per session -- requires
timed statistics on col sid format
SELECT v.SID, SUBSTR(s.NAME,1,30) "Statistic", v.VALUE
FROM V$STATNAME s, V$SESSTAT v WHERE
s.NAME = 'CPU used by this session' AND v.STATISTIC# =
s.STATISTIC#

Hussain
Ahmed

Qadri hussain
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]

@skm.org.pk
cc:

Sent by:
root
urgent

01/20/2003
12:44

Please
respond

to
ORACLE-L

HI all We have a consistent problem of
CPU utilization 100%. We have had this problem since
Saturday, but it automatically subsided, I mean went back to normal after a few hours, and remained normal on Sunday as well. But
its back to 100% since morning, that is when the load
on the server has gone up again to 100% and over all
work is non-existent.
Our machine is Compaq Proliant ML350, 900 MB ram, 933 single
Processor, Database size of roughly 5 GB. WINNT4.0,
Oracle 8.1.7.
I have checked the temporary tablespaces, they are
normal. We have a 24x7 environment, a hospital, so
please can you suggest the areas to look in to, its
really very urgent.
Regards,
Hussain
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: Thomas Day INET:
[EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

RE: Need an Oracle Check List

2003-01-20 Thread DENNIS WILLIAMS

Ken - 14 miles, you dawg! I'm jealous. Here I am humping 30 miles across the
major metro area. Seriously, learn as much as you can from the departing
person, because even if you have access to that DBA in the future, it is
amazing how fast they can forget details.

Robert - I think you have excellent points about learning everything about
their backup and recovery procedures. That reminds me that a good question
would be to ask about their test recovery and the procedure they used. :-)

Ken - Here is an audit form I've prepared to investigate various aspects of
a database. It may be help you ask more questions. If you use it and any
improvements occur to you, be sure to pass them along.

Oracle Database Audit


Server: __  Instance Name: __   Date:
_
Test / Production

Backup / Recovery Audit
Archive: Y/Nshow parameter log_archive_start
Control file placement: number ___ separate devices Y/N select * from
v$controlfile;  
Date of last backup controlfile to trace: show parameter user_dump_dest
Log file: size  number _ groups _ separate devices Y/N select *
from v$logfile, v$log;
Backup: schedule  RMAN Y/N RMAN validation commands
Exports: schedule  location: Date of last export,
 errors in log? Y/N
Temp tablespace: select username, temporary_tablespace from dba_users;  Are
any system? Y/N
Default tablespace: select username, default_tablespace from dba_users; Are
any system? Y/N
Usernames owning tables: __ select distinct owner from
dba_tables;
LogMiner: show parameter utl_file_dir ___


Security Audit
DBA privilege   select grantee from dba_role_privs where
granted_role = 'DBA';
Default passwords
List of schemas, responsible person, # of processes (activity)
select username, count(*) from v$session group by username;

Performance Audit
When are the critical performance times for this database?
___
Attach STATSPACK report from a peak time.
TIMED_STATISTICS = true/false   show parameter timed_statistics
Table statistics are stored:  for future diagnosis in case
CBO chooses new plans.

Shared Pool
What is the block size? __ show parameter db_block_size;
What is the shared pool size? show parameter shared_pool_size;
What is the library-cache hit ratio? __ goal 99%+ (from STATSPACK
report, first page)
What is the dictionary hit ratio? ___ goal 99%+ (from STATSPACK,
Dictionary Cache Stats)
What is the JAVA_POOL_SIZE? _
What is the LARGE_POOL_SIZE? _

Buffer Cache
What is the BHR? __ (from STATSPACK report, first page)
What is db_block_buffers? __ (from STATSPACK report, first page)
Keep pool: show parameter buffer_pool_keep 
Recycle pool: show parameter buffer_pool_recycle ___
What are the hit ratios for all buffer pools? V$BUFFER_POOL_STATISTICS.
Statistics for increasing buffers - 8i V$RECENT_BUCKET, 9i V$DB_CACHE_ADVICE
Which tables and indexes are assigned to KEEP, RECYCLE? 
select owner, table_name, buffer_pool from dba_tables; dba_indexes;
What are the sum  of blocks of the objects assigned to the KEEP pool? As a %
of KEEP pool size?
select sum(blocks) from dba_tables where buffer_pool = 'KEEP';
Number of LRU_LATCHES? ___ show parameter db_block_lru_latches;

Redo Log Buffer
What is the log buffer size? ___ show parameter log_buffer;
At what time interval are log switches occuring?  goal: 20min.
Look for log buffer space% in v$session_wait
In v$sysstat, look for redo buffer allocation retries, redo log space
requests
Are there waits for the redo allocation latch?

File I/O
Are all temporary tablespaces correctly defined? 
select tablespace_name, file_name, autoextensible from dba_temp_files;
select tablespace_name, maxextents from dba_tablespaces order by
tablespace_name;
List objects in SYSTEM tablespace that are not owned by SYS:
select segment_name, segment_type, owner from dba_segments where owner 
'SYS' and tablespace_name = 'SYSTEM';
Do DATA tablespaces contain only tables?
select segment_name, segment_type, owner, tablespace_name from dba_segments
where tablespace_name like '%DATA%' and segment_type  'TABLE'
Do INDEX tablespaces contain only indexes?
select segment_name, segment_type, owner, tablespace_name from dba_segments
where tablespace_name like '%INDEX%' and segment_type  'INDEX'
Do ROLLBACK tablespaces contain only rollback segments?
select segment_name, segment_type, owner, tablespace_name from dba_segments
where tablespace_name like '%RBS%' and segment_type  'ROLLBACK';
I/O conflicts - priorities
1. Are redo logs on separate devices from any other tablespaces? select
member from v$logfile;
2. Are rollback tablespace datafiles on separate devices from any other
tablespaces?
3. Are DATA and INDEX tablespace datafiles on separate devices from SYSTEM
tablespaces?
4. Are DATA and INDEX

RE: 100% CPU utilization, urgent


If you run the second script you will get the CPU utilization (whatever
that means) per SID.  In your case SIDs 1-6 are the ones that you're
interested in.  The NT Task Manager will only show you ORACLE.EXE.  It
doesn't show the embedded threads.



   

  Koivu, Lisa

  Lisa.Koivu  To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @efairfield.com cc: 

  Sent by: rootSubject: RE: 100% CPU utilization, 
urgent   
   

   

  01/20/2003 10:36 

  AM   

  Please respond   

  to ORACLE-L  

   

   





Thomas, thanks for your post.


However I don't see where I can match the threads on NT to what I see in
Task Manager.  Am I missing something?


To be more explicit, here's what I've got:


SQL select * from dba_nt_threads;


ID_THREAD B NAMESIDSERIAL# USERNAME
STATUS   OSUSER
- - - - -- --
 
3144  1 PMON  1  1
ACTIVE   SYSTEM
2436  1 DBW0  2  1
ACTIVE   SYSTEM
2972  1 LGWR  3  1
ACTIVE   SYSTEM
3172  1 CKPT  4  1
ACTIVE   SYSTEM
2976  1 SMON  5  1
ACTIVE   SYSTEM
3380  1 RECO  6  1
ACTIVE   SYSTEM
2840 11   1973 LISA
ACTIVE   lkoivu2
900  12  2 DBSNMP
INACTIVE SYSTEM


8 rows selected.


I see no processes in task manager that correspond to any of the numbers
listed in ID_THREAD.  In fact my sessions script used to reference spid,
but I took it out because I couldn't make sense of it on Windows.


Thanks for any insight.


Lisa Koivu
Oracle Dogbarf Cleanerupper
Fairfield Resorts, Inc.
5259 Coconut Creek Parkway
Ft. Lauderdale, FL, USA  33063






-Original Message-
Sent: Monday, January 20, 2003 9:00 AM
To: Multiple recipients of list ORACLE-L






Create the view dba_nt_threads and query it, then run the monitor CPU per
session.  These are not my scripts --- I'm pretty sure that they were
posted here by others --- but I did not capture the information on who
originally wrote them.  My apologies.  HTH


--cr_dba_nt_threads.sql
-- run as sys
create or replace view
 dba_NT_threads
 as
 select
 p.spid ID_THREAD,
 p.background BACKGROUND,
 b.name NAME,
 s.sid SID,
 s.serial# SERIAL#,
 s.username USERNAME,
 s.status STATUS,
 s.osuser OSUSER,
 s.program PROGRAM
 from
 v$process p,
 v$bgprocess b,
 v$session s
 where
 s.paddr = p.addr
 and
 b.paddr(+) = p.addr;
create public synonym dba_nt_threads for dba_nt_threads;
create public synonym threads for dba_nt_threads;





-- monitor CPU per session
-- requires timed statistics on
col sid format 
SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE
FROM V$STATNAME s, V$SESSTAT v
WHERE s.NAME = 'CPU used by this session'
AND v.STATISTIC# = s.STATISTIC#







  Hussain Ahmed


  Qadri hussain   To:  Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]


  @skm.org.pk cc:


  Sent by: rooturgent






  01/20/2003 12:44


  AM


  Please respond


  to ORACLE-L











HI all
We have a consistent problem of CPU utilization 100%. We have had this
problem since Saturday, but it automatically subsided, I mean went back to
normal after a few hours, and remained normal on Sunday as well. But its
back to 100% since

RE: quest shareplex

2003-01-20 Thread Martin, Alan

Title: RE: quest shareplex





Has anyone used Oracle Streams for simple A to B replication? Likes/dislikes? Can it be used in 8.1.7?


Thanx,
Alan Martin
Defense Logistics Information Service
[EMAIL PROTECTED]


-Original Message-
From: Khedr, Waleed [mailto:[EMAIL PROTECTED]]
Sent: Friday, January 17, 2003 5:55 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: quest shareplex



I'm sure you know Oracle has a new product Oracle Streams that does the
same:


http://technet.oracle.com/docs/products/oracle9i/doc_library/release2/server
.920/a96571/strmover.htm#43906


Waleed


-Original Message-
Sent: Friday, January 17, 2003 11:14 AM
To: Multiple recipients of list ORACLE-L



I'm working with a couple of IBM gals(don't you all get offended) who 
are asking about shareplex, i've not used it and have no idea whether 
its good or not(or for that matter what its purpose is).



Anyone enlighten me.


thanks, joe



Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Khedr, Waleed
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

can't remove advance queuing

2003-01-20 Thread Mark O'Loughlin

Hello All,

I'm having problems with a oracle 8.7.1 database running on SuSE 7.1.  My
original problem was unable to drop a user, searching through the archive
I found the problem described at
http://www.orafaq.net/archive/oracle-l/2002/03/01/144826.htm

This was the exact problem, the trace file was reporting a fail with error
942 and 604 when executing the command:
select name from system.aq$_queue_tables where schema=:1;

The solution was to run catnoque.sql and then catqueue.sql as the sys
user, this will recreate the AQ tables.  This is where things fail:

When i run the catnoque.sql it gets as far as drop package dbms_aq; and
just seems to sit there, looking at top oracle's cpu usuage is minimal
(0.3% CPU 1.9%) so it doesn't seem to be doing anything. The last thing i
get in the trace log is:

=
PARSING IN CURSOR #5 len=33 dep=1 uid=0 oct=7 lid=0 tim=0 hv=3605072212
ad='512e1c0c'
delete from source$ where obj#=:1
END OF STMT
PARSE #5:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=0
BINDS #5:
 bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24
offset=0
   bfp=0958d010 bln=22 avl=03 flg=05
   value=2451


Anyone know what is going on?


Regards
Mark
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Mark O'Loughlin
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 100% CPU utilization, urgent


I don't know off hand.  Why does it matter?  Aren't you interested in
finding out which thread is responsible for most of your CPU utilization?
This will give you relative values.  What their absolute meaning is is
unimportant, isn't it?



   

  Hussain Ahmed

  Qadri hussain   To:  Multiple recipients of list 
ORACLE-L [EMAIL PROTECTED]
  @skm.org.pk cc: 

  Sent by: rootSubject: RE: 100% CPU utilization, 
urgent   
   

   

  01/20/2003 10:24 

  AM   

  Please respond   

  to ORACLE-L  

   

   





Thanks for the script, I would like to know how would I interpret the
VALUES column, I mean what does it stand for. If the value of CPU used for
a particular SID is 2000, what does that mean? Is it the time, in 1/100 th
of seconds of the total CPU time? Can you please help me understand this?


Thanks and regards


Hussain


-Original Message-
Sent: Monday, January 20, 2003 7:00 PM
To: Multiple recipients of list ORACLE-L





Create the view dba_nt_threads and query it, then run the monitor CPU per
session.  These are not my scripts --- I'm pretty sure that they were
posted here by others --- but I did not capture the information on who
originally wrote them.  My apologies.  HTH


--cr_dba_nt_threads.sql
-- run as sys
create or replace view
 dba_NT_threads
 as
 select
 p.spid ID_THREAD,
 p.background BACKGROUND,
 b.name NAME,
 s.sid SID,
 s.serial# SERIAL#,
 s.username USERNAME,
 s.status STATUS,
 s.osuser OSUSER,
 s.program PROGRAM
 from
 v$process p,
 v$bgprocess b,
 v$session s
 where
 s.paddr = p.addr
 and
 b.paddr(+) = p.addr;
create public synonym dba_nt_threads for dba_nt_threads;
create public synonym threads for dba_nt_threads;





-- monitor CPU per session
-- requires timed statistics on
col sid format 
SELECT v.SID, SUBSTR(s.NAME,1,30) Statistic, v.VALUE
FROM V$STATNAME s, V$SESSTAT v
WHERE s.NAME = 'CPU used by this session'
AND v.STATISTIC# = s.STATISTIC#







  Hussain Ahmed


  Qadri hussain   To:  Multiple recipients
of list ORACLE-L [EMAIL PROTECTED]


  @skm.org.pk cc:


  Sent by: rooturgent






  01/20/2003 12:44


  AM


  Please respond


  to ORACLE-L











HI all
We have a consistent problem of CPU utilization 100%. We have had this
problem since Saturday, but it automatically subsided, I mean went back to
normal after a few hours, and remained normal on Sunday as well. But its
back to 100% since morning, that is when the load on the server has gone up

again to 100% and over all work is non-existent.





Our machine is Compaq Proliant ML350, 900 MB ram, 933 single Processor,
Database size of roughly 5 GB. WINNT4.0, Oracle 8.1.7.





I have checked the temporary tablespaces, they are normal.
We have a 24x7 environment, a hospital, so please can you suggest the areas

to look in to, its really very urgent.





Regards,





Hussain











--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Thomas Day
  INET: [EMAIL PROTECTED]


Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru')

Re: 100% CPU utilization, urgent


Does this help?

select
  p.spid ID_THREAD
, p.background BACKGROUND
, b.name NAME
, s.sid SID
, s.serial# SERIAL#
, NVL(S.USERNAME, 'SYS') USERNAME
, s.status STATUS
, s.osuser OSUSER
, s.program PROGRAM
, S.TYPE
, T.VALUE CPU
from sys.v_$process p
, sys.v_$bgprocess b
, sys.v_$session s
, V$SESSTAT T,
  V$STATNAME N
where N.NAME = 'CPU used by this session'
and s.paddr = p.addr
and b.paddr(+) = p.addr
AND T.STATISTIC# = N.STATISTIC#
AND S.SID = T.SID
order by s.sid
/


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Thomas Day
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Americas Cup

2003-01-20 Thread Orr, Steve

Title: RE: Americas Cup





Yeah and my Oracle stock is down 6% so there's obviously a significant connection between company performance and extravagant CEO recreational obsessions. 


-Original Message-
From: Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Americas Cup


Larry Ellison has spent 95 million (US) attempting to become the challenger
to Team New Zealand for the Americas Cup. Unfortunately did not make the
grade...


http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html


Ken

RE: Americas Cup

2003-01-20 Thread Wong, Bing

That $95mill should be the profit sharing for Oracler employees...  What a
waste!

-Original Message-
Sent: Monday, January 20, 2003 9:09 AM
To: Multiple recipients of list ORACLE-L


Larry Ellison has spent 95 million (US) attempting to become the challenger
to Team New Zealand for the Americas Cup.  Unfortunately did not make the
grade...

http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html

Ken
_
Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346
Email: mailto:[EMAIL PROTECTED]



LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be
privileged. It is intended for the addressee(s) only. Access to this E-mail
by anyone else is unauthorized. If you are not an addressee, any disclosure
or copying of the contents of this E-mail or any action taken (or not taken)
in reliance on it is unauthorized and may be unlawful. If you are not an
addressee, please inform the sender immediately.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Fowler, Kenneth R
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Wong, Bing
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: slowish query causing problems...

2003-01-20 Thread Mohammed Shakir

How about trying rule based optimizer as a test. It should use indexes
if they exist.

Cost based optimizer may not use index if it finds cost of using full
scan is less than cost of using indexes. This is possible if a table
has few rows say less than 1000 rows. Index may not be used if
selectivity is low, that is, Oracle has to bring in more than say 7% of
the rows from the table.

--- Denham Eva [EMAIL PROTECTED] wrote:
 Hello,
  
 Thanks for the replies
 Here is the description of the table and the indexes, pls remember I
 have
 removed and tested each index seperately, still insisted on a Full
 search. 9
 indexes is not my idea of a perfect situation these are created by
 the
 developers ( another company) so politics plays a big roll here.
  
 CREATE TABLE FWEPCODE1 ( 
   RECORDID  INTEGER   NOT NULL, 
   FUNC  VARCHAR2 (20), 
   WOTYPEVARCHAR2 (20), 
   EXP   VARCHAR2 (20), 
   PIK   VARCHAR2 (20), 
   FUNCDESC  VARCHAR2 (80), 
   EXPDESC   VARCHAR2 (80), 
   PIKDESC   VARCHAR2 (80), 
   EX1   VARCHAR2 (1), 
   EX2   VARCHAR2 (10), 
   EX3   VARCHAR2 (10), 
   EX4   VARCHAR2 (10), 
   EX5   VARCHAR2 (10), 
   EX6   VARCHAR2 (10), 
   EX7   VARCHAR2 (10), 
   EX8   VARCHAR2 (10), 
   EX9   VARCHAR2 (10), 
   EX10  VARCHAR2 (10) ) ; 
  
  FWEPCODE1_NDX1 ON FWEPCODE1(FUNC, WOTYPE, EXP, PIK);
  FWEPCODE1_NDX2 ON FWEPCODE1(FUNC); 
  FWEPCODE1_NDX3 ON FWEPCODE1(EXP); 
  FWEPCODE1_NDX4 ON FWEPCODE1(FUNC, WOTYPE); 
  FWEPCODE1_NDX5 ON FWEPCODE1(FUNC, EX2); 
  FWEPCODE1_NDX6 ON FWEPCODE1(EXPDESC); 
  FWEPCODE1_NDX7 ON FWEPCODE1(FUNC, WOTYPE, PIK); 
  FWEPCODE1_NDX8 ON FWEPCODE1(RECORDID); 
  FWEPCODE1_NDX9 ON FWEPCODE1(WOTYPE, FUNC, EXP); 
  
 I have added a CSV file as an attachment as requested by one lister
 of the
 plan_table.
  
 Once again appreciation for all the help.
 Regards
 Denham
 
 -Original Message-
 Sent: Tuesday, January 14, 2003 3:24 PM
 To: Multiple recipients of list ORACLE-L
 
 
 Eva,
  
 Is there an index on the fwepcode1 table with the three columns used
 in the
 where clause?  Are the three columns varchar or varchar2?  Make sure
 the EXP
 column is not a number!
  
 Secondly, I think I would change the query as follows:
  
  
 SELECT DISTINCT (1) 
FROM fwepcode1 
   WHERE (wotype = 'TST' AND func = 'C0NEPRF' AND EXP =
 '2') 
  OR not exists(select 1 FROM valuelist 
  WHERE listname = 'STATUS' 
AND MAXVALUE = 'A'
AND VALUE='INPRG' ) 
 
  
 
 Tom Mercadante 
 Oracle Certified Professional 
 
 -Original Message-
 Sent: Tuesday, January 14, 2003 6:29 AM
 To: Multiple recipients of list ORACLE-L
 
 
 
 Hello List, 
 
 Pls help me on this problem. Our application does a validation when
 it uses
 a certain screen, as it so happens this screen is used very
 intensively. The
 performance is very slow, I have isolated the main culprit. I have
 tried the
 following.
 
 I have dropped all the indexes and tried recreating them
 individually. Each
 time I have run an explain plan on the query, the optimizer (both
 rule and
 Choose) have chosen to do a FULL table scan on the fwepcode table.
 Even when
 using a hint to explicitly use the index it still uses FULL.
 
 This is very frustrating indeed. 
 
 SELECT DISTINCT (1) 
FROM fwepcode1 
   WHERE (wotype = 'TST' AND func = 'C0NEPRF' AND EXP =
 '2') 
  OR 'INPRG' NOT IN (SELECT VALUE 
   FROM valuelist 
  WHERE listname = 'STATUS' 
AND MAXVALUE = 'A') 
 
 Is the reason that the optimizer does not use any of the indexes
 because of
 the SELECT DISTINCT (1)? 
 I have tried adjusting this query slightly to remove this and it
 still
 insists on doing a full table scan. 
 Funny enough the sub query on valuelist table does use a index. 
 The table contains 8920 rows. The cost according to the explain plan
 is 703
 and bytes 9834. 
 
 The system is a Oracle 817 on Win2k. 
 
 Pls advise, any options or help will be appreciated. 
 Many Thanks 
 Denham Eva 
 Oracle DBA 
 UNIX is basically a simple operating system, but you have to be a
 genius to
 understand the simplicity. 
 Dennis Ritchie. 
 
 
 
   _  
 
 DISCLAIMER 
 
 
 
 This message is for the named person's use only. It may contain
 confidential, proprietary or legally privileged information. No
 confidentiality or privilege is waived or lost by any
 mistransmission. If
 you receive this message in error, please immediately delete it and
 all
 copies of it from your system, destroy any hard copies of it and
 notify the
 sender. You must not, directly or indirectly, use, disclose,
 distribute,
 print, or copy any part of this message if you are not the intended
 recipient. TFMC, its holding company, and any of its subsidiaries
 each
 reserve

Re: SQLplus question unusual behavior

2003-01-20 Thread babu . nagarajan


Just a thought - is facility a table or is it some synonym/view pointing
somewhere else..


Babu



|-+---
| |   John Shaw   |
| |   John.Shaw@correctio|
| |   nscorp.com |
| |   Sent by:|
| |   [EMAIL PROTECTED]|
| |   |
| |   |
| |   01/20/03 10:30 AM   |
| |   Please respond to   |
| |   ORACLE-L|
| |   |
|-+---
  
---|
  |
   |
  |   To:   Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
   |
  |   cc:  
   |
  |   Subject:  SQLplus question unusual behavior  
   |
  
---|




I am trying to update a small table from a remote table with sqlplus
9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table -
however that doesn't really happen.
Am I suffering from a severe lack of caffine or is this really odd?

SQL select count(*) from facility;

  COUNT(*)
--
 0

SQL insert into facility (select * from facility@dev);

233 rows created.

SQL select count(*) from facility;

  COUNT(*)
--
 0

SQL commit;

Commit complete.

SQL select count(*) from facility;

  COUNT(*)
--
 0


_
This e-mail transmission and any attachments to it are intended solely for
the use of the individual or entity to whom it is addressed and may contain
confidential and privileged information.  If you are not the intended
recipient, your use, forwarding, printing, storing, disseminating,
distribution, or copying of this communication is prohibited.  If you
received this communication in error, please notify the sender immediately
by replying to this message and delete it from your computer.


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: 100% CPU utilization, urgent

2003-01-20 Thread Koivu, Lisa

Title: RE: 100% CPU utilization, urgent





Thanks Jeff for your detailed explanation.


(Can I please have Unix back now???!)


Have a great day. 
Lisa


-Original Message-
From: Jeff Herrick [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 11:40 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: 100% CPU utilization, urgent





On Mon, 20 Jan 2003, Koivu, Lisa wrote:


 Thomas, thanks for your post.

 However I don't see where I can match the threads on NT to what I see in
 Task Manager. Am I missing something?

 To be more explicit, here's what I've got:



Lisa,


The point you're missing is that Task Manager shows _processes_ and
the view is showing _threads_ . They're 2 distinct constructs. In its
simplest sense a thread is an independently executing 'thread of
execution' from a main task. This is how you see one process for
ORACLE.EXE and its running multiple threads (PMON, SMON etc)
if you look at the process using a tool such as PVIEW or PSTAT.


Processes are spawned using the CreateProcess() API call and a process
then spins off multiple threads using another call such as
AfxBeginThread() (in C++). The threads all operate independently
of each other and the programmer must be careful when accessing
common areas of memory simultaneously by different threads. This is
why in a Dr. Watson dump you will see what each thread is doing
and one or more of them will usually be running WaitForSingleObject()
which is a WIN32 way of serializing access to shared _process_
memory.


Contrast this to the multi-process architecture that Oracle uses
on Unix. The shared memory stuctures are separate from each
individual _process_ and the processes use semaphores or
latches to serialize access to the external memory segment.


HTH


Jeff Herrick


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Jeff Herrick
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

Recall: Oracle 9.2.0.2 performance problem

Broodbakker, Mario would like to recall the message, Oracle 9.2.0.2 performance 
problem.
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Broodbakker, Mario
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQLplus question unusual behavior

Check if there are two taables named FACILTY in your database.

As SYS, check

SELECT OWNER, Object_name, Object_type
FROM DBA_OBJECTS
WHERE UPPER(OBJECT_NAME) = 'FACILITY'

Note the use of upper(). Someone might have defined the table in lowercase 
using quotes.

CREATE TABLE FACILITY is not the same as CREATE TABLE facility.

HTH.

Arup

From: John Shaw [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: SQLplus question unusual behavior
Date: Mon, 20 Jan 2003 07:30:45 -0800
MIME-Version: 1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by 
mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 Jan 
2003 08:01:55 -0800
Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com 
(8.9.3/8.9.3) with UUCP id IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST)
Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; 
Mon, 20 Jan 2003 07:30:45 -0800
Message-ID: [EMAIL PROTECTED]
X-Comment: Oracle RDBMS Community Forum
X-Sender: John Shaw [EMAIL PROTECTED]
Sender: [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization: Fat City Network Services, San Diego, California
X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence: bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 20 Jan 2003 16:01:55.0073 (UTC) 
FILETIME=[40E1BF10:01C2C09D]

I am trying to update a small table from a remote table with sqlplus 
9.2.0.2 .
It seems to indicate that it has inserted 233 row into my local table - 
however that doesn't really happen.
Am I suffering from a severe lack of caffine or is this really odd?

SQL select count(*) from facility;

  COUNT(*)
--
 0

SQL insert into facility (select * from facility@dev);

233 rows created.

SQL select count(*) from facility;

  COUNT(*)
--
 0

SQL commit;

Commit complete.

SQL select count(*) from facility;

  COUNT(*)
--
 0


_
STOP MORE SPAM with the new MSN 8 and get 2 months FREE* 
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup Nanda
 INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Americas Cup

2003-01-20 Thread Igor Neyman

Title: RE: Americas Cup



are you saying that if Larry wins, Oracle stock would go up ? 
-:)

Igor Neyman, OCP DBA[EMAIL PROTECTED] 



  - Original Message - 
  From: 
  Orr, Steve 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, January 20, 2003 1:04 
  PM
  Subject: RE: Americas Cup
  
  Yeah and my Oracle stock is down 6% so there's obviously a 
  significant connection between company performance and extravagant CEO 
  recreational obsessions. 
  -Original Message- From: 
  Fowler, Kenneth R [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup 
  Larry Ellison has spent 95 million (US) attempting to become 
  the challenger to Team New Zealand for the Americas 
  Cup. Unfortunately did not make the grade... 
  http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00 
  .html 
  Ken

Re: SQLplus question unusual behavior

2003-01-20 Thread John Shaw



It's a 
table. [EMAIL PROTECTED] 01/20/03 11:04AM 
Just a thought - is facility a table or is it some 
synonym/view pointingsomewhere 
else..Babu|-+---| 
| John 
Shaw 
|| 
| 
John.Shaw@correctio|| 
| 
nscorp.com 
|| 
| Sent 
by: 
|| 
| 
[EMAIL PROTECTED] 
|| 
| 
|| 
| 
|| 
| 01/20/03 10:30 
AM || 
| Please respond 
to || 
| 
ORACLE-L 
|| 
| 
||-+--- 
---| 
| 
| | 
To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED] 
| | 
cc: 
| | Subject: SQLplus 
question unusual 
behavior 
| 
---|I 
am trying to update a small table from a remote table with sqlplus9.2.0.2 
.It seems to indicate that it has inserted 233 row into my local table 
-however that doesn't really happen.Am I suffering from a severe lack of 
caffine or is this really odd?SQL select count(*) from 
facility; 
COUNT(*)-- 
0SQL insert into facility (select * from facility@dev);233 
rows created.SQL select count(*) from facility; 
COUNT(*)-- 
0SQL commit;Commit complete.SQL select count(*) 
from facility; 
COUNT(*)-- 
0_This e-mail transmission and any attachments to it 
are intended solely forthe use of the individual or entity to whom it is 
addressed and may containconfidential and privileged information. If 
you are not the intendedrecipient, your use, forwarding, printing, storing, 
disseminating,distribution, or copying of this communication is 
prohibited. If youreceived this communication in error, please notify 
the sender immediatelyby replying to this message and delete it from your 
computer.-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: 
 INET: [EMAIL PROTECTED]Fat City Network 
Services -- 858-538-5051 http://www.fatcity.comSan Diego, 
California -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

RE: Americas Cup

2003-01-20 Thread Weaver, Walt

Title: RE: Americas Cup





Well, I guess now he can use the boat for target practice when he's flying around in his fighter jet...


--Walt Weaver
 Bozeman, Montana


-Original Message-
From: Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM
To: Multiple recipients of list ORACLE-L
Subject: Americas Cup



Larry Ellison has spent 95 million (US) attempting to become the challenger
to Team New Zealand for the Americas Cup. Unfortunately did not make the
grade...


http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html


Ken
_
Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346
Email: mailto:[EMAIL PROTECTED]




LEGAL NOTICE
Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this E-mail by anyone else is unauthorized. If you are not an addressee, any disclosure or copying of the contents of this E-mail or any action taken (or not taken) in reliance on it is unauthorized and may be unlawful. If you are not an addressee, please inform the sender immediately.

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Fowler, Kenneth R
 INET: [EMAIL PROTECTED]


Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).

10053 trace in 9i

I'm looking at the results of a 10053 trace from 9i.
I'm not finding any real documentation for the following parameters in the 
base table access cost section:

tb_sel
rsc_cpu
rsc_io
ix_sel

I believe that these all combine somehow to define a cost for a specific
index
access but I'm not sure how to calculate this cost. I think this is new for
9i, can someone shed some light on these?

RF

Robert G. Freeman 
Technical Management Consultant
TUSC - The Oracle Experts www.tusc.com
904.708.5076 Cell (it's everywhere that I am!)
Author of several books you can find on Amazon.com!


-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Freeman Robert - IL
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Americas Cup

2003-01-20 Thread KENNETH JANUSZ

Title: RE: Americas Cup



Was this Oracle money or Larry's private funds?

Ken Janusz, CPIM

  - Original Message - 
  From: 
  Orr, Steve 
  
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Monday, January 20, 2003 12:04 
  PM
  Subject: RE: Americas Cup
  
  Yeah and my Oracle stock is down 6% so there's obviously a 
  significant connection between company performance and extravagant CEO 
  recreational obsessions. 
  -Original Message- From: 
  Fowler, Kenneth R [mailto:[EMAIL PROTECTED]] 
  Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup 
  Larry Ellison has spent 95 million (US) attempting to become 
  the challenger to Team New Zealand for the Americas 
  Cup. Unfortunately did not make the grade... 
  http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00 
  .html 
  Ken

Re: Recall: Oracle 9.2.0.2 performance problem

2003-01-20 Thread Joseph S Testa

Mario, no can do, its already been deleted.

joe


 Broodbakker, Mario would like to recall the message, Oracle 9.2.0.2 
performance problem.
 -- 
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 -- 
 Author: Broodbakker, Mario
   INET: [EMAIL PROTECTED]
 
 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).
 
 

Joseph S Testa
Chief Technology Officer
Data Management Consulting
p: 614-791-9000
f: 614-791-9001
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Joseph S Testa
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Americas Cup

2003-01-20 Thread Gogala, Mladen

Title: RE: Americas Cup

Well,
Larry Ellison allegedly has MiG 25 which is an interceptor
airplane
armed
to blow other airplanes out of the sky. It doesn't have any
weapon
system
to sink a ship. He should purchase few F-16 and A-10 planes.

Those
can be used against ships. Speaking of the race, allegedly those GPS

navigation systems they use in the modern yachts are
running SQL Server.
Larry
couldn't have won with a software like that.

-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 1:05
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Americas Cup
Well, I guess now he can use the boat for target practice when
he's flying around in his fighter jet...
--Walt Weaver Bozeman,
Montana
-Original Message- From:
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup
Larry Ellison has spent 95 million (US) attempting to become
the challenger to Team New Zealand for the Americas
Cup. Unfortunately did not make the grade...
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html
Ken _ Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services Tel: (860) 732-0026 Fax: (860) 715-8346 Email:
mailto:[EMAIL PROTECTED]

LEGAL NOTICE Unless expressly stated
otherwise, this message is confidential and may be privileged. It is intended
for the addressee(s) only. Access to this E-mail by anyone else is
unauthorized. If you are not an addressee, any disclosure or copying of the
contents of this E-mail or any action taken (or not taken) in reliance on it
is unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately.
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net --
Author: Fowler, Kenneth R INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego,
California -- Mailing list and web
hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT spelling
of 'ListGuru') and in the message BODY, include a line
containing: UNSUB ORACLE-L (or the name of mailing
list you want to be removed from). You may also
send the HELP command for other information (like subscribing).

RE: Americas Cup

2003-01-20 Thread Orr, Steve

Title: RE: Americas Cup



Well 
he almost DIED the last time he did this so it ISan improvement. 


  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 11:49 
  AMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Americas Cup
  are you saying that if Larry wins, Oracle stock would go up 
  ? -:)
  
  Igor Neyman, OCP DBA[EMAIL PROTECTED] 
  
  
  
  
- Original Message - 
From: 
Orr, Steve 

To: Multiple recipients of list ORACLE-L 

Sent: Monday, January 20, 2003 1:04 
PM
Subject: RE: Americas Cup

Yeah and my Oracle stock is down 6% so there's obviously a 
significant connection between company performance and extravagant CEO 
recreational obsessions. 
-Original Message- From: 
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup 
Larry Ellison has spent 95 million (US) attempting to become 
the challenger to Team New Zealand for the Americas 
Cup. Unfortunately did not make the grade... 
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00 
.html 
Ken

Has anyone ever seen ORA-11928 ???

2003-01-20 Thread James Howerton

DBA's

We are getting an intermittent ORA-11928 in conjunction with ORA-2063
and ORA-4088 during a batch load that runs every 5 minutes. (See below)
It only happens once every few days and at different times. When we
re-run the transaction it loads correctly. 

I also get ORA-11928 in an OEM alert on another database from time to
time. The log shows: new connection cannot be established. ora-11928:
Message 11928 not found;  product=rdbms; facility=ora. However I have
never been unable to establish a connection and I get an event cleared
the next time OEM checks???

ORA-11928 is not listed in the FM, Metalink, or google.

Thoughts anyone.

...JIM...

ERROR text...

20030118060618_healthquest_280  java.sql.SQLException: ORA-11928:
Message 11928 not found;  product=RDBMS; facility=ORA 01/18/2003
06:11:07
ORA-02063: preceding line from ADT_HRZ
ORA-04088: error during execution of trigger 'ADT.AE_AIS_TRG'

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: James Howerton
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Americas Cup

2003-01-20 Thread Orr, Steve

Title: RE: Americas Cup

I
understand an Oracle database was running onboad the yacht but...

it
must not have been tuned well...
or
maybe they were using BCHR tuning methods...
or
maybethere wasn'ta good DBA onboard...
or
maybethe DBAwas Larry and he was dependent on using
OEM...
or
maybe it wasn't unbreakable and there were some ora-00600's.

Actually I watched one of the races on ESPN and the commentators said 1)
the skipper made a few tactical errors in desperation because 2) the boat did
not perform as well under higher winds. (15) Maybe the bid wind was
sitting on board. ;-) If there had been less wind it would have probably
won. FWIW.

-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 12:50
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Americas Cup
Well, Larry Ellison allegedly has MiG 25 which is an
interceptor airplane
armed to blow other airplanes out of the sky. It
doesn't have any weapon
system to sink a ship. He should purchase
few F-16 and A-10 planes.
Those can be used against ships. Speaking of
the race, allegedly those GPS
navigation systems they use in the modern yachts are
running SQL Server.
Larry couldn't have won with a software
like that.

-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 1:05
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Americas Cup
Well, I guess now he can use the boat for target practice
when he's flying around in his fighter jet...
--Walt Weaver Bozeman,
Montana
-Original Message- From:
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup
Larry Ellison has spent 95 million (US) attempting to become
the challenger to Team New Zealand for the Americas
Cup. Unfortunately did not make the grade...
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html
Ken

RE: Americas Cup

2003-01-20 Thread Weaver, Walt

Title: RE: Americas Cup

Did he
finally get it? Last I heard U.S. Customs wouldn't let him bring it in the
country.

-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 1:05
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Americas Cup
Well, I guess now he can use the boat for target practice
when he's flying around in his fighter jet...
--Walt Weaver Bozeman,
Montana
-Original Message- From:
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup
Larry Ellison has spent 95 million (US) attempting to become
the challenger to Team New Zealand for the Americas
Cup. Unfortunately did not make the grade...
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html
Ken _ Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED]

LEGAL NOTICE Unless expressly stated
otherwise, this message is confidential and may be privileged. It is
intended for the addressee(s) only. Access to this E-mail by anyone else is
unauthorized. If you are not an addressee, any disclosure or copying of the
contents of this E-mail or any action taken (or not taken) in reliance on it
is unauthorized and may be unlawful. If you are not an addressee, please
inform the sender immediately.
-- Please see the official ORACLE-L
FAQ: http://www.orafaq.net -- Author: Fowler, Kenneth R INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051
http://www.fatcity.com San Diego, California --
Mailing list and web hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and in the message BODY,
include a line containing: UNSUB ORACLE-L (or the
name of mailing list you want to be removed from). You may
also send the HELP command for other information (like
subscribing).

Re: SQLplus question unusual behavior

2003-01-20 Thread John Shaw



I wish it was 
-but that's not the case here. [EMAIL PROTECTED] 
01/20/03 11:19AM Check if there are two taables named FACILTY in 
your database.As SYS, checkSELECT OWNER, Object_name, 
Object_typeFROM DBA_OBJECTSWHERE UPPER(OBJECT_NAME) = 
'FACILITY'Note the use of upper(). Someone might have defined the table 
in lowercase using quotes.CREATE TABLE FACILITY is not the same as 
CREATE TABLE "facility".HTH.ArupFrom: "John Shaw" 
[EMAIL PROTECTED]Reply-To: 
[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L 
[EMAIL PROTECTED]Subject: SQLplus question unusual 
behaviorDate: Mon, 20 Jan 2003 07:30:45 -0800MIME-Version: 
1.0Received: from newsfeed.cts.com ([209.68.248.164]) by 
mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20 
Jan 2003 08:01:55 -0800Received: from fatcity.UUCP 
(uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id 
IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST)Received: by fatcity.com 
(26-Feb-2001/v1.0g-b72/bab) via UUCP id 00534A0E; Mon, 20 Jan 2003 
07:30:45 -0800Message-ID: 
[EMAIL PROTECTED]X-Comment: Oracle RDBMS 
Community ForumX-Sender: "John Shaw" 
[EMAIL PROTECTED]Sender: 
[EMAIL PROTECTED]Errors-To: [EMAIL PROTECTED]Organization: 
Fat City Network Services, San Diego, CaliforniaX-ListServer: v1.0g, 
build 72; ListGuru (c) 1996-2001 Bruce A. BergmanPrecedence: 
bulkReturn-Path: [EMAIL PROTECTED]X-OriginalArrivalTime: 20 
Jan 2003 16:01:55.0073 (UTC) 
FILETIME=[40E1BF10:01C2C09D]I am trying to update a 
small table from a remote table with sqlplus 9.2.0.2 .It seems 
to indicate that it has inserted 233 row into my local table - however 
that doesn't really happen.Am I suffering from a severe lack of caffine 
or is this really odd?SQL select count(*) from 
facility; 
COUNT(*)-- 
0SQL insert into facility (select * from 
facility@dev);233 rows created.SQL select 
count(*) from facility; 
COUNT(*)-- 
0SQL commit;Commit 
complete.SQL select count(*) from 
facility; 
COUNT(*)-- 
0_STOP 
MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Arup 
Nanda INET: [EMAIL PROTECTED]Fat City Network 
Services -- 858-538-5051 http://www.fatcity.comSan Diego, 
California -- Mailing list and web 
hosting 
services-To 
REMOVE yourself from this mailing list, send an E-Mail messageto: 
[EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message 
BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list 
you want to be removed from). You mayalso send the HELP command for 
other information (like subscribing).

Re: Americas Cup

2003-01-20 Thread Igor Neyman

Title: RE: Americas Cup

There are lots of MIG25 in this country.
GM's VP Lutz is flying one.

Igor Neyman, OCP DBA[EMAIL PROTECTED]

- Original Message -
From:
Weaver,
Walt
To: Multiple recipients of list ORACLE-L

Sent: Monday, January 20, 2003 3:24
PM
Subject: RE: Americas Cup

Did
he finally get it? Last I heard U.S. Customs wouldn't let him bring it in the
country.

-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 12:50
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Americas Cup
Well, Larry Ellison allegedly has MiG 25 which is
an interceptor airplane
armed to blow other airplanes out of the sky. It
doesn't have any weapon
system to sink a ship. He should purchase
few F-16 and A-10 planes.
Those can be used against ships. Speaking of
the race, allegedly those GPS
navigation systems they use in the modern yachts
are running SQL Server.
Larry couldn't have won with a software
like that.

-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003
1:05 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Americas Cup
Well, I guess now he can use the boat for target practice
when he's flying around in his fighter jet...
--Walt Weaver Bozeman,
Montana
-Original Message- From:
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup
Larry Ellison has spent 95 million (US) attempting to
become the challenger to Team New Zealand for the
Americas Cup. Unfortunately did not make the grade...
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html
Ken _ Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED]

Fat City Network Services --
858-538-5051 http://www.fatcity.com San Diego, California --
Mailing list and web hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and in the message BODY,
include a line containing: UNSUB ORACLE-L (or the
name of mailing list you want to be removed from). You may
also send the HELP command for other information (like
subscribing).

Re: 100% CPU utilization, urgent

2003-01-20 Thread Stephane Faroult

 Hussain Ahmed Qadri wrote:
 
 Thanks for the script, I would like to know how would I interpret the
 VALUES column, I mean what does it stand for. If the value of CPU used
 for a particular SID is 2000, what does that mean? Is it the time, in
 1/100 th of seconds of the total CPU time? Can you please help me
 understand this?
 
 Thanks and regards
 
 Hussain
 
 -Original Message-
 From: Thomas Day [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 20, 2003 7:00 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: 100% CPU utilization, urgent
 
 Create the view dba_nt_threads and query it, then run the monitor CPU
 per
 session.  These are not my scripts --- I'm pretty sure that they were
 posted here by others --- but I did not capture the information on who
 
 originally wrote them.  My apologies.  HTH
 
 --cr_dba_nt_threads.sql
 -- run as sys
 create or replace view
  dba_NT_threads
  as
  select
  p.spid ID_THREAD,
  p.background BACKGROUND,
  b.name NAME,
  s.sid SID,
  s.serial# SERIAL#,
  s.username USERNAME,
  s.status STATUS,
  s.osuser OSUSER,
  s.program PROGRAM
  from
  v$process p,
  v$bgprocess b,
  v$session s
  where
  s.paddr = p.addr
  and
  b.paddr(+) = p.addr;
 create public synonym dba_nt_threads for dba_nt_threads;
 create public synonym threads for dba_nt_threads;
 

If all NT monitoring tools display threads id in hex and Oracle in
decimal, if I were you, NT folks, my natural laziness would incite me to
create the following function :

create or replace function dec2hex(n in number)
return varchar2
is
  v_result  varchar2(20) := '';
  v_characters  varchar2(16) := '0123456789abcdef';
  n_remain  number;
  n_pos number;
begin
  n_remain := n;
  while (n_remain  0)
  loop
n_pos := mod(n_remain, 16);
v_result := substr(v_characters, n_pos + 1, 1) || v_result;
n_remain := trunc(n_remain / 16); 
  end loop;
  if (v_result = '')
  then
return '0';
  else
return(v_result);
  end if;
end;
/

and, instead of selecting p.spid in the query above, query

   substr(dec2hex(to_number(p.spid)), 1, 9) 

I hate converting between decimal and hexadecimal :-).

-- 
HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Has anyone ever seen ORA-11928 ???

2003-01-20 Thread Stephane Faroult

James Howerton wrote:
 
 DBA's
 
 We are getting an intermittent ORA-11928 in conjunction with ORA-2063
 and ORA-4088 during a batch load that runs every 5 minutes. (See below)
 It only happens once every few days and at different times. When we
 re-run the transaction it loads correctly.
 
 I also get ORA-11928 in an OEM alert on another database from time to
 time. The log shows: new connection cannot be established. ora-11928:
 Message 11928 not found;  product=rdbms; facility=ora. However I have
 never been unable to establish a connection and I get an event cleared
 the next time OEM checks???
 
 ORA-11928 is not listed in the FM, Metalink, or google.
 
 Thoughts anyone.
 
 ...JIM...
 
 ERROR text...
 
 20030118060618_healthquest_280  java.sql.SQLException: ORA-11928:
 Message 11928 not found;  product=RDBMS; facility=ORA 01/18/2003
 06:11:07
 ORA-02063: preceding line from ADT_HRZ
 ORA-04088: error during execution of trigger 'ADT.AE_AIS_TRG'
 
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: James Howerton
   INET: [EMAIL PROTECTED]
 

Jim,

   If you have a look in oraus.msg (the primary source of information
for error messages) you will find the following :

/ 11000 - 11999 Reserved for mvs sql*net errors 

LU 6.2 strikes again ? 

I guess that you must be accessing ADT_HRZ through a database link in
your trigger. You should have some specific documentation for MVS /
SQL*Net somewhere, the error message is likely to be explained into it.
You may also find some useful information in sqlnet.log files you may
collect here and there.
-- 
HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Americas Cup

2003-01-20 Thread Gogala, Mladen

Title: RE: Americas Cup

Now
here is an idea for resolving differences between him and
Gates:
Let's
give Larry a P-51 Mustang, a zero or a ME-110 to Bill Gates
and
let
them sort things out. No chutes in the planes.

-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 3:25
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Americas Cup
Did
he finally get it? Last I heard U.S. Customs wouldn't let him bring it in the
country.

-Original Message-From: Gogala, Mladen
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 12:50
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Americas Cup
Well, Larry Ellison allegedly has MiG 25 which is
an interceptor airplane
armed to blow other airplanes out of the sky. It
doesn't have any weapon
system to sink a ship. He should purchase
few F-16 and A-10 planes.
Those can be used against ships. Speaking of
the race, allegedly those GPS
navigation systems they use in the modern yachts
are running SQL Server.
Larry couldn't have won with a software
like that.

-Original Message-From: Weaver, Walt
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003
1:05 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: Americas Cup
Well, I guess now he can use the boat for target practice
when he's flying around in his fighter jet...
--Walt Weaver Bozeman,
Montana
-Original Message- From:
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 20, 2003 10:09 AM To: Multiple recipients of list ORACLE-L Subject: Americas Cup
Larry Ellison has spent 95 million (US) attempting to
become the challenger to Team New Zealand for the
Americas Cup. Unfortunately did not make the grade...
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00
.html
Ken _ Clinical and Regulatory Informatics - Groton/New London
Coordinator, Business and Technical Services
Tel: (860) 732-0026 Fax: (860) 715-8346 Email: mailto:[EMAIL PROTECTED]

LEGAL NOTICE Unless expressly
stated otherwise, this message is confidential and may be privileged. It
is intended for the addressee(s) only. Access to this E-mail by anyone
else is unauthorized. If you are not an addressee, any disclosure or
copying of the contents of this E-mail or any action taken (or not taken)
in reliance on it is unauthorized and may be unlawful. If you are not an
addressee, please inform the sender immediately.
-- Please see the official
ORACLE-L FAQ: http://www.orafaq.net --
Author: Fowler, Kenneth R INET: [EMAIL PROTECTED]
Fat City Network Services --
858-538-5051 http://www.fatcity.com San
Diego, California -- Mailing
list and web hosting services -
To REMOVE yourself from this mailing list, send an E-Mail
message to: [EMAIL PROTECTED] (note EXACT
spelling of 'ListGuru') and in the message BODY,
include a line containing: UNSUB ORACLE-L (or the
name of mailing list you want to be removed from). You may
also send the HELP command for other information (like
subscribing).

Help with procedure

2003-01-20 Thread Bryan, Miriam

Hi List, I'm hoping someone can help me. I'm trying to compile a procedure,
which calls another procedure and I keep getting an error on the first end;
can't figure out what's wrong. Perhaps someone that hasn't seen this
procedure for hours can tell me what's wrong.
The user has all the right privileges.

Here's the code:



CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin
AS
--
--
-- Purpose: Convert Agent_Activity.Admin table to Employee_Activity
--  User_Info and User_Security_Group.
--
-- MODIFICATION HISTORY
-- Person  Date Comments
-- -   --   ---
-- psurring   1/20/03   Initial implementation
--

err_num NUMBER;
err_msg VARCHAR2 (100);
V_SECURITY_GROUPUSER_SECURITY_GROUP.SECURITY_GROUP_ID%TYPE;
V_BRANCHUSER_INFO.BRANCH%TYPE;

CURSOR get_admin 
  IS
  Select username,
   password,
   level_,
   center,
   first_name,
   last_name
From AGENT_ACTIVITY.ADMIN
Where upper(level_) in ('CENTER','TEAM','GROUP','PAYROLL');

BEGIN

   FOR x IN get_workgroups
   LOOP
begin
if upper(x.level_) in ('CENTER','TEAM','GROUP') then
v_security_group := 4;
else if upper(x.level_) in ('PAYROLL') then
v_security_group := 2;
end if;
if x.center = 'TX' then
v_branch := '7';
else
v_branch := 'G';
end if;
 EMPLOYEE_ACTIVITY.ADD_USER(x.username,
 x.first_name,
 x.last_name,
 x.password,
 v_branch,
 null,
 'SYSTEM',
 v_security_group);
 
 EXCEPTION
 WHEN OTHERS
 THEN
err_num := SQLCODE;
err_msg := SUBSTR (SQLERRM, 1, 100);
ROLLBACK;
insert into Application_error (USER_NAME,
 ERROR_DATE,
 PROCEDURE_NAME,
 SQL_ERROR_NUM,
 SQL_ERR_MSG,
 PARAMETER)
values
(v_LAST_UPDATED_BY,sysdate,'EMPLOYEE_ACTIVITY.ADD_USER',v_err_num,v_err_msg,
'v_USER_NAME='||v_USER_NAME||
'v_FIRST_NAME='||v_FIRST_NAME||
'v_LAST_NAME='||v_LAST_NAME||
'v_PASSWORD='||v_PASSWORD||
'v_DEFAULT_BRANCH='||v_DEFAULT_BRANCH||
'v_DEFAULT_WORKGROUP_ID='||v_DEFAULT_WORKGROUP_ID||
'v_LAST_UPDATED_BY='||v_LAST_UPDATED_BY||
'v_SECURITY_GROUP_ID='||v_SECURITY_GROUP_ID);
  COMMIT;
  RAISE;
  
   END;
   END LOOP;
end;
/


TIA,

M. Bryan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bryan, Miriam
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: can't remove advance queuing

When it's sitting there, from another session as sys, see if the session is
waiting on anything. I have a pretty godd feeling you will see a library
cache wait on that session. Do you have a job running (using dbms_aq) that
is holding a share lock on the advanced queue?

Arup
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 12:44 PM


 Hello All,

 I'm having problems with a oracle 8.7.1 database running on SuSE 7.1.  My
 original problem was unable to drop a user, searching through the archive
 I found the problem described at
 http://www.orafaq.net/archive/oracle-l/2002/03/01/144826.htm

 This was the exact problem, the trace file was reporting a fail with error
 942 and 604 when executing the command:
 select name from system.aq$_queue_tables where schema=:1;

 The solution was to run catnoque.sql and then catqueue.sql as the sys
 user, this will recreate the AQ tables.  This is where things fail:

 When i run the catnoque.sql it gets as far as drop package dbms_aq; and
 just seems to sit there, looking at top oracle's cpu usuage is minimal
 (0.3% CPU 1.9%) so it doesn't seem to be doing anything. The last thing i
 get in the trace log is:

 =
 PARSING IN CURSOR #5 len=33 dep=1 uid=0 oct=7 lid=0 tim=0 hv=3605072212
 ad='512e1c0c'
 delete from source$ where obj#=:1
 END OF STMT
 PARSE #5:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=4,tim=0
 BINDS #5:
  bind 0: dty=2 mxl=22(22) mal=00 scl=00 pre=00 oacflg=00 oacfl2=1 size=24
 offset=0
bfp=0958d010 bln=22 avl=03 flg=05
value=2451


 Anyone know what is going on?


 Regards
 Mark
 --
 Please see the official ORACLE-L FAQ: http://www.orafaq.net
 --
 Author: Mark O'Loughlin
   INET: [EMAIL PROTECTED]

 Fat City Network Services-- 858-538-5051 http://www.fatcity.com
 San Diego, California-- Mailing list and web hosting services
 -
 To REMOVE yourself from this mailing list, send an E-Mail message
 to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
 the message BODY, include a line containing: UNSUB ORACLE-L
 (or the name of mailing list you want to be removed from).  You may
 also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Arup Nanda
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQLplus question unusual behavior

2003-01-20 Thread Chaim . Katz


Arup,
How about  select * instead of select count... Maybe the data is there but
something is wrong with sql*plus set up (numwidth) so that you don't see
the count.
( I know that sounds stranger than the original question, but from the
query you posted it looks like the count(*) is null which can't be...)





John Shaw [EMAIL PROTECTED]@fatcity.com on 01/20/2003
03:39:43 PM

Please respond to [EMAIL PROTECTED]

Sent by:[EMAIL PROTECTED]


To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:



I wish it was  - but that's not the case here.

 [EMAIL PROTECTED]  01/20/03 11:19AM 
Check if there are two taables named FACILTY in  your database.

As SYS, check

SELECT OWNER, Object_name,  Object_type
FROM DBA_OBJECTS
WHERE UPPER(OBJECT_NAME) =  'FACILITY'

Note the use of upper(). Someone might have defined the table  in lowercase
using quotes.

CREATE TABLE FACILITY is not the same as  CREATE TABLE facility.

HTH.

Arup

From: John Shaw  [EMAIL PROTECTED]
Reply-To:  [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L  [EMAIL PROTECTED]
Subject: SQLplus question unusual  behavior
Date: Mon, 20 Jan 2003 07:30:45 -0800
MIME-Version:  1.0
Received: from newsfeed.cts.com ([209.68.248.164]) by
mc9-f3.bay6.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Mon, 20
Jan
2003 08:01:55 -0800
Received: from fatcity.UUCP  (uucp@localhost)by newsfeed.cts.com
(8.9.3/8.9.3) with UUCP id  IAA19511;Mon, 20 Jan 2003 08:01:26 -0800 (PST)
Received: by fatcity.com  (26-Feb-2001/v1.0g-b72/bab) via UUCP id
00534A0E;
Mon, 20 Jan 2003  07:30:45 -0800
Message-ID:  [EMAIL PROTECTED]
X-Comment: Oracle RDBMS  Community Forum
X-Sender: John Shaw  [EMAIL PROTECTED]
Sender:  [EMAIL PROTECTED]
Errors-To: [EMAIL PROTECTED]
Organization:  Fat City Network Services, San Diego, California
X-ListServer: v1.0g,  build 72; ListGuru (c) 1996-2001 Bruce A. Bergman
Precedence:  bulk
Return-Path: [EMAIL PROTECTED]
X-OriginalArrivalTime: 20  Jan 2003 16:01:55.0073 (UTC)
FILETIME=[40E1BF10:01C2C09D]

I am trying to update a  small table from a remote table with sqlplus
9.2.0.2 .
It seems  to indicate that it has inserted 233 row into my local table -
however  that doesn't really happen.
Am I suffering from a severe lack of caffine  or is this really odd?

SQL select count(*) from  facility;

    COUNT(*)
--


SQL insert into facility (select * from  facility@dev);

233 rows created.

SQL select  count(*) from facility;

    COUNT(*)
--


SQL commit;

Commit  complete.

SQL select count(*) from  facility;

    COUNT(*)
--



_
STOP  MORE SPAM with the new MSN 8 and get 2 months FREE*
http://join.msn.com/?page=features/junkmail

--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Arup  Nanda
  INET: [EMAIL PROTECTED]

Fat City Network  Services    -- 858-538-5051 http://www.fatcity.com
San Diego,  California    -- Mailing list and web  hosting  services
-
To  REMOVE yourself from this mailing list, send an E-Mail message
to:  [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message  BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list  you want to be removed from).  You may
also send the HELP command for  other information (like subscribing).







-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: 
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

RE: Americas Cup

2003-01-20 Thread Weaver, Walt

Title: RE: Americas Cup



I 
thought Lutz owns an L-39. I was told this by a local pilot who just bought an 
L-39.

There 
are MIG 15's, 17's, and 21's in the U.S. but I wasn't aware of any 
Foxbats.

--Walt

  -Original Message-From: Igor Neyman 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 1:55 
  PMTo: Multiple recipients of list ORACLE-LSubject: Re: 
  Americas Cup
  There are lots of MIG25 in this country.
  GM's VP Lutz is flying one.
  
  Igor Neyman, OCP DBA[EMAIL PROTECTED] 
  
  
  
  
- Original Message - 
From: 
Weaver, 
Walt 
To: Multiple recipients of list ORACLE-L 

Sent: Monday, January 20, 2003 3:24 
PM
Subject: RE: Americas Cup

Did he finally get it? Last I heard U.S. Customs wouldn't let him 
bring it in the country.

  -Original Message-From: Gogala, Mladen 
  [mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 12:50 
  PMTo: Multiple recipients of list ORACLE-LSubject: 
  RE: Americas Cup
  Well, Larry Ellison allegedly has MiG 25 which is 
  an interceptor airplane
  armed to blow other airplanes out of the sky. It 
  doesn't have any weapon
  system to sink a ship. He should purchase 
  few F-16 and A-10 planes. 
  Those can be used against ships. Speaking 
  of the race, allegedly those GPS 
  navigation systems they use in the modern yachts 
  are running SQL Server. 
  Larry couldn't have won with a 
  software like that. 
  
-Original Message-From: Weaver, Walt 
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 
1:05 PMTo: Multiple recipients of list 
ORACLE-LSubject: RE: Americas Cup
Well, I guess now he can use the boat for target 
practice when he's flying around in his fighter jet... 
--Walt Weaver  Bozeman, 
Montana 
-Original Message- From: 
Fowler, Kenneth R [mailto:[EMAIL PROTECTED]] 
Sent: Monday, January 20, 2003 10:09 AM 
To: Multiple recipients of list ORACLE-L 
Subject: Americas Cup 
Larry Ellison has spent 95 million (US) attempting to 
become the challenger to Team New Zealand for 
the Americas Cup. Unfortunately did not make the grade... 
http://www.stuff.co.nz/stuff/sundaystartimes/auckland/0,2106,2204857a6469,00 
.html 
Ken _ Clinical and Regulatory Informatics - Groton/New London 
Coordinator, Business and Technical Services 
Tel: (860) 732-0026 Fax: (860) 715-8346 
Email: mailto:[EMAIL PROTECTED] 

LEGAL NOTICE Unless expressly 
stated otherwise, this message is confidential and may be privileged. It 
is intended for the addressee(s) only. Access to this E-mail by anyone 
else is unauthorized. If you are not an addressee, any disclosure or 
copying of the contents of this E-mail or any action taken (or not 
taken) in reliance on it is unauthorized and may be unlawful. If you are 
not an addressee, please inform the sender immediately.
-- Please see the official 
ORACLE-L FAQ: http://www.orafaq.net -- Author: Fowler, Kenneth R 
 INET: [EMAIL PROTECTED] 

Fat City Network Services -- 
858-538-5051 http://www.fatcity.com 
San Diego, 
California -- Mailing list and 
web hosting services - 
To REMOVE yourself from this mailing list, send an 
E-Mail message to: [EMAIL PROTECTED] (note 
EXACT spelling of 'ListGuru') and in the message 
BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). 
You may also send the HELP command for other 
information (like subscribing).

Re: Help with procedure

Could you relate exactly what error you are seeing?  Just seeing the code
doesn't help much...

To get the error messages, you can execute the following from SQL*Plus:

SHOW ERRORS PROCEDURE PROCEDURE CONVERT_AA_ADMIN

while connected as the account EMPLOYEE_ACTIVITY...

- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, January 20, 2003 2:15 PM


 Hi List, I'm hoping someone can help me. I'm trying to compile a
procedure,
 which calls another procedure and I keep getting an error on the first
end;
 can't figure out what's wrong. Perhaps someone that hasn't seen this
 procedure for hours can tell me what's wrong.
 The user has all the right privileges.

 Here's the code:



 CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin
 AS
 --
 --
 -- Purpose: Convert Agent_Activity.Admin table to Employee_Activity
 --  User_Info and User_Security_Group.
 --
 -- MODIFICATION HISTORY
 -- Person  Date Comments
 -- -   --   ---
 -- psurring   1/20/03   Initial implementation
 --

 err_num NUMBER;
 err_msg VARCHAR2 (100);
 V_SECURITY_GROUPUSER_SECURITY_GROUP.SECURITY_GROUP_ID%TYPE;
 V_BRANCHUSER_INFO.BRANCH%TYPE;

 CURSOR get_admin
   IS
   Select username,
password,
level_,
center,
first_name,
last_name
 From AGENT_ACTIVITY.ADMIN
 Where upper(level_) in ('CENTER','TEAM','GROUP','PAYROLL');

 BEGIN

FOR x IN get_workgroups
LOOP
 begin
 if upper(x.level_) in ('CENTER','TEAM','GROUP') then
 v_security_group := 4;
 else if upper(x.level_) in ('PAYROLL') then
 v_security_group := 2;
 end if;
 if x.center = 'TX' then
 v_branch := '7';
 else
 v_branch := 'G';
 end if;
  EMPLOYEE_ACTIVITY.ADD_USER(x.username,
  x.first_name,
  x.last_name,
  x.password,
  v_branch,
  null,
  'SYSTEM',
  v_security_group);

  EXCEPTION
  WHEN OTHERS
  THEN
 err_num := SQLCODE;
 err_msg := SUBSTR (SQLERRM, 1, 100);
 ROLLBACK;
 insert into Application_error (USER_NAME,
  ERROR_DATE,
  PROCEDURE_NAME,
  SQL_ERROR_NUM,
  SQL_ERR_MSG,
  PARAMETER)
 values

(v_LAST_UPDATED_BY,sysdate,'EMPLOYEE_ACTIVITY.ADD_USER',v_err_num,v_err_msg,
 'v_USER_NAME='||v_USER_NAME||
 'v_FIRST_NAME='||v_FIRST_NAME||
 'v_LAST_NAME='||v_LAST_NAME||
 'v_PASSWORD='||v_PASSWORD||
 'v_DEFAULT_BRANCH='||v_DEFAULT_BRANCH||
 'v_DEFAULT_WORKGROUP_ID='||v_DEFAULT_WORKGROUP_ID||
 'v_LAST_UPDATED_BY='||v_LAST_UPDATED_BY||
 'v_SECURITY_GROUP_ID='||v_SECURITY_GROUP_ID);
   COMMIT;
   RAISE;

END;
END LOOP;
 end;
 /

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Tim Gorman
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Auto start failing AGAIN... shared realm does not exist....

2003-01-20 Thread Bob Metelsky

My scenario

Fresh install of w2k server, sp 3 high end machine, twin 2G processers
4G ram ...
Installed Oracle 8.17 release 3, Install went perfectly smooth
built 9 databases connected and imported all data I could connect at
will ... All was well

The problem:
when the machine reboots, the service and database does not start
automatically.If I try to 
sqlplus user/pass@instance 
I get the 
Oracle not available, shared realm does not exist (in other words
the dbs did not start)

I can start manually using 
startdb.bat
svrmgrl.exe command='@C:\db_startup\initdb8i.sql' 

initdb8i.sql
connect internal/pass@db8i
startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora
exit 

The instance starts and all is well


Ive deleted all the services using Oradim and rebooted, then recreated
using

rem D:\install\setODIM.bat
set db=someinstance
sleep 1
ORADIM -DELETE -SID %db%
sleep 2
ORADIM -NEW -SID %db% -INTPWD passwd -STARTMODE auto -PFILE
D:\OraHome1\admin\%db%\PFILE\init%db%.ora -TIMEOUT 90
sleep 2
ORADIM -SHUTDOWN -SID %db% -USRPWD passwd -SHUTTYPE srvc,inst -SHUTMODE
i 
sleep 2
ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE
D:\OraHome1\admin\%db%\PFILE\init%db%.ora
echo off
echo.
echo Done creating oradim entries for %db% !

If I create  one service, using the above batch file I can connect to
the database,
eg ORADIM -STARTUP -SID %db% -USRPWD passwd -STARTTYPE srvc,inst -PFILE
D:\OraHome1\admin\%db%\PFILE\init%db%.ora
but when the machine reboots and I try to connect I get the oracle not
available

here are my registry settings
http://209.123.6.84/srvreg.jpg

This is very frustrating as I had this problem on a server that had the
OS upgraded and I could never get the autostart working correctly
This is a new machine and I can reboot at will or make any changes (no
one is using this server yet) so I really need to get this working.

I am at a loss... any suggestions would be appreciated

thanks
bob
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bob Metelsky
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Base conversion - WAS: RE: 100% CPU utilization, urgent

2003-01-20 Thread Richard Ji

Can't you just use to_char function to convert from decimal to hex?

select to_char(255,'x') from dual;

TO_CHA
--
ff

Richard Ji

-Original Message-
Sent: Monday, January 20, 2003 3:55 PM
To: Multiple recipients of list ORACLE-L


 Hussain Ahmed Qadri wrote:
 
 Thanks for the script, I would like to know how would I interpret the
 VALUES column, I mean what does it stand for. If the value of CPU used
 for a particular SID is 2000, what does that mean? Is it the time, in
 1/100 th of seconds of the total CPU time? Can you please help me
 understand this?
 
 Thanks and regards
 
 Hussain
 
 -Original Message-
 From: Thomas Day [mailto:[EMAIL PROTECTED]]
 Sent: Monday, January 20, 2003 7:00 PM
 To: Multiple recipients of list ORACLE-L
 Subject: Re: 100% CPU utilization, urgent
 
 Create the view dba_nt_threads and query it, then run the monitor CPU
 per
 session.  These are not my scripts --- I'm pretty sure that they were
 posted here by others --- but I did not capture the information on who
 
 originally wrote them.  My apologies.  HTH
 
 --cr_dba_nt_threads.sql
 -- run as sys
 create or replace view
  dba_NT_threads
  as
  select
  p.spid ID_THREAD,
  p.background BACKGROUND,
  b.name NAME,
  s.sid SID,
  s.serial# SERIAL#,
  s.username USERNAME,
  s.status STATUS,
  s.osuser OSUSER,
  s.program PROGRAM
  from
  v$process p,
  v$bgprocess b,
  v$session s
  where
  s.paddr = p.addr
  and
  b.paddr(+) = p.addr;
 create public synonym dba_nt_threads for dba_nt_threads;
 create public synonym threads for dba_nt_threads;
 

If all NT monitoring tools display threads id in hex and Oracle in
decimal, if I were you, NT folks, my natural laziness would incite me to
create the following function :

create or replace function dec2hex(n in number)
return varchar2
is
  v_result  varchar2(20) := '';
  v_characters  varchar2(16) := '0123456789abcdef';
  n_remain  number;
  n_pos number;
begin
  n_remain := n;
  while (n_remain  0)
  loop
n_pos := mod(n_remain, 16);
v_result := substr(v_characters, n_pos + 1, 1) || v_result;
n_remain := trunc(n_remain / 16); 
  end loop;
  if (v_result = '')
  then
return '0';
  else
return(v_result);
  end if;
end;
/

and, instead of selecting p.spid in the query above, query

   substr(dec2hex(to_number(p.spid)), 1, 9) 

I hate converting between decimal and hexadecimal :-).

-- 
HTH,

Stephane Faroult
Oriole Software
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Stephane Faroult
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Richard Ji
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Upgrade from 7.3.4 to 8.0.6

2003-01-20 Thread Bowes, Chris

Title: Upgrade from 7.3.4 to 8.0.6





Hi everyone!


 Has anyone seen this and know a solution? I am upgrading a base from 7.3.4 to 8.0.6. Everything appears to go fine until the catrep8m script. In that script I get several errors:

Statement processed.
 (P.delivery_order  C.cscn)
 *
ORA-00904: invalid column name
grant select on defcalldest to select_catalog_role
 *
ORA-00942: table or view does not exist
comment on table DEFCALLDEST is
 *
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.CALLNO is
 *
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.DEFERRED_TRAN_ID is
 *
ORA-00942: table or view does not exist
comment on column DEFCALLDEST.DBLINK is
 *
ORA-00942: table or view does not exist
DROP PUBLIC SYNONYM defcalldest
 *
ORA-01432: public synonym to be dropped does not exist
Statement processed.
 OR (P.delivery_order  C.cscn
 *
ORA-00904: invalid column name
Statement processed.
Statement processed.
Statement processed.



This then forces several dictionary packages invalid and they wont' recompile.


I have tried rebuilding the dictionary before I upgrade and rebuilding after I upgrade. Neither one seems to work. When I rebuild, the catrep script gives that same error.

So far Oracle hasn't been able to find it. Has anyone seen this and know the fix?


Thanks in advance.


--Chris
[EMAIL PROTECTED]

RE: Help with procedure

2003-01-20 Thread Johnston, Tim

What is the exact error?  What oracle version?  Just guessing, are the privs
granted directly to the user or through a role?  If they are via a role,
grant them directly to the user...

HTH
Tim

-Original Message-
Sent: Monday, January 20, 2003 4:16 PM
To: Multiple recipients of list ORACLE-L


Hi List, I'm hoping someone can help me. I'm trying to compile a procedure,
which calls another procedure and I keep getting an error on the first end;
can't figure out what's wrong. Perhaps someone that hasn't seen this
procedure for hours can tell me what's wrong.
The user has all the right privileges.

Here's the code:



CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin
AS
--
--
-- Purpose: Convert Agent_Activity.Admin table to Employee_Activity
--  User_Info and User_Security_Group.
--
-- MODIFICATION HISTORY
-- Person  Date Comments
-- -   --   ---
-- psurring   1/20/03   Initial implementation
--

err_num NUMBER;
err_msg VARCHAR2 (100);
V_SECURITY_GROUPUSER_SECURITY_GROUP.SECURITY_GROUP_ID%TYPE;
V_BRANCHUSER_INFO.BRANCH%TYPE;

CURSOR get_admin 
  IS
  Select username,
   password,
   level_,
   center,
   first_name,
   last_name
From AGENT_ACTIVITY.ADMIN
Where upper(level_) in ('CENTER','TEAM','GROUP','PAYROLL');

BEGIN

   FOR x IN get_workgroups
   LOOP
begin
if upper(x.level_) in ('CENTER','TEAM','GROUP') then
v_security_group := 4;
else if upper(x.level_) in ('PAYROLL') then
v_security_group := 2;
end if;
if x.center = 'TX' then
v_branch := '7';
else
v_branch := 'G';
end if;
 EMPLOYEE_ACTIVITY.ADD_USER(x.username,
 x.first_name,
 x.last_name,
 x.password,
 v_branch,
 null,
 'SYSTEM',
 v_security_group);
 
 EXCEPTION
 WHEN OTHERS
 THEN
err_num := SQLCODE;
err_msg := SUBSTR (SQLERRM, 1, 100);
ROLLBACK;
insert into Application_error (USER_NAME,
 ERROR_DATE,
 PROCEDURE_NAME,
 SQL_ERROR_NUM,
 SQL_ERR_MSG,
 PARAMETER)
values
(v_LAST_UPDATED_BY,sysdate,'EMPLOYEE_ACTIVITY.ADD_USER',v_err_num,v_err_msg,
'v_USER_NAME='||v_USER_NAME||
'v_FIRST_NAME='||v_FIRST_NAME||
'v_LAST_NAME='||v_LAST_NAME||
'v_PASSWORD='||v_PASSWORD||
'v_DEFAULT_BRANCH='||v_DEFAULT_BRANCH||
'v_DEFAULT_WORKGROUP_ID='||v_DEFAULT_WORKGROUP_ID||
'v_LAST_UPDATED_BY='||v_LAST_UPDATED_BY||
'v_SECURITY_GROUP_ID='||v_SECURITY_GROUP_ID);
  COMMIT;
  RAISE;
  
   END;
   END LOOP;
end;
/


TIA,

M. Bryan
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Bryan, Miriam
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Johnston, Tim
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: Database tracking

2003-01-20 Thread Anjo Kolk

Title: Message



If it runs slower, then what? And if it 
automagically fixes it self again? Is that considered a problem or 
not?

Anjo.

  - Original Message - 
  From: 
  Terrian, 
  Tom (Contractor) (DAASC) 
  To: Multiple recipients of list ORACLE-L 
  
  Sent: Wednesday, January 15, 2003 6:53 
  PM
  Subject: Database tracking
  
  All, I would like 
  to track the performance of my production databases by 
  runningthesame SQL statementagainst each database every 5 minutes or 
  so and recording the results. For example:
  sql set timing 
  on;
  sql select 
  count(*) from dba_tables;
  
  That was I would 
  know if they are getting faster or slower over time. As anyone already 
  done this? Would there be a good SQL statement to 
  use?
  
  Thanks,
  Tom 
  Terrian

RE: Americas Cup

2003-01-20 Thread Whittle Jerome Contr NCI

Title: RE: Americas Cup






There's a difference? ;-)

Just think: US Postal Service has been catching heck for spending about $3 million on the Postal team in the Tour de France and Lance Armstrong has been winning. Uncle Larry spends $95 million to come in second place. Of course USPS is a government monopoly and has been losing money.

Jerry Whittle

ASIFICS DBA

NCI Information Systems Inc.

[EMAIL PROTECTED]

618-622-4145

-Original Message-

From: KENNETH JANUSZ [SMTP:[EMAIL PROTECTED]]

Was this Oracle money or Larry's private funds?

 

Ken Janusz, CPIM

Re[2]: Americas Cup

2003-01-20 Thread Robert Eskridge

Mladen, have you ever seen video of what a Coast Guard .50cal can do
to a fishing boat?  I don't know what armament Ellison's interceptor
could carry, but I suspect the mounts would support something that
could easily turn a racing yacht into toothpicks.


G Well, Larry Ellison allegedly has MiG 25 which is an interceptor airplane
G armed to blow other airplanes out of the sky. It doesn't have any weapon
G system to sink a ship. He should purchase few F-16 and A-10 planes. 
G Those can be used against ships.  Speaking of the race, allegedly those GPS 
G navigation systems they use in the modern yachts are running SQL Server. 
G Larry couldn't have won with a software like that. 

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.net
-- 
Author: Robert Eskridge
  INET: [EMAIL PROTECTED]

Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Re: SQLplus question unusual behavior