FAQ

Oracle > oracle-l > November 2010

Search Discussions

101 discussions - 277 posts

  • Hi, I don't want to initiate a religious war. I have been using MySQL since last two years in production environment. I used SQL Server Express and Oracle Express before. I have no complaints with ...
    RP KhareRP Khare
    Nov 8, 2010 at 9:31 am
    Nov 9, 2010 at 9:35 pm
  • I have a developer request to compare CLOB fields over a dblink. We looked at dbms_utility.get_hash_value but that only works for varchar data types. We then looked at dbms_crypto.hash, which has ...
    Sherrie KubisSherrie Kubis
    Nov 1, 2010 at 2:34 pm
    Nov 3, 2010 at 6:58 pm
  • SQL*Plus: Release 11.2.0.2.0 Production on Tue Nov 2 19:09:25 2010 Copyright (c) 1982, 2010, Oracle. All rights reserved. Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - ...
    Michael DinhMichael Dinh
    Nov 3, 2010 at 2:12 am
    Nov 3, 2010 at 4:31 am
  • Hi all, I'm trying to (efficiently) determine which rows have column values with characters outside of the range of 0-127. My first attempt was something like this: select doc_id,doc_authors from ...
    Bobak, MarkBobak, Mark
    Nov 9, 2010 at 12:55 pm
    Nov 9, 2010 at 2:39 pm
  • Anyone using it successfully? I see a blog: http://sai-oracle.blogspot.com/2010/09/beware-of-data-loss-in-bct-based-rman.html but it read only as an issue with standby databases? thanks, joe Joe ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Nov 2, 2010 at 8:17 pm
    Nov 3, 2010 at 1:02 pm
  • If it is really so simple, You need some kind of locking in Your application (what is strange for me it should already be built-in) - pessimistic (ie. for example SELECT FOR UPDATE) or optimistic ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Nov 2, 2010 at 9:58 am
    Nov 3, 2010 at 12:52 am
  • I just recently tried to put 11.2.0.1 client on OEL 6 in a virtualbox. Had a heck of a time with packages. It ended up going in, very unstable and is really OEL 5. So my experiment is over for now ...
    Martin BrownMartin Brown
    Nov 13, 2010 at 2:33 pm
    Apr 27, 2011 at 4:40 pm
  • hi, where do You buy e-ebooks about Oracle usually? We plan to buy a small library - best of all in electronic format Regards Remigiusz -- Pole nakazi Remigiusz Sokolowski pos : DBA at DIiUSI addr ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Nov 5, 2010 at 8:10 am
    Nov 8, 2010 at 10:56 am
  • Hello all. I'm guessing this has come up before but I couldn't find it in the archives so here goes... I'm trying to find the reason why there isn't a mechanism to create multiple indexes at the same ...
    Nick PierpointNick Pierpoint
    Nov 16, 2010 at 9:32 pm
    Nov 25, 2010 at 2:13 pm
  • OK, I don't know if this one is related to oracle database, OEL, or something else entirely. But here it is: We have oracle clusterware 11.1 installed and running with asm 11.1. We also have oracle ...
    John SmithJohn Smith
    Nov 12, 2010 at 2:14 am
    Nov 17, 2010 at 9:35 pm
  • Greetings, I am doing an RMAN backup on RHEL 5 of my archivelogs every 10 minutes to keep the mount point from filling up. crosscheck archivelog all; backup as compressed backupset archivelog all ...
    Blanchard, William GBlanchard, William G
    Nov 15, 2010 at 4:01 pm
    Nov 19, 2010 at 11:23 am
  • SQL oradebug doc event action HANGANALYZE HANGANALYZE Hang analyze Usage HANGANALYZE( level ) Try to give in bracket. -- Thanks & Regards, Taral Desai -- http://www.freelists.org/webpage/oracle-l
    Taral DesaiTaral Desai
    Nov 9, 2010 at 1:45 pm
    Nov 10, 2010 at 4:51 pm
  • Dear fellows, at my current site we got a bunch of new DB servers running under HP-UX. The servers are configured to support host names up to 64 characters and some of them already exceed the former ...
    Uwe KüchlerUwe Küchler
    Nov 2, 2010 at 5:20 pm
    Nov 8, 2010 at 4:09 pm
  • I can't seem to find any documentation on this, probably because the search terms are so generic. Basically I'm wondering if you execute an update statement where you are setting the same value that ...
    Clay ColburnClay Colburn
    Nov 1, 2010 at 5:57 pm
    Nov 4, 2010 at 5:05 pm
  • Do you have exactly the same storage configuration in both data centers ? We found that _usually_ switching from buffered filesystem to direct IO won't help unless you increase also Oracle buffers ...
    Przemyslaw BakPrzemyslaw Bak
    Nov 26, 2010 at 9:21 am
    Nov 29, 2010 at 9:37 am
  • Good morning Friend, please, post one example of your script and the result that will be created by script. Cheers Waldirio -- Atenciosamente Waldirio msn: waldirio_at_gmail.com Skype: waldirio ...
    Waldirio Manhães PinheiroWaldirio Manhães Pinheiro
    Nov 26, 2010 at 9:40 am
    Nov 29, 2010 at 4:51 am
  • Hi guys, again with more newb questions.. lol! I found strange and not really easy to find why oracle has no oracle 10g client for linux. A guy here where I work has the 10g client for windows and I ...
    Guilherme Raymo LongoGuilherme Raymo Longo
    Nov 24, 2010 at 12:30 pm
    Nov 24, 2010 at 1:01 pm
  • Hi all, while doing performance tests of some new queries in our application I noticed one query where the estimated rows differ much from the actual rows in the execution plan (Line 7 in the ...
    Michael SeiwertMichael Seiwert
    Nov 7, 2010 at 8:53 am
    Nov 9, 2010 at 8:09 am
  • Ok so I have to plead complete ignorance here. I have a request from developers to "update java to newer version", I thought the JVM that is installed into the database is completely separate from ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Nov 3, 2010 at 1:31 pm
    Nov 3, 2010 at 1:54 pm
  • sounds like it's about time http://db-optimizer.blogspot.com/2010/06/cursorsharing-picture-is-worth-1000.html <http://db-optimizer.blogspot.com/2010/06/cursorsharing-picture-is-worth-1000.html tried ...
    kyle Haileykyle Hailey
    Nov 24, 2010 at 5:27 am
    Nov 30, 2010 at 1:37 am
  • I have a couple of Toshiba's Qosmio X500 with 64bit. http://www.toshiba.ca/web/product.grp?lg=en&section=1&group=1&product=9652&part=10970#spectop the spec says 1 tb hard drive but mine is 1.5TB on 2 ...
    Amaral, RuiAmaral, Rui
    Nov 24, 2010 at 5:16 pm
    Nov 25, 2010 at 12:29 am
  • hi, have You ever heard of KeySchemaTable UseCachingTable flag? We have got a solution to IN list limit (at 1000) that this can be circumvented by turning off such flag. I searched db reference, ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Nov 19, 2010 at 11:53 am
    Nov 19, 2010 at 2:40 pm
  • Hi Mohan, Good to see your problem is solved. Out of curiosity, may I ask why you explicitly set asm_diskstring when you are using asmlib? It should have been sufficient to leave it to the empty ...
    Martin BachMartin Bach
    Nov 19, 2010 at 7:14 am
    Nov 19, 2010 at 2:40 pm
  • Hi, Interesting enought that I have just had a conversation with colleagues about this a couple of days ago. Briefly: (extracted from Oracle Metalink note 220970.1) "Why does netca always creates the ...
    Jozsef HorvathJozsef Horvath
    Nov 8, 2010 at 4:09 pm
    Nov 19, 2010 at 6:16 am
  • Reference - Oracle Enterprise Manager Grid Control Certification Checker [ID 412431.1] Somewhere in there is this (underlines mine) NOTE: Oracle Enterprise Manager support for managing the listed ...
    Rajendra.pande_at_ubs.comRajendra.pande_at_ubs.com
    Nov 18, 2010 at 1:57 pm
    Nov 18, 2010 at 3:24 pm
  • All, I am planning to use customized ASM name +ASM_XP0053 ( where xp0053 is the server name) instead of the default +ASM Does this have any disadvantage . thanks in advance regards Kart -- ...
    K RK R
    Nov 16, 2010 at 12:35 am
    Nov 16, 2010 at 2:57 pm
  • Oracle-L, We're looking to implement an Oracle 11gR2 RAC environment with ASM and wanted to see if anyone had experiences (good/bad) implementing a backup solution utilizing NetBackup/RMAN. Any ...
    Dubovecky, JeffDubovecky, Jeff
    Nov 11, 2010 at 2:16 pm
    Nov 11, 2010 at 2:36 pm
  • You answered your own question - Because you want to get things done. You are dealing with people, bottom line, and some are better, some are worse, some are over worked, some are over their head, ...
    Robert FreemanRobert Freeman
    Nov 10, 2010 at 1:51 pm
    Nov 11, 2010 at 1:27 pm
  • I'm thinking that has to be ONE ugly query :) -- Thomas Roach 813-404-6066 troach_at_gmail.com -- http://www.freelists.org/webpage/oracle-l
    Thomas RoachThomas Roach
    Nov 11, 2010 at 3:55 am
    Nov 11, 2010 at 10:12 am
  • That approach would work, but in 11GR2 you can active dataguard with real time apply, which allows you to have the standby open in read only while the logs are being applied. That seems to be what ...
    Andrew KerberAndrew Kerber
    Nov 9, 2010 at 1:28 pm
    Nov 9, 2010 at 3:12 pm
  • Hey all, I've been trying to download the 3.3GB OEL5 DVD from Edelivery all weekend, but it stops at seemingly random intervals each time. Sometimes I get 300MB, sometimes 2+GB, but never the whole ...
    Rich JesseRich Jesse
    Nov 8, 2010 at 4:29 pm
    Nov 9, 2010 at 8:12 am
  • Hi all, does anybody know, or have consireded, any implication about having an instance name completely different from database name? I want to say, instance name maybe is D0EUNAME and database is ...
    Stefano CislaghiStefano Cislaghi
    Nov 8, 2010 at 10:10 am
    Nov 8, 2010 at 5:38 pm
  • Anyone see the problem before? I searched the WEB and only found a bug fix for 9.2.0.6. I was not able to find any posts about this error on 10.2.0.4 oracle databases. Our database server is Sun ...
    Jason KhymJason Khym
    Nov 5, 2010 at 1:44 am
    Nov 5, 2010 at 12:30 pm
  • Hallo Ric, I forgot to mention the DB version - it is 10.2.0.4 on Linux, statistics were computed (without histograms). Original query takes 1.08 seconds, union 0.01 Original statement: select * from ...
    Petr NovakPetr Novak
    Nov 4, 2010 at 12:39 pm
    Nov 5, 2010 at 11:07 am
  • What type of monitoring are you looking for? You can monitor 'throughput' based on taking snapshots of a table on the destination side, while the refresh is running. This must be run as a sysdba ...
    Bradd PiontekBradd Piontek
    Nov 4, 2010 at 4:03 pm
    Nov 5, 2010 at 6:54 am
  • I created a user account and am trying to create an odbc connection with it. It will let me connect with my system account but not with this account. Is there some role or sys priv that needs to be ...
    Zelli, BrianZelli, Brian
    Nov 4, 2010 at 4:25 pm
    Nov 4, 2010 at 5:13 pm
  • Hi All, I am installing 11.2.0.2 grid infrastrcuture on three node rhel 5 machines (x86_64). Root.sh is failing while adding nodeapps and vips. rootcrs logfile clearly showing that rootcrs.pl is not ...
    Harish KumarHarish Kumar
    Nov 3, 2010 at 7:09 am
    Nov 4, 2010 at 1:35 am
  • I logged in successfully by these users & accounts are not locked. Then I used FNDCPASS to change apps password but couldn't be reset & adadmin still don't work. Also I don't have a backup from table ...
    Mostafa EletribyMostafa Eletriby
    Nov 1, 2010 at 12:09 pm
    Nov 1, 2010 at 7:40 pm
  • The default for _lgwr_async_io = false, right? At least it is in my database. It is a hidden parameter, so was it changed in 10203? Perhaps ... Not sure how much documentation there is on these ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Nov 30, 2010 at 2:35 pm
    Nov 30, 2010 at 2:57 pm
  • Everytime that I've tried, I've only ever been able to create an SR for RED HAT LINUX SERVER INSTALL or some such category, which is something I've never wanted to do. Let me know what you find ...
    Don SeilerDon Seiler
    Nov 27, 2010 at 6:05 pm
    Nov 27, 2010 at 6:50 pm
  • Hello Friends, I would like to know how to see patches applied in Windows environment. Ps. In Linux I know the command: opatch lsinventory - details But in windows i did not get the command in the ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Nov 27, 2010 at 12:17 pm
    Nov 27, 2010 at 3:56 pm
  • Hi, does anybody know any data (or survey) which shows percentage what are the most popular operating systems (Solaris, AIX, Linux, ...) on which Oracle RDBMS is deployed ? Regards Przemyslaw Bak ...
    Przemyslaw BakPrzemyslaw Bak
    Nov 23, 2010 at 8:46 am
    Nov 25, 2010 at 5:36 pm
  • Hi, I have a rac database (10.2.0.4 on Redhat linux 4.6), which reports daily 5 or 6 times a global enqueue deadlock detected. For my investigations I'm trying to understand the wait-for-graph, but ...
    D'Hooge FreekD'Hooge Freek
    Nov 25, 2010 at 4:56 pm
    Nov 25, 2010 at 5:13 pm
  • "older jdbc thin drivers will not perform the automagic compile" ? I thought that compilation was always done by the server process; the client can only submit parse calls for a SQL statement ? ...
    Hemant K ChitaleHemant K Chitale
    Nov 24, 2010 at 11:43 pm
    Nov 24, 2010 at 11:59 pm
  • Good Day DBA's, Our shop owns a check printing application running on top of Oracle 9.2.0.1.0. This application is very slow during one particular process. While this process is running so slow, what ...
    Patrick obrienPatrick obrien
    Nov 23, 2010 at 4:54 pm
    Nov 24, 2010 at 3:40 pm
  • Peter, I would look for /var/log (or any other place dep, on the OS) to make sure there are no issues at hardware. You may get 15196 for hardware related issues as well. I don't see the version or ...
    K GopalakrishnanK Gopalakrishnan
    Nov 22, 2010 at 5:53 pm
    Nov 24, 2010 at 9:11 am
  • Hi Everyone, First happy Thanksgiving to all who will celebrate it! Now, to my issue: I have installed the Grid Control agent 10.2.0.4 on an OEL 5.5 server running an 11.1.0.7 database. This is a ...
    Allan NelsonAllan Nelson
    Nov 23, 2010 at 5:35 pm
    Nov 23, 2010 at 10:45 pm
  • Hi, please look down in report - all events are listed in next sections (Wait Events, Background Wait Events) . Top 5 includes also CPU, ist is only for the first glance. You should examine all ...
    Petr NovakPetr Novak
    Nov 22, 2010 at 10:29 am
    Nov 22, 2010 at 5:08 pm
  • Anyone else having trouble downloading from MOS? I wonder if that big security patch for 11.2.0.2 has them overloaded. -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.' -- ...
    Andrew KerberAndrew Kerber
    Nov 22, 2010 at 3:35 pm
    Nov 22, 2010 at 4:08 pm
  • Fellow DBAs, Database version: 11.1.0.7 I tried to create a scheduler job and I get an error that the job already exists. When I query the dba_scheduler_jobs view I do not see that job. Am I missing ...
    Dd yakkaliDd yakkali
    Nov 19, 2010 at 2:31 am
    Nov 19, 2010 at 6:16 pm
Nov 2010
123
Group Navigation
period‹ prev | Nov 2010 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions101
posts277
users126
websiteoracle.com

126 users for November 2010

: 13 posts Niall Litchfield: 13 posts Amaral, Rui: 11 posts Bobak, Mark: 9 posts Petr Novak: 8 posts Remigiusz Sokolowski: 7 posts Hemant K Chitale: 6 posts Martin Bach: 6 posts Goulet, Richard: 5 posts Michael McMullen: 5 posts TESTAJ3_at_nationwide.com: 5 posts Andrew Kerber: 4 posts Andy Klock: 4 posts Blanchard, William G: 4 posts D'Hooge Freek: 4 posts Dion Cho: 4 posts Guillermo Alan Bort: 4 posts Herring Dave - dherri: 4 posts Howard Latham: 4 posts Jack van Zanen: 4 posts
show more
Archives