in one tablespace? I think you mean in one schema.
-Original Message-
Sent: Monday, January 20, 2003 10:39 PM
To: Multiple recipients of list ORACLE-L
If it is possible, how could two tables have the same name and structure in
one tablespace ? I think you should check your data dictionar
Robert,
Does this mean you're using it? If so, could you describe your use, and any caveats?
>>> [EMAIL PROTECTED] 21/1/2003 15:28:47 >>>
This message has been scanned by MAILSweeper.
Workspace management - cool feature!
RF
-Or
Hi all,
I am wondering is there something wrong with my listener settings. I mean when I type
LSNRCTL> servicesConnecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=test01u)(PORT=1521)))Services Summary...Service "TEST2" has 2 instance(s). Instance "TEST2", status UNKNOWN, has 1 handler(s) fo
If it is possible, how could two tables have the same name and structure in
one tablespace ? I think you should check your data dictionary or your
program documentation.
Hope this helps.
Rgrds,
Sony
> -Original Message-
> From: Arup Nanda [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January
You will get ORA-12992 if there was FK referencing to column you attempted to drop.
There are bugs related to dropping columns from a table with LOB datatypes.
This is very bizarre in 8i.
I have experienced it while testing this new feature
Here is a reproducible case on all versions of
Workspace management - cool feature!
RF
-Original Message-
Sent: Monday, January 20, 2003 8:49 PM
To: Multiple recipients of list ORACLE-L
Dennis,
Thanx very much for the tip. I'm going through the doco at the moment - it
looks pretty intense! Could be just what I'm looking for.
>>>
Arn - Well, I should warn you of one thing. Even the Oracle Education
instructor that covered this feature wasn't sure what the heck it would be
good for. I just put together the fact that you seemed to be wanting to
version your documents, and this is a versioning feature.
Dennis Williams
DBA, 4
Is it such kind of war or foot ball game ?
> -Original Message-
> From: Gogala, Mladen [SMTP:[EMAIL PROTECTED]]
> Sent: Tuesday, January 21, 2003 2:50 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Americas Cup
>
> Well, Larry Ellison allegedly has MiG 25 which is an
Hmm.
Running the update with 100,000 records in the table :
Now I get different run-times :
1. 01hr:16min:41.55sec, 386 log-switches [10MB redologs]
2. 00hr:03min:39.76sec, 33 log-switches
3. 00h4:03min:37.56sec, 32 log-switches
What I can see is that the SMON was still busy
when I started
I might not change either. Chaining can happen
regardless of PCTFREE and PCTUSED.
The answer is 'it depends'. The dependency being
the data and how it's being accessed.
Jared
On Saturday 18 January 2003 15:28, Reddy, Madhusudana wrote:
> Charlie,
>
> Would you please post your PL/SQL code her
Have you checked the event logs?
Also take a look at Doc # 136214.1 on MetaLink.
Jared
On Monday 20 January 2003 13:46, Bob Metelsky wrote:
> 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 perfe
It seems like you are in an infinte loop. Your counter cntr
never gets incremented.
-Original Message-
Sent: Monday, January 20, 2003 8:19 PM
To: Multiple recipients of list ORACLE-L
I have been trying to run a "benchmark" of a server
[9iRel2 on HPUX]
The database is 9.2.0.2 with Exte
tpc.org?
On Sunday 19 January 2003 21:38, Hemant K Chitale wrote:
> I am looking for a quick and easy HW benchmark
> for an Oracle database.
> Now, before everyone starts jumping on the word "benchmark",
> I just need something that can be setup in an hour or two,
> simulate 1 to 1 million trans
Dennis,
Thanx very much for the tip. I'm going through the doco at the moment - it looks
pretty intense! Could be just what I'm looking for.
>>> [EMAIL PROTECTED] 18/1/2003 8:09:43 >>>
This message has been scanned by MAILSweeper.
A
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
John Shaw wrote:
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(*) f
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
Yes, thanks. The DB benchmark at SoftTreeTech does seem like a good, beginning, small
benchmark that an individual can setup and run immediately.
Thanks, again !
Hemant
--- Juan Miranda <[EMAIL PROTECTED]> wrote:
>
> try dbtools / db benchmark expert http://www.softtreetech.com/
> There ha
oops. The "cntr := cntr+1" is missing from the update.
The previous update round didn't have a counter, though.
I am re-running the update now.
Hemant
- Forwarded message from Hemant K Chitale <[EMAIL PROTECTED]> -
Date: Tue, 21 Jan 2003 09:16:28 +0800 (SGT)
Reply-To: [EMAIL PROTECTED]
Dear RMAN Wizards
I have this problem with a script for deleting archive file on tape.
The story is that this script has worked perfect for more than a 2 year
until the database
and there by rman was upgraded to 8.1.7.4 from 8.1.6..x.
The media manager is TSM (IBM Tivoli) and everything is runni
Chaim,
It was posted by John Shaw. And the figures showed 0 (not null) in the
original posting.
Arup
From: [EMAIL PROTECTED]
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
Subject: Re: SQLplus question unusual behavior
Date: Mon, 20 Jan 2003 13:23:
I have been trying to run a "benchmark" of a server
[9iRel2 on HPUX]
The database is 9.2.0.2 with Extent Management Local and
an Undo Tablespace.
This is my table :
create table txn_table
(setrangenumber(2) not null,
col1 varchar2(6),
col2 varchar2(255),
col3
Bryan, Miriam wrote:
CREATE OR REPLACE PROCEDURE EMPLOYEE_ACTIVITY.convert_AA_admin
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
^^
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 2
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 gov
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,
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
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
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 th
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 servic
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
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
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'
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
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 privi
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]]
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.
>
> 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 y
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
Sub
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
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: Gogala, Mladen
[mailto:[EMAIL PROTECTED]]Sent: Monday, January 20, 2003 12:50
PMTo: Multiple recipients of list ORACLE-LSubject: RE:
Am
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
maybe there wasn't a good DBA onboard...
or
maybe the DBA was Larry and he was dependent on using
OEM...
or
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
Title: RE: Americas Cup
Well
he almost DIED the last time he did this so it IS an 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 s
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
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 S
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 st
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
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: Multipl
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
||
|
|
|
nscorp.co
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
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 s
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, Califo
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 lis
Just a thought - is facility a table or is it some synonym/view pointing
somewhere else..
Babu
|-+--->
| | John Shaw |
| ||
| | Sent by:|
| | [EMAIL PROT
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
selectivit
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 Ame
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:
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
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?
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 w
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: F
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.
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 excelle
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 clear trend
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
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
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 PROTEC
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
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
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 t
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:
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
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;
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=glance&s=books
(pls watch for line-wrap.)
Cheers,
-Roy
Roy Pardee
Programmer/Analyst
SWFPAC
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 PR
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?
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
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 di
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
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
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.c
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. Wh
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 cras
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 after any
t
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:
Banara
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
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 h
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. Yo
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 th
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
c
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, 20
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
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
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 alread
...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
sqlp
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 Me
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 th
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
I have the following table in Oracle 8.1.7:
Name Null?Type
- --
DIENSTLEISTUNGSOBJEKTOID VARCHAR2(23)
OID NOT NULL VARCHAR2(23)
AUME
1 - 100 of 119 matches
Mail list logo
