Re: End of Roche contract

2003-12-19 Thread Paul Baumgartel
- Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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 -

Off-topic postings

2003-12-17 Thread Paul Baumgartel
s work and entertainment is entertainment.) Thanks, everyone, and happy holidays to all. = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official OR

Re: rebuilding indexes - sure to cause a ruckus

2003-12-08 Thread Paul Baumgartel
xing" article. > > In part, these are some of the issues I raised directly with Don in a > number > of emails (warning somewhat on the longish side ;): __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the offi

Re: How windows manage memory: oracle

2003-12-04 Thread Paul Baumgartel
gt; > 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 an E-Mail

RE: View definition oddities

2003-12-04 Thread Paul Baumgartel
ECTED] (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). > > &

RE: Copying stats between/amongst schemas

2003-12-02 Thread Paul Baumgartel
logged in > under the source schema owner user then you exec > dbms_stats.import_schema_stats(...) while logged in under the target > schema owner user? I wanted to do this under a DBA account which > doesn't > own anything. > > alter session set current_schema=Doh >

RE: Copying stats between/amongst schemas

2003-12-02 Thread Paul Baumgartel
Steve, I've done this: first export the source schema's stats from the dictionary into a user table, then import from that user table into the dictionary for the target schema. (Use CREATE_STAT_TABLE to create the user table.) Paul Baumgartel --- "Orr, Steve" <[EMAIL

Verifying success of dbms_repcat.execute_ddl

2003-12-02 Thread Paul Baumgartel
_ the DDL has been run on each master database (I am running a batch job that disables all FKs, then runs an import; the first attempt produced failures because the row insertions caused by the import arrived at the other master DB _before_ the FK disablement). Any help appreciated. TIA. = Pau

RE: Any articles/books that take relational theory and make it

2003-11-20 Thread Paul Baumgartel
ervices > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mail

Re: FW: SAN configuration for Banner

2003-11-19 Thread Paul Baumgartel
onfigured on the > SAN for the B80 and 6C4 computers. Sam has told me that, in the > Oracle > community, mirroring (RAID1) is preferred over RAID 5 for various > reasons (RAID5 is: more costly for write-intensive applications, 3 > times > more likely to incur data loss, suffers from massi

RE: SQL Query

2003-11-14 Thread Paul Baumgartel
Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fa

RE: Re: Logical StandBy question

2003-11-12 Thread Paul Baumgartel
___ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 htt

Re: Logical StandBy question

2003-11-12 Thread Paul Baumgartel
t; -- > Author: Jose Luis Delgado > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ---------

Re: How do you genrate primary keys?

2003-11-05 Thread Paul Baumgartel
> -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Yong Huang > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California -- Mailing li

Re: shareplex: datatype unsupported

2003-11-05 Thread Paul Baumgartel
--- > To REMOVE yourself from this mailing list, send an E-Mail message > 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

Re: PCTFREE and PCTUSED

2003-11-04 Thread Paul Baumgartel
rcentage of used space falls below PCTUSED", didn't you? = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identity with Yahoo! Mail AddressGuard http://antispam.yahoo.com/whatsnewfree -- Please see the offici

Re: database terminated

2003-11-04 Thread Paul Baumgartel
ntaining: 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 Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identit

Function calls, queries, and trace files

2003-11-04 Thread Paul Baumgartel
reasing "dep" values (with detours for "true" recursive SQL, such as data dictionary access, that follows Cary's rule)? TIA = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Protect your identity with Yahoo! M

"tim=" values in Windows 2k / Oracle 9.2.0.4 trace files

2003-10-31 Thread Paul Baumgartel
an the microsecond resolution values on Linux, so that would be, what, tenths of nanoseconds???). And I guess the Windows epoch is not the same as the Unix epoch (perish the thought). Has anyone figured out how to convert these to wall clock time values? TIA ===== Paul Baumgartel Transcentive, Inc. ww

RE: 10046 level 8 trace - help required with 'direct path write'

2003-10-30 Thread Paul Baumgartel
et > -- > Author: Tim Onions > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing list and web hosting services > ----- > To

Re: 10046 trace data question

2003-10-29 Thread Paul Baumgartel
****5 > __ Do you Yahoo!? Exclusive Video Premiere - Britney Spears http://launch.yahoo.com/promos/britneyspears/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgart

Re: 10046 trace data question--addendum

2003-10-29 Thread Paul Baumgartel
product or exempt from disclosure under applicable law. > If you have received this message in error, or are not the named > recipient(s), please immediately notify corporate MIS at (860) > 766-2000 and delete this e-mail message from your computer, Thank > you. > *********

RE: oracle internet directory

2003-10-29 Thread Paul Baumgartel
d 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 Transcentive, Inc. www.transcentive.com _

RE: dba interview questions

2003-10-29 Thread Paul Baumgartel
t; >>> Dear List, Can anyone send me a list of dba interview questions? > >>> > >>> Thanks, > >>> > >>> > > ___ > Get Your 10MB account for FREE at http://mail.arab

Unaccounted-for elapsed time

2003-10-28 Thread Paul Baumgartel
is output makes a couple of function calls...does the elapsed time here include the waits that the function calls might cause? I have 24 seconds of elapsed that aren't accounted for. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com ___

RE: VPN to database?

2003-10-27 Thread Paul Baumgartel
Never mind, I see that it is. Thanks. --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > Jared, > > Is that the book from sans.org? > > Thanks, > > Paul > > > --- Jared Still <[EMAIL PROTECTED]> wrote: > > Yes, I will ditto the recomme

RE: VPN to database?

2003-10-27 Thread Paul Baumgartel
t; To: Multiple recipients of list ORACLE-L > > > > > > We are an Application Service Provider--we maintain a set of > servers in > > a colocation facility and our customers use our application via the > > Web. Security is a paramount concern, of course, and only our W

Re: VPN to database?

2003-10-27 Thread Paul Baumgartel
ation, encryption, and > integrity. > > Anyone have experience using this? We are considering using > Entrust > > SSL authentication as we already use Entrust to authenticate users > of > > our app. Would Advanced Security replace a VPN, or coexist with > it? > >

RE: VPN to database?

2003-10-24 Thread Paul Baumgartel
Entrust to authenticate users of our app. Would Advanced Security replace a VPN, or coexist with it? = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com

VPN to database?

2003-10-24 Thread Paul Baumgartel
nd of configuration (network/firewall/VPN/Oracle Net) might make such access possible. TIA, = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? The New Yahoo! Shopping - with improved product search http://shopping.yahoo.com -- Please se

RE: Cary's book[Scanned]

2003-10-04 Thread Paul Baumgartel
Sure, I can take it. ;-) --- Rachel Carmichael <[EMAIL PROTECTED]> wrote: > you REALLY want an answer to that? > --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > > > > --- Bob Metelsky <[EMAIL PROTECTED]> wrote: > > >[snip] > > > > >

RE: Cary's book[Scanned]

2003-10-03 Thread Paul Baumgartel
mproved product search http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

Re: Describe privilege on procedures & packages

2003-09-30 Thread Paul Baumgartel
n > 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). __ Do you Yahoo!? The New Yahoo! Shopping - with

