FAQ

Search Discussions

787 discussions - 2,454 posts

  • Position: Sr. Oracle DBA Location: Central part of Texas Description: This great telecom company needs an Oracle DBA=20 to provide database support. This is a staff position. Selected candidate ...
    OraStaffOraStaff
    Oct 24, 2000 at 6:51 pm
    Oct 28, 2000 at 12:12 am
  • oh that was minor compared to today's rant... a third party product that denormalizes tables because their "experts" told them that if you have more than 4 tables in a join performance suffers ...
    Rachel CarmichaelRachel Carmichael
    Oct 25, 2000 at 3:01 am
    Oct 26, 2000 at 11:52 am
  • Here we are using following SQL: select to_date('5-OCT-1582','DD-MON-YYYY') from dual; which is returning 15-OCT-1582, instead of 05-OCT-1582 Any Clue ? Sanjeev
    Sanjeev SachdevaSanjeev Sachdeva
    Oct 17, 2000 at 2:37 pm
    Oct 18, 2000 at 8:45 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0017_01C0384F.63FE0EA0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Guys and gals, We have a ...
    Mark LeithMark Leith
    Oct 17, 2000 at 2:31 pm
    Oct 20, 2000 at 5:20 pm
  • All, Last night our backups were not able to kick in as the shutdowns did not work. The trace file shows the following SESSION ID:(25.43498) 2000.10.12.18.08.57.034 SHUTDOWN: waiting for active calls ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Oct 13, 2000 at 8:09 am
    Oct 19, 2000 at 10:32 pm
  • [ahem] A little rude, but it rings a bell.... http://www.jeigh.com/werk/admin/ --- Dennis Taylor --- Don't worry about people stealing your ideas. If your ideas are any good, you'll have to ram them ...
    Dennis TaylorDennis Taylor
    Oct 26, 2000 at 10:05 pm
    Oct 31, 2000 at 11:42 pm
  • Hi all, My database has 2 redo log groups and each group has 3 members. Each members size is 1 meg each. The problem is that archive logs are generated at a fast rate: -rw-r----- 1 oracle dba 1056768 ...
    Larry TaylorLarry Taylor
    Oct 26, 2000 at 4:23 pm
    Oct 27, 2000 at 8:27 am
  • 15

    RAID

    All, I have seen various threads on the subject of Oracle and Raid but don't have any messages stored on the subject so forgive me for the repetition factor. Can someone provide a list of ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Oct 27, 2000 at 11:27 am
    Oct 30, 2000 at 7:22 pm
  • Hi everyone, I am not sure if there are any people in this list at this hour of the day. But we are facing a terrible situation here on the production system. And I will need some advice. For ...
    Winnie_Liu_at_infonet.comWinnie_Liu_at_infonet.com
    Oct 22, 2000 at 8:19 am
    Oct 24, 2000 at 4:28 pm
  • Hi, At what point in time does a rollback segment shrink back to its optimal value? Bill Carle AT&T Database Administrator 816-995-3922 wcarle_at_att.com
    Carle, William T (Bill), NBSOCarle, William T (Bill), NBSO
    Oct 17, 2000 at 1:17 pm
    Oct 23, 2000 at 2:31 am
  • 14

    OEM

    I'm trying to run the Oracle enterprise manager and it asks for the administrator login for the management server. The documentation specifies that the default login name is SYSMAN, but what is the ...
    Arun AggarwalArun Aggarwal
    Oct 25, 2000 at 5:22 am
    Oct 27, 2000 at 7:28 pm
  • Hello, Is Oracle 8.1.6 capable of creating and using a datafile on an NFS-mounted disk on another machine? We have two Sun machines (OS block size is 8k on both); the machine running Oracle is short ...
    Bill BeckerBill Becker
    Oct 24, 2000 at 3:41 pm
    Oct 26, 2000 at 1:34 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0387C.1FE26AEA Content-Type ...
    Bowes, ChrisBowes, Chris
    Oct 17, 2000 at 8:52 pm
    Oct 19, 2000 at 7:17 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C02D72.75CDDB70 Content-Type ...
    Satar NaghshinehSatar Naghshineh
    Oct 3, 2000 at 7:45 pm
    Oct 5, 2000 at 11:38 am
  • Some of our objects have up to 3000 extents and we are starting to have load issues and performance issues. I know that I need to do an export, recreate the object with a larger initial extent and ...
    Cemail_at_sprintmail.comCemail_at_sprintmail.com
    Oct 10, 2000 at 12:28 am
    Oct 17, 2000 at 2:00 pm
  • Check you NLS_DATE_FORMAT and make sure you have it set to DD-MON-RR (Based on your format) and not DD-MON-YY. The RR causes it to respect the Y2K issues. If you can't bounce the database to reset ...
    Shaw, GlenShaw, Glen
    Oct 13, 2000 at 2:40 pm
    Oct 13, 2000 at 7:55 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_001D_01C0337A.1EE38DB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Guy's I've been asked a ...
    Mark LeithMark Leith
    Oct 11, 2000 at 10:55 am
    Oct 11, 2000 at 8:06 pm
  • Know this is silly, but can't find it, post RTFM. If AUDIT ALL on scott.emp is set, and AUD$ fills up ( maxextents, space exhaustion, whatever) Are actions agains EMP now prohibited? And I am having ...
    Mohan, RossMohan, Ross
    Oct 16, 2000 at 7:26 pm
    Oct 19, 2000 at 5:53 pm
  • Hello, to use funktions in sql I would expect that I have to define a pragma restrict_reference. Some one told me that I have to set a init.ora-parameter to allow all functions to run in ...
    Wolfgang.ludewig_at_systor.comWolfgang.ludewig_at_systor.com
    Oct 31, 2000 at 12:28 pm
    Oct 31, 2000 at 10:10 pm
  • The shop here is a Novell 4.11 sp8a running Oracle 7.3.4.0.1 ( I know, no = heckling please). They purchased dual cpu's for the servers but they = aren't supported on 4.11( plan to upgrade the OS to ...
    Ron RogersRon Rogers
    Oct 27, 2000 at 12:56 pm
    Oct 30, 2000 at 8:41 pm
  • Gurus, In all the years that I have dealt with Oracle (both as a developer and a DBA -- altogether 3 years) I never stopped to pay much attention to the fact that when you define a field in a table ...
    Val_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.comVal_Gamerman/Victoria_Financial.VICTORIA_FINANCIAL_at_lnn.com
    Oct 20, 2000 at 7:29 pm
    Oct 23, 2000 at 12:38 am
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C038D9.CEA78E40 Content-Type ...
    Amar Kumar PadhiAmar Kumar Padhi
    Oct 18, 2000 at 8:02 am
    Oct 21, 2000 at 10:01 am
  • How can you fix invalid stored procedures? Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere!
    Cemail_at_sprintmail.comCemail_at_sprintmail.com
    Oct 18, 2000 at 4:56 pm
    Oct 19, 2000 at 10:36 am
  • If you have nothing better to do than answer a question in such a = demeaning and senseless manner, you should not be answering at all! Trust = me, you would never work in my shop! Victoria DeVore ...
    Victoria DeVoreVictoria DeVore
    Oct 17, 2000 at 1:51 am
    Oct 18, 2000 at 4:46 pm
  • Does ORACLE 8i support rename a column? If Yes, how to do it. Thanks.
    LL
    Oct 16, 2000 at 6:23 pm
    Oct 17, 2000 at 10:57 pm
  • Dear All, My team is writing a proposal for our huge core system using Oracle database. We already consider IBM mainframe S/390 as an alternative and we are now looking for another alternative using ...
    NosieNosie
    Oct 13, 2000 at 4:48 am
    Oct 16, 2000 at 3:34 pm
  • are there any pointers or whitepaper on oracle8 & solaris standards azhar
    Azhar SiddiqAzhar Siddiq
    Oct 1, 2000 at 1:34 pm
    Oct 31, 2000 at 10:52 am
  • This is a multi-part message in MIME format. ------=_NextPart_000_1133_01C03F41.52AA71E0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Dear listers, I ...
    Eric LansuEric Lansu
    Oct 26, 2000 at 9:38 am
    Oct 30, 2000 at 9:07 am
  • Listers, We are considering upgrading our 7.3.4 and 8.0.4 databases to either 8.1.5, 8.1.6, or 8.1.7. I asked previously on the list about experiences with 8.1.7 and got three responses. That leads ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Oct 24, 2000 at 5:14 pm
    Oct 27, 2000 at 12:26 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_0815_01C03471.14745150 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Is there a place ...
    Walter KWalter K
    Oct 12, 2000 at 10:23 pm
    Oct 17, 2000 at 5:25 pm
  • I need a little advice. We have a fairly new (< 1 year) 8.1.5 instance to support my company's internet business. We recently changed our network solutions provider and now my management wants to ...
    Ruiz, Mary A (CAP, CDI)Ruiz, Mary A (CAP, CDI)
    Oct 12, 2000 at 1:55 pm
    Oct 13, 2000 at 10:44 pm
  • Hi, I have a logical question, any one who can make it clear. create table a (x number(2) unique); insert into a values (null); 1 row created. insert into a values (null); 1 row created. Q:- I have a ...
    Awaisb_at_paktel.comAwaisb_at_paktel.com
    Oct 10, 2000 at 8:37 am
    Oct 11, 2000 at 10:19 am
  • Well, I must admit to being flummoxed. The nature of this problem guarantees that it'll be easy, and I'll be embarrased. Well, tough. I'm tired of beating my head against the wall. I'm trying to ...
    Dennis TaylorDennis Taylor
    Oct 4, 2000 at 9:29 pm
    Oct 5, 2000 at 4:31 pm
  • Have you heard? No? Well, after just 1 day, there is a LOT of news. But, it is only 1 day, so there will be a lot more announced. Should I wait for Friday? No. OK, here are a few things: 8.2 becomes ...
    TheOracle DBATheOracle DBA
    Oct 3, 2000 at 4:38 pm
    Oct 4, 2000 at 2:22 pm
  • Two weeks ago we upgraded our instances from 8.0.5 to 8.1.6. This was the worst thing we could do. The consume of CPUs have increased from 50% to 90% and our users are very angry because of long ...
    MARCOTULLI ARMANDOMARCOTULLI ARMANDO
    Oct 5, 2000 at 1:04 pm
    Oct 30, 2000 at 9:18 am
  • I have a developer here who would like to suppress a column heading for one column but have it normal for the rest. The following is an example of what he wants. select col1, col2, col3 from table1 ...
    Kimberly SmithKimberly Smith
    Oct 27, 2000 at 6:46 pm
    Oct 28, 2000 at 9:47 am
  • Hello Lists, I am using Oracle 8.1.5. Is it possible to import a package alone? How? I just want to rollback to a previous version of a package. Any help would be highly appreciated. Thanks, Muru
    Murugesan BalakrishnanMurugesan Balakrishnan
    Oct 25, 2000 at 11:12 pm
    Oct 26, 2000 at 10:30 pm
  • What is the best method to tell if performance is degrading because of waiting on the archiver to write logs? I'm running 8.1.6 for Solaris. Thanks, Dave Turner
    David TurnerDavid Turner
    Oct 25, 2000 at 5:51 pm
    Oct 25, 2000 at 10:29 pm
  • We are in the process of installing new disks and upgrading our software and I was looking for some opinions and/or facts. We are upgrading to AIX 4.3.3 and Oracle 8.1.6 on a basically OLTP system ...
    Sarka Chris (CGI)Sarka Chris (CGI)
    Oct 13, 2000 at 8:15 pm
    Oct 16, 2000 at 9:20 pm
  • This is a multi-part message in MIME format. ------=_NextPart_000_000D_01C02F87.B9CB4210 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Hi Guys, Just wanted to double ...
    Mark LeithMark Leith
    Oct 6, 2000 at 10:22 am
    Oct 7, 2000 at 12:15 am
  • OK, I am feeling stupid today. Now I want to see what Oracle products and versions are installed for this instance on this server. I tried "inspdver" but apparently that is not available anymore. I ...
    Nancy MccormickNancy Mccormick
    Oct 4, 2000 at 4:23 pm
    Oct 5, 2000 at 9:07 am
  • Hi All, I am trying to convert the following case stmt to Oracle but am stuck. I tried using DECODE but cannot handle the <= or <. Equal or Not equal I can convert by using decode. Any ideas? Thanks ...
    Cale, Rick T (Richard)Cale, Rick T (Richard)
    Oct 30, 2000 at 7:58 pm
    Oct 31, 2000 at 3:56 pm
  • I need to find a '%' in char field (8.05) and I can't seem to figure out the right sql to get it - the following are what I've tried so far (\ is the escape). SQL select * from test where a like ...
    Shaw, John BShaw, John B
    Oct 18, 2000 at 7:18 pm
    Oct 19, 2000 at 3:11 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C03935.6F32F000 Content-Type ...
    Swapna_PSwapna_P
    Oct 18, 2000 at 6:58 pm
    Oct 19, 2000 at 7:35 am
  • I would like to know how to verify the number of database connections there are currently. I tried v$session and look at the output from lsnrctl services. Does anyone else have any suggestions? ...
    Larry TaylorLarry Taylor
    Oct 16, 2000 at 8:33 pm
    Oct 17, 2000 at 2:29 pm
  • I am getting a lot of waits on my db file sequential reads and I kinda understand that is indicative of reading the indexes of the tables, but my question is, is it an indication that there are too ...
    Rodney WomackRodney Womack
    Oct 12, 2000 at 10:18 am
    Oct 14, 2000 at 7:53 am
  • Hi, I believe the session '172, 9' was hanging since 21-SEP. But when I tried to kill session, I go ORA-00030: user session ID does not exist Oracle Technical support said that only two choices: 1 ...
    Linda WangLinda Wang
    Oct 10, 2000 at 5:58 pm
    Oct 12, 2000 at 8:50 pm
  • Is 8.1.7 generally available? Can I order a CD of it? Does it have it's own migration utility for upgrading from 7.3.x? Is there any word from the trenches on the general stability/bugginess of ...
    Cherie_Machler_at_gelco.comCherie_Machler_at_gelco.com
    Oct 4, 2000 at 7:18 pm
    Oct 5, 2000 at 8:36 pm
  • This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible. ------_=_NextPart_001_01C0436E.4B32A460 Content-Type ...
    Swapna_PSwapna_P
    Oct 31, 2000 at 7:10 pm
    Oct 31, 2000 at 10:08 pm
  • Hi Gurus, Is there any way to get the a number of affected rows after an update or delete statement? Thanks in advance Gyula Andor
    Andor GyulaAndor Gyula
    Oct 27, 2000 at 8:00 am
    Oct 28, 2000 at 8:14 am
Group Navigation
period‹ prev | Oct 2000 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions787
posts2,454
users495
websiteoracle.com

495 users for October 2000

Eric D. Pierce: 59 posts Tom Pall: 56 posts Diana Duncan: 43 posts Dgoulet_at_vicr.com: 40 posts Rachel Carmichael: 38 posts Winnie_Liu_at_infonet.com: 36 posts Satar Naghshineh: 35 posts Shevtsov, Eduard: 34 posts Mohan, Ross: 33 posts Ron Rogers: 33 posts Jared Still: 32 posts Koivu, Lisa: 28 posts Gogala, Mladen: 27 posts Joseph S. Testa: 26 posts Deshpande, Kirti: 25 posts Cale, Rick T (Richard): 24 posts Paquette stephane: 23 posts David Turner: 22 posts Holman, Rodney: 22 posts Mark Leith: 21 posts
show more
Archives