FAQ

Oracle > oracle-l > February 2013

Search Discussions

97 discussions - 558 posts

  • I'm curious to know- If your environment uses parallel and if so, how is it configured? (Par parameters and any resource groups that may degrade DOP) What is you PGA set to?� What is your current PGA ...
    Kellyn Pot'vinKellyn Pot'vin
    Feb 19, 2013 at 2:14 am
    Feb 19, 2013 at 11:44 pm
  • Who's going to the Hotsos conference next week? I'll be there. Best week of the year. Finn This e-mail and any attachments are confidential, may contain legal, professional or other privileged ...
    Jorgensen, FinnJorgensen, Finn
    Feb 28, 2013 at 3:15 pm
    Mar 5, 2013 at 9:17 am
  • I'm curious what priority your LMS processes run in? One of our DBAs here has a system that is giving him fits and I was looking at it and it seems [to me] that LMS priority for his clusters is way ...
    Christopher Taylor2Christopher Taylor2
    Feb 27, 2013 at 12:40 am
    Feb 28, 2013 at 5:58 pm
  • I can read and write simple perl script for admin but i don't define myself a perl programmer . A question for you . For searching a DBA in 2013 do you think perl is something usefull nowdays ? I use ...
    pier paolo Brunopier paolo Bruno
    Feb 6, 2013 at 9:37 pm
    Feb 12, 2013 at 4:06 pm
  • I have developers who are able to create indexes thru their application builder. On one table they have 30 indexes. I've often said to them that they are creating too many but I get overruled by ...
    Zelli, BrianZelli, Brian
    Feb 19, 2013 at 4:09 pm
    Feb 21, 2013 at 12:39 am
  • Hey all, In 11.2.0.3.0, we're archiving older data. This first phase will include deleting (archiving) about 4 years of data. Ongoing archiving will then delete the oldest 6 months of data. Since our ...
    Rich JesseRich Jesse
    Feb 1, 2013 at 3:16 pm
    Feb 2, 2013 at 6:04 am
  • Hello We have a SQL is running slow in one of our OLTP applications: SELECT A1.PERSONNUM , A1.FULLNM , A5.PPENDDATEDTM, A2.NAME, SUM(A7.DURATIONSECSQTY/3600) FROM TKCSOWNER.WFCTOTAL A7, ...
    Ram KRam K
    Feb 5, 2013 at 11:52 pm
    Feb 9, 2013 at 2:03 am
  • Howdy, In our 11.2.0.3 production DB, I was looking at v$sysstat, and happened to order the view by VALUE DESC for kicks. The highest number is for the 'logical read bytes from cache' stat and is ...
    Rich JesseRich Jesse
    Feb 12, 2013 at 8:24 pm
    Feb 18, 2013 at 8:52 pm
  • Hello, I wonder if there is any problem to access to https://support.oracle.com Thanks, Wissem -- http://www.freelists.org/webpage/oracle-l
    Wissem elkhlifiWissem elkhlifi
    Feb 12, 2013 at 7:57 am
    Feb 12, 2013 at 11:18 am
  • Env: 10.2.0.4 64bit 3 node RAC on RH Linux 5.6 Question: what is the 2nd argument? [58759497] Situation: - No nightly exports/datapumps - we have nightly RMAN backups. - There is a known Oracle Bug ...
    Christopher Taylor2Christopher Taylor2
    Feb 26, 2013 at 3:41 pm
    Mar 4, 2013 at 9:58 pm
  • I'm on V10 Oracle .on Redhat Linux and slightly perplexed I have installed the 11 software and a test database via the installer but after setting the path and explicity calling the right sqlplus I ...
    Howard LathamHoward Latham
    Feb 7, 2013 at 3:10 pm
    Feb 7, 2013 at 9:25 pm
  • Oracle - EE 11.2.0.2 OS - SUSE11 I have a particularly egregious SQL statement that causes problems in my production OLTP. It's bad enough when only one session is running it, but at times there may ...
    Sandra BeckerSandra Becker
    Feb 4, 2013 at 3:23 pm
    Feb 7, 2013 at 7:51 pm
  • I haven't done anything with ASM disks. Had a consultant come in to do an install on a physical server with it's own set of disks. He was all about that ASM was the way to go and to not use hardware ...
    Mike HayesMike Hayes
    Feb 4, 2013 at 8:38 pm
    Feb 6, 2013 at 6:39 pm
  • has anyone ever used DBCA 11g to configure an EM 12c agent for their database? either during the "create database" stage or by going back to the "configure database options" functionality of DBCA? I ...
    Jeremy SchneiderJeremy Schneider
    Feb 25, 2013 at 11:16 pm
    Mar 1, 2013 at 9:38 pm
  • While creating some sample SQLs for my OCA 11g students, I found what seems to be a bug in 11.2.0.1 Oracle OTN Developer Days VM select employee_id, department_id, department_name from employees ...
    Hemant K ChitaleHemant K Chitale
    Feb 24, 2013 at 3:16 pm
    Feb 24, 2013 at 9:56 pm
  • Hi, Anybody observed, that "opatch auto" first patches the DB home and then the GI Home. Shouldn't it be the other way round? Thanks -- http://www.freelists.org/webpage/oracle-l
    Purav ChovatiaPurav Chovatia
    Feb 13, 2013 at 3:43 pm
    Feb 14, 2013 at 6:47 am
  • Env: 10.2.0.4 RAC 3 Nodes RHEL 5.6 64-bit 10.2.0.4 ASM 3 Nodes RHEL 5.6 64-bit We have our archivelogs stored solely in a diskgroup managed by the ASM instance. We don't write the archivelogs to a ...
    Christopher Taylor2Christopher Taylor2
    Feb 5, 2013 at 1:31 pm
    Feb 5, 2013 at 8:34 pm
  • Hi, Tried this on 10.2.0.4 and 11.1.0.7 I guess I'm not the first to stumble across this. I'm extracting data from an application where some dates are stored free form in varchars (I know. Vendor ...
    Fergal TahenyFergal Taheny
    Feb 21, 2013 at 12:46 pm
    Feb 21, 2013 at 2:18 pm
  • Hi Gurus, I'm writing regarding our prod environment with Oracle 11g (11.2.0.2) on 64-bit AIX 6.1 with storage on IBM XIV devices. The users have been complaining a very poor performance and all ...
    Saad KhanSaad Khan
    Feb 19, 2013 at 5:09 pm
    Feb 20, 2013 at 5:04 am
  • What is everyone's code review process? * Do you review code during development or right before going to QA? * Or do developers come to you and say we need this to go to production right now can you ...
    Jeff ChircoJeff Chirco
    Feb 6, 2013 at 9:39 pm
    Feb 11, 2013 at 1:19 pm
  • I have a question regarding the named user license that I am confused on. If we have a 10 user Standard Edition license is that 10 users for the server or is it 10 user per database running on that ...
    Jeff ChircoJeff Chirco
    Feb 5, 2013 at 9:44 pm
    Feb 6, 2013 at 2:02 pm
  • 11.2 Redhat LInux. I've migrated to 11g . I use email. So I need to set up acls but the XDB portion of the database is invalid and was when it was a 10 db. What would you do? Can XDB be dropped and ...
    Howard LathamHoward Latham
    Feb 28, 2013 at 8:01 pm
    Mar 7, 2013 at 10:32 pm
  • Getting error that fnd_file unable to create a file. From manager log we see: declare * ERROR at line 1: ORA-20100: Error: FND_FILE failure. Unable to create file, l0127129.tmp in the directory, ...
    Jeffrey BeckstromJeffrey Beckstrom
    Feb 28, 2013 at 1:58 pm
    Feb 28, 2013 at 6:57 pm
  • Hi WGB, I've been in your position often and it's not easy. One thing that worked well for me was to use the existing Oracle infrastructure for the new project. Consolidate various applications into ...
    David RobillardDavid Robillard
    Feb 16, 2013 at 3:28 pm
    Feb 28, 2013 at 5:53 pm
  • Positions: Oracle DBA (Several Positions) Location: A major city in Kansas. ("Pack and Move" Relocation Assistance is provided) Salary: $75,000.00 - $105,000.00 depends on experience. No bonus but ...
    OrastaffOrastaff
    Feb 20, 2013 at 3:57 pm
    Feb 22, 2013 at 12:50 am
  • My boss wants a count of the distinct, active users on various production databases since Jan 1. We are running 11.2.0.2 on AIX 6.1. denise -- http://www.freelists.org/webpage/oracle-l
    Denise GwinnDenise Gwinn
    Feb 12, 2013 at 11:44 am
    Feb 13, 2013 at 2:14 pm
  • What specific 11.2 level are you referring to here? Would be most troubled if this is seen on 11.2.0.3.x ( to me anyhow ). Is this with expdp to file and then tables not there trying to impdp later ...
    John HurleyJohn Hurley
    Feb 8, 2013 at 6:42 pm
    Feb 11, 2013 at 7:39 pm
  • We have a company document that says to not use fdisk to partition disks for Oracle. It says to use parted or sfdisk. It says you can't guarantee alignment with fdisk. My best guess is they didn't ...
    Walker, Jed SWalker, Jed S
    Feb 7, 2013 at 2:33 pm
    Feb 7, 2013 at 3:44 pm
  • All, This is a question to the group. If you were to sit in a presentation about Oracle Database 12c, what would you like to see and get out of the presentation? What would you be looking to learn ...
    Bobby CurtisBobby Curtis
    Feb 27, 2013 at 2:40 am
    Mar 3, 2013 at 4:13 am
  • We are seeing wildy varying performance in an Orion run meant to simulate a DW workload (large sequential 1MB reads). The output below seems to be "red flags" all over: a) Wildly varying results, ...
    Tornblad, JohnTornblad, John
    Feb 25, 2013 at 12:35 am
    Feb 28, 2013 at 5:48 pm
  • Hi all, 11.2 on Linux. I have a 300g table with 80k rows that has 3 CLOB columns. Most of the records are similar size - some are very large . Im planning to Partition the table and use store as ...
    OrclOrcl
    Feb 27, 2013 at 12:21 pm
    Feb 28, 2013 at 3:27 am
  • Greetings, I've been asked by our security department if there's a way to overwrite a blob in the database but I don't know of any way to do it. I asked my trusted coworker Google if there was a way ...
    WblanchardWblanchard
    Feb 23, 2013 at 4:38 am
    Feb 26, 2013 at 4:57 pm
  • So, I'm sure everyone on this list understands the costs involved in standing up an Oracle database (especially if you have to factor in EE, DR, DG, etc.). With the economy the way it is an money ...
    WblanchardWblanchard
    Feb 15, 2013 at 8:28 pm
    Feb 19, 2013 at 8:47 pm
  • List, Since most of us use Google to get quick answer, I don't consider this to be off-topic ...
    Dennis WilliamsDennis Williams
    Feb 12, 2013 at 9:35 pm
    Feb 17, 2013 at 11:11 pm
  • Ok, this is a stupid question but for some reason I haven't been able to wrap my head around it. If we license all of the procs on a server, can we throw as many databases on it as we want? What ...
    WblanchardWblanchard
    Feb 5, 2013 at 5:49 pm
    Feb 6, 2013 at 9:46 pm
  • Is there a way to influence [thru manual intervention] which node is preferred for sessions? The reason I ask this question, in this way, is that we have 3 nodes, and node 2 continuously seems to be ...
    Christopher Taylor2Christopher Taylor2
    Feb 2, 2013 at 6:33 pm
    Feb 6, 2013 at 6:46 pm
  • Ok, this question is a little off the path. I teach a dbms class and I want the students to use sqlplus. The school used to provide the download of the client but no longer. I told them to go to the ...
    Zelli, BrianZelli, Brian
    Feb 20, 2013 at 2:17 pm
    Mar 3, 2013 at 4:33 am
  • List, I'm trying to use OEM12cR2 to clone the oracle home of a 9.2.0.8 database but it keeps failing. I have no trouble cloning any 10.2 or 11g oracle homes. The process keeps failing with this ...
    Jorgensen, FinnJorgensen, Finn
    Feb 14, 2013 at 4:41 pm
    Feb 28, 2013 at 8:27 am
  • All, I am observing one of the device doing high i/o . is there a way where i can map to which oracle datafile is on this device . appreciate any suggestions thanks Kart -- ...
    K RK R
    Feb 26, 2013 at 12:57 am
    Feb 27, 2013 at 1:22 pm
  • I'm having a hard time locating on metalink a certification matrix for EL 6 and OCFS2. Does one exist? Looking at oss.oracle.com/projects/ocfs2 documentation it appears to only be supported up to v ...
    Christopher Taylor2Christopher Taylor2
    Feb 21, 2013 at 11:53 pm
    Feb 22, 2013 at 7:15 pm
  • So I've got triggers in the production and test database. A user reported that she can't see the trigger code in test but can in production. There are no grants on the trigger and she only has select ...
    WblanchardWblanchard
    Feb 15, 2013 at 4:08 pm
    Feb 15, 2013 at 4:33 pm
  • Plat REDHAT LInux DB 11.2 My Primary - just upgraded for 10 to 11 cannot connect to the standby on another box. There's something you have to do with the Orapwd file. It is documented but sometimes ...
    Howard LathamHoward Latham
    Feb 14, 2013 at 10:34 am
    Feb 15, 2013 at 2:49 am
  • I need to multiplex my online redolog files. Currently I have only a single member in each group. The question is how do I do this in a Dataguard environment running in Maximum performance mode? Are ...
    Zabair AhmedZabair Ahmed
    Feb 11, 2013 at 3:38 pm
    Feb 11, 2013 at 5:18 pm
  • Positions: Oracle DBA (Several Positions) Location: A major city in Kansas. ("Pack and Move" Relocation Assistance is provided) Salary: $75,000.00 - $110,000.00 depends on experience. No bonus but ...
    OrastaffOrastaff
    Feb 7, 2013 at 6:41 pm
    Feb 11, 2013 at 1:42 pm
  • Hi all, I'm having an issue with a particular sql_id I monitor. It's a pl/sql procedure which is used in pl/sql notification of AQ. Database is EE 10.2.0.5 on Solaris 5.10. For some reason this ...
    Stojan VeselinovskiStojan Veselinovski
    Feb 8, 2013 at 12:11 am
    Feb 8, 2013 at 2:17 pm
  • Hi, list: I have a quick question about UTL_RAW.CAST_TO_VARCHAR2 Database version 11.2.0.2 Database character set UTF8 I set NLS_LANG before using SQLPLUS export NLS_LANG=AMERICAN_AMERICA.UTF8 SQL Â ...
    Lei ZengLei Zeng
    Feb 4, 2013 at 10:27 pm
    Mar 14, 2013 at 7:08 pm
  • Can you audit the other things without auditing SESSION (Logons) ? We have a scenario where we're generating thousands of .aud files per day - and our user population is not very large. I've just ...
    Christopher Taylor2Christopher Taylor2
    Feb 27, 2013 at 7:35 pm
    Feb 28, 2013 at 4:38 pm
  • <user group promotion The theme of the NoCOUG winter conference at the NoCOUG winter conference on Thursday, Feburary 21 at the Oracle conference center in Redwood Shores is that NoSQL and Big Data ...
    Iggy FernandezIggy Fernandez
    Feb 17, 2013 at 6:54 am
    Feb 26, 2013 at 5:21 pm
  • HI: We are seeing kernel memory of the database servers keep increasing and run out of memory. Server is Sun T4 (2 CPU, 128G memory), solaris version is "Oracle Solaris 10 8/11 s10s_u10wos_17b SPARC" ...
    Eagle FanEagle Fan
    Feb 25, 2013 at 2:54 am
    Feb 26, 2013 at 2:41 am
  • After reading through a decent amount of information on Kevin Closson's site, it seems pretty convincing that there is a mismatch between the ability of Exadata's compute nodes to process data at the ...
    Stephens, ChrisStephens, Chris
    Feb 22, 2013 at 8:48 pm
    Feb 23, 2013 at 11:56 am
Feb 2013
12
Group Navigation
period‹ prev | Feb 2013 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions97
posts558
users157
websiteoracle.com

157 users for February 2013

Christopher Taylor2: 51 posts Rjamya: 17 posts Kellyn Pot'vin: 16 posts Hans Forbrich: 15 posts Wblanchard: 14 posts Andrew Kerber: 14 posts Niall Litchfield: 14 posts Rich Jesse: 13 posts Tanel Poder: 13 posts John Hurley: 12 posts Wolfgang Breitling: 12 posts Fergal Taheny: 11 posts Norman Dunbar: 11 posts Herring Dave - dherri: 10 posts Iggy Fernandez: 9 posts Jonathan Lewis: 9 posts Martin Klier: 9 posts Howard Latham: 8 posts Tim Gorman: 8 posts Mark W. Farnham: 7 posts
show more
Archives