Search Discussions

619 discussions - 2,931 posts

  • Recently this list had a discussion of female Oracle DBAs. The consensus was that the numbers were increasing, which I view as a good thing. Here is an article with industry statistics saying that ...
    Jan 7, 2003 at 11:11 pm
    Jan 9, 2003 at 6:24 pm
  • Joe, That's what I have heard (from 2 Oracle University Professors/Lecturers/Demonstrators). But no one would tell me when it may happen. We do not use RMAN (yet) so I did not pursue it further ...
    Deshpande, KirtiDeshpande, Kirti
    Jan 8, 2003 at 7:44 pm
    Jan 27, 2003 at 5:44 pm
  • http://careerlink.devx.com/articles/hc0199/hc0199.asp <http://careerlink.devx.com/articles/hc0199/hc0199.asp Interesting article I stumbled across. Best quote: "Stay Out of your DBA's Face"! WELL ...
    Koivu, LisaKoivu, Lisa
    Jan 28, 2003 at 9:24 pm
    Jan 31, 2003 at 2:43 pm
  • Here's an excellent real life example of why BCHR is not a good tuning metric and you should focus on reducing I/Os. A simple fix for a query and here is the resulting email to the client, who ...
    Fink, DanFink, Dan
    Jan 10, 2003 at 3:19 pm
    Jan 31, 2003 at 9:21 pm
  • unix time conversion functionCary.... I once thought I wanted to do some Perl coding... So I bought a book and started to play with it. It made my head bleed... literally I had little droplets of ...
    Robert FreemanRobert Freeman
    Jan 28, 2003 at 6:39 am
    Jan 29, 2003 at 9:14 pm
  • I have a 8.1.7 repository database for Designer 9i (client) running on SUN Solaris 8. I can start the database up but when I access the data via Designer it crashes. I try to start it back up and I ...
    Webber Valerie HWebber Valerie H
    Jan 2, 2003 at 7:45 pm
    Jan 15, 2003 at 4:39 pm
  • As far as we know there is no bandwidth limit on this list and problems can be understood better if you state them in a lucid and clear language. I had to really read twice (sorry haven't had my ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jan 2, 2003 at 1:39 pm
    Jan 6, 2003 at 10:54 pm
  • Feeling particularly anal the other day, I used the following specification to run statspack at the top of the hour, 15, 30 and 45 minutes after the hour. variable jobno number; variable instno ...
    Jan 22, 2003 at 12:23 am
    Jan 23, 2003 at 12:09 am
  • Hi, My brain is slow today.... Can someone help me ? I can do : select idu+1 from user_group_members where fk_user in(44541,41402,41813); IDU+1 41411 41821 44546 But I can't do : select 'insert into ...
    Henrik Ekenberg <henrik.ekenberg_at_anoto.com>Henrik Ekenberg <henrik.ekenberg_at_anoto.com>
    Jan 28, 2003 at 6:43 am
    Jan 30, 2003 at 10:45 pm
  • All, I would like to track the performance of my production databases by running the same SQL statement against each database every 5 minutes or so and recording the results. For example: sql set ...
    Terrian, Tom (Contractor) (DAASC)Terrian, Tom (Contractor) (DAASC)
    Jan 15, 2003 at 5:53 pm
    Jan 20, 2003 at 10:49 pm
  • Hi friends Why DDL statements performs auto commit ? What is the exact reason behind that one? Anyone can share his/her opinions!! Thanks & regards BanarasiBabu -- Please see the official ORACLE-L ...
    BanarasiBabu TippaBanarasiBabu Tippa
    Jan 22, 2003 at 11:33 am
    Jan 23, 2003 at 5:50 pm
  • HI all We have a consistent problem of CPU utilization 100%. We have had this problem since Saturday, but it automatically subsided, I mean went back to normal after a few hours, and remained normal ...
    Hussain Ahmed QadriHussain Ahmed Qadri
    Jan 20, 2003 at 5:44 am
    Jan 21, 2003 at 7:31 pm
  • ('binary' encoding is not supported, stored as-is) break on proc column "QUERY" format A40 word_wrapped select substr(KGLNAOWN || '.' || KGLNACNM, 1, 35) proc, KGLNADNM "QUERY" from x$kglrd where ...
    Stephane FaroultStephane Faroult
    Jan 10, 2003 at 10:03 am
    Jan 13, 2003 at 1:09 pm
  • Hi Waleed, No. This is the name of the package. Thanks Lisa -----Original Message----- Sent: Tuesday, December 31, 2002 3:04 PM To: Multiple recipients of list ORACLE-L I see "ELVIS.CLEANUP_VEGAS_PK" ...
    Koivu, LisaKoivu, Lisa
    Jan 2, 2003 at 1:14 pm
    Jan 2, 2003 at 9:23 pm
  • List, I am looking for a recommendation on a book or web site covering statspack and it's use. A moderate level usage rather than an expert level literature is desired. Any recommendations please ...
    Ron RogersRon Rogers
    Jan 23, 2003 at 2:44 pm
    Jan 24, 2003 at 4:14 pm
  • Larry Ellison has spent 95 million (US) attempting to become the challenger to Team New Zealand for the Americas Cup. Unfortunately did not make the grade.. ...
    Fowler, Kenneth RFowler, Kenneth R
    Jan 20, 2003 at 5:08 pm
    Jan 21, 2003 at 10:37 pm
  • I am considering the appropriate way to do database corruption prevention. Should I use one or more of the following as a proactive measure ? Export DBVerify Analyze table validate structure cascade ...
    Pui Ho ChanPui Ho Chan
    Jan 17, 2003 at 12:28 pm
    Jan 19, 2003 at 6:48 pm
  • Dear list ! I have just been asked the following question: is it possible to make a connection from an Oracle client to an Oracle instance (both are 8.1.7) in an "encrypted" way. I.e. if someone is ...
    Andrey BronfinAndrey Bronfin
    Jan 6, 2003 at 1:43 pm
    Jan 14, 2003 at 2:33 pm
  • ummm.......I just truncated all of the system tables in a new database (that's not good). No backups yet. Anyway to recover from this or do I have to recreate the database? Thanks, Tom Terrian -- ...
    Terrian, Tom (Contractor) (DAASC)Terrian, Tom (Contractor) (DAASC)
    Jan 8, 2003 at 2:18 pm
    Jan 10, 2003 at 12:20 pm
  • I am looking to add a unix box to my collection of wintel machines at home. It will be used solely for running/testing Oracle, so I don't need bells & whistles. My thoughts are either Linux/intel or ...
    Fink, DanFink, Dan
    Jan 30, 2003 at 3:14 pm
    Jan 30, 2003 at 10:35 pm
  • I've got a cust that is showing some signs that one would think is having a horrible problem on I/O... I suspect it is the "error" of having a **HUGE** value in db_block_buffers and it's constantly ...
    Michael KlineMichael Kline
    Jan 23, 2003 at 6:46 pm
    Jan 30, 2003 at 3:25 pm
  • Anyone have any problems with the CBO not using a index when you know it is faster by forcing a hint ? I have set the following ... Solaris Oracle Version block size = 8 ...
    Johnson, MichaelJohnson, Michael
    Jan 24, 2003 at 2:28 am
    Jan 25, 2003 at 8:13 pm
  • I have a recurring, repeatable problem I was wondering about its cause. Oracle on W2K Professional (SP2) Dell Optiplex workstation Pentium 4 Step 1 - I do an SQLLDR process that loads 88640 ...
    Weiss, RickWeiss, Rick
    Jan 27, 2003 at 11:53 pm
    Jan 28, 2003 at 7:14 pm
  • MessageHow does one qualify for senior oracel dba. Do you guys have any questionare which I can ask myself . -Bp -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BigP INET ...
    Jan 21, 2003 at 11:05 pm
    Jan 24, 2003 at 2:33 am
  • System Administrator says he doesn't trust that the rc commands will stop if the database doesn't want to shutdown and even if it does would want to shutdown with scripts beforehand so that a DBA ...
    Jan 29, 2003 at 4:29 pm
    Jan 30, 2003 at 8:34 pm
  • 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 ...
    Koivu, LisaKoivu, Lisa
    Jan 28, 2003 at 7:10 pm
    Jan 30, 2003 at 3:50 pm
  • I am trying to update a small table from a remote table with sqlplus . It seems to indicate that it has inserted 233 row into my local table - however that doesn't really happen. Am I ...
    John ShawJohn Shaw
    Jan 20, 2003 at 3:30 pm
    Jan 21, 2003 at 7:19 pm
  • Hi All For those sites with either a standby, DR or failover database, the following information is very important to you. You could be in breach of Oracle's Licensing agreement and could cost you ...
    Jan 16, 2003 at 3:08 am
    Jan 17, 2003 at 1:53 am
  • I've finally managed to fit IOUG-A into my timetable, after years of thinking that I really ought to go some day. I see from the 'University Class' listings that no-one is doing anything about ...
    Jonathan LewisJonathan Lewis
    Jan 6, 2003 at 10:13 am
    Jan 8, 2003 at 3:08 pm
  • I am designing some tables to store Customer Support Data. The main table (SUPPORT_DATA) contains many (up to 15) foreign key links to other tables. Most of the other tables are small lookup ...
    Gregory NorrisGregory Norris
    Jan 6, 2003 at 8:03 pm
    Jan 7, 2003 at 7:53 pm
  • Hello Listers, I was asked if there is any procedure that could be called from a trigger to replace (with a blank) or remove all non-printable characters from the text before inserting it in the ...
    Deshpande, KirtiDeshpande, Kirti
    Jan 3, 2003 at 5:09 pm
    Jan 5, 2003 at 3:33 am
  • The support analyst handling my TAR gave up, perhaps someone on here can help me out... I have an database. I used RMAN to perform a full backup of my database on server A (Brain). The RMAN ...
    Gary JacksonGary Jackson
    Jan 30, 2003 at 7:56 pm
    Jan 31, 2003 at 10:01 pm
  • I'm working with a couple of IBM gals(don't you all get offended) who are asking about shareplex, i've not used it and have no idea whether its good or not(or for that matter what its purpose is) ...
    Joseph S TestaJoseph S Testa
    Jan 17, 2003 at 4:14 pm
    Jan 22, 2003 at 7:08 pm
  • Hello All, I have found some of the tables are heavily chained in one of the database . I want to fix them by exp and imp, but before that I would like to have a formula or some better method to ...
    Reddy, MadhusudanaReddy, Madhusudana
    Jan 15, 2003 at 9:05 pm
    Jan 21, 2003 at 5:39 pm
  • Is there any way you can specify that the only permissible values (is it called a domain?) that can be entered in varchar2 field in an Oracle table to, for example, A, B and C? We can restrict what ...
    Aidan WhitehallAidan Whitehall
    Jan 30, 2003 at 4:00 pm
    Jan 31, 2003 at 12:38 pm
  • I am using substitution variables in SQLPlus, but don't want to be prompted for their values. I want to set them at the start of the script. Kind of like a preprocessor directive. Is this possible? ...
    Erik WilliamsErik Williams
    Jan 15, 2003 at 3:04 pm
    Jan 16, 2003 at 6:24 pm
  • Hi all, I hit by this error ORA-00600: internal error code, arguments: [2662], [0], [54151123], [0], [54173017], [16781180], [], [] Can you help me where to find info about this error Sinardy -- ...
    Sinardy XingSinardy Xing
    Jan 7, 2003 at 3:33 am
    Jan 7, 2003 at 11:49 pm
  • Hi there. I have a non-unique index on a table, and I'm trying to force Oracle to use the index - but it always does a FTS. Why? (I've tried it with and without the alias) SQL set autotrace traceonly ...
    Cunningham, GeraldCunningham, Gerald
    Jan 31, 2003 at 6:31 pm
    Jan 31, 2003 at 11:30 pm
  • Can anyone explain why it is that I seem unable to use 'like' and 'not like' on columns containing null values. (I am unable to find information regarding this on MetaLink.) For example: SQL select * ...
    Gary JacksonGary Jackson
    Jan 30, 2003 at 5:41 pm
    Jan 31, 2003 at 7:49 am
  • Hello everyone, My apologies for bombarding the list with more questions than answers as of late. This one is pretty desparate. For those of you who support Peoplesoft databases - Are there any ...
    Koivu, LisaKoivu, Lisa
    Jan 28, 2003 at 9:08 pm
    Jan 29, 2003 at 2:59 pm
  • Is there such thing as an over-normalized database design? What defines over-normalization? And what are its consequences? (Other than the obvious degraded database performance and lots of tuning) I ...
    Saira SomaniSaira Somani
    Jan 23, 2003 at 4:00 pm
    Jan 24, 2003 at 5:29 pm
  • List, I recently tried to set the compatible= parameter in a 9iRel2 Solaris 8 database. If you bounce the instance the sql show parameter compatible=9.0.0 stays the same, it does not change ...
    Ehresmann, DavidEhresmann, David
    Jan 13, 2003 at 2:43 pm
    Jan 13, 2003 at 8:38 pm
  • Hi: I am trying to learn how to make use v$sgastat info in our oracle 8173 db. Here is what I set for the instance: shared_pool_size 268435456 shared_pool_reserved_size 13421772 large_pool_size ...
    Guang MeiGuang Mei
    Jan 8, 2003 at 9:00 pm
    Jan 10, 2003 at 3:28 am
  • Hi All, I want to avoid generation of archivelogs against all the DML applied to some tables. Thank you -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: GL2Z/ INF DBA ...
    Jan 6, 2003 at 9:34 am
    Jan 7, 2003 at 11:04 pm
  • I have 2 8i database out of which one is production and the other is for development and testing. How can I update the data of the second one as the first one? tried import but it didnt update the ...
    Jan 6, 2003 at 8:33 am
    Jan 6, 2003 at 10:44 pm
  • Does anyone know off hand if using NVL on an indexed column negate use of an index in CBO? This is 9202 ... and the column will be a varchar2(1). Raj Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot ...
    Jamadagni, RajendraJamadagni, Rajendra
    Jan 2, 2003 at 5:48 pm
    Jan 2, 2003 at 9:44 pm
  • Hello everyone, I hope this is a quick question. Can you run 8.1.7 Statspack on an instance? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author ...
    Ruth GramoliniRuth Gramolini
    Jan 29, 2003 at 6:53 pm
    Jan 30, 2003 at 1:14 pm
  • I am wondering if it is possible to produce .mdb or .xls format files from inside Oracle. Can this be done? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin & Operations | ...
    Boivin, Patrice JBoivin, Patrice J
    Jan 24, 2003 at 9:19 pm
    Jan 27, 2003 at 5:18 pm
  • I could test this myself but that would require coordination with the system administrators and they always seem to think their time is too important for testing. :) i would like to implement RMAN in ...
    Chris StephensChris Stephens
    Jan 21, 2003 at 4:45 pm
    Jan 22, 2003 at 2:28 pm
  • All, Has anyone installed and run SqlServer and Oracle on the same NT box? I've heard mixed rumors that either you can or cannot do it. Both databases would be very small with very few transactions ...
    Mercadante, Thomas FMercadante, Thomas F
    Jan 21, 2003 at 1:19 pm
    Jan 22, 2003 at 1:19 am
Group Navigation
period‹ prev | Jan 2003 | next ›
Group Overview
grouporacle-l @

404 users for January 2003

Jared.Still_at_radisys.com: 104 posts Jamadagni, Rajendra: 100 posts DENNIS WILLIAMS: 96 posts Deshpande, Kirti: 63 posts Fink, Dan: 61 posts Arup Nanda: 59 posts Koivu, Lisa: 59 posts Rachel Carmichael: 58 posts Jared Still: 53 posts Jonathan Lewis: 52 posts Freeman Robert - IL: 50 posts Jesse, Rich: 48 posts Mercadante, Thomas F: 42 posts Richard Ji: 39 posts Dgoulet_at_vicr.com: 38 posts Robert Freeman: 35 posts Tim Gorman: 35 posts Stephane Faroult: 34 posts Sony kristanto: 33 posts Farnsworth, Dave: 32 posts
show more