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 t
Dear Guru's
I am frequently running tkprof of a PL/SQL program and I would
like to have a repository of Tkprof output. I would like to build a
utility that would parse the tkprof output into different areas and
store it in the database.
Say we can split the tkprof output into
1. Stateme
It is 9.2.0.4 running on Sun Solaris Version 8. What is strange I can
filter and sync the same documents on my test database without getting the
errors. The test database is the same version but the patches on the OS is
more up-to-date.
Sandra
-Original Message-
Sent: Thursday, January
Hi,
I am generating the trace using the event 10046, level 12. In the
trace file I am seeing "Row source operation" following by "execution
plan". What is the different between these 2, as I am seeing diffent
execution plan for both of them?
Thanks and Regards,
Satheesh Babu.S
DISCLAIMER:
This
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
Amen to that. I had a table with about 40 indexes on v7.0.16. I don't
think that it was possible that any of them could have been "ignored",
because all of them were used. I can't verify that, because this system was
born and died (subsequently cremated) over 10 years ago and I never thought
to
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:4
So, my intention to set P_A_T to 140G on a new datawarehouse is ill-advised?
I'm not kidding, by the way. The Sun E15K belonging to the project I'm
currently working on (purportedly) has 160G of RAM. It is still in the box,
so I'm not believing anything until I type "prtconf"...
I wasn't planni
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 what
I am interested in the bug number. Currently am having memory problems that
may be related to the pga.
Sandra
-Original Message-
Sent: Thursday, January 22, 2004 5:09 PM
To: Multiple recipients of list ORACLE-L
Yes I have and still have a problem with pga memory leak
When using pl/sql
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
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 recipients
Sandra - Are you on 9.2.0.4?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 10:44 AM
To: Multiple recipients of list ORACLE-L
I have had a problem on my 9i database for three weeks. I am getting a
ORA-7445 error which is point
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
ex
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.
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
Yes I have and still have a problem with pga memory leak
When using pl/sql tables. I'm on 9i performance and tuning course at oracle
Now and discussed this with the teacher. He went looking and found a bug
Stating that on 9i (9.2.0.2 and further) there seems to be a limit on total
pga per process o
If you're willing to go to the trouble of setting up Perl, DBI, DBD::Oracle, DBD::Chart
and its dependent libs ( graphics ), I'll send the Perl/Shell stuff I use to generate charts.
It includes some modifications to YAPPPACK.
That sound OK Mogens?
Jared
Joan Hsieh <[EMAIL PROTECTED]>
Se
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
Here's a sample chart. These are generated every morning and available via our intranet.
http://www.cybcon.com/~jkstill/yapppack_chart.png
Hmmm...
Looks like someone is doing a lot of commits at 02:30 and 05:15.
Jared
Joan Hsieh <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/2
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.
I subscribed by the
“send
email to [EMAIL PROTECTED] with 'subscribe' in the Subject field”
method and received confirmation within an hour.
David
Phillips
Support DBA
Gasper
937-445-1382
[EMAIL PROTECTED]
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMA
And please notice that no sorting of the input is required, unlike awk|sort|uniq
Jared
Mladen Gogala <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
01/22/2004 08:54 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
I'm looking at the notes to apply patch 4 to Oracle 9.2.0.3. After
installing the products.jar file, one of the steps is to run
startup migrate
then run catpatch.sql
I've looked on technet as well as the documentation CD and can not find
any info on startup migrate.
Can someone point me in a
Based on a sample of one message, it looks like Freelists may be running
about 2 hours behind.
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: DENNIS WILLIAMS
INET: [EMAIL PROTECTED]
Fat City Network Services
Yes. On Solaris 5.8.
-Original Message-
Sent: Thursday, January 22, 2004 3:10 PM
To: Multiple recipients of list ORACLE-L
Sandra - Are you on 9.2.0.4?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 10:44 AM
To: Multip
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
Thanks Raj. I have confidence on you and hope we will meet in next CTOUG
meeting.
Best Regards,
Prasad
860 843 8377
"Jamadagni,
I was trying to sign up this morning... The response
was fast but I keep getting booted on the final confirmation email... The
message I get is...
Invalid number of parameters.
Not sure
why... Figured I'd wait and see if anyone else is having the same
problem... Anyone else experience
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
Sandra - Are you on 9.2.0.4?
Dennis Williams
DBA
Lifetouch, Inc.
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, January 22, 2004 10:44 AM
To: Multiple recipients of list ORACLE-L
I have had a problem on my 9i database for three weeks. I am getting a
ORA-7445 error which is point
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
Test new oracle-l
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: EPS - DBA (Group)
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
---
Well, I did check with them first to ensure the volume would be OK.
It is running a bit slow. I'm not sure if it is just freelists.org, or a general
internet slowdown.
Sending mail from work to home it seems that it is taking much too long.
Jared
"Ron Thomas" <[EMAIL PROTECTED]>
Sent by
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
---
Thanks for input Raj.
I was also thinking on the same lines (Querying v$views periodically and
store it in some metadata table) if there is no easier way to figure out
from DBA_ views.
As far as changing the production code, as you know, It has to go thru the
dev/test databases first and then g
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
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 table from multiple tables. The extract table is then used for rep
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
I have had a problem on my 9i database for three weeks. I am getting a
ORA-7445 error which is pointing to some memory problems. It is occurring
during the CTX_DOC.FILTER process. We are running this process from a
custom PL/SQL package that is being initiated from an Oracle Job. However,
we st
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
It's been a great ride.
"Bruce A.
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
Hi All,
Is there anyway to find out from data dictionary views when was a database
procedure/function last executed. Would like know the solution for 8i and
9i databases. We have some older code in the databases and do not know if
any application is using it or not.
I appreciate your help.
Th
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
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" " $4 " " $5 " "$6}'|more
nam='SQL*Net message to client'
nam='S
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
Title: Metalink on the blink
but
their education site is off the air (at least it was an hour
ago)
Tom Mercadante Oracle Certified Professional
-Original Message-From: Goulet, Dick
[mailto:[EMAIL PROTECTED]Sent: Thursday, January 22, 2004 10:09
AMTo: Multiple recipients of
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
for LMTs...
Advantages in uniform versus automatic?
Uniform 5 MB? 10 MB.100MB etc
thoughts would be appreciatd
Thanks
Brad
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Odland, Brad
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-
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
Title: Metalink on the blink
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]
"The swim only hurt once - from the beginning
to the end" - Doc Counsilman on swimming the
English Chan
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 data to the file before
loading(its not negotiable).
ksh eats up 24% of total CPU on a 4 CPU Solaris box. We cannot do this. I am not
allowed to strea
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
Hallo,
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 any of the fields
ORGANIZATION_NUMBER
LEGAL_NAME
COMPANY_FORM_ID
ORDER_STOP
in table COMPANY
The script bo be run is this one:
insert into system_change
values(sys
1 - 100 of 116 matches
Mail list logo