FAQ

Oracle > oracle-l > February 2011

Search Discussions

121 discussions - 667 posts

  • So, I am in the process of reviewing resumes from several JR and SSR candidates for the team. The question I came up with is, what kind of questions (technical) should I ask during the interview. I ...
    Guillermo Alan BortGuillermo Alan Bort
    Feb 6, 2011 at 11:06 pm
    Feb 9, 2011 at 3:48 pm
  • We've discussed this here before, but things change rapidly in the world of Oracle licensing so I'm here to find out the latest info before actually purchasing. As I've said before, I work as an ...
    Janine OhmerJanine Ohmer
    Feb 15, 2011 at 6:12 pm
    Feb 17, 2011 at 5:24 pm
  • I can think of many ways to do this but is there a definitive best practice? I'm sure there must be articles on this somewhere, so links as well as comments are appreciated. BEGIN for cur1 in (SELECT ...
    Michael MooreMichael Moore
    Feb 9, 2011 at 9:45 pm
    Feb 10, 2011 at 5:24 pm
  • Hi, Letting off some steam here. I just moved a Oracle client to 11.2, having done a set of tests with JDBC, PERL DBI, sqlplus etc etc. So far one shell script has had a problem, because it used the ...
    Peter HitchmanPeter Hitchman
    Feb 22, 2011 at 10:14 am
    Feb 25, 2011 at 9:35 pm
  • From: Mark W. Farnham Sent: Thursday, February 03, 2011 4:33 AM To: 'sheldonquinny_at_gmail.com'; 'Oracle-L Freelists' Subject: RE: Based of the Tablespace Growth Script I need to define a query. It ...
    Mark W. FarnhamMark W. Farnham
    Feb 3, 2011 at 9:42 am
    Feb 13, 2011 at 7:22 pm
  • Ah, the wonderful world of MOS! No wonder you all have been singing its praises! :) Fortunately I remembered to look under RDBMS, even though there is also an entry in the product list for Database ...
    Janine OhmerJanine Ohmer
    Feb 17, 2011 at 5:41 pm
    Feb 19, 2011 at 8:34 pm
  • Anyone ever configure the Grid Sql*Server agent on a sql database that user dynamic ports? If so how did you handle it? Dick Goulet Senior Oracle DBA/NA Team Leader -- ...
    Goulet, RichardGoulet, Richard
    Feb 4, 2011 at 5:37 pm
    Feb 7, 2011 at 3:22 pm
  • Hi, I am looking for Doc or Steps which can be used in creating a Physical Standby Database with Real-Time Apply. I have a Primary Database in Archive and FlashBack. OS- Windows 2003R2 DB- Oracle ...
    Sheldon QuinnySheldon Quinny
    Feb 21, 2011 at 11:18 am
    Feb 15, 2012 at 1:38 pm
  • Hi We are getting frequently the following error in alert log files of production server.It was running fine for last 3 months.There is no changes in listener configuration. WARNING: inbound ...
    KRISHNA MOORTHYKRISHNA MOORTHY
    Feb 23, 2011 at 2:24 pm
    Feb 24, 2011 at 12:49 am
  • Hi, I'm getting ready to do a new install of Dataguard. (Oracle 11.2.0, Solaris 10 64bit). The plan is to create a physical, and a logical standby. From what I understand, it's possible to have the ...
    Ed lewisEd lewis
    Feb 11, 2011 at 5:29 pm
    Feb 17, 2011 at 8:13 am
  • I've been trying to tune a SQL statement but I get very inconsistent results. I always start with: alter system flush shared_pool; alter system flush buffer_cache; Then I run the SQL, but the first ...
    Michael MooreMichael Moore
    Feb 7, 2011 at 5:49 pm
    Feb 8, 2011 at 5:15 pm
  • 10.2.0.3 on 32-bit Windows 2003 R2 I have a reporting table that is too large to grow by 10% very often - 66 million records growing by 250k per week = 24 weeks before stats go stale and are ...
    TJ KiernanTJ Kiernan
    Feb 9, 2011 at 7:50 pm
    Feb 14, 2011 at 1:16 pm
  • Where is there a document on setting up oracle users to administrator the database on Windows servers? Our admin wants to use domain accounts with Active Directory, but that does not sound right to ...
    Joe SmithJoe Smith
    Feb 8, 2011 at 10:07 pm
    Feb 14, 2011 at 1:04 pm
  • So, I recently took ownership of an 11gR2 cluster. One of the first things I noticed is that the SCAN was not set up correctly. The nslookup showed only 2 ip addresses, not the required 3. I am not ...
    Andrew KerberAndrew Kerber
    Feb 3, 2011 at 4:17 pm
    Feb 5, 2011 at 10:04 pm
  • Hi, I have following problem: update on table waits for lock (only one row tested), there is no lock on the table in v$LOCK, analyze table validate structure gets ORA-00054, no rows in db_2pc_pending ...
    Petr NovakPetr Novak
    Feb 17, 2011 at 7:20 pm
    Feb 18, 2011 at 9:30 am
  • Hi all, I created a trigger in my db with no errors, like this one: CREATE OR REPLACE TRIGGER scadenziario_update_trigger BEFORE UPDATE ON scadenziario FOR EACH ROW DECLARE motivo_sopralluogo ...
    Jose soaresJose soares
    Feb 11, 2011 at 1:31 pm
    Feb 14, 2011 at 6:37 pm
  • http://stage.vambenepe.com/archives/1735 -- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-l
    Niall LitchfieldNiall Litchfield
    Feb 10, 2011 at 10:52 am
    Feb 11, 2011 at 8:20 pm
  • Platform - IBM s/390 OS - SUSE Linux 10 Oracle - EE 10.2.0.4 We have been moving our application from 9.2 thick client to 11.2 thin client. Along the way we broke parts of the application because the ...
    Sandra BeckerSandra Becker
    Feb 21, 2011 at 7:04 pm
    Mar 7, 2011 at 6:23 pm
  • All, I have a need to do this next week. our productiond database is around 4TB . and I have to create 5 devlopment database from the production backup in TSM . Can i start the clone all these at the ...
    K RK R
    Feb 4, 2011 at 3:50 am
    Feb 26, 2011 at 10:09 am
  • Well, our systems guy is having trouble getting the storage configured correctly on Powerpath for or new 11gR2 cluster. His problem is getting the storage to appear in the same position on both ...
    Andrew KerberAndrew Kerber
    Feb 24, 2011 at 2:36 pm
    Feb 25, 2011 at 2:24 pm
  • SQL UPDATE s_subject 2 SET u_mrn = (SELECT u_mrn FROM annmarie.s_subject 3 WHERE annmarie.s_subject.s_subjectid = s_subject.s_subjectid) 4 where exists 5 (SELECT u_mrn FROM annmarie.s_subject 6 WHERE ...
    Zelli, BrianZelli, Brian
    Feb 17, 2011 at 8:06 pm
    Feb 17, 2011 at 8:31 pm
  • Ok, The subject pretty much says it all - I need some ideas on how to create an IO profile (specific to the disk I/O) for a server over "x" amount of time under the following constraints: 1.) Grid ...
    Taylor, Chris DavidTaylor, Chris David
    Feb 11, 2011 at 7:11 pm
    Feb 12, 2011 at 2:14 am
  • Dear List, I have an Oracle database configured in Archivelog mode running for the past couple months. Unfortunately, there is no backup has been taken so far, however, I am in need to clone the ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Feb 2, 2011 at 7:41 pm
    Feb 2, 2011 at 8:29 pm
  • I can't understand the Oracle license documentation. Is the Named User license cost also per processor? For example, if the named user license cost is $100 and I have 1 user on a 4 CPU box. Do I have ...
    Terrian, Thomas J DLA CTR TRANSACTION SERVICESTerrian, Thomas J DLA CTR TRANSACTION SERVICES
    Feb 1, 2011 at 3:51 pm
    Feb 1, 2011 at 7:50 pm
  • Hi, We had a legacy SAP database (2.1 TB) and the people who managed it are all gone. Now I have a task to restore it from tapes. Sun Solaris 9 Oracle 9i SAP 40B NetWorker 7.1 or 7.2 Legato NetWorker ...
    Roger XuRoger Xu
    Feb 25, 2011 at 4:08 pm
    Mar 14, 2011 at 11:42 pm
  • Hi Group, Greetings. I am trying to setup OEM email alert when the tablespace reaches 85% for warning and 95% for critical. I go to preferences - under Notification - Rules - create a rule - for All ...
    Sundar mahadevanSundar mahadevan
    Feb 24, 2011 at 9:53 pm
    Feb 25, 2011 at 3:57 pm
  • Hello! I'm quite sure most of you at least once have been in a situation when you HAD TO implement a requirement, which is stupid, results in slow performance and in principle cannot be optimized ...
    Gints PlivnaGints Plivna
    Feb 17, 2011 at 2:16 pm
    Feb 18, 2011 at 11:49 pm
  • Hi Friends, SunOS 5.10 Generic_137112-06 i86pc i386 i86pc, 64 Bit Oracle 10.2.0.1.0 While I am doing a startup, getting following error. SQL startup; ORACLE instance started. Total System Global Area ...
    Sreejith S NairSreejith S Nair
    Feb 16, 2011 at 1:26 pm
    Feb 18, 2011 at 12:24 pm
  • I have a database that is a data warehouse, so we bulk load data daily and tune the database for heavy read operations. I noticed that all of the foreign keys in the database are disabled. This ...
    Clay ColburnClay Colburn
    Feb 15, 2011 at 11:16 pm
    Mar 25, 2011 at 5:17 pm
  • I saw a ORACLE document "Performance Tuning Guide for Siebel CRM Application on Oracle Part I - Cost-Based Optimization Guide" On this article it say "don't analyze system statistics": System ...
    Dba1 mccDba1 mcc
    Feb 16, 2011 at 7:56 pm
    Mar 4, 2011 at 10:09 pm
  • All, Platform : Solaris(64-bit) RDBMS Version: 11.1.0.7.2 Our production database experienced hang and we could not connect to sqlplus and hang cleared on its own after few minutes. From AWR report ...
    Sanjeev MSanjeev M
    Feb 28, 2011 at 6:34 pm
    Mar 1, 2011 at 1:44 pm
  • dear all, two nodes cluster. I got strange behaviour on oracle clusterware 11.2.0.2 I had configured 2 nic (10gbit): node1-priv1 192.168.128.x node1-priv2 192.168.129.x node2-priv1 192.168.128.y ...
    Ujang JaenudinUjang Jaenudin
    Feb 23, 2011 at 6:18 am
    Feb 28, 2011 at 2:15 pm
  • When we were a much smaller company, we had one class of DB, "generic-DBA" where DBA was an abbreviation for "Does 'Bout Anything". A given DBA was responsible for Installation, patching, ...
    Michael MooreMichael Moore
    Feb 15, 2011 at 7:11 pm
    Feb 16, 2011 at 5:46 pm
  • subject changed so I can rant. This is my response to the recent thread about how to install Oracle in a Windows environment. I've changed the thread because I think that the main points were ...
    Niall LitchfieldNiall Litchfield
    Feb 15, 2011 at 9:15 pm
    Feb 16, 2011 at 1:31 pm
  • We were just chatting about the problem of users abandoning their terminals and the question arose - How long could a user leave an uncommitted transaction before it got rolled back?. Which mechanism ...
    Howard LathamHoward Latham
    Feb 15, 2011 at 1:04 pm
    Feb 15, 2011 at 4:45 pm
  • I don't have much experience using directories in Oracle (Oracle 10 on Windows Server 2003). I've taken over an instance with very little documentation. I don't believe any of these directories below ...
    Thomas DayThomas Day
    Feb 11, 2011 at 2:47 pm
    Feb 11, 2011 at 5:56 pm
  • All oracle versions, solaris 9,10. No ASM instance, so one listener/oracle_home. Back in the day, we had a couple scripts set up that would cycle through the databases and log in to an account using ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Feb 9, 2011 at 4:02 pm
    Feb 10, 2011 at 9:12 am
  • The only difference is the MAX function. SQL SELECT d1.dummy FROM DUAL d1 WHERE NOT EXISTS (SELECT MAX(1) FROM DUAL d2 WHERE d2.dummy = 'z') no rows selected. SQL SELECT d1.dummy FROM DUAL d1 WHERE ...
    Michael MooreMichael Moore
    Feb 9, 2011 at 1:39 am
    Feb 9, 2011 at 9:49 pm
  • Hi, I have a sql file (abc.sql) which contains some code. I am able to run this using "run" command as SQL run abc.sql 1* select 1 from dual 1 SQL But not able to execute using "_at_" command. If i ...
    Cbbakshi_at_aol.comCbbakshi_at_aol.com
    Feb 8, 2011 at 1:45 pm
    Feb 9, 2011 at 6:25 am
  • Hi All, I'm looking for a cheap way to start playing with RAC in my own time. I'd like to run a virtual environment but my current laptop doesn't really have the power. I know you can't run RAC ...
    Charlotte HammondCharlotte Hammond
    Feb 4, 2011 at 11:14 am
    Feb 7, 2011 at 4:30 am
  • 11.2.0.2 on RHEL I'm working on some SQL that suffers from some horrible cardinality estimate problems due to dummy rows that screw up the columns stats. Everything was going fine this morning but ...
    Stephens, ChrisStephens, Chris
    Feb 25, 2011 at 8:37 pm
    Feb 26, 2011 at 4:24 am
  • I had a user that deleted records from DBA_JOBS. Unfortunately, the application gives the user DBA rights so this is beyond my control. *I* know it is bad practice to directly mess with SYS tables, ...
    Jay HostetterJay Hostetter
    Feb 25, 2011 at 4:53 pm
    Feb 25, 2011 at 9:47 pm
  • We are in the process of moving an Oracle DB 10g from AIX to HP. Old DB is in non ASM, while the new one will be in ASM. I found ...
    Ram RamanRam Raman
    Feb 9, 2011 at 10:42 pm
    Feb 13, 2011 at 3:04 am
  • Hi Group, Greetings. I am trying to setup a logical dataguard on 11.2.0.2 (SLES 11 x86_64). Initially I am creating the physical standby with rman hot backup from primary. I followed the procedure ...
    Sundar mahadevanSundar mahadevan
    Feb 8, 2011 at 10:28 pm
    Feb 10, 2011 at 8:54 pm
  • Curious question. I have attended two Oracle events recently promoting Exadata. These are high performance, expensive systems. At the same time we have purchased applications requiring small to ...
    Peter BarnettPeter Barnett
    Feb 9, 2011 at 3:17 pm
    Feb 9, 2011 at 5:02 pm
  • Hello Listers, Using Oracle 9i RMAN template below. Level 0 executes on Sunday, Level 1 the rest of the week. Client has limited disk space. Can the 'delete input' and/or 'delete obsolete' be ...
    Alan StergerAlan Sterger
    Feb 7, 2011 at 6:22 pm
    Feb 8, 2011 at 12:38 pm
  • Hi, I was trying to find out which view could provide me information if I am logged on Rac or Standalone instance. Disregard many ways to look for this info, but considering only when connected, and ...
    Alex ListAlex List
    Feb 5, 2011 at 6:37 pm
    Feb 6, 2011 at 10:50 pm
  • Hi Our production database server is getting frrezed suddenly yesterday..There is no deadlock or any unknown errors in alert log file. Oracle database version : 10.0.2.0 OS : RedHatLinux 5.2 Please ...
    KRISHNA MOORTHYKRISHNA MOORTHY
    Feb 5, 2011 at 6:30 am
    Feb 5, 2011 at 5:15 pm
  • Listers, Anyone successful in getting ETL developers using Business Objects Data Integrator to use DBMS_APPLICATION_INFO for setting module and action? Interested in getting this done for the usual ...
    Larry G. ElkinsLarry G. Elkins
    Feb 11, 2011 at 1:26 pm
    Mar 25, 2011 at 1:04 pm
  • I am scrathing my head to write a SQL query to get this information: I have two tables t1 and t2 with these values Table t1 Col1 Col2 ------ ------ 1 One 2 Two 3 Three Table t2 Col1 Colx ------ ...
    John scottJohn scott
    Feb 24, 2011 at 6:56 pm
    Feb 27, 2011 at 7:57 am
Feb 2011
123
Group Navigation
period‹ prev | Feb 2011 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions121
posts667
users194
websiteoracle.com

194 users for February 2011

Niall Litchfield: 27 posts Andrew Kerber: 22 posts : 20 posts Guillermo Alan Bort: 20 posts Michael Moore: 20 posts Sheldonquinny_at_gmail.com: 16 posts Subodh Deshpande: 15 posts Allen, Brandon: 13 posts Goulet, Richard: 10 posts Janine Ohmer: 10 posts Greg Rahn: 9 posts Dominic.Brooks_at_barclayscapital.com: 8 posts Harel Safra: 8 posts Jared Still: 8 posts Laimutis.Nedzinskas_at_seb.lt: 8 posts Martin Bach: 8 posts Pavel Ermakov: 8 posts Stephane Faroult: 8 posts Taylor, Chris David: 8 posts Bobak, Mark: 7 posts
show more
Archives