FAQ

Oracle > oracle-l > August 2003

Search Discussions

492 discussions - 2,415 posts

  • I've been keeping an eye on the Boston Globe's Oracle DBA job postings, two years ago it wasn't uncommon to see eight or more per week, now I tend to see one or two, or none. For a while they also ...
    Boivin, Patrice JBoivin, Patrice J
    Aug 14, 2003 at 11:34 am
    Aug 15, 2003 at 2:54 pm
  • Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 ...
    Walter KWalter K
    Aug 28, 2003 at 3:34 pm
    Aug 31, 2003 at 5:39 am
  • Has anyone else noticed? Not so long ago, we saw quite a few more questions about such things as data modeling, application security architecture, physical database design, and Oracle Designer Not so ...
    Jared StillJared Still
    Aug 22, 2003 at 6:19 am
    Aug 27, 2003 at 10:14 pm
  • There seems to be a problem with consistent shutdowns in 9i Oracle 9i 64bit 9.0.1.3.0 - infrastructure database that comes with the application server 9.2.0.1.0 - that is the version of RDBMS we are ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 20, 2003 at 4:24 pm
    Aug 22, 2003 at 4:49 am
  • Guys, When trying to duplicate database with this script I have my auxiliary setup as new database, target setup as old database and am using duplicate database command along with logfile command to ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 4, 2003 at 9:09 pm
    Aug 6, 2003 at 1:44 pm
  • Jared, Did you send the list/me some mail with "Your Details" as subject line. It has some .pif file as extention. Maybe that is some virus, So wanted to make sure before i open it. Thanks. Enter for ...
    Dilip PatelDilip Patel
    Aug 25, 2003 at 5:14 pm
    Aug 28, 2003 at 6:59 pm
  • Hi Listers, One of my remote Clients is facing a problem with Redo Logs. The Redo Logs and the Archive logs in turn have suddenly started to generate at an alarming Rate. This has suddenly started ...
    Munish BajajMunish Bajaj
    Aug 1, 2003 at 10:34 am
    Aug 4, 2003 at 1:34 pm
  • Just came to know from CTOUG news that Oracle has chosen Arup Nanda(our List member) as "DBA of the Year". Congratulations Arup. thought I will share this news with the group. CTOUG Board Member, ...
    Prasada.Gunda_at_hartfordlife.comPrasada.Gunda_at_hartfordlife.com
    Aug 28, 2003 at 2:54 pm
    Aug 29, 2003 at 10:44 pm
  • Dear All, I am collecting (Just writing in a book ) of all tough problems, great issues handled with Oracle RDBMS as a DBA. Request you kindly send us the Top 5 Problems, Difficult scenarios(the most ...
    Veeraraju_MareddiVeeraraju_Mareddi
    Aug 23, 2003 at 1:09 pm
    Aug 27, 2003 at 11:09 am
  • Hi, does anybody have any experience with setting the SGA_MAX_SIZE in 9i. I assumed the purpose of this parameter was that SGA would grow as requested to that limit. Example: You could configure your ...
    Stephen.HODGKINSON_at_eaguk.comStephen.HODGKINSON_at_eaguk.com
    Aug 1, 2003 at 9:54 am
    Aug 9, 2003 at 1:09 pm
  • Oracle 8.1.7.4 Win2k What is the consensus on datafile sizing and the impact/overhead multiple datafiles have on performance? For example, if I have one 2.5g datafile, and three 1g datafiles, and I ...
    Dave PhillipsDave Phillips
    Aug 6, 2003 at 8:14 pm
    Aug 8, 2003 at 12:15 pm
  • Just completed the registration, and was wondering how much company I was going to have there. Who else has plans to attend? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author ...
    Steve McClureSteve McClure
    Aug 15, 2003 at 1:24 am
    Aug 28, 2003 at 10:49 pm
  • Hi, Whats the best way to write the results of a SQL query to a CSV file? Thanks. Hotmail messages direct to your mobile phone http://www.msn.co.uk/msnmobile -- Please see the official ORACLE-L FAQ ...
    Imran AshrafImran Ashraf
    Aug 25, 2003 at 12:39 pm
    Aug 26, 2003 at 9:19 pm
  • Our hardware people tell me that our disk array will not support Raid 10. Given a choice between Raid 1 or 5 for my tablespaces, which one is best? This is Oracle 8.1.7 on AIX 4.3.3. The application ...
    Schauss, PeterSchauss, Peter
    Aug 12, 2003 at 7:24 pm
    Aug 15, 2003 at 2:34 am
  • Guys, I have attached statspack report here. The ENV is Oracle 9.2.0.3 / Win2k AS - SP3. 1.Can you tell me which INIT parameters are to be changed which will give improved performance ? 2.can someone ...
    Prem Khanna JPrem Khanna J
    Aug 10, 2003 at 2:24 pm
    Aug 14, 2003 at 5:14 am
  • how different is it to administer oracle on different flavors of unix? Im running into some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell. is it just little syntax ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Aug 26, 2003 at 1:24 pm
    Aug 28, 2003 at 9:34 pm
  • Hello, Quest is trying to sell us a product named SharePlex. It sounds very attractive, but then sales people are supposed to be good at that. We are a mid sized company, about 2.2 billion per year, ...
    Nelson, AllanNelson, Allan
    Aug 8, 2003 at 9:14 pm
    Aug 11, 2003 at 9:44 am
  • We have a situation where a process can't insert into a partition of a partitioned table. The process just keeps running. - A stored procedure executes a SQL insert statement (listing below). - It ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Aug 6, 2003 at 3:39 pm
    Aug 8, 2003 at 9:24 pm
  • Hi All I would like to ask for your thoughts on whether to RAC or just go vertical (more cpu) Background Txn - OLTP like txn during day but batch extracts at night and very big batch extract ...
    Tjambu_fatcity_at_yahoo.com.auTjambu_fatcity_at_yahoo.com.au
    Aug 5, 2003 at 12:29 pm
    Aug 6, 2003 at 1:19 pm
  • Does anyone have any experience using cursor_sharing in 8.1.7.4? I feel I need to use it due to literal SQL statements being used. We have had misc 4031 errors off and on and I feel this is my last ...
    Fedock, John (KAM.RHQ)Fedock, John (KAM.RHQ)
    Aug 19, 2003 at 6:49 pm
    Aug 22, 2003 at 1:39 am
  • DABs, Is there any way in my connection to get the sid and serial# for my own connection? Suppose I connect to Oracle db by sqlplus scott/tiger_at_test. In this connection, SQL What shoud I input to ...
    Chuan.zhang_at_customs.gov.auChuan.zhang_at_customs.gov.au
    Aug 29, 2003 at 4:34 am
    Aug 30, 2003 at 2:04 pm
  • I have created my first 9i database on OS/390 v2.10. On my Oracle 8i instance, I can connect to the database using: sys/sys_password_at_the_instance HOWEVER, In Oracle 9i, I cannot do this. I am ...
    Babette Turner-UnderwoodBabette Turner-Underwood
    Aug 17, 2003 at 4:29 am
    Aug 18, 2003 at 5:44 pm
  • Wolfe Knowing SQL Server and moving to Oracle is going to be tough. The other way round is very simple though from Oracle to SQL Server. Every database functions differently in many respects. Best is ...
    Suhen PatherSuhen Pather
    Aug 1, 2003 at 12:29 am
    Aug 4, 2003 at 11:54 pm
  • I need to move selected tables from one schema to another schema within the same database. The tables I need to move all start with the same prefix (abc_sometablename). Say there are 200 tables out ...
    Smith, Ron L.Smith, Ron L.
    Aug 4, 2003 at 4:14 pm
    Aug 4, 2003 at 5:44 pm
  • 13

    Grid

    While I was cleaning up the other day, I noticed a magazine sticking out of the middle (sadly, closer to the top) of my still-to-be-read list. The cover story of Physics Today (Feb. 2002) is "The ...
    Henry PorasHenry Poras
    Aug 25, 2003 at 6:09 pm
    Aug 28, 2003 at 5:59 pm
  • We currently have an application we are trying to speed up. In researching rule/cost based optimizers, I read that the cost based optimizer was the way to go (although rule had its moments) because ...
    Burton, LauraBurton, Laura
    Aug 25, 2003 at 8:49 pm
    Aug 26, 2003 at 9:49 pm
  • Use RLS ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -----Original ...
    Jamadagni, RajendraJamadagni, Rajendra
    Aug 23, 2003 at 8:24 pm
    Aug 25, 2003 at 8:24 pm
  • Hi All, I'm trying to find some technical details about SharePlex, that is: How much network bandwidth I'd expect to replicate from database, generating 1-5 MB/sec redo. Does SharePlex send SQL text ...
    Gorbounov,VadimGorbounov,Vadim
    Aug 21, 2003 at 5:49 pm
    Aug 25, 2003 at 9:07 am
  • hi all, in the latest code release, a group implemented RLS and since then spotlight is constantly flagging 'latch waits' in the system. Yesterday the latch waits were upwards of 90%. Most active ...
    Jamadagni, RajendraJamadagni, Rajendra
    Aug 19, 2003 at 3:19 pm
    Aug 21, 2003 at 4:29 am
  • Yesterday I got hit with the Blaster Bug. To make a long story short I cannot apply the MS fix to my XP Prof. since I don't have the Update.inf file. Would like some feedback on where I can locate it ...
    KENNETH JANUSZKENNETH JANUSZ
    Aug 13, 2003 at 3:49 pm
    Aug 13, 2003 at 7:39 pm
  • How do you guys collect capacity planning metrics, such as DB size? Do you use StatsPack, Oracle OEM, others? I'm interested in an efficient method to track DB growth in GB month over month. Best ...
    David WagonerDavid Wagoner
    Aug 11, 2003 at 9:24 pm
    Aug 12, 2003 at 3:59 pm
  • Hello, I was wondering if someone can help me with a report. I am stuck figuring out what I can do to complete it. Here is what I need to do: for a given date range, i..e. start_date - end_date ...
    ViktorViktor
    Aug 26, 2003 at 8:59 pm
    Aug 29, 2003 at 3:04 am
  • Daniel Fink -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Daniel Fink INET: Daniel.Fink_at_Sun.COM Fat City Network Services -- 858-538-5051 http://www.fatcity.com San ...
    Daniel FinkDaniel Fink
    Aug 18, 2003 at 4:14 pm
    Aug 19, 2003 at 8:44 pm
  • Hello, Suppose I have some SQL scripts in my /home/user directories, /usr/local/bin directories, etc. If I start 'sqlplus' from console in /home/user directories, I can load/execute the script by ...
    Reuben D. BudiardjaReuben D. Budiardja
    Aug 14, 2003 at 6:09 pm
    Aug 16, 2003 at 11:24 pm
  • I just had a contractor tell me that the problem with my Diabetic detection and Listing 'feature' in their product (Integrated Clinical Database, ICDB) is because the 'view' crafted for that ...
    Wolfe Stephen S GS-11 6 MDSS/SGSIWolfe Stephen S GS-11 6 MDSS/SGSI
    Aug 12, 2003 at 1:39 pm
    Aug 13, 2003 at 3:04 pm
  • Hi Guys and Gals, We are currently doing some testing to enable us to move our production database from one unix box to another. We are running a 7.3.4 db in archivelog mode. The approach that ...
    Dobson, LisaDobson, Lisa
    Aug 7, 2003 at 12:20 pm
    Aug 13, 2003 at 9:04 am
  • Hi, Is there a statement in pl/SQL like case or is if elsif the only way. Meaning if I need to transalate state depending on input number as follows : 1 - CA 2 - OR 3 - WA 4 - AR Can I have one ...
    A JoshiA Joshi
    Aug 7, 2003 at 8:24 pm
    Aug 7, 2003 at 11:39 pm
  • I see it here all the time. Any articles on it? Im assuming its some kind of storage system right? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fat City Network Services ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Aug 4, 2003 at 6:19 pm
    Aug 5, 2003 at 2:19 pm
  • Sounds similar to the economic theories of Harry S. Dent, Jr. -- it's all based on birth-rate. Rich Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech Inc, Sussex, WI USA -- ...
    Jesse, RichJesse, Rich
    Aug 29, 2003 at 4:14 pm
    Aug 29, 2003 at 7:54 pm
  • I am sure you guys might have some nice perl/shell script to analyze alert log for errors or potential problem . Can you share it with me /list . Ohh thanks in advance guys . -ak -- Please see the ...
    AKAK
    Aug 27, 2003 at 5:14 pm
    Aug 28, 2003 at 2:54 pm
  • Guys, ...thought of buying a good book for linux system administration. i came across the books below. which one is good ? 1.Running Linux From O'Reilly By Matt Welsh, Matthias Kalle Dalheimer, Terry ...
    Prem Khanna JPrem Khanna J
    Aug 26, 2003 at 10:14 am
    Aug 27, 2003 at 8:44 am
  • Hi, I just start testing the trcanlzr scripts (metalink 224270.1) I did not remember seeing any traffic on that utility on oracle-l, that's why I went on orafaq where there is only a post by ...
    Stephane PaquetteStephane Paquette
    Aug 25, 2003 at 6:24 pm
    Aug 26, 2003 at 8:09 pm
  • Hi all, I have a 9.2.0.3 DB and I need to connect to Forms 6i as user sys. There are 3 boxes for username, password and database. I tried a lot of combinations, eg: Username: sys as sysdba Password ...
    RoboRobo
    Aug 21, 2003 at 8:54 am
    Aug 22, 2003 at 8:54 pm
  • im fairly certain its because DBMS_RLS doesnt use bind variables now. latch waits indicates plus your 100 concurrent users. you can check this by going to v$sqlarea and checking for similiar sql_text ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Aug 19, 2003 at 5:39 pm
    Aug 21, 2003 at 9:09 pm
  • Hello, env: Oracle 9.2.0.3 on Solaris. I am looking for any comments, good or bad, regarding Oracle Streams. We are considering using this to transfer data between some 9.2 databases on multiple Sun ...
    Becker.bill_at_marshfieldclinic.orgBecker.bill_at_marshfieldclinic.org
    Aug 13, 2003 at 5:04 pm
    Aug 19, 2003 at 9:39 pm
  • Hello I've an installation/implementation question! We've to analyse 50 document types, in total those 50 has 70 different attributes. We don't want to put all those document types into one table, ...
    Vernaillen TimVernaillen Tim
    Aug 7, 2003 at 1:34 pm
    Aug 7, 2003 at 10:14 pm
  • Hi, We're busy setting up an upgrade for oracle 7.3.4 hp-ux 10.20 to oracle 9.0.1.0 on a different hp-ux 11.11 box. In order to be able to migrate we installed 7.3.4 on this machine, copied datafiles ...
    Jeroen van SluisdamJeroen van Sluisdam
    Aug 27, 2003 at 1:49 pm
    Aug 30, 2003 at 4:24 am
  • Guys, When user trys to run our application through a VPN behind the firewall in a url they get an error. They can use ssh to get to host where I installed the application server but not run the ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 27, 2003 at 8:29 pm
    Aug 28, 2003 at 10:29 pm
  • We have a new requirement to support multiple languages in at least one of our databases. I'm reading the Oracle 9iR2 Globalization Support Guide (450 pages), but wonder if any of you can share ...
    David WagonerDavid Wagoner
    Aug 27, 2003 at 6:34 pm
    Aug 28, 2003 at 1:49 pm
  • Gurus, Would appreciate any help that I can get on this... I have 9.2.0.1 on redhat 9 ... However I cannot seen to start the agent on the server... agentctl start just bails out.. no messages... This ...
    Anjan ThakuriaAnjan Thakuria
    Aug 20, 2003 at 7:04 pm
    Aug 21, 2003 at 4:39 pm
Aug 2003
12345…10
Group Navigation
period‹ prev | Aug 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions492
posts2,415
users337
websiteoracle.com

337 users for August 2003

Tanel Poder: 173 posts Mladen Gogala: 96 posts DENNIS WILLIAMS: 91 posts Ryan: 81 posts Jamadagni, Rajendra: 78 posts Jared.Still_at_radisys.com: 74 posts Jesse, Rich: 48 posts Tim Gorman: 43 posts Jared Still: 42 posts Goulet, Dick: 33 posts Paula_Stankus_at_doh.state.fl.us: 31 posts Stephen Lee: 31 posts Stephane Faroult: 29 posts AK: 26 posts Cary Millsap: 26 posts Mercadante, Thomas F: 25 posts Joe Testa: 24 posts Matthew Zito: 24 posts Mladen Gogala: 23 posts Nuno Souto: 21 posts
show more
Archives