RE: OFA myths was Re: BAARF

2003-09-30 Thread Paul Baumgartel
gt; > 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 an E-Mail message > to

RE: Off Topic: PC Firewall Recommendation

2003-09-29 Thread Paul Baumgartel
o.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: (long and boring) "SQL AREA" and "LIBARARY CACHE" size?

2003-09-29 Thread Paul Baumgartel
ing). > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Tanel Poder > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California--

Re: Reality check for filesystem/disk layout

2003-09-26 Thread Paul Baumgartel
redo logs like fine > grained > stripe sizes) but given the mix of uses for each that doesn't seem > viable. > > > Comments, suggestions or even productive questioning of my sanity > would be > appreciated. > > > Thanks, > Jay Miller > >

Re: 10g: SQL Plus

2003-09-22 Thread Paul Baumgartel
HELP command for other information (like subscribing). ______ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: htt

RE: how can I see which database I am logged into without

2003-09-12 Thread Paul Baumgartel
rnia-- Mailing list and web hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') >

RE: alert log for physical standby?--pilot error

2003-09-11 Thread Paul Baumgartel
$ORACLE_HOME/rdbms/log. > If you have looked for the file with find (don't tell you are on > Windoze), have you used -follow ? > > HTH > > SF > > >----- --- Original Message --- - > >From: Paul Baumgartel <[EMAIL PROTECTED]> > >To: Mul

alert log for physical standby?

2003-09-11 Thread Paul Baumgartel
I've created a physical standby database that seems to be performing properly, but there's no alert log in user_dump_dest, nor anywhere else on the machine. Is there no alert log until/unless the standby undergoes a role transition? TIA = Paul Baumgartel Transce

Re: Tough Oracle DBA experience

2003-08-24 Thread Paul Baumgartel
he name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribin I don't respond to any messages that use "u" for the word "you". __ Do you Yahoo!? Yahoo! SiteBuilder -

Re: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Paul Baumgartel
Wow--that one sent me scrambling to Google. Nice riposte! --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > Paul Baumgartel wrote: > > > > A couple of corrections are in order here. First, some Christians > > might object to your characterizing the Holy Trinity

RE: URGENT!!! My 9i databases are not shutting down cleanly/cons

2003-08-21 Thread Paul Baumgartel
r than the intended recipient is strictly prohibited and may be > illegal. > If you have > received this communication in error, please notify the sender > immediately > by reply e-mail, > delete this communication, and destroy all copies. > > > Corporate Systems,

RE: Multiple parses with bind variables

2003-08-21 Thread Paul Baumgartel
.21 0.17 0 0 0 > > > Execute945 0.04 0.08 0 0 0 > > > Fetch 945 38.48 43.24 0 620428 0 > > > > = > Paul Baumgartel > Tr

Multiple parses with bind variables

2003-08-20 Thread Paul Baumgartel
1890 0.21 0.17 0 0 0 Execute945 0.04 0.08 0 0 0 Fetch 945 38.48 43.24 0 620428 0 = Paul Baumgartel Transcentive, Inc. www.transcentiv

Re: Partitioning

2003-08-14 Thread Paul Baumgartel
t to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ:

Re: oracle logical standby

2003-08-04 Thread Paul Baumgartel
abase? I had trouble to find the 9.2.3 doc. I really appreciate > for > your help. > > Joan > > Paul Baumgartel wrote: > > > > We were going to use logical standby but quickly abandoned the idea > > after testing. > > > > 1. The APPLY process

Re: oracle logical standby

2003-08-01 Thread Paul Baumgartel
. Then on the other hand-what things > should > someone try to leverage? > > thanks in advance! > > > Greg Loughmiller > > > = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? Yahoo! SiteBuilder - Free, eas

RE: Oracle to MSSQL conversion?

2003-08-01 Thread Paul Baumgartel
nd web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line cont

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Paul Baumgartel
> > > San Diego, California-- Mailing list and web > > > hosting services > > > > > > > > > > --------- > > > > To REMOVE yourself from this mailing list, send an E-Mail &

RE: Oracle to MSSQL conversion?

2003-07-31 Thread Paul Baumgartel
b hosting > services > > > - > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, inc

RE: 9i-OCP Question

2003-07-30 Thread Paul Baumgartel
isk failure? > > Cheers, > > -Roy > > Roy Pardee > Programmer/Analyst/DBA > SWFPAC Lockheed Martin IT > Extension 8487 __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com --

RE: logon trigger to start tracing

2003-07-23 Thread Paul Baumgartel
//sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: logon trigger to start tracing

2003-07-23 Thread Paul Baumgartel
That's it! Thanks...sometimes I forget that a trigger is a stored object, too. Regards, --- Wolfgang Breitling <[EMAIL PROTECTED]> wrote: > The logon user needs to have granted "alter session" privileges > directly to > her, not just through a role. = Pau

RE: logon trigger to start tracing

2003-07-23 Thread Paul Baumgartel
port.start_trace (waits => false, binds => false) ; > end ; > / > DISCONNECT > > logon as user X: > trace file created > > logon as user Y: > no trace file created > > logon as user Y, say "alter sesssion set current_schema = X ;" > no trace file cr

logon trigger to start tracing

2003-07-22 Thread Paul Baumgartel
cient privileges ORA-06512: at "SYS.DBMS_SESSION", line 126 ORA-06512: at line 2 When SQL statements are executed in the session, no further trace information is added to the file. Anyone know what's going on here? TIA = Paul Baumgartel Transcentive, Inc.

Re: Oracle has out-smarted me again.

2003-07-16 Thread Paul Baumgartel
quot;About"; version showed as 2.2.0.18.0. = Paul Baumgartel Transcentive, Inc. www.transcentive.com __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Aut

Re: Oracle has out-smarted me again.

2003-07-16 Thread Paul Baumgartel
you tell > the > install where "some" is? > > > > > > > Paul Baumgartel > >recipients of list ORACLE-L <[EMAIL

Re: Oracle has out-smarted me again.

2003-07-15 Thread Paul Baumgartel
> 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now o

RE: High availability and upgrades

2003-07-10 Thread Paul Baumgartel
mirror is split off, the two nodes continue to run against two mirrored copies, correct? Thanks! Paul Baumgartel --- Matthew Zito <[EMAIL PROTECTED]> wrote: [snip] > What about a storage-level solution? Either at the software (i.e. > Veritas) or hardware (i.e. your big honkin' st

Re: High availability and upgrades

2003-07-10 Thread Paul Baumgartel
. We'd like to use the secondary database for > > reporting as well, so a physical standby isn't practical. > > > > RAC doesn't give us a second database copy. > > > > Multimaster replication requires that changes to replicated objects > be > &g

High availability and upgrades

2003-07-10 Thread Paul Baumgartel
ven't tested Streams yet. I'd be interested in hearing of any experiences from those who have the same or similar requirements. Paul Baumgartel __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official O

Re: Logical standby?

2003-07-03 Thread Paul Baumgartel
Even some of the MetaLink papers are buggy--I was advised to rely on the 9.2.0.2.0 docs. --- Stephane Faroult <[EMAIL PROTECTED]> wrote: > Paul Baumgartel wrote: > > > > OK, I'm going to aim a little lower: is _anyone_ using Logical > > Standby? Any tips, got

Logical standby?

2003-07-02 Thread Paul Baumgartel
OK, I'm going to aim a little lower: is _anyone_ using Logical Standby? Any tips, gotchas, implementation accounts to share? TIA = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do you Yahoo!? SBC Yahoo! DSL - Now only $

Re: Logical standby

2003-07-01 Thread Paul Baumgartel
sense here? ;-) --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > I have successfully (on the third attempt) gotten a logical standby > database up, running, and applying changes from the primary. > However, > I quickly ran into a problem, and I'm wondering if anyone else ha

Logical standby

2003-07-01 Thread Paul Baumgartel
mpathy are welcome. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: RMAN Recovery Question: Restore with loss of control files an

2003-07-01 Thread Paul Baumgartel
REMOVE yourself from this mailing list, send an E-Mail message > 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

Re: printing out of Pl/SQL

2003-06-27 Thread Paul Baumgartel
tp://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and we

Re: WHY IT DOES NOT WORK ==> rman target "/ as sysdba" THANKS

2003-06-27 Thread Paul Baumgartel
x27;) 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). __ Do you Yahoo!? SBC Yahoo! DSL - Now on

