Search Discussions

64 discussions - 309 posts

  • Hello, Does anyone have any experience with updating compressed table? The only difference between 2 tables is no compression vs OLTP compression. PL/SQL using FOR loop updating 1 row and a time and ...
    Michael DinhMichael Dinh
    Dec 25, 2012 at 4:53 am
    Dec 28, 2012 at 3:33 pm
  • I learned yesterday that our new billing application is being written to use a Postgres database instead of the Oracle database it currently uses. Somehow or other (development hasn't figured it out ...
    Sandra BeckerSandra Becker
    Dec 6, 2012 at 4:34 pm
    Dec 22, 2012 at 2:49 am
  • I was looking at the Dell Precision m6700 but I'm not sure I want to pull the pin on that badboy right now so I was curious if any of you guys have a good workstation replacement you use to run test ...
    Christopher Taylor2Christopher Taylor2
    Dec 29, 2012 at 1:28 am
    Jan 2, 2013 at 8:14 pm
  • I'm curious if anyone uses anything other than OCFS/OCFS2 filesystems for their RAC shared storage areas? It seems that OCFS (our version anyway) is not extendable unless you take it offline. A key ...
    Christopher Taylor2Christopher Taylor2
    Dec 12, 2012 at 8:15 pm
    Dec 13, 2012 at 11:50 am
  • Here is an interview question using facebook for an example. It's a data modeling question that applies to a lot of social network sites and startups ...
    kyle Haileykyle Hailey
    Dec 7, 2012 at 9:26 pm
    Dec 18, 2012 at 8:08 am
  • I could swear that a while back I read or saw a presentation from someone where they discussed how Oracle stores the internal timestamp. They said it was stored as a number and that in order to not ...
    Walker, Jed SWalker, Jed S
    Dec 19, 2012 at 12:50 am
    Dec 19, 2012 at 10:39 pm
  • Has anyone taken a training class from Hotsos? Specifically I am looking at the Optimizing Oracle SQL, Intensive class. Is this a good class, is it for more advance DBA's? I don't know if I will ...
    Jeff ChircoJeff Chirco
    Dec 5, 2012 at 7:40 pm
    Dec 10, 2012 at 4:21 pm
  • Hi all, I have to pick one of them - Oracle Stream or Golden Gate for our reporting system (I actually like logical standby since looks we only need an exact copy of prod database for reporting ...
    Lu JiangLu Jiang
    Dec 4, 2012 at 7:48 pm
    Dec 6, 2012 at 8:47 pm
  • Oracle EE on Exadata X2-2 quarter rack with extra cells (7 cells in total). Under heavy I/O load (i.e. when the cells are saturated) we are seeing a very large difference between the average ...
    Matt McClernonMatt McClernon
    Dec 31, 2012 at 1:51 am
    Jan 12, 2013 at 7:51 pm
  • All, I am working on migrating some oracle databases into Amazon RDS. Is there a good monitoring solution out there for these instances? The provided cloudwatch is minimal, and not useful at all in ...
    Michael WehrleMichael Wehrle
    Dec 13, 2012 at 3:56 pm
    Dec 17, 2012 at 9:24 am
  • I'm about to clone a clone of a clone of a clone and it's 6.5 TB in size. I'm a tad concerned, before I start, because I don't see how to do this in the docs, or in any of my books on RMAN. I need ...
    Norman DunbarNorman Dunbar
    Dec 11, 2012 at 11:37 am
    Dec 12, 2012 at 9:38 am
  • I have never been a member of either one but I am thinking of joining one and was wondering which one do any of you prefer and what do you use it for? What do you personally get out of it? There have ...
    Jeff ChircoJeff Chirco
    Dec 10, 2012 at 4:33 pm
    Dec 10, 2012 at 9:13 pm
  • Dear listers, I have too much read IO waits (db file sequential read) on a CLOB, when inserting data, and I don't understand why. Statement: INSERT into TABLE (<list of all columns ) values <list of ...
    Martin KlierMartin Klier
    Dec 5, 2012 at 8:33 am
    Dec 7, 2012 at 6:03 pm
  • Environment: Windows Server 2008 R2 64-Bit / Oracle 64 bit I have a new environment I'm setting up and testing for an upcoming go live. I have a database PROD on node1 which backs up to ...
    Steve WalesSteve Wales
    Dec 5, 2012 at 3:51 am
    Dec 5, 2012 at 8:00 pm
  • Does anyone use this software from Netapp? We want to apply it in several different environments. Thanks in advance, denise -- http://www.freelists.org/webpage/oracle-l
    Denise GwinnDenise Gwinn
    Dec 18, 2012 at 2:11 am
    Jan 8, 2013 at 6:15 pm
  • We support an ERP application that uses the jdbc thin client to connect to Oracle Databases. Historically it's just been done using a single instance of a database and the connect string looks ...
    Steve WalesSteve Wales
    Dec 4, 2012 at 10:58 pm
    Dec 9, 2012 at 11:23 am
  • I have TOAD on my pc(windows 7). I have the 32 bit oracle client 10g. TOAD works fine. I just downloaded Quest SQL Optimizer, installed it, but get the infamous: "ora-12154 could not resolve the ...
    Zelli, BrianZelli, Brian
    Dec 5, 2012 at 4:33 pm
    Dec 6, 2012 at 5:22 am
  • All, Me and a colleague were having discussion about creating indexes in character columns that are big in size. He is of the opinion that big character columns should not be indexed. He could not ...
    Orlando LOrlando L
    Dec 26, 2012 at 5:54 am
    Dec 28, 2012 at 3:11 pm
  • Anyone good with table functions? I am getting an ora-00932 error when I call this: type redo_gen_format as object (inst_id number, sid number, serial# number, username varchar2(30), machine ...
    Andrew KerberAndrew Kerber
    Dec 27, 2012 at 3:20 pm
    Dec 27, 2012 at 8:30 pm
  • This is something I came up with while learning Analytics and thought I'd share and see what others think. I thought it was just fun, but in some cases it is quite nice to have. I'm now thinking with ...
    Walker, Jed SWalker, Jed S
    Dec 21, 2012 at 6:12 pm
    Dec 24, 2012 at 12:46 pm
  • I'm doing some analysis of a query and looking at the indexes vs the query. The table has several indexes and one of them is on district+period+a few other columns. The query is doing this: where ...
    Steve WalesSteve Wales
    Dec 19, 2012 at 11:50 pm
    Dec 20, 2012 at 7:17 pm
  • We're experimenting with partitioning a table into many partitions with many subpartitions because of the way we process by Organization IDs and Secure Profiles - related to parallel application ...
    Christopher Taylor2Christopher Taylor2
    Dec 14, 2012 at 3:24 pm
    Dec 17, 2012 at 7:54 pm
  • I'm trying to map our ASM raw devices to our EMC powerpath device names (from there I can use powermt to display the physical devices). We do not use ASMlib apparently and our ...
    Christopher Taylor2Christopher Taylor2
    Dec 10, 2012 at 1:16 pm
    Dec 10, 2012 at 7:47 pm
  • Jonathan, I couldn't reproduce the scenario of reading the same block with "db file sequential read" waitevent and immediately followed by "direct path read" waitevent. Martin, can you try ...
    Saibabu DevabhaktuniSaibabu Devabhaktuni
    Dec 7, 2012 at 8:39 am
    Dec 8, 2012 at 8:46 pm
  • Hi Gurus, I am a newbie in reading AWR and concluding the issue lies at some point. Would require your advice in knowing where the issue lies during my production hung due to high archive generation ...
    Apps DBAApps DBA
    Dec 30, 2012 at 6:34 pm
    Jan 8, 2013 at 6:43 am
  • Anyone ever automate the failover to a standby database? All code or a product, no human interaction? I got asked about the ability to failover to another database in 20 minutes. Which means new DB ...
    Dba DBADba DBA
    Dec 20, 2012 at 11:33 pm
    Dec 21, 2012 at 12:58 pm
  • Any of you guys use this pay site? I'm curious what your thoughts were? One of the excerpts came in handy last night while I researching a production problem and I thought it was an intriguing site - ...
    Christopher Taylor2Christopher Taylor2
    Dec 20, 2012 at 3:05 pm
    Dec 20, 2012 at 6:01 pm
  • So I received the following error moving a non-partitioned table to a partitioned one and now I have 2 tables in various states: ERROR at line 1: ORA-01442: column to be modified to NOT NULL is ...
    Christopher Taylor2Christopher Taylor2
    Dec 19, 2012 at 7:25 pm
    Dec 19, 2012 at 8:54 pm
  • Something seems amiss here CPU - 80 and Cores - 40? Host Name racdb2.mwallet.ccd.infosys.com Platform Linux x86 64-bit CPUs 80 <-- Cores 40 <-- Sockets 4 Memory (GB) 127.53 Thanks PB Singh  Consider ...
    Pratap Singh -X (prsingh1 - ABACUS BUSINESS SOLUTIONS INC at Cisco)Pratap Singh -X (prsingh1 - ABACUS BUSINESS SOLUTIONS INC at Cisco)
    Dec 17, 2012 at 5:37 pm
    Dec 19, 2012 at 5:26 am
  • Hi all, with every AWR snapshot I get "ORA-00001: unique constraint (SYS.WRH$_MUTEX_SLEEP_PK) violated" which generates trace file and core dump. I' aware that this error is not dangerous but in 3 ...
    Marko SuticMarko Sutic
    Dec 9, 2012 at 9:39 am
    Dec 9, 2012 at 8:33 pm
  • All, Can anybody let me know the difference for the internal mechanism on parallel update and serial update When I run serial update Oracle can't offload the statement (I assume this is due to ...
    Coskan gundogarCoskan gundogar
    Dec 9, 2012 at 9:44 am
    Dec 9, 2012 at 1:47 pm
  • (Testing the GMAIL mobile interface to see if the formatting comes out right - if it doesn't my apologies!) Ok guys, I have this SQL INSERT query I've been working on. This large table is slated to ...
    Chris TaylorChris Taylor
    Dec 5, 2012 at 3:58 pm
    Dec 5, 2012 at 4:16 pm
  • Guys/Gals, Here are a couple of scripts (very rough probably - but hey, I'm proud of them). The first is a pretty standard view - it limits the query time range to a specific window of 12am to 5am ...
    Christopher Taylor2Christopher Taylor2
    Dec 1, 2012 at 1:40 am
    Dec 1, 2012 at 3:19 pm
  • Hi list, have anyone seen something like this? We have a Perl+C application connecting to Oracle; it uses DBD::Oracle and OCI (although it does not seem to actually use OCI in this case). It runs ...
    Vít ©pinkaVít ©pinka
    Dec 17, 2012 at 10:54 pm
    Jan 14, 2013 at 10:51 pm
  • Hi All, I am facing a problem while droping a partition of a partitioned table when the table contains nested columns. Can anyone suggest me how to drop this partition. I am getting following error ...
    Abhishek GurungAbhishek Gurung
    Dec 21, 2012 at 7:16 am
    Dec 23, 2012 at 9:00 pm
  • To invoke AGCTL interface do i need to install xagpack.zip package? Please advise. My database is in environment and i need to setup GG in oracle grid infrastructure for automatic ...
    Nagaraj SNagaraj S
    Dec 17, 2012 at 8:22 am
    Dec 20, 2012 at 6:34 am
  • I tested reproducing block cleanout process for queries using smart scan and confirm that full cleanout's are happening at the storage cell level and there is absolutely no redo generated for it, ...
    Saibabu DevabhaktuniSaibabu Devabhaktuni
    Dec 13, 2012 at 8:32 am
    Dec 17, 2012 at 9:21 am
  • Hi, I would like to know what type of strategy is been use by other DBA's for Making backups of Production DB which are in Terra bytes. Please let me know your inputs. Thank you. Regards, Sheldon. -- ...
    Sheldon QuinnySheldon Quinny
    Dec 12, 2012 at 6:43 am
    Dec 12, 2012 at 6:48 pm
  • Spent several hours on this today... an ORA-1445 "cannot select ROWID from, or sample, a join view without a key-preserved table" in one environment but not another on (what we thought) were the same ...
    Tornblad, JohnTornblad, John
    Dec 7, 2012 at 1:07 am
    Dec 7, 2012 at 4:16 pm
  • Good day, I am hoping that some kind soul who is uber awesome at tracking down pl/sql and PGA issues will be able to help us out on this one. :) *Basic Environment:* - Oracle HTTP Server (Fusion ...
    Charles SchultzCharles Schultz
    Dec 7, 2012 at 3:43 am
    Dec 7, 2012 at 1:34 pm
  • Does anyone have experience or recommendations for benchmarks that are cross database compatible? I've been using Swingbench to do performance comparison between physical and virtual databases at ...
    kyle Haileykyle Hailey
    Dec 5, 2012 at 9:02 pm
    Dec 7, 2012 at 2:44 am
  • Hi! I would be thrilled to hear your comments about a little something I wrote. BASH is meant as a drop-in replacement for ASH - mainly when a Diagnostic Pack license is not available. More ...
    Marcus MönnigMarcus Mönnig
    Dec 28, 2012 at 7:07 pm
    Dec 30, 2012 at 10:44 am
  • Hello, Oracle University just released a 1-day Real-World Performance Training On Demand (TOD) seminar ...
    Jenny Tsai-SmithJenny Tsai-Smith
    Dec 18, 2012 at 7:54 pm
    Dec 28, 2012 at 8:30 am
  • Performance is the price paid for protection. Thank you everyone for you assistance and guidance. Summary of changes made: Create PK REVERSE index PCTFREE 20 INITRANS 8 to reduce LATCH.cache buffers ...
    Michael DinhMichael Dinh
    Dec 28, 2012 at 5:29 am
    Dec 28, 2012 at 6:13 am
  • Hello We have a RAC database with 2 nodes. One of the nodes have some OS errors, and we are thinking of reinstall it. Our main concern is if its is possible to deletenode, reinstall the ...
    Ricard MartínezRicard Martínez
    Dec 21, 2012 at 2:42 pm
    Dec 26, 2012 at 9:57 pm
  • Oracle 11g redhat linux. This gets sporadic mentions in forum. Process seems to get stuck / fail when a truncate table is done in a procedure using execute immediate. Anyone else seen this or fixed ...
    Howard LathamHoward Latham
    Dec 14, 2012 at 8:18 pm
    Dec 14, 2012 at 9:13 pm
  • Hi , I have a two node RAC on RHEL. I saw the following in my AWR in terms of configurations. Though the number of cores are same, the number of CPUs are different. Will it make any difference in ...
    Nisha MohanNisha Mohan
    Dec 13, 2012 at 6:32 am
    Dec 13, 2012 at 2:08 pm
  • Hi All, We scheduled to collect statistics on every Sunday. With Oracle10g we always create partitions (range by date column) for the whole year up front.we pre-seed statistics to a partition(using ...
    Dec 5, 2012 at 5:16 pm
    Dec 5, 2012 at 6:34 pm
  • Hi, I'm having a problem when export/import a schema from a oracle instance to another, source is under linux and target is under aix. It happens while importing process with the ...
    Dec 5, 2012 at 9:51 am
    Dec 5, 2012 at 4:23 pm
  • Hello all, we are trying to monitor the usage of certain indexes by checking v$segment_statistics on a regular basis. But unfortunately not all of them have an entry in the view, even though they ...
    Thomas KellererThomas Kellerer
    Dec 4, 2012 at 3:44 pm
    Dec 4, 2012 at 4:46 pm
Group Navigation
period‹ prev | Dec 2012 | next ›
Group Overview
grouporacle-l @

116 users for December 2012

Christopher Taylor2: 21 posts Saibabu Devabhaktuni: 11 posts kyle Hailey: 10 posts Mark W. Farnham: 10 posts Michael Dinh: 9 posts Patterson, Joel: 9 posts Jared Still: 8 posts Tim Gorman: 8 posts Norman Dunbar: 7 posts Andrew Kerber: 6 posts David Fitzjarrell: 6 posts Kevin Closson: 6 posts Paresh Yadav: 6 posts Steve Wales: 6 posts Walker, Jed S: 6 posts Grabowy, Chris: 5 posts Niall Litchfield: 5 posts Bobby Curtis: 4 posts Chris Taylor: 4 posts Igor Neyman: 4 posts
show more