Search Discussions

66 discussions - 404 posts

  • A repository adds complexity and an unnecessary dependence. In a disaster I now have to recover 2 databases which requires more resources and effort than recovering a single db. Having said that, ...
    Dave MorganDave Morgan
    Dec 8, 2013 at 3:04 am
    Dec 20, 2013 at 5:29 pm
  • I know its only 15 bucks(and I can get couple of them) but are there any must have books that we shouldn't miss out on. Any suggestions? From: Rich Jesse Sent: 12/2/2013 10:16 AM To: <span ...
    Max scalfMax scalf
    Dec 2, 2013 at 4:40 pm
    Dec 4, 2013 at 2:46 pm
  • Listers, Looking at buying a new laptop, and intend to use Oracle's VM and Linux to mimic various production scenarios, playing with things like RAC, Data Guard, Golden Gate, OEM 12c, etc. There was ...
    Larry ElkinsLarry Elkins
    Dec 20, 2013 at 6:59 pm
    Feb 13, 2014 at 12:21 pm
  • Here are the results of the survey I had taken: Q1. What Linux vendors do you currently use? Answer Choices – Responses – – SUSE/SLES 8.33% 6 – Redhat 66.67% 48 – Oracle 45.83% 33 Q2. Would you ...
    Jeffrey BeckstromJeffrey Beckstrom
    Dec 3, 2013 at 2:20 pm
    Jan 20, 2014 at 7:48 pm
  • Dear Gurus; I have a problem I stumbled upon and I am hoping you can direct me on a fix even though this is a Linux question and sort of trivial. The Environment is Oracle Enterprise Linux 6 ...
    Ndidi IbeachumNdidi Ibeachum
    Dec 20, 2013 at 11:31 am
    Dec 23, 2013 at 10:22 am
  • I thought this would be easy but I'm not figuring it out nor am I able to find it in all my searching. I want to create a directory for the current directory. I want to do this programmatically in ...
    Ric Van DykeRic Van Dyke
    Dec 18, 2013 at 8:49 pm
    Dec 19, 2013 at 1:08 am
  • Hello List, I had a question that i am not able to find an answer on. oracle (NO RECOVER CATALOG) Lets say I run the below backup...and let say i keep that backup for sysdate+365. Now 10 ...
    Max scalfMax scalf
    Dec 6, 2013 at 5:55 pm
    Dec 9, 2013 at 11:07 pm
  • I've always told people to avoid this like the plague but I'm now on a call with a developer who says Oracle in general and Tom Kyte specifically have changed their position on this and they now ...
    Jay MillerJay Miller
    Dec 18, 2013 at 3:54 pm
    Dec 24, 2013 at 2:34 am
  • All, Is there anyone other than myself that doesn't think this is right. For those of you who have missed it, like I did, when Oracle started evolving Fine Grained Access Controls (FGA) the role of ...
    Dick GouletDick Goulet
    Dec 11, 2013 at 11:26 pm
    Dec 21, 2013 at 10:45 am
  • Please forward me following 2 quires. Thanks in advance. *Q1: Given the following table of transactions in a cash register:* id| trade_time | amount -- ---------------- ------ 1| 06/16/2013 11:43| ...
    Arif GulzarArif Gulzar
    Dec 18, 2013 at 8:47 pm
    Dec 19, 2013 at 10:14 pm
  • Merry Christmas (to those of you who celebrate), Happy Holidays (to those who may not but have something going on - including New Year's), and Good Afternoon: We are currently running a 3-node RAC on ...
    David BarbourDavid Barbour
    Dec 26, 2013 at 7:23 pm
    Jan 2, 2014 at 5:07 pm
  • Hi Friends, I have doubts about the next_change# column from v$archived_log. This is my query and its corresponding output: SQL select sequence#,first_change#,first_time,next_change#,next_time from ...
    Nassyam BashaNassyam Basha
    Dec 29, 2013 at 4:35 pm
    Dec 31, 2013 at 7:19 pm
  • We're architecting a new system, and will need 99.5% availability. Looking over Oracle's MAA options, I see RAC with Data Guard. .. but it's not clear to me how this would actually work to avoid ALL ...
    Chris KingChris King
    Dec 23, 2013 at 2:40 pm
    Dec 23, 2013 at 9:21 pm
  • Hello list, I have a strange problem when trying to create a job using the DBMS_SCHEDULER package: I verified that the job name does not exists using the following statements: (All the following ...
    Thomas KellererThomas Kellerer
    Dec 16, 2013 at 11:11 am
    Dec 16, 2013 at 3:53 pm
  • Hi Can anyone share the doc/reference for doing DR exercise for 4-node Primary RAC (11g R2) on 2-node DR RAC ? We have 4-Node Oracle 11g R2 RAC with 8 Databases using ASM based OCR/Voting and ...
    Sanjay MishraSanjay Mishra
    Dec 12, 2013 at 6:22 pm
    Dec 12, 2013 at 9:09 pm
  • Dear Gurus, I need to get ASM disk group space usage information across 200+ servers. We need this report for capacity planning analysis. Instead of logging to each individual server is there any way ...
    Nagaraj SNagaraj S
    Dec 11, 2013 at 9:27 am
    Dec 12, 2013 at 3:44 pm
  • I'm curious what's everybody's opinion on the best collection of scripts. I know that lots of DBAs have their own personal/private collection but I'm talking about collections that have been posted ...
    Jeremy SchneiderJeremy Schneider
    Dec 11, 2013 at 4:20 pm
    Dec 11, 2013 at 11:36 pm
  • Hi I am trying to influence the execution plan of a query using hints. Oracle enterprise edition Tables are heap and indexes are all b-tree. select * from oprid_sec a, emp_app_sec b where ...
    Paul HoughtonPaul Houghton
    Dec 2, 2013 at 6:26 pm
    Dec 6, 2013 at 10:27 am
  • Running 11gr3 EE. Is there a view where I can see when an index was made invisible? -- Sandy GHX
    Sandra BeckerSandra Becker
    Dec 23, 2013 at 5:27 pm
    Dec 23, 2013 at 9:41 pm
  • Hey all, Recently in our EM12c (, I started getting "The page has been idle for a while. Click OK to reload page." timeouts every 15-20 minutes on a Performance Home page of an Oracle DB ...
    Rich JesseRich Jesse
    Dec 16, 2013 at 7:36 pm
    Dec 17, 2013 at 5:51 pm
  • Hi List, In case if you are not aware, Oracle has announced its Exadata x4 and here is the link to changes in the latest offering ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Dec 12, 2013 at 7:29 am
    Dec 19, 2013 at 8:04 am
  • I get a popup that tells me I can download a newer version of TOAD. When I go to the website there is a 32bit or 64bit version. How do I know which to download? Brian This email message may contain ...
    Zelli, BrianZelli, Brian
    Dec 18, 2013 at 5:37 pm
    Dec 18, 2013 at 7:41 pm
  • Lists, When we're creating a table using CTAS with parallel clause, we observed the parallel slave sessions are blocking each other. We are using this temp. table for the report purpose and before ...
    Prabhu KrishnaswamyPrabhu Krishnaswamy
    Dec 12, 2013 at 6:10 pm
    Dec 17, 2013 at 8:31 pm
  • How do you tell Oracle Standard Edition from Oracle Standard One Edition? This is what I get from select * from v$version; BANNER ...
    Blake WilsonBlake Wilson
    Dec 13, 2013 at 4:53 pm
    Dec 13, 2013 at 5:09 pm
  • Hello All, I was a very active member of the list 12-15 years ago, as a result I see many names from that time. If you were at OracleWorld in 2000 please drop me an email off list, I will try and put ...
    Dave MorganDave Morgan
    Dec 12, 2013 at 5:00 pm
    Dec 12, 2013 at 7:50 pm
  • My client has a production database that is hitting 150-160 redo log switches PER HOUR during the hours of 1-3 am. This is database that is loaded thru an nightly ETL process where tables are ...
    Chris TaylorChris Taylor
    Dec 9, 2013 at 5:36 pm
    Dec 10, 2013 at 9:49 am
  • RAC on Oracle Linux 6 Yesterday I was asked how to handle the following: The developers are frantically working to debug a number of issues with a nightly batch process that frequently fails ...
    Stephens, ChrisStephens, Chris
    Dec 3, 2013 at 7:03 pm
    Dec 3, 2013 at 11:19 pm
  • Oracle: 11gR2 EE OS: SunOS 5.10 Generic_148888-01 (64 bit)<http://ptcgrid.ghx.com:4889/em/console/ecm/track/hc/view/osGeneral$target=pcntrcts.ghx.com$type=host?event=doLoad Access control lists were ...
    Sandra BeckerSandra Becker
    Dec 30, 2013 at 4:15 pm
    Jan 10, 2014 at 10:36 pm
  • Oracle RAC on Linux with two instances prod1 and prod2 When one instance is open, the second instance takes 40 minutes to open from the mount stage. When both instances are open, queries ...
    Nadeem M. KhanNadeem M. Khan
    Dec 9, 2013 at 5:58 pm
    Jan 6, 2014 at 7:35 pm
  • Good afternoon. Oracle Currently on ASM but looking to migrate to the Oracle ZFSSA. The big selling point of the ZFSSA was the ARC and L2ARC caches backed by DRAM and flash. However we want ...
    Don SeilerDon Seiler
    Dec 5, 2013 at 9:59 pm
    Dec 6, 2013 at 7:00 pm
  • My last SR update: --- I am starting to wonder if I am the only person on the planet running EM with Provisioning Pack on AIX. Is this an error Oracle hasn't seen before? --- Basically, EM11g can ...
    Patrice sur GMailPatrice sur GMail
    Dec 3, 2013 at 2:30 pm
    Dec 4, 2013 at 2:44 pm
  • Hi all Has anyone migrated to Oracle Sparc T5 and running in LDOM (Oracle VM for Sparc) and noticed any performance problems? We have migrated a few database from Sun Sparc M9000 to the new T5's and ...
    Ls ChengLs Cheng
    Dec 5, 2013 at 1:20 pm
    Jan 20, 2014 at 12:34 pm
  • Hi Do we know any best way to check if a particular MV's is been used in last couple of days. I know that we can enable monitoring on Table level to check it but look like this is not valid for ...
    Sanjay MishraSanjay Mishra
    Dec 23, 2013 at 9:47 pm
    Jan 14, 2014 at 10:24 am
  • Hi all, We're trying to install OEM Cloud Control on a Sparc Solaris 11.1 server, with Oracle RDBMS The installation process failed at the OMS Configuration step, 59% completed ...
    Lou AvramiLou Avrami
    Dec 30, 2013 at 7:51 am
    Jan 2, 2014 at 7:14 pm
  • Greetings, I have upgraded a database from Oracle to Oracle on Sun Solaris. The RMAN backup was working fine using Netbackup (version: NetBackup-Solaris10 6.5.5) but it started ...
    Mandal, AshokeMandal, Ashoke
    Dec 27, 2013 at 6:26 am
    Dec 29, 2013 at 4:21 am
  • Some levity to the day. Noticed a kernel message just after taking a VM snapshot of REHL image: Message from syslogd... kernel:Dazed and confused, but trying to continue This is now my favorite error ...
    Mohammed bhattiMohammed bhatti
    Dec 18, 2013 at 9:32 pm
    Dec 19, 2013 at 5:42 pm
  • Hi I am redesigning a backup to use RMAN. This database has lob columns. I am trying to determine if there is any optimization that can be done from a backup and recovery point of view (when using ...
    Kumar MadduriKumar Madduri
    Dec 16, 2013 at 2:08 pm
    Dec 19, 2013 at 12:13 pm
  • Hi Sanjay I use cloning to install RDBMS binaries and it's pretty straight-forward. Create a zip archive of the source ORACLE_HOME, extract it on the target, run clone.pl from target ...
    Austin HackettAustin Hackett
    Dec 14, 2013 at 1:19 pm
    Dec 16, 2013 at 12:45 am
  • My sysadmin verifies that all of a sudden 13Gbs of free space was lost overnight. (and we have narrowed down the file). The database is and the datafiles autoextend at 10Mbs ( ...
    Patterson, JoelPatterson, Joel
    Dec 11, 2013 at 2:50 pm
    Dec 11, 2013 at 7:13 pm
  • We're getting started on Solaris 11 and using zones and I'm not familiar with installing Oracle inside a zone. Is a zone basically a standard solaris installation running "virtualized"? In other ...
    Chris TaylorChris Taylor
    Dec 4, 2013 at 11:29 pm
    Dec 9, 2013 at 5:49 am
  • Hey all, I'm expecting to get dinged on an audit because I have FAILED_LOGIN_ATTEMPTS set to 10 in a profile (, if that matters). On our new DBs, I plan on changing that to UNLIMITED. The ...
    Rich JesseRich Jesse
    Dec 6, 2013 at 3:08 pm
    Dec 6, 2013 at 6:59 pm
  • Hi all, This question is on behalf of our sys admin. He has a question that we are unable to answer it. Hope someone might know it. Is it possible to remove entries such as these: export ...
    Hsieh, JoanHsieh, Joan
    Dec 18, 2013 at 6:31 pm
    Dec 18, 2013 at 7:02 pm
  • I am looking for DBA’s opinions on Microsoft Entity Framework. It lets the developers write programs that interact with the database with out having to write any database code, the framework does it ...
    Dec 18, 2013 at 7:05 am
    Dec 18, 2013 at 11:26 am
  • Hello list, Long time listener, first time caller. I've got Oracle up and running in an OEL VM. I'd like to get the admin scripts in my local $ORACLE_HOME so I don't have to ssh into the VM every ...
    Jeremiah PeschkaJeremiah Peschka
    Dec 17, 2013 at 12:58 am
    Dec 17, 2013 at 1:39 pm
  • Ok, I'm feeling stupid as I don't have much experience with timestamp columns with timezones. I'm looking at SYS.AUD$ and I'm really confused. Here's what I'm selecting as I try to understand: select ...
    Chris TaylorChris Taylor
    Dec 11, 2013 at 6:05 pm
    Dec 11, 2013 at 8:05 pm
  • I have recently installed 12c EM and I am working on the alerts and I have noticed that I am getting 2 alerts when a database goes down. 1 for the target is down and another for the target is ...
    Dec 8, 2013 at 8:32 pm
    Dec 9, 2013 at 4:57 am
  • I would love to do that and I have suggested that to management and they said they do not budget to stand up another server/db. Is it extra license to have the catalog or can I just go ahead and ...
    Max scalfMax scalf
    Dec 6, 2013 at 11:31 pm
    Dec 7, 2013 at 9:35 pm
  • Are ou STILL lookng for a gift for that Oracle DBA on your list? Register him or her for RMOUG Training Days in Denver! http://lnkd.in/dhUpr6i Tom Kyte, among others, will be there and it will be the ...
    David FitzjarrellDavid Fitzjarrell
    Dec 5, 2013 at 8:14 pm
    Dec 5, 2013 at 8:48 pm
  • Ahh, the joys of digest mode and holidays together I believe this is the wrong metric to use. As others have pointed out it is equivalent to ~40hours/year. The correct question is what is the longest ...
    Dave MorganDave Morgan
    Dec 30, 2013 at 7:16 pm
    Jan 2, 2014 at 3:56 pm
  • Today is Oracle day (for about another 6 hours if my timezones are correct! http://extras.apress.com/12DaysofTeach_11.html -- Niall Litchfield Oracle DBA http://www.orawin.info
    Niall LitchfieldNiall Litchfield
    Dec 30, 2013 at 11:04 pm
    Dec 31, 2013 at 5:42 am
Group Navigation
period‹ prev | Dec 2013 | next ›
Group Overview
grouporacle-l @

128 users for December 2013

Radoulov, Dimitre: 20 posts Rich Jesse: 15 posts Don Seiler: 13 posts David Fitzjarrell: 12 posts Jared Still: 11 posts Max scalf: 11 posts Chris Taylor: 10 posts Mark Bobak: 10 posts Mark W. Farnham: 10 posts Jonathan Lewis: 9 posts Nassyam Basha: 9 posts D'Hooge Freek: 8 posts Niall Litchfield: 8 posts Tim Gorman: 8 posts Dave Morgan: 7 posts Hans Forbrich: 7 posts Justin Mungal: 6 posts Ndidi Ibeachum: 6 posts Paresh Yadav: 6 posts Ric Van Dyke: 6 posts
show more