Of Stephane
Faroult[EMAIL PROTECTED]
Sent: Tuesday, June 18, 2002 6:48 AM
To: Multiple recipients of list ORACLE-L
Subject: RE: RE: Advance Oracle Trigger Writing Advice
Hanna,
I still have a fairly confused view of what your problem is and how you plan to
solve it. Jean
Title: RE: RE: Advance Oracle Trigger Writing Advice
Hi Hannah,
I think you could use a simpler feature to brute-force a trace of your trigger's execution path. The SYS.DBMS_SYSTEM.KSDWRT procedure provides output facilities for the alert.log and session trace files. SYS.DBMS_SYSTEM.KSDWRT
To: [EMAIL PROTECTED]
Sent: Thursday, May 30, 2002 9:43 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Advice needed please
Thanks Dennis.
Anything whether it be a reaction or an answer,
is welcome.
Regards
Lee
-Original Message-
Sent: 30 May 2002 15
Oracle 8.0.5
Tru64 4.0f
One of our developers here is writing a utility to provide fast unloads of
tables (to replace fastunloader as it happens)
His problem is as follows. Start from the bottom and work your way up. I
would be really grateful if anyone can offer up some alternatives for us.
Lee - Just some reactions, few answers.
- Generally a process like this will be disk-bound, not CPU-bound, so idle
CPU time is to be expected unless your disk is REALLY fast.
- Multiple simultaneous full-table scans may not be any faster because the
disk heads may need to flit to and fro in
Thanks Dennis.
Anything whether it be a reaction or an answer, is welcome.
Regards
Lee
-Original Message-
Sent: 30 May 2002 15:08
To: Multiple recipients of list ORACLE-L
Lee - Just some reactions, few answers.
- Generally a process like this will be disk-bound, not CPU-bound,
, 2002 9:43 PM
To: Multiple recipients of list ORACLE-L
Subject: RE: Advice needed please
Thanks Dennis.
Anything whether it be a reaction or an answer, is welcome.
Regards
Lee
-Original Message-
Sent: 30 May 2002 15:08
To: Multiple recipients of list ORACLE-L
Hello!
In my unix system (hp ux 10.20) I have one particular
file will be generated from some applications every
day.
File name MATERIAL.20020508225043
I usually deleted one month old files with rm
*200203* command ( I need to keep last month files 04
and delete all older than that). Can any
In my unix system (hp ux 10.20) I have one particular
file will be generated from some applications every
day.
File name MATERIAL.20020508225043
I usually deleted one month old files with rm
*200203* command ( I need to keep last month files 04
and delete all older than that). Can any
find dir -name MATERIAL.* -mtime +30 -exec rm -f {} \;
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Thursday, May 09, 2002 6:43 PM
Hello!
In my unix system (hp ux 10.20) I have one particular
file will be generated from some applications
-- Tim Gorman [EMAIL PROTECTED]
find dir -name MATERIAL.* -mtime +30 -exec rm -f {} \;
Main problem with this is forkatosis if there are too many
files. Using xargs breaks the rm's up into fewer proc's
and tends to run faster since the rm command can access
top-level dir's a single time for
8.1.7
(4c) Migrate the existing database.
Any pros, cons, or suggestions with respect to what I've laid out here?
As always, thank you very much in advance for all the sound advice you've
historically offered.
Jim Damiano
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
export from #2
Or Option 3:
(3c) Install Oracle 8.1.7
(4c) Migrate the existing database.
Any pros, cons, or suggestions with respect to what I've laid out here?
As always, thank you very much in advance for all the sound advice
you've
historically offered.
Jim Damiano
--
Please see
) |
| Subject: Advice on going about a minor |
| upgrade. |
|
Greetings fellow-DBAs,
We have a web application which exists on a Windows/NT 4 box running Oracle
Standard Server 8.1.6
Thank you Sergey ..
Bunyamin K. Karadeniz
Oracle DBA / Developer
Civilian IT Department
Havelsan A.S. Eskisehir yolu
7.km Ankara Turkey
Phone: +90 312 2873565 / 1217
Mobile : +90 535 3357729
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Saturday,
Dear Gurus , I need your help ..
I run UTLBSTAT and then after 2 hour run the
UTLESTAT.sql scripts as internal and look at the report.txt generated
...
On report.txt , I see that
System wide wait events for background processes:
System wide wait events for non-background
processes :
Bunyamin - I went to http://www.google.com http://www.google.com and
searched for utlbstat and received 1,050 results. I would recommend that
you try the same and read up on the resources available over the Internet. I
would also recommend the book Oracle Performance Tuning 101 by Gaja Krishna
Hello Bunyamin,
1) These values are values between starting utlbstat and utlestat (not
from database startup).
2) It's impossible to make all wait events=0. Importance of different
events depends on what database you have (OLTP, DSS, mixed).
Optimims for wait events are zero wait time :-)
You
Stephane - You comment we may have too much pinned and you're probably right there.
Currently our pinning is done by a startup trigger than pins packages, procedures,
functions and triggers (this is what I meant by objects) and I took the simple to
code and ensure it pins everything that
on Sunday 21st
and problem persisted a=
nd I decided to restart the instance around 11:30am
Sunday 21st.=0D
=0D
What I would like is some advice on what other
information I should collect=
next and advice on any settings that may need
altering.=0D
Bruce,
You mention that you have all of your
2002 22:23:18Our production instance started getting ora-4031errors around 6pm on Frida=y 19th.=0DI was called by our users around 9am on Sunday 21stand problem persisted a=nd I decided to restart the instance around 11:30amSunday 21st.=0D=0DWhat I would like is some advice on what otherinformatio
Our production instance started getting ora-4031 errors around 6pm on Friday 19th.
I was called by our users around 9am on Sunday 21st and problem persisted and I
decided to restart the instance around 11:30am Sunday 21st.
What I would like is some advice on what other information I should
If the tables are all analyzed, and cost-based optimizer is enabled,
the order in the FROM clause does not matter (it would matter only if
you added an /*+ ORDERED(...) */ hint.
I'm not sure what you mean by your question about guidelines in the
predicate. I assume you're trying to tune the
Don't forget that Oracle has redesigned the whole
area of hash buckets and hash latches.
In 8.1, the number of buckets is roughly 2 x db_block_buffers,
but each latch covers multiple buckets (don't forget that
a latch is about 160 bytes, so a noticeable amount of
memory overhead)
Because each
, 2002 7:14 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: Perf Advice Needed: cache buffers chains, high waits,
_db_block_hash_buckets
[Mogens Nørgaard]
Amen. Contention for cache buffers chains means too much logical
IO,
ie. find and exterminate heavy SQL.
I don't
James Manning wrote:
[Mogens Nørgaard]
Amen. Contention for cache buffers chains means too much logical IO,
ie. find and exterminate heavy SQL.
I don't see why the heavy SQL would result in the chain having 66 buffer
heads in it, though, or why the sleep count would be so skewed.
was that with so much activity going on on this small table, the
latching would never be fully eliminated, and it was poorly designed code.
I just want to check that everyone agrees with me, or would you expect to be
able to eliminate the waits even under these conditions?
Thanks for your advice,
Jim
be fully eliminated, and it was poorly designed code.
I just want to check that everyone agrees with me, or would you expect to be
able to eliminate the waits even under these conditions?
Thanks for your advice,
Jim
-Original Message-
Manning
Sent: 28 February 2002 17:14
advice,
Jim
-Original Message-
Manning
Sent: 28 February 2002 17:14
To: Multiple recipients of list ORACLE-L
_db_block_hash_buckets
[Mogens Nørgaard]
Amen. Contention for cache buffers chains means too much logical
IO, ie. find and exterminate heavy SQL
don't get the feeling that's the
right fix.
Anyone have any advice to offer? Pages/URL's that can help give some
advice?
It's worth noting that these latches are basically non-existant as
wait events at low load - log file sync is about the only wait
event I see at low loads, and I'm working
ut since the sleps are so heavily skewed to only a few of the children as it stands, I don't get the feeling that's the right fix.Anyone have any advice to offer? Pages/URL's that can help giv
e someadvice?It's worth noting that these latches are basically non-existant aswait events at low
[Mogens Nørgaard]
Amen. Contention for cache buffers chains means too much logical IO,
ie. find and exterminate heavy SQL.
I don't see why the heavy SQL would result in the chain having 66 buffer
heads in it, though, or why the sleep count would be so skewed.
And my core question is
James Manning [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
02/28/02 09:13 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:Re: Perf Advice Needed: cache buffers chains, high waits,
_db_block_hash_buckets
?
- the number of children for cache buffers chains is 4096. Now,
increasing that could have a positive effect on distributing the
contention, but since the sleps are so heavily skewed to only a few
of the children as it stands, I don't get the feeling that's the
right fix.
Anyone have any advice
Title: OT: Need Hardware advice under Linux
Hi List,
I want so setup new oracle server (for developement) under linux. I will install RedHat 7.1. What I like to know is what processor should I choose
AMD Athlon 1,4 Ghz or Intel 1,5 Ghz, I would prefer AMD.
Are there any know problems
We have a requirement to run some of the functionality of our application
automatically when the database starts up. Basically to run some PL/SQL.
What is the best approach to this?
T.I.A.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: John Dunn
INET: [EMAIL
Invoke a startup trigger on 8i above
John Dunn wrote:
We have a requirement to run some of the functionality of our application
automatically when the database starts up. Basically to run some PL/SQL.
What is the best approach to this?
T.I.A.
--
Please see the official ORACLE-L
by: Subject: Re: ORA-00600 on
Production DB - Need advice
[EMAIL PROTECTED]
08/06/2001 02:23
PM
Please respond to
ORACLE-L
Try calling on your tar
I thought that was the question, how to get service on an ITAR. Oh well, it
was Monday after all.
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 5:12 PM
Ruth Gramolini wrote:
1-800-223-1711
I have what used to
]
Sent by:
cc:
[EMAIL PROTECTED]
Subject: Re: ORA-00600 on Production DB - Need
advice
.tenet.edu
:
[EMAIL PROTECTED]
Subject: Re: ORA-00600 on Production DB - Need
advice
.tenet.edu
Try calling on your tar. That is what they have told me to do. Just waiting
doesn't help!
Ruth
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Monday, August 06, 2001 1:58 PM
Mondays, gotta love em, they make Fridays worth the wait. I've got a
This may not be related to your problem. My shop had problem with 8.1.7,
HP-UX 11.0 - 32 bit. We encountered memory leak bug. Oracle knew about it
and had not had a patch yet, I think. So we disable the db handle caching.
-Original Message-
[mailto:[EMAIL PROTECTED]]
Sent: Monday,
to lose time on support, upload yourself
first. if you can not find your bug, send iOraBugFinder results to support.
iOraBugFinder has capability of sending emails.
I'm planing some other web based db utils. if you have a product advice, don't
hesitate to email me.
6/8/01 09:50:37, Deshpande
PROTECTED] Subject: Re: ORA-00600 on
Production DB - Need advice
.tenet.edu
by:Subject: RE: ORA-00600 on Production
DB - Need advice
[EMAIL PROTECTED
-00600 on Production
DB - Need advice
[EMAIL PROTECTED
- Need advice
.tenet.edu
08/06/2001 12:44 PM
Hi David,
To get the proper output for ulimit, use
/usr/bin/ulimit -a
or
sh ulimit -a
Also the following information should help in trying to debug the problem.
1. Total
by: Subject: RE: ORA-00600 on Production DB -
Need advice/Still
[EMAIL PROTECTED]Searching
om
by: Subject: Re: ORA-00600 on
Production DB - Need advice
[EMAIL PROTECTED]
08/06/2001 02:23
PM
Please respond to
ORACLE-L
Try calling on your tar. That is what they have told
by: cc:
[EMAIL PROTECTED] Subject: Re:
ORA-00600 on Production DB - Need advice
.tenet.edu
08/06/2001 12:44 PM
Hi David,
To get the proper output for ulimit, use
/usr/bin/ulimit -a
or
sh
Ruth Gramolini wrote:
1-800-223-1711
I have what used to be Silver Support and that works. When I had wht used
to be Bronze Support I didn't have an 800 number.
Good luck!
Ruth
and they are going to tell you that you have to file an iTAR with
metalink first.
--
Bill Shrek Thater
Hi Listers,
(Thanks Abardeen1 for your help!)
However, I need to be cautious because this problem is on our production
database.
This is what I found after investigating the solution details:
I searched for catnoqueue.sql in CATALOG.SQL and CATEXP.SQL which are the
scripts that I had
Hello all,
Again turning to the wisdom of the list.
I'm looking for information on database developments and application
development practices. You know the DBA vrs developer thing this list loves
so much.
Any good resources you know about that I can look into? Any good
methodologies you
Hi Dict,
Thanks for your advice;
As you suggested supposing, I found out few inefficient SQL, corrected those
SQL,
compiled it in both Schema and run Payroll in both Schema,
Will the time difference(6-9 Minutes) be Solved ? Because I have already
6-9 Minutes time diffrenece in my hand prior
: Saturday, April 28, 2001 11:00 AM
To: Multiple recipients of list ORACLE-L
Hi Dict,
Thanks for your advice;
As you suggested supposing, I found out few inefficient SQL, corrected
those
SQL,
compiled it in both Schema and run Payroll in both Schema,
Will the time difference(6-9 Minutes) be Solved
parameter,same
index ,and also analyzed. The question is why in One User
it runs in 22-24 Min and in another 30-34 Min ?
Now Please advice me what do I check or to do, so that the it time
takes
to run comes down to 22-24 Min, same as the new user.
Oracle 8.1.4
Optimize goal : choose
in 22-24 Min and in another 30-34 Min ?
Now Please advice me what do I check or to do, so that the it time
takes
to run comes down to 22-24 Min, same as the new user.
Oracle 8.1.4
Optimize goal : choose
Biggest table haiving record less than 6 rows.
Thanks in Advance
30-34 Min ?
Now Please advice me what do I check or to do, so that the it time takes
to run comes down to 22-24 Min, same as the new user.
Oracle 8.1.4
Optimize goal : choose
Biggest table haiving record less than 6 rows.
Thanks in Advance
Naba
This e-mail and any files transmitted
Improvement.
At this stage every table in both user has same storage parameter,same
index ,and also analyzed. The question is why in One User
it runs in 22-24 Min and in another 30-34 Min ?
Now Please advice me what do I check or to do, so that the it time
takes
to run comes
at New User. Still no visible Improvement.
At this stage every table in both user has same storage parameter,same
index ,and also analyzed. The question is why in One User
it runs in 22-24 Min and in another 30-34 Min ?
Now Please advice me what do I check or to do, so that the it time takes
to run
as the one created at New User. Still no visible Improvement.
At this stage every table in both user has same storage parameter,same
index ,and also analyzed. The question is why in One User
it runs in 22-24 Min and in another 30-34 Min ?
Now Please advice me what do I check or to do, so
,and also analyzed. The question is why in One
User it runs in 22-24 Min and in another 30-34 Min ?
Now Please advice me what do I check or to do, so
that the it time takesto runcomes down to 22-24 Min, same as the new
user.
Oracle 8.1.4Optimize goal : chooseBiggest
table haiving record less
ing to avoid the fun and games I've had this week, any
advice?
Thanks guys
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Pu
would you reccomend backing up to? CD (aahhemmm!!), network
drives, seperate directory?
I'm really just trying to avoid the fun and games I've had this week, any
advice?
Thanks guys
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED
!!), network
drives, seperate directory?
I'm really just trying to avoid the fun and games I've had this week, any
advice?
Thanks guys
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538
g in ARCHIVELOG MODE is
there?
Also, where would you reccomend backing up to? CD (aahhemmm!!), network
drives, seperate directory?
I'm really just trying to avoid the fun and games I've had this week, any
advice?
Thanks guys
Mark
--
Please see the official ORACLE-L FAQ: http://www.orafaq.c
: referenced name org/omg/CORBA/BAD_TYPECODE could not be
found
ORA-29521: referenced name org/omg/CORBA/MARSHAL could not be found
ORA-29521: referenced name org/omg/CORBA/ORB could not be found
Any advice ?
Regards
Henrik
SHAL could not be found
ORA-29521: referenced name org/omg/CORBA/ORB could not be found
Any advice ?
Regards
Henrik
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Henrik Ekenberg
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 53
101 - 169 of 169 matches
Mail list logo