FAQ

Search Discussions

636 discussions - 2,928 posts

  • On top of learning Oracle, which programming languages would also benefit some1 learning Oracle? Perl? Java? How would these languages be used? -- Please see the official ORACLE-L FAQ ...
    Les AyudoLes Ayudo
    Feb 18, 2003 at 4:56 pm
    Feb 21, 2003 at 8:32 pm
  • DBA's Check the article's comment on Oracle trying to ban Teradata from IOUG Teradata Steals Oracle's Data Mart Users ... Teradata pushes consolidation and woos away Oracle customers. But Oracle ...
    James HowertonJames Howerton
    Feb 12, 2003 at 9:58 pm
    Feb 24, 2003 at 10:23 pm
  • I recently inherited a 40GB 7.3.4 database (yes, it needs to upgrade). Last night I analyzed the tables and a corrupted block was found. I know which table and datafile it is, and it's the only table ...
    Suzy VordosSuzy Vordos
    Feb 24, 2003 at 4:09 pm
    Feb 27, 2003 at 6:53 pm
  • A couple of friends and I are thinking of putting up a small training company here in the Phils. (When we say small...its really small with almost 0 capitalization...just sheer guts and technical ...
    Maria Aurora VT de la VegaMaria Aurora VT de la Vega
    Feb 5, 2003 at 4:23 am
    Feb 13, 2003 at 6:44 pm
  • To those who are interested in running RAC on Linux. I know we have been talking about RAC on linux lately. This is great news Redhat has made a special developer's edition for their Advanced Server ...
    Richard JiRichard Ji
    Feb 9, 2003 at 5:23 am
    Feb 13, 2003 at 7:23 pm
  • Hey all, Can anyone think of a reason to hold on to Oracle 7.3.3 HP/UX CDs? We've been at 8.1.7 for 18 months now. I can't think of a good reason, other than the software isn't available anymore ...
    Jesse, RichJesse, Rich
    Feb 24, 2003 at 2:58 pm
    Feb 26, 2003 at 11:48 am
  • And you thought your job was bad . . . (Yes, this IS a production job) 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=623898383366807000000000 Card=81143391896031200000000000000 1 0 MERGE JOIN ...
    Barbara BakerBarbara Baker
    Feb 27, 2003 at 6:23 pm
    Feb 28, 2003 at 7:30 pm
  • For your amusement, MS thinks they can "now" equal Oracle in performance (wasn't that what they claimed 3 years ago?). Anyway, I tend to think of these benchmarks like the NASCAR winners. Yeah I'm ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Feb 27, 2003 at 7:26 pm
    Feb 28, 2003 at 10:45 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" Service startup on Windows 2000 fails Good morning everyone, Windows 2000 sp3, ver 8.1.7.2 I have NO IDEA what is going on here. I can't start any of ...
    Koivu, LisaKoivu, Lisa
    Feb 19, 2003 at 2:08 pm
    Feb 20, 2003 at 2:28 pm
  • Hello, I'm thinking of going to school to get Oracle certified. There are 2 schools in my area that are offering Oracle certs but one offers Oracle 8i courses w/ an upgrade to 9i, while the other ...
    Les AyudoLes Ayudo
    Feb 14, 2003 at 3:23 pm
    Feb 18, 2003 at 2:03 am
  • Hello everyone, i've been quiet recently, for those of you who know what I've been up to class has been great, emergency medicine is really kewl. Now to the oracle stuff, We're having new ...
    Joe TestaJoe Testa
    Feb 2, 2003 at 11:23 pm
    Feb 7, 2003 at 10:19 pm
  • I'm continuing to introduce myself to 9i. I've been reading about Automatic Segment Space Management, and I just wondered if anybody had any positive/negative experiences with it. I got some good ...
    Jay HostetterJay Hostetter
    Feb 19, 2003 at 2:33 pm
    Feb 21, 2003 at 5:19 pm
  • I overheard one guy mention that once you learn one database, you know them all. Is this true? Or was he just talking about the theory behind the db? -- Please see the official ORACLE-L FAQ ...
    Les AyudoLes Ayudo
    Feb 16, 2003 at 1:38 am
    Feb 20, 2003 at 5:19 pm
  • Hi list, I issue a select count(*) from mytable and last 30 seconds. The table has 1,466,196 records and were loaded with a batch process, so they are in a countinous space. I consider that time ...
    Ramon E. EstevezRamon E. Estevez
    Feb 11, 2003 at 4:19 pm
    Feb 13, 2003 at 7:40 pm
  • Where is it well documented how to install multiple server versions, 8i and 9i, on the same unix server? Ray Stell stellr_at_vt.edu (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L ...
    Ray StellRay Stell
    Feb 6, 2003 at 1:08 pm
    Feb 28, 2003 at 10:29 pm
  • Just had a thought here, have not tried it yet. I have a database that I am working with that is generating 28 GB of redo each day. I would really like to know what objects are generating all this ...
    Post, EthanPost, Ethan
    Feb 21, 2003 at 3:44 pm
    Feb 22, 2003 at 12:09 am
  • Dear friends, I traced one of our test cases and found something weird. Did anybody else observe this? Env: server - 9.0.1.4, Solaris. client - weblogic 7, uses original oracle thin 9.0.1 jdbc driver ...
    Gorbounov,VadimGorbounov,Vadim
    Feb 13, 2003 at 2:49 pm
    Feb 14, 2003 at 2:53 pm
  • Dear list, Have any of you every experienced MV's not refreshing for no particular reason? We have been using some simple MV's for several months with no problem. Now after upgrading our app and ...
    Jared StillJared Still
    Feb 25, 2003 at 8:48 am
    Feb 26, 2003 at 12:13 am
  • I'm fighting a view.... Someone hand me a big dagger with which to kill it. I have a view that takes 6 minutes to run when I query it like this: select count(*) from TST_XVW a where ...
    Freeman Robert - ILFreeman Robert - IL
    Feb 12, 2003 at 3:18 pm
    Feb 13, 2003 at 12:03 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" Skill Sets - This may be a dumb question Hello everyone, Well I've been "reassigned". I was responsible for the completely messed up Peoplesoft ...
    Koivu, LisaKoivu, Lisa
    Feb 25, 2003 at 4:34 pm
    Feb 25, 2003 at 8:35 pm
  • I have a problem query which will not complete. This query is part of a report run within Oracle Applications. Our versions are: Oracle Server 8.1.7.4, Apps 11.5.3, HP-UX 11.11 Listed below is the ...
    Glenn TravisGlenn Travis
    Feb 14, 2003 at 4:03 pm
    Feb 19, 2003 at 9:05 pm
  • I'm curious as to an explanation on don't #1 (what constitutes "reorganization"?) and what is ASSM for don't #5? "Assembly"??? Rich Rich Jesse System/Database Administrator rich.jesse_at_qtiworld.com ...
    Jesse, RichJesse, Rich
    Feb 24, 2003 at 3:39 pm
    Feb 28, 2003 at 4:19 pm
  • As AIX 4.3.3 goes out of service this year, we need to upgrade our AIX box to AIX 5.2 We have both Oracle 8.1.7(32 bit) and Oracle 9i Release 2(9.2.0.1.0) (64 bit) installed on that box. Will ...
    John DunnJohn Dunn
    Feb 27, 2003 at 10:44 am
    Feb 28, 2003 at 2:58 pm
  • Hi, So my boss comes over this morning and tells me that the users are having a performance problem with a 3rd party application that have recently began using. This is an oracle database where they ...
    Eberhard, JeffEberhard, Jeff
    Feb 26, 2003 at 8:43 pm
    Feb 27, 2003 at 5:34 pm
  • Here is the list of top 10 do's and don't that I came up with. #1 - Do Maintain your Expertise #2 - Do Use the DBMS_STATS Package to Collect Statistics #3 - Do Use Bind Variables #4 - Do Put your ...
    Freeman Robert - ILFreeman Robert - IL
    Feb 23, 2003 at 10:23 pm
    Feb 24, 2003 at 10:23 pm
  • List, I'm use to using a standard D=development T=test P=production. So for a database newly created on development it would be called something like D24X7. Then when it was created on Production it ...
    Godlewski, MelissaGodlewski, Melissa
    Feb 14, 2003 at 4:23 pm
    Feb 17, 2003 at 3:13 pm
  • 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 ...
    Koivu, LisaKoivu, Lisa
    Feb 6, 2003 at 2:23 pm
    Feb 7, 2003 at 2:38 pm
  • Hi, We are looking from migration from Sun box to Windows box. Is anyone used Windows clustering with oracle8i? Is this clustering stable or more frequent creating problem? Please advice Thx -Seema ...
    Seema SinghSeema Singh
    Feb 4, 2003 at 10:34 pm
    Feb 6, 2003 at 5:29 pm
  • Yes, regarding these 3, how can they be considered absolute do's or don'ts? I didn't take Cary's material to mean ignore physical IO's but rather to show the importance and impact of logical IO's ...
    Darrell LandrumDarrell Landrum
    Feb 23, 2003 at 11:48 pm
    Feb 25, 2003 at 8:13 am
  • Guys, I took this exam after 12 hours studying and missed 4 questions. I studied using the self-test software (few practice exams) some memorization and the student guides from the oracle 8 tuning - ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Feb 25, 2003 at 10:09 pm
    Feb 28, 2003 at 6:45 pm
  • I have been tasked to write a script to run SQL. I don't want a password field to be shown in the script. Does someone have run into this and have a better idea? For example, I have following line in ...
    Nguyen, David MNguyen, David M
    Feb 24, 2003 at 8:54 pm
    Feb 25, 2003 at 6:47 pm
  • All, I'm trying to send an email attachment (Oracle Tablespace Report) from a Sun Unix box to myself when the batch job runs. Anybody been able to do this? I can send the text of the file, but what I ...
    Mercadante, Thomas FMercadante, Thomas F
    Feb 13, 2003 at 3:44 pm
    Feb 13, 2003 at 7:29 pm
  • We have a query from a 3rd-party tool that seems to either run very quick or crawls to a complete stop. We can find no patterns to this behavior. The hang can be experienced even when there are no ...
    Thomas JeffThomas Jeff
    Feb 5, 2003 at 5:59 pm
    Feb 6, 2003 at 7:23 pm
  • Hi: I have a quick question about replacing "$" with "\$" on unix. I need to convert string "123$45$678" to "123\$45\$678" through a pipe. I tried with sed command, but could not get it to work ...
    Guang MeiGuang Mei
    Feb 3, 2003 at 6:39 pm
    Feb 4, 2003 at 4:00 pm
  • I have never had good luck with DBMS_STATS. It seems that the old analyze runs much faster..... Runs in 45 seconds: analyze table log_trans partition (log_trans_20030104) estimate statistics sample 5 ...
    Terrian, Tom (Contractor) (DAASC)Terrian, Tom (Contractor) (DAASC)
    Feb 25, 2003 at 6:12 pm
    Feb 27, 2003 at 4:09 pm
  • Does anyone happen to remember when Juan Loaiza and Bhaskar Himatsingka first published their paper called: How to stop defragmenting and start living: the definitive word on fragmentation. Thanks ...
    Jonathan LewisJonathan Lewis
    Feb 26, 2003 at 2:53 pm
    Feb 27, 2003 at 4:38 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" GRRRRR OWS Are these people at Oracle Support always this stupid??! I'm having an argument with an analyst regarding the permissions to the ...
    Koivu, LisaKoivu, Lisa
    Feb 19, 2003 at 2:39 pm
    Feb 25, 2003 at 9:53 am
  • We are running Oracle 7.3.4.5.0 on an IBM/AIX RISC System/6000: Version 2.3.4.0.0. I know there is SQL that allows setting a data file to auto extend. I am trying to find out where in the data ...
    Sam BootsmaSam Bootsma
    Feb 21, 2003 at 3:44 pm
    Feb 22, 2003 at 3:43 pm
  • Here I am, still at work at 10:00 PM. A lovely upgrade likely to take all my time until sometime Tuesday. But enough about my problems. No wait, there's more... :) I'm going to upgrade a database ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Feb 15, 2003 at 6:03 am
    Feb 18, 2003 at 12:38 am
  • As a longtime Oracle DBA who has used many products, including RMAN, I find myself guilty of a paradoxical mistrust of RMAN, dating back from the time when Oracle has tried several products, ...
    Michael FontanaMichael Fontana
    Feb 10, 2003 at 10:03 pm
    Feb 14, 2003 at 6:23 am
  • Hi Listers, I set the sql trace true in a procedure, let's say the procedure testproc(var1 IN number, var2 IN varchar2). Is there a way to know the value passed to that procedure (the value of var1 ...
    Bahar, Rivaldi (BBASSI-CHQ)Bahar, Rivaldi (BBASSI-CHQ)
    Feb 10, 2003 at 5:28 pm
    Feb 11, 2003 at 4:50 pm
  • I am looking for info on how you support a large number of PCs (200+) and keep each ones tnsnames.ora file in sync. It seems that most people do not touch them. Some try to modify them and when new ...
    Fedock, John (KAM.RHQ)Fedock, John (KAM.RHQ)
    Feb 27, 2003 at 7:56 pm
    Feb 27, 2003 at 10:44 pm
  • All We are attempting to move some applications off Compaq T64 into Sun Solaris 8 and running into performance issues. I am trying to rebuild an index which is taking more than 3 1/2 hours while it ...
    babu.nagarajan_at_Cummins.combabu.nagarajan_at_Cummins.com
    Feb 25, 2003 at 2:11 pm
    Feb 26, 2003 at 9:03 pm
  • I have just installed Oracle 8i1.7 on solaris 9 (ultra sparc 10) and issued the command sqlplus and I rec'd a "command not found" error. Is there something I forgt to do before the install? Let me ...
    Les AyudoLes Ayudo
    Feb 23, 2003 at 12:33 pm
    Feb 25, 2003 at 7:03 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN" AIX question AIX 4.3.3 Can anyone tell me if there's a command to determine what volumes/disks are on each controller? I'm way out of my element here ...
    Koivu, LisaKoivu, Lisa
    Feb 21, 2003 at 5:19 pm
    Feb 22, 2003 at 3:58 am
  • Is anybody aware of a freeware metadata repository tool that is configurable enough to capture metadata attributes that the business would value? For example, to capture information about columns ...
    Tracy RahmlowTracy Rahmlow
    Feb 14, 2003 at 7:49 pm
    Feb 18, 2003 at 5:59 pm
  • Hmmm - I wonder if we are talking about the same company? The SQR product I know of came out of a US company called MITI (Long Beach, CA), and was marketed in UK by SPS. It was originally a report ...
    Robson, PeterRobson, Peter
    Feb 14, 2003 at 11:43 am
    Feb 16, 2003 at 3:58 am
  • Hi all, Does Unix has an on-line research source, like metalink for Oracle? Pls send me the links. Much appreciated. Also is Linux pretty similar to Unix. What's the major difference? Thank you in ...
    Andrea OracleAndrea Oracle
    Feb 13, 2003 at 5:24 pm
    Feb 14, 2003 at 6:39 pm
  • I am preparing to migrate from 8.1.7 to 9.0.2. I was just wondering if I am the only DBA that doesn't like all of this other "stuff" in my database - Ultrasearch, Intermedia, Oracle Text, and XML. I ...
    Jay HostetterJay Hostetter
    Feb 13, 2003 at 8:09 pm
    Feb 14, 2003 at 2:34 pm
  • There are a lot of good items on your list. Harrison is the definitive work on Oracle SQL tuning, though it is also worthwhile to pick up the O'Reilly pocket SQL tuning book as well. Robert Freeman's ...
    Cjgait_at_earthlink.netCjgait_at_earthlink.net
    Feb 3, 2003 at 1:23 pm
    Feb 9, 2003 at 12:13 am
Group Navigation
period‹ prev | Feb 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions636
posts2,928
users401
websiteoracle.com

401 users for February 2003

DENNIS WILLIAMS: 125 posts Jared.Still_at_radisys.com: 67 posts Jamadagni, Rajendra: 60 posts Freeman Robert - IL: 59 posts Jonathan Lewis: 57 posts Lyndon Tiu: 54 posts Rachel Carmichael: 53 posts Dgoulet_at_vicr.com: 52 posts Jared Still: 52 posts Jesse, Rich: 52 posts Richard Ji: 50 posts Stephen Lee: 48 posts Mogens Nørgaard: 46 posts Deshpande, Kirti: 45 posts Gogala, Mladen: 36 posts Boivin, Patrice J: 35 posts Tim Gorman: 33 posts Connor McDonald: 32 posts Les Ayudo: 32 posts Igor Neyman: 30 posts
show more
Archives