FAQ

Oracle > oracle-l > April 2012

Search Discussions

71 discussions - 440 posts

  • hi, I wonder if anybody used this feature and what are Your impressions? We turn it on lately on some application and here a little subjective first look: - enabling it is easy - point A - we add ...
    Remigiusz SokolowskiRemigiusz Sokolowski
    Apr 3, 2012 at 11:05 am
    May 31, 2012 at 4:18 pm
  • Hi List We have been asked to come up with key performance indicators for the databases running in our company. The idea is to identify when things start to go wrong. Can you please share the methods ...
    Orlando LOrlando L
    Apr 11, 2012 at 4:18 pm
    Apr 19, 2012 at 5:22 pm
  • I know it's common for many folks to separate their OMS from their repository for Enterprise Manager- I haven't been one to do this in the past due to, OK, just going to say it, flaky network ...
    Kellyn Pot'vinKellyn Pot'vin
    Apr 12, 2012 at 2:19 pm
    Apr 14, 2012 at 11:35 am
  • Hi All, A RAC with 2 data nodes. Replication on RAC data node 1 will replicate to the standalone database. RAC data nodes have an there own redo logs(I think so). If I change data on RAC data node ...
    Paul HarrisonPaul Harrison
    Apr 17, 2012 at 3:31 pm
    Apr 19, 2012 at 5:19 pm
  • Hi All, I am asking a very basic question. Can we use 169.254.1.11 & 169.254.1.12 as private IP's for RAC 2 node cluster? (basically any 169.254.x.x ) we just have 1 private NIC for each node ...
    KrishnaKrishna
    Apr 6, 2012 at 2:59 am
    Apr 6, 2012 at 2:13 pm
  • We have a database server with one of the largest and fastest growing customer. Here is the current size of the database server. What process do you have to decide when to add more storage? Do you ...
    Michael DinhMichael Dinh
    Apr 19, 2012 at 3:21 pm
    May 2, 2012 at 7:43 pm
  • Per https://blogs.oracle.com/ebs/entry/the_new_my_oracle_support it seems so, not that I'd miss it terribly. HTML site works just fine. -- http://www.freelists.org/webpage/oracle-l
    RjamyaRjamya
    Apr 10, 2012 at 7:40 pm
    Apr 17, 2012 at 4:24 am
  • Hi, We are working on a dev cluster which originally was intended to be only 11.2 databases. However requirements changed mid-project (go figure!) and we now have to deploy an 10.2.0.5 database in ...
    Guillermo Alan BortGuillermo Alan Bort
    Apr 18, 2012 at 12:34 am
    Apr 23, 2012 at 3:35 pm
  • Hi, List, I have a query that uses function based index in DEV1 db but does NOT use it in DEV2 db. I've compared parameters db_file_multiblock_read_count and optimizer_index_cost_adj, they are ...
    Li LiLi Li
    Apr 25, 2012 at 2:51 pm
    Apr 28, 2012 at 11:15 am
  • Hello oracle-l, Has anyone done 11.201 to 11.202 in place upgrade for any of your databases on Linux. The manual seems to be for a new location upgrade. We are interested in knowing the steps for ...
    C PC P
    Apr 5, 2012 at 4:31 pm
    Apr 11, 2012 at 4:34 am
  • This is for Windows 2003 sp2 in case that matters. I need to upgrade some existing instances from 11.1.0.7 to 11.2.0.3. I only have one sever to work with so my high level plan is as follows: 1 ...
    Schauss, Peter (ESS)Schauss, Peter (ESS)
    Apr 18, 2012 at 6:14 pm
    Apr 21, 2012 at 4:46 pm
  • Has anyone had experience with whether using SQL Profiles (optimizer_capture_sql_plan_baselines= TRUE, optimizer_use_sql_plan_baselines=TRUE) is detrimental to overall performance. I'm talking about ...
    Walker, Jed SWalker, Jed S
    Apr 13, 2012 at 1:08 pm
    Apr 16, 2012 at 7:47 pm
  • I thought I saw a thread on windows 7 and oracle client. We can't seem to get it loaded. It asks for vista but not windows 7. We need 64bit. Is there a work-around? Brian Brian J. Zelli Senior ...
    Zelli, BrianZelli, Brian
    Apr 30, 2012 at 2:54 pm
    Apr 30, 2012 at 11:07 pm
  • Hi List, I am wondering if anyone has implemented an archive solution and would be willing to share what product you used, either commercial, open source or home-grown? We are at a point that we have ...
    Li LiLi Li
    Apr 20, 2012 at 4:40 pm
    Apr 24, 2012 at 6:30 pm
  • Hi Lists According to the Doc as below: *Oracle® Database Application Developer's Guide - Large Objects 10g Release 2 (10.2)* Part Number B14249-01 In Chapter 4 there are 2 graph： 1. LOB values ...
    Leyi Kamus ZhangLeyi Kamus Zhang
    Apr 21, 2012 at 3:35 pm
    Apr 24, 2012 at 6:25 pm
  • Hi, listers, The update based on rowid as shown below, which is a statement issued by SharePlex process at the target database, has about 2.5 K per execution, any thoughts about what could the cause? ...
    DenisDenis
    Apr 10, 2012 at 8:12 pm
    Apr 11, 2012 at 12:05 pm
  • Hi all, I'm trying to create a query to know which tables are linked with table 'anagrafica' in PostgreSQL I can achieve it with this query: SELECT 'anagrafica' AS table, ...
    JoJo
    Apr 28, 2012 at 7:05 pm
    Apr 30, 2012 at 1:01 pm
  • Hi all, This is an instance in v11. SQL sho parameter memory NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ hi_shared_memory_address integer 0 ...
    Orlando LOrlando L
    Apr 25, 2012 at 7:09 pm
    Apr 29, 2012 at 12:46 pm
  • Hello listers, I'm at a bit of a quandry here. We have a DW load process that uses exchange partition to load the fact table. First we gather all the event data and transform it so that it is staged ...
    Rodd HolmanRodd Holman
    Apr 30, 2012 at 9:34 pm
    May 2, 2012 at 7:38 pm
  • Hi While doing some tests to see if there are any anormal behaviour in a batch process I noticed something in my test case which I cannot explain regarding consistent read and undo applying. I have ...
    Ls ChengLs Cheng
    Apr 24, 2012 at 10:07 pm
    Apr 26, 2012 at 5:27 am
  • Ok, I couldn't find it quickly so I'm asking... How do you find the earliest restore point within an existing RMAN backup? Chris Taylor "Quality is never an accident; it is always the result of ...
    Taylor, Chris DavidTaylor, Chris David
    Apr 24, 2012 at 1:15 pm
    Apr 24, 2012 at 1:45 pm
  • In Oracle 11.2.0.3 and 10.2.0.3 group by produces wrong cardinalities. See the inner hash join cardinality bellow. Does anyone know a patch/workarround for this particular problem? Tried a few ...
    Laimutis NedzinskasLaimutis Nedzinskas
    Apr 26, 2012 at 12:32 pm
    Apr 27, 2012 at 11:54 am
  • Other than licensing the stand-by database itself, is there anything else that needs to be licensed to use Standby? Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 26, 2012 at 6:30 pm
    Apr 27, 2012 at 12:54 am
  • I realize this is way off topic (probably should be titled "WOT:...") for Oracle but #1, I don't currently belong to any good linux/redhat forums and #2, the issue found was from an Oracle maint ...
    Herring Dave - dherriHerring Dave - dherri
    Apr 15, 2012 at 5:47 pm
    Apr 24, 2012 at 2:03 pm
  • Is there a licensing cost to use APEX? Does your database license have to include all of the users connecting through APEX or how is that licensed? Jeffrey Beckstrom Database Administrator Greater ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 16, 2012 at 3:04 pm
    Apr 17, 2012 at 6:08 pm
  • Running 11.2.0.2.5 RAC on Linux x86. We are migrating to a new SAN. With respect to the OCR diskgroup, which is defined with 3 disks with normal redundancy, I do know how to migrate the OCR/voting ...
    Jeff ThomasJeff Thomas
    Apr 6, 2012 at 2:35 pm
    Apr 6, 2012 at 6:16 pm
  • Hi Friends, In AWR under Instance Efficiency Percentages we see a Library Hit % and we find it very low for one snapshot. I would like to know the trend for few more days available in AWR snapshots ...
    Sreejith S NairSreejith S Nair
    Apr 4, 2012 at 9:40 am
    Apr 6, 2012 at 12:20 am
  • Are any other users having difficulty replying to Oracle-L ? At present I'm getting Error 554 with "possible abuse" as the justification from the BT smtp servers for any replies I try to send to the ...
    Jonathan LewisJonathan Lewis
    Apr 29, 2012 at 7:28 am
    Apr 29, 2012 at 12:34 pm
  • 2-node Oracle 11.2.0.1 RAC, RHEL 5.7 x86_64, kernel 2.6.18-274.7.1.el5 One of the 3 SCAN listeners listens on an IP which exists on the other node of this 2-node RAC. C:\ nslookup scancs4.<domainname ...
    Yong HuangYong Huang
    Apr 23, 2012 at 7:53 pm
    Apr 25, 2012 at 3:00 pm
  • This question came up from a reader of my blog. She asks how high can we set vm.nr_hugepages. My response is below. Does anyone else have input on how much memory Linux actually needs on VLM ...
    Andrew KerberAndrew Kerber
    Apr 17, 2012 at 4:13 pm
    Apr 24, 2012 at 3:02 pm
  • I took the following example from MOS note 956603.1 and modified the key to use an md5 hash of a passphrase I made up. It runs without issue. Original with new key create or replace function ...
    Kenneth NaimKenneth Naim
    Apr 23, 2012 at 7:14 pm
    Apr 24, 2012 at 2:51 pm
  • I've been asked to remediate various Oracle security issues for dozens of instances. Here's the reference document provided with the scan results: Center for Internet Security Security Configuration ...
    DnrgDnrg
    Apr 18, 2012 at 12:13 pm
    Apr 19, 2012 at 2:55 pm
  • Hi, I have a statement which produces a high CBO cost but executes very quickly, as shown below. Based on the execution timings, is the cost figure a true representative of the response time? The DB ...
    Hameed, AmirHameed, Amir
    Apr 16, 2012 at 6:55 pm
    Apr 18, 2012 at 11:50 am
  • Please consider participating in this poll. http://timurakhmadeev.wordpress.com/2012/04/09/method_opt/ -- Regards, Greg Rahn | blog <http://bit.ly/u9N0i8 | twitter <http://bit.ly/v733dJ | linkedin ...
    Greg RahnGreg Rahn
    Apr 9, 2012 at 11:00 pm
    Apr 10, 2012 at 5:15 pm
  • Hey all, Working on upgrading from 10.1.0.5 to 11.2.0.3 on AIX 5.3. I've patched AIX up to TL12 SP5, which should be the terminal release. I've installed 11.2.0.3.0, as well as AIX APAR IV11158 to ...
    Rich JesseRich Jesse
    Apr 2, 2012 at 7:28 pm
    Apr 2, 2012 at 8:33 pm
  • I am trying to get offline backups configured for my RAC server nodes. I was planning on having all local filesystems backed up, but the offline backup team says they don't backup the OS by default ...
    Walker, Jed SWalker, Jed S
    Apr 30, 2012 at 11:34 pm
    May 2, 2012 at 7:41 pm
  • Our environment: 95% RHEL5 5% Windows Approximately 120 Oracle EE 11.2.0.2 databases. 3 DBAs We're looking for a method to help automate the application of the quarterly CPUs. We've looked into the ...
    Kroll, Stanley R.Kroll, Stanley R.
    Apr 30, 2012 at 2:08 pm
    Apr 30, 2012 at 10:12 pm
  • Hi List, IOUG Collaborate 2012 starts tomorrow - is anybody going to be there? Aaaaand, is anybody of you speaking there? I'll present about Cursoer Mutex waits (Session #893) Hope to see you in ...
    Martin KlierMartin Klier
    Apr 22, 2012 at 3:44 am
    Apr 22, 2012 at 8:24 pm
  • Hi, we have a small application having QA & Prod. QA - 2 node RAC: 11.2.0.3 : RHEL 5.8 - Datacenter A Prod: 2 node RAC : 11.2.0.3 RHEL 5.8 - Datacenter B can I configure Dataguard in the above ...
    Venkaiah kodaliVenkaiah kodali
    Apr 17, 2012 at 2:06 am
    Apr 17, 2012 at 3:13 am
  • Intermittent Apache errors, server errors ... is this like some code Ester Egg surfaced after Easter? I am fearful of heading to flash site. Anyone else experiencing issues as well? Raj -- ...
    RjamyaRjamya
    Apr 9, 2012 at 3:46 pm
    Apr 10, 2012 at 11:33 am
  • Hi All, I am trying to install Golden Gate on RAC. The documentation mentioned to install GG on shared storage on all nodes. can anybody give their experiences in using OCFS2 or ACFS for Golden gate ...
    KrishnaKrishna
    Apr 7, 2012 at 8:44 pm
    Apr 9, 2012 at 12:37 am
  • Hi Friends, I am getting the following error using Oracle Spatial - Oracle 10.2.0.4 ORA-21780: Maximum number of object durations exceeded. Any idea ? Any experience with this error ? Regards ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Apr 7, 2012 at 1:55 am
    Apr 7, 2012 at 4:42 pm
  • Hello, We've created a logical standby, and discovered issues with tables that have function-based indexes. Its appear the LSB does not use them. This caused the LSB to lag far behind the primary ...
    Ed lewisEd lewis
    Apr 5, 2012 at 11:18 pm
    Apr 7, 2012 at 6:58 am
  • Howdy all, So I've migrated my Grid Control 10g to Cloud Control 12c. Several minor issues, a few major ones, but it's working. One piece I overlooked (probably because the documentation only ...
    Rich JesseRich Jesse
    Apr 30, 2012 at 5:05 pm
    May 1, 2012 at 5:46 pm
  • I'm going to ask quite an open question , so I hope that I don't get slapped down for that, but the chances are, if I haven�t included the information, then the chances are I don't know, but do ask! ...
    David RobertsDavid Roberts
    Apr 28, 2012 at 4:13 am
    Apr 28, 2012 at 6:13 am
  • Looking at upgrading from 4.0 to 4.1. Is it possible to migrate an APEX application from a 4.1 database to a 4.0 database or does the source and target have to be at the same version? Jeffrey ...
    Jeffrey BeckstromJeffrey Beckstrom
    Apr 3, 2012 at 6:46 pm
    Apr 27, 2012 at 4:43 pm
  • Hello, We have a RAC 4 nodes environment running in 11gR2 / Linux redhat. database in Archivelog mode and we use RMAN. Every Sunday, We do weekly Tape backup of the recovery area + Current ...
    Mek SMek S
    Apr 18, 2012 at 8:14 pm
    Apr 26, 2012 at 10:51 pm
  • Oracle 11.2.0.2 redhat 5.6 psu 13343424 ASM installed in /grid OH DB installed in /dbhome_1 no RAC I was about to install PSU# 13343424 and was reading the README.html and it said if you have grid ...
    Michael McMullenMichael McMullen
    Apr 18, 2012 at 1:12 pm
    Apr 22, 2012 at 2:52 pm
  • Hi All, Greetings. Recently we were trying to export a frequently updated table using datapump with flashback_scn. It failed with ORA-1555. But when we tried to insert into table as select * from ...
    Sundar mahadevanSundar mahadevan
    Apr 20, 2012 at 5:04 pm
    Apr 20, 2012 at 8:22 pm
  • I'm using the 'good offices' (thank you Mark) of the list to inform you all that Chris Date is making a rare appearance in the UK (he was last here two years ago) for a 2 day seminar on the above ...
    Peter RobsonPeter Robson
    Apr 12, 2012 at 8:53 am
    Apr 20, 2012 at 10:18 am
Apr 2012
12
Group Navigation
period‹ prev | Apr 2012 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions71
posts440
users139
websiteoracle.com

139 users for April 2012

Tanel Poder: 13 posts Taylor, Chris David: 12 posts Hans Forbrich: 11 posts GG: 10 posts Niall Litchfield: 10 posts Walker, Jed S: 10 posts Joel Patterson: 9 posts Rjamya: 9 posts CRISLER, JON A: 8 posts Ls Cheng: 8 posts Radoulov, Dimitre: 8 posts Karl Arao: 7 posts Kellyn Potvin: 7 posts Kevin Jernigan: 7 posts Norman Dunbar: 7 posts Remigiusz Sokolowski: 7 posts Yong Huang: 7 posts David Fitzjarrell: 6 posts Guillermo Alan Bort: 6 posts Jeffrey Beckstrom: 6 posts
show more
Archives