FAQ

Search Discussions

171 discussions - 1,146 posts

  • Hi all, I have a 2 node 9i RAC primary (Win 2003), 9.2.0.6 mandated by the application. Have a physical standby 9.2.0.7. All appears to be going well, teething problems over (touch wood). The primary ...
    Tony SequeiraTony Sequeira
    Dec 5, 2006 at 10:09 pm
    Aug 21, 2007 at 5:17 pm
  • I was reading an article about the appropriate setting for db_file_multiblock_read_count. I'm on a HP-UX 11.11 64-bit system with Oracle 9.2.0.7.0. The original value was 16 and I bounced the ...
    Kevin LidhKevin Lidh
    Dec 8, 2006 at 8:46 pm
    Dec 14, 2006 at 6:38 pm
  • After having it set in our dev instances for a week, I raised our db_file_multiblock_read_count in production from 16 to 128 (based on documented 10046 traces). After getting tickets about certain ...
    Don SeilerDon Seiler
    Dec 19, 2006 at 6:44 pm
    Dec 21, 2006 at 7:47 pm
  • Fellas, here is my situation: We have upgraded 11i database from 9206 and 10.2.0.2. There are various complaints on performance. When I digged into it.. I found some init parameters whicha are ...
    MVRMVR
    Dec 23, 2006 at 2:37 pm
    Jan 2, 2007 at 3:20 pm
  • Hello again, everyone, Someone has just brought this up to my attention and I thought "What? Why haven't I heard of this?" Has anyone heard of this rumor? What version of Oracle are we talking about? ...
    Leng KaingLeng Kaing
    Dec 15, 2006 at 5:47 am
    Dec 22, 2006 at 2:16 am
  • Howdy listers, This is actually more of a Unix question, but it is also Oracle related and I know there are a lot of people on this list more experienced than I with Unix so I figured I'd give it a ...
    Allen, BrandonAllen, Brandon
    Dec 12, 2006 at 10:21 pm
    Feb 8, 2007 at 9:57 pm
  • Greetings, This is a question I have been looking at and puzzling over for a couple of days and am unable to explain, I'm hoping someone can help me understand what is going on. In a 9i database I ...
    William WagmanWilliam Wagman
    Dec 21, 2006 at 5:49 pm
    Dec 22, 2006 at 5:20 pm
  • I'm still googling for answers but it's looking like I won't be finding one, so time to ask here. I am working as a consultant with a 9.2.0.8 installation. I was present when it was installed and ...
    Janine SiskJanine Sisk
    Dec 6, 2006 at 10:14 pm
    Dec 8, 2006 at 9:58 pm
  • Hi Gurus, This seems very common issue but I am confronted with a requirement where we need to have 24x7 availability, no exceptions. There is no way we can have staging server (for patch testing ...
    Dhimant PatelDhimant Patel
    Dec 16, 2006 at 2:22 pm
    Dec 22, 2006 at 12:18 am
  • Any suggestions for a unix like 'time' command that can be used from the command line, just on unix/linux? I need to time some RMAN operations on Win32 box. I've already DL'd and looked at Windows ...
    Jared StillJared Still
    Dec 1, 2006 at 5:47 pm
    Dec 1, 2006 at 10:17 pm
  • Guys/Gals, I'm going to ask just to be sure I'm not totally dead. But does anyone know of a way to rename a schema without going thru the export/import or data pump process. I've a duhveloper who ...
    Richard J. GouletRichard J. Goulet
    Dec 15, 2006 at 3:53 pm
    Dec 15, 2006 at 11:08 pm
  • We have a huge table ( 160 million rows) which has about 20 million duplicate rows that we need to delete. What is the most efficient way to do this as we will need to do this daily? A single ...
    A EbadiA Ebadi
    Dec 12, 2006 at 10:31 pm
    Dec 14, 2006 at 7:47 pm
  • I have an opportunity to conduct a basic technical acceptance testing, lasting no more than 5 days, on a pre-prod environment. It consists of a 2-node 10gR2 patchset 1 RAC database hosted on SLES 9 ...
    Boris DaliBoris Dali
    Dec 27, 2006 at 4:27 pm
    Jan 15, 2007 at 2:20 pm
  • My system statistics are horribly out-of-date and I'd like to gather more current numbers. Just to give you a taste, my current production statistics have MBRC=5, SREADTIM=0.078, MREADTIM=0.065. I ...
    Don SeilerDon Seiler
    Dec 12, 2006 at 7:14 pm
    Jan 3, 2007 at 11:07 am
  • Hi, About to do: 2 Node RAC 10GR2 {10.2.0.2} on HP-UX (Serviceguard extensions for RAC will also be used) using ASM for database storage. I was wondering whether anyone has configured asm over slvm? ...
    Naqi MirzaNaqi Mirza
    Dec 27, 2006 at 8:25 pm
    Dec 28, 2006 at 8:14 pm
  • Afternoon (UK time) all, Oracle 8174. (I know, I know !) HPUX 11.11. I wonder if anyone has any clues about this problem that I'm seeing on one of my databases. There is a housekeeping packaged ...
    Norman DunbarNorman Dunbar
    Dec 20, 2006 at 1:57 pm
    Dec 21, 2006 at 10:01 pm
  • Hey, Just curious, anyone out there running 10gR2 RAC on top of Vertias even tho it hasn't been certified by Oracle....? From Veritas's website they support 10g but any idea when it may be certified? ...
    Best, DavidBest, David
    Dec 18, 2006 at 1:46 am
    Dec 19, 2006 at 8:27 pm
  • Folks, Sanity check question for those familiar with ZFS. Is there any reason, assuming all datafiles were on a single ZFS filesystem (which is the level of consistent snapshot granularity), that ...
    Donahue, AdamDonahue, Adam
    Dec 12, 2006 at 2:18 pm
    Dec 17, 2006 at 4:21 am
  • Hi, We are facing a serious performance issue. This is a delete statement and it takes 4 hours to delete 2.3 million rows from a 65 million row table. The c_trace table has only one index (the ...
    Don DooDon Doo
    Dec 21, 2006 at 5:46 pm
    Dec 22, 2006 at 11:46 am
  • Hi, Does anyone use 10gR2 Grid control for enterprise wide monitoring ? How reliable and stable it is ? we are in the process of currently evaluating the same (10gR2 grid on solaris 10) for ...
    PremPrem
    Dec 22, 2006 at 11:42 am
    Dec 23, 2006 at 10:57 am
  • Hello, I was playing around with SQL*Plus and found that I could include the host command in my scripts, being a UN*X person I styarted trying to get the result of some simple commands (pwd, ls, ...
    David MossDavid Moss
    Dec 15, 2006 at 9:27 am
    Dec 19, 2006 at 6:22 am
  • Trying to follow up on a bug in Metalink. 09/24/06 10:29 pm *** (CHG: Asg- NEW OWNER) 09/24/06 10:31 pm *** 09/24/06 10:43 pm *** 09/24/06 11:35 pm *** 09/25/06 12:02 am *** 09/25/06 07:10 pm *** ...
    Rajesh.Rao_at_jpmchase.comRajesh.Rao_at_jpmchase.com
    Dec 13, 2006 at 2:24 pm
    Dec 15, 2006 at 5:33 pm
  • I've got a client that is considering splitting devl/test and production at the DBA level. There are only about 8 Oracle folks, and that would put 6 on Production and 2 on test and there are about ...
    Michael KlineMichael Kline
    Dec 12, 2006 at 11:17 pm
    Dec 15, 2006 at 2:18 pm
  • Morning all, Does any-one know what the process queue reference latch does? I've never seen it pop up in my monitors, but this morning in one database it has an appalling miss rate: NAME WW IMM ...
    Tony van LingenTony van Lingen
    Dec 2, 2006 at 12:33 am
    Dec 6, 2006 at 8:57 am
  • Have people been using the incremental merge feature of rman successfully? It seems a little scary to me. Randy -- http://www.freelists.org/webpage/oracle-l
    Steiner, RandySteiner, Randy
    Dec 4, 2006 at 2:52 pm
    Dec 5, 2006 at 7:38 pm
  • Folks Does use of Multiple BLOCK sizes (for different Tablespaces) help in Performance of a Hybrid Application? Any best practices, Links, Docs? Thanks indeed CAUTION - Disclaimer ***************** ...
    VIVEK_SHARMAVIVEK_SHARMA
    Dec 19, 2006 at 10:40 am
    Dec 20, 2006 at 4:27 pm
  • We have an application that is consistently seeing this so-called "idle" wait: select user from dual call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ...
    Charles SchultzCharles Schultz
    Dec 19, 2006 at 9:04 pm
    Dec 20, 2006 at 2:34 pm
  • I am just curious to know the answer for these questions. which type of things you will analyze about the database from your previous dba...when he is leaving and you are coming into the picture? ...
    Murtuja KhokharMurtuja Khokhar
    Dec 15, 2006 at 7:17 am
    Dec 15, 2006 at 3:21 pm
  • Looking to hire a senior Oracle DBA with architecture experience. Must be able to obtain a US security clearance. No relocation. Work will be on a Federal contract. If you're interested and ...
    Thomas DayThomas Day
    Dec 4, 2006 at 2:58 pm
    Dec 5, 2006 at 7:31 pm
  • All: I'm getting the following error when attempting to invoke 10g OUI on a new Solaris 10 box. I connect to the new server via xhost +, ssh -X, and can invoke the standard xWindows utilities such as ...
    Jeffery ThomasJeffery Thomas
    Dec 27, 2006 at 2:14 pm
    Dec 27, 2006 at 5:54 pm
  • hello, i'd like to use rman to take cold and hot backups of a RAC database. how should i register the database in the rman catalog? do i register each instance of the RAC or just one instance and ...
    Haroon A. QureshiHaroon A. Qureshi
    Dec 18, 2006 at 4:42 pm
    Dec 22, 2006 at 10:30 pm
  • What is a good place to go to get information on the Oracle Apps technology stack? I'm thinking of the type of information that for the Oracle database is covered by the concepts manual (or by ...
    Moore, PaulMoore, Paul
    Dec 6, 2006 at 5:01 pm
    Dec 7, 2006 at 7:43 pm
  • We have a new version of an application which involves lots of changes to tables e.g. columns added, columns deleted, columns renamed, columns moved to new tables We needed to upgrade the live system ...
    John DunnJohn Dunn
    Dec 4, 2006 at 10:17 am
    Dec 5, 2006 at 12:00 pm
  • Hello, After 10g upgrade, one job started performing very bad, real slow. It used to complete in an hour and its taking around 4 hours now. I have checked wait history from ...
    MVRMVR
    Dec 28, 2006 at 8:14 pm
    Dec 31, 2006 at 11:15 am
  • Hey all, In our migration of a new ERP system in 10.2.0.2.0 on AIX, a user hit an ORA-7445 (with no parameters!). I file an SR, upload the resulting trace file, troubleshooting happens, and it's ...
    Jesse, RichJesse, Rich
    Dec 20, 2006 at 4:51 pm
    Dec 31, 2006 at 11:03 am
  • Hi, One of our developer has asked this question. "In our project we plan to drop some columns as we anticipate not to use these columns. We do not want to drop the columns completely out of the ...
    Oracle-l-bounce_at_freelists.orgOracle-l-bounce_at_freelists.org
    Dec 19, 2006 at 5:19 pm
    Dec 20, 2006 at 2:01 pm
  • Hi listers, I am looking for an example how to manipulate a histogram On a DATE column with DBMS_STATS. I have only found examples using VARCHAR and NUMBER types. Any pointers, links, articles, etc ? ...
    Milen KulevMilen Kulev
    Dec 10, 2006 at 8:59 pm
    Dec 14, 2006 at 10:30 pm
  • Hello listers. I have used histograms to imporve performance drastically on several earlier occassions on our DSS databases. But recently, it took me quite a while to determine that by removing ...
    Shivaswamy RaghunathShivaswamy Raghunath
    Dec 11, 2006 at 3:39 pm
    Dec 12, 2006 at 7:22 pm
  • does anyone know of a guide to Oracle's bug status codes? we have an open bug which has changed status a number of times - that is all we get to see. It would be *nice* to understand what stat 11 (or ...
    Niall LitchfieldNiall Litchfield
    Dec 6, 2006 at 10:52 am
    Dec 6, 2006 at 6:41 pm
  • Does the CBO use stats collected with "analyze table..." on LONG and LONG RAW columns? I think that the CBO only uses stats collected by dbms_stats. I have inheirted this shell script ( from ...
    Joe SmithJoe Smith
    Dec 13, 2006 at 5:25 pm
    Dec 19, 2006 at 3:05 pm
  • Hey all, I've finally succumbed to DBLINKs with the hope that it's the lesser of evils for our new ERP system. Since I won't have the time to test these out as much as I think they warrant, I'm ...
    Jesse, RichJesse, Rich
    Dec 15, 2006 at 6:39 pm
    Dec 18, 2006 at 10:10 am
  • If you have any Oracle Streams questions please let me know. I would be more than happy to share my experience. Thanks Sam Chakkanat http://www.cbenchusa.com -- ...
    Sam ChakkanatSam Chakkanat
    Dec 12, 2006 at 11:00 pm
    Dec 13, 2006 at 8:43 pm
  • if your task was to remove/mask sensitive data such as ssn/ccard numbers and those numbers are in multiple tables throughout your database, where would you start? if you are an oracle tool, what's ...
    Doug GernaatDoug Gernaat
    Dec 18, 2006 at 3:44 pm
    Dec 20, 2006 at 10:15 pm
  • Hello all, Please suggest some good books for RAC basics, mainly 10g RAC.Also advice on whether I should learn 10g DBA and go for 10g RAC, I am looking for 10g RAC installation and I need to ...
    AnandAnand
    Dec 12, 2006 at 1:25 pm
    Dec 15, 2006 at 12:19 am
  • Hi Again . When the dbase hangs the listener.log file shows the following errors : TNS-12547: TNS:lost contact TNS-12560: TNS:protocol adapter error TNS-00517: Lost contact 32-bit Windows Error: 54 ...
    Walid alkaakatiWalid alkaakati
    Dec 1, 2006 at 9:00 am
    Dec 12, 2006 at 9:56 am
  • Christian, I was reading your document "CBO - A Configuration Roadmap" . You write : "Histograms are essential for all columns referenced in WHERE clauses that contain skewed data. Notice that they ...
    Hemant K ChitaleHemant K Chitale
    Dec 28, 2006 at 4:12 pm
    Dec 29, 2006 at 8:00 pm
  • Folks Need to Run csscan Utility as Background processes because the LAN Network Connecting my PC to the SUN DB Server is somewhat Unstable. Can csscan be Run as a Background Unix Process or NOT? ...
    VIVEK_SHARMAVIVEK_SHARMA
    Dec 27, 2006 at 7:00 am
    Dec 27, 2006 at 4:32 pm
  • Hi, I am using log miner on 9.2.06. With DICT_FROM_ONLINE_CATALOG option since UTL_FILE is not set for flat file option. After start_logmnr what happens is it works for select sql_redo from ...
    A JoshiA Joshi
    Dec 22, 2006 at 8:55 pm
    Dec 23, 2006 at 6:10 pm
  • Folks Manually converted a Database from NON-RAC to RAC (2 instances) & Changed the "tnsnames.ora" file suitably. Yet connect VIA the Listener to this Database is failing. ERROR: ORA-12521 ...
    VIVEK_SHARMAVIVEK_SHARMA
    Dec 21, 2006 at 3:26 pm
    Dec 21, 2006 at 11:49 pm
  • Hello, I made an error initially when I sent the information re the clustering factor, here is the correct query... SQL select table_name,blevel,avg_data_blocks_per_key, 2 ...
    William WagmanWilliam Wagman
    Dec 21, 2006 at 6:58 pm
    Dec 21, 2006 at 9:07 pm
Group Navigation
period‹ prev | Dec 2006 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions171
posts1,146
users232
websiteoracle.com

232 users for December 2006

Kevin Closson: 56 posts Niall Litchfield: 30 posts Allen, Brandon: 28 posts Wolfgang Breitling: 25 posts Dennis Williams: 23 posts Jared Still: 21 posts Mark J. Bobak: 20 posts Oracle-l-bounce_at_freelists.org: 20 posts Christian Antognini: 19 posts Jesse, Rich: 19 posts Mercadante, Thomas F \(LABOR\): 19 posts Mladen Gogala: 19 posts Mladen Gogala: 18 posts Rjamya: 18 posts VIVEK_SHARMA: 18 posts Joel.Patterson_at_crowley.com: 17 posts Kerber, Andrew: 17 posts Alex Gorbachev: 16 posts Charles Schultz: 16 posts Mark W. Farnham: 16 posts
show more
Archives