RE: redo log maintenance

, 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: Thursday

RE: Constant Date in SQL*Loader Control File

') 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 INET: [EMAIL PROTECTED

RE: Constant Date in SQL*Loader Control File

). -- 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

redo log maintenance

ntity 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,

Upgrade gotchas - 8.1.7.4-9.2.0.3 on Windows

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, California-- Mailing list and web hostin

RE: Database components

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

RE: dbms_stats.gather_schema_stats

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, California-- Mailing list and web

Is this thing on?

ruses 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 Network Services

RE: Shite of the day

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 exp/imp... I can't even export my database. -Original

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

(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-5051 http

FW: Shite of the day

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 Diego, California

RE: Shite of the day

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 Diego, California-- Mailing list and web

RE: Shite of the day

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 Network

RE: Shite of the day

- 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 thinks it's in recovery and I can't force it to do an incomplete

RE: cannot allocate new log

Milton Park Abingdon Oxfordshire OX14 4SH Phone: +44 (0) 1235 838151 Fax:+44 (0) 1235 838160 Direct Line: +44 (0) 1235 838147 ___ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Koivu, Lisa INET

RE: dbms_stats broken

-- 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 - To REMOVE yourself from this mailing list

RE: dbms_stats

: 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 - To REMOVE yourself

RE: dbms_stats broken

://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 - To REMOVE yourself from

RE: dbms_stats

') 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 INET: [EMAIL

Unbreakable, my buns. Upgrade to 9.2/w2k

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 - To REMOVE

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

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

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

the database in 9.2. OUI did not upgrade successfully. Koivu, Lisa Lisa.Koivu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @Fairfieldresort cc

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

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. Koivu, Lisa Lisa.Koivu To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

dbms_stats broken

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

PGA question

r 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, California-- Mailing list and web hostin

Skill Sets - This may be a dumb question

r 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, California-- Mailing list and web hostin

RE: Skill Sets - This may be a dumb question

: 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 - To REMOVE yourself from this mailing list, send an E-Mail message

AIX 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, California-- Ma

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

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.

Service startup on Windows 2000 fails

-- 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

GRRRRR OWS

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-- 858-538-5051 http

RE: Service startup on Windows 2000 fails

the services? I would trya reboot first before looking at other things. Could you try that and then tell us how it goes? Wayne Straughn Database Administrator Barbados Light Power Co Ltd -Original Message-From: Koivu, Lisa

RE: Service startup on Windows 2000 fails

. 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 Wayne, Thanks so much for responding. I

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

-- 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 - To REMOVE yourself from this mailing list, send

RE: Rman and database shutdowns UPDATE

-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-5051

RE: Breaking down values in a large table

John, Look at the FILESIZE parm of export. Lisa Koivu OracleMonkey 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

RE: Count(*) last 30 seconds

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

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

). -- 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: SQL Plus Environment

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 Diego

RE: Question about RMAN and recovery scenario.

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 Diego, California

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 place,

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

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

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 Tuning Question Goo

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 a

RE: AIX 4.3.3 / 8.1.7 Timed Statistics Tuning Question

(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 -Original Message- From: Koivu,

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.txt

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

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

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

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, which works

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 L.

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 OracleDiaper

RE: index hint ignored?

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 in size, 20

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 mean

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 the

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

now for a 10K run since it is the high 70s where I work likely around 70 on the beach. Point your browser at www.camzone.com and click the on the Del Mar Beach Cam link. I'll wave as I go buy in about 1 hour. HAND! Koivu, Lisa Lisa.Koivu@efair To: Multiple recipients of list ORACLE-L

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]]

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: Take Care of your DBAs

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 exercise of any type and thought I was crazy for going running over lunch

RE: Peoplesoft Oracle

Financial [EMAIL PROTECTED] From: Koivu, Lisa [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Peoplesoft Oracle Date: Tue, 28 Jan 2003 13:08:59 -0800 Hello everyone, My apologies for bombarding the list with more questions than answers

RE: Global Stats

: 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 :) I've been reading up

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? What is

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:

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

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

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

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

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

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 SID

RE: 100% CPU utilization, urgent

choose any/all of the threads and then choose ADD. The value now in the performance monitor will show you the actual thread ID that you can match to the SPID column in V$PROCESS. For ex. SELECT s.* FROM v$session s, v$process p where p.spid='spid_in_perf_mon' and p.addr=s.paddr; Rick Koivu

RE: 100% CPU utilization, urgent

of 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 explicit, here's what I've got: Lisa

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,

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 fails

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 AM

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:

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 whew! I really

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

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

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: 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 OracleDork Administrator Fairfield Resorts, Inc.

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

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: 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 legs

RE: Orawomen

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 in college (1999) but I always felt singled out

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

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

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

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

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

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

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: Subject: Perl DBI/SQL question - For those who use it... Hi everyone, This may

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 Sent

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

, 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. In true ksh style I had written my loads

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: ORA-1410 Silliness

and do not necessarily represent those of Oracle Corporation. Koivu, Lisa wrote: Hello all, 8.1.7, Windows 2000 SP2 Here's the error: * ERROR at line 1: ORA-01001: invalid cursor ORA-06512: at ELVIS.CLEANUP_VEGAS_PK, line 1970 ORA-01410: invalid ROWID ORA-06512: at line 1 Has

RE: ORA-1410 Silliness

"ELVIS.CLEANUP_VEGAS_PK" in the error message. Is it the primary key index for a table? If yes, then it may need to be rebuilt. Regards, waleed -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002

RE: ORA-1410 Silliness

Nope... -Original Message-From: ora ak [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 4:54 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness Did u do any migration recently . "Koivu, Lisa" [EMAIL PROTECTED] wrote:

RE: ORA-1410 Silliness

that, I know of no freeware one :) since you say this has only recently started happening, and since the sql runs on its own, what else has changed since the problem started? Amount of data? Other apps on the box taking away memory? Rachel --- Koivu, Lisa [EMAIL PROTECTED] wrote: Hi Rachel

RE: ORA-1410 Silliness

e-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 31, 2002 12:49 PMTo: Multiple recipients of list ORACLE-LSubject: RE: ORA-1410 Silliness You asked for it. Here goes. It is partitioned on julian_run_date. Please don't hammer me about the design

RE: ORA-1410 Silliness

? --- Koivu, Lisa [EMAIL PROTECTED] wrote: Amount of data, definately. This table grows by ~2.5GB weekly. Have you ever seen data volume begin to cause problems? Thanks Rachel -Original Message- Sent: Tuesday, December 31, 2002 5:05 PM To: Multiple recipients of list ORACLE-L Okay

  1   2   3   4   5   6   >