FAQ

Search Discussions

137 discussions - 807 posts

  • Hi List, Bit defeatist and off-topic, I admit, but I'd like to hear what's the opinion on future of our profession and which way to go. My experiences: 1995 - Oracle DBA collegaue says: it will all ...
    Ranko MosicRanko Mosic
    Mar 4, 2008 at 2:25 am
    Mar 19, 2008 at 9:23 am
  • I've got a 9iR2 database on an AIX server which is currently experiencing some SAN problems. The SysAdmins have indicated that we need to move off the SAN for several days while they address the ...
    Greg NorrisGreg Norris
    Mar 11, 2008 at 1:18 pm
    Mar 27, 2008 at 9:15 am
  • We're using Swingbench to stress test an 8-node 10.2.0.3 RAC running on RH Linux (2.6.9-55.ELsmp x86_64). The total non-idle active sessions is between 200 and 300 (select count(*) from gv$session ...
    Yong HuangYong Huang
    Mar 17, 2008 at 7:04 pm
    Mar 26, 2008 at 9:18 pm
  • I have a statspack report with this line as one of the wait events: SQL*Net message to client 7,255,516 0 3 0 900.0 As you can see, the number of waits is very high, but the actual time is only 3 ...
    John SmithJohn Smith
    Mar 12, 2008 at 1:18 pm
    Mar 15, 2008 at 2:58 am
  • Hi All Lets assume that one of my datafile on the primary database has been corrupted in a datagaurd environment. Can i do these steps to recover the primary db. 1)On primary do RMAN sql 'alter ...
    HrishyHrishy
    Mar 3, 2008 at 2:18 pm
    Mar 15, 2008 at 6:54 pm
  • Source DB: Dell server, RHEL4, 12G RAM, Oracle 64 bit 9.2.0.8 SE1, little endian Target DB: IBM VM on series z9, SLES10, 4G RAM, Oracle 10.2.0.3 EE, big endian Database is just shy of 1 terabyte in ...
    Sandra BeckerSandra Becker
    Mar 25, 2008 at 11:56 am
    Mar 25, 2008 at 4:08 pm
  • <!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" Just attended a OU course in Performance Tuning. After hearing the explanation on incremental checkpointing, I still cannot understand ...
    Peter TeohPeter Teoh
    Mar 22, 2008 at 1:26 am
    Mar 28, 2008 at 4:22 am
  • Greetings, I have a 500GB production database running on Oracle 9i on Solaris . and now the Users Testing group wants to keep it in sync with production every night . So I am looking for any ...
    PrasadPrasad
    Mar 15, 2008 at 4:15 pm
    Mar 19, 2008 at 4:03 pm
  • Hi all, I'm wandering is possible to have different computers using the same disk groups in ASM without RAC? Even on different O/S ? The main idea is to define a share area for all the development ...
    Amihay GonenAmihay Gonen
    Mar 31, 2008 at 9:17 am
    Apr 5, 2008 at 7:34 pm
  • Hi all I read from somewhere, I think the wait interface book where it states that the number of clone copies of data block is governed by _DB_BLOCK_MAX_CR_DBA which is set to 6. If there will be ...
    AmonteAmonte
    Mar 24, 2008 at 12:10 am
    Apr 1, 2008 at 9:29 am
  • In the past 1 (or 2?) years, the quality of notes on MetaLink has significantly deteriorated. Some are outright misleading (and potentially dangerous to novice DBAs). However, in recent months, I ...
    Hemant K ChitaleHemant K Chitale
    Mar 25, 2008 at 2:27 pm
    Mar 31, 2008 at 11:20 am
  • Hi folks, After some tuning I went back to the developer and recommended a new super version, slightly changed and including a full and a parallel hint. The new query runs in 5 mins vs 68mins for the ...
    Tony AdolphTony Adolph
    Mar 27, 2008 at 1:41 am
    Mar 30, 2008 at 10:20 pm
  • I help support a 10.2.0.3 Database running on MS Windows Server 2003 SP1. Someone has some old performance scripts that displays the data dictionary hit ratio amongst others. This comes in in the mid ...
    Tony SequeiraTony Sequeira
    Mar 18, 2008 at 9:12 am
    Mar 23, 2008 at 5:10 pm
  • I've been tasked with building a 10gR1 RAC around 10.1.0.5. I have been reading the puschitz.com site and he uses RHEL 3 with a 2.4 kernel. Does anyone know if I can do this with RHEL or Oracle Linux ...
    Allan NelsonAllan Nelson
    Mar 20, 2008 at 1:25 pm
    Mar 20, 2008 at 5:43 pm
  • Is it possible to use OS authenticated accounts ( i.e. identified externally ) between two servers? I have a linux box with with an oracle client install and an aix server with EE installed. The ...
    Joe SmithJoe Smith
    Mar 4, 2008 at 1:54 am
    Mar 7, 2008 at 2:27 pm
  • A developer is trying to implement some search functionality in an apex application that searches across several different text columns in several different tables. The query is taking entirely too ...
    Stephens, ChrisStephens, Chris
    Mar 7, 2008 at 5:03 pm
    Mar 11, 2008 at 1:30 pm
  • Oracle 10.2.0.3, Enterprise Edition, on AIX 5.3. I am testing Oracle database backup and recovery on our development database using incremental backups. On disk I have an RMAN Incremental Level 0 ...
    Sam BootsmaSam Bootsma
    Mar 4, 2008 at 10:42 pm
    Mar 10, 2008 at 4:02 pm
  • A friend of mine is considering Unbreakable in his organization and wondered if I had heard of anybody using it in production. I personally haven't but was wondering if anyone on this list was using ...
    Kevin LidhKevin Lidh
    Mar 14, 2008 at 2:53 pm
    Mar 15, 2008 at 3:39 am
  • All, I am stumped. I am at a site where I did not do initial setup. Previous DBA departed. I have used export from Production & am trying to import into new test DB. I have ALTER SYSTEM SET ...
    Sol beachSol beach
    Mar 19, 2008 at 3:34 pm
    Mar 19, 2008 at 5:00 pm
  • 10

    LMTs

    CREATE TABLESPACE dataDATAFILE '/FS/data_s01.dbf' size 2000m autoextend on next 1m maxsize 12000m, '/FS/data_s02.dbf' size 2000m autoextend on next 1m maxsize 12000mEXTENT MANAGEMENT LOCAL UNIFORM ...
    Joe SmithJoe Smith
    Mar 10, 2008 at 2:30 pm
    Mar 11, 2008 at 8:30 pm
  • Listers, Is there any limit on the number of columns a BTree index can have, before it is considered a bad design. I see a need to build an index with almost 30 columns. Thanks -- ...
    Ram RamanRam Raman
    Mar 19, 2008 at 5:58 pm
    Mar 28, 2008 at 9:34 pm
  • All, After reading some of the posts on the "DBA Future" thread, it reminded me of the worse mistake I ever made as a DBA. Immediately after the incident I documented the actual recovery procedures ...
    David TaftDavid Taft
    Mar 19, 2008 at 3:21 pm
    Mar 21, 2008 at 2:23 pm
  • All, Does anyone have any white papers or step by step examples of setting up an Oracle 10G environment with a standby database that does not use Data Guard. This is for an Oracle 10G Standard ...
    Ronnie DoggartRonnie Doggart
    Mar 17, 2008 at 7:34 am
    Mar 18, 2008 at 4:06 pm
  • Swingbench is an excellent toolset and we are pushing our test rig by using it. However I am not sure how to tell when you have an optimum configuration or what a realistic throughput (TPM might ...
    John HallasJohn Hallas
    Mar 3, 2008 at 1:46 pm
    Mar 15, 2008 at 7:38 pm
  • Is it correct that upgrading from 9i to 10g will change the MV refresh behaviour. I checked in one forum that it will use delete command for complte refresh instead of Truncate. Has anybody seen this ...
    Sanjay MishraSanjay Mishra
    Mar 5, 2008 at 6:49 pm
    Mar 6, 2008 at 4:02 am
  • Our users have application data and programs such that, for testing, it is easier to set the OS clock back. So every morning, like the movie Groundhog Day, the QA servers have a sudo script to set ...
    Wittry, DanWittry, Dan
    Mar 25, 2008 at 7:49 pm
    Apr 17, 2008 at 11:04 am
  • Anyone know of an SMTP server that I can use with utl_mail? I've tried about 4 different ones (e.g. smtp.yahoo.com) that I have access too but I get errors. If I remember correctly this is because ...
    Robert FreemanRobert Freeman
    Mar 22, 2008 at 3:48 pm
    Apr 2, 2008 at 3:17 am
  • I'm curious what hints people use the most often tuning SQL statements and why. I'm been working on monitoring tools such as my free ASHMON sort of an OEM-lite and S-ASH packages and Acitve Session ...
    kyle Haileykyle Hailey
    Mar 31, 2008 at 10:46 pm
    Apr 2, 2008 at 2:51 am
  • Hi, could anybody explain to me why the execution plan of the select statement differs completly from the execution plan of the update statement? While the select statement uses a very good plan ...
    Michael SeiwertMichael Seiwert
    Mar 27, 2008 at 2:49 pm
    Mar 31, 2008 at 8:18 am
  • I am installing Oracle 10 on AIX 5.3 machine with 4GB RAM How much swap space should I configure? John Dunn Product Consultant Sefas Innovation Limited Direct Dial + 44 (0) 117 373 6122 www.sefas.com ...
    John DunnJohn Dunn
    Mar 27, 2008 at 9:17 am
    Mar 27, 2008 at 3:31 pm
  • Hi, please note: This is a recovery test problem, not a current production situation. (Not invented, though. I heard of somebody who actually had it in production. Don't know what they did about it.) ...
    Giantpanda_at_gmx.netGiantpanda_at_gmx.net
    Mar 27, 2008 at 11:19 am
    Mar 30, 2008 at 12:51 pm
  • Hi, While invoking opatch lsinventory . I get the below error Exception in thread "main" java.lang.NoClassDefFoundError: javax/xml/transform/Source at ...
    Shanmugam, DhandapaniShanmugam, Dhandapani
    Mar 26, 2008 at 3:35 pm
    Mar 26, 2008 at 4:18 pm
  • Whe Oracle 10 is installed there are a lot of users/schema created. Are there any it is safe to drop?...such as SCOTT...any others? John Dunn Product Consultant Sefas Innovation Limited Direct Dial + ...
    John DunnJohn Dunn
    Mar 7, 2008 at 9:48 am
    Mar 24, 2008 at 6:03 am
  • I;m trying to do an RMAN duplicate database to new host so target db is in nomount mode trouble is this gives blocked status from sqlnet. I have found stuff about dedicated connection in listener but ...
    Howard LathamHoward Latham
    Mar 13, 2008 at 2:29 pm
    Mar 14, 2008 at 2:37 pm
  • Few days back, I have borrowed the latest "Oracle Automatic Storage Management" book to read during the week-end and thought of writing review about ASM book. I did write previous about this book at ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Mar 6, 2008 at 3:06 pm
    Mar 7, 2008 at 8:07 pm
  • Greetings, I have installed Oracle 10.2.0.3.0 on a server running Centos 4, 2.6.9-67.0.4.Elsmp. This is a new server and installation. I am using the DBCA to create the database which initially will ...
    William WagmanWilliam Wagman
    Mar 6, 2008 at 9:30 pm
    Mar 7, 2008 at 5:02 pm
  • Solars Zones and Oracle......It's a whole new world for me. Any quick thoughts on this anyone? Pro's; Con's; GotYa's; Stability; Performance (CPU and I/O) hit; FYI's; Dynamic resizing issues; etc ...
    Brian MacLeanBrian MacLean
    Mar 2, 2008 at 5:55 am
    Mar 3, 2008 at 7:15 pm
  • Hi, I am trying to use parallel hint for the following query that uses a range partitioned table/local index. Partition pruning happens, however I am not able to get the PQO kick in. Oracle9i ...
    Arul RamachandranArul Ramachandran
    Mar 24, 2008 at 8:59 pm
    Mar 25, 2008 at 7:31 pm
  • Does this make sense: Incremental backups for database every day (based on block change tracking approach - new in 10G). Archivelogs are backed up everyday. Full cold backup on the weekend. Recovery ...
    Joe SmithJoe Smith
    Mar 14, 2008 at 7:16 pm
    Mar 14, 2008 at 9:20 pm
  • Hi, I have a new 11G RAC set-up to play with! We use TSM to do our backups and RMAN. I know that TSM associates backups with the client node from which they came. So: a) Where is the best place to ...
    Peter HitchmanPeter Hitchman
    Mar 5, 2008 at 11:39 am
    Mar 14, 2008 at 1:55 am
  • Hi all, We have been requested to come up with a solution for the following problem: We have a production system that is about 200Gb. We want to be able to build a parallel database that will ...
    Ram RamanRam Raman
    Mar 5, 2008 at 8:30 pm
    Mar 12, 2008 at 7:08 pm
  • Does anyone know when the 10.2.0.4 patchset of Oracle on Solaris SPARC 64-bit will be available to be downloaded. I was able to download the patchset for Linux x86 and Linux x86-64. Thanks, Sandra ...
    Arnold, SandraArnold, Sandra
    Mar 26, 2008 at 2:05 pm
    May 5, 2008 at 3:30 pm
  • Hi, while trying to reduce the amount of indexes created on some large tables in an OLTP system, I try to figure out which indexes get rarely and what the statements look like that use those ...
    Ralph GraulichRalph Graulich
    Mar 31, 2008 at 10:35 am
    Mar 31, 2008 at 2:48 pm
  • Hi all, While working with scheduler and external jobs on 11g (OS: RHEL 4 U6 - 64-bit) I have encountered the error: SQL exec DBMS_SCHEDULER.run_job('FTJOB'); BEGIN DBMS_SCHEDULER.run_job('FTJOB') ...
    Goran bogdanovicGoran bogdanovic
    Mar 27, 2008 at 2:05 pm
    Mar 31, 2008 at 8:36 am
  • Hello I plan to copy data from all tables to the new tables in new tablespace every night. Why? Old tablespaces will be purged every night and I have to have old date I think that I have two ...
    Wojciech SkrzyneckiWojciech Skrzynecki
    Mar 25, 2008 at 8:50 pm
    Mar 26, 2008 at 6:53 pm
  • While researching a problem we have I came across Note: *144808.1 it says in part.... * For the moment, do NOT use Expdp/Impdp when going to UTF8 or a other multibyte characterset on ALL 10g versions ...
    Sol beachSol beach
    Mar 18, 2008 at 9:49 pm
    Mar 23, 2008 at 8:36 am
  • Hi I have dumped a block and trying to see the data it contains, for the varchar2 it's quite simple we simply convert hex to ascii but for number I cant find a suitable way, does anyone know how to ...
    AmonteAmonte
    Mar 19, 2008 at 12:36 pm
    Mar 20, 2008 at 11:32 am
  • Running an RMAN Duplicate Database to another host (clone) with a different file structure. I'm on Oracle 9.2.0.7 and using a catalog. It's a 5.4TBDB, and the freakin' thing failed on the last 3 ...
    David BarbourDavid Barbour
    Mar 16, 2008 at 1:27 pm
    Mar 17, 2008 at 4:30 pm
  • We are just now starting the process of looking at RAC. So far, I am pretty much overwhelmed by all of the different acronyms, products, terms, etc. I am lost..... For those of you who are using RAC, ...
    Terrian, Thomas J Mr CTR DLA J6DIBTerrian, Thomas J Mr CTR DLA J6DIB
    Mar 11, 2008 at 6:11 pm
    Mar 12, 2008 at 1:14 pm
  • Probably a strange question, but does anybody have a PL/SQL package they'd be willing to share that creates a dBase IV file? My users want me to create a dBase IV file for them, so they can directly ...
    Bill FergusonBill Ferguson
    Mar 11, 2008 at 3:56 pm
    Mar 12, 2008 at 11:14 am
Group Navigation
period‹ prev | Mar 2008 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions137
posts807
users221
websiteoracle.com

221 users for March 2008

Jared Still: 34 posts Dan Norris: 17 posts Mark W. Farnham: 17 posts Niall Litchfield: 17 posts Howard Latham: 15 posts Stephens, Chris: 14 posts Bradd Piontek: 13 posts freek D'Hooge: 13 posts Hrishy: 13 posts Jeremy Schneider: 13 posts Yechiel Adar: 13 posts Andrew Kerber: 12 posts Greg Rahn: 12 posts Krish.hariharan_at_quasardb.com: 12 posts Peter Teoh: 12 posts John Hallas: 11 posts Mark Brinsmead: 11 posts Martin Klier: 11 posts Oxnard Montalvo: 11 posts Allen, Brandon: 10 posts
show more
Archives