RE: Extent allocation

2001-02-07 Thread Paul Baumgartel
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

RE: Are snapshot logs purged?

2001-02-14 Thread Paul Baumgartel
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

Get Java from database?

2001-02-15 Thread Paul Baumgartel
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

RE: Get Java from database?

2001-02-15 Thread Paul Baumgartel
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

RE: OFF TOPICRE: Get Java from database?

2001-02-15 Thread Paul Baumgartel
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

RE: Get Java from database?

2001-02-16 Thread Paul Baumgartel
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

RE: shutdown Abort...Open normal??

2001-02-16 Thread Paul Baumgartel
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

Connection Manager

2001-02-20 Thread Paul Baumgartel
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

RE: Restore Scenario

2001-02-27 Thread Paul Baumgartel
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

RE: RE: MetaSlop

2001-02-27 Thread Paul Baumgartel
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

RE: Oracle Upgrade DBA Wanted

2001-03-02 Thread Paul Baumgartel
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

RE: opinions on naming primary keys in new database (seriously)

2001-03-08 Thread Paul Baumgartel
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

RE: Weird - unable to extend error

2001-03-09 Thread Paul Baumgartel
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) ---

RE: Weird - unable to extend error

2001-03-09 Thread Paul Baumgartel
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

RE: number of Mb to add?

2001-03-12 Thread Paul Baumgartel
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

RE: Lemon Juice in Ants Pooh-Poohed

2001-03-20 Thread Paul Baumgartel
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

RE: Execute priv to an isolated procedure inside a package

2001-03-27 Thread Paul Baumgartel
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

RE: Set transaction does not work

2001-03-29 Thread Paul Baumgartel
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

OID installation

2001-04-03 Thread Paul Baumgartel
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

RE: Oracle being scalable

2001-04-05 Thread Paul Baumgartel
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:

OID installation

2001-04-09 Thread Paul Baumgartel
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

RE: OID installation

2001-04-09 Thread 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

RE: OID installation

2001-04-09 Thread Paul Baumgartel
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

Re: imp - limitation on number of tables?

2001-04-11 Thread Paul Baumgartel
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

Re: Should each partition have it's own tablespace and datafile?

2001-04-11 Thread Paul Baumgartel
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

Re: stupid DBA

2001-04-13 Thread Paul Baumgartel
ttp://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 To REMOVE yourself fr

transaction recovery error

2001-04-30 Thread Paul Baumgartel
. 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

RE: differences between physical datafile and v$datafile

2001-05-01 Thread Paul Baumgartel
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

Re: Oracle DBA Needed in Fairfield County, CT...Major Company.

2001-05-09 Thread Paul Baumgartel
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

RE: What columns are in the Primary Key

2001-05-10 Thread Paul Baumgartel
). 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

RE: PL/SQL Question

2001-05-11 Thread Paul Baumgartel
-- 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

RE: datafile sizing question

2002-09-25 Thread Paul Baumgartel
-- 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

Re: * Sr. Oracle 8i DBA Needed in NYC- Locals Only..

2002-10-04 Thread Paul Baumgartel
__ 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

Re: Any way to see the currently running SQL in one session.

2002-10-16 Thread Paul Baumgartel
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

PDBA toolkit (from Perl for Oracle DBAs) question

2002-10-24 Thread Paul Baumgartel
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

SQL*Plus COPY error

2002-10-25 Thread 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

SQL*Plus COPY error solved (sort of)

2002-10-25 Thread Paul Baumgartel
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

RE: SQL*Plus COPY error solved (sort of)

2002-10-29 Thread Paul Baumgartel
: 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

Re: Joseph Testa has sent you a 10% discount]

2002-10-29 Thread Paul Baumgartel
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

Re: blast from the past

2002-11-06 Thread 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

Re: Slow Inserts

2002-11-15 Thread Paul Baumgartel
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

Re: Invalid Objects but no errors

2002-11-15 Thread Paul Baumgartel
-- 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

Re: SunFire v100

2002-08-22 Thread Paul Baumgartel
). __ 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

ROWNUM strangeness?

2002-08-29 Thread Paul Baumgartel
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

ROWNUM strangeness?--SOLVED

2002-08-29 Thread Paul Baumgartel
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

Re: ROWNUM strangeness?

2002-08-29 Thread Paul Baumgartel
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

SQL-2100 in Pro*C program

2002-08-29 Thread Paul Baumgartel
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

Library cache lock and library cache latch

2002-08-30 Thread Paul Baumgartel
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

Re: waits vs. logons

