FAQ

Oracle > oracle-l > March 2010

Search Discussions

133 discussions - 521 posts

  • Hello I take a base backup on Sunday and take differential incremental backups every night and I want to perform recovery on Friday. Will I be able to apply backups up to Wednesday night SCN and open ...
    Orlando LOrlando L
    Mar 18, 2010 at 4:57 am
    Mar 23, 2010 at 2:38 am
  • We are upgrading an application to the current version and also upgrading the DB version from 9i to 10g. The application code has several bits of code that are explicitly setting RULE mode. One in a ...
    Jeffrey ZollarsJeffrey Zollars
    Mar 15, 2010 at 7:21 pm
    Mar 17, 2010 at 1:31 pm
  • Oracle Admins, I've been an AIX Admin for years, I'm a junior Oracle DBA and I apologize if the ASM Topic has come up lately. As an AIX Admin, using filesystems seems the best option for me. Reading ...
    Patrick obrienPatrick obrien
    Mar 5, 2010 at 10:44 pm
    Mar 9, 2010 at 10:52 am
  • Oracle 11gR2, running on an Amazon CentOS Linux instance. In order to use Amazon's snapshot feature for backups, I have a nightly script that executes "alter database begin backup", takes the ...
    Janine SiskJanine Sisk
    Mar 15, 2010 at 8:15 pm
    Mar 16, 2010 at 4:09 pm
  • Hello Oracle users, is it possible to flashback a database then turn around and roll it forward using a pitr process? thank you! -- http://www.freelists.org/webpage/oracle-l
    Patrick O'BrienPatrick O'Brien
    Mar 3, 2010 at 3:29 pm
    Mar 4, 2010 at 3:15 pm
  • Platform: IBM z9 OS: SUSE10 Oracle: 10gR2 Management is under the mistaken impression that the performance problems we are experiencing on a daily basis ALWAYS happen at the same time. To that end, ...
    Sandra BeckerSandra Becker
    Mar 3, 2010 at 8:54 pm
    Mar 11, 2010 at 5:32 am
  • Anyone else having the problem that documents once found on OTS are then blank??? Example, try looking for document id 409044.1. Dick Goulet Senior Oracle DBA/NA Team Lead PAREXEL International 900 ...
    Goulet, RichardGoulet, Richard
    Mar 15, 2010 at 2:04 am
    Mar 16, 2010 at 5:54 pm
  • Thought this was might be of interest. http://blogs.oracle.com/otn/2010/02/pssst_wanna_be_the_honorary_ci.html Chris Taylor Sr. Oracle DBA Ingram Barge Company Nashville, TN 37205 Office ...
    Taylor, Chris DavidTaylor, Chris David
    Mar 2, 2010 at 7:25 pm
    Mar 9, 2010 at 10:36 pm
  • select 1 from dual; is pretty fast. perhaps you'd like to set some boundaries. -- Niall Litchfield Oracle DBA http://www.orawin.info -- http://www.freelists.org/webpage/oracle-l
    Niall LitchfieldNiall Litchfield
    Mar 11, 2010 at 8:30 pm
    Mar 13, 2010 at 2:01 am
  • Any favorite resources out there for deciphering these reports? For 8i/9i I used the excellent breakdown in Tom Kyte's "expert one on one" book, but it is failing me now; too much has changed. i ...
    Janine SiskJanine Sisk
    Mar 9, 2010 at 5:26 am
    Mar 23, 2010 at 3:12 am
  • How do you measure the cost of a datafile autoextending? thanks. Hotmail: Trusted email with powerful SPAM protection. http://clk.atdmt.com/GBL/go/210850553/direct/01/ -- ...
    Joe SmithJoe Smith
    Mar 13, 2010 at 7:38 pm
    Mar 16, 2010 at 7:47 am
  • This is a 9i database: SQL show parameter user_dump_dest NAME TYPE VALUE ------------------------------------ ----------- ------------------------------ user_dump_dest string ...
    Roger XuRoger Xu
    Mar 18, 2010 at 7:41 pm
    Mar 24, 2010 at 6:06 am
  • Good Day Oracle DBA's, I want to copy my Oracle 11.2.0.1.0 DB/Instance on my AIX Server to the same server. The biggest obstacles I am having at the moment is the putting together the correct ...
    Patrick obrienPatrick obrien
    Mar 17, 2010 at 4:39 pm
    Mar 22, 2010 at 12:09 pm
  • 10.2.0.4 Red Hat Linux I found a very simple query that is consuming a ton of I/O resources. Depending on the bind value, the query should be using an index. I've set the statistics_level to 'ALL' in ...
    Stephens, ChrisStephens, Chris
    Mar 16, 2010 at 7:58 pm
    Mar 17, 2010 at 5:57 pm
  • If I run a single-node RAC cluster, do I actually need to purchase a RAC license, or will a Oracle Enterprise license be sufficient ? -- http://www.freelists.org/webpage/oracle-l
    Crisler, JonCrisler, Jon
    Mar 9, 2010 at 10:05 pm
    Mar 11, 2010 at 1:45 am
  • Hi list, i ran some tests with a default installation of 11.2 GRID on RHEL5 64bit, ocr and votingdisks are in ASM. while running some storage failure scenarios i've somehow managed to corrupt the ASM ...
    Andreas PieskAndreas Piesk
    Mar 4, 2010 at 10:15 pm
    Mar 5, 2010 at 11:06 pm
  • Hi list, Can anyone recommend any good books/sites for Oracle Financials? -- http://www.freelists.org/webpage/oracle-l
    James AkinsJames Akins
    Mar 3, 2010 at 3:30 am
    Mar 4, 2010 at 12:53 am
  • Hi Everyone, Kinda off topic. We are installing a new compiler for Cobol Microfocus on our HP-UX 11.23 and Oracle 11.1.0.7 We are on Itanium 64 bit. We have the option of installing 32bit or 64 bit ...
    Lyallbarbour_at_sanfranmail.comLyallbarbour_at_sanfranmail.com
    Mar 19, 2010 at 1:08 pm
    Mar 19, 2010 at 2:12 pm
  • Looking for your opinion, advice, good/bad/otherwise. thanks, joe Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead (Work) 614-677-1668 (Cell) 614-312-6715 -- ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Mar 17, 2010 at 1:22 pm
    Mar 19, 2010 at 2:09 pm
  • Thomas, Is aq_tm_processes 0; make sure you are issuing a commit after the enqueue; and check your alert logs for any errors. Rgds Mark Teehan Singapore From: oracle-l-bounce_at_freelists.org On ...
    Teehan, MarkTeehan, Mark
    Mar 11, 2010 at 1:11 am
    Mar 17, 2010 at 1:50 am
  • 1-) Did anyone try oswatcher with their RAC installation? Any pros / conns? Reliable? 2-) I guess the first question should have been: Did anyone managed to find Oswatcher on Oracle downloads? It ...
    Ozgur OzdemirciliOzgur Ozdemircili
    Mar 15, 2010 at 3:59 pm
    Mar 16, 2010 at 10:06 am
  • OK, I know this question has been asked a couple of million times, so anyone with an answer please contact me off the list. But I need a tool that can do a stress test on a database with multiple ...
    Goulet, RichardGoulet, Richard
    Mar 12, 2010 at 7:07 pm
    Mar 14, 2010 at 8:05 am
  • Again, got caught by overquoting..;) Original Message -------- Subject: Re: execute immediate parsing update Date: Wed, 03 Mar 2010 09:34:03 +1000 From: De DBA To: ujang.jaenudin_at_gmail.com CC ...
    De DBADe DBA
    Mar 2, 2010 at 11:55 pm
    Mar 3, 2010 at 4:55 pm
  • Hi, No the problem didnt resolve but since I needed to do something very urgently, I reverted the 8k thing after reading all that which Tom Kyte has written and some of you suggested as well. So now ...
    Saad KhanSaad Khan
    Mar 1, 2010 at 3:30 pm
    Mar 2, 2010 at 2:39 am
  • The incremental backup topic raises an interesting question for me. I am yet to appreciate the usefulness of incremental backups. I always use a periodic(daily or weekly) fullback and rely on ...
    Pani BabuPani Babu
    Mar 19, 2010 at 12:09 pm
    Mar 22, 2010 at 5:52 pm
  • we have ORACLE 10.2.0.4 on UNIX system. Recently one of our databases has ORA-0155 error happen several times. this database already setup: undo_retention = 20000 undo data file size current is 9 GB ...
    Dba1 mccDba1 mcc
    Mar 16, 2010 at 11:48 am
    Mar 17, 2010 at 3:09 pm
  • Are you using GNS so you can push/pull nodes easily? thanks, joe Joe Testa, Oracle Certified Professional Senior Engineering & Administration Lead (Work) 614-677-1668 (Cell) 614-312-6715 -- ...
    TESTAJ3_at_nationwide.comTESTAJ3_at_nationwide.com
    Mar 9, 2010 at 5:15 pm
    Mar 10, 2010 at 7:34 pm
  • List, I'm trying to locate the Oracle desupport list. Specifically I'm trying to see if a desupport date has been announced for 10g database. I've searched Metalink, but must be using the wrong ...
    Dennis WilliamsDennis Williams
    Mar 5, 2010 at 9:11 pm
    Mar 6, 2010 at 10:12 am
  • Version 10.2 I am trying to clean up our sys.aud$ table. I want to clean slate our auditing and start over. I don't want to disable auditing with the audit_trail parameter. I just want to noaudit ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    Mar 5, 2010 at 12:41 pm
    Mar 5, 2010 at 5:20 pm
  • Hi all, I am kinda stuck here: trying to find 10.2.0.1 BASE for the Oracle Client for MAC OS X and cannot... I downloaded 10.2.0.4 version, but it has to be applied on 10.2.0.1 first, doesn't it? ...
    Masha GurenichMasha Gurenich
    Mar 2, 2010 at 6:01 pm
    Mar 3, 2010 at 12:19 am
  • Hi, I'm working on migrating large amounts of data from a DB2 database to an Oracle 10g database (10.2.0.1) Windows. Will eventually reside in an 11gR2 database (not sure about OS yes, I don't make ...
    S. Anthony SequeiraS. Anthony Sequeira
    Mar 17, 2010 at 1:46 pm
    Mar 21, 2010 at 11:34 am
  • I'm sure this topic has been brought up several times before. I'm looking for some documentation /advice for building a new Datawarehouse. It will have the nightly ETL feeds, denormalization, long ...
    Ravi GaurRavi Gaur
    Mar 17, 2010 at 5:43 pm
    Mar 19, 2010 at 1:17 pm
  • Hello every, Anyone can advise how to ban plsql developer connect to oracle? The plsql developer search widget may cause some ora-600 warning in alert log . So I want to ban any connection using ...
    MacleanMaclean
    Mar 18, 2010 at 2:47 am
    Mar 18, 2010 at 1:47 pm
  • Start by looking at v$SQL_shared_cursor to understand why your child cursors are not shareable. It's possible that it's due to stats generation, but there are many other possibities, and it would be ...
    Bobak, MarkBobak, Mark
    Mar 18, 2010 at 12:01 am
    Mar 18, 2010 at 12:46 am
  • Hi, How do you track the problems? It seems we had a problem with connecction pools of one of the Weblogic servers.My boss asked me if there was any problem with the DB.Now reviewing our Gridcontrol ...
    Ozgur OzdemirciliOzgur Ozdemircili
    Mar 3, 2010 at 11:02 am
    Mar 16, 2010 at 10:29 am
  • Does anyone know if a 64 bit db will sit happily on an existing 32 bit cluster? If so and I can't in principle see why not then it would make a nice migration path here -- ...
    Niall LitchfieldNiall Litchfield
    Mar 11, 2010 at 10:58 am
    Mar 12, 2010 at 7:42 am
  • Hi All, I am runing Oracle Enterprose Edition 10.2.0.4 on Windows 2003 Enterprise Edition 32 bit. Please help me understand the below line Correctly. Oracle Database 10g Enterprise Edition Release ...
    Blessing KamutandeBlessing Kamutande
    Mar 10, 2010 at 10:15 am
    Mar 11, 2010 at 11:35 pm
  • Our 32gb solaris 9 server running two instances of 10gr2 One small db to support OID (sga max size 288M, pga aggregate 32M) and one of our production dbs(6gb pga aggregate target, 12gb ...
    Neil KodnerNeil Kodner
    Mar 10, 2010 at 5:14 pm
    Mar 11, 2010 at 12:23 am
  • Dear DBA Our Environment had an incident and got an error message ORA-04031: unable to allocate 1048 bytes of shared memory We understand that it is because of SGA Fragmentation. How to Monitor the ...
    Mudhalvan MoovarkkuMudhalvan Moovarkku
    Mar 10, 2010 at 10:03 am
    Mar 10, 2010 at 10:31 am
  • Thanks Mark for the response. partitioning? Partition exchange? Nologging? NO to all the above questions =( We currently don't know what to partition, logging is required at the moment because of ...
    Michael DinhMichael Dinh
    Mar 4, 2010 at 8:55 pm
    Mar 7, 2010 at 6:45 am
  • Hi Any ideas on how to re-write this self join using Analytical functions SELECT tab2.col1, tab2.col2 sum(tab2.col3) count(*) FROM tab1,tab2 WHERE tab1.col1 = tab2.col2 AND tab1.col2 = tab2.col2 AND ...
    HrishyHrishy
    Mar 18, 2010 at 9:10 am
    Mar 19, 2010 at 12:45 am
  • Hi, How can I do for call an .sql script that is in the SO (host). Ex. I have the file c:\script.sql I would like to call this file via PL/SQL., only via PL/SQL. Consider that the SO can be : Windows ...
    Eriovaldo AndriettaEriovaldo Andrietta
    Mar 18, 2010 at 2:43 am
    Mar 18, 2010 at 2:02 pm
  • Juan, What you trying to do is illogical. Assume that you have 5 days of archive logs on disk but only backups of database files for the last 2 days. Of what purpose are the other three days ...
    Goulet, RichardGoulet, Richard
    Mar 17, 2010 at 1:29 pm
    Mar 18, 2010 at 5:13 am
  • Can anyone pull up doc id 763087.5 in MoS? I cannot using Firefox 3.6. No errors, but no document. Please respond back-channel to avoid cluttering up the list. Fun, fun, fun. -Chris Warticki :-) -- ...
    Sweetser, JoeSweetser, Joe
    Mar 16, 2010 at 3:58 pm
    Mar 16, 2010 at 4:24 pm
  • Hi, in one of our 2 node -RAC database in one node I observe Instance Efficiency Percentages (Target 100%) Buffer Nowait %: 92.30 Redo NoWait %: 100.00 Buffer Hit %: 218.12 In-memory Sort %: 100.00 ...
    K RK R
    Mar 13, 2010 at 8:15 pm
    Mar 15, 2010 at 8:22 pm
  • While doing DR rebuild ( physical standby ), after restoring standby controlfile in DR location, i am getting below error while restoring database. I took backup through RMAN ( hotbackup ) from ...
    Harshan eppuramHarshan eppuram
    Mar 15, 2010 at 11:11 am
    Mar 15, 2010 at 12:01 pm
  • Hi Brandon, The problem with this approach is this: One would need to retain all of AWR data for *just* the SQL and SQL plans. The other is this: A Dev/Test would run over a long period, with SQL ...
    John KanagarajJohn Kanagaraj
    Mar 11, 2010 at 11:37 pm
    Mar 12, 2010 at 4:37 pm
  • That should work fine if the database is not open (ie just mounted). Otherwise you may have to add a RECOVER DATABASE step. Also check for locations like FRA and log archive destinations, if they are ...
    Don SeilerDon Seiler
    Mar 11, 2010 at 7:17 pm
    Mar 12, 2010 at 8:21 am
  • Hi folks, it was an annoying experience, just in case you hit it: http://www.usn-it.de/index.php/2010/03/08/oracle-11g-adaptive-cursor-sharing-does-not-work-with-plsql/ As far as I know, there is no ...
    Martin KlierMartin Klier
    Mar 8, 2010 at 9:46 am
    Mar 8, 2010 at 10:44 am
  • Dear list, on one of my 10.2.0.4 databases, I suddenly can't display predicate informations of an execution plan any more. I tried with this script, as I always did: set timing on; set serveroutput ...
    Martin KlierMartin Klier
    Mar 4, 2010 at 8:33 am
    Mar 4, 2010 at 10:51 am
Mar 2010
123
Group Navigation
period‹ prev | Mar 2010 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions133
posts521
users182
websiteoracle.com

182 users for March 2010

Jared Still: 17 posts Niall Litchfield: 14 posts : 13 posts Yechiel Adar: 12 posts Goulet, Richard: 10 posts Janine Sisk: 10 posts Allen, Brandon: 9 posts Lyallbarbour_at_sanfranmail.com: 9 posts Andrew Kerber: 8 posts Guillermo Alan Bort: 8 posts Kathy duret: 8 posts Martin Berger: 8 posts Rich Jesse: 8 posts Robert Freeman: 8 posts Crisler, Jon: 7 posts De DBA: 7 posts Dunbar, Norman: 7 posts John Kanagaraj: 7 posts Karl Arao: 7 posts Michael Dinh: 7 posts
show more
Archives