Re: Oracle 9.2 RAC on Win2K?

2003-06-25 Thread Paul Baumgartel
and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line contain

Re: Passing array as input to procedure from sqlplus-HELP

2003-06-17 Thread Paul Baumgartel
> also send the HELP command for other information (like subscribing). __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paul Baumgartel

RE: Oracle Names

2003-06-12 Thread Paul Baumgartel
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). __ Do you Yahoo!? Yahoo! Cal

Re: World premier performance of the BAARF party logo

2003-06-12 Thread Paul Baumgartel
sage 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). __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Ou

DBA ignorance (was Win2k memory weirdness)

2003-04-04 Thread Paul Baumgartel
://www.orafaq.net -- 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 - To REMOVE yourself from this

Memory strangeness on Win2k

2003-04-04 Thread Paul Baumgartel
g the instance, but any other ideas would be appreciated. I really prefer running Oracle on Unix. TIA, Paul Baumgartel __ Do you Yahoo!? Yahoo! Tax Center - File online, calculators, forms, and more http://tax.yahoo.com -- Please see the official ORA

OEM jobs on Win2K

2003-04-02 Thread Paul Baumgartel
Hi all. I've just entered the world of Oracle on Windows. My first question regards the mechanism used to run jobs that are created using OEM.How does OEM execute RMAN, or export, for example? Thanks Paul Baumgartel __ Do you

