FAQ

Oracle > oracle-l > February 2012

Search Discussions

84 discussions - 419 posts

  • Hi all, Although it is fairly new, does anyone experience with the DB Appliance? We are looking into this product however, haven't come across anyone with any real knowledge of the Appliance. I was ...
    Joseph ReidJoseph Reid
    Feb 28, 2012 at 4:51 pm
    Mar 10, 2012 at 9:45 pm
  • Folks, When using SQL plan baseline, is it possible to instruct the optimizer to use a baseline that has sub-optimal plan than the one it is currently using. For example, a SQL statement, which ...
    Hameed, AmirHameed, Amir
    Feb 2, 2012 at 8:58 pm
    Feb 15, 2012 at 6:25 pm
  • Hi All, 99% of the response time spent on the Fetch call.I know changing the arraysize from SQL*PLUS would reduce the number of fetch calls. But this sql is generated from a third-party application's ...
    Antony RajAntony Raj
    Feb 3, 2012 at 6:56 pm
    Feb 10, 2012 at 10:38 pm
  • Hi all, target environment: 11.2.0.3 RAC on RHEL 5.7 x86-64 SAN HP 3PAR I'm reading the following note on MOS: RAC and Oracle Clusterware Best Practices and Starter Kit (Linux) [ID 811306.1], in the ...
    Radoulov, DimitreRadoulov, Dimitre
    Feb 13, 2012 at 10:32 pm
    Mar 4, 2012 at 1:33 pm
  • Hi I have a database which had some application modifications (including database tables and pl/sql changes) last week, since then we have TM contention time to time. Initially I thought it was ...
    LS ChengLS Cheng
    Feb 27, 2012 at 11:41 pm
    Mar 6, 2012 at 4:36 pm
  • Hi everyone, Yesterday, I've got a question from someone: what's the percentage of different OS platforms Oracle runs on? Like about what percentage Oracle runs on Linux, what percentage on HP-UX, ...
    Betty HuangBetty Huang
    Feb 21, 2012 at 12:50 am
    Feb 27, 2012 at 8:46 am
  • Hi, On a 11gR2 RAC setup, after public network failure on one of the nodes, what is timeout for the VIP to failover to a surviving node? We carried out some tests by pulling out the cable for public ...
    Purav ChovatiaPurav Chovatia
    Feb 6, 2012 at 2:36 pm
    Mar 7, 2012 at 2:53 pm
  • Hello everyone, Has anyone looking for solutions that perform flashback schema similar to flashback table? The solution we are looking for should be able to rollback changes done during schema ...
    Mihajlo TekicMihajlo Tekic
    Feb 22, 2012 at 3:19 pm
    Feb 22, 2012 at 9:57 pm
  • Hi, I am trying to recover rman backups from one host to other (recover Oracle 10.2.0.1 backups on RHEL-4, x86_64 to Oracle 11.2.0.3.0 RHEL-5, x86_64). This is a test environment. - The database was ...
    Paresh YadavParesh Yadav
    Feb 15, 2012 at 5:06 am
    Feb 17, 2012 at 2:59 pm
  • Hi, From what I understand, Oracle does not support any of their products on VMWARE. With that said, has anyone installed grid control on VMWARE ? If so, were there any issues ? Thanks ed lewis -- ...
    Ed lewisEd lewis
    Feb 29, 2012 at 10:50 pm
    Mar 8, 2012 at 6:51 pm
  • Hi all, again a 2 node RAC 11.2.0.3.1 setup on RHEL 5.7 asmlib oracleasm-2.6.18-274.17.1.el5-2.0.5-1.el5 (kernel in use oracleasm-2.6.18-274.17.1.el5) Linux native multipath - device mapper asm scan ...
    Radoulov, DimitreRadoulov, Dimitre
    Feb 17, 2012 at 8:35 pm
    Feb 24, 2012 at 7:35 pm
  • Someone just brought me to a system that recently had an outage. A disk had gone bad and been replaced (supposedly RAID1). The database was restarted and appears to be working normally; however, ...
    Walker, Jed SWalker, Jed S
    Feb 13, 2012 at 11:19 pm
    Feb 23, 2012 at 9:33 pm
  • I tried to clone ORACLE database use one week ago RMAN (10Gr2) database backup. Clone database also on same server but different instance name. Anyone know how to do it? Thanks. -- ...
    Dba1 mccDba1 mcc
    Feb 7, 2012 at 3:20 pm
    Feb 7, 2012 at 10:37 pm
  • I have a query that can't be modified. It is a vendor supplied query. Since I can't change the query is there any way to do something like ... Hint the query and generate the query plan then somehow ...
    Dustin HaydenDustin Hayden
    Feb 23, 2012 at 3:28 pm
    Mar 13, 2012 at 11:35 am
  • Hi friends, I installed a Oracle 10g and I am facing problem to start listener service. C:\Users\ericarmo lsnrctl start LSNRCTL for 64-bit Windows: Version 10.2.0.4.0 - Production on 24-FEB-2012 ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Feb 25, 2012 at 12:46 am
    Mar 2, 2012 at 1:38 pm
  • This is Oracle 11.1.0.7.0 on Windows Server 2003 (32 bit). I changed the password for DBSNMP. Now I am trying to tell the dbconsole agent to use the new password. This is what I did: 1. set ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Feb 29, 2012 at 4:37 pm
    Feb 29, 2012 at 8:30 pm
  • Greetings All, I am trying to duplicate a database but it is failing with the following error: RMAN-03002: failure of set command at 02/22/2012 14:48:56 RMAN-06004: ORACLE error from recovery catalog ...
    Mandal, AshokeMandal, Ashoke
    Feb 22, 2012 at 11:19 pm
    Feb 24, 2012 at 10:55 pm
  • Hi all, How to find out which process or user session(s) are generating highest number of archive logs in a RAC database? My database is in 10.2.0.3 RAC In 10.2.0.3 Grid control, I noticed there is a ...
    Anurag VermaAnurag Verma
    Feb 16, 2012 at 5:38 am
    Feb 17, 2012 at 9:32 pm
  • Good morning listers, I'm researching a little bit of Oracle networking, and especially IPv6. Despite the fact that one cannot really ignore IPv6 anymore, there is no one I know of who is planning on ...
    Martin BachMartin Bach
    Feb 13, 2012 at 11:13 am
    Feb 14, 2012 at 12:02 pm
  • Hi, I would like to know if this query is justifiable for giving me a daily report on the database use space and how much it has increased. I am trying to use this as my Database Growth Usages ...
    Sheldon QuinnySheldon Quinny
    Feb 19, 2012 at 9:06 am
    Feb 20, 2012 at 1:40 pm
  • In our 11.2.0.3 EE database the first row insert right after a CREATE TABLE does not have a VERSIONS_STARTSCN or VERSIONS_XID associated with it, and we cannot query the data as it existed between ...
    Matt McClernonMatt McClernon
    Feb 13, 2012 at 6:15 am
    Feb 14, 2012 at 9:44 pm
  • Hi, Some one please share your ideas / methods for performance tuning approach for Oracle database ( specifically connection pooling application ) . i.e, If we are not able to identify the specific ...
    Raja SubramaniyanRaja Subramaniyan
    Feb 4, 2012 at 2:44 pm
    Feb 9, 2012 at 8:00 pm
  • Jeff, You can go really crazy with this idea, but let's start with the concept of truncating a table in a production environment. You do not want everyone to be able to do it, and you certainly don't ...
    Tim GormanTim Gorman
    Feb 8, 2012 at 10:57 pm
    Feb 9, 2012 at 7:33 pm
  • How can I find out how much time is spent by a query in memory sorts? i can easily get i/o timings, but I have suspicion my query is spending all its time on sorts... 64 bit linux 11.2.0.2 Thanks for ...
    Josh CollierJosh Collier
    Feb 23, 2012 at 2:12 am
    Feb 23, 2012 at 4:42 pm
  • My apologies if this has already been brought up but who's going to the Hotsos Symposium next month? I'll be there and would like to meet with other listers if interested. Finn -- ...
    Jorgensen, FinnJorgensen, Finn
    Feb 10, 2012 at 9:31 pm
    Feb 13, 2012 at 4:34 pm
  • Hi, I was wondering if it is easy to migrate an database in single instance to RAC+ASM using RMAN. Is it recommended using this method for any case?? My db has around 1 TB and I have the whole ...
    Alex CwbAlex Cwb
    Feb 2, 2012 at 11:38 pm
    Feb 5, 2012 at 8:40 am
  • Has anyone done the following: You have a primary database that is heavy into OLTP and has a physical standby in another geographical location. You create a logical standby locally for ...
    Goulet, RichardGoulet, Richard
    Feb 2, 2012 at 3:33 pm
    Feb 2, 2012 at 8:59 pm
  • Hello, Version: Oracle 9.2.0.8.0 OS: HP-UX preoas B.11.23 U ia64 3960232104 unlimited-user license problem: one hour less in sysdate only when we make conections using listener in all databases ...
    Samuel Guiñales CristobalSamuel Guiñales Cristobal
    Feb 28, 2012 at 10:38 am
    Feb 28, 2012 at 1:04 pm
  • Hello all, I detected a problem as described by testcase: (tested in following Installations) Linux x86 64-bit - Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production Microsoft ...
    Kurt-frankeKurt-franke
    Feb 21, 2012 at 2:09 pm
    Feb 22, 2012 at 11:32 am
  • Last night we saw (I mean really saw) a gen0 process blocked by a user session performing a distributed transaction in our RAC db. Unfortunately neither Oracle nor interwebs are very helpful on what ...
    RjamyaRjamya
    Feb 10, 2012 at 4:53 pm
    Feb 10, 2012 at 7:01 pm
  • I have one node which is part of 3 node 11gr2 RAC. Other 2 nodes(rac1, rac2) a power down, and on this node(rac3), crs is down. Problem is, that, if I switch crs up, he will up all VIP addresses , ...
    Sauron 666Sauron 666
    Feb 6, 2012 at 10:19 am
    Feb 7, 2012 at 8:38 am
  • Folks, We have an Oracle ERP system (11.5.10) with database version 11.1.0.7 running on Solaris 9. There are batch jobs, submitted via concurrent managers, that have been running fine for a long ...
    Hameed, AmirHameed, Amir
    Feb 3, 2012 at 4:33 pm
    Feb 3, 2012 at 8:32 pm
  • Hi list, The following is the question from our developer who is looking for a solution for the new system and business requirement. He proposed ODBC gateway, ETL tools. I would greatly appreciated ...
    Hsieh, JoanHsieh, Joan
    Feb 1, 2012 at 6:41 pm
    Feb 3, 2012 at 2:38 pm
  • Guys, Anyone had to convert an exponential number to a proper decimal number ? Ive got a varchar2 field which holds an exponential number as a string and need to get it out as a real number.... e.g ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Feb 27, 2012 at 1:07 pm
    Feb 27, 2012 at 4:40 pm
  • I have been trying to figure out how exadata griddisks are presented as candidate asm disks. We know that the disk discovery path for asm instances using exadata is "o/<cell_ip_address ...
    Gaurav mehtaGaurav mehta
    Feb 21, 2012 at 9:38 am
    Feb 22, 2012 at 5:46 pm
  • All, Before I go off like a gun in a colleagues face, has anyone had their DATA_PUMP_DIR changed when doing an Oracle upgrade? A colleague of mine did an upgrade of a dev database the other day for ...
    Goulet, RichardGoulet, Richard
    Feb 20, 2012 at 2:28 pm
    Feb 20, 2012 at 4:57 pm
  • I'm testing same exact sql in 2 different databases (identical object metadata (cloned), but different data volume). This query produces same exact xplan (identical plan hash) in both databases. 1) ...
    FmhabashFmhabash
    Feb 15, 2012 at 8:20 pm
    Feb 17, 2012 at 2:25 pm
  • Good day list, Very recently we have upgraded our 10gR2 (10.2.0.4) databases to 11gr2 and applied latest PSU patch (11.2.0.2.4). However, for some concerns, the COMPATIBLE parameter value was kept to ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Feb 13, 2012 at 7:06 am
    Feb 13, 2012 at 5:02 pm
  • Hi List, Suppose I want find out how many transactions can happen or happened in a time frame.. then apart from successful commits and or user calls, should I need to consider rollbacks(no matter ...
    Subodh DeshpandeSubodh Deshpande
    Feb 13, 2012 at 5:45 am
    Feb 13, 2012 at 2:55 pm
  • Guys, Just set up an 11gR2 DG config (one primary/one standby) on Linux and am seeing some strange errors in the standby alert log..... Every now and again, (its fairly random) the following is ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Feb 9, 2012 at 1:45 pm
    Feb 9, 2012 at 2:20 pm
  • I would like to give a developer access to alter a specific list of procedures/functions/packages from multiple schemas but I can think of a way to do it. I don't want to give him access to a whole ...
    Jeff ChircoJeff Chirco
    Feb 8, 2012 at 8:28 pm
    Feb 8, 2012 at 10:26 pm
  • test -- http://www.freelists.org/webpage/oracle-l
    Michael MooreMichael Moore
    Feb 8, 2012 at 6:51 pm
    Feb 8, 2012 at 7:13 pm
  • Hi, db 11.2.0.2.4 on aix through the code we make a few hundreds thousands of inserts into a large partitioned table. It takes some time, but usually it is a stable process (ie. time is more or less ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Feb 7, 2012 at 10:06 am
    Feb 8, 2012 at 12:12 am
  • We are looking at keeping a remote database at a vendor site updated. Timing is not terribly critical since one of the options is running a batch ETL job on a daily basis. Another option is to use ...
    Peter BarnettPeter Barnett
    Feb 3, 2012 at 3:51 pm
    Feb 4, 2012 at 1:10 am
  • Hello All, I am seeing the following message in lgwr tracefile along with 'log write time wait time' warnings: Warning: log write broadcast wait time 3000ms This is a RAC database (Version ...
    Saurabh manroySaurabh manroy
    Feb 24, 2012 at 9:58 am
    Feb 24, 2012 at 11:12 pm
  • Content-Type: text/plain; charset="US-ASCII" Content-Transfer-Encoding: quoted-printable We have our first 32K block size customer and suddenly we are receiving several deadlock graphs (0060) with ...
    Causey, BobCausey, Bob
    Feb 24, 2012 at 4:02 pm
    Feb 24, 2012 at 5:20 pm
  • Is there a way I can set a FTS to only use db file sequential read. Its for troubleshooting and curiosity mostly. Josh Collier Manager, Enterprise Services Information Technology Banfield Pet ...
    Josh CollierJosh Collier
    Feb 24, 2012 at 12:49 am
    Feb 24, 2012 at 6:59 am
  • Hi, We have written a stored procedures that DEQUEUEs a row from a specified queue in oracle 11g database. We have a program in PHP that loops say 5000 times and each loop, it calls the DEQUEUE ...
    ManiMani
    Feb 20, 2012 at 7:45 pm
    Feb 24, 2012 at 5:06 am
  • Good day, listers, We have recently been delving into ZFS and the very nice snap features. We hit a snag last night when attempting to scp a database from one host using zfs to another host using ...
    Charles SchultzCharles Schultz
    Feb 16, 2012 at 2:33 pm
    Feb 16, 2012 at 3:02 pm
  • Hi all, target environment: 11.2.0.3 RAC on RHEL 5.7 x86-64. Regarding the correct asmlib configuration with Linux native multipathing (device mapper) - note that I'm aware of the asmlib vs. udev ...
    Radoulov, DimitreRadoulov, Dimitre
    Feb 13, 2012 at 3:35 pm
    Feb 13, 2012 at 4:42 pm
Feb 2012
12
Group Navigation
period‹ prev | Feb 2012 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions84
posts419
users158
websiteoracle.com

158 users for February 2012

Antony Raj: 20 posts Radoulov, Dimitre: 17 posts Niall Litchfield: 16 posts Hameed, Amir: 10 posts Jonathan Lewis: 10 posts Lei Zeng: 10 posts David Fitzjarrell: 7 posts Guillermo Alan Bort: 7 posts Jared Still: 7 posts Mihajlo Tekic: 7 posts Subodh Deshpande: 7 posts Betty Huang: 6 posts LS Cheng: 6 posts Martin Berger: 6 posts Rjamya: 6 posts Kurt-franke: 5 posts Andy Klock: 5 posts CRISLER, JON A: 5 posts Michael Dinh: 5 posts Paresh Yadav: 5 posts
show more
Archives