FAQ

Oracle > oracle-l > November 2012

Search Discussions

82 discussions - 394 posts

  • Morning all, Oracle versions are 11.2.0.3 Enterprise and Standard on Linux x86-64. May affect others. I'm fighting/discussing with Oracle Support at the moment on a potential bug in the use of ...
    Norman DunbarNorman Dunbar
    Nov 26, 2012 at 11:01 am
    Dec 4, 2012 at 9:26 am
  • Thank you David for that comprehensive example. One question is it possible to modify the subpartition template to say add a third value in the future eg UGLY. Thanks Sent from Yahoo! Mail on Android ...
    Zabair AhmedZabair Ahmed
    Nov 29, 2012 at 11:03 am
    Nov 29, 2012 at 8:03 pm
  • Hi I have a 11.2.0.3 single instance running a WMS system called Selektron, which consumes tons of CPU. This database runs on IBM AIX 6.1 LPAR UnCapped configuration, using 16 Logical CPUs (SMT ...
    Ls ChengLs Cheng
    Nov 13, 2012 at 12:06 pm
    Dec 1, 2012 at 11:02 am
  • Oracle 11.2.0.2 SLES11 on IBM mainframe DB size - just below 1T I run an incremental 0 backup on my production OLTP once a week, incrementals the rest of the week. Recently changed the disk_asynch_io ...
    Sandra BeckerSandra Becker
    Nov 12, 2012 at 7:39 pm
    Nov 13, 2012 at 8:47 pm
  • Anyone know of a decent tool for monitoring Dataguard Maybe like spotlight where you can watch the log files being transmitted , spot bottlenecks etc. Oracle 11 Redhat Linux BTW please stop send ...
    Howard LathamHoward Latham
    Nov 29, 2012 at 10:29 am
    Nov 29, 2012 at 8:47 pm
  • Anyone done any data mining on this view? I'm trying to understand how the EXECUTIONS_TOTAL, EXECUTIONS_DELTA, ELAPSED_TIME_TOTAL, ELAPSED_TIME_DELTA roll up (if they do) from one snapshot to the ...
    Christopher Taylor2Christopher Taylor2
    Nov 20, 2012 at 3:45 pm
    Nov 21, 2012 at 4:37 pm
  • List: 10.2.0.3 EE on Solaris. No RAC. I have a client who run a report which consist of just a select statement. Nothing really special except there's a couple of stored function calls in the ...
    Jorgensen, FinnJorgensen, Finn
    Nov 27, 2012 at 5:43 pm
    Nov 29, 2012 at 10:02 pm
  • Hi, We are looking for RAC Implementation for our SAP database instances. I have one question about the migration process of File System Datafiles to ASM. If we do so, the reorg of the objects are ...
    Raja SubramaniyanRaja Subramaniyan
    Nov 27, 2012 at 9:58 am
    Nov 28, 2012 at 7:13 pm
  • To List: Has anyone done a Redhat v5 to v6 upgrade on an a RAC cluster? Our UNIX admin tells me that the upgrade is a re-install of Linux. Oracle Support has stated this: Oracle RAC supports rolling ...
    Don MorseDon Morse
    Nov 22, 2012 at 11:14 pm
    Nov 26, 2012 at 10:34 pm
  • I am looking in the v$rowcache table and found something that I haven't been able to find out about. PARAMETER COUNT MODIFICATIONS GETS GETMISSES MISS_PCT -------------------------------- ---------- ...
    Walker, Jed SWalker, Jed S
    Nov 14, 2012 at 10:47 pm
    Nov 17, 2012 at 10:17 am
  • I have this 3-Node RAC (10.2.0.4) that I've inherited (as I've mentioned) and after putting out a few issues I'm ready to move onto the redo logs (and perhaps I should have started here earlier) ...
    Christopher Taylor2Christopher Taylor2
    Nov 14, 2012 at 9:50 pm
    Nov 16, 2012 at 8:28 am
  • Hey guys (or should I say Sehr Geehrte Damen und Herren), I'm (slowly) learning German, I'm hoping to move to Germany within the next year or so and as I hope to get a job as a DBA or something of ...
    Guillermo Alan BortGuillermo Alan Bort
    Nov 2, 2012 at 1:41 am
    Nov 7, 2012 at 8:50 pm
  • All, Anyone seen this behavior before. We are on 11.2.0.3 EE 2 Node RAC, RH 5.8 We have 2 app nodes (node1 and node2) where we are testing connectivity to newly setup 2 Node RAC cluster. From ...
    Steven AndrewSteven Andrew
    Nov 1, 2012 at 10:56 pm
    Nov 2, 2012 at 10:41 pm
  • So, users can decrypt dblink passwords as the key is included in the ciphertext... -- SQL select name, userid, utl_raw.cast_to_varchar2(dbms_crypto.decrypt((substr(passwordx,19)), 4353, ...
    OracleOracle
    Nov 25, 2012 at 8:20 pm
    Nov 29, 2012 at 1:27 pm
  • All Our management has decided to put together statistics from various resources including OS, network, san etc into a central location and plot things in the form of a graph. The purpose is to track ...
    Ram KRam K
    Nov 6, 2012 at 7:02 pm
    Nov 9, 2012 at 8:17 pm
  • Hi, I have a four-node RAC system, the workload runs against the database waits on log file sync heavily, average wait time is 82.41 ms, account for 75% DB time. The system CPU resource is rich ...
    SuyaSuya
    Nov 26, 2012 at 6:37 am
    Dec 4, 2012 at 9:48 am
  • Hello, I am analyzing some performance problems of an Oracle 10.2.0.5.0 2-node RAC system and one figure in the AWR report caught my attention: Rollback per transaction %: 98.15 What exactly does ...
    Thomas KellererThomas Kellerer
    Nov 20, 2012 at 2:17 pm
    Nov 21, 2012 at 4:56 pm
  • Hi, I'm the sole DBA at my shop. This means that I'm pretty much always on call - on vacations and what not. My boss wants to get me a backup and has someone willing to start heading down the DBA ...
    Steve WalesSteve Wales
    Nov 16, 2012 at 9:52 pm
    Nov 17, 2012 at 12:12 pm
  • A customer asked me 2 questions and i am not sure of the answer so i'd ask your experience 1) they have some instances and they want to disable diagnostic and tuning pack . Istances are 10.2.0.3 and ...
    pier paolo Brunopier paolo Bruno
    Nov 26, 2012 at 11:01 pm
    Nov 28, 2012 at 11:56 pm
  • Hi all, This post is partially OT, I am looking for resources like forums or ML (a clone to oracle-l :D ) on data modeling... does anybody have info about this? Thanks Ste -- ...
    Stefano CislaghiStefano Cislaghi
    Nov 28, 2012 at 10:36 am
    Nov 28, 2012 at 9:38 pm
  • Setup: 10.2.0.4 64-bit RHEL 3 node RAC node1 is requesting blocks for a transaction - either node2 or node3 is holding the block(s) that are being requested. How can I determine which node(s) of the ...
    Christopher Taylor2Christopher Taylor2
    Nov 13, 2012 at 4:35 pm
    Nov 14, 2012 at 5:08 pm
  • So, there are days I really hate Windows. Windows updates were applied to my dev box. I had a standalone instance setup that was working fine using dbcontrol, using ....1158/em Post updates, I cannot ...
    Storey, Robert (DCSO)Storey, Robert (DCSO)
    Nov 12, 2012 at 4:46 pm
    Nov 12, 2012 at 6:17 pm
  • The latest issue of the NoCOUG Journal was published today. NoCOUG has just completed 26 years and therefore this is the 104th issue of the Journal. Here is the announcement that went out today ...
    Iggy FernandezIggy Fernandez
    Nov 27, 2012 at 1:42 am
    Nov 28, 2012 at 2:54 pm
  • Hi list, I have couple questions related to Exadata but first a little bit of background story: I am considering different solutions for database consolidation as well as increasing high availability ...
    Goran bogdanovicGoran bogdanovic
    Nov 21, 2012 at 10:11 am
    Nov 21, 2012 at 7:14 pm
  • Before I log yet another SR with Oracle, is anyone aware of the circumstances under which the above view is not populated? I've pushed some monitoring based on dba_tablespace_usage_metrics into ...
    Niall LitchfieldNiall Litchfield
    Nov 21, 2012 at 7:02 am
    Nov 21, 2012 at 5:21 pm
  • We have created asm disk using asmlib and assigned to the diskgroups. This was done a while back. Is there a way now to get LUN ID of these disks? We are in linux running 11.2.0.3 grid. Regards, ...
    Shanmugam, Satheesh BShanmugam, Satheesh B
    Nov 20, 2012 at 3:17 pm
    Nov 21, 2012 at 12:33 pm
  • I need a test script to generate TEMP tablespace READS - I'm able to generate writes but I'm not getting any reads (or very few). Anyone have a simple script to do that? The reason for this is to ...
    Christopher Taylor2Christopher Taylor2
    Nov 6, 2012 at 3:13 pm
    Nov 6, 2012 at 7:13 pm
  • All, I appreciate if you could shed some light on which direction to go. I have Solaris non-rac database running with 26GB SGA ( PDB-NONRAC(Solaris)) and 3 node RAC database in Linux with 100GB SGA ( ...
    Sudhakar G PillaiSudhakar G Pillai
    Nov 5, 2012 at 3:44 pm
    Nov 5, 2012 at 11:03 pm
  • Hi I am getting "ORA-04031: unable to allocate 3896 bytes of shared" errors in the asm instance of a cluster node. Currently the SGA_MAX_SIZE is set to default value (400 MB) and there are about a ...
    Manmohan JalsinghManmohan Jalsingh
    Nov 15, 2012 at 12:10 am
    Jan 15, 2013 at 9:35 pm
  • Hi, We are considering to use RMAN image copy as our backup method, then apply the daily incrementals to update the image copy. Has anyone done that before? If the image copy is corrupted, will it be ...
    Chen ZhouChen Zhou
    Nov 29, 2012 at 5:11 am
    Nov 30, 2012 at 9:44 am
  • Hi List, This is 10.2.0.4 on Solaris 10. We are seeing large amounts of the blocking enqueue 'enq: TX - row lock contention' on insert of a normal/heap table as well as smaller amounts on a couple of ...
    RichRich
    Nov 29, 2012 at 4:28 pm
    Nov 29, 2012 at 8:24 pm
  • I guess I'm really looking for excel or similar help.. I have a set of tablespace data along the lines of the table below Date Name Size March TS1 100 March TS2 200 March TS3 300 April TS1 120 April ...
    Niall LitchfieldNiall Litchfield
    Nov 15, 2012 at 9:41 am
    Nov 19, 2012 at 3:39 pm
  • Anyone have any idea what might be happening when sessions are connecting and all but a few succeed. After that swingbench (actually charbench) just waits for a long time until those few extra ...
    kyle Haileykyle Hailey
    Nov 13, 2012 at 4:17 am
    Nov 14, 2012 at 5:03 am
  • I opened an SR about 5 months ago with support on an intermittent problem with monitoring (OEM SQL Monitor) long-running parallel queries. Inexplicably, after "some" amount of time (varied from 30-90 ...
    Tornblad, JohnTornblad, John
    Nov 2, 2012 at 4:37 pm
    Nov 13, 2012 at 10:15 pm
  • Hi Oracle-l, When I run a simple select on one 160mb clob, the oracle foreground process uses all memory, swap then hangs the server. This happens on red hat 4.5, 5.7 and OEL 6.3 Tested Oracle ...
    Tom DaleTom Dale
    Nov 12, 2012 at 3:05 pm
    Nov 13, 2012 at 6:32 pm
  • Hello, I have been experiencing ORA-01031 insufficient privileges from application using Weblogic (WLS) connected as the schema owner. Database is 11.2.0.3 the SQL itself does not fail when execute ...
    Michael DinhMichael Dinh
    Nov 6, 2012 at 2:21 pm
    Nov 7, 2012 at 4:52 am
  • Hi , I am facing the following error during impdp .Mine is a 2 node RAC of version 11.2.0.3 on Redhat Linux.Kindly help me.I have given read and write permission to public on my DB directory ...
    Nisha MohanNisha Mohan
    Nov 6, 2012 at 5:44 am
    Nov 6, 2012 at 10:48 am
  • Folks, I'm new to AIX and I'm a bit confused on the configuration options for filesystems regarding the use of aio, cio. I've been through multiple metalink docs and publib.ibm.com docs but I still ...
    Christopher Taylor2Christopher Taylor2
    Nov 2, 2012 at 1:21 pm
    Nov 2, 2012 at 5:00 pm
  • Yesterday I had my first experience with RAC One Node, and there is one feature of it that is somewhat confusing. We installed RAC One Node on an ODA, and all went smoothly. When we started the ...
    Jared StillJared Still
    Nov 29, 2012 at 5:34 pm
    Nov 30, 2012 at 6:23 pm
  • SLES11 Oracle 11.2.0.2.0 We have a project to refresh snapshot databases on a varying schedule. These snapshots all will be development, test, QA, and UAT. The snapshots will be done at the hardware ...
    Sandra BeckerSandra Becker
    Nov 28, 2012 at 7:54 pm
    Nov 29, 2012 at 5:22 pm
  • Thanks Mark First reaction is -- whhhatt. This seems to be beyond my SQL/partitioning knowledge. But I will continue with my analysis/research on the issue. Yes I do have a test system and I've ...
    Zabair AhmedZabair Ahmed
    Nov 28, 2012 at 7:38 pm
    Nov 28, 2012 at 8:57 pm
  • If you had a job that wrote a file to disk from the database that sometimes took 10 minutes and sometimes 2 hours and somebody wanted to throw money at the problem why so slow sometimes what would ...
    Howard LathamHoward Latham
    Nov 27, 2012 at 3:23 pm
    Nov 27, 2012 at 7:04 pm
  • Hey all, Looking ahead to where I can no longer do on-the-fly compression on my exports due to Oracle now charging for that functionality (exp- expdp), I came across an Oracle6 Linux manual that says ...
    Rich JesseRich Jesse
    Nov 15, 2012 at 3:37 pm
    Nov 15, 2012 at 5:42 pm
  • Hello, I would appreciate any feedback from storage experts on my post http://mdinh.wordpress.com/2012/11/15/san-insanity/ SAN Insanity. Thanks Michael. -- http://www.freelists.org/webpage/oracle-l
    Michael DinhMichael Dinh
    Nov 15, 2012 at 1:29 pm
    Nov 15, 2012 at 2:32 pm
  • I have another puzzle related to /dev/(u)random. I posted somewhere else without an answer. On RHEL 6, a very simple JDBC java program returns instantly if I pass /dev/./urandom to ...
    Yong HuangYong Huang
    Nov 14, 2012 at 5:20 pm
    Nov 14, 2012 at 10:17 pm
  • hello, When recently visting a custumer, I have seen this init parameter _unnest_subquery set to FALSE. It is an 11.2.0.3 Oracle database. I wonder what are the reasons behind setting this parameter ...
    Mek SMek S
    Nov 5, 2012 at 1:01 pm
    Nov 5, 2012 at 1:37 pm
  • Running 11.2.0.2, SLES11 Current set up is primary to a single physical standby. Goal is to set up a second physical cascading standby. Questions: Can the cascaded standby be created through EM? If ...
    Sandra BeckerSandra Becker
    Nov 1, 2012 at 5:42 pm
    Nov 1, 2012 at 6:06 pm
  • I need to create a synonym for dba_synonyms named dba_synonymns, because I always misspell dba_synonyms "dba_synonymns". -- http://www.freelists.org/webpage/oracle-l
    Gerald CunninghamGerald Cunningham
    Nov 30, 2012 at 9:17 pm
    Dec 1, 2012 at 12:26 am
  • All, I have the following view: CREATE OR REPLACE FORCE VIEW myview (SERVER_NAME, DB_NAME, COLLECTION_DATE, MOUNT_NAME, ALLOCATED_SPACE, USED_SPACE, VERSION) AS select ...
    OracledbaOracledba
    Nov 30, 2012 at 3:34 pm
    Nov 30, 2012 at 10:25 pm
  • Hello, an Oracle 10.2.0.5.0 2-node RAC system (Linux) went haywire last week. The CPUs of both nodes went to 100% and the message KEWRAFC: FLUSH SLAVE FAILED, AWR ENQUEUE TIMEOUT was written to the ...
    Thomas KellererThomas Kellerer
    Nov 26, 2012 at 7:57 am
    Nov 29, 2012 at 9:58 am
Nov 2012
12
Group Navigation
period‹ prev | Nov 2012 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions82
posts394
users126
websiteoracle.com

126 users for November 2012

Christopher Taylor2: 28 posts Zabair Ahmed: 20 posts Norman Dunbar: 14 posts David Fitzjarrell: 10 posts Ls Cheng: 10 posts Niall Litchfield: 9 posts Sandra Becker: 9 posts D'Hooge Freek: 8 posts Mark W. Farnham: 8 posts Patterson, Joel: 8 posts Goran bogdanovic: 7 posts kyle Hailey: 7 posts Jared Still: 6 posts Jonathan Lewis: 6 posts Jorgensen, Finn: 6 posts pier paolo Bruno: 6 posts Ray Stell: 6 posts Rjamya: 6 posts Bobby Curtis: 5 posts De DBA: 5 posts
show more
Archives