Re: High current mode buffer gets on insert

2003-03-14 Thread Paul Baumgartel
I thought I'd repost to see if I could get a response. Anyone? --- Paul Baumgartel <[EMAIL PROTECTED]> wrote: > I'm looking at a client's tkprof output, showing among other things > that the insertion of about 135,000 rows taking 450 seconds of CPU, > and &

High current mode buffer gets on insert

2003-03-13 Thread Paul Baumgartel
g the load. Am I correct in concluding that the high CPU, and especially the current mode block gets numbering over 6 times the number of rows inserted, are due to index updates? Thanks! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL

FalconStor and Oracle performance

2003-03-06 Thread Paul Baumgartel
rom anyone who's worked with FalconStor or similar products and can suggest other things to investigate. TIA, Paul Baumgartel __ Do you Yahoo!? Yahoo! Tax Center - forms, calculators, tips, more http://taxes.yahoo.com/ -- Please see the offici

RE: Where is result set maintained?

2003-02-06 Thread Paul Baumgartel
> When one executes a query, the result set is identified. Fetching > the > rows in the result set can be done over a period of time. In what > form > does Oracle maintain the result set, and where? > > TIA > > Paul Baumgartel > > > ___

Where is result set maintained?

2003-02-05 Thread Paul Baumgartel
When one executes a query, the result set is identified. Fetching the rows in the result set can be done over a period of time. In what form does Oracle maintain the result set, and where? TIA Paul Baumgartel __ Do you Yahoo!? Yahoo! Mail Plus

