FAQ

Oracle > oracle-l > August 2005

Search Discussions

325 discussions - 1,748 posts

  • Hi all This is to find out if there are any of you out there that either 1. have MMOG design or DBA experience or 2. know of anyone that has MMOG = Massive Multiplayer Online Game Looking at a system ...
    Tony JambuTony Jambu
    Aug 12, 2005 at 10:12 am
    Aug 15, 2005 at 11:47 am
  • I can NOT believe the if I used NOLOGGING to create and INDEX "long ago" *and* had many, many subsequent FULL BACKUPS that it could/did effect or error on a future recovery? Again, we are getting ...
    Marquez, ChrisMarquez, Chris
    Aug 11, 2005 at 1:13 pm
    Aug 25, 2005 at 8:28 am
  • Null is not a value. Just like infinity is not a value. Null is a state. Or is it in this case a non-existant state?;-) Which is why [NULL != NULL] as mathematical operations are not valid - state ...
    Billy Verreynne (JW)Billy Verreynne (JW)
    Aug 1, 2005 at 1:25 am
    Aug 10, 2005 at 1:02 am
  • 29

    OCFS2

    Looks like OCFS2 has come out of beta. Any brave takers on being a guinea pig, and letting us know how it goes David Hill CONFIDENTIALITY NOTICE This message contains confidential information ...
    David hillDavid hill
    Aug 5, 2005 at 11:37 am
    Aug 10, 2005 at 12:56 am
  • I have just been hit by the bug 3083560 which will be fixed in Oracle 9.2.0.7, if Oracle support is to be believed (and frequently, it is not). There was also a debate about the qualities of Linux, ...
    Mladen GogalaMladen Gogala
    Aug 22, 2005 at 10:40 pm
    Aug 28, 2005 at 8:31 am
  • Hi, I had been reading several articles, about how much faster is linux than windows. I don't know what is real and what is marketing. Could some one share please their own tests. Thank you -- Oracle ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Aug 4, 2005 at 9:58 am
    Dec 2, 2005 at 6:31 pm
  • I have no wish to start a flame war, repeat old topics already covered or take this way off-topic, but I am genuinely interested in taking my certification (only 8 years after starting in Oracle!) ...
    Johnson, GeorgeJohnson, George
    Aug 12, 2005 at 10:24 am
    Aug 14, 2005 at 9:03 pm
  • So, I have recently become a dba manager and I have a small issue. I have a junior dba new to scripting, sql, plsql, oracle. This scenario has happened a few times: -I request him to research ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 3, 2005 at 10:34 pm
    Aug 5, 2005 at 7:17 am
  • Recently this happened to me. I studied a good Oracle book by an author some months ago. It was a tough read for me, took several weeks to study, understand some important parts of the book. I had ...
    Ram KRam K
    Aug 19, 2005 at 3:22 am
    Aug 22, 2005 at 10:29 am
  • How would you approach task of sizing data files for a project that will start with a 1TB database but may relatively quickly grow to stabilize at around 10TB mark? Obvious options are: start with ...
    Branimir PetrovicBranimir Petrovic
    Aug 30, 2005 at 6:34 am
    Sep 8, 2005 at 2:37 pm
  • Hello! If your production-environment is an aix, your test-environment should be the same - right? Is it ok to use Linux for test-environment? There are many reasons not to use windows in this case - ...
    Bjørn Dörr JensenBjørn Dörr Jensen
    Aug 11, 2005 at 3:35 pm
    Aug 12, 2005 at 11:28 am
  • Hi all, I need to estimate table growth. Any ideas except standard select segment_name, sum(bytes) from dba_segments group by segment_name; and likes, done every day to extrapolate growth ? Any ...
    Ranko MosicRanko Mosic
    Aug 22, 2005 at 4:40 pm
    Aug 26, 2005 at 2:21 pm
  • RHAS 3.0/ 2 node 9.2.0.6 RAC/Web Logic front-end/JDBC thin-client connection. Developer is not getting response time he needs from a PL/SQL package he calls inside his java code. Made some sql ...
    Brian WisniewskiBrian Wisniewski
    Aug 2, 2005 at 12:50 pm
    Aug 9, 2005 at 7:36 pm
  • Hi, please Is there some free way to encrypt Oracle network data transmission in Windows? For example to avoid some person capture network data and found the role passwords. Thank you -- Oracle ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Aug 30, 2005 at 9:22 am
    Aug 31, 2005 at 12:01 pm
  • Sorry for the repeat post, going fishin... Is anyone attaching their Red Hat servers to a SAN with multiple paths to the luns for failover? How do you manage the paths? We were testing SDD (IBM ...
    Ray StellRay Stell
    Aug 16, 2005 at 10:14 am
    Aug 26, 2005 at 7:01 am
  • Folks, I'm having a rough time trying to figure out how to debug a DDL trigger. I'm on Oracle 9.2.0.4, under Tru64 5.1. I've written a trigger whose purpose is to make a backup copy of a table in one ...
    Herring Dave - dherriHerring Dave - dherri
    Aug 22, 2005 at 4:31 pm
    Aug 24, 2005 at 6:17 pm
  • Hello, I am attempting to make a copy of a production database that is on HP-UX and put it on a Solaris 5.8 box for testing. What are my choices for copying from one platform to the other? Just ...
    Fred SmithFred Smith
    Aug 16, 2005 at 11:55 am
    Aug 17, 2005 at 12:21 pm
  • this is for those who haven't checked OTN is last couple of days. Raj select standard_disclaimer from company_requirements where category = 'MANDATORY'; -- http://www.freelists.org/webpage/oracle-l
    RjamyaRjamya
    Aug 29, 2005 at 11:32 am
    Aug 31, 2005 at 10:32 am
  • Hi everyone, I'm encountering some strange problems with the CBO in Oracle 9.2.0.6 - it's telling me that I have more rows in the indexes than there are rows in the tables. I've tried all ...
    Leng KaingLeng Kaing
    Aug 9, 2005 at 12:26 am
    Aug 11, 2005 at 10:21 am
  • Hi, Okay, I am already 8i and 9i dba and I lost faith in doing OCP any more since just reading dump (example questions) anyone can pass. I wanted to do the OCM, but, surprised to see the pre-requisit ...
    The Human FlyThe Human Fly
    Aug 29, 2005 at 5:38 am
    Aug 30, 2005 at 8:37 pm
  • http://www.angrydba.com/ What is the worst thing you can here when you walk by a DBA's cube? 'Oops' Best quote on here: 'When did God create DBA's?' The day before he had his access revoked. -- ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Aug 23, 2005 at 12:57 pm
    Aug 29, 2005 at 11:46 am
  • Does anybody know any reason of not using temporary tables in Oracle 9i. Thanks -- http://www.freelists.org/webpage/oracle-l
    Aggarwal, MeenakshiAggarwal, Meenakshi
    Aug 26, 2005 at 10:54 am
    Aug 29, 2005 at 5:49 am
  • Oracle 9.2.0.4.0 Windows 2000 SP4 3gb memory The database is about 100gb. I seem to be having a problem with system resources that is causing new connections to the database to not happen during peak ...
    Sweetser, JoeSweetser, Joe
    Aug 9, 2005 at 12:50 pm
    Aug 13, 2005 at 4:23 am
  • Yesterday I posted a question regarding dbms_stats and analyze. A developer was running analyze compute on some tables because a report wouldn't run unless he analyzed compute statistics on those ...
    Ana ChotoAna Choto
    Aug 10, 2005 at 1:59 pm
    Aug 11, 2005 at 8:17 am
  • Hi all. I'm fazed by a query I've been asked to optimize. By creating an index, I've been able to lower EXPLAIN's cost estimate from nearly 5k to 36. Problem is, this translated in an answer time ...
    Leandro Guimaraes Faria C. DutraLeandro Guimaraes Faria C. Dutra
    Aug 9, 2005 at 3:21 pm
    Aug 11, 2005 at 12:22 am
  • Hi Listers, I have a korn shell script which needs to run 3 sqlplus scripts in parallel then run the final sqlplus script. Is there a way to ensure that sqlplus scripts 1 thru 3 completes before ...
    D chengD cheng
    Aug 3, 2005 at 4:50 pm
    Aug 5, 2005 at 3:05 am
  • I am wanting to write my archive logs to a different server to the one my database runs on. This server will not be running Oracle therefore I can't send the archive job via NET8, i currently send ...
    Peter DixonPeter Dixon
    Aug 24, 2005 at 5:43 am
    Aug 29, 2005 at 9:40 am
  • Dear FreeList users, I have been given a task to write a piece of pl/sql code/procedure which should accept a sequence name as IN parameter and output the nextval using OUT parameter. Any tips, ...
    Savitha malveSavitha malve
    Aug 23, 2005 at 5:52 am
    Aug 26, 2005 at 1:51 pm
  • Hello! Do anyone knew something about progress in research about developing sql that can analyze pictures or videos? Greeting Bjørn -- http://www.freelists.org/webpage/oracle-l
    Mette&Bj�rnMette&Bj�rn
    Aug 8, 2005 at 1:08 pm
    Aug 9, 2005 at 6:53 am
  • For those nervous about NOLOGGING, note that Oracle Apps (eBusiness Suite) 11i does use NOLOGGING in a number of operations -- eg when applying Patches and in a number of Business Intelligence ...
    Hemant K ChitaleHemant K Chitale
    Aug 24, 2005 at 8:14 am
    Aug 26, 2005 at 4:00 pm
  • Folks Need to migrate a big production Hybrid database from Oracle 8.1.7 on Sun to 9.2 on AIX. Main issue is that Source & Target DB Boxes/Machines being Located 20 KMs apart there is NO connectivity ...
    Oracle-l-bounce_at_freelists.orgOracle-l-bounce_at_freelists.org
    Aug 19, 2005 at 10:53 am
    Aug 24, 2005 at 1:49 pm
  • I'm struggling with getting CentOS 4.1 (RHEL 4 clone) configured as a desktop that I can also run an instance of 9i, 10gR1, and/or 10gR2 on. There's no way I should be having this many problems with ...
    Jesse, RichJesse, Rich
    Aug 10, 2005 at 1:46 pm
    Aug 11, 2005 at 7:21 am
  • Hi, does any one knows why in windows database release there is a developers release meanwhile in other platforms not. Thanks in advance. -- Oracle Certified Profesional 9i 10g Orace Certified ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Aug 31, 2005 at 9:26 am
    Sep 4, 2005 at 3:20 pm
  • I have a great position in the low cost of living and really nice city of Tally Florida. I am looking for an experienced Oracle dba. Does anyone have any ideas on the best place to recruit - ...
    Paula_Stankus_at_doh.state.fl.usPaula_Stankus_at_doh.state.fl.us
    Aug 30, 2005 at 10:31 pm
    Aug 31, 2005 at 4:41 pm
  • Our developers have a requirement to query a table and send the output to a PC every N minutes. Developers don't know Perl so looking at some alternatives. I would hate to do it in Sql*plus since ...
    Jeffrey BeckstromJeffrey Beckstrom
    Aug 25, 2005 at 6:52 am
    Aug 25, 2005 at 11:45 am
  • Assuming I don't have access to statspack, can I figure out the rate of inserts into the database? This is on a 9.2.0.6 db running RH AS 3.0. Third party app issuing JDBC calls to db. The approach I ...
    MkbMkb
    Aug 23, 2005 at 10:58 am
    Aug 25, 2005 at 9:43 am
  • All, My skill level: I have written my share of shell scripts...mostly basic. A few "loops" and "if" statements here and there. 90% of my shell scripts have been to do things with Oracle; EXP/IMP, ...
    Marquez, ChrisMarquez, Chris
    Aug 18, 2005 at 3:16 pm
    Aug 19, 2005 at 8:07 am
  • Hi All, Can I poll the list on their views on the use of histograms? I've previously been quite conservative, only gathering them when we've had a specific case of bad CBO performance due to skewed ...
    Charlotte HammondCharlotte Hammond
    Aug 16, 2005 at 6:35 am
    Aug 16, 2005 at 3:53 pm
  • Hi: I have a autocommit value set to OFF however when I exit from SQL*Plus it commits the transaction. Is it a expected behavior? SQL show auto autocommit OFF SQL delete from t1; 48601 rows deleted ...
    Sami SeeranganSami Seerangan
    Aug 15, 2005 at 2:12 pm
    Aug 15, 2005 at 6:20 pm
  • I am trying to run this cmd as root from a shell script: su - oracle -c /apps/oracle/product/9.2/bin/sqlplus /nolog @/apps/oracle/select_user.sql output: SQL*Plus: Release 9.2.0.6.0 - Production on ...
    Joe SmithJoe Smith
    Aug 11, 2005 at 3:33 pm
    Aug 12, 2005 at 7:54 am
  • We have migrated our datawarehouse to 9.2.0.6 from 8.1.7.4. Since the upgrade we experienced some performance degradation. We run a daily job to analyze the datawarehouse schemas using dbms_stats ...
    Ana ChotoAna Choto
    Aug 9, 2005 at 10:26 am
    Aug 9, 2005 at 12:39 pm
  • In my original quest for help I was working with one script. (btw with you help/code I did complete this task...works well, thanks!) Now I have a new problem that I do not know how to deal with. I ...
    Marquez, ChrisMarquez, Chris
    Aug 31, 2005 at 10:13 am
    Aug 31, 2005 at 11:07 am
  • Thomas, folks Is there some way of Avoiding creation of Constraint on Source/Master table while using Materlialized view refresh? NOTE - Production Database does NOT have any constraints & is of 600 ...
    VIVEK_SHARMAVIVEK_SHARMA
    Aug 26, 2005 at 6:52 am
    Aug 31, 2005 at 9:44 am
  • hi, I need to review the contents of an archive log generated last week on my production database. I did some searching online but couldn't find anything that was very helpful - I would prefer to ...
    Oracle_at_digistar.comOracle_at_digistar.com
    Aug 29, 2005 at 9:49 am
    Aug 30, 2005 at 6:42 pm
  • Hi, I'm trying to use rman with legato and when running run { allocate channel ch1 type 'sbt_tape'; } I get: RMAN-00571: =========================================================== RMAN-00569 ...
    Oded MaimonOded Maimon
    Aug 6, 2005 at 9:47 am
    Aug 26, 2005 at 2:33 pm
  • I need to restore our production database to a new server. I have RMAN (9i) backups on disk, but the original server is not available. No catalog was used. Can anyone point be to any instructions on ...
    Smith, Ron L.Smith, Ron L.
    Aug 22, 2005 at 9:05 am
    Aug 22, 2005 at 11:11 am
  • This statement appears to be killing our performance. What's going on and is there anything we can do about it? select type#,blocks,extents,minexts,maxexts,extsize,extpct,user#,iniexts,NVL(li ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Aug 17, 2005 at 11:04 am
    Aug 18, 2005 at 10:19 am
  • Hi, Is there a Linux command to find out number of processors or speed? I have Red Hat Enterprise Linux AS release 3. Muqthar Ahmed Database Administrator * * * * * * * * The information contained in ...
    Muqthar AhmedMuqthar Ahmed
    Aug 16, 2005 at 9:10 am
    Aug 17, 2005 at 10:47 am
  • We are currently having an issue on one of our servers. Its a Solaris 5.9 server running Oracle 8.1.7.4. There are 34 databases running on that server: 25 Production and 9 Standby. Whenever we try to ...
    Kevin LangeKevin Lange
    Aug 10, 2005 at 2:47 pm
    Aug 15, 2005 at 1:14 pm
  • We are setting up an application (third-party out-of the-box type) and the group that is setting it up would like to set it up so that when users search for records the searches are NOT case ...
    J. DexJ. Dex
    Aug 8, 2005 at 11:43 am
    Aug 8, 2005 at 7:50 pm
Aug 2005
12345…7
Group Navigation
period‹ prev | Aug 2005 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions325
posts1,748
users267
websiteoracle.com

267 users for August 2005

Leandro Guimaraes Faria C. Dutra: 91 posts Jared Still: 78 posts Allen, Brandon: 59 posts Marquez, Chris: 52 posts Oracle-l-bounce_at_freelists.org: 48 posts Rjamya: 48 posts Mercadante, Thomas F (LABOR): 37 posts Mladen Gogala: 36 posts Mladen Gogala: 36 posts Juan Carlos Reyes Pacheco: 28 posts Wolfgang Breitling: 28 posts Kennedy, Jim: 25 posts Paul Drake: 25 posts Billy Verreynne (JW): 23 posts Christian Antognini: 23 posts Raja rao: 22 posts David Sharples: 21 posts Dennis Williams: 20 posts GovindanK: 20 posts Reidy, Ron: 20 posts
show more
Archives