Stephane Faroult wrote:
I hate converting between decimal and hexadecimal
:-).
You can use TO_CHAR for that :)
I am afraid age is showing ...
Did not get you. Your routine is fine except the fact
it can be faster.
When I was 12 it was my first asm (ix86) exercise --
hex2dec/dec2hex routine
Title: RE: Re: 100% CPU utilization, urgent
Why ??
oraclei@rhea-ACPT1> sys
SQL*Plus: Release 9.2.0.2.0 - Production on Tue Jan 21 07:33:42 2003
Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved.
Connected.
SQL> select to_char(12345,'') from dua
>
>Stephane Faroult wrote:
>> I hate converting between decimal and hexadecimal
>:-).
>
>You can use TO_CHAR for that :)
I am afraid age is showing ...
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroul
INET: [EMAIL PRO
>
>Stephane Faroult wrote:
>> I hate converting between decimal and hexadecimal
>:-).
>
>You can use TO_CHAR for that :)
I am afraid age is showing ...
Regards,
Stephane Faroult
Oriole
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stephane Faroul
INET: [EMAIL PRO
There may be some utility at sysinternals.com that does what you require.
On Monday 20 January 2003 03:49, Hussain Ahmed Qadri wrote:
> 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
> w
Stephane Faroult wrote:
I hate converting between decimal and hexadecimal :-).
You can use TO_CHAR for that :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily represent those of Oracle Corporation.
--
Please see the official ORACLE-L FAQ: http://ww
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, urg
otal 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
> Subjec
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
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
@skm.org.pk> cc:
Sent by: root Subject: RE: 100% CPU ut
uot;Koivu, Lisa"
@efairfield.com> cc:
Sent by: root Subject: RE: 100% C
Title: RE: 100% CPU utilization, urgent
We seem to have switched email threads, but
the value from the VALUE column in the query on V$SESSTAT is centiseconds
of CPU consumed by the session. Although V$SESSTAT is not updated
continuously (but rather in "spurts"), you should see a c
uot;Koivu, Lisa"
field.com> cc:
Sent by: Subject: RE: 100% C
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---
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 sho
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;
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
>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
Title: 100% CPU utilization, urgent
It would be more appropriate to determine whether
SMON is consuming all the CPU first, before sending someone on some
irrelevant wild-goose chase for "fragmented tablespaces". More
effective to first look for basic facts than to go off chasing
tag, 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
>-
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
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
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
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)
[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
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
lto:[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 foun
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
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,
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 numbe
Title: 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
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 some
Title: 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
Title: 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
36 matches
Mail list logo
