Search Discussions

142 discussions - 714 posts

  • Hi I have a few direct load insert into 10 partitioned (and subpartitioned) tables, each partition is partitioned by hour and there are 8 hash subpartitions per partition. These processes runs in ...
    LS ChengLS Cheng
    Dec 19, 2009 at 7:58 am
    Dec 24, 2009 at 4:18 pm
  • I'm having trouble understanding FK's and NULL's. It appears I can insert a null value to a foreign key which is not what I would expect. Is the "solution" to put NOT NULL on the column definition? ...
    Sweetser, JoeSweetser, Joe
    Dec 15, 2009 at 9:22 pm
    Dec 23, 2009 at 4:55 pm
  • Hi everyone, The following simple join query on one of our business critical RAC databases with two instances was frequently leading into a dead lock situation ultimately a causing database hang ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Dec 15, 2009 at 7:22 am
    Dec 15, 2009 at 9:30 pm
  • Hi All, By using awk or any unix commands, can we change all ctl files .We have 25 such files which is subject to change. load data infile 'DATACITI_MASTER.dbo.aspc_defaultdb.dat' "str ''" into table ...
    Noor MullaNoor Mulla
    Dec 14, 2009 at 10:19 am
    Dec 17, 2009 at 9:16 am
  • Does anybody know how to make RMAN (delete obsolete) only deletes backupsets only (not archived log files)? Thank, Roger -- http://www.freelists.org/webpage/oracle-l
    Roger XuRoger Xu
    Dec 14, 2009 at 5:18 pm
    Jan 20, 2010 at 6:52 pm
  • Hi all - I am studying for the 10g OCP exam and came across a question that is incorrect in the book and wanted to know if it was just a typo or totally incorrect. Question: What is responsible for ...
    Bill ZakrzewskiBill Zakrzewski
    Dec 9, 2009 at 9:31 pm
    Dec 16, 2009 at 11:01 pm
  • Docs for the AUDIT statement are here http://download.oracle.com/docs/cd/E11882_01/server.112/e10592/statements_4007.htm#i2059073 This will allow you to capture DML against specific database ...
    Jared StillJared Still
    Dec 21, 2009 at 10:17 pm
    Dec 24, 2009 at 4:43 pm
  • Remember, if it's moving rows (and therefore, changing ROWIDs), it's also got indexes to update. So it could require significantly more UNDO than the size of the table. If you can afford the ...
    Adam MuschAdam Musch
    Dec 7, 2009 at 3:58 pm
    Jan 27, 2010 at 4:56 pm
  • Has anyone found native compiled PL/SQL code to be much slower than interpreted? Is this perhaps indicative that we have a setting screwed up somewhere? From what I read in the docs, native compiled ...
    Steve BaldwinSteve Baldwin
    Dec 23, 2009 at 7:48 pm
    Jan 4, 2010 at 1:34 pm
  • Hi all. Is there a guide or documentation on how to add and configure application server targets for monitoring on Grid Control? We'd like to add everything to one monitoring portal, but I can't find ...
    Domagoj SmoljanovicDomagoj Smoljanovic
    Dec 11, 2009 at 6:52 pm
    Dec 18, 2009 at 4:30 am
  • Hi group, I have to move a 10g ( application off a Solaris 10 machine (using ASM) to a Windows 2003 server (don't ask). The required application is only one smallish schema, so I'm going to ...
    Tony SequeiraTony Sequeira
    Dec 15, 2009 at 4:20 pm
    Dec 17, 2009 at 2:00 pm
  • Hi List, I need to move a database from Windows to HP-UX. What are my options besides exp/imp (datapump)? Source: Little Endian - Microsoft Windows IA (32-bit) Oracle Database 10g Enterprise Edition ...
    Roger XuRoger Xu
    Dec 11, 2009 at 3:50 pm
    Dec 14, 2009 at 12:43 pm
  • Really funny... http://www.dba-oracle.com/art_dbazine_what_kind_dba.htm All the best for 2010. David -- http://www.freelists.org/webpage/oracle-l
    David PintorDavid Pintor
    Dec 30, 2009 at 10:16 pm
    Jan 11, 2010 at 7:19 pm
  • All, In one of the database when I run the explain plan it takes a while before I get the plan output . so I created a index on statement_id . but still no luck. Anyone have any idea on how to ...
    K RK R
    Dec 17, 2009 at 3:25 pm
    Dec 18, 2009 at 6:39 am
  • 11


    Hi, I have couple of files (one like below as exmple) which needs to be compared using diff command. File a.txt Table_name row_count A 10 D 11 C 34 D 45 E 34 F 26 G 83 File b.txt Table_name row_count ...
    Noor MullaNoor Mulla
    Dec 21, 2009 at 11:36 am
    Dec 22, 2009 at 12:23 am
  • Hi, listers. Maybe someone here can see something obvious that I'm missing. The following message from Oracle Support refers to an SR that I really don't remember filing. I did, however, take ...
    Gus SpierGus Spier
    Dec 9, 2009 at 3:00 am
    Dec 11, 2009 at 6:13 am
  • Oracle EE OEL V4 64 bit. All, I am stumped by what has happened to the statistics for a table that I have that is range interval - list partitioned. I gather the stats like this ...
    Peter HitchmanPeter Hitchman
    Dec 10, 2009 at 2:20 pm
    Jan 18, 2010 at 12:48 pm
  • Listers, While configuring a monitoring server like Grid control server (or any other type), how much of High availability or redundancy factors should we consider. What happens when the monitoring ...
    Ram RamanRam Raman
    Dec 10, 2009 at 12:04 am
    Jan 11, 2010 at 2:05 am
  • Hello, A client is running an application that does high volume concurrent inserts ( 200million rows). Performance degrades with high buffer busy waits. The tablespace is ASSM managed, so we can't ...
    Haroon A. QureshiHaroon A. Qureshi
    Dec 17, 2009 at 5:46 pm
    Dec 22, 2009 at 7:28 pm
  • If i don't have the diagnostic pack, i can't even select from awr tables much less run an awr report without being in license violation? bah humbug. joe Joe Testa, Oracle Certified Professional ...
    Dec 11, 2009 at 5:50 pm
    Dec 12, 2009 at 9:41 am
  • Well, I've been doing a little soul searching, I've been studying computer engineering for a few years now. I don't like programming, I don't like project management... and that's about all they ...
    Guillermo Alan BortGuillermo Alan Bort
    Dec 7, 2009 at 9:40 pm
    Dec 9, 2009 at 6:23 pm
  • All, I am observing the date dimension table is giving high cpu cost and on explain table it seems to be a troubling spot . I am looking for any suggestion on what would be a better approach for ...
    Dec 8, 2009 at 7:17 pm
    Dec 9, 2009 at 3:16 am
  • They look the same to me, yes. As for your second question: I've never seen the CBO do transformations where subqueries in SELECT-clauses, are being 'pushed' into the underlying FROM-clause. I guess ...
    Toon KoppelaarsToon Koppelaars
    Dec 30, 2009 at 4:27 am
    Dec 30, 2009 at 7:47 pm
  • RAC. Looking to get more insight into this latch as I see seek to troubleshoot and check for co-relation to an issue with sessions experiencing "gc cr request" waits. Especially, what causes ...
    Rajesh RaoRajesh Rao
    Dec 16, 2009 at 2:27 am
    Dec 16, 2009 at 10:16 pm
  • 8


    I'm bringing myself up-to-date on the use of the Flash Recovery Area. We have a lot of databases on 9i where we were not using FRA. I'm experimenting with FRA in 11g to become more comfortable with ...
    Hostetter, Jay MHostetter, Jay M
    Dec 11, 2009 at 3:31 pm
    Dec 14, 2009 at 8:25 pm
  • Database on a 6 way RAC, each node has 16 CPUs. (That's all the info I have on the system, I'm working remote) Data collected from AUD$ via the DBA_AUDIT_SESSION view has the TIMESTAMP and ...
    Ric Van DykeRic Van Dyke
    Dec 28, 2009 at 7:48 pm
    Dec 31, 2009 at 2:27 pm
  • Greetings List, We have a physical standby running on a 4-node RAC. last night the apply instance (instance 1) had ora-04031 error and data guard broker changed the apply instance to be instance 2 ...
    Li LiLi Li
    Dec 22, 2009 at 7:26 pm
    Dec 23, 2009 at 9:09 pm
  • Standby database server: SUSE Linux Enterprise Server 10 (s390x) 0.2.5 (64-bit) Production database server: SUSE Linux Enterprise Server 10 (s390x) 0.2.5 (64-bit) EM: I'm ...
    Sandra BeckerSandra Becker
    Dec 22, 2009 at 9:47 pm
    Dec 23, 2009 at 5:54 pm
  • Hi All, I have Oracle 10g( on my local machine (Windows XP) . when ever i start the database on my machine it start throwing this Error. ORA-07445: exception encountered: core dump ...
    Balakrishna YBalakrishna Y
    Dec 22, 2009 at 8:08 am
    Dec 22, 2009 at 3:19 pm
  • Hi all, Could you let me know any good Oracle DBA blogs. (Not APPS DBA blogs). Just to read during free time... Thanks, -- Anurag Verma, Database Administrator ERCOT(Electric Reliability Council of ...
    Anurag VermaAnurag Verma
    Dec 17, 2009 at 12:13 am
    Dec 17, 2009 at 12:16 pm
  • So, we'll be moving to 11gR2 soon enough and at a local Oracle seminar a couple weeks ago, they had a white paper for upgrading to 11gR2.? Typical plans, things like that.? Oracle's RAT was talked ...
    Dec 15, 2009 at 8:19 pm
    Dec 16, 2009 at 6:51 am
  • Good morning, Background: Windows 2003 / Oracle 10g with auto undo (8K block size) We have only one datafile (20 GB) in the undo tablespace. When I ran RMAN backup of this datafile, it created a 20GB ...
    Roger XuRoger Xu
    Dec 15, 2009 at 4:20 pm
    Dec 15, 2009 at 7:35 pm
  • RMAN full resync of recovery catalog hangs When I check in the catalog database the session is waiting for SQL*Net message from client. This was happening on the old catalog. I created a new catalog ...
    Steve HarvilleSteve Harville
    Dec 8, 2009 at 2:22 pm
    Dec 9, 2009 at 9:50 pm
  • Looks like an Oracle internal message when trying to access http://asktom.oracle.com: Oracle Corp Website Unavailable The website you are trying to access is currently unavailable Please visit the ...
    Rich JesseRich Jesse
    Dec 4, 2009 at 4:17 pm
    Dec 4, 2009 at 8:22 pm
  • What are the risks of NOT including archivelogs as part of the RMAN routine backups? I have been tasked with reducing our backup sizes and was asked if we had to include archivelogs in our backups. I ...
    Taylor, Chris DavidTaylor, Chris David
    Dec 2, 2009 at 4:56 pm
    Dec 2, 2009 at 11:24 pm
  • All - I was just given a database to maintain on Windows, does anyone have a basic RMAN backup script that I can alter to automate an RMAN backup on Windows? I usually work on Linux or Unix and not ...
    Bill ZakrzewskiBill Zakrzewski
    Dec 1, 2009 at 3:03 pm
    Dec 2, 2009 at 1:04 am
  • Can someone please confirm to me whether I'm going crazy or not by looking at document 465968.1, step 11, substeps 4 and 7, and see if it looks like Oracle left out exactly what sql script to run in ...
    Rich TylkaRich Tylka
    Dec 24, 2009 at 5:29 pm
    Dec 29, 2009 at 9:38 am
  • All, First off, Merry Christmas, Happy Hanukah, Happy Kwanza, etc... to one and All. I'm trying to track down a perception that some of our developers have that there is no longer, post Oracle 10g ...
    Goulet, RichardGoulet, Richard
    Dec 23, 2009 at 6:31 pm
    Dec 23, 2009 at 7:10 pm
  • Hi List, Quick Q: We've a dataguard physical standby that we cloned, and the clone bonked on: GATHER_STATS_JOB encountered errors. Check the trace file. Errors in file ...
    Newman, ChristopherNewman, Christopher
    Dec 17, 2009 at 7:31 pm
    Dec 19, 2009 at 4:50 pm
  • Greetings listers, I am trying to justify locking the developers out of our production database but I need your help. We just moved to a new landscape because the developers had horked up the last ...
    Blanchard, WilliamBlanchard, William
    Dec 16, 2009 at 4:57 pm
    Dec 16, 2009 at 8:21 pm
  • Dateline September 21, 2009, Larry Ellison rants against cloud computing: Â Â Â Â http://tinyurl.com/ybf2vbb December 15, 2009, I receive an email from "Oracle Cloud Computing" inviting me "to view a ...
    Rich JesseRich Jesse
    Dec 15, 2009 at 3:39 pm
    Dec 15, 2009 at 7:50 pm
  • I've been remiss in deleting old objects from my recycle bin. At this point I have over 2GB of objects in the recycle bin. I did 'purge dba_recyclebin' as sysadmin and now the recycle bin is empty ...
    Dec 8, 2009 at 8:11 pm
    Dec 9, 2009 at 7:48 pm
  • Profiler (and other similar products) are already used. Mrnl is not, though it would most certainly be useful. Aggregated unaccounted for time is known. What is being looked for by the "SA's" is ...
    Larry G. ElkinsLarry G. Elkins
    Dec 2, 2009 at 9:35 pm
    Dec 3, 2009 at 7:20 am
  • Hello all, and thanks in advance for your input on these questions. For those of you who are familiar with RAC, in your experiences, how often are the patches (include vulnerability patches) rolling ...
    Dec 17, 2009 at 8:40 pm
    Dec 19, 2009 at 1:38 pm
  • Hi, We have SQLLDR SHELL programs that are generated in which there is a line for each sqlldr load job. We need to monitor or check the results of each load job when it finishes to see if there were ...
    Noor MullaNoor Mulla
    Dec 14, 2009 at 6:35 am
    Dec 14, 2009 at 4:52 pm
  • Hi, I have a situation in which the application vendor is asking to increase the buffer cache size to resolve a performance issue, pointing to the advisories from the dbconsole. Although I have ...
    D'Hooge FreekD'Hooge Freek
    Dec 7, 2009 at 5:58 pm
    Dec 11, 2009 at 5:57 pm
  • Hi gurus, Linux Redhat: I mistakely ran a script and changed db passwords for all users. Is the only option here RMAN restore/recovery? Would point-in-time work, won't it? The database has ...
    Dec 9, 2009 at 12:56 am
    Dec 10, 2009 at 2:38 pm
  • Hi Listers, Is there any way to get the name of the current script being executed by sql*plus? For example.. I have the following levels of scripts ... Driver_Script.sql calls 2.....one.sql and ...
    Srinivas ChintamaniSrinivas Chintamani
    Dec 5, 2009 at 3:39 am
    Dec 6, 2009 at 8:04 pm
  • Hi With today multicore servers, parallel query is very important to get the max performance from a server. It´s common to see 16 core servers using only one of them… Do you put some little ...
    Juan MirandaJuan Miranda
    Dec 4, 2009 at 1:03 pm
    Dec 4, 2009 at 9:06 pm
  • Hi all, I working on Oracle Fin on 9.2 For some reason d/b generates almost 1G of arch logs per min. What may cause this? How do I find out what process is generating all these logs? I will have less ...
    Eugene PipkoEugene Pipko
    Dec 1, 2009 at 6:02 pm
    Dec 1, 2009 at 6:58 pm
Group Navigation
period‹ prev | Dec 2009 | next ›
Group Overview
grouporacle-l @

192 users for December 2009

Jared Still: 27 posts Mark W. Farnham: 22 posts Niall Litchfield: 21 posts Robert Freeman: 20 posts Greg Rahn: 19 posts Roger Xu: 19 posts Yong Huang: 17 posts Goulet, Richard: 15 posts Noor Mulla: 14 posts Kellyn Pedersen: 13 posts Allen, Brandon: 12 posts Guillermo Alan Bort: 12 posts Marcin Przepiorowski: 12 posts K R: 11 posts LS Cheng: 11 posts Troach_at_gmail.com: 10 posts Lyallbarbour_at_sanfranmail.com: 9 posts Martin Bach: 9 posts Rumpi Gravenstein: 9 posts Steve Baldwin: 9 posts
show more