Search Discussions

86 discussions - 519 posts

  • I am settling a debate about allowing CamelCase procedure names within a package. For example Procedure GetOpenProjects() Or Procedure get_open_projects() I am particularly against it and would ...
    Jeff ChircoJeff Chirco
    May 18, 2012 at 9:39 pm
    May 30, 2012 at 4:17 pm
  • Hi Two notes are given for applying the fix for this alert (one for rac and another for non-rac). We dont use scan listeners on a 2 node rac. So after reading the note 1340831.1, I think the steps ...
    Kumar MadduriKumar Madduri
    May 2, 2012 at 7:25 am
    May 11, 2012 at 7:20 pm
  • I understand many still like to see business logic placed outside of the database and that ORM's are very popular but I didn't expect to see experienced software developers to have opinions like ...
    Stephens, ChrisStephens, Chris
    May 15, 2012 at 7:24 pm
    May 31, 2012 at 5:03 pm
  • Hi all, I'm interested in finding out whether posters to this list wish there were features in Oracle that are available on other systems? I saw a posting by Jonathan Lewis ...
    Paul LinehanPaul Linehan
    May 26, 2012 at 4:34 am
    Jun 19, 2012 at 11:02 am
  • Colleagues, I am currently working on a system that is experiencing frequent ORA-04031 errors. Investigation found that they have a LOT of SQL with literal values and while I suggested that they fix ...
    Gerry MillerGerry Miller
    May 1, 2012 at 9:42 am
    May 15, 2012 at 10:53 pm
  • Just after a sanity check really. Does anybody else on this list encounter the issue I describe below when using the HTML version of MOS? It's happening for me and at least one other colleague across ...
    Niall LitchfieldNiall Litchfield
    May 10, 2012 at 11:07 am
    Jun 29, 2012 at 9:26 am
  • Folks, I have a three-node Oracle RAC running with Grid version So, far there is no database created and only CRS is running on all nodes. I am using NFS for everything (binaries, OCR & ...
    Hameed, AmirHameed, Amir
    May 8, 2012 at 2:43 pm
    May 22, 2012 at 10:07 am
  • Hi all My developers have a pretty complex batch process (written entirely in PL/SQL packages & functions) running in RAC database (Solaris 10), this process runs in around 12 hours time, we ...
    Ls ChengLs Cheng
    May 17, 2012 at 6:54 pm
    Jun 7, 2012 at 8:58 pm
  • I have a 3TB database that needs to be moved from hp-ux to linux. I need to know the fastest way to do this. Tried doing a datapump export (parallel 6) and it took over 36 hours which is too long ...
    Dustin HaydenDustin Hayden
    May 25, 2012 at 11:15 am
    Jun 12, 2012 at 12:11 am
  • Probably a silly question but I have a brain freeze ... In this 11gr2 env, we will be refreshing a mview over a dblink, developers want to know " is there a way that the dbms_mview.refresh() can tell ...
    May 23, 2012 at 1:29 pm
    May 30, 2012 at 12:02 pm
  • I'm interested in creating a daily report to run in our development environments to spot inefficient SQL early in the process. I've already got one that lists top ten highest elapsed time and top ten ...
    Stephens, ChrisStephens, Chris
    May 29, 2012 at 8:15 pm
    Jun 1, 2012 at 5:20 pm
  • I need to run a block corruption test. I have a BCV copy of prod I am running this on. We are not using RMAN for prod backups. I can't change this. DB Version: DB Size: 10 TBs files are on ...
    Dba DBADba DBA
    May 21, 2012 at 6:46 pm
    May 23, 2012 at 3:47 pm
  • Hello everyone, My developers at our shop have issues with learning new stuff. When i say "new", i really mean old... Implicit cursors haven't even been discovered by them yet. Anyways, what would be ...
    Lyall BarbourLyall Barbour
    May 30, 2012 at 3:13 pm
    May 31, 2012 at 2:20 am
  • Hi, I have to move a oracle database 10g ( to another server, what would you recommend me that is the best option for doing it? Cloning database? Architecture will be the same in the ...
    May 3, 2012 at 8:26 am
    May 12, 2012 at 10:38 am
  • Hi experts, We have limited budget, and put SSD for both undo and temp tablespace. We encountered ora-01555 error and some error that temp tablespace is not enough. I just want to know how SSD will ...
    Qihua wuQihua wu
    May 21, 2012 at 11:58 pm
    May 24, 2012 at 4:30 pm
  • Hi, We have an Oracle 10g database on RHEL5. I would love to find a way to speed up the export of the database. It currently takes about 7.5 hours. The main problem is with 2 tables, one of which is ...
    Maureen EnglishMaureen English
    May 5, 2012 at 1:59 am
    May 7, 2012 at 11:23 pm
  • Is there an active Oracle user group in the Raleigh, NC area? Seems there used to be. Asked my local Oracle rep and he didn't know of one. Would rather join an existing group. But I'm potentially ...
    May 16, 2012 at 7:13 pm
    Jun 5, 2012 at 11:31 am
  • Hi list, could anyone share some tips, experience (or white papers)? RAC and Oracle Clusterware Best Practices and Starter Kit (HP-UX) [ID 811303.1] contains a Step By Step guide for installing ...
    Radoulov, DimitreRadoulov, Dimitre
    May 25, 2012 at 1:49 pm
    May 25, 2012 at 8:38 pm
  • Hi, We are running a workload on 2 different setups to compare performance. And we have some very unusual observations for exactly the same workload. There are a few differences between the 2 setups, ...
    Purav ChovatiaPurav Chovatia
    May 15, 2012 at 3:41 pm
    May 22, 2012 at 3:32 pm
  • If one was inclined to learn Perl from the ground up, what books or courses would you recommend? I'd like to add this to my toolbox but I've been lax [read: lazy]. Chris Taylor "Quality is never an ...
    Taylor, Chris DavidTaylor, Chris David
    May 10, 2012 at 5:38 pm
    May 16, 2012 at 11:54 pm
  • DB Version: This is a very old database that may date back to 6.x. We have a very old job that does replace(to_char(field)) and blows up on some data. When I look at it I notice that it ...
    Dba DBADba DBA
    May 4, 2012 at 6:37 pm
    May 10, 2012 at 6:25 am
  • This from a query on v$access in our DW in Â Â Â Â Â Â Â Â Â Â SID OWNERÂ Â Â Â Â Â Â Â Â Â OBJECT -------------- --------------------Â ...
    May 17, 2012 at 11:00 pm
    May 23, 2012 at 2:43 am
  • Folks, I am duplicating my prod db every night and recently started using ASM diskgroups for the auxiliary database instance. I've noticed that each time duplicate db runs, a new set of datafiles are ...
    Imtiaz MerchantImtiaz Merchant
    May 20, 2012 at 5:31 am
    May 21, 2012 at 2:02 pm
  • Hi list, I've been given a deadline to decide whether we stay with 12c or go back to 11g OEM. I'd much rather stay with 12c as it's shiny and new (and honestly seems a lot more stable than 11g) but ...
    Guillermo Alan BortGuillermo Alan Bort
    May 18, 2012 at 2:06 pm
    May 19, 2012 at 10:56 am
  • Current Environment: Oracle RH 5 New Environment: Oracle RH 5 We are migrating from one data center to another, all new equipment and the latest Oracle 11gR2 database. To ...
    Bill ZakrzewskiBill Zakrzewski
    May 31, 2012 at 5:42 pm
    Jun 9, 2012 at 4:03 pm
  • List, We're seeing some discussions in our organization around the SAP Database offering Hana. I'm interested to hear your thoughts on this Do you think this product will gain any traction? Do you ...
    Art VandelayArt Vandelay
    May 17, 2012 at 3:38 am
    May 19, 2012 at 3:26 am
  • All, Has anyone else had problems logging in. Apologies if someone has already posted this but I have missed it if that was the case. Every time I try to login, it tells me I need to update my ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    May 17, 2012 at 1:57 pm
    May 18, 2012 at 4:34 pm
  • Hello, We're building a new environment with Rac 11g. We also plan to install grid control, version 12. Anyone have any experience, gotchas with GC 12 that they can share ? thanks ed lewis -- ...
    Ed lewisEd lewis
    May 10, 2012 at 9:20 pm
    May 15, 2012 at 12:02 am
  • I work with more and more developers with this or a similar idea. I read somewhere, sometime about those who are unfamiliar with history...something..something...destined to repeat it... :) Chris ...
    Taylor, Chris DavidTaylor, Chris David
    May 15, 2012 at 7:48 pm
    May 18, 2012 at 3:30 pm
  • I'm not taking sides, but probably worth a read. http://www.oracle.com/itanium -- Regards, Greg Rahn | blog <http://bit.ly/u9N0i8 | twitter <http://bit.ly/v733dJ | linkedin <http://linkd.in/gregrahn ...
    Greg RahnGreg Rahn
    May 17, 2012 at 5:23 am
    May 17, 2012 at 1:29 pm
  • Hi, Anyone out there had any experience installing and configuring this. We have a project beginning shortly and Golden Gate is a client requirement and I have never touched it before. I will do some ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    May 15, 2012 at 11:26 am
    May 17, 2012 at 8:32 am
  • http://www.oracle.com/technetwork/topics/security/alert-cve-2012-1675-1608180.html -- http://www.freelists.org/webpage/oracle-l
    Ray StellRay Stell
    May 1, 2012 at 3:24 pm
    May 1, 2012 at 5:46 pm
  • Morning folks. This shouldn't be difficult, but as usual, it is. Creating a link between an Oracle DB and a Sql server DB. 1) I setup the System DSN and tested it. Works 2) Modified the TNSNAMES.ORA ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    May 1, 2012 at 3:02 pm
    May 1, 2012 at 5:14 pm
  • Can someone help in explaining as what will be difference in using Scan Listener vs its associated 3 IP to the JDBC Thin Driver Connection strings. Client Jdbc drivers are 11g R2 Driver. What need to ...
    Sanjay MishraSanjay Mishra
    May 24, 2012 at 9:41 pm
    Aug 4, 2012 at 12:36 am
  • Hello All, I'd like to quantifying large page (16mb) Memory Savings with Oracle 10gR2 ( running on aix 6.1 like this test below ...
    Thiago MacielThiago Maciel
    May 22, 2012 at 3:48 pm
    May 23, 2012 at 2:38 am
  • All, Looking at an issue with a particular sql query which runs fine on other customer sites but one customer is having a problem with it. On most customer sites when it joins to a particular table ...
    Fred TillyFred Tilly
    May 12, 2012 at 4:33 pm
    May 12, 2012 at 10:39 pm
  • I thought I'd ask before I do advertize for one. Thank you. -- http://www.freelists.org/webpage/oracle-l
    May 9, 2012 at 2:32 pm
    May 9, 2012 at 4:20 pm
  • Hi all, does anybody know how ADVM volume metadata is supposed to be backed up? I mean, today we intentionally corrupted our test RAC env, I executed several dd if=/dev/zero of=/path/to/partition ...
    Radoulov, DimitreRadoulov, Dimitre
    May 8, 2012 at 7:11 pm
    May 9, 2012 at 3:24 pm
  • Hey all, My next EM issue is that the console times out after about 10 minutes. The webpage goes "grayish" and depending what page I was on, sometimes there's a single small "bang" in a ...
    Rich JesseRich Jesse
    May 2, 2012 at 7:22 pm
    May 8, 2012 at 5:26 pm
  • We don't use RAC but we do use CMAN for most connections (with Oracle instances ranging from to CMAN's not a product I understand very well. Q1) Will the fixes mentioned in MOS ID ...
    May 7, 2012 at 3:02 pm
    May 8, 2012 at 5:16 pm
  • Hi Friends, I am getting an error when creating a materialized view: ORA-12054: cannot set the ON COMMIT refresh attribute for the materialized view The schema has the following sys privs. CREATE ...
    Eriovaldo AndriettaEriovaldo Andrietta
    May 4, 2012 at 12:01 am
    May 4, 2012 at 1:01 pm
  • of the 3 DNS servers for this client databases. This caused very long wait times where some people thought the listener was hung and or the databases were down. Listener and databases never were ...
    Wolfson Larry - lwolfsWolfson Larry - lwolfs
    May 23, 2012 at 8:30 pm
    May 24, 2012 at 9:57 pm
  • Hi lists According to MOS document id 1393363.1, if scnhealthcheck.sql result is "C - SCN Headroom is low", then “apply the latest recommended patches right now“, this is exactly we used to ...
    May 22, 2012 at 8:08 am
    May 22, 2012 at 9:02 am
  • Gurus, Good Morning. We had two node RAC instance on 11g Rel 2 ( Last Saturday we had some maintenance which involved the restart of the Instance including ASM instance. There is no Change ...
    M MudhalvanM Mudhalvan
    May 21, 2012 at 8:59 am
    May 22, 2012 at 12:49 am
  • Guys/Gals (specifically in the U.S.), I've been with my current company for almost 6 years and I have identified a trend in my own career that at about 5 years I'm ready to move on to something new ...
    Taylor, Chris DavidTaylor, Chris David
    May 16, 2012 at 1:06 pm
    May 18, 2012 at 3:37 pm
  • Listers, I am trying to troubleshoot a performance issue in one of our database, then I happened to see this situation. SQL SELECT * FROM (SELECT 2 A.INSTANCE_NUMBER, 3 A.SQL_ID, 4 A.EVENT, 5 ...
    Sreejith S NairSreejith S Nair
    May 14, 2012 at 6:37 am
    May 14, 2012 at 10:00 am
  • List I found a metalink doc for dataguard for 11g: 1075908.1. Is there anything similar in metalink for 10g. I dont see any links at the bottom. OL. -- http://www.freelists.org/webpage/oracle-l
    Orlando LOrlando L
    May 8, 2012 at 5:36 pm
    May 8, 2012 at 9:35 pm
  • Hi all, env: 2 node RAC on RHEL 5.7 Following note 1340831.1, I installed the patch for bug 12880299 and I noticed that the remote node was patched during the installation of the patch on ...
    Radoulov, DimitreRadoulov, Dimitre
    May 8, 2012 at 1:02 pm
    May 8, 2012 at 6:52 pm
  • Received this from O'Reilly -- Stephane Faroult RoughSea Ltd <http://www.roughsea.com Konagora <http://www.konagora.com RoughSea Channel on Youtube <http://www.youtube.com/user/roughsealtd -- ...
    Stephane FaroultStephane Faroult
    May 3, 2012 at 6:17 pm
    May 3, 2012 at 7:30 pm
  • Today we had a major data corruption happen from a user process and had to roll back production to before the process happened. What I thought I did was this: 1. Copy Prod to Test as of the point in ...
    Steve WalesSteve Wales
    May 3, 2012 at 1:12 am
    May 3, 2012 at 6:34 am
Group Navigation
period‹ prev | May 2012 | next ›
Group Overview
grouporacle-l @

165 users for May 2012

Rjamya: 21 posts Radoulov, Dimitre: 15 posts Taylor, Chris David: 14 posts Joel Patterson: 12 posts Martin Berger: 12 posts Niall Litchfield: 11 posts Nuno Souto: 11 posts Dba DBA: 9 posts Gerry Miller: 9 posts Allen, Brandon: 8 posts CRISLER, JON A: 8 posts Jared Still: 8 posts GG: 7 posts Guillermo Alan Bort: 7 posts Mark W. Farnham: 7 posts Michael Dinh: 7 posts Norman Dunbar: 7 posts Peter Sharman: 7 posts Purav Chovatia: 7 posts David Fitzjarrell: 6 posts
show more