2002-09-04 Thread Paul Baumgartel
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

Replication question

2002-09-04 Thread Paul Baumgartel
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

RE: Replication question

2002-09-05 Thread Paul Baumgartel
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

Re: Question about database and service name

2002-09-05 Thread Paul Baumgartel
[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

Satisfied customer

2002-09-11 Thread Paul Baumgartel
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

RE: Oracle and Tru64

2002-06-04 Thread Paul Baumgartel
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

Oracle on NT

2002-06-04 Thread Paul Baumgartel
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

Re: Using a Sequence for a Default Value

2002-07-10 Thread Paul Baumgartel
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

Re: Where is Oracle 9.2 init.ora?

2002-07-11 Thread Paul Baumgartel
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

Re: Triggers are getting disabled

2002-07-12 Thread Paul Baumgartel
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

RE: Hot Backup

2001-08-08 Thread Paul Baumgartel
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

Stored procedure performance

2001-08-13 Thread Paul Baumgartel
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

RE: Substitute for Materialized Views/Snapshots?

2001-08-14 Thread Paul Baumgartel
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

RE: RMAN cold backups continued

2001-08-15 Thread Paul Baumgartel
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

RMAN cold backups continued

2001-08-15 Thread Paul Baumgartel
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

RE: database upgrade policy?

2001-08-23 Thread Paul Baumgartel
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

Stored procedures that return multiple rows

2001-08-23 Thread Paul Baumgartel
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]

RE: RedoLogs switching

2001-08-24 Thread Paul Baumgartel
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

RE: results of analyze

2001-08-29 Thread Paul Baumgartel
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

OT: football fan-hood

2001-08-29 Thread Paul Baumgartel
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

RE: Tkprof output

2001-08-30 Thread Paul Baumgartel
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

RE: OT: football fan-hood

2001-08-30 Thread Paul Baumgartel
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

RE: OPS$users

2001-08-31 Thread Paul Baumgartel
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

RE: OT: Interesting News..

2001-09-04 Thread Paul Baumgartel
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

RE: CLOB help

2001-09-05 Thread Paul Baumgartel
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

RE: 8.1.7 LMTs Autoallocate vs Uniform Extents

2002-03-26 Thread Paul Baumgartel
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

Seeking opinions

2002-04-01 Thread Paul Baumgartel
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

Re: Designer's Table API: Threat or Menace?

2002-04-02 Thread Paul Baumgartel
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

RE: Seeking opinions

2002-04-02 Thread Paul Baumgartel
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

ORA-27072/HP-UX file too large

2002-04-04 Thread Paul Baumgartel
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

Re: ORA-27072/HP-UX file too large

2002-04-04 Thread Paul Baumgartel
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

Re: Seeking opinions

2002-04-04 Thread Paul Baumgartel
). __ 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

Re: Seeking opinions

2002-04-05 Thread Paul Baumgartel
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

Re: Seeking opinions

2002-04-06 Thread Paul Baumgartel
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

Re: Experiences with 9iRAC (upgrading from 8.1.5OPS on Tru64)

2002-04-10 Thread Paul Baumgartel
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

insert performance

2002-04-10 Thread Paul Baumgartel
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

Re: insert performance

2002-04-10 Thread Paul Baumgartel
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

RE: TKPROF?

2002-04-11 Thread 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

Re: comming down the pipe

2002-04-11 Thread Paul Baumgartel
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

RE: insert performance

2002-04-11 Thread Paul Baumgartel
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

RE: comming down the pipe

2002-04-11 Thread Paul Baumgartel
). __ 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

How to determine number of freelists

2002-04-11 Thread Paul Baumgartel
. 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

Re: insert performance

2002-04-12 Thread Paul Baumgartel
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

consistent reads during inserts

2002-04-12 Thread Paul Baumgartel
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

Re: Buffer in Import

2002-04-25 Thread Paul Baumgartel
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

Spec'ing hardware

2002-05-03 Thread Paul Baumgartel
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

RE: Compressing Export Dumps / WinZip

2002-05-16 Thread Paul Baumgartel
). __ 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

wait event trace file formatter?

2002-05-20 Thread Paul Baumgartel
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

RE: wait event trace file formatter?

2002-05-20 Thread Paul Baumgartel
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

RE: What makes Export slow ?

2002-05-20 Thread Paul Baumgartel
! __ 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

Re: wait event trace file formatter?

2002-05-20 Thread Paul Baumgartel
' 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

Re: Revoke Delete

2001-11-27 Thread Paul Baumgartel
-- 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

  1   2   3   >