FAQ

Search Discussions

84 discussions - 165 posts

  • The coordinator should not be doing writes, assuming you are using PDML? Are you? alter session enable parallel dml; If you are seeing waits on block 2 then the issue is space allocation - your ...
    Greg RahnGreg Rahn
    Apr 10, 2010 at 3:03 am
    May 3, 2010 at 2:41 am
  • Anyone else noticed that over the last year it has taken longer and longer to get responses from support? I have also had multiple tickets where if I do not call in, I never get a response. I have ...
    Dba DBADba DBA
    Apr 19, 2010 at 1:14 pm
    Apr 20, 2010 at 2:15 am
  • We have about 600-700 Oracle VMs running on VMware ESX with RHEL 4/5, SLES, and Windows. They're not really production, since we're a software development shop, but we use them pretty regularly. We ...
    Matthew ZitoMatthew Zito
    Apr 14, 2010 at 3:14 pm
    Apr 17, 2010 at 12:34 pm
  • I saw a big database today with an SGA size of 56GB and a shared pool of 12Gb. The SGA_TARGET was set to 0. This database size is a few terabytes. I have not heard of such big SGA or SP sizes. I ...
    Ram RamanRam Raman
    Apr 16, 2010 at 1:55 am
    Apr 20, 2010 at 2:57 am
  • Hello everyone, I am new to this virtualization world. I want to get more information about this. I always thought that Virtualization software needs a base OS to run on. Once you have the ...
    Dd yakkaliDd yakkali
    Apr 30, 2010 at 9:11 pm
    May 1, 2010 at 9:27 am
  • The i386 version of the libXp package is missing. Please check: # rpm -qa --queryformat "%{NAME}-%{VERSION}-%{RELEASE} (%{ARCH})\n" libXp Then Install the package libXp by the command: # rpm -ivh ...
    Surachart OpunSurachart Opun
    Apr 30, 2010 at 3:47 pm
    Apr 30, 2010 at 5:30 pm
  • Hi Gurus, I've a production database environment 10.2.0.3 on SUSE linux. We have two databases running on the same oracle binaries. On the second database there is a datamart ETL job (Informatica) ...
    Saad KhanSaad Khan
    Apr 16, 2010 at 2:55 am
    Apr 20, 2010 at 2:16 pm
  • I'm not seeing it either. 11.2.0.1 on RHEL 5.4 64-bit. SQL*Plus: Release 11.2.0.1.0 Production on Thu Apr 8 16:51:01 2010 Copyright (c) 1982, 2009, Oracle. All rights reserved. Connected to: Oracle ...
    Scott SibertScott Sibert
    Apr 8, 2010 at 9:56 pm
    Apr 13, 2010 at 1:55 pm
  • Hi list, I'm trying to datapump import a large table across a nework link. To improve performance, I was planning to run multiple impdp processes in parallel, on subsets of the table. The table is ...
    Tom LanyonTom Lanyon
    Apr 24, 2010 at 12:29 am
    Apr 26, 2010 at 3:36 am
  • Dear list, I am just wondering if you can get a better price from oracle sales than oracle online shop ? 39K per core for enterprise edition with almost 10K partition per core is so expensive !!! ...
    Bao jiejieBao jiejie
    Apr 7, 2010 at 4:37 pm
    Apr 19, 2010 at 11:52 am
  • Hi dear listers, I have a very strange performance issue which I couldn't figure it out. I have 2 11.2.0.1 databases with the exactly same parameters, they both on the same server. One sql statement ...
    Joan HsiehJoan Hsieh
    Apr 13, 2010 at 2:54 pm
    Apr 14, 2010 at 5:50 am
  • Has any one bought on this db appliance? Some one was saying a query taking 14 hours or so takes only a few minutes.I understand the hybrid columnar compression for whse workloads, from an OLTP stand ...
    Dd yakkaliDd yakkali
    Apr 24, 2010 at 1:34 am
    Apr 28, 2010 at 12:57 am
  • Hi, expdp und dbms_metadata jumps into my mind. expdp knows a parameter named exclude and include where you can specify what kind of data should be exported. You should be able to transport the ...
    Jost,Jost,
    Apr 21, 2010 at 2:36 pm
    Apr 22, 2010 at 12:55 pm
  • Hi Database 1 is on 11.1.0.7.2 SQL explain plan for 2 SELECT * 3 FROM pa_expenditure_items_all 4 WHERE system_linkage_function = 'VI' AND cost_distributed_flag = 'N'; Explained. SQL SELECT * FROM ...
    Kumar MadduriKumar Madduri
    Apr 20, 2010 at 9:49 am
    Apr 20, 2010 at 6:14 pm
  • We have an application that is suddenly doing a lot of parsing. The history behind this is that about 2 years ago the database was upgraded from 8i to 10g at which point performance went down hill ...
    Joe A-CJoe A-C
    Apr 9, 2010 at 1:40 am
    Apr 9, 2010 at 7:14 pm
  • Ugh, it's 9:15pm, and I'm just now heading home, so, brain is a bit fried. First, I don't suppose you're installing 11gR2 Clusterware? If you are, there's a "SSH Connectivity" button that you click, ...
    Bobak, MarkBobak, Mark
    Apr 8, 2010 at 1:20 am
    Apr 8, 2010 at 7:55 pm
  • I'm really not sure why everyone is responding that this would be an "odd request." We are running a stretch rac with about 4 blocks in between our rac servers, and it's running great. We do have a ...
    Tyfanie WineriterTyfanie Wineriter
    Apr 2, 2010 at 11:29 pm
    Apr 5, 2010 at 7:15 am
  • You need to know where the time difference went - so run the query with the hint /*+ gather_plan_statistics */ to see if the amount of work and the number of "starts" of each line vary significantly ...
    Jonathan LewisJonathan Lewis
    Apr 3, 2010 at 8:11 am
    Apr 4, 2010 at 6:59 am
  • Thanks, Job. I guess I rarely read the portions of the License documentation relating to HTTP server. :-) (But then, since I never really do anything with it, why would I?) The term "restricted use" ...
    Mark BrinsmeadMark Brinsmead
    Apr 26, 2010 at 3:20 am
    Apr 29, 2010 at 1:55 pm
  • Three 1tb databases on 10.2.0.4 from solaris sparc to solaris x86-64. We used expdp/impdp with streams. For data pump we used 15 parallel threads, export took about 2h and import took about 15h to ...
    Ilmar KermIlmar Kerm
    Apr 22, 2010 at 4:15 pm
    Apr 29, 2010 at 1:58 am
  • Hello, I am running a batch job on an oracle 10.2.0.3 database, which locates on a ZFS file system. The job runs very slow. Got the AWR report, it shows following top events. Top 5 Timed Events Avg ...
    GengmaoGengmao
    Apr 26, 2010 at 11:03 am
    Apr 27, 2010 at 3:37 am
  • Hi! Add parameters --user & --password to your wget command and account as your MOS account. Then you will be authenticated and download will begin normally after few redirects. -TL Dear listers, ...
    Teijo LallukkaTeijo Lallukka
    Apr 25, 2010 at 7:35 pm
    Apr 26, 2010 at 3:24 am
  • Hi there, for all of you suffering from bug 8740030 where an "OHASD stop" isn't executed during system restart when using Oracle Restart there are good news. When not stopping a database resource ...
    Martin BachMartin Bach
    Apr 22, 2010 at 3:20 pm
    Apr 24, 2010 at 7:57 pm
  • Jared, Oracle Support recommended downgrading to 11.1.0.7 in fact, so I think that is what we will do. Avadhani, I didn't mean don't go live, just test it thoroughly before you do;-) Scott, on what ...
    Guillermo Alan BortGuillermo Alan Bort
    Apr 22, 2010 at 3:36 pm
    Apr 22, 2010 at 4:15 pm
  • I had to have a bug fix added to the latest oem grid patch for an oem query that ran for hours and we had to kill it several times/day. It took 6 months to get the patch done (not exaggerating). open ...
    Dba DBADba DBA
    Apr 19, 2010 at 2:33 pm
    Apr 19, 2010 at 3:14 pm
  • ... when they don't stop calling you. (gotta stop answering the phone) ... and when "no", and "we cannot afford it even with steep discounts" are not acceptable responses. Oracle: "Can you schedule ...
    Jared StillJared Still
    Apr 13, 2010 at 6:14 pm
    Apr 19, 2010 at 11:46 am
  • Are any of the folks from Oracle-L interested in meeting up on Monday night? I see the "welcome reception" ends at 7:30, so I was thinking perhaps getting together around 7 or 7:30 at Mizuya bar, ...
    Matthew ZitoMatthew Zito
    Apr 16, 2010 at 11:15 pm
    Apr 18, 2010 at 6:20 am
  • List, I'm trying to configure a JDBC connection to a database. Done this successfully many times. This database is built by our corporate team to their standards. I'm wondering if they've done ...
    Dennis WilliamsDennis Williams
    Apr 16, 2010 at 12:35 am
    Apr 16, 2010 at 4:45 am
  • It was 2 or 3 years ago now, but I spent a couple of years working with Spatial for the Ordnance Survey here in the UK. I worked on 10.1 and 10.2 on a project to migrate data from a non-Oracle ...
    Ian CaryIan Cary
    Apr 14, 2010 at 3:51 pm
    Apr 14, 2010 at 4:35 pm
  • You may want to try checking v$session_wait to see what the session is waiting on. Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist Oracle Blog: http://jkstill.blogspot.com Home ...
    Jared StillJared Still
    Apr 12, 2010 at 4:16 pm
    Apr 12, 2010 at 4:53 pm
  • How do I configure a Delphi program so the buffer between the client and the database server will make fewer trips. When working with Java there is something like: fetch array size. How do I change ...
    Yechiel AdarYechiel Adar
    Apr 12, 2010 at 10:50 am
    Apr 12, 2010 at 1:13 pm
  • I've never run backups through Grid Control, so not sure on that, but you might want to check out MOS 73431.1 for general info regarding rman compatibility. My guess would be that Grid Control runs ...
    Allen, BrandonAllen, Brandon
    Apr 9, 2010 at 5:56 pm
    Apr 9, 2010 at 10:38 pm
  • What recommendations you are looking for... Just take the Class.. And dive into the ocean of Streams ... Enjoy !!! -----Original Message----- From: oracle-l-bounce_at_freelists.org On Behalf Of mkb ...
    Pankaj JainPankaj Jain
    Apr 9, 2010 at 5:56 pm
    Apr 9, 2010 at 6:16 pm
  • Just curious if anyone on the list using an alternative to Data Guard? If so, what are you using, and how do you like it? This is mainly for my own personal interest at this point. Thanks, Chris ...
    Taylor, Chris DavidTaylor, Chris David
    Apr 8, 2010 at 3:16 pm
    Apr 8, 2010 at 3:30 pm
  • Hi listers, I have a new requirement that is dictated by the software applications that connect to a particular DB which is a 10gR2 DB. These two applications uses tables of their own and there are a ...
    Amir GheibiAmir Gheibi
    Apr 6, 2010 at 9:15 am
    Apr 6, 2010 at 9:30 am
  • From Merriam-Webster: Main Entry: snap·shot Pronunciation: \?snap-?shät\ Function: noun Date: 1890 1 : a casual photograph made typically by an amateur with a small handheld camera 2 : an ...
    Stephane FaroultStephane Faroult
    Apr 1, 2010 at 8:16 am
    Apr 1, 2010 at 1:57 pm
  • I have implemented Flora's method. I thought there might be a better way than shutting down service/db manually, but I am going to use that one. Thanks everyone and thanks to Flora. -- Thanks, Ram ...
    Ram KRam K
    Apr 30, 2010 at 10:41 pm
    Apr 30, 2010 at 10:41 pm
  • Thanks to all the on and off-list replies. Indeed the indexes were the problem here, as Data Pump was attempting to build all the indexes for these large tables concurrently in the temp space. I'm ...
    Tom LanyonTom Lanyon
    Apr 30, 2010 at 5:29 am
    Apr 30, 2010 at 5:29 am
  • Hi Hermant, That is great information, thank you so much. I figured we were defaulting to the same method_opt, but I did not know Oracle was looking at sys.col_usage$ to determine which histograms to ...
    Michael SchmittMichael Schmitt
    Apr 29, 2010 at 3:56 pm
    Apr 29, 2010 at 3:56 pm
  • Anyone know why the instructions for this require the recreation of the STATSPACK repository? We have a client who would quite like to keep a record of historical performance information and also be ...
    Niall LitchfieldNiall Litchfield
    Apr 29, 2010 at 1:57 pm
    Apr 29, 2010 at 1:57 pm
  • redhat Linux 11g Anyone seen any documenation on using port forwarding for compressing archivelogs on 11g? There seems to be only little on 10g Metalink. -- Howard A. Latham -- ...
    Howard LathamHoward Latham
    Apr 29, 2010 at 1:53 pm
    Apr 29, 2010 at 1:53 pm
  • Hi I have worked with backtrack and its very good piece of software but i have used it only in non rac and non asm environments. Prior to 11g rman did not have the feature to clone from a active ...
    HrishyHrishy
    Apr 29, 2010 at 9:56 am
    Apr 29, 2010 at 9:56 am
  • Daniel, As one of those who does have to comply it's done in a rather invasive way that really does protect the information. All of our laptops are encrypted at boot and you need a smart card and pin ...
    Goulet, RichardGoulet, Richard
    Apr 28, 2010 at 7:38 pm
    Apr 28, 2010 at 7:38 pm
  • I have logged a case for that in the past (http://freekdhooge.wordpress.com/2009/11/03/two-oracle-rac-bugs-on-the-wall-two-oracle-bugs-take-one-down) It should have been fixed in the april psu patch ...
    D'Hooge FreekD'Hooge Freek
    Apr 28, 2010 at 6:50 pm
    Apr 28, 2010 at 6:50 pm
  • Its also possible this system had syslog turned off. Its the only way I can think of where the system remain up but with no logging taking place. Now, that being behind us, I thought it odd that he ...
    William MuriithiWilliam Muriithi
    Apr 28, 2010 at 5:16 pm
    Apr 28, 2010 at 5:16 pm
  • Hi Yong, Are you looking at the updated version (verify_function_11g) or the original version (verify_function)? The utlpwdmg.sql (in 11.1.0.7 at least) contains both. And as part of the script it ...
    Kathryn axelrodKathryn axelrod
    Apr 28, 2010 at 3:56 pm
    Apr 28, 2010 at 3:56 pm
  • Does anybody know whether someone who already has HSPD12 clearance can ask for a higher salary when applying for another job? Isn't it basically like a security clearance? Anybody else done this and ...
    J. DexJ. Dex
    Apr 28, 2010 at 2:18 pm
    Apr 28, 2010 at 2:18 pm
  • Hi Group, A position as become available where I work. The company is named Fiberlink (please see fiberlink.com for more information on what we do). This opportunity is located in Blue Bell, PA which ...
    Thomas RoachThomas Roach
    Apr 27, 2010 at 10:08 pm
    Apr 27, 2010 at 10:08 pm
  • Does there has way to check which ORACLE client version user using it connect to ORACLE database? Thanks. -- http://www.freelists.org/webpage/oracle-l
    Dba1 mccDba1 mcc
    Apr 26, 2010 at 7:55 pm
    Apr 26, 2010 at 7:55 pm
  • 5 RAC Clusters on AIX 5.3 & Oracle 10gR2, all work fine. Now HACMP is another story :) I prefer a active cluster such as RAC. HACMP was more of a problem than it's benefit. From ...
    Sais, GeneSais, Gene
    Apr 26, 2010 at 7:20 pm
    Apr 26, 2010 at 7:20 pm
Group Navigation
period‹ prev | Apr 2010 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions84
posts165
users107
websiteoracle.com

107 users for April 2010

Greg Rahn: 7 posts : 6 posts Niall Litchfield: 6 posts Dba DBA: 5 posts Matthew Zito: 5 posts Andre van Winssen: 4 posts Dd yakkali: 4 posts Tom Lanyon: 4 posts Yechiel Adar: 4 posts Andrew Kerber: 3 posts Bobak, Mark: 3 posts Jared Still: 3 posts Ram Raman: 3 posts Anupam Pandey: 2 posts Cary Millsap: 2 posts D'Hooge Freek: 2 posts Gengmao: 2 posts Goulet, Richard: 2 posts Guillermo Alan Bort: 2 posts Hrishy: 2 posts
show more
Archives