Search Discussions

110 discussions - 718 posts

  • Hi all, I'm trying to get direct load insert working. I'm running RAC on Linux x86-64. The table is range partitioned, and has one XMLTYPE column with SECUREFILES BINARY XML storage. I ...
    Bobak, MarkBobak, Mark
    Oct 31, 2011 at 7:09 pm
    Nov 4, 2011 at 8:36 pm
  • I am preparing to deploy Oracle Enterprise Manager Cloud Control 12c in a dev environment. It's a two node cluster with a clustered repository database in and I'm going with the 1-system ...
    Guillermo Alan BortGuillermo Alan Bort
    Oct 17, 2011 at 5:27 pm
    Oct 21, 2011 at 7:49 pm
  • Listers, We have a 10.105 database that was installed as part of the application install. We are unable to log into the database as sys user. The password file is there, it has been recreated etc ...
    Ram RamanRam Raman
    Oct 7, 2011 at 10:53 pm
    Oct 12, 2011 at 12:37 pm
  • Hi We have one environment on Sun Infrastructure where we are planning to move to RAC on 11g. So move is from non-RAC to 4-Node 11g R2 RAC. Database is OLTP, Partitioned Tables/Indexes and Apps is ...
    Sanjay MishraSanjay Mishra
    Oct 12, 2011 at 5:25 pm
    Oct 25, 2011 at 6:15 pm
  • I am curious how many of you grant your developers the 'CREATE DATABASE LINK' privilege in 10g or higher? We have a production read-only account that is setup to provide support for troubleshooting ...
    Taylor, Chris DavidTaylor, Chris David
    Oct 29, 2011 at 3:20 pm
    Nov 1, 2011 at 6:15 pm
  • I am about to approve this comment out on my blog from one of my favorite DBA God's: "Yep, like Cary is saying " 90% of performance tuning is politics". I am paraphrasing. Don't hold me to the exact ...
    Kellyn Pot'vinKellyn Pot'vin
    Oct 26, 2011 at 5:16 pm
    Nov 1, 2011 at 4:46 pm
  • I am working on a nearly 20 year old legacy system. The OLTP peaks at about 100,000 executions/minute and we expect this to continue to increase. When the system first came out, they had to make sure ...
    Dba DBADba DBA
    Oct 19, 2011 at 8:10 pm
    Oct 24, 2011 at 10:59 am
  • Afternoon all, a developer is asking me what the exact function of "LIKE '%%'" in a WHERE clause is. I'm stumped, and cannot find anything on Google or in the Oracle docs. The puzzler is this: There ...
    Dunbar, Norman (Capgemini)Dunbar, Norman (Capgemini)
    Oct 5, 2011 at 2:29 pm
    Oct 13, 2011 at 6:45 am
  • Hello everyone I am running a query which looks like following (running in select a.account_number, a.id, b.* from account a, tmp_account b where b.amount between a.lowest_amount and ...
    Oct 21, 2011 at 5:42 am
    Oct 24, 2011 at 12:15 pm
  • �Hi, Can any one help me get to the bottom of this? We have two Solaris servers one hosting Oracle 10.1 and the other 11.2. The CPU stats on the 11g box are rounded to centiseconds while on 10g they ...
    Gerry MillerGerry Miller
    Oct 21, 2011 at 7:14 am
    Nov 18, 2011 at 12:28 pm
  • Hi List, This is 64-bit on RHEL 5.6 x86_64. There have been no changes to the DB server nor the application servers since 10SEP11 other than normal business. We started to see increased CPU ...
    Oct 25, 2011 at 3:03 pm
    Apr 13, 2012 at 3:45 pm
  • I have a few OBIEE queries that "perform poorly". Apparently, the users are allowed to "insert" a list of values to query for. OBIEE then constructs the query with a large IN LIST. If I move the IN ...
    Chitale, Hemant KrishnaraoChitale, Hemant Krishnarao
    Oct 28, 2011 at 8:50 am
    Oct 31, 2011 at 2:37 pm
  • So, here is the problem. We were given HP DL585G7s with RHEL5.3 installed. I installed RAC. We just found that the DL585G7 is only certified with RHEL5.5 or later. The SA team would rather ...
    Walker, Jed SWalker, Jed S
    Oct 22, 2011 at 7:24 pm
    Oct 27, 2011 at 4:23 pm
  • I was recently adding some enhancements to an in-house, DBA Utility application, which uses numerous sessions to process large numbers of table segments concurrently. While I was doing this, I ...
    Adric NorrisAdric Norris
    Oct 21, 2011 at 4:40 pm
    Oct 27, 2011 at 4:26 pm
  • If anyone's interested ; http://download.oracle.com/docs/cd/NOSQL/html/index.html Hemant K Chitale This email and any attachments are confidential and may also be privileged. If you are not the ...
    Chitale, Hemant KrishnaraoChitale, Hemant Krishnarao
    Oct 19, 2011 at 3:01 am
    Oct 26, 2011 at 7:29 am
  • I'm trying to find out if replication existed in Oracle in any form in versions previous to Oracle 7? Were snapshots introduced in 7, or were they available in earlier versions? I have worked with 6, ...
    Robert FreemanRobert Freeman
    Oct 23, 2011 at 9:18 pm
    Oct 26, 2011 at 4:54 am
  • Hi! I know that Oracle considers VMWare soft-partioning and that if you would go for processor licenses, you need to license in regards to the underlying hardware, not what you assigned to a VM. But ...
    Marcus MönnigMarcus Mönnig
    Oct 19, 2011 at 6:37 pm
    Oct 21, 2011 at 8:57 am
  • Hi I noticed this in 11gR2. The query here does not mean anything, but I just ran it to show the difference. select end_date, kumar, user_name, employee_id, max(end_date) from (select ...
    Kumar MadduriKumar Madduri
    Oct 26, 2011 at 8:57 pm
    Nov 2, 2011 at 9:34 pm
  • Just bought a Christmas Present - A Kindle on looking at it I wondered if it would be possible to put the Entire Oracle doc on it. Anyone tried? -- Howard A. Latham Sent from my Nokia N97 -- ...
    Howard LathamHoward Latham
    Oct 25, 2011 at 2:58 pm
    Oct 26, 2011 at 7:45 pm
  • Hi I have a developer who is keen reading documentation and then uses it to debate. So in 11gR2 documentation, ...
    LS ChengLS Cheng
    Oct 25, 2011 at 8:23 am
    Oct 26, 2011 at 4:21 pm
  • Hi Lister's, i am currently investigating which session consume the most cpu-time per instance. In order to do so i am using the view dba_hist_active_sess_history Tracking down the time spent waiting ...
    Jan-Hendrik BollJan-Hendrik Boll
    Oct 11, 2011 at 9:34 am
    Oct 24, 2011 at 8:09 pm
  • Oracle AIX 6.1 Peoplesoft HCM + ELM We have an existing RAC + GRID cluster built to run Peoplesoft HCM. 2 nodes....active/active. We have been asked to install another Peoplesoft ...
    Daniel HublerDaniel Hubler
    Oct 20, 2011 at 12:13 pm
    Oct 24, 2011 at 6:23 pm
  • All, We have a query that runs slow on a 10g database for certain set of values only. After getting complaints from user, we investigated it. the query was selecting rows from a table with 10 million ...
    Orlando LOrlando L
    Oct 3, 2011 at 11:14 pm
    Oct 4, 2011 at 2:06 pm
  • Hi, Was wondering if anyone had experience of the best (and cheapest) way to do this was ? On Linux with Oracle 11gR2. SQL Server is 2008 I think (maybe 2005) I know we can do it from the other side ...
    Robertson Lee - lerobeRobertson Lee - lerobe
    Oct 27, 2011 at 11:47 am
    Oct 27, 2011 at 12:42 pm
  • So, as part of my upgrade I must move all my client machines (approx 400) from a mixture of 9i and 10i to all of them being on 11g. Anyone have a best practice or best method of doing a mass upgrade? ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Oct 13, 2011 at 12:20 pm
    Oct 25, 2011 at 4:55 pm
  • Hi List, This is 64-bit on RHEL 5.6 x86_64 I believe that ASSM freespace management is (roughly) controlled through PID - ref Tanel Poder's outstanding presentation at ...
    Oct 28, 2011 at 9:41 pm
    Nov 5, 2011 at 4:56 am
  • All, I am thinking of buying a laptop to install virtualbox and install oracle 11gR2 RAC with OEL. What configuration and vendor I should be going for . Looking for any suggestion from the List ...
    K RK R
    Oct 27, 2011 at 6:27 pm
    Oct 29, 2011 at 3:33 am
  • Hello, I've been tasked with generating a CSV file with the contents of a view in an old database as an extra copy before the DB is decommissioned. I've done this in the past for smaller tables or ...
    Steve WalesSteve Wales
    Oct 26, 2011 at 10:00 pm
    Oct 27, 2011 at 11:28 pm
  • Is it possible to have different listeners (different names) listening on the same server/IP and the same port? Will that cause conflict? Each listener has a different set of databases listed under ...
    P DP D
    Oct 11, 2011 at 3:07 pm
    Oct 17, 2011 at 4:52 pm
  • not sure what happened with the attachments Regards Remigiusz -- ------------------------------------------------------------------------------------ Remigiusz Soko³owski ...
    Remigiusz SokołowskiRemigiusz Sokołowski
    Oct 6, 2011 at 8:38 am
    Oct 7, 2011 at 12:46 pm
  • We have recently upgraded one of our Oracle ERP (11i.10.2) systems database from to After the upgrade, we are seeing some odd behavior on a custom job that was working fine prior ...
    Hameed, AmirHameed, Amir
    Oct 5, 2011 at 11:25 pm
    Oct 6, 2011 at 8:00 am
  • Metalink Note: 1189783.1 speaks of out-of-place upgrading and patching. I'm wonder if it might be a good idea to change the oracle home naming conventions to use four or five digits under product ...
    Joel PattersonJoel Patterson
    Oct 28, 2011 at 2:31 pm
    Oct 30, 2011 at 12:47 pm
  • We are having c- files under the ORACLE_HOME/dbs directory on regular basis and these are pretty big to fill up the filesystem. -rw-rw---- 1 oracle oinstall 15564800 May 22 18:08 ...
    Mandal, AshokeMandal, Ashoke
    Oct 18, 2011 at 10:28 pm
    Oct 21, 2011 at 1:30 pm
  • Looks like whole list was very quiet over the weekend, last message I was was Oct 14th .. I dont remember this happening before ... Raj -- http://www.freelists.org/webpage/oracle-l
    Oct 17, 2011 at 12:39 pm
    Oct 19, 2011 at 2:53 am
  • -- http://www.freelists.org/webpage/oracle-l
    Rajendra PandeRajendra Pande
    Oct 13, 2011 at 1:42 pm
    Oct 14, 2011 at 4:59 pm
  • Back to my learning of RAC. Today, it was suggested that we turn on IRQBALANCE on our Oracle 11.2.0 RAC systems to help distribute the IRQ load, to hopefully help with performance. I did a check and ...
    Walker, Jed SWalker, Jed S
    Oct 3, 2011 at 9:30 pm
    Oct 10, 2011 at 2:14 pm
  • According to 11g docs, you can do the below but I'm obviously missing something since I don't know much about AD ...
    Taylor, Chris DavidTaylor, Chris David
    Oct 27, 2011 at 8:03 pm
    Dec 4, 2013 at 4:19 am
  • RHEL 5 SQL desc mv_strain_xml; ERROR: ORA-04043: object mv_strain_xml does not exist SQL select owner, object_type from dba_objects where object_name = 'MV_STRAIN_XML'; OWNER OBJECT_TYPE ...
    Stephens, ChrisStephens, Chris
    Oct 13, 2011 at 2:28 pm
    Oct 22, 2011 at 3:55 pm
  • Anyone have a good way to determine how much data is being sent across database links on a per-object basis? I'm trying to find our biggest offenders and I'm having a hard time trying to track down ...
    Wisniewski, Brian SWisniewski, Brian S
    Oct 19, 2011 at 2:45 am
    Oct 21, 2011 at 7:16 pm
  • Hi I am currently reviweing some batch processes, most of them are INSERT... SELECT, in production environment where flashback is enabled the speed is quite slow compared with QA environment where ...
    LS ChengLS Cheng
    Oct 19, 2011 at 6:22 pm
    Oct 21, 2011 at 5:44 am
  • Hello, I'm looking to hear about any good/bad experiences with connecting an Exadata V2 to a newer X2. I'm particularly keen to hear from anyone who has done this, and what versions of the software ...
    Jason arneilJason arneil
    Oct 19, 2011 at 11:12 am
    Oct 20, 2011 at 5:59 pm
  • I'm sure this comes up every year, but since it's my first time in about 15 yrs for attending OOW, I'm hoping you'll be easy on me. Does anyone know if there are limitations on us sharing OOW ...
    Herring Dave - dherriHerring Dave - dherri
    Oct 11, 2011 at 6:25 pm
    Oct 11, 2011 at 10:12 pm
  • Has anyone seen drawbacks of setting �_clusterwide_global_transactions� = false in 11202 cluster? We don't use XA much but do see lots of 'dfs lock handle' waits. We already checked doc 1361615.1 but ...
    Oct 5, 2011 at 8:04 pm
    Oct 10, 2011 at 1:17 am
  • We have a RAC database that I'm currently building a new RAC for. We will migrate to it one schema at a time using Data Pump. The current database has dictionary managed ...
    Walker, Jed SWalker, Jed S
    Oct 4, 2011 at 9:17 pm
    Oct 5, 2011 at 3:09 pm
  • Hello all, If a server is running multiple databases (ranges from to 10.2). Is there a way to estimate the CPU capacity that are used by each of the database which will relate to the OS ...
    Upendra NUpendra N
    Oct 13, 2011 at 9:12 pm
    Jan 28, 2012 at 11:02 pm
  • Hi, community, I need to salvage some data after SYSAUX tablespace was offline due to disk controller problem. Unfortunately RMAN backup is not good, can backup all datafile except the 'sysaux' ...
    Flora DengFlora Deng
    Oct 26, 2011 at 7:38 pm
    Nov 2, 2011 at 3:02 pm
  • Hi Does anyone know if simply have the RDBMS server software installed but no database running requires a license? I dont think so since Oracle LMS scripts runs againsta database Any thoughts? Thanks ...
    LS ChengLS Cheng
    Oct 28, 2011 at 5:27 am
    Nov 1, 2011 at 7:35 am
  • Hi In sqlplus when we divide if the result is less than 1, for example 0.5 we see this: SQL select 1 /2 from dual; 1/2 ---------- .5 Is it possible to get 0.5 without using to_char()? I am fine ...
    Oct 17, 2011 at 4:13 pm
    Oct 17, 2011 at 4:56 pm
  • Okay, I'm slogging through documentation to try to help our developer. My las of SQL server knowledge is hindering me. He's trying to run linked server connection on a test box to an oracle ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Oct 14, 2011 at 2:40 pm
    Oct 14, 2011 at 5:03 pm
  • I hope this is okay usage of oracle-l. I want to start up an Oracle Profressionals' circle in google+. Comment in this post to be added and I'll share the circle. I've seen how powerful this is for ...
    Shaun BattertonShaun Batterton
    Oct 4, 2011 at 4:16 am
    Oct 13, 2011 at 8:23 am
Group Navigation
period‹ prev | Oct 2011 | next ›
Group Overview
grouporacle-l @

195 users for October 2011

Taylor, Chris David: 28 posts David Fitzjarrell: 21 posts Sidney Chen: 19 posts Subodh Deshpande: 19 posts Kellyn Pot'vin: 18 posts Joel Patterson: 17 posts Bobak, Mark: 16 posts Sanjay Mishra: 16 posts Chitale, Hemant Krishnarao: 14 posts Niall Litchfield: 14 posts LS Cheng: 13 posts D'Hooge Freek: 12 posts Dunbar, Norman (Capgemini): 12 posts Mark W. Farnham: 12 posts Greg Rahn: 11 posts Tim Gorman: 10 posts Laimutis Nedzinskas: 9 posts Guillermo Alan Bort: 9 posts Peter Sharman: 9 posts Robert Freeman: 9 posts
show more