FAQ

Oracle > oracle-l > January 2014

Search Discussions

102 discussions - 547 posts

  • Simple question, hopefully I'll get some answers! :) Because if I don't, some security "expert" heads will roll as a result... Who here has database servers, app servers, admin and dev workstations, ...
    Nuno SoutoNuno Souto
    Jan 14, 2014 at 7:52 am
    Jan 22, 2014 at 4:34 pm
  • List, We have a SQL that is being executed few thousand times in an hour. The SQL belongs to an application supplied by a 3rd party vendor. The SQL accesses 500 rows from a million row table every ...
    Ram RamanRam Raman
    Jan 20, 2014 at 11:32 pm
    Feb 8, 2014 at 5:14 am
  • We are looking at training a new DBA from scratch (hiring from within) and I am looking for any opinions on where/how/what to train this person on. I was thinking of starting with just basic SQL and ...
    Jeff CJeff C
    Jan 31, 2014 at 11:12 pm
    Feb 4, 2014 at 4:32 pm
  • On 11.2.0.3 on linux, I'm getting session waits of 16070 days. This equates to 44 years in my math. This smells like the old overflow issue that I remember from days of old. My google fu is not ...
    John D ParkerJohn D Parker
    Jan 7, 2014 at 5:54 pm
    Jan 23, 2014 at 8:39 pm
  • Mainly out of curiosity - for those of you that setup Oracle VMs on personal hardware, which vendor do you prefer and what are the drawbacks (if any) that caused you to go with the one you chose? For ...
    Chris TaylorChris Taylor
    Jan 22, 2014 at 4:13 pm
    Feb 9, 2014 at 7:47 pm
  • What is everybody's favorite tool to monitor Standard Edition 10 and 11g databases? I know statspack is an option but I am looking for more of a gui option. Thanks
    Jeff CJeff C
    Jan 15, 2014 at 4:27 pm
    Jan 20, 2014 at 6:43 pm
  • Has anyone used EMC's SRDF with Oracle RAC 11gR2? Any issues? Does it work with RAC? -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'
    Andrew KerberAndrew Kerber
    Jan 27, 2014 at 8:45 pm
    Jun 1, 2014 at 5:15 am
  • I know about the laptop RAC articles on the web. Does anyone know of any others such as dataguard exercises, recovery exercises, etc... ? I can do them myself, but if people have already written ...
    Dba DBADba DBA
    Jan 9, 2014 at 5:00 pm
    Jan 10, 2014 at 5:43 pm
  • Hi all, We're in a bit of an uncomfortable spot here... We're basically a Windows shop, our DB servers have internet access, and therefore our DB servers have AV software installed. We have ...
    Uzzell, StephanUzzell, Stephan
    Jan 31, 2014 at 5:06 pm
    Feb 4, 2014 at 10:00 am
  • I have Oracle 11.0.1.0 over Windows 2008. Yesterday we had to bounce the instance due to an ora-04031 error caused by the Automatic Memory Management system, the error is solved by patching to ...
    David Ramírez ReyesDavid Ramírez Reyes
    Jan 17, 2014 at 10:43 pm
    Jan 18, 2014 at 6:15 am
  • I am trying to drop the user mdsys and get the following error: * ERROR at line 1: ORA-04098: trigger 'MDSYS.SDO_TOPO_DROP_FTBL' is invalid and failed re-validation How do I get rid of this user? ...
    Zelli, BrianZelli, Brian
    Jan 14, 2014 at 2:06 pm
    Jan 16, 2014 at 6:44 am
  • Some SAs are talking to us about using this instead of doing standard RMAN backups. This is a large data center environment with 1000s of DBs. I really don't know anything about it other than the ...
    Dba DBADba DBA
    Jan 9, 2014 at 6:13 pm
    Jan 16, 2014 at 2:40 am
  • Hi All, For reasons I won't bore you with I need to build an index on a table on a legacy application on a Standard Edition database which has grown like topsy and is now almost 3 billion rows (I ...
    Charlotte HammondCharlotte Hammond
    Jan 31, 2014 at 12:29 pm
    Feb 4, 2014 at 6:48 am
  • I am trying to install Oracle 11.2.0.4 on Redhat Enterprise Linux (6.4). I have no physical access to the console, so I have to run the installer remotely. Here is what I have done: - On my PC ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Jan 30, 2014 at 7:01 pm
    Jan 31, 2014 at 1:45 pm
  • Because it adds complexities and dependencies. Don't get me wrong, when I was a junior the primary job of the intermediates was to manage 200 x 2GB, 15K rpm JBOD. Redo and archive logs had to be on ...
    Dave MorganDave Morgan
    Jan 24, 2014 at 3:13 am
    Jan 27, 2014 at 4:33 pm
  • Hi, I'm trying to write some Haskell code for direct SGA access of - preferredly, as of today - x$ksmsp (sql queries against this table being expensive, possibly...), and for that I'm following the ...
    KeydanaKeydana
    Jan 7, 2014 at 10:34 pm
    Jan 18, 2014 at 7:16 am
  • Ive just been told there's a tool that will do a 'cold backup' of a live database by taking a snapshot of the db at a particular time. The only way I have heard of achieving this is by having ...
    Howard LathamHoward Latham
    Jan 8, 2014 at 11:58 am
    Jan 8, 2014 at 8:12 pm
  • This is not for production. I am doing some practice installs so I can mess with RAC in a lab environment at work. These test servers don't have SCAN IPs and SAs don't have time to set them up. When ...
    Dba DBADba DBA
    Jan 8, 2014 at 9:17 pm
    Mar 19, 2014 at 10:25 am
  • Dear Experts, We are migrating from Oracle (Solaris) 11gR1 to Exadata 11gR2. Considering the two differences 1) Os Solaris Vs Linux 2) Version 11gR1 Vs 11gR2 - What is the best migration method? 1) ...
    Thomas P SThomas P S
    Jan 30, 2014 at 7:24 am
    Jan 31, 2014 at 3:26 pm
  • DB Version: 11.2.0.2 Grid Control: 11g (not sure on exact version) When I look in Grid Control I See 1 SQL as a top SQL State and it says the primary wait is: SQL*Net more data from client I ran the ...
    Dba DBADba DBA
    Jan 16, 2014 at 5:22 pm
    Jan 18, 2014 at 10:37 am
  • Can a OEE 12 db be configured into cloud control and also have this EM Express deal? This text could be taken either way: "Enterprise Manager Database Control is no longer available in Oracle ...
    Ray StellRay Stell
    Jan 8, 2014 at 1:46 pm
    Jan 9, 2014 at 12:34 am
  • Hi I want to know how people are using Oracle On VMWARE especially if they are using them for mission critical application production environment on VMWare. As Oracle says that they will not support ...
    Sanjay MishraSanjay Mishra
    Jan 6, 2014 at 3:09 pm
    Jan 8, 2014 at 7:47 pm
  • This is Oracle 9.2. We have external tables defined to load DAT files the vendor sends us. However, some of the new DAT files have “99999999” or “00000000” in a DATE field inside the DAT file. I ...
    Chris TaylorChris Taylor
    Jan 29, 2014 at 10:34 pm
    Jan 30, 2014 at 4:02 pm
  • Hi All, I have 2 nodes Dataguard Configuration (Physical Standby) in Oracle 11.2.0.3.0 on Oracle Linux 5.8. Now I am planning to add a third node physical standby to this configuration. I have ...
    Sandip MukhopadhyaySandip Mukhopadhyay
    Jan 27, 2014 at 12:37 pm
    Jan 27, 2014 at 6:27 pm
  • I've been working on a two-day seminar and was looking for a good way to introduce the different parts; I have settled for silent film title cards. While working on this, I found a number of old ...
    Stéphane FaroultStéphane Faroult
    Jan 24, 2014 at 8:05 am
    Jan 24, 2014 at 6:05 pm
  • Is there a good way to check, from within the database, whether or not database sessions are utilizing network encryption? I know you can look at the *network_service_banner* column of ...
    Adric NorrisAdric Norris
    Jan 18, 2014 at 2:42 am
    Jan 22, 2014 at 9:08 pm
  • Hi, all I have a table with our product database - a bit over half a million rows and an integer pseudo primary key populated ascending by sequence. This is replicated to another database by a simple ...
    Kim Berg HansenKim Berg Hansen
    Jan 16, 2014 at 9:59 am
    Jan 17, 2014 at 8:25 am
  • I have never used Exadata and neither has anyone on my team. From what I have been reading many of the exadata DBAs have quite a bit of SA knowledge as well. How much SA knowledge is required to ...
    Dba DBADba DBA
    Jan 13, 2014 at 4:28 pm
    Jan 14, 2014 at 6:32 pm
  • Anyone willing to share what they set pga and sga values to for a standby database? We currently have ours set to the same as our primary databases, but are looking at finding what minimum values we ...
    Maureen EnglishMaureen English
    Jan 6, 2014 at 11:36 pm
    Jan 7, 2014 at 8:18 am
  • Hi Is it fine to only apply PSU patch to DB and ignore GI ? I thought ASM should be same or higher version that RDBMS. In one of the existing client, I saw patches are only applied to RDBMS and never ...
    Sanjay MishraSanjay Mishra
    Jan 30, 2014 at 3:14 pm
    Jan 30, 2014 at 7:52 pm
  • (I’m having some confusion, so sorry if this message gets posted 3 times… ) Thank you everyone for responding to my recent question about ITL deadlocks. As an alternative to re-creating my hash ...
    McPeak, MattMcPeak, Matt
    Jan 27, 2014 at 9:47 pm
    Jan 29, 2014 at 7:36 pm
  • Hi, I have a question about the high number of reads on a LOB on a 10.2.0.4.0 64bit instance. The problem I'm facing is that selecting a CLOB column (from nhibernate) causes many reads from the same ...
    Jure BratinaJure Bratina
    Jan 28, 2014 at 7:58 pm
    Jan 29, 2014 at 9:01 am
  • Anyone else having trouble getting into *.oracle.com? I tried metalink, then I tried just oracle.com without success. -- Andrew W. Kerber 'If at first you dont succeed, dont take up skydiving.'
    Andrew KerberAndrew Kerber
    Jan 27, 2014 at 3:24 pm
    Jan 28, 2014 at 6:40 pm
  • Oracle Ver. 11.2.0.3 (RAC)RHEL 5 -x86-64 Dear Listers; I use ADR which is quite helpful but it does not manage certain log files with these the listener and scan_listener logs being the exception ...
    Ndidi IbeachumNdidi Ibeachum
    Jan 17, 2014 at 12:43 pm
    Jan 23, 2014 at 8:55 pm
  • I am hiring an entry to mid level DBA. If you are interested contact me off-list. Thanks for your time, Josh C.
    Josh CollierJosh Collier
    Jan 3, 2014 at 5:34 pm
    Jan 19, 2014 at 12:46 am
  • I'm trying to understand an instruction the following instructions from an application installation guide. It says: If the database is configured for the UTF8 or AL32UTF8 character set ...
    Chris KingChris King
    Jan 16, 2014 at 7:13 pm
    Jan 16, 2014 at 11:05 pm
  • Hi! I wonder if is there a way to have an apple and eat it, i.e. get the display of rows (which is done by feedback on) and yet suppress this very line in the spooled log (which is intended to be a ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Jan 8, 2014 at 9:56 am
    Jan 10, 2014 at 10:38 pm
  • Hello Gurus, If any one worked on oracle compliance using oem 12c please share me your steps to implement. I tried to implement by selecting the compliance standards and then added targets by ...
    Nagaraj SNagaraj S
    Jan 16, 2014 at 6:43 am
    Feb 5, 2014 at 6:50 pm
  • Hi, I am not a newbie when it comes to Oracle SQL, however, I am far from an expert, so I am getting stuck on how to do certain things in queries. Help is appreciated! To get the last transplant date ...
    William ThrelfallWilliam Threlfall
    Jan 29, 2014 at 10:59 pm
    Feb 3, 2014 at 10:17 pm
  • Hi * Does anyone experienced any major issue/bug reported for latest Jan '2014 SPU/PSU on any platform for both GI/RDBMS ? * Is there any Oracle doc which might be updated to help to verify before ...
    Sanjay MishraSanjay Mishra
    Jan 31, 2014 at 2:57 pm
    Jan 31, 2014 at 3:51 pm
  • I am wondering if "alter table shrink space" has any negative impact on Golden Gate replication , or there are any gotchas - concerns beyond the standard docs on shrink space ?
    CRISLER, JON ACRISLER, JON A
    Jan 30, 2014 at 10:05 pm
    Jan 31, 2014 at 2:51 pm
  • We have been given a .dbf file by a sys admin that says that he needs us to be able to recover the data that's in the file. Apparently, there was a problem with the original system that the database ...
    Scott CanaanScott Canaan
    Jan 30, 2014 at 7:13 pm
    Jan 31, 2014 at 3:07 am
  • Hi All, Anyone applied this? I can see Martin had no issues in http://martincarstenbach.wordpress.com/2014/01/15/applying-gi-psu-12-1-0-1-2-in-the-lab/but only after applying 12.1.0.1.1. I've hit the ...
    Stojan VeselinovskiStojan Veselinovski
    Jan 21, 2014 at 10:04 pm
    Jan 30, 2014 at 12:12 am
  • I have a situation where the users like to submit eight (8) copies of an I/O intensive job simultaneously - one job for each of our product lines. The job operates on tables that are not partitioned ...
    McPeak, MattMcPeak, Matt
    Jan 24, 2014 at 7:25 pm
    Jan 24, 2014 at 10:22 pm
  • Hi Listers Does anyone use ASM Normal Redundancy with large LUN such as 1TB? We are considering use 1TB LUN for a 6TB Database but when normal redundancy is used ASM reserves 1 LUN space (distributed ...
    Ls ChengLs Cheng
    Jan 23, 2014 at 12:54 pm
    Jan 23, 2014 at 9:08 pm
  • Hi All, Hope every one is doing great!! I have two questions. 1. we have oracle rman catalog db in which all the prod databases are registered, we cloned the database to a different server and by ...
    Nilesh kumarNilesh kumar
    Jan 22, 2014 at 5:52 pm
    Jan 23, 2014 at 5:21 pm
  • Hi all, Hoping someone can point me in the right direction, or give me some basic reading material here... We have a query that (apparently) used to perform well, but recently runs 10+ minutes (long ...
    Uzzell, StephanUzzell, Stephan
    Jan 21, 2014 at 10:21 pm
    Jan 22, 2014 at 6:55 pm
  • Hello: My understanding is that this seems to be the best combination in the sense that it gives me a full backup (at a point in time) plus have the advantages of incremental backup. In case of ...
    Kumar MadduriKumar Madduri
    Jan 21, 2014 at 10:38 am
    Jan 22, 2014 at 5:53 am
  • Gurus, Oracle 11..2.0.3 on Linux R6 == 1) I have a field with a data type of varchar2 that has integers and non-integer characters. 2) Example: 214’ or 61+45 or 88/8. 3) How can i remove the ...
    BalaBala
    Jan 16, 2014 at 3:39 pm
    Jan 16, 2014 at 4:30 pm
  • I need to know what patches have been applied to a database. In OEM 11g I could do that by going to the target database and selecting "Software and Support" and the "Oracle Home inventory". For the ...
    Keith MooreKeith Moore
    Jan 13, 2014 at 6:45 pm
    Jan 16, 2014 at 2:59 pm
Jan 2014
123
Group Navigation
period‹ prev | Jan 2014 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions102
posts547
users144
websiteoracle.com

144 users for January 2014

Hans Forbrich: 31 posts Jonathan Lewis: 20 posts Chris Taylor: 19 posts Dba DBA: 19 posts Jared Still: 19 posts Nuno Souto: 15 posts Andy Gmail: 14 posts Niall Litchfield: 13 posts Mark W. Farnham: 12 posts David Fitzjarrell: 11 posts Dave Morgan: 10 posts Sanjay Mishra: 10 posts Juan Carlos Reyes Pacheco: 9 posts Uzzell, Stephan: 9 posts Bill thater: 7 posts John D Parker: 7 posts Justin Mungal: 7 posts Ls Cheng: 7 posts Rajesh Aialavajjala: 7 posts David: 6 posts
show more
Archives