Re: Replication..

2003-01-29 Thread Paul Baumgartel
ficial ORACLE-L FAQ: http://www.orafaq.net > -- > Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > San Diego, California-- Mailing li

Re: Oracle Advanced Replication

2002-12-11 Thread Paul Baumgartel
o be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the of

Re: Common PL/SQL package to truncate tables

2002-12-11 Thread Paul Baumgartel
ces > Thomson, Inc. > > Email: [EMAIL PROTECTED] > > Indy DBA Master Documentation available at: > http://gkmqp.tce.com/tis_dba > Select 'Indy DBA' then 'DBA Web Pages' > > > > ___

Re: Invalid Objects but no errors

2002-11-15 Thread Paul Baumgartel
ormation (like subscribing). __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED]

Re: Slow Inserts

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

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 em

Re: VIEWS/ROLES/PRIVS

2002-11-01 Thread Paul Baumgartel
rch new jobs daily now http://hotjobs.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-- Mailing list and web hosting servic

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

2002-10-29 Thread Paul Baumgartel
u want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do you Yahoo!? HotJobs - Search new jobs daily now http://hotjobs.yahoo.co

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

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

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 fir

SQL*Plus COPY error

2002-10-25 Thread Paul Baumgartel
osed to. TIA! __ 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://ww

PDBA toolkit (from Perl for Oracle DBAs) question

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

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

2002-10-16 Thread Paul Baumgartel
ations does not represent that this transmission is free of > errors, > viruses or interference. > > > __ Do you Yahoo!? Faith Hill - Exclusive Performances, Videos & More http://faith.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.

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

2002-10-04 Thread Paul Baumgartel
t; die, > probably me. *-) > > Dick Goulet __ 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 Ser

RE: datafile sizing question

2002-09-25 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-50

Satisfied customer

2002-09-11 Thread Paul Baumgartel
ad hoped to put a face 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

Re: Question about database and service name

2002-09-05 Thread Paul Baumgartel
trick in the TNSNAMES.ORA and LISTENER.ORA files. > > Please can anyone give some light in that, I am totally confused !!! > > > Ramon E. Estevez > [EMAIL PROTECTED] > 809-565-3121 > > __ Do You Yahoo!? Yahoo! Fina

RE: Replication question

2002-09-05 Thread Paul Baumgartel
eplication of an object, it > creates a package called $RP. This package contains > code > to be run 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

  1   2   3   >