FAQ

Oracle > oracle-l > March 2005

Search Discussions

376 discussions - 1,331 posts

  • We have been doing application load testing lately and I found enq TX index contention being the top contender among other waits. The table with 5 indexes, all it's index columns gets updated via an ...
    StalinStalin
    Mar 21, 2005 at 9:51 pm
    Mar 22, 2005 at 4:52 pm
  • I blogged Day 1: http://www.oreillynet.com/pub/wlg/6627 I wish I'd thought to pack my camera. Oh well. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * ...
    Jonathan GennickJonathan Gennick
    Mar 8, 2005 at 12:37 am
    Mar 10, 2005 at 7:35 pm
  • Hello list, We have one query in our trading application thats executed 1770 times in just 20 mintues of time and around 490 users were connected, bascially, this query runs for every tranaction. The ...
    The Human FlyThe Human Fly
    Mar 31, 2005 at 9:17 am
    Apr 1, 2005 at 1:30 pm
  • Hello All, I've been testing a 10g RAC database (on linux & RAW) and one very specific task our application is doing is concurent inserts into the same table. I understand there are concurency issues ...
    Christo KutrovskyChristo Kutrovsky
    Mar 24, 2005 at 3:00 pm
    Mar 31, 2005 at 11:43 am
  • Hi, What changes required in below query to make faster? select url_stub, page_title, one_line_item_desc, score(10) content_score from url_pages sp where contains( sp.page_body, '(non-fee ...
    Seema SinghSeema Singh
    Mar 15, 2005 at 2:51 pm
    Mar 17, 2005 at 11:51 am
  • Hi all, We are facing the problem with design of a new application. Historically, we have been successful in pursuing our rules that DB links are not acceptable in our environment. Until now, we've ...
    Alexander GorbachevAlexander Gorbachev
    Mar 14, 2005 at 2:58 pm
    Mar 15, 2005 at 11:45 am
  • Oracle 9.2 We want to schedule a job via DBMS_JOB to run at 12:30am and 12:30pm. I'd prefer to schedule 1 job to do this rather than 1 job to run at 12:30am and 1 job at 12:30pm (I don't want them to ...
    Dirschel, SteveDirschel, Steve
    Mar 2, 2005 at 4:10 pm
    Mar 10, 2005 at 11:38 am
  • -Environment: Oracle 9205 RAC / RHEL3 cursor_sharing =3D FORCE Table MONITORING ON and STATISTICS updated every night (for tables that need it). Perl / Web based application. This is strangest thing ...
    Marquez, ChrisMarquez, Chris
    Mar 10, 2005 at 9:11 am
    Mar 14, 2005 at 5:06 pm
  • Oracle EE 9.2.0.4 64 bit SunOS 5.8 64bit data warehouse db ~100gb right now, growing every month no partitioning yet Just verified that you can drop an index when its underlying tablespace is in ...
    Carmen RusuCarmen Rusu
    Mar 3, 2005 at 11:15 am
    Mar 4, 2005 at 3:44 am
  • Just curious how the rest of the world gets "yesterday" in UNIX. We're running Solaris and we execute a sqlplus script with "select sysdate-1 from dual;" and pipe it to tail to set an environment ...
    Knight, JonKnight, Jon
    Mar 29, 2005 at 1:59 pm
    Mar 30, 2005 at 1:32 pm
  • All: We are planning to cold backup for 1 TeraBytes of datawarehouse database on weekly basis (every Saturday). Version :9i R2, OS: Sun Solaris No Archivelog Mode These are the steps we decide to ...
    Sami SeeranganSami Seerangan
    Mar 9, 2005 at 10:44 pm
    Mar 10, 2005 at 4:15 pm
  • I'm soliciting backup for a recommendation NOT to migrate our Oracle10g databases to a VMS cluster that our parent company is installing in a new data center. I'm thoroughly convinced that it's not ...
    Paul BaumgartelPaul Baumgartel
    Mar 30, 2005 at 5:51 pm
    Mar 31, 2005 at 6:05 pm
  • We have a collection of systems proposed where a set (I'm delibaerately avoiding the word 'cluster' here as we're not talking RAC) of Sun V440 boxes will be running Oracle instances attached to a ...
    Stephen boothStephen booth
    Mar 10, 2005 at 11:43 am
    Mar 11, 2005 at 1:29 am
  • Why does Oracle have to execute the sql and scan data in a table for a sql like this: Select * from table Where column1 is null and column1=3D10 Or=20 Select * from table Where column1=3D10 and ...
    Khedr, WaleedKhedr, Waleed
    Mar 7, 2005 at 11:41 am
    Mar 8, 2005 at 3:52 am
  • Hi all, Oracle 8.1.7.4 on 64-bit Solaris 8. I've searched Metalink but I'm having a hard time finding search terms that don't return about 2 million hits :) I've run into a situation where the same ...
    Jo_holvoet_at_amis.comJo_holvoet_at_amis.com
    Mar 3, 2005 at 12:04 pm
    Mar 3, 2005 at 1:20 pm
  • Hi, For portability reasons our Unix SAs would like us to run one listener / instance on the same port of each server. While I have no problem setting up one listener for two instances or two ...
    JayMiller_at_TDWaterhouse.comJayMiller_at_TDWaterhouse.com
    Mar 21, 2005 at 1:26 pm
    Mar 23, 2005 at 3:55 pm
  • Hi guys, Apologies if I'm revisiting a beaten path but I've tried to search the archive, metalink and google and couldn't find my answer (or it may have been hiding). So I'll ask the question ...
    Leng KaingLeng Kaing
    Mar 15, 2005 at 12:55 am
    Mar 18, 2005 at 12:13 am
  • I=92m trying to use a hot backup to make a copy of our production 817_32 = database using a 3rd disk mirror split operation. Here are the steps I=92m = taking: Create a text copy of the control file ...
    Rich HollandRich Holland
    Mar 14, 2005 at 10:12 am
    Mar 15, 2005 at 5:03 pm
  • Folks, Is it just my configurations, or is SQL in Oracle10g "buggy as hell," (to quote a colleague)? Every day I'm getting some sort of illogical result or ORA- error that is unreproducible in 9i ...
    Adam DonahueAdam Donahue
    Mar 2, 2005 at 6:32 pm
    Mar 3, 2005 at 8:46 am
  • 9i instance Linux Okay, we have an instance that we can log into connect sys/password as sysdba and it works fine however... if we try to log in '/ as sysdba' it complains about insufficient ...
    Aj wellsAj wells
    Mar 29, 2005 at 6:50 pm
    Mar 30, 2005 at 10:21 pm
  • Hello All, One of our client have upgraded their database from 9.2.04 to 9.2.0.6. They are using a CRM software which is generating the below mentioned SQL. Oracle is unable to parse this SQL, infact ...
    Brajesh.JaiswalBrajesh.Jaiswal
    Mar 21, 2005 at 4:46 pm
    Mar 22, 2005 at 1:19 pm
  • Hi,list: The developers of our new project chose JBoss+Hibernate as middle tier,and the backend maybe take single instance or RAC of Oracle 10g.I think hibernate is a good choise for developers,but ...
    Zhai JingminZhai Jingmin
    Mar 12, 2005 at 12:43 am
    Mar 19, 2005 at 12:29 am
  • I am being told that where there are five layers of views, it's because the design of the base tables no longer meet requirements. So they build views upon views. Do you think it's reasonable to see ...
    Boivin, Patrice JBoivin, Patrice J
    Mar 16, 2005 at 9:16 am
    Mar 16, 2005 at 2:59 pm
  • I'm trying to achieve partition pruning when accessing a table using a column other than the partition key. Here is the test: create table test_p_v ( c1 number, c2 number, c3 number)=20 partition by ...
    Khedr, WaleedKhedr, Waleed
    Mar 2, 2005 at 12:27 pm
    Mar 6, 2005 at 1:15 pm
  • I see Apple Xserve G5 is listed in the 10g EE support list. Anybody tried this out? Ray Stell stellr_at_vt.edu (540) 231-4109 Tempus fugit 28^D -- http://www.freelists.org/webpage/oracle-l
    Ray StellRay Stell
    Mar 30, 2005 at 4:14 pm
    May 6, 2005 at 4:22 pm
  • I haven't applied it to any lin32 boxes, but have been testing it on win32. So far, no issues. Just wondering if anyone has hit any potholes out there. thanks. Paul -- #/etc/init.d/init.cssd stop # ...
    Paul DrakePaul Drake
    Mar 25, 2005 at 3:02 pm
    Mar 29, 2005 at 7:47 am
  • I understand there is a "DESCRIBE my_data_base" command in Oracle SQL, and I assume it will return material describing the d-b in question. Right so far? If so, is it restricted in some way? I'm ...
    Graeme St. ClairGraeme St. Clair
    Mar 28, 2005 at 11:52 am
    Mar 28, 2005 at 4:13 pm
  • Hello Need some help on this. I have 2 table Emp empid (running on oracle sequenceno) empname deptid Dept deptid empid deptname I need to insert into emp table first and then get seqid just created ...
    Kean JacintaKean Jacinta
    Mar 18, 2005 at 5:20 am
    Mar 18, 2005 at 11:41 am
  • Hi: I want to calculate archivedlog file size per day to estimate backup storage area for the database which is currently operating in NOARCHIVELOG MODE. My redo log filesize is 100MB and below is ...
    Sami SeeranganSami Seerangan
    Mar 13, 2005 at 8:14 pm
    Mar 14, 2005 at 12:30 pm
  • I have read where you can grant access to a column to a user/role. I need to take it one step further. I need to restrict access to the column if it is for a certain group of people. i.e. I have ...
    Burton, LauraBurton, Laura
    Mar 11, 2005 at 4:09 pm
    Mar 12, 2005 at 2:34 am
  • ... come to those who wait. My manager has informed me that he would like me to take on a role as a database architect rather than 'just' as a DBA. Good news for me, as that is what I was hired to do ...
    Jared StillJared Still
    Mar 4, 2005 at 11:50 am
    Mar 10, 2005 at 7:26 am
  • we have materialized views being updated nightly by the refresh job. can someone tell me if that will rebuild the index and/or compute statistics associated to it? -- Bryan S Wells - DBA Newbie ...
    Bryan WellsBryan Wells
    Mar 1, 2005 at 4:32 pm
    Mar 3, 2005 at 9:55 am
  • Hi, A friend of mine was telling me that in his shop, they don't install Oracle software by the Installer anymore. They 'tar' one ORACLE_HOME from a unix server and copy it to the new server. It seem ...
    Luc DemancheLuc Demanche
    Mar 31, 2005 at 8:22 am
    Apr 1, 2005 at 2:42 am
  • Hi, We are trying to do a good configuration of our SAN. Let's see that exemple. EMC, with disk of 146G. - one LUN of RAID-5 for data (4+1 disks = 534G) one LUN of RAID-5 for index (4+1 disks = 534G) ...
    Luc DemancheLuc Demanche
    Mar 29, 2005 at 11:51 am
    Mar 29, 2005 at 9:26 pm
  • All... we are moving a production 9iR2 data warehouse to a new 4-way with 8G memory. was wondering if its worth upping my SGA to take advantage of this extra memeory? currently we are using less than ...
    Bryan WellsBryan Wells
    Mar 22, 2005 at 7:43 pm
    Mar 23, 2005 at 3:26 pm
  • Can anyone point me to some documents on calculating resource requirements for a project? I'm ok with disk consumption but cpu and memory seem harder to project. What I've done so far is get their ...
    David TurnerDavid Turner
    Mar 7, 2005 at 5:03 pm
    Mar 15, 2005 at 12:08 pm
  • Will Arhive Redo Log be generated by the INSERT /*+ APPEND */ Command if = the Target Table has been PRE-Created with NOLOGGING? Any possibility of giving Hint for NOLOGGING in the INSERT Command ? ...
    VIVEK_SHARMAVIVEK_SHARMA
    Mar 10, 2005 at 5:32 pm
    Mar 13, 2005 at 11:47 pm
  • Hello oh you great masters of Database: I come to you with a humble question version 9.2.0.6 on hp-ux 11i11 I have query like this: select * from a, b_at_site1 b c_at_site1 c where a.col1=b.col2 and ...
    Alfonso LeónAlfonso León
    Mar 10, 2005 at 3:12 pm
    Mar 11, 2005 at 4:11 am
  • Oracle 9.2.0.6 solaris 9 I was testing some rman stuff yesterday. I deleted a datafile from a users tablespace(only one datafile in the tablespace, they only had quota on that tablespace). I then ...
    Michael McMullenMichael McMullen
    Mar 4, 2005 at 8:23 am
    Mar 6, 2005 at 2:36 pm
  • Hi, We can use 10053 trace to list all the optimizer calculations and decesions about the query plan. But is there any event to check whether the optimizer has rewrittent our query, and if yes then ...
    Amit.poddar_at_yale.eduAmit.poddar_at_yale.edu
    Mar 11, 2005 at 8:31 pm
    Mar 14, 2005 at 8:13 am
  • Hi all, I have a simple question about Perl that I found when I was testing the speed of Perl doing Oracle transactions. The main reason for testing it was that my company has the internal script ...
    Martic ZoranMartic Zoran
    Mar 10, 2005 at 3:52 am
    Mar 11, 2005 at 4:16 am
  • Hi, We are sending the e-mails using the mailx client from the unix cron jobs. The new requirement is, after the stored procedure is executed using the job scheduler (dbms_job), we would like to send ...
    Subbiah, NagarajanSubbiah, Nagarajan
    Mar 8, 2005 at 12:30 pm
    Mar 8, 2005 at 2:14 pm
  • Running u0801070.sql - it has been running for 20 hours now. We are seeing 4030 errors, etc. Only thing changed init.ora so far is to increase java pool from 50m to 200 m per upgrade instructions ...
    Jeffrey BeckstromJeffrey Beckstrom
    Mar 2, 2005 at 8:42 am
    Mar 2, 2005 at 11:26 am
  • for lock type 'CU' what do values id1 and id2 indicate? We had a developer experience DBDS (death by dynamic sql). The session is waiting on 'global cache cr request' waiting for more than 3000 ...
    RjamyaRjamya
    Mar 23, 2005 at 3:55 pm
    Apr 26, 2005 at 11:51 am
  • Hello : i wanted to save image into database. Which would you recommend blob or long raw ? I read out some article mention about LOBS, only the LOB locator is stored in the table column . What does ...
    Kean JacintaKean Jacinta
    Mar 28, 2005 at 2:28 am
    Mar 29, 2005 at 6:59 am
  • Recently, Tanel Poder had suggested a way to reduce locks and latching was to issue a: ALTER TABLE owner.table LOCK DISABLE. This stops checking for table locks and also stops anyone from dropping or ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    Mar 25, 2005 at 2:30 pm
    Mar 26, 2005 at 9:53 pm
  • Hi, How do I find what is the latest 9i 10g release and dates released. And possibly upcoming releases. I am seraching on metalink patches advanced search etc. Thanks in advance.
    A JoshiA Joshi
    Mar 22, 2005 at 11:50 am
    Mar 25, 2005 at 9:46 pm
  • I'm currently evaluating Data Guard for our DR setup and initial tests seem to work fine. However, I made the mistake of asking Oracle about the licensing of the failover machines and was shocked by ...
    Brian WisniewskiBrian Wisniewski
    Mar 22, 2005 at 10:14 am
    Mar 23, 2005 at 4:45 am
  • I'm trying to use sftp for "security" reasons, but I've got some tablespaces that are quite large, and they are giving me some very strange errors. The old "bad" ftp routine handles these just ...
    Kline.MichaelKline.Michael
    Mar 15, 2005 at 3:57 pm
    Mar 18, 2005 at 4:42 pm
  • Hi Gurus, I am creating the file using utl_file package, but even though I set the umask to 022 the file is created without execute permission i=2Ee=2E file= is created with rw-r--r--=2E I am looking ...
    Admane, NarendraAdmane, Narendra
    Mar 9, 2005 at 10:44 am
    Mar 10, 2005 at 11:49 am
Mar 2005
12345…8
Group Navigation
period‹ prev | Mar 2005 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions376
posts1,331
users405
websiteoracle.com

405 users for March 2005

Jared Still: 51 posts Mercadante, Thomas F: 34 posts Niall Litchfield: 34 posts Paul Drake: 27 posts Christian Antognini: 25 posts Martic Zoran: 21 posts Rjamya: 21 posts Tim Gorman: 20 posts Mhthomas: 18 posts Lex de Haan: 17 posts Mladen Gogala: 17 posts Reidy, Ron: 17 posts Jonathan Lewis: 16 posts Mladen Gogala: 16 posts Stephen booth: 16 posts David Wendelken: 15 posts Hollis, Les: 15 posts Jungwolf: 15 posts Kean Jacinta: 15 posts Goulet, Dick: 14 posts
show more
Archives