Not at all, Chris - here you go.
Chris Stephens wrote:
Hey Mogens...
Would you mind sending me a copy of that paper?
Thanks either way!!
chris
-Original Message-
Sent: Wednesday, September 24, 2003 9:05 PM
To: Multiple recipients of list ORACLE-L
Compress to impress? by Julian Dyke
v$sgastat?
-Original Message-
From: Prem Khanna J [mailto:[EMAIL PROTECTED]
Sent: Friday, September 26, 2003 12:25 PM
To: Multiple recipients of list ORACLE-L
Subject: Re: SQL AREA and LIBARARY CACHE size?
Hi Manoj,
quoteIn my system size of library cache is approx 48 mb
and sql area
Hi Manoj,
this is the statistics i got from one of my instance.
sql area225 MB
library cache 112 MB
I was also confused as u were [ i didn't notice this so far ].
but reading the replies of Tanel Steve once again:
tanel
But what Steve meant (please correct me
Try this...
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage
-Original Message-
Sent: 26 September 2003 02:20
To: Multiple recipients of list ORACLE-L
http://www.oracle.com
Bottom you have Technologies ; In that Click Technology network to get to
Find the SID and SERIAL# from v$session, slap a trace
on the session using DBMS_SUPPORT and see what pops
out
hth
connor
--- Seema Singh [EMAIL PROTECTED] wrote: Hi,
I have been noticing on oRACLE 9i ora_j000 process
is taking more CPU.
When I select sid,job from dba_jobs_running its
looks
Hello Tim
I had a meeting yesterday about recovery time for a system and I also said
to take snapshots few times a day. The reason is to have a short recovery
time if you need to restore the database. Our tapes are going offsite as a
backup against total site disaster, and yes, we also have
Hi Prem,
I Think you are also doing the same mistake that I have done yesterday,
that was causing so much confusion.
I had earlier calculated the library cache and sql area size from X$ksmsp.
Please check the size of these component in x$ksmss.
WHat is difference in both x$ view is little bit
Hi Manoj,
to be frank : need to know more basic stuff before i peep into X$ tables.
let me get good at fundamentals (a lot to be read explored) first.
later i can join u to explore about X$ stuff ;)
meanwhile,i'm waiting for someone to explain me about transient chunk recurrent
chunk.
Jp.
I'd suggest, when possible, not to use any x$ views, but stich with plain
old documented ways. That way you'll probably avoid a lot of confusion,
especially when database versions might change..
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent:
Sir Visser -
The honour is mine. We shall BAARF around the world in the years to come.
Mogens
Piet de Visser wrote:
Sir Norgaard, Group,
Accepted, I think #43 is rather cool,
as in: life, the universe and everyting++
I'll have to postpone review/critque/shredding of any
text, statement or
They are indeed, and their prices are (in the order you list them) in
addition to the EE price:
$20K, $20K, $10K, $10K, $10K.
Mogens
Hemant K Chitale wrote:
oops, I forgot to mention Partitioning pricing.
Partitioning is also listed seperately under Enterprise Edition options.
This is 25% of
Indeed. It's SO cool to run the version 5 thing again. Will you be at
the UKOUG conference in Birmingham in December by any chance?
Robson, Peter wrote:
Ah-a - NOW I see why you want my old version 5 manuals!!
peter
edinburgh
-Original Message-
From: Mogens Nørgaard [mailto:[EMAIL
And of course the Trace File Repository thing that Torben Holm from
Miracle made. Not half bad either. And free.
But nothing beats the Hotsos profiler in completeness and ability to
interpret the complex situations in these 10046 traces correct. And the
whole notion of not-accounted-for is
Was it not Dave Ensor that once concluded that x$ tables actually change
less than v$ tables?
Tanel Poder wrote:
I'd suggest, when possible, not to use any x$ views, but stich with plain
old documented ways. That way you'll probably avoid a lot of confusion,
especially when database versions
sql parsing would be reflected in Library cache not rowcache
Basic stuff
Not that basic. Rowcache will get hit during any hard parse, since you need
to get information about objects from DD. And if objects information isn't
cached yet, it has to be loaded into row cache.
Btw, row cache locks
Yep, in Apps 11i there's also more than 10k tables, over 150k objects total
in database - quite a hit for data dictionary :)
Tanel.
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Friday, September 26, 2003 5:54 AM
They are not even lookup
Hi,
Apologies if this has been asked before, or is a really lame question.
We currently have lots of locking problems running a web-deployed (J-initiator on
Win2k) off-the-shelf application.
The application is running from an Oracle Forms 6i patch 12 application server on
Windows 2000 sp4 and
Called from where? :) I think Tanel, Mladen and you missed the ironical
point -- if it can't be called from SQL why it is a deterministic one?
Erm.. ee.. if you put a wrapper function over it which retuns number...
(just joking)
Ok, I was too short-sighted there. I just checked from
Hi!
1) You can set idle_time profile option in server, to automatically
disconnect sessions idle for some time.
2) You can set sqlnet.expire_time to some minutes or hours, that Oracle
would probe all sessions over some interval and disconnect the ones which
don't have a corresponding client
...long long way to go . b4 i reach x$ tables.
Tanel, can u brief me about transient chunks recurrent chunks
that u were discussing with Steve ?
Jp.
26-09-2003 19:54:48, Tanel Poder [EMAIL PROTECTED] wrote:
I'd suggest, when possible, not to use any x$ views, but stich with plain
old
Simon,
Look for CREATE PROFILE in the SQL Reference for setting a limit on idle times.
SF
- --- Original Message --- -
From: Simon Gregory
[EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L
[EMAIL PROTECTED]
Sent: Fri, 26 Sep 2003 03:39:41
Hi,
Apologies if this has
Hi,
Thanks for your suggestions. Usually Friday we have low traffic on our website. I
will run the database with one node to check the row cache problem.
Muqthar
-Original Message-
Sent: Friday, September 26, 2003 7:15 AM
To: Multiple recipients of list ORACLE-L
sql parsing would
Mladen
Hm The company where my brother worked at last had hundreds of
perl scripts implementing most of their printing application. It has all
now been ported to java for similar reasons. Maybe you are better with
python then?, its not as huge as perl, that's for sure
cheers
Pete
--
Title: OT: Linux VPN and routing HOWTO
Hi
I'm Sorry to put this way OT subject here, but you guys usually come up with the answer anyway.
I'm trying to setup my linux at home so that I can VPN into it. Now I can connect already but can't ping or connect any of the machines in my network.
Im in the middle of Kytes new tuning book. He states that google uses a query similiar
to this to return web pages in their search function:
select /*+ FIRST_ROWS */ b.*
from ( select a.*, a.rownum
from (your query here) a
where rownum pick max number of rows you want in a batch )
SQL parsing would also be reflected in rowcache because, to parse
successfully, you
need dictionary and parse locks.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Sam Roberts
Sent: Friday, September 26, 2003 2:20 AM
Oracle 9.2.0.3.0
HP-UX 11i
block size 16K
db_file_multiblock_read_count 64
I have five groups of tables that have the same query issued to them.
Table structures, indexes
are the same, just the data and the number of rows are different. The
three tables that have more
than 3 million rows
Title: RE: any else try trace analyzer?
KG Since when it became free? Last time I checked it was a subscription model. Maybe things have changed ...
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views
Title: OT: Linux VPN and routing HOWTO
Is IP forwarding enabled? cat
/proc/sys/net/ipv4/ip_forward ? If its a zero, set it to a 1 (echo 1
/proc/sys/net/ipv4/ip_forward)
Beyond that, use a packet sniffer like tcpdump to
see what is appearing on the wire on both interfaces.
Thanks,
Matt
Title: RE: equivalent for isdate, isnumeric
you could however use diutil.bool_to_int and diutil.int_to_bool which is used by oracle to transmit/receive Boolean data across SqlNet.
Since others have pointed out, Boolean is not a SQL datatype, you could not build a FBI around it, deterministic
the structure of scripts is as follows ...
set ...
declare
v_alert_msg varchar2(20);
v_alert_statusnumber;
begin
dbms_alert.register('START_NOW');
-- first wait for alert to be received ...
dbms_alert.waitone('START_NOW',v_alert_msg,
v_alert_status);
-- your rest of script code ...
...
Title: Message
I still remember the dinner I had in an Mongolian restaurant near the
I35, great food (considering that I don't eat meat)... it has been 4-5
years, don't remember the name though.
Raj
Rajendra
Title: Message
No,
visit San Antonio - Fiesta, Margarita Pour off and Pachanga del Rio!
;o)
-Original Message-From: Mercadante,
Thomas F [mailto:[EMAIL PROTECTED] Sent: Thursday,
September 25, 2003 3:15 PMTo: Multiple recipients of list
ORACLE-LSubject: RE: DBA needed
I just ordered from Bookpool. It's in stock according to their website.
Glad I took a few minutes to start cleaning up the listserv email, didn't
realize it was out yet. Really looking forward to this one...
Jay Miller
Sr. Oracle DBA
-Original Message-
Sent: Wednesday, September 24,
Title: Message
Or,
the function can be written to return number. It's not so hard to do. If there
are problems,
please
let me know, I'll post the new version of the code, wrapped.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL
Google certainly doesn't use an Oracle database. They just wouldn't get the
performance
that they achieve currently.
See this link on Google's architecture
: http://www.computer.org/micro/mi2003/m2022.pdf
Hemant
At 05:44 AM 26-09-03 -0800, you wrote:
Im in the middle of Kytes new tuning book.
Title: Message
Was it
the Fire Hut? Good Stuff!
-Original Message-From: Jamadagni,
Rajendra [mailto:[EMAIL PROTECTED] Sent: Friday,
September 26, 2003 9:15 AMTo: Multiple recipients of list
ORACLE-LSubject: RE: DBA needed in Austin, TX
I still remember the dinner I had
Gene,
Good stuff. Thanks for the tip.
ed
- Original Message -
From:
Gene Sais
To: Multiple recipients of list ORACLE-L
Sent: Wednesday, September 24, 2003 6:29
PM
Subject: RE: URGENT REPORTS
What I like about VNC, is that all you need for a client is a
hmmm. must have read it wrong in the book. any idea how to get the 'estimated number
of record returned?
From: Hemant K Chitale [EMAIL PROTECTED]
Date: 2003/09/26 Fri AM 10:44:40 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: Google's architecture -- was Re: paging
Steve,
Thank you. I am grateful that someone else shrugs too.
I still get a lot of feedback about the OFA. Almost every conference I
go to, someone forgives me for writing the OFA Standard. And I leave not
knowing for sure where things went wrong.
A few weeks ago, one of the Oracle-L threads
Title: RE: Google's architecture -- was Re: paging and google.com
http://tinyurl.com/ordz
HTH
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email are strictly personal.
QOTD: Any
Hi,
There are two BUGS 2605240 and 2683906 which got fixed in 9.2.0.4.0. I will be
applying the patch to fix the problem.
Thanks for your input.
Muqthar
-Original Message-
Sent: Friday, September 26, 2003 9:55 AM
To: Multiple recipients of list ORACLE-L
SQL parsing would also be
How can I say this...
Don't confuse learning how to pass the performance tuning exam with
learning how to make systems faster.
I'll offer you my Dad's advice on this, which he reiterated frequently
on our 30-minute drives to and from school:
There are two answers to every question your teachers
Title: RE: DBA needed in Austin, TX
It rains sand in Amarillo. Ive seen it.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis101:
10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004:
March 710 Dallas
- Visit www.hotsos.com for
Thank you... The honor is gratefully accepted... Soon the hordes of BAARF
party member shall rule the world! Um... Ok, maybe not rule the world...
But at least we'll be loud!
Tim
BAARF Party Member #44
-Original Message-
Sent: Wednesday, September 24, 2003 10:40 PM
To: Multiple
I'd be interested to see the sequence of tests that support the
hypothesis that disk sorts are about 14,000 times slower than memory
sorts.
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium
yeah but alot of employers like to see the certifications. so for most of us who are
not at the point in our career as some of the senior guys here, we have to do it. Ive
noticed that you can get more done if your certified too. Adds credibility to what you
say. Especially with management.
i had one yesterday when i killed a process. Also, what parameter tells oracle where
to dump?
why does oracle dump memory? It sucked up 3.4 GB of disk space and we had to do a
'shutdown abort'
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: [EMAIL PROTECTED]
Raj,
It's Mongolian Barbeque and still there. Now there's even a Mongolian
BBQ North.
Tom,
You're forgetting that:
- In the summer it's hot.
- When it's hot, people wear less clothes to keep cool, sometimes a LOT
less.
- Austin is home to the University of Texas (almost 50,000 students at
peak,
Title: RE: DBA needed in Austin, TX
But it wasn't in the summer... and you didn't get the full
effect.
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/
\
\
\ \
Few people really enjoy the simple
pleasure of flying a kite Adam
Wells age 11
Title: RE: DBA needed in Austin, TX
HELP
Thanks for your suggestions. You have provided me with some excellent
ideas.
Saira
-Original Message-
Mladen Gogala
Sent: September 26, 2003 1:05 AM
To: Multiple recipients of list ORACLE-L
efforts?
Yes, that's a great idea for forcing plans. Thanks for thinking of that.
Essentially
user_dump_dest, background_dump_dest, NJ.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of [EMAIL PROTECTED]
Sent: Friday, September 26, 2003 11:50 AM
To: Multiple recipients of list ORACLE-L
Subject: what causes a
Title: RE: DBA needed in Austin, TX
*Need Subscription Help? mailto:[EMAIL PROTECTED]
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo Texas /\ / \ / \ \ / \/
\
\
\ \
Few people really enjoy the simple
pleasure of flying a kite Adam
Wells age 11
-Original
Tim, what are we going to do tomorrow night?
Not the same thing as every night, try to take over the world?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Johnston, Tim
Sent: Friday, September 26, 2003 11:35 AM
To:
encoded content removed -- binaries not allowed by ListGuru
The previous attachment was filtered out by the ListGuru mailing
software at fatcity.com because binary attachments are not appropriate
for mailing lists. If you want a copy of the attachment which was
removed, contact the sender
[EMAIL PROTECTED] scribbled on the wall in glitter crayon:
- Austin is home to the University of Texas (almost 50,000 students at
peak, half of which are female).
Are you getting a visual at all?
can you say sunburned tongue?;-)
--
Bill Shrek Thater ORACLE DBA
I'm going to work my
Dennis,
The ERP vendor started off using Informix and ported their application
to Oracle. We are 1 of 2 Oracle installations and they do not have much
Oracle expertise in their company - they don't provide any
administrative type manuals for the SA or DBA with respect to their
products. I wish
Friday, September 26, 2003, 11:49:40 AM, you wrote:
Jaite Raj,
Jaite It's Mongolian Barbeque and still there. Now there's even a Mongolian
Jaite BBQ North.
It's a chain. They're in Lansing, Michigan too. I remember
them being a bit different in that you went around and
collected a dish of raw
Oracle 9.2.0.3.0
HP-UX 11i
block size 16K
db_file_multiblock_read_count 64
I have five groups of tables that have the same
query issued to them.
Table structures, indexes
are the same, just the data and the number of rows
are different. The
three tables that have more
than 3 million rows
I would just like to know what are your experiences setting OPEN_CURSORS
for Java applications / middle-tier application servers ?
We're rolling out a bunch of applications on WebMethods, Tivoli Identity
Manager,
Plumtree, Documentum etc --- all non-Oracle clients accessing the database
through
I'm confused. Does Tom Kyte actually say that Google uses
Oracle
or is he talking of google-like behaviour in Oracle queries
?
Hemant
At 07:24 AM 26-09-03 -0800, you wrote:
http://tinyurl.com/ordz
HTH
Raj
Saira
That is exactly my point. How do you think they did the port? I would
pretty much guarantee that they took their existing Informix version and
made the minimum changes necessary to get the Oracle port going. Hopefully
they have a manual for their Informix version with a chapter on the
Oh, please don't get me wrong: grades are important!
My point is that there's getting perfect grades, and there's knowing
what's going on. And sometimes they're different. I believe you're
better off with both credentials *and* actual horsepower than with just
one or the other.
I don't consider
Tanel Poder wrote:
Called from where? :) I think Tanel, Mladen and you missed the ironical
point -- if it can't be called from SQL why it is a deterministic one?
Erm.. ee.. if you put a wrapper function over it which retuns number...
(just joking)
Ok, I was too short-sighted there. I just checked
Mladen Gogala wrote:
Or, the function can be written to return number. It's not so hard to
do. If there are problems,
please let me know, I'll post the new version of the code, wrapped.
Thank you. :)
--
Vladimir Begun
The statements and opinions expressed here are my own and
do not necessarily
Sorry Hemant ...
The link points to RGaffuri's quest to find 'approximately how many rows
will be received' part of the question.
Raj
Rajendra dot Jamadagni at nospamespn dot
com All Views expressed in this
What is so special about htat Mongolloid BBQ?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Jonathan Gennick
Sent: Friday, September 26, 2003 12:30 PM
To: Multiple recipients of list ORACLE-L
Subject: Re[2]: DBA
must have been google like behavior. i dont focus on every word.
From: Hemant K Chitale [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 12:39:53 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: Google's architecture -- was Re: paging and google.com
I'm confused.
Simon
Just another idea for you, that may or may not be helpful. I haven't
worked with Forms, others on this list can provide some ideas. However, I
have seen some weird behavior from Micro$oft apps based on VB and ASP. If
the database connection is left with mostly defaults, the app will tend
Title: Message
Google
like behavior in oracle queries? On top of real results you get "paid placement"
entries, some of them
X-rated? That'll be the day.
--Mladen GogalaOracle DBA
-Original Message-From:
[EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of
Hemant K
got them in columbus, oh also, excellent restaurant.
joe
Jonathan Gennick wrote:
Friday, September 26, 2003, 11:49:40 AM, you wrote:
Jaite Raj,
Jaite It's Mongolian Barbeque and still there. Now there's even a Mongolian
Jaite BBQ North.
It's a chain. They're in Lansing, Michigan too. I
Title: Message
We
have the luxury of moving a 300G database to a new box that's being built and
choosing the specifications, disk layout, striping, etc. After
spendingthe morning poring over Cary Millsap's wonderful VLDB paper
this is what we're thinking of but I'd appreciate any
comments.
Title: Message
Hmm...
gives me something to work on... I've got the name to go with it
too...
"Before we look at your boring data, Bambi recommends you check this HOT
HOT HOT XXXInfo!!"
Gives
a whole new meaning to Relational Database.
-Original Message-From: Mladen Gogala
Title: Message
Google
does use Oracle, but afaik only in-house for internal applications. The
clustered search engine is entirely custom code and engine. 10,000 servers
would be a pretty big RAC install. :)
Thanks,
Matt
--Matthew ZitoGridApp SystemsEmail:
[EMAIL PROTECTED]Cell:
Title: Message
There
you go. That's how we (DBAs) gonna make money in the
future.
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED]Sent: Friday, September 26, 2003
12:50 PMTo: Multiple recipients of list ORACLE-LSubject:
RE: Google's architecture -- was Re:
memory only dumped to the udump. it didnt dump to the bdump. how is it decided where
it will be dumped?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 12:09:39 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: what causes a memory dump?
Friends --
Don't ask for the details... they're too gruesome for print... but I need to
FTP several 30GB files to my laptop, and all the FTP packages I've tried
crap out at 4G. And before someone yells OT, they're DBF files and this is
a backup.
BTW, the Maxtor 250GB external storage device...
There's a document by Michael R. Ault, about it, if
you want it, I can send it to you..
Gabriel
--- Saira Somani-Mendelin [EMAIL PROTECTED]
wrote:
Thanks for your suggestions. You have provided me
with some excellent
ideas.
Saira
-Original Message-
Mladen Gogala
Sent:
Title: Message
From a
cowboy diary as related on the History Channel...
"If I
owned both Hell and Texas I'd rent out Texas and live in
Hell."
-Original Message-From: Mladen Gogala
[mailto:[EMAIL PROTECTED] Sent: Thursday, September 25, 2003
11:50 AMTo: Multiple
S... People are listening... Someone will hear our plans...
-Original Message-
Sent: Friday, September 26, 2003 12:10 PM
To: Multiple recipients of list ORACLE-L
Tim, what are we going to do tomorrow night?
Not the same thing as every night, try to take over the world?
--
Mladen
Title: RE: FTP big file to little laptop
tried scp ?? maybe zipped might help ... and please don't tell me it is for DR ... g
Raj
Rajendra dot Jamadagni at nospamespn dot com
All Views expressed in this email
Title: Message
No way... It is one of the prettiest places... except in
October
Have only been as far as the airport in Houston, don't know that I would
care to be anywhere other than that... but the state is
beautiful.
April Wells Oracle DBA/Oracle Apps DBA Corporate Systems Amarillo
Here is our way to move oracle dump file which is 6G (using ssh):
ssh -n remote_unix_box_name cat /oracle/u4/dev_staging/oracle.dmp.1.gz
/data/oracle.dmp.1.gz
/oracle/u4/dev_staging/oracle.dmp.1.gzis dump file from remote box that
we want to download
/data/oracle.dmp.1.gz is the
Sounds more like there HOT HOT HOT XXXInfo files of you...according to that other
email. Large files = picture files.
-Original Message-
Bellow, Bambi
Sent: Friday, September 26, 2003 1:40 PM
To: Multiple recipients of list ORACLE-L
Friends --
Don't ask for the details... they're too
Forgot to add one more aspect. You may consider "extproc"; A Java/C program interface
From DB2 equivalent of "extproc" of oracle. DB2 to pass values to the Java/C program
which will in turn connect to Oracle and carry out DMLs.
HTH
GovindanK-Original Message-
From: Govindan
How about putting Ext3 filesystem on that drive? Large files are supported
and wget wouldn't crap out?
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On
Behalf Of Bellow, Bambi
Sent: Friday, September 26, 2003 1:40 PM
To:
Oh good grief, I foolishly thought this thread was dead.
Please take it to the off topic list.
April Wells [EMAIL PROTECTED]
Sent by: [EMAIL PROTECTED]
09/26/2003 10:59 AM
Please respond to ORACLE-L
To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
cc:
v$session.type
Cary Millsap
Hotsos Enterprises, Ltd.
http://www.hotsos.com
Upcoming events:
- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney
- Hotsos Symposium 2004: March 7-10 Dallas
- Visit www.hotsos.com for schedule details...
-Original Message-
[EMAIL PROTECTED]
Sent:
It may not be FTP, but the OS and filesystem you're using. I've FTPd
several 20+G files to/from Win2000 on NTFS to/from Linux on etx3 filesystems
without a problem. If you think it is FTP, you may want to consider
alternatives like Samba or NFS.
Rich
Rich Jesse
Depending on the type of process which is dumping. If it's a background
process
(LGWR,DBWR,SMON,PMON,CKPT,RECO,CJQ,P00,D00, shared servers, archiver) it
goes to bdump.
If it isn't, it goes to udump.
--
Mladen Gogala
Oracle DBA
-Original Message-
From: [EMAIL PROTECTED]
I had thought it was an OS issue too... but was informed that it was an FTP
issue. I'm looking into ext3. Thanks!
-Original Message-
Sent: Friday, September 26, 2003 1:35 PM
To: Multiple recipients of list ORACLE-L
It may not be FTP, but the OS and filesystem you're using. I've FTPd
Indeed, that statement doesn't even pass the 'Is it reasonable test'.
Assume a sort in memory takes 0.2 seconds. Accordingly, the same
sort on disk would take 46.7 minutes:
( .2 * 14000 ) / 60 = 46.7
That just doesn't sound reasonable to me.
Jared
Cary Millsap [EMAIL
Yeah, baby! You should see what I keep in BLOBS!
Bambi.
-Original Message-
Sent: Friday, September 26, 2003 1:10 PM
To: Multiple recipients of list ORACLE-L
Sounds more like there HOT HOT HOT XXXInfo files of you...according to
that other email. Large files = picture files.
Title: Message
Avoid
small stripe sizes for your redo log volumes - especially on two-disk-only RAID
sets, you'll break readahead and write allocation on many arrays.
Beyond
that, it looks good - what kind of array are you using?
Matt
--Matthew ZitoGridApp SystemsEmail:
[EMAIL
ok so what causes the memory to dump? Im stumped?
From: Mladen Gogala [EMAIL PROTECTED]
Date: 2003/09/26 Fri PM 02:39:41 EDT
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Subject: RE: RE: what causes a memory dump?
Depending on the type of process which is dumping. If it's a
Title: Message
That
Burlesonpaper referenced below, http://www.praetoriate.com/oracle_tips_sorting_operations.htm,
is quite entertaining. (I'd be careful with using it as guidance) Found at least
5 errors/urban myths is in it which is pretty good for such a short paper. His
last paragraph
The Mongolian Wok here in West Palm Beach went out of business, probably
b/c Palm Beach County residents can't decide what ingredients to pick :).
One thing about Texas, is that they have the highest homeowners insurance
fees in the country. They get their share of All of nature's
Can you remind me, what is readahead good for on redo files? I believe that
parallelism is much more essential for
the recovery and archiver file is usually quick enough, even without any
special tricks.
--
Mladen Gogala
Oracle DBA
-Original Message-
Matthew Zito
Sent: Friday,
Cary - Love the succinct reply!
Ryan - Just create a daemon process that will remove any dump files every 3
seconds. Not to worry.
Just kidding. You need to review the dump file using your keen knowledge
of your system in conjunction with Oracle Support and try to figure out why
the
1 - 100 of 131 matches
Mail list logo