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
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 Oracle
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]
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 circumstances,
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
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
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
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
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
of 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
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
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:
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
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
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, my
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
-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 the unique
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-
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
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
evening after the day'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 ORACLE-L
[EMAIL PROTECTED]
Subject: Re: pga_aggregate_target and a memory
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/2004
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
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
--
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.
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
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 trace
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:
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
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-
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
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 Network
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 $3
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
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
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
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
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
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
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 I
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
ORACLE-L [EMAIL PROTECTED]
Rajendra.Jamadagncc:
[EMAIL PROTECTED] Subject: RE: How to find the
last execution time of a Procedure
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
---
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: Thursday,
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
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
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
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
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.
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 really hammering their servers now. I've tried to sign up using both
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
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
: 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...
- Kirti
--- [EMAIL PROTECTED] wrote:
Kirti
Give it a little time, you'll get it.
Jared
Arnold, Sandra [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
01/22/2004 11:49 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
Subject:RE: !!Please Read - Oracle-L
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
running a bit slow. I'm not sure
:
[EMAIL PROTECTED] Subject: RE: How to find the
last execution time of a Procedure.
Sent
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,
, 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
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
: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 (/\'([^\']+)/ {
next if exists $Godot{$1};
$Godot{$1}=undef;
}
}
foreach (sort
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
by: [EMAIL PROTECTED]
01/22/2004 11
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
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
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 ignore
Test new oracle-l
--
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
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 much. But
somehow I failed to generate the gif file
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
]
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 quite often some time ago. I like it very much. But
somehow
-
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 list
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
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
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
: 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...
- Kirti
--- [EMAIL PROTECTED] wrote:
Kirti
It's in the documentation. Do a search on 'startup migrate'. It's used to upgrade,
downgrade, or change the word size of the database.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 4:24 PM
To: Multiple
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
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 list of PGA things that were supposedly causing
memory leaks prior to 9.2.0.4. Are you
Govindan,
You can create FK relationship(Parent-child) by using UNIQUE constraint..
Correct me if I am wrong.
-Original Message-
Sent: Thursday, January 22, 2004 6:37 PM
To: Multiple recipients of list ORACLE-L; Multiple recipients of list
ORACLE-L
Cc: [EMAIL PROTECTED]
Add this to
time from routine DBA work!
Must have finished the book. :)
Not yet.. Its tough..
Re the PGA problems, what was the value for 'over allocation count' in
v$pgastat?
Actually, I never bothered to look at v$pgastat. Should have.. and will,
when we do some more
testing next week
DBMS_LOCK manipulates the same enqueue mechanism that Oracle uses for just
about everything. Same as every other type of lock shown in V$LOCK, just
type = UL.
Thus, any problems in DBMS_LOCK would be shared by just about every facet of
session-level concurrency in the RDBMS...
on 1/21/04 5:49
application (at least in
the beginning).
Appropriately enough, its name was DATA...
on 1/21/04 2:44 AM, Nuno Souto at [EMAIL PROTECTED] wrote:
Let's be realistic: any table with 15 indexes
PROBABLY needs a little bit of a re-design
exercise? ;)
Cheers
Nuno Souto
[EMAIL PROTECTED
If you're on 9i, external tables and pipelined table functions should be
useful...
on 1/22/04 7:59 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote:
We are getting a feed of an 800 MB file that will come in nightly. It needs to
be loaded to the database. Per requirements, we have to add some
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 ORACLE-L
[EMAIL PROTECTED]
Subject: Re: pga_aggregate_target and a memory
leak
Replies in line
Dear Bruce and Jared,
I appriciate your efforts whole heartedly.You have been doing a
GREAT job. It has been rewarding to be part of this community. This
forum has always helped us to understand a little bit more of Oracle.
Wishing the new incarnation of Oracle-l all success!!
Special
drop table t1;
create table t1
nologging
pctfree 50
pctused 50
as select
1 n01,
1 n02,
1 n03,
1 n04,
1 n05,
1 n06,
1 n07,
1 n08,
1 n09,
1 n10,
1 n11,
1 n12,
1 n13,
1 n14,
1 n15,
rownum n16,
lpad(rownum,10) v1
from all_objects
;
create index i01 on t1(n01);
create index i02 on
It's probably the case that the trigger fires
the first time - but at parse/optimise time
Oracle had already determined the sequence
of actions needed to execute the statement
based on the then session state, so that sequence
is played out, irrespective of the fact that you
changed the session
Hi Rhojel
Tjeck out: http://www.baarf.com/
Rgds, Frank
- Original Message -
From:
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, January 21, 2004 9:04
AM
Subject: Defragmenting a RAID 5
volume?
Hello people,
We recently
Mladen,
I agree you can measure how many IOs are being done and how many a disk sub-
system, such as those provided by EMC, can perform and still give good
performance. What I meant is that it is hard and some would say impossible to
estimate how many IOs per sec a new application will do. A
Let's be realistic: any table with 15 indexes
PROBABLY needs a little bit of a re-design
exercise? ;)
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
snip
(I assume the report intended to say the first 15
indexes on a specific table, 'cos the data dictionary
alone has
The first 15 indexes CREATED?
Joking, are they?
Cheers
Nuno Souto
[EMAIL PROTECTED]
- Original Message -
I've just been reading a report for one of our systems and it says that Oracle 8.1.7
will only use the first 15
indexes created. Any index created after the 15th will be ignored
' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, January 21, 2004 9:44 AM
Let's be realistic: any table with 15 indexes
PROBABLY needs a little bit of a re-design
exercise
When required I did it through a logon trigger ... wait I still do it.
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any clod can have facts, having
I've seen this sort of thing happen when you have more than one Oracle_Home and client
tools get confused about which tnsnames.ora file to use. Fastest solution is to find
every tnsnames.ora file on the client computer and make sure that they are all
identical. Correct solution is usually to
Hi John ,
i have mailed a doc . have a look at it .
Regards,
Prem.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Does anyone have examples of how to use bind variables in VB
when using
OO4O?
John
--
Please see the official ORACLE-L FAQ:
Gene,
I strongly recommend implementing Statspack.
It is very straight-forward.
Just do it when you have exclusive use of the database, or comment
out the following two lines in ora_rdbms_admin:SPCUSR.SQL if you have
these packages already installed.
(We're running 8.1.7 on
As in: does it present an inherent or hidden performance
problem when a lot of sessions try to lock/release the same
lock?
Will serialize perfectly!
Or how many lock/release per second. Or some other
idea of how efficient it is?
Depends on the work done between acquiring the lock and
On a light-weight test on 8.1.7.4 at 700MHz on W2000 -
About 15,000 request/release per second
if you are using an ID
About 8,000 request/release per second
if you are using a pre-allocated lock handle
About 800 request/release per second
if you have to allocate_unique on every
i think expert one on one has some comments on it. Its in a section referring to
building your own insert locks. So if a table is locked, the user gets notified.
I read the book last year.
From: Nuno Souto [EMAIL PROTECTED]
Date: 2004/01/21 Wed AM 07:49:25 EST
To: Multiple recipients of
, but I like it)... there is a
nifty wrapper for DBMS_LOCK. I based my code off of that.
From: Carel-Jan Engel [EMAIL PROTECTED]
Date: 2004/01/21 Wed AM 08:24:25 EST
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Re: Has anyone done any scalability work on dbms_lock
Either re-run catproc or try with utlirp.
On 01/20/2004 12:44:34 PM, Hamid Alavi wrote:
so what's the solution?
-Original Message-
Sent: Tuesday, January 20, 2004 4:10 AM
To: Multiple recipients of list ORACLE-L
Someone is messing with standard package ... so it would seem.
Raj
301 - 400 of 67344 matches
Mail list logo