FAQ

Oracle > oracle-l > May 2009

Search Discussions

126 discussions - 655 posts

  • A colleague and I were just discussing DBA's getting fired for screwing something up/failing to do something (Not for being generally poor employees like showing up late, etc). Neither of us had ...
    Newman, ChristopherNewman, Christopher
    May 15, 2009 at 3:39 pm
    Jun 17, 2009 at 1:12 am
  • Brandon, With a 8-table join this probably isn't the root cause as you've got max 40k join order permutations - that's including all cartesian join orders, which aren't all evaluated by default, ...
    Tanel PoderTanel Poder
    May 6, 2009 at 7:49 pm
    May 10, 2009 at 5:38 pm
  • So, I'm reading a particular book tonight. I don't want to say which one it is at the moment because I know one of the authors and I want to make sure that this author did not write this chapter. My ...
    Robert FreemanRobert Freeman
    May 22, 2009 at 1:11 am
    May 28, 2009 at 6:58 pm
  • A couple of weeks ago I asked the list if anyone was using HP/Oracle's Exadata machine.. The response was thunderous in it's silence and I can now see why ...
    Goulet, RichardGoulet, Richard
    May 13, 2009 at 1:44 pm
    May 15, 2009 at 2:08 pm
  • If you run a "dmesg" - do you see any errors in the kernel logs? If the devices stop responding to I/O for periods of time there should be SCSI timeouts in the logs, or at least some warnings from ...
    Matthew ZitoMatthew Zito
    May 15, 2009 at 1:57 pm
    May 19, 2009 at 5:35 am
  • I believe that Peoplesoft does allow multiple schemas (the default is SYSADM, so the multiples could be SYSADM_1, SYSADM_2 etc) in a single Oracle Database. This could support seperate business units ...
    Hemant K ChitaleHemant K Chitale
    May 20, 2009 at 2:12 pm
    May 30, 2009 at 7:10 pm
  • All, Is it possible to write a query to identify sessions that are holding invalidated package states? We are looking at issues around code migrations. The goal is to only recycle sessions that we ...
    Rumpi GravensteinRumpi Gravenstein
    May 6, 2009 at 5:27 pm
    May 7, 2009 at 8:23 pm
  • Kyle, The home-made sequence generator (table that holds the next "sequence number") springs immediately to mind. Something I still see from time to time. HTH Stéphane Faroult kyle Hailey wrote: -- ...
    Stephane FaroultStephane Faroult
    May 12, 2009 at 3:16 pm
    May 15, 2009 at 3:02 pm
  • Hello everyone, After our application folks implemented transaction management in the app, I am seeing a bunch of seesions waiting with "Tx - row lock contention" on an insert statement. we found ...
    Dd yakkaliDd yakkali
    May 26, 2009 at 6:41 pm
    May 31, 2009 at 6:41 am
  • Good Morning fellows, In one of our R&D boxes, we have 10g installed on SUSE linux. It was working fine and in use of users for various apps. Yesterday a user reported me that he cant run sqlplus ...
    Saad KhanSaad Khan
    May 19, 2009 at 2:43 pm
    May 19, 2009 at 5:50 pm
  • Has anybody given any thought to where we are going as SSD's get cheaper and bigger? We've been going round and round at my shop with discussions about RAID, other disk allocation issues, fights over ...
    Freeman, DonaldFreeman, Donald
    May 1, 2009 at 2:09 pm
    May 3, 2009 at 8:36 am
  • I am facing a lot of problems with bind variables because the access plan is changing and a critical performance problem occurs.(I have already posted a question "Histogram worthwhile" here at ...
    Roberto VeigaRoberto Veiga
    May 31, 2009 at 2:14 pm
    Jun 11, 2009 at 6:46 pm
  • I am nervous about doing this since it is Linux versus other OS. What is the correct command to use to remove a directory and all of the files that fall under that directory without receiving ...
    J. DexJ. Dex
    May 15, 2009 at 2:34 pm
    May 18, 2009 at 10:14 am
  • Thanks Alan, What you say is interesting. We are a RAC shop and I have always used oracleasm tools to create/delete ASM disks for SAN shared storage before or after I use them for an ASM instance ...
    QuijadaReina, Julio CQuijadaReina, Julio C
    May 28, 2009 at 12:35 pm
    May 29, 2009 at 7:55 pm
  • I could not agree more! This should be an interesting thread. =) EM seems to be Oracle's tool of choice, yet managing EM itself is a chore and a completely new set of skills. And very buggy. It has ...
    Charles SchultzCharles Schultz
    May 2, 2009 at 1:31 pm
    May 7, 2009 at 2:24 pm
  • Hi folks, Based on Oracle's ML note 249212.1, it seems that Oracle does not officially certify any of its product for VMWARE, but it does certify its products for the Oracle VM (464754.1). Having ...
    Hameed, AmirHameed, Amir
    May 13, 2009 at 4:10 pm
    May 14, 2009 at 9:46 pm
  • I'm at Collaborate right now, and we just finished the RAC SIG bird-of-a-feather session (it's a group discussion, and was quite good). Had an interesting point come up - we were discussing ...
    Jeremy SchneiderJeremy Schneider
    May 5, 2009 at 5:54 pm
    May 6, 2009 at 8:00 pm
  • dear all, I have 10.2.0.3 on solaris sparc, when trying to decrease log_buffer, it could not be done. always keep 14MB, sga is 3.5GB I want to decrease it to 1MB according to metalink note. 351857.1 ...
    Ujang JaenudinUjang Jaenudin
    May 28, 2009 at 10:14 am
    May 28, 2009 at 5:26 pm
  • Hi Bill, In my opinion, it would make more sense to install them locally, so that oracle home availability is not dependent upon SAN reachability(howsoever unlikely). Plus, if by oracle on SAN ...
    Rajeev PrabhakarRajeev Prabhakar
    May 14, 2009 at 7:32 pm
    May 15, 2009 at 12:39 pm
  • First, a little background. Two SAP systems running on a single Windows Server. Windows 2003 Server Oracle 10.2.0.4 Databases are using separate ORACLE_HOMEs. Backups consistently fail following the ...
    Jared StillJared Still
    May 26, 2009 at 8:18 pm
    May 27, 2009 at 12:43 am
  • No kidding. The economy must be a LOT worse than I thought. Or maybe Buffalo New York is a city somewhere else, and it's not actually US$... Michael Moore wrote: -- Jeremy Schneider Chicago, IL ...
    Jeremy SchneiderJeremy Schneider
    May 30, 2009 at 5:26 pm
    Jun 1, 2009 at 10:16 pm
  • Any reason you don't just run the scripts from a linux box? Speaking only for myself, when given the choice (most of the time) admin scripts are run from a linux box. Jared Still Certifiable Oracle ...
    Jared StillJared Still
    May 20, 2009 at 9:30 pm
    May 21, 2009 at 3:43 pm
  • Ok, this is semi-off topic. I need a laptop that will run an Oracle database, and at the same time do regular word processing, etc. I am looking at the dell xps, which will take 8G ram, and can take ...
    John SmithJohn Smith
    May 17, 2009 at 11:40 pm
    May 18, 2009 at 7:37 pm
  • I had always used the rule of thumb for putting 1.5 swap to RAM on Linux Servers We are installing OEL 5.2, 10G 3 node RAC cluster with 64G of RAM. When I looked at the Metalink install doc 421038.1 ...
    Kathy duretKathy duret
    May 13, 2009 at 7:08 pm
    May 14, 2009 at 12:36 pm
  • Listers, I have a two node 9i RAC on Windows 2000 (SP4) Advanced Server. This database serves a Siebel software running on a different machine. I don't know why these are windows machines, and I have ...
    Guillermo Alan BortGuillermo Alan Bort
    May 8, 2009 at 10:24 pm
    May 13, 2009 at 5:57 am
  • We are using ASM for 10.2.0.4 RAC on Linux x86-64 and will need to replace a number of disks in the storage array. I am wondering if anyone here has had any "interesting" experience with this sort of ...
    Don GranamanDon Granaman
    May 7, 2009 at 7:57 pm
    May 11, 2009 at 2:03 pm
  • Hi all does anyone know of any papers or study comparing ASM vs raw performance? We have a vendor deadset on raw, and the DbAs would rather not have to deal with that! thanks- Jeff Wong -- ...
    ~Jeff~~Jeff~
    May 27, 2009 at 8:30 am
    May 29, 2009 at 1:20 am
  • Hi, i have a materialized view, Only Complete referesh is possible on that view since it contains lot of subquerys, In order to complete refresh it takes 20 minutes to do that, So i need to reduce ...
    Mohammed Mehraj hussainMohammed Mehraj hussain
    May 21, 2009 at 1:39 am
    May 28, 2009 at 7:17 pm
  • Anybody know of program that will do a "tail" of a file on windows and keep refreshing itself when the file changes? This email and any files transmitted with it are confidential and intended solely ...
    Jeffrey BeckstromJeffrey Beckstrom
    May 18, 2009 at 7:10 pm
    May 20, 2009 at 8:18 pm
  • Hi Prem, I think it will just terminate the recovery, it may also corrupt the archivelog that it is currently being transported to the standby (which happened twice on me).. And it depends on your ...
    Karl AraoKarl Arao
    May 18, 2009 at 1:20 pm
    May 19, 2009 at 5:34 pm
  • 10.2.0.4 I want to create a database link in database "A" that connects to a physical standby database "B" that is in recovery mode: SQL create database link B connect to yyy identified by zzz using ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    May 18, 2009 at 2:11 pm
    May 18, 2009 at 7:42 pm
  • hi all, i need to format a file using the sed command on windows . For example iam running this command in my comman prompt of win xp. D:\sample sed "s/REM //" sample.sql 'sed' is not recognized as ...
    Mohammed Mehraj hussainMohammed Mehraj hussain
    May 15, 2009 at 5:35 am
    May 15, 2009 at 9:22 am
  • All, We have two node RAC environment with the applications connections going to first node. (No reference to the second node in tnsnames.ora). We are not using load balancing or failover. If case of ...
    Sanjeev mSanjeev m
    May 11, 2009 at 4:39 pm
    May 11, 2009 at 6:47 pm
  • Hey all, The recent thread on OEM's pluses and minuses got me thinking, but I didn't want to completely hijack the thread, so I figured I'd start a new one. It seems like most people use OEM/GC for ...
    Matthew ZitoMatthew Zito
    May 5, 2009 at 12:40 pm
    May 7, 2009 at 6:55 pm
  • Hi all, I inherited 8.1.7.4 (was upgraded from 8.1.6.3) on Win2000 Adv. Server(was upgraded from NT). Physical RAM is 4Gb db_block_size = 4096 sort_area_size = 6291456 sort_area_retained_size = ...
    Eugene PipkoEugene Pipko
    May 4, 2009 at 8:00 pm
    May 6, 2009 at 4:39 pm
  • Deen, Can you explain what problem(s) you've encountered doing this? To me it sounds as if all you would need is to declare log_input_values as an autonomous transaction (Only if storing data even ...
    Mathias MagnussonMathias Magnusson
    May 2, 2009 at 5:16 am
    May 3, 2009 at 3:20 pm
  • compensation is not the same across the country even given for living standards. I have been told that technical pay in south florida is horrible. that being said, in a bad economy, I have seen alot ...
    Dba DBADba DBA
    May 1, 2009 at 3:03 pm
    May 2, 2009 at 7:47 am
  • Hi List, has anyone ever seen any information about Transparent Session Migration? I even discovered this subject today starting with v$tsm_session and some digging led me to DBA_TSM_SOURCE, ...
    Martin BergerMartin Berger
    May 11, 2009 at 9:40 am
    Jun 3, 2009 at 4:43 am
  • Has anyone managed to get Database Control working for more than one database on the same Oracle home, on the same server? Details? Thanks! Mary Elizabeth -- http://www.freelists.org/webpage/oracle-l
    Mary Elizabeth McNeelyMary Elizabeth McNeely
    May 30, 2009 at 3:24 pm
    Jun 1, 2009 at 2:13 pm
  • I do think that there's a big benefit to knowing how to make your nearly idle development machine with little load and data behave like a very busy production machine with lots of load and data. You ...
    Cary MillsapCary Millsap
    May 27, 2009 at 10:09 pm
    May 28, 2009 at 4:34 pm
  • Hi Can somebody shared the SQL who can give the list of user based on PRIVILEGE passed to the script. e. I want to create a list of user who has CREATE SESSION privlege. It should only show me the ...
    Sanjay MishraSanjay Mishra
    May 18, 2009 at 4:31 pm
    May 20, 2009 at 3:38 am
  • Greetings, I can't find it at the moment but there are notes on Metalink taking you step-by-step through the removal of CRS on both Windows and unix. Bill Wagman Univ. of California at Davis IET ...
    William WagmanWilliam Wagman
    May 18, 2009 at 11:07 pm
    May 19, 2009 at 3:27 pm
  • at the CMD prompt, you may want to do so before calling them 'limited'. They are however different than commands in *nix land. MSDOS commands typically do not work as well in pipelines. There are ...
    Jared StillJared Still
    May 15, 2009 at 4:50 pm
    May 17, 2009 at 7:52 am
  • I changed the command to "delete force obsolete" and then it worked. ++++++++++ Getting following error when doing a delete command. I can not run a crosscheck command since we backup the backups via ...
    Jeffrey BeckstromJeffrey Beckstrom
    May 15, 2009 at 1:09 pm
    May 15, 2009 at 2:45 pm
  • We have Oracle Grid control 10.2.0.2 on solaris 10. Some of the custom written reports are eating up quite a bit of CPU cycles (tables are not large). The issue seems to be incorrect query plan. Do ...
    Upendra NUpendra N
    May 13, 2009 at 7:22 am
    May 14, 2009 at 8:18 am
  • Hi Listers, Please help me on this, I never encounter any problems when creating a new database using dbca. The screen show the ora-32006 complaining the background_dump_dest paramter, I have edit ...
    Joan HsiehJoan Hsieh
    May 4, 2009 at 5:55 pm
    May 5, 2009 at 7:28 am
  • Spotlight was nice when it came out but hasn't grown out of the old statistics and ratio based performance monitoring that has long been supplanted by the wait interface analysis. Waits and CPU usage ...
    kyle Haileykyle Hailey
    May 4, 2009 at 6:38 pm
    Jun 16, 2009 at 6:11 pm
  • Hi I dropped a schema that had about 175G of data in it. It took almost 10 hrs for that to happen, Is this normal. The system is in noarchivelog mode, v 10.2. -- Ram. -- ...
    Ram KRam K
    May 31, 2009 at 7:29 am
    Jun 1, 2009 at 1:56 pm
  • Look at the indexes in for the AWR tables. They grow and never shrink in 10. You will have to write a simple procedure to rebuild or coalesce them on a regular basis. -- ...
    Joel.wittenmyer_at_templarstable.comJoel.wittenmyer_at_templarstable.com
    May 27, 2009 at 2:46 pm
    May 28, 2009 at 9:43 am
  • So, I'm looking for some feedback from anyone that has run Oracle on VMWare. What have your experiences been, positive or negative? What is hype, what is great, what is disastrous, what is vapor? ...
    Robert FreemanRobert Freeman
    May 21, 2009 at 4:11 pm
    May 23, 2009 at 11:09 pm
May 2009
123
Group Navigation
period‹ prev | May 2009 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions126
posts655
users175
websiteoracle.com

175 users for May 2009

Jared Still: 27 posts Matthew Zito: 23 posts Bobak, Mark: 20 posts Tanel Poder: 20 posts Rajeev Prabhakar: 17 posts : 15 posts Guillermo Alan Bort: 13 posts Karl Arao: 13 posts Mathias Magnusson: 13 posts Goulet, Richard: 12 posts Yong Huang: 12 posts Howard Latham: 11 posts Niall Litchfield: 11 posts Nuno Souto: 11 posts Andrew Kerber: 10 posts Sanjay Mishra: 10 posts Tony van Lingen: 10 posts Jeremy Schneider: 9 posts Yechiel Adar: 9 posts Martin Berger: 8 posts
show more
Archives