Add this to what Arup said:
PK enables one to have References established in a schema. (Parent Child
relationships i mean). That cannot be done just by having a unique
and/or
not null constraints set.
You will get ORA-02270: no matching unique or primary key for this
column-list
HTH
GovindanK
richt-
Van: Ryan [mailto:[EMAIL PROTECTED]
Verzonden: donderdag 22 januari 2004 11:05
Aan: Multiple recipients of list ORACLE-L
Onderwerp: Re: Re: pga_aggregate_target and a memory leak
Im not sure I see what the size of the PAT has to do with a memory leak. On
metalink there is a laundry li
AIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/2004 09:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: What to look for in STATSPACK report
Jared,
I played YAPPPACK qui
Joe,
I didn't do that many, but the 6 or so times that I have used it, it
worked fine.
>From what I read, it basically does a startup restrict, IIRC.
Have fun,
Stephen
>>> [EMAIL PROTECTED] 01/22/04 02:29PM >>>
Joe - I just know that it works. I used it to upgrade about 20
instances.
Dennis
TED]
01/22/2004 09:19 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: What to look for in STATSPACK report
Jared,
I played YAPPPACK quite often some time ago. I like it very
Joe,
You did not mention about platform.
I just did migration from 8.1.7.4 to 9.2.0.4 today on Windows. That upgrade
was manul.
After connecting with database
you have to issue command
startup migrate pfile=init_SID.ora file. Please give complete/absolute path
of this file.
However, I have
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540/statements_15a.htm#2110144
MIGRATE
Use the MIGRATE clause only if you are upgrading from Oracle release 7.3.4
to the current release. This clause instructs Oracle to modify system
parameters dynamically as required for the upg
oops!
wrong list, eh? :)
"EPS - DBA (Group)" <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/2004 11:39 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: test please igno
Joe,
Here's brief from metalink.. for details Check this
Doc ID: 252273.1
STARTUP MIGRATE was introduced in 9.2 as a mechanism to be sure that most
everything that needs to be done to run an upgrade script or a patch
script is done automatically. In the past, customers were expected to
adjust
Joe - I just know that it works. I used it to upgrade about 20 instances.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 3:14 PM
To: Multiple recipients of list ORACLE-L
I'm looking at the notes to apply patch 4 to Oracle 9.2.
D]
[mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004
3:09 PM
To: Multiple recipients of list
ORACLE-L
Subject: RE: !!Please Read -
Oracle-L is moving!!
Give it a little time, you'll get it.
Jared
"Arnold, Sandra"
<[EMAIL PROTECTED]>
Sent
PROTECTED]>
cc:
Subject: Re: How to get unique value using AWK?
There is much improved version of awk called "perl"
and it has something called hashes. Code snippet would
look something like this:
my %Godot;
while (<>} {
chomp;
if (/\'([^\'
;s load has
> hit it.
>
> Paul
>
> this was on w2k server sp3, 9.2.0.4 std ed
>
>
> > > > From: Kirtikumar Deshpande
> > <[EMAIL PROTECTED]>
> > > > Date: 2004/01/21 Wed PM 02:44:31 EST
> > > > To: Multiple recipients of list
Jonathan
Thanks so much for posting this excellent article. Very high quality as
all your writing is. This was my devious purpose in replying, in hopes
something like this was out there.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January
dagni,
Rajendra" To: Multiple recipients of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE:
a version of Outlook
2003...
Tim
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] Sent: Thursday, January 22, 2004
2:39 PMTo: Multiple recipients of list ORACLE-LSubject:
Re: !!Please Read - Oracle-L is moving!!
Well, I did check with them first to
ensure the volume would be OK. It is
runn
cc:
Subject: RE: !!Please Read - Oracle-L is moving!!
I went through the webpage but never got the confirmation email back
containing the code to be entered.
-Original Message-
Sent: Thursday, January 22, 2004 2:00 PM
To: Multiple recipients of list ORACLE-L
It's wor
stance, no ORA-00600's were recorded at instance
> shutdown. That was not really a good test though, will
> have to see tomorrow evening after the day's load has
> hit it.
>
> Paul
>
> this was on w2k server sp3, 9.2.0.4 std ed
>
>
> > > > Fro
Chris - In Excel, click on Data --> Text to Columns.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 1:00 PM
To: Multiple recipients of list ORACLE-L
I had this same problem. It ended up being that when I opened the file in
exe
I went through the webpage but never got the confirmation email back
containing the code to be entered.
-Original Message-
Sent: Thursday, January 22, 2004 2:00 PM
To: Multiple recipients of list ORACLE-L
It's working for me, but slowly. I tried to do it through the webpage and
got the
L PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/2004 10:24 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject: Re: !!Please Read - Oracle-L is moving!!
The list members must be rea
I came across a very nice example a while ago
where there were 4 concurrent sessions feeding
data into a holding table, and one session consuming
from the table.
The rules said that the consumer could not run
while the producers were loading the table, but
multiple producers were allowed to run.
It's working for me, but slowly. I tried to do it through the webpage and got the
first confirmation e-mail back (containing a code to enter on the webpage.) Then I
subscribed to the new list, got a second e-mail back to confirm my subscription, and
replied to that. I'm sure more things will sho
I had this same problem. It ended up being that when I opened the file in
exel, all the columns from the csv went into one excel column and for some
reason it wasn't apparentor something like that. .now if I could
only remember what it was I did to fix it. hmmm.
..i think it was some sea
But you better check with experts as my knowledge of x$ is feather-weight ... also
there is a column on x$kglob called kglhdexc ... to me it seems the execution count (I
feel like "Mr. Monk" already). so if execution count is > 0 then you can say that it
actually got executed.
But if this does
Johnathan,
Very interesting article. I especially like the parts where it is not
our fault it is designed that way. I agree that with proper thought and
trial, a lot of perceived performance issues can be eliminated or
minimized.
I could really use the compress option, I guess that I will have to
Reminder to post to freelists.org per Jared - I'm crossposting this reply.
Jay
Pipe your output to sort, then uniq.
grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 " " $5 "
"$6}'|sort|uniq
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thur
Jonathan:
I'd go a bit further than that. Your article is
fantasitic.
I've read "How to stop defrag ..." several times. It
just never clicked for me.
I've been migrating to LMT using your article, and
it's been great. It's crystal-clear, and I really
appreciate the examples.
Thanks!
Barb
---
ts of list
ORACLE-L <[EMAIL PROTECTED]>
Subject: RE: How to find the
last execution time of a Procedure.
Since you're doing an aggregate function, you may want to investigate
using materialized views here. Since, I'm assuming, policy
effective dates aren't something that changes on a minute-to-minute
basis, you could set up a materialized view that refreshed every night
and would answer this questi
The list members must be really hammering their servers now. I've tried to sign up
using both the
web and email methods and have yet to receive a conformation/response.
I can see the headlines now, "oracle-l slashdots freelists.org"
;-)
Ron Thomas
Hypercom, Inc
[EMAIL PROTECTED]
"The box said
Thanks Kirti and everyone who responded.
This forum is really great.
- Original Message -
Date: Thursday, January 22, 2004 12:14 pm
> Why not process the trace file with 9i tkprof?
> It will nicely summarize the wait times for those events.
> After seeing those unique wait events, your
Comments in line.
On 01/22/2004 12:24:26 PM, Tracy Rahmlow wrote:
This statement is from a batch program within a pl/sql procedure.
(Also, I
have many similar ones within the process) The policy table has
approximately 6.2 million rows. The procedure is to
incrementally(daily)
build an extract ta
Bruce,
Thanks for all your work, support, and honesty. It's appreciated.
Henry
-Original Message-
Bruce A. Bergman
Sent: Thursday, January 22, 2004 11:14 AM
To: Multiple recipients of list ORACLE-L
Yes, this is legitimate.
Jared and I have been talking recently about this. This list
it depends on how the code is written ... maybe it is doing row
operations ... care to show the code (at-least pseudo code)
??
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
That goes both ways, my friend. :)
-Original Message-
Sent: Thursday, January 22, 2004 11:40 AM
To: Multiple recipients of list ORACLE-L
On 01/22/2004 12:04:35 PM, "Bellow, Bambi" wrote:
> uniq is not ubiq. If uniq doesn't do it for you, do sort -u
Why would you things that way when
Jay -
Try:
$ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 " " $5 " "$6}' |
sort | uniq | more
HTH,
Dave
> Hi All,
>
> My manager wants to get all the unique wait events from the trace file.
> I tried the below but how do i get DISTICT wait event name?
>
> Any help would be really
On Thu, 2004-01-22 at 10:09, [EMAIL PROTECTED] wrote:
> Hi All,
>
> My manager wants to get all the unique wait events from the trace file.
> I tried the below but how do i get DISTICT wait event name?
>
> Any help would be really appreciated.
>
grep -i WAIT devdb1_ora_989.trc_orig|awk '{print
On 01/22/2004 12:04:35 PM, "Bellow, Bambi" wrote:
uniq is not ubiq. If uniq doesn't do it for you, do sort -u
Why would you things that way when you can do them in perl?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mladen Gogala
INET: [EMAIL PROTECTED]
Fat City Networ
Too bad Steve Adams' site is not available, cuz that's
the place to be.
He says it better than I can, so I've appended a bit
of info from him. I'd suggest getting to Steve's site
as soon as it's up.
We have monitoring enabled on our 9.2.0.4 database,
but it's not currently heavily used. But so
Why not process the trace file with 9i tkprof?
It will nicely summarize the wait times for those events.
After seeing those unique wait events, your boss may ask for the wait times next!! Be
proactive
:)
- Kirti
--- "Simpson, Ken" <[EMAIL PROTECTED]> wrote:
> > -Original Message-
Jared,
I played YAPPPACK quite often some time ago. I like it very much. But
somehow I failed to generate the gif file from the csv file as sample
shown. Can someone shade me some light on this? I tied very hard to make
the graphs from the csv file but just don't know how.
Thanks,
Joan
Jared St
uniq is not ubiq. If uniq doesn't do it for you, do sort -u
-Original Message-
Sent: Thursday, January 22, 2004 10:34 AM
To: Multiple recipients of list ORACLE-L
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent:
Try this ...
$ grep -i WAIT devdb1_ora_989.trc_orig|awk '{print $3" " $4 " " $5 " "$6}'|
sort -u
Thanks,
Nikhil
-Original Message-
Sent: Thursday, January 22, 2004 11:09 AM
To: Multiple recipients of list ORACLE-L
Hi All,
My manager wants to get all the unique wait events from the
The number of rows affected by an SQL statement
is something that has been available to Oracle for
a long time. Monitoring just records that number in
a memory structure.
I'd guess the memory structure is a hash table, and
there are no latches protecting it (so I've heard, and
I can't see any in
Jared and Bruce: Thanks for everything.
Waleed
-Original Message-
Sent: Thursday, January 22, 2004 11:14 AM
To: Multiple recipients of list ORACLE-L
Yes, this is legitimate.
Jared and I have been talking recently about this. This list has just
outgrown what Fat City can handle. While
I think
http://www.jlcomp.demon.co.uk/08_lmt.doc
is pretty good, but I'm biased.
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearanc
On Thu, 2004-01-22 at 10:34, Simpson, Ken wrote:
> How about piping it through uniq?
uniq normally assumes the input is sorted. See my other response.
Best,
--
Edward Simmonds RHCE, OCP
- Real men don't send html email.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
There is much improved version of awk called "perl"
and it has something called hashes. Code snippet would
look something like this:
my %Godot;
while (<>} {
chomp;
if (/\'([^\']+)/ {
next if exists $Godot{$1};
$Godot{$1}=undef;
}
}
foreach (sort keys %Godot) {
print "$_\n";
}
On 01/22
> Paul
>
> this was on w2k server sp3, 9.2.0.4 std ed
>
>
> > > > From: Kirtikumar Deshpande
> > <[EMAIL PROTECTED]>
> > > > Date: 2004/01/21 Wed PM 02:44:31 EST
> > > > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECT
Well, I don't know about anyone else, but I make use of it to synchronize data upload
programs for our testers. Can't have two instances of the upload program processing
the same tester, they'd duplicate data. Anyhow, we normally run 4 instances of this
program & the dbms_lock package works ab
not easily, but you could probably scan through x$kglob (frequently) and see if the
name exists ... if it is, it means it was loaded for execution.
Another solution might be to modify old code and have them add a row in a separate
table using autonomous transaction to indicate they got executed.
pipe it through uniq
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having an opinion is an art !
-Original Message-
> -Original Message-
> From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
> Behalf Of [EMAIL PROTECTED]
> Sent: Thursday, January 22, 2004 11:09 AM
> To: Multiple recipients of list ORACLE-L
> Subject: How to get unique value using AWK?
>
>
> Hi All,
>
> My manager wants to get all th
Bruce,
I think I'd characterize the service provided as great, period. Sure we've
had the odd hiccup now and again, but on the whole it has been great. Thanks a whole
lot, your work has been and is appreciated.
Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA
-Original Messa
Yes, this is legitimate.
Jared and I have been talking recently about this. This list has just outgrown what
Fat City can handle. While I'd like to think that I've always provided
adequate-to-good service for the list, it's never been "great", and with the list
growing, and traffic growing, m
We need to start moving these discussions to freelists per Jared's note.
Brad - I agree with Ron. I think it is critical to read "How to quit
defragmenting . . ." before making the change to ensure you clearly
understand the concepts and receive the benefits. If someone on the list
knows of a more
Brad,
For LMT's I prefer uniform sizing that I can define to meet the needs
of the data. If you use automatic the extend sizes will change
drimatically as the number if extends increase. With a little planning
you can have little waste in the tablespace and use the tablespace for
multiple tables o
On 01/22/2004 09:59:27 AM, "Adams, Matthew (GECP, MABG, 088130)" wrote:
Is anyone else having problems with Metalink this morning
or is it just us? We can't log in at all.
It's just you. What did you do to Larry to punished in such a way?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.
Ryan - Can you provide more details? Typically ksh scripts are much, much
more efficient than alternate methods, such as manipulating data within the
database. Depending on which method you are using to measure CPU usage, you
may be seeing 1/4 of one CPU. But even if your script is using a full CPU
list ORACLE-LSubject: RE:
Metalink on the blink
A
little slow, but nothing out of the ordinary.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Adams, Matthew (GECP,
MABG, 088130) [mailto:[EMAIL PROTECTED]Sent: Thursday,
January
Title: Metalink on the blink
not me ... it is working fine ...
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this email
are strictly personal. QOTD: Any clod
can have facts, having an
Title: Metalink on the blink
Painfully slow, but it works.
-Original Message-
From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 22, 2004
9:59 AM
To: Multiple recipients of list
ORACLE-L
Subject: Metalink on the blink
Is anyone else
Ryan,
Could you cat the second file on to the end of the first file and have
the data load successfully?
cat file2 >> file1
How about a second box to perform the editing of the data file.
Something that resource intensive and manditory should not have a
problem getting funded.
Ron
>>> [EMAIL PR
considered Perl ?? also the load you mention is for what? adding data to the data file
you get or loading into the db??
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly
Matthew - Works fine for me.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 8:59 AM
To: Multiple recipients of list ORACLE-L
Is anyone else having problems with Metalink this morning
or is it just us? We can't log in at
Yes indeed, it is genuine.
Jared
On Thu, 2004-01-22 at 00:29, Venu Gopal wrote:
>
> Is this a genuine mail...? I'm a part of the list.
>
> -Original Message-
> Sent: Thursday, January 22, 2004 1:56 PM
> To: [EMAIL PROTECTED]
>
>
> Dear Oracle-L subscriber,
>
> Due to changing circums
I've just logged in and reviewed an old TAR and did a survey on a closed
TAR.
Maybe it's you :)
>>> [EMAIL PROTECTED] 01/22/04 07:59AM >>>
Is anyone else having problems with Metalink this morning
or is it just us? We can't log in at all.
Matt
Matt Adams - GE Appliances - [EMAIL PROTECTED
Title: Metalink on the blink
I avoid the log in problem... I just stay logged in all week. Saves
time in the long run. It is running REALLY slowly, though... (I was
putting that down to our crappy network) and I logged out and back
in... Nope... It's just you Matt!
=)
April Wells
Title: Metalink on the blink
A
little slow, but nothing out of the ordinary.
Dick GouletSenior Oracle DBAOracle Certified 8i
DBA
-Original Message-From: Adams, Matthew (GECP, MABG,
088130) [mailto:[EMAIL PROTECTED]Sent: Thursday, January 22,
2004 9:59 AMTo: Multiple recipie
comments in line... I may need correction from some of you on this.
> -Original Message-
> Sent: Wednesday, January 21, 2004 9:39 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Wondering if there is a "rule of thumb", quick'n fast but good enough
> to be used as an indicator, litmu
The easiest way to write code for me is to use a text editor and sqlplus, always works
for me.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod
Thanks Alexander. I wasn't aware of this new feature. It will certainly make
my script much simpler.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
[mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 3:49 PM
To: Multiple recipients of list ORACLE-L
Branimir
Beware of simple ratios.
The logic is seductive. It seems likely that an easy way to find
unnecessary indexes is to look at a ratio such as you describe. And it
shouldn't pose much load on a system to do a quick report on ratio. But what
would it mean in practice? Just go around d
Paul,
Most of my work is on HP-UX and AIX.
I have yet to see any ORA-600 and memory leaks related to P_A_T. All databases that I
work with
are on 9.2.0.4, except just one running on 9.2.0.3. No memory leak there either.
- Kirti
--- Paul Drake <[EMAIL PROTECTED]> wrote:
> --- Kirtikumar Desh
Enable auditing on COMPANY?
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (Derek Bok)
===
> Hallo everyone,
>
> I have the table system_change
>
> and I I have the insert statement here below be run when there is an
> update or insert of a value in any ofthe field
Just remember these words about global contexts ... 'doesn't work correctly in RAC'
...
A global context is "global" only within instance ... not across.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views e
Thank You Jonathan.
Syed
- Original Message -
To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
Sent: Thursday, January 22, 2004 1:29 PM
> Note in-line
>
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>
> The educated person is not the person
> who can ans
Yes indeed It is.. :)
-Original Message-
Venu Gopal
Sent: Thursday, January 22, 2004 1:59 PM
To: Multiple recipients of list ORACLE-L
Is this a genuine mail...? I'm a part of the list.
-Original Message-
Sent: Thursday, January 22, 2004 1:56 PM
To: [EMAIL PROTECTED]
Dear Orac
I also tried this morning a few times and it was down.
-Original Message-
Sent: Thursday, January 22, 2004 12:04 PM
To: Multiple recipients of list ORACLE-L
ixora.com.au seems to be unavailable. Any clue?
Regards, Carel-Jan
===
If you think education is expensive, try ignorance. (
Notes in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC - O
this was on w2k server sp3, 9.2.0.4 std ed
>
>
> > > > From: Kirtikumar Deshpande
> > <[EMAIL PROTECTED]>
> > > > Date: 2004/01/21 Wed PM 02:44:31 EST
> > > > To: Multiple recipients of list ORACLE-L
> > <[EMAIL PROTECT
Note in-line
Regards
Jonathan Lewis
http://www.jlcomp.demon.co.uk
The educated person is not the person
who can answer the questions, but the
person who can question the answers -- T. Schick Jr
Next public appearance2:
March 2004 Hotsos Symposium - Keynote
March 2004 Charlotte NC - OUG
fires,
but the execution engine is committed to using
index X - which happens to be unusable, so the
statement fails.
On the second call, the session parameters have
changed, so Oracle re-parses the update, and
ignores the unusable index, choosing a different
plan. Consequently the update can work
Looking at the source (list owner) I'd say it is.
Jack
-Original Message-
Sent: Thursday, January 22, 2004 9:29 AM
To: Multiple recipients of list ORACLE-L
Is this a genuine mail...? I'm a part of the list.
-Original Message-
Sent: Thursday, January 22, 2004 1:56 PM
To: [EMAI
backup additionally is good as it still allows you to capture the
database structure}
Hemant
At 08:54 AM 21-01-04 -0800, you wrote:
Sorry it took so long to get back to you; I've been caching the list for
awhile
and am just starting to catch up. :-)
Page 43, in the grey box with title
this mean that I'm reading another myth? Couldn't confirm it on metalink.
Ta,
Leng.
---
From: "Jonathan Lewis" <[EMAIL PROTECTED]>
Date: Wed, 21 Jan 2004 07:20:30 -
Subject: Re: Oracle 8.1.7 can only use the first 15th indexes?
drop table t1;
cr
From: Kirtikumar Deshpande
<[EMAIL PROTECTED]>
> > Date: 2004/01/21 Wed PM 02:44:31 EST
> > To: Multiple recipients of list ORACLE-L
<[EMAIL PROTECTED]>
> > Subject: Re: pga_aggregate_target and a memory leak
> >
> > Replies in line...
> >
> &g
ate: 2004/01/21 Wed PM 02:44:31 EST
> > > To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> > > Subject: Re: pga_aggregate_target and a memory
> leak
> > >
> > > Replies in line...
> > >
> > > - Kirti
> > >
||
> > |-+>
> >
>
>---
> ---|
> > |
> |
> > | To: Multiple recipients of list
> ORACLE-L
&
03:09 |
> | | PM |
> | | Please respond to|
> | | ORACLE-L |
> | ||
> |-+>
>
>---
---|
> |
|
> | To: Mul
;
> > - Original Message -
> > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> > Sent: Wednesday, January 21, 2004 7:44 PM
> >
> >
> > > Replies in line...
> > >
> > > - Kirti
> > >
&g
Thanks for your reply Jonathan..Here is an update..
The update that i sent you yesterday is updating a column on which there
is a local bitmap index. There are also other local bitmsap indexes on
that partitions. Yesterday i made all the local indexes pertaining to
that partition UNUSABLE and we go
> Jonathan Lewis <[EMAIL PROTECTED]> wrote:
>
> Sounds like you just need each user to call allocate_unique
> on startup to get a group-specific handle, then do a
> request in exclusive mode before doing the job and
> a release on completion. Users will then naturally queue
> and resume with min
Hmm, that's actually a very good idea.
It might actually do the job here. Thanks.
Nuno Souto
[EMAIL PROTECTED]
> Jamadagni, Rajendra <[EMAIL PROTECTED]> wrote:
>
> if it is single instance you could also use global application
> contexts ... (alas they don't work in RAC across node) ...
>
--
Pl
gt;
> - Original Message -
> To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>
> Sent: Wednesday, January 21, 2004 7:44 PM
>
>
> > Replies in line...
> >
> > - Kirti
> >
> > --- [EMAIL PROTECTED] wrote:
> > >
When you have already contacted oracle support, you could have asked
them. It's their job to know that.
On 01/21/2004 05:24:28 PM, AK wrote:
Looks like we are hitting bug 3091541 ( As per oracle support ) .
getting ksedmp: internal or fatal error
ORA-00600: internal error code, arguments: [17281],
uary 21, 2004 7:44 PM
> Replies in line...
>
> - Kirti
>
> --- [EMAIL PROTECTED] wrote:
> > Kirti, you're back!
>
> Thanks. Found some slack time from routine DBA work!
>
> >
> > Must have finished the book. :)
>
> Not yet.. Its tough..
>
Yep!
Thanks,
Nikhil
-Original Message-
Sent: Wednesday, January 21, 2004 2:55 PM
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED] oriole]$ export AWK="awk '{print \$4}'"
[EMAIL PROTECTED] oriole]$ echo ${AWK}
awk '{print $4}'
[EMAIL PROTECTED] oriole]$ cal | awk '{print $4
301 - 400 of 71998 matches
Mail list logo