Search Discussions

508 discussions - 3,145 posts

  • You guys are going to enjoy this :-). I just read a very interesting article that managed to insult some of my favorite Oracle authors and the entire state of Alabama! Now I've heard Mr. Burleson ...
    David WagonerDavid Wagoner
    Mar 4, 2004 at 4:59 pm
    Mar 27, 2004 at 9:15 am
  • We had a discussion on here regarding hints. some of you stated that Oracle cannot ignore a proper hint. I have a TAR open and asked about this. Here is the response. "A hint simply adds weight to a ...
    Mar 4, 2004 at 1:36 pm
    Mar 15, 2004 at 2:01 pm
  • Hi: I have a query which gave two very different explain plan on 8173 and 9204. The two instances (on two separate Sun Solaris boxes) both have the same db_file_multiblock_read_count (8), block_size ...
    Guang MeiGuang Mei
    Mar 1, 2004 at 11:06 am
    Mar 2, 2004 at 2:59 pm
  • Someone at work maintains that it takes them 10 minutes to break the Oracle SYS password security. And the Sun boof-head (a different person and I use the term loosely...) assures me he's capable of ...
    Nuno SoutoNuno Souto
    Mar 10, 2004 at 4:04 am
    Jun 20, 2004 at 9:13 am
  • We have a fairly big query that takes about 6 hours to complete. To speed up things, we thought of the following: Create a logon trigger, which stores in memory each user's info during login time ...
    Maryann AtkinsonMaryann Atkinson
    Mar 12, 2004 at 8:59 am
    May 20, 2004 at 9:26 pm
  • Hi, I have to write an HP-UX Korn shell script to check the status of 20 databases - up or down - and send an email if any are down. I'm a relative newbie at Unix. I'm not asking anyone to "do it for ...
    Michael MilliganMichael Milligan
    Mar 9, 2004 at 2:26 pm
    Mar 11, 2004 at 8:01 pm
  • Hi All I am trying to reclaim the wasted space (huge deletes), which are above the HWM. I had analysed the table before and got the "empty_blocks" details from dba_tables. I am using the following ...
    Vidya kalyanaramanVidya kalyanaraman
    Mar 10, 2004 at 12:48 am
    Jun 9, 2005 at 8:09 pm
  • We are having a debate on building tablespaces with automatic segment space management (ASSM). This is a 9i db on a Solaris box. I'm in favor of using ASSM but the senior dba is a bit hesitant and ...
    Mark MoynahanMark Moynahan
    Mar 4, 2004 at 4:09 pm
    Mar 11, 2004 at 1:05 pm
  • i ran the following exec dbms_system.set_sql_trace_in_session(sid,serial#,true); Procedure Completed Successfully I then went to my udump directory to check for a trace file and could not find one? ...
    Mar 3, 2004 at 7:02 am
    Apr 13, 2004 at 11:32 am
  • Thanks Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line. -- Archives are at ...
    Mar 23, 2004 at 3:41 am
    Mar 24, 2004 at 3:33 pm
  • What do you think about this idea. Every one have (only weekly) to put something This can be something he learned, Statictics, for example the statics reading a cursor normally in a database function ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Mar 3, 2004 at 4:58 pm
    Mar 5, 2004 at 7:44 am
  • Hi I found some reasons to use Oracle instead sql server. Does any one know some paper that shows that differences, for example I know sql server don't have hot backup, but where there is a paper ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Mar 30, 2004 at 7:30 am
    Mar 31, 2004 at 6:31 am
  • Huascar Normal? No. In order to help diagnose your situation, please post more details. Like your query, the sizes of your tables, etc. Have you analyzed the tables in Oracle? Dennis Williams DBA ...
    Mar 11, 2004 at 7:20 am
    Mar 12, 2004 at 4:13 am
  • I know many of you have addressed this same issue... What is a good method to create a smaller test database from Production? I've read about the commercial product called DataBee for doing this, but ...
    David WagonerDavid Wagoner
    Mar 1, 2004 at 12:34 pm
    Mar 3, 2004 at 3:07 am
  • call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- ---------- Parse 1 0.01 0.01 0 5 0 0 Execute 6 213.15 949.43 393775 10256309 20885 ...
    Jamadagni, RajendraJamadagni, Rajendra
    Mar 23, 2004 at 10:58 am
    Mar 25, 2004 at 2:07 pm
  • We are currently running 8.1.7 databases on a 4 year old Dell Pentium machine, under SCO UnixWare. This is the last supported version of Oracle under UnixWare, and since the hardware is getting old ...
    John FlackJohn Flack
    Mar 19, 2004 at 7:50 am
    Mar 22, 2004 at 6:46 am
  • Friends, I recently wrote this message, but then sent it just to myself in order not to offend anyone or perhaps be misunderstood. But after 14 days with this message in my inbox, I have decided to ...
    Mogens NørgaardMogens Nørgaard
    Mar 16, 2004 at 5:39 pm
    Mar 22, 2004 at 5:03 am
  • the cardinalities of the tables are different so oracle chose a different plan. alot more records in the 9204 one than int he 8173 and you are doing full table scans. so alot more data to read ...
    Mar 1, 2004 at 11:22 am
    Mar 3, 2004 at 1:08 pm
  • Your advice please. I still don't have a clear idea when is a good idea to use intermedia, if we have blobs, bfiles, and clobs tosave any data, when is a good idea to think to use intermedia. Which ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Mar 18, 2004 at 8:10 am
    Mar 25, 2004 at 7:46 am
  • D:\Oracle\ora101\BIN net start (removed non-relevant rows) OracleCSService OracleOraHome101iSQL*Plus OracleOraHome101TNSListener D:\Oracle\ora101\BIN net stop "OracleOraHome101iSQL*Plus" The service ...
    Paul DrakePaul Drake
    Mar 22, 2004 at 1:23 am
    Mar 23, 2004 at 11:08 am
  • I have an 8i read only database that is used for query of images. Occassionally, I back it up using OS utilities (cp, tar, TSM, etc) while the db is open. Question: Is there any benefit to having ...
    Gene SaisGene Sais
    Mar 3, 2004 at 9:00 am
    Mar 7, 2004 at 8:34 am
  • I don't think this needs to be labeled a weekly/formal event. There are people on this list that blow my mind on a daily/hourly basis and others who post non-sense on a regular basis...and I have ...
    Chris StephensChris Stephens
    Mar 4, 2004 at 10:31 am
    Mar 5, 2004 at 4:28 am
  • Just wondering what others experiences are installing this version. Did you perhaps find that there is no new version of the Oracle Home Selector? And that even if you hack the registry so that the ...
    Mar 25, 2004 at 12:21 pm
    Mar 26, 2004 at 10:58 am
  • is there a standard query for this? Seems like people have different standards. Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to ...
    Mar 10, 2004 at 6:02 pm
    Mar 12, 2004 at 5:44 am
  • How about all the people who do want to participate, respond to Juan. I'll start: I would like to be involved. How about all the people who do not want to participate, stop saying why it's such a bad ...
    Michael MilliganMichael Milligan
    Mar 4, 2004 at 11:19 am
    Mar 7, 2004 at 7:07 pm
  • All, I am attempting to perform Rman disk backups on a data warehouse. While the disk backup runs fine, the size of the output files are, of course, huge. What I would like to do is to pipe the ...
    Mercadante, Thomas FMercadante, Thomas F
    Mar 29, 2004 at 9:16 am
    Mar 30, 2004 at 8:47 am
  • A primary database was moved to a new server. The primary and standby are no longer communicating. The alert log on the primary is reporting.... ORA-16069: Archive Log standby database activation ...
    Grabowy, ChrisGrabowy, Chris
    Mar 25, 2004 at 8:29 am
    Mar 26, 2004 at 7:05 am
  • I don't know if some dba, want to talk about the way to solve organizing a group of developer (including times, work to be done, quality control, etc.) We have some experience, and had developed a ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Mar 22, 2004 at 9:33 am
    Mar 23, 2004 at 5:44 pm
  • List, We have an issue where we would like to join two tables using a column of different data types, so we thought to create a view which could cast one of those join columns to match that of the ...
    Saira Somani-MendelinSaira Somani-Mendelin
    Mar 19, 2004 at 8:46 am
    Mar 19, 2004 at 11:50 am
  • OK, I'm just going to bite the bullet and claim total ignorance here and see if someone takes pity on me :( (sad face a nice touch, eh?) Someone has accidently updated 378 records in the customer ...
    Barbara BakerBarbara Baker
    Mar 23, 2004 at 3:04 pm
    Mar 23, 2004 at 6:36 pm
  • I am looking into doing some table compression on my warehouse database to free up some space on the os. I am running on Unix 5.1. The compression is about 2.5:1 on my tables. The ...
    LeRoy KemnitzLeRoy Kemnitz
    Mar 19, 2004 at 2:37 pm
    Mar 23, 2004 at 3:38 pm
  • Okay, don't shoot the messenger, I think the question is kind of silly myself, but I have been directed to ask. As Samba is open source, and we don't know (if it breaks) who we will be able to get to ...
    April WellsApril Wells
    Mar 22, 2004 at 11:29 am
    Mar 23, 2004 at 9:48 am
  • Just out of curiousity... Does anyone know of any oracle related web logs besides mark rittmans that would prove valuable to visit frequently? ...certainly doesn't have to be specific to dba topics ...
    Chris StephensChris Stephens
    Mar 18, 2004 at 8:09 am
    Mar 20, 2004 at 7:16 pm
  • 17


    I'm running my 9.2 on XP Prof. SP1. I need DOS at my Command Prompt but cannot find it. Is it on XP? If so, where is it? Thanks, Ken Janusz, CPIM Please see the official ORACLE-L FAQ ...
    Mar 8, 2004 at 9:39 pm
    Mar 9, 2004 at 6:55 pm
  • I would suspect it's either from one of the old werewolf stories or from "The Lone Ranger" TV series. -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of Rognes, Sten ...
    Freeman, DonaldFreeman, Donald
    Mar 6, 2004 at 12:27 am
    Mar 9, 2004 at 8:30 am
  • Oracle support(without knowing anything about my system) is telling me to use the following settings: OPTIMIZER_INDEX_CACHING = 50 OPTIMIZER_INDEX_COST_ADJ = 5 Tom Kyte's book effective Oracle by ...
    Mar 5, 2004 at 8:46 am
    Mar 9, 2004 at 7:18 am
  • the only way to eliminate a soft parse on a query with bind variables is to set session_cached_cursors? Now is it possible for two different sessions to share the same cursor or will this always ...
    Mar 2, 2004 at 4:11 pm
    Mar 3, 2004 at 3:06 pm
  • We are now about a month a half from IOUG-A lives conference in Toronto, Canada in April and I have seen much less adverstising that in years past. Either registrations are going very well or very ...
    Adams, Matthew (GE Consumer & Industrial)Adams, Matthew (GE Consumer & Industrial)
    Mar 2, 2004 at 1:58 pm
    Mar 3, 2004 at 9:51 am
  • Dear list, Just asking for experiences using iFS, now called "Oracle Content Management SDK". I'm casting about for ideas to manage IT documents. The three things that I see as being necessary are ...
    Mar 31, 2004 at 12:54 pm
    Apr 4, 2004 at 6:18 am
  • With 9i, we have implemented the temp tablespace. This tablespace does not get backed up. Shortly, we are going to move this database to a new server. We will backup the database (hot backup) ...
    Jeffrey BeckstromJeffrey Beckstrom
    Mar 23, 2004 at 1:11 pm
    Mar 24, 2004 at 8:33 am
  • List, Here in the midst of Sarbanes Oxley, I've been pondering methods that might be used to prevent a system administrator from connecting to any databases running on that box. I know that it is ...
    Mar 16, 2004 at 4:33 pm
    Mar 18, 2004 at 12:38 am
  • Hello, I keep hearing of all the fun and good stuff that goes on at a Hotsos seminar but I've never been able to attend one as they usually seem to take place in the south west or west coast. So I'm ...
    Mar 11, 2004 at 1:05 pm
    Mar 12, 2004 at 8:50 am
  • Hi All, I have sent the question bank whoever requested. ( Few mail accounts rejected the zip attachement. Give other id, will send it again) Pl. let me know if anybody missed that. Sorry for the ...
    Kommareddy, Srinivas (MED, Wissen Infotech)Kommareddy, Srinivas (MED, Wissen Infotech)
    Mar 29, 2004 at 5:58 am
    Mar 31, 2004 at 1:57 am
  • Hi, Can some one tell me how to pass a array to a procedure when I run the procedure at sqlplus with pl/sql block of a declare begin end. I have a procedure that is going to accept as input a set of ...
    A JoshiA Joshi
    Mar 25, 2004 at 12:33 am
    Mar 26, 2004 at 8:19 am
  • Hi everyone, A couple of days ago I attempted a parallel mv-create statement in my dev database. Instead of completing, or even showing any progress, it sat there. When I didn't run it in parallel, I ...
    Koivu, LisaKoivu, Lisa
    Mar 25, 2004 at 10:27 am
    Mar 26, 2004 at 2:08 am
  • Well, what can I say...more performance problems in our apps environment. The outsourcing company is suggesting things like increasing buffer cache (seriously!). This time I've successfully ...
    Chris StephensChris Stephens
    Mar 30, 2004 at 3:26 pm
    Apr 13, 2004 at 12:09 am
  • hi i read the follwing line in oracle 9i documentation, Unique and primary keys can use non-unique as well as unique indexes. They can even use just the first few columns of non-unique indexes. i am ...
    Sai SelvaganesanSai Selvaganesan
    Mar 30, 2004 at 5:26 pm
    Apr 1, 2004 at 7:30 pm
  • I have another question about Oracle performance... I want to import MS Access to Oracle (Delphi as programming tool). But all the mechanisms are slows. By SQL Loader the process of importing ...
    Huascar EspinozaHuascar Espinoza
    Mar 11, 2004 at 1:13 pm
    Mar 12, 2004 at 8:43 am
  • Ryan There's two good scripts for this purpose, expensive_sql.sql and suspicious_sql.sql on Steve Adams' site http://www.ixora.com.au/scripts/query_opt.htm Also, just check the high CPU statements ...
    Feighery RaymondFeighery Raymond
    Mar 11, 2004 at 7:20 am
    Mar 12, 2004 at 6:08 am
  • Hi, maybe this is a stupid question, but I didn't it before, I want to create a cursor load data, and return in in a funciton something like If you can please, thank you. CREATE OR REPLACE TYPE ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Mar 3, 2004 at 2:07 pm
    Mar 4, 2004 at 11:13 am
Group Navigation
period‹ prev | Mar 2004 | next ›
Group Overview
grouporacle-l @

342 users for March 2004

Mladen Gogala: 164 posts Juan Cachito Reyes Pacheco: 153 posts Ryan.gaffuri_at_cox.net: 94 posts Jared.Still_at_radisys.com: 85 posts Niall Litchfield: 75 posts Bobak, Mark: 66 posts Jonathan Lewis: 66 posts DENNIS WILLIAMS: 56 posts Mercadante, Thomas F: 49 posts Tanel Põder: 47 posts Wolfgang Breitling: 46 posts Mladen Gogala: 45 posts Jamadagni, Rajendra: 42 posts April Wells: 41 posts Carel-Jan Engel: 40 posts Stephen.Lee_at_DTAG.Com: 40 posts Tim Gorman: 40 posts Ron Rogers: 38 posts Goulet, Dick: 37 posts Oracle-l-bounce_at_freelists.org: 37 posts
show more