Title: Extent allocation
It is a big
clue. Oracle rounds to multiples of 5 extents to prevent the existence of
a free extent of fewer than 5 blocks, which is unlikely to be
usable.
Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212
813-0829 x103 (office) 917
549-4717 (mobile
to consider (in this order) dropping the snapshots, dropping
the logs, re-creating the logs, and re-creating the snapshots. Perform some
DML on the master tables, then do fast refreshes and ensure that the logs
are empty.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549
I'm new to Java in the DB. Once a class or source has been loaded into
Oracle, is there any way to get it back out?
Thanks.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
--
Please see the official ORACLE-L FAQ: http
No, I wasn't clear enough; I mean retrieve into a file.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Thursday, February 15, 2001 4:16 PM
To: Multiple recipients of list ORACLE-L
You mean, drop
Title: OFF TOPICRE: Get Java from database?
Someone has been
drinking *too much* java, methinks.
Paul Baumgartel InstiPro, Inc. [EMAIL PROTECTED] 212
813-0829 x103 (office) 917
549-4717 (mobile)
-Original Message-From: Mohan, Ross
[mailto:[EMAIL PROTECTED]]Sent: Thursday
What about a binary (i.e., class) file? Any way to extract it to an OS
file?
I'm asking because we have some Java stored procedures of uncertain origin
and we're trying to locate the source. They're stored in the DB as classes.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829
Instance recovery, not database recovery, occurs after a shutdown abort or
other abnormal instance termination. No DBA intervention is required;
Oracle takes care of it automatically.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile
Can anyone explain to me the difference between Connection Manager's
connection concentration and connection pooling capabilities, and the
appropriate circumstances in which to use them? Thanks.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717
Speaking of dairy:
Jared, your web site features an "Oracle Initialization Parms Comparison".
When I see "parm", I think of Parmesan (or, more properly, Parmigiana)
cheese.
Shouldn't that be "params"? Or "settings"?
Paul Baumgartel
InstiPro, Inc.
[EM
And if you were running a comparable system, what would *you* say?
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Tuesday, February 27, 2001 2:51 PM
To: Multiple recipients of list ORACLE-L
Man
Yeah, it was in my inbox as well...sounds like these people are mining this
mailing list for addresses.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Friday, March 02, 2001 9:32 AM
To: Multiple
r database objects.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Thursday, March 08, 2001 11:11 AM
To: Multiple recipients of list ORACLE-L
Hugh,
You are right that Richard Barker says not to use an e
In this case the "temporary segment" was not a sort segment, but the space
allocated for an index while under construction. I'm surprised that no one
here caught that!
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
---
I'm not so sure.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Friday, March 09, 2001 9:55 AM
To: Multiple recipients of list ORACLE-L
Sorry Paul,
Do not pass Go and do not collect 200 quid. One
It's Oracle blocks.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Monday, March 12, 2001 11:20 AM
To: Multiple recipients of list ORACLE-L
if I get this message,
IMP-00058: ORACLE error 1654
age header, at
least, so it's possible to filter them out.
And no, I am not a grouch, curmudgeon, in need of lightening up, etc.
Sometimes enough is enough, already.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
--
Please see the official OR
That is correct.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Tuesday, March 27, 2001 8:45 AM
To: Multiple recipients of list ORACLE-L
I have not tested this. I believe ,with about a 60% level
d it, only to
find that the relevant rollback info has been overwritten. You'd have to
specify the BIG_ROLLBACK to be used by your other transactions *before* you
issue the query. Setting an RBS has no effect on a query.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
91
does not currently have an Oracle8i database."
Is the purpose of this recommendation to ensure best performance, or is
there some other issue? Thanks.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
--
Please see the officia
his email formatting broke the line in two, just add the "tml" to the ".h"
and you'll get there
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
Sent: Thursday, April 05, 2001 12:31 PM
To:
I'm looking for help installing Oracle Internet Directory (8.1.7, Sun
Solaris 2.7). The software installation goes fine, but once the OID
Configuration Assistant window comes up, everything stops. My database does
use the UTF8 character set. Any ideas out there? Thanks.
Paul Baumgartel
I found the problem. The OiD schema installation assumes that the password
for "system" is "manager". If it isn't, the installation doesn't proceed.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Origin
You can, but the scripts are meant to be run via the GUI installer: I
changed the system password to "manager" instead and all ran smoothly.
Paul Baumgartel
InstiPro, Inc.
[EMAIL PROTECTED]
212 813-0829 x103 (office)
917 549-4717 (mobile)
-Original Message-
[mai
for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mai
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mai
.
Thanks!
Paul Baumgartel
InstiPro Group, Inc.
[EMAIL PROTECTED]
212 813-0829 x103
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
My resume is attached. Please contact me at your convenience. Thanks.
Paul Baumgartel
[EMAIL PROTECTED]
917 549-4717
- Original Message -
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Sent: Wednesday, May 09, 2001 11:26 AM
Major state-of-the-art pharmaceutical company
). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
__
Do you Yahoo!?
New DSL Internet Access from SBC Yahoo!
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
you Yahoo!?
Faith Hill - Exclusive Performances, Videos More
http://faith.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California
variables such as ORACLE_HOME. But
nowhere do I see how to use a SQL*Net connect string: I have PDBA
installed on my PC, and I want to connect to databases on Unix servers;
the service name resolution is provided by Oracle Names. What am I
missing?
Thanks,
Paul Baumgartel
!
__
Do you Yahoo!?
Y! Web Hosting - Let the expert host your web site
http://webhosting.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
This COPY script failure occurred when running in SQL*Plus on Windows
NT. In SQL*Plus on (Unix) database server, runs just fine, so
immediate problem solved.
Shouldn't it work from PC, though?
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
I'm trying to use (for the first time in 15 years
: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
-
To REMOVE yourself from this mailing list, send
may
also send the HELP command for other information (like subscribing).
__
Do you Yahoo!?
HotJobs - Search new jobs daily now
http://hotjobs.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
the large
reel-to-reel tapes in my hand. As I recall, the project never got off
the ground, to my chagrin. Imagine allowing a single developer to
choose a language that way now!
Paul Baumgartel
--- [EMAIL PROTECTED] wrote:
Things seem a little slow on the list ( like I need more email
and s.sid = sid
order by se.time_waited
/
Run this before and after executing the insert statement, and compute
the delta for each wait event seen.
HTH
Paul Baumgartel
--- [EMAIL PROTECTED] wrote:
Oracle 8.1.7.0.0 on Win2k (4 CPU, 4GB RAM)
A 3rd Party app. is experiencing very slow performance
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- 858-538-5051 http://www.fatcity.com
San Diego, California-- Mailing list and web hosting services
).
__
Do You Yahoo!?
HotJobs - Search Thousands of New Jobs
http://www.hotjobs.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California
WHERE ROWNUM 1000, the query returns 336
rows!
I don't know the size of the entire result set (I'm running a count
right now), but if the result set consists of at least 336 rows,
shouldn't WHERE ROWNUM 50 return 49 rows?
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL
is not sequential, and ROWNUM 999 could be the 336th row in
sorted order.
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET
I believe you have ROWNUM confused with ROWID.
--- ltiu [EMAIL PROTECTED] wrote:
Holes in your extents/segments. Normal. You get this after repeated
updates/deletes/inserts.
ltiu
Paul Baumgartel wrote:
I've been given a query to investigate. The performance varies
extremely
anything in the program itself, such as closing
cursors more frequently, that will help?
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http
session
calls it constantly; the wait event references the library cache lock.
I've seen waits on the library cache latch in similar situations (at
least I think I have; my memory may be failing me!).
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED
logged on.
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
in the owning schema, nor in that of the
replication administrator. What, then, is the mechanism by which the
procedures in this package are called?
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo
when rows are inserted, updated, or deleted. There are,
however, no trigges in the owning schema, nor in that of the
replication administrator. What, then, is the mechanism by which the
procedures in this package are called?
TIA!
=
Paul Baumgartel, Adept Computer Associates, Inc
[EMAIL PROTECTED]
809-565-3121
__
Do You Yahoo!?
Yahoo! Finance - Get real-time stock quotes
http://finance.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat
to the name!
Paul Baumgartel
__
Yahoo! - We Remember
9-11: A tribute to the more than 3,000 lives lost
http://dir.remember.yahoo.com/tribute
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL
that the end is an execution by technical nitwits.
__
Do You Yahoo!?
Yahoo! - Official partner of 2002 FIFA World Cup
http://fifaworldcup.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET
the local machine?
Side question: Am I correct in my belief that the Oracle service must
be running before an Oracle instance can start, and that it keeps
running even when the instance is shut down?
Many TIA.
Paul Baumgartel
__
Do You Yahoo!?
Yahoo
John, yes, you must use a trigger, with some variation of
select sequence.nextval into :new.column_name from dual;
Paul Baumgartel
--- John Weatherman [EMAIL PROTECTED] wrote:
OK, I RTFM and am probably just missing it. Is there an easy may to
define
a default as a NextVal? When I try
directly to the spfile.
HTH,
Paul Baumgartel
--- DENNIS WILLIAMS [EMAIL PROTECTED] wrote:
For Oracle 9.2 (Solaris), can anyone tell me where Oracle is
expecting the
init.ora file?
I created the database using dbca. It created an init.ora in
admin/{db_name}/pfile. I moved
subscribing).
__
Do You Yahoo!?
Sign up for SBC Yahoo! Dial - First Month Free
http://sbc.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services
to
be written to the redo log. If all of your tablespaces are in backup mode
at the same time, redo writes for the tablespaces whose files are not
currently being copied will be unnecessarily large.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent
application developers similarly negated by a performance disadvantage?
I'm interested in hearing opinions based on both theoretical and empirical
information. Thanks.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
I ordinarily wouldn't correct a misspelling, but in this case, it matters:
it's CONSISTENT, not CONSISTANT.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, August 14, 2001 3:54 PM
To: Multiple recipients of list ORACLE-L
Chris,
If you
I found the problem--O/S enviroment variable NLS_LANG must be set. Thanks.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 15, 2001 9:10 AM
To: '[EMAIL PROTECTED]'
Thanks to everyone who replied yesterday. It appears I had
above, fail (see below) with errors
mentioning database keyword and character set. This is Oracle 9.0.1 on
Solaris. I'll appreciate any ideas; thanks!
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
RMAN shutdown immediate
2 startup mount
3 run {
4 allocate channel t1
Good for you, David. We are moving in that direction, too. I convince
people by saying 9i is really 8.2.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 23, 2001 12:41 PM
To: Multiple recipients of list ORACLE-L
Okay, I know
thesecircumstances, and how it was implemented:did you return
a ref cursor, an index-by table, a set of arrays? Any advice will be
appreciated. Thanks!
Paul Baumgartel MortgageSight
Holdings, LLC [EMAIL PROTECTED]
Redo log switch information appears in your alert log; you can also monitor
v$log and v$logfile.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Friday, August 24, 2001 11:51 AM
To: Multiple recipients of list ORACLE-L
Hi,
How to Know when
Hi Ruth.
{user|all|dba}_tables, {user|all|dba}_columns, {user|all|dba}_indexes
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, August 29, 2001 9:41 AM
To: Multiple recipients of list ORACLE-L
Good morning all,
Someone asked me where
Title: RE: How to loop call to SQL script in PL/SQL...
Lisa,
The stereotypical
football fan is, of course, a male,whose wife/significant other usually
wants nothing to do with the sport. I've often wondered what might inspire
a woman to follow football--care to satisfy my curiosity?
Paul
d be close to 1:
ratio = transaction tables consistent reads undo records applied /
transaction tables consistent read rollbacks
A solution is to create more, smaller
rollback segments, or to use automatic undo management.
Paul Baumgartel MortgageSight Holdings,
LLC [EMAIL
I haven't heard it, Ruth; care to clue me in?
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Thursday, August 30, 2001 1:57 PM
To: Multiple recipients of list ORACLE-L
Have you heard ESPN's reason why women are so attracted to Hockey? You
In your init.ora, check the value of OS_AUTHENT_PREFIX. If it's not OPS$,
that's the problem. Most people set it to (null string) now, so your
Oracle username would be production, not ops$production.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message
different environment, not a different type of Unix).
How the new HP differentiates itself from the competition will determine how
the deal affects Sun.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Tuesday, September 04, 2001 2:30 PM
Use the supplied DBMS_LOB package.
Paul Baumgartel
MortgageSight Holdings, LLC
[EMAIL PROTECTED]
-Original Message-
Sent: Wednesday, September 05, 2001 4:51 PM
To: Multiple recipients of list ORACLE-L
DBA's,
I'm trying to help one of our developers without success. (developmentally
Reading descriptions of the effects of Autoallocate leads me to
think that Autoallocate is nothing more than PCTINCREASE redux--a
little less crude, but still no way to manage your space.
Paul Baumgartel
--- sundeep maini [EMAIL PROTECTED] wrote:
Dennis,
I mentioned Autoallocate
a data
dictionary query. What do you think?
Thanks,
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Greetings - send holiday greetings for Easter, Passover
http://greetings.yahoo.com/
--
Please
code far outweigh the possibility that the code
isn't the most compact.
Paul Baumgartel
--- Pardee, Roy E [EMAIL PROTECTED] wrote:
Greetings all,
Is anyone out there using Oracle Designer's Table API? We're trying
to
decide whether to use it as opposed to writing our own packages
of metadata and the flexibility that OFA provides in terms
of
tuning
(I'm not limited to specific disks because I have customer data)
and
performance.
My 2 cents...
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do
export runs nightly and succeeded last
night (I can't be sure about all previous nights as they don't save the
log files).
Has anyone else seen this? Why is export writing to the temporary
tablespace?
TIA
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED
size is
approx. 3 GB. A similar full export runs nightly and succeeded last
night (I can't be sure about all previous nights as they don't save
the
log files).
Has anyone else seen this? Why is export writing to the temporary
tablespace?
TIA
=
Paul Baumgartel, Adept Computer
).
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
who misplaces or misnames a file.
Rachel
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
That's a great idea. Henceforth I'm going to do the same! Thanks.
--- Rachel Carmichael [EMAIL PROTECTED] wrote:
and, on a Unix box, I ALWAYS do an fuser before deleting a
file.
Just
with
this, but I still believe that the ONLY way to make sure if a
datafile
is part of the database is to query the database. All you need is
one
forgetful person who misplaces or misnames a file.
Rachel
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
That's a great
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
=
Paul Baumgartel, Adept Computer
sessions performing
inserts); how can I check to see if there's freelist contention?
Anything else I should investigate?
Many TIA,
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Tax Center
Follow-up question: can someone explain exactly why buffer busy waits
can be due to heavy insert activity when there are insufficient
freelists? I suspect that this may figure into my problem with insert
performance. Thanks!
Paul Baumgartel
subscribing).
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858
Wasn't that expression originally coming down the pike, as in
turnpike? :-)
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul
sessions
performing
inserts); how can I check to see if there's freelist contention?
Anything else I should investigate?
Many TIA,
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo
).
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
.
Thanks,
PB
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Tax Center - online filing with TurboTax
http://taxes.yahoo.com/
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
No. CPU utilitization averages 40-60% across 4 CPUs.
--- Mohammed Shakir [EMAIL PROTECTED] wrote:
No enough inserts to bog down the CPUs?
--- Paul Baumgartel [EMAIL PROTECTED] wrote:
Thanks, Mohammed and Anjo, for your replies.
Now my question is this: given that the table structures
is correct that consistent read
buffers are always obtained from a rollback segment. Finally, would
any of you draw the conclusion that the difference in elapsed time
between these two is due to the difference in number of consistent
reads?
Thanks!
=
Paul Baumgartel, Adept Computer Associates, Inc
Ramon
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Games - play chess, backgammon, pool and more
http://games.yahoo.com/
--
Please see the official ORACLE-L FAQ: http
in advance!
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED]
__
Do You Yahoo!?
Yahoo! Health - your guide to health and wellness
http://health.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
).
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858
I'm looking for a way to format a trace file produced by event 10046
trace name context forever,level 8 (this dumps all wait events to a
file). Has anyone written such a formatter, or have information on
one? Thanks.
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED
by event 10046
trace name context forever,level 8 (this dumps all wait events to a
file). Has anyone written such a formatter, or have information on
one? Thanks.
=
Paul Baumgartel, Adept Computer Associates, Inc.
[EMAIL PROTECTED
!
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San
' at http://www.hotsos.com
I have used the first one found very good.
__
Do You Yahoo!?
LAUNCH - Your Yahoo! Music Experience
http://launch.yahoo.com
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
! GeoCities - quick and easy web site hosting, just $8.95/month.
http://geocities.yahoo.com/ps/info1
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Paul Baumgartel
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego
1 - 100 of 245 matches
Mail list logo