RE: redo log maintenance

dding, dropping and switching logfiles ever since the version 6 and I have never needed to shut down the database for it.   Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]Sent: Thu

redo log maintenance

. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Constant Date in SQL*Loader Control File

ame of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Net

RE: Constant Date in SQL*Loader Control File

essage 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). -- Please see th

Upgrade gotchas - 8.1.7.4->9.2.0.3 on Windows

entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

RE: dbms_stats.gather_schema_stats

. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Database components

tGuru') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu

Is this thing on?

ction about viruses and other defects. The sender's business entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City N

RE: Shite of the day (now 9i upgrade)

ist, 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 HELP command for other information (like subscribing). -- P

RE: Shite of the day

IBLE check when version 10 comes out. > -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED]] > > No.  I guess by manual I mean I didn't use the gui. I ran the > appropriate upgrade script. > > Gosh I hope it doesn't come to e

RE: Shite of the day

> -Original Message- > From: Koivu, Lisa [mailto:[EMAIL PROTECTED] > Sent: Wednesday, June 04, 2003 1:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Shite of the day > > > Hi Ganesh, > > Thanks for your reply. Still, no dice. Now it t

RE: Shite of the day

ACT 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq

RE: Shite of the day

me of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fa

FW: Shite of the day

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-5

RE: cannot allocate new log

_ Nuala Cullen Catlogic 30 Park Gate Milton Park Abingdon Oxfordshire OX14 4SH Phone: +44 (0) 1235 838151 Fax:+44 (0) 1235 838160 Direct Line: +44 (0) 1235 838147 ___ -- Please

RE: dbms_stats

ing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: dbms_stats broken

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City N

RE: dbms_stats

Kanagaraj 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 an E-

RE: dbms_stats broken

RACLE-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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

dbms_stats broken

Hello everyone,   Is anyone using dbms_stats and gather stale or gather auto in 9.2?  I’m trying to use dbms_stats gather schema stats with the stale option and it just isn’t working in 8.1.7.4.  This is documented on Metalink.  I’d love to hear from someone else if this is fixed in 9.2

RE: Unbreakable, my buns. Upgrade to 9.2/w2k

: 5/28/2003 11:56 AM > > > I was not able to upgrade an 8.1.7.0 database to 9.2.0.1.0 on Win2K. > I > had > to create a new Oracle home, install 9.2, and clone the database in > 9.2. > OUI did not upgrade successfully. > > > > > >

RE: Unbreakable, my buns. Upgrade to 9.2/w2k

, and clone the database in 9.2. OUI did not upgrade successfully. "Koivu, Lisa" @Fairfieldresort cc: s.com> Subject: Unbreakable,

RE: Unbreakable, my buns. Upgrade to 9.2/w2k .... repost

2k I have upgraded 16 databases ( manually using the scripts and procedures in metablink as a guide ) with very few problems and only then on the 1st ones I did. We were going from 8174 ro 92021 on Win2k SP3. -----Original Message-From: Koivu, Lisa

Unbreakable, my buns. Upgrade to 9.2/w2k

Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web h

PGA question

r any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cali

RE: Skill Sets - This may be a dumb question

;s business entity is not liable for any loss or damage arising in any way from this message or its attachments."-- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, Califo

Skill Sets - This may be a dumb question

#x27;s business entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcit

RE: AIX question

Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA 33063 Office: 954-935-4117 Fax:954-935-3639 Cell:954-683-4459 -Original Message- Sent: Friday, February 21, 2003 3:23 PM To: [EMAIL PROTECTED] Cc: Koivu, Lisa Try this: lsdev -C -c adapter (to

AIX question

entity is not liable for any loss or damage arising in any way from this message or its attachments." -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Cal

RE: dbms_debug

Title: RE: dbms_debug I have been chastised before for leaving packages compiled in debug mode before.  Suppossedly it incurs a performance hit.    Of course I was doing this through SQL*Navigator, not command line.   And of course I have been chastised for much worse.   Mrs. Monkey.

RE: Veritas Agent for Oracle / incremental backups vs. hot

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Service startup on Windows 2000 fails

out of my tree." Mrs. Monkey. -Original Message- Sent: Wednesday, February 19, 2003 2:30 PM To: [EMAIL PROTECTED]; Koivu, Lisa Please tell us what caused the problem and how you solved it. -- Lyndon Tiu Quoting "Koivu, Lisa" <[EMAIL PROTECTED]>: > Hi Wayn

RE: Service startup on Windows 2000 fails

  -----Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, February 19, 2003 10:09 AMTo: Multiple recipients of list ORACLE-LSubject: Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1

GRRRRR OWS

field Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063 Office: 954-935-4117  Fax:    954-935-3639 Cell:    954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 85

Service startup on Windows 2000 fails

  Fax:    954-935-3639 Cell:    954-683-4459 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Rman and database shutdowns UPDATE

tGuru') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa

RE: SQL Plus Environment

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City

RE: [new info] Redhat Advanced Server Dev Edition - RAC

] 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: [EMAIL PROTECTED]

RE: Count(*) last 30 seconds

Title: Message well, have you traced the statement yet?  That's where to start, with autotrace.   My count(*) which executes a FTS (in a load to mitigate any ORA-1555 error) takes 15 minutes to count 50 million rows.   Lisa Koivu Tired, Tired, Tired. Fairfield Resorts, Inc. 5259 Coconut

RE: Breaking down values in a large table

John,   Look at the FILESIZE parm of export.   Lisa Koivu Oracle Monkey Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063 Office: 954-935-4117  Fax:    954-935-3639 Cell:    954-683-4459 -Original Message-From: John Hallas [ma

RE: Question about RMAN and recovery scenario.

ist you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Di

RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

g up all the memory on the box when one of the jobs is run (not sure which one), appears to be a memory leak of some sort, we are working on it (just a note, the peoplesoft environment is not the AIX environment I spoke about). - Ethan

RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Hi Henry,   OS isn't paging when I've looked.  But with the memory this low it seems to me paging could happen pretty darn quick.   There are a couple of logins that can run reports.  These aren't big databases but as you know

RE: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

t environment is not the AIX environment I spoke about).   - Ethan -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Thursday, February 06, 2003 8:24 AMTo: Multiple recipients of list ORACLE-LSubject: AIX 4.3.3 / 8.1.7 & Timed Statistics &

RE: Looking for simple monitor script dbup.bat

Title: RE: Looking for simple monitor script dbup.bat Hi Bob, Check out Steve Adams' script (www.ixora.com.au).  It's written in ksh and will need a little modification to send emails, but it's bulletproof.  Also others on the list have mentioned Cygwin (?) the Windows-ksh to allow this to

AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question

Title: AIX 4.3.3 / 8.1.7 & Timed Statistics & Tuning Question Good morning everyone - Quick poll for those of you on 8.1.7 and AIX 4.3.3:  Do you have TIMED_STATISTICS = true?  Have you encountered any problems with it? The databases I inherited have this set false all over the plac

RE: Re[2]: awk and ksh question - solved

Title: RE: Re[2]: awk and ksh question - solved I'll check it out.  Yes that sounds like it would be easier.  That is, when our cluster finally comes back up and the app servers are fixed.  GRR Thanks to all that replied. -Original Message- From: Robert Eskridge [mailto:

RE: awk and ksh question - solved

Title: RE: awk and ksh question - solved Stephen, I'm aware of the syntax.  My question was, WHY??  Robert hit it on the head, awk and ksh are both interpreting $1. Anyway I solved the problem with shift, like this.  Thanks to all that replied.  export PAGER= export PAGERFILE=dba_oncall.t

awk and ksh question

Title: awk and ksh question Hello everyone, I'm trying to awk through a text file and use that with a passed-in message to send email.  Here's an example of my text file: # DBA's on call [EMAIL PROTECTED]    # Lisa pager [EMAIL PROTECTED]    # Lisa email Here's my awk statement, w

OT: Sendmail, never mind

Title: OT: Sendmail, never mind Of course I stumbled across the fix two minutes after I threw my hands up. My apologies for adding to the list volume.  Sorry. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063

OT: Help - AIX and Sendmail

Title: OT: Help - AIX and Sendmail Hello everyone , Sendmail and mailx isn't working on my two AIX hosts.  I can send mail from the host if I do it manually via telnet port 25 but I can't figure out how to configure it properly.  My knowledge of networking is basically zilch. If anyone h

RE: index hint ignored?

a braindead Friday.   LK -Original Message-From: Cunningham, Gerald [mailto:[EMAIL PROTECTED]]Sent: Friday, January 31, 2003 2:32 PMTo: Koivu, Lisa; [EMAIL PROTECTED]Subject: RE: index hint ignored? Thanks, Lisa.   This particular table is rather small (~20,000 rows, 1.3 Mb

RE: index hint ignored?

Title: Message Hi Jerry,   Methinks it's because this is a small table.  20 records?  Peanuts.  Why bother with the index.   On the same token you should probably not spend a lot of time worrying about this...  unless this is just a learning exercise :)   hth Lisa Koivu Oracle Diaper Adm

RE: Check for all numeric in a column

Title: Message Hi Ron -   in pl/sql, try and convert it with to_number and catch the error if it won't convert.   Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063     -Original Message-From: Smith, Ron

RE: "Take Care of your DBAs"

"Take Care of your DBAs" Hallo, what is exercise? > "Koivu, Lisa" wrote: > > Hi Dennis, Point taken.  Most of us can't feed ourselves on our > physical abilities...  my point was that most of the people I have met > in IT are not into regular exerci

RE: comparing null values

Title: RE: comparing null values Gary I think this goes back to the classic definition of NULL.  NULL means "unknown value".  Therefore you can't say anything definite about the value.  So it is not equal to anything or like anything, period.  It is "IS NULL" from a SQL perspective. HTH

RE: Restricting the range of values in a field

Title: RE: Restricting the range of values in a field Yes.  Read up on check constraints. Lisa Koivu Oracle Diaper Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063 -Original Message- From: Aidan Whitehall [mailto:[EMAIL PROTECTED]] S

RE: RMAN backup/restore to disk on 600G - terabyte Databases?? SP

the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND!     "Koivu, Lisa"   of list ORACLE-L <[EMAIL PROTECTED]>   field.com>   

RE: Creating a simple stored procedure

Title: RE: Creating a simple stored procedure Hi Bob, first of all who are you creating the sp as?  If it's not the table owner, is there a synonym declared?  Is update granted via a role?  If it is, grant update directly to the procedure owner. Or forget all this and run the proc as t

RE: "Take Care of your DBAs"

Title: RE: "Take Care of your DBAs" Hi Dennis, Point taken.  Most of us can't feed ourselves on our physical abilities...  my point was that most of the people I have met in IT are not into regular exercise of any type and thought I was crazy for going running over lunch. Sorry I did not mea

RE: "Take Care of your DBAs"

Title: RE: "Take Care of your DBAs" I used to play Ping Pong with the sysadmins and the app architect...  aahh, the glory dotcom days when I could bring my dog to work :) Most of the dba's I have met are not into physical activity and exercise. -Original Message- From: [EMAIL PROTE

RE: SQL question

Title: RE: SQL question Elegant or not, here's how I'd do it select count(*) from (select distinct ename, job from emp); -Original Message- From: Charu Joshi [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 1:19 PM To: Multiple recipients of list ORACLE-L Subject: SQL

RE: Peoplesoft & Oracle

Title: RE: Peoplesoft & Oracle John, Henry, Lindsay, David, Thanks for your responses.  At least I don't feel like I'm completely out in the cold here.  John:  My boy is huge, teething, not sleeping much, standing and taking his first steps, had his first bloody nose already.  Sleep?  Wh

RE: Global Stats

EMAIL PROTECTED]] Sent: Wednesday, January 29, 2003 3:55 AM To: Multiple recipients of list ORACLE-L Subject: Re: Global Stats You may want to read up on table monitoring. Jared On Tuesday 28 January 2003 11:10, Koivu, Lisa wrote: > Hi everyone, > > Back to the lovely world of Oracle

RE: Peoplesoft & Oracle

er connection. You might as well be tortured like the rest of us trying to find things. David Davis, DBA Manulife Financial [EMAIL PROTECTED] >From: "Koivu, Lisa" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROT

Global Stats

Title: Global Stats Hi everyone, Back to the lovely world of Oracle :) I've been reading up on statistics.  Out of the 8.1.7 doco: /* Partitioned schema objects may contain multiple sets of statistics. They can have statistics which refer to the entire schema object as a whole (global st

Checklist - Ken Janusz??

Title: Checklist - Ken Janusz?? Hello everyone, I saw a check list posted to the list a couple of days ago.  Well, wouldn't you know it - Hours ago I inherited an Oracle/Peoplesoft/AIX environment and I need that check list because I am talking to the previous DBA in just a couple of hours

Check list - never mind...

Title: Check list - never mind... I found it in the archives of the list on the website.  Sorry... Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063

RE: dbms_job - running jobs every 15 minutes

Title: RE: dbms_job - running jobs every 15 minutes Cron?  How RELIABLE !! -Original Message-From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 22, 2003 10:10 AMTo: Multiple recipients of list ORACLE-LSubject: RE: dbms_job - running jobs every 15 min

RE: 100% CPU utilization, urgent

list ORACLE-L Subject: RE: 100% CPU utilization, urgent On Mon, 20 Jan 2003, Koivu, Lisa wrote: > Thomas, thanks for your post. > > However I don't see where I can match the threads on NT to what I see in > Task Manager.  Am I missing something? > > To be more explici

RE: 100% CPU utilization, urgent

nd p.addr=s.paddr; Rick          "Koivu, Lisa"             

RE: 100% CPU utilization, urgent

Title: RE: 100% CPU utilization, urgent Thomas, thanks for your post.  However I don't see where I can match the threads on NT to what I see in Task Manager.  Am I missing something?  To be more explicit, here's what I've got: SQL> select * from dba_nt_threads; ID_THREAD B NAME 

RE: Database Verification

Title: RE: Database Verification FWIW: The other answers have been correct as to what to do to check for corruption. As far as preventing it??  I don't know of a way you can PREVENT it from happening.  When it happens, it's usually something out of your hands (bad hardware, glitch in OS,

RE: HELP..URGENT....NOT

Title: Message WOW this is awesome!  I hope a lot of these links are still alive. Thanks for sending this. -Original Message-From: Farnsworth, Dave [mailto:[EMAIL PROTECTED]]Sent: Thursday, January 16, 2003 10:50 AMTo: Multiple recipients of list ORACLE-LSubject: RE: HELP.

RE: Installer does not run on Win 2k Service Pack 3

Title: RE: Installer does not run on Win 2k Service Pack 3 Hi Rick, are you on Pentium 4 Processor?  If so check out note 1312999.1  This has happened to me many, many times. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 16, 2003 9:09 A

event parm question

Title: event parm question Good morning everyone, Has anyone ever had new errors or performance problems pop up after setting an event parameter?  I set event=1410 trace name errorstack in my 8.1.7/w2k database to catch ora-1410 errors.  Since I have done that, one query in particular fail

RE: dw tool question

Title: RE: dw tool question Hi Bruce, Thank you so much for your comments.  Turns out I have a lot to learn about Brio.  It's not my job to create the metadata layer in the app so I passed that info on to our report programmer.  She knew exactly what you were talking about   I really though

RE: How to identify full table scans?

Title: RE: How to identify full table scans? Govind, Just curious why you are attacking the full table scans.  I implemented something like this in the past utilizing Steve Adams' script expensive_sql.sql.  It was very telling and very very useful. Lisa Koivu Oracle Database Administrator

RE: dw tool question

Title: RE: dw tool question This is something I am currently dealing with. We have two products here:  Business Objects and BRIO.  It depends on what kind of end-user you expect to support.  The main difference I see between these two is that Business Objects can easily hide the metadata de

RE: 8.1.6: possible to set role in db's logon trigger?

Title: RE: 8.1.6: possible to set role in db's logon trigger? Hi Roy, Note 122230.1 will answer your first question about session id's. Lisa Koivu Oracle Dogbone Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063 -Original Message---

RE: Which session is killing performance?

Title: RE: Which session is killing performance? HI Craig, try these scripts set linesize 200 column username format a15 column idle format a10 column machine format a22 column terminal format a15 column program format a15 select  sid,     serial#,     username, --  process,   

RE: Query optimization

Title: RE: Query optimization Have you tried NO_EXPAND? Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063 -Original Message- From: Krishnaswamy, Ranganath [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 0

RE: RMAN on NT

Title: Message Hi Ron,   I've been using RMAN on Windows 2000.  I do my backups to disk so I don't have to deal with third party tape software.  Each time I have tested a recovery it seems to work fine.  I am 8.1.7.2, W2K sp2   Lisa Koivu Oracle Dork Administrator Fairfield Resorts, Inc.

RE: RMAN and disk usage info

Title: RE: RMAN and disk usage info I've seen this on my Windows system.  It creates one huge file for each channel to disk and the file size shrinks a bit after backup completion.  I never tried to determine what is controlling the initial file sizes (heck, it's working and someone is screami

RE: Orawomen

attribute this to the parents.   My $.02   Dave -----Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Wednesday, January 08, 2003 8:34 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Orawomen Well, it's been a while since I was

RE: Orawomen

Title: RE: Orawomen Well, it's been a while since I was in college (1999) but I always felt singled out in a class.  Some teachers, that were as old as the hills, truly felt that women should not be in science and did not hesitate to say so.  Other teachers could not keep their eyes off my leg

RE: Long-running PL/SQL function (long)

Title: RE: Long-running PL/SQL function (long) Hi Cherie, Using pl/sql tables and bulk binding will increase the speed dramatically with both insert and cursor fetching.  I've done it myself many times with runaway success. Also, lookup tables can be cached in the procedure to avoid going

RE: FULL TABLE SCAN?

Title: RE: FULL TABLE SCAN? _full_table_scan=FALSE -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 07, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Subject: FULL TABLE SCAN? Hi How to avoid FULL TABLE SCAN? Thx -seema

FW: IOUG-A

Title: FW: IOUG-A Jonathan, if you do decide to give that class, I am definately interested.  $250 I can talk my boss into.  $1300 for IOUG-A, I can't.  (Ah, the joys of working for a non-IT-centric company.) Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Cr

RE: strange issue with setting transaction

Title: RE: strange issue with setting transaction Sergei, are you committing in your "transaction"?  A transaction ends with a commit or rollback.  Therefore if you execute set transaction use rollback... then commit, the next transaction will grab whatever rbs it wants unless you specify set

RE: Perl DBI/SQL question - For those who use it...

t 09:09:06AM -0800, Koivu, Lisa wrote: > Hi everyone, > > This may be a stupid question.  If so please humor me with a stupid answer. > However: > > I FINALLY have the fun fun fun chance to change one of my data loads to use > the DBI instead of the procedures I hacked together

RE: Perl DBI/SQL question - For those who use it...

Title: RE: Perl DBI/SQL question - For those who use it... I think I just answered my own question after reading through Charlie's example code... The errors that would be spit to the screen would be returned in $DBI::errstr.  Lisa -Original Message- From: Koivu, Lisa

RE: Perl DBI/SQL question - For those who use it...

is a WIP. If fact, it's not even to alpha stage yet. Jared "Koivu, Lisa" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED]  01/03/2003 09:09 AM  Please respond to ORACLE-L       To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>     cc:  

Perl DBI/SQL question - For those who use it...

Title: Perl DBI/SQL question - For those who use it... Hi everyone, This may be a stupid question.  If so please humor me with a stupid answer. However: I FINALLY have the fun fun fun chance to change one of my data loads to use the DBI instead of the procedures I hacked together.  In tr

RE: dbms_sql from stored procedure

Title: RE: dbms_sql from stored procedure Sarath, Go locally managed tablespace and forget about extent management.  It's just not worth it. Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 5259 Coconut Creek Parkway Ft. Lauderdale, FL, USA  33063 -Original Message

RE: create view using DBMS.SQL

e_definitions; View created. SQL> select count(*) from mytest;   COUNT(*) --    641 SQL> >From: "Koivu, Lisa" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE:

RE: ORA-1410 Silliness

u enable tracing? Do it -- you'll find *everything*. Kind Regards, -- Vladimir Begun The statements and opinions expressed here are my own and do not necessarily represent those of Oracle Corporation. Koivu, Lisa wrote: > Vladimir, > > Thanks for your reply. > I have tested the cur

RE: Automatic backup on Oracle 9i -- For Jared

Title: RE: Automatic backup on Oracle 9i -- For Jared Well if you want an answer from the experts on this list (or anyone, really - I fall into the 'shmo' category) it's best to ask a question in the clearest way possible...  otherwise your emails may go directly to the delete folder. Ur c

RE: functions/procedures and commits

Title: Message The behavior of this may have changed... but I have seen autocommit not work as advertised.  Just my opinion but I think explicit commits are good practice, if nothing else just for ease of reading code.    Lisa Koivu Oracle Database Administrator Fairfield Resorts, Inc. 525

RE: ORA-1410 Silliness

Jamadagni      MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message-From: Koivu, Lisa [m

  1   2   3   4   5   6   >