Search Discussions

213 discussions - 1,222 posts

  • Greetings all, Summary I'm a newbie Oracle DBA in a new job [non-profit in a small town, life is like that sometimes;-) ]. I'm busting my butt reading up on everything I can, but there is one issue ...
    Aug 3, 2006 at 11:35 pm
    Aug 8, 2006 at 6:08 pm
  • OK, just starting a new job with more design than I have done in a while. Looking into things, I have been noticing that many tables have no PK. Some have a unique index, but not all. When I pointed ...
    Stephen AndertStephen Andert
    Aug 17, 2006 at 4:46 pm
    Aug 22, 2006 at 1:58 pm
  • So I made it back on the list, I have a question for you all about DB security. There seems to be a lot of talk about DB security, but not a lot of action. Is that true, and if it is true why don't ...
    Anjo KolkAnjo Kolk
    Aug 15, 2006 at 11:42 am
    Aug 17, 2006 at 9:30 pm
  • Hello everyone, Just wonder if you also can't connect to the Metalink? I am based in the UK and can't connect during last 1/2 hours. Is it planed downtime? Any ideas then it will be available again? ...
    Jurijs VelikanovsJurijs Velikanovs
    Aug 29, 2006 at 3:55 pm
    Aug 31, 2006 at 8:53 pm
  • Hi, In sql server we can use nolock hint to see the uncommitted data of the other sessions. Is their any equivalent hint for query in Oracle? Thanks --Harvinder -- ...
    Harvinder SinghHarvinder Singh
    Aug 10, 2006 at 5:31 pm
    Aug 15, 2006 at 1:27 pm
  • hi all, I have a question (may sound silly to some of you) : what are the different ways of checking if an oracle instance is up and running or not? what is the use of "sgadef" file and what is the ...
    Onkar N TiwaryOnkar N Tiwary
    Aug 29, 2006 at 3:16 pm
    Aug 30, 2006 at 1:28 pm
  • Hi I have TKPROFed some batch processes running in Oracle 8i. After upgraded to 9i I monitored the same batch processes and I notice Parsing has been reduced by 50% without changing any code. Does ...
    Aug 30, 2006 at 4:20 pm
    Aug 31, 2006 at 4:31 pm
  • I am trying to play around with reading the SGA using my own program, as popularized by Kyle Hailey and Miladin Modrakovic's papers and presentations. I am confused about where to find x$ksusecst ...
    Jeremiah WiltonJeremiah Wilton
    Aug 18, 2006 at 9:14 pm
    Aug 21, 2006 at 10:04 pm
  • Gurus, Is there a straight way of querying v$SQL* views in order to retrieve all queries made by a session including a recursive queries made by oracle on behalf of user. Assume that SID and SERIAL# ...
    Dhimant PatelDhimant Patel
    Aug 24, 2006 at 2:38 pm
    Aug 29, 2006 at 4:43 am
  • Does anyone actually have ASM "put to the test" as they say? Anyone have huge ASM extent pointer array areas within their shared pool? Anyone have "ORA-4031-creeping syndrome" ? For instance: select ...
    Kevin ClossonKevin Closson
    Aug 29, 2006 at 11:23 pm
    Sep 1, 2006 at 4:58 pm
  • Ever since moving to 9i and 10g databases in the last couple years, the most common performance problem I see is queries that are optimized by the CBO based on one set of bind variables, but ...
    Allen, BrandonAllen, Brandon
    Aug 24, 2006 at 6:51 pm
    Sep 28, 2006 at 5:21 am
  • Hi, I need some feedback on upgrading to 64-Bit. We are a state public health agency. My project team has proposed that during our regular server replacement cycle that our next purchase to replace ...
    Freeman, DonaldFreeman, Donald
    Aug 16, 2006 at 3:37 pm
    Aug 17, 2006 at 4:15 pm
  • We have ORACLE 9ir2 on DELL server. we normally keep two weeks RMAN backup on disks (include full and incremental). Due to database big, we plan to compress RMAN backup use "gzip". My questions are ...
    Dba1 mccDba1 mcc
    Aug 10, 2006 at 2:32 pm
    Aug 11, 2006 at 8:51 am
  • Hi all, I used to be a regular reader of this list, but work took me in another direction and I've been away the last few months. However, life is circular and so here I am back again with another ...
    Janine SiskJanine Sisk
    Aug 28, 2006 at 1:53 am
    Aug 29, 2006 at 5:17 pm
  • environment: Oracle EE 5.2 We had a bit of a scare a few weeks ago when RMAN reported a corrupt block during a backup. V$DATABASE_BLOCK_CORRUPTION had no data, a dbverify showed up ...
    Joe Armstrong-ChampJoe Armstrong-Champ
    Aug 15, 2006 at 1:57 pm
    Aug 15, 2006 at 7:08 pm
  • We have a system with swap less than half the size I would like, 5 GB swap with 8 GB real. Last week we started to run out of virtual memory while real memory usage was still low. There was only 400 ...
    David TurnerDavid Turner
    Aug 24, 2006 at 2:46 pm
    Sep 15, 2006 at 6:43 pm
  • Hi all. After a little research basically decided on advice from some good names the best way to load 4Tb of data unloaded from Informix (Client is migrating) is to use external tables. at the moment ...
    Aug 28, 2006 at 4:50 am
    Aug 30, 2006 at 3:30 pm
  • Hello List, Since migrated from 9i to 10g, we are facing few new issues. At our premises, we tend to bounce our database at week-end. In 9i, it was talking few minutes. But, in 10g Re2.10, it is ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Aug 11, 2006 at 3:04 pm
    Aug 11, 2006 at 9:53 pm
  • Hi, I am checking the Automatic Shared Memory feature and set the following 2 parameters in init.ora file and recreate the spfile and restarted the oracle: sga_max_size=943718400 sga_target=629145600 ...
    Harvinder SinghHarvinder Singh
    Aug 21, 2006 at 3:43 pm
    Aug 23, 2006 at 11:02 pm
  • Hi I was wondering what does LD_PRELOAD do in HP-UX? I understand more or less that it loads some specific shared library with dld.sl before searching SHLIB_PATH, am I correct? The problem I am ...
    LS ChengLS Cheng
    Aug 30, 2006 at 6:01 pm
    Sep 1, 2006 at 12:16 pm
  • Friends, I would like to go with shared Oracle home(10g RDBMS Home) for multiple databases. The question is about EM Configuration. Generally each database has got a seperate EM Port for "Database ...
    Aug 23, 2006 at 3:39 pm
    Aug 24, 2006 at 9:35 am
  • Good day, list, In light of Metalink note *377037.1* (*Selects Against ALL_SYNONYMS Perform Badly on 10g Release 10.2*), we have been tracking down why we have so many calls to all_synonyms in the ...
    Charles SchultzCharles Schultz
    Aug 23, 2006 at 3:20 pm
    Aug 23, 2006 at 4:53 pm
  • Our shop is new to large-scale datawarehouse projects. We are finding our current index maintenance strategy for nightly jobs to be unworkable, as it consists of dropping all indexes before the ...
    Aug 11, 2006 at 2:17 pm
    Aug 12, 2006 at 10:11 am
  • Hi, I am implementing a new oracle 10G environment and am undecided on the new feature "flashback recovery area". It looks as if it is just a quicker way to do PITR, am I correct? Or does it add to ...
    Zanen, dhr. J.A. \(Jack\) vanZanen, dhr. J.A. \(Jack\) van
    Aug 29, 2006 at 8:47 am
    Aug 29, 2006 at 9:41 pm
  • Good morning I am reading this list since long time, this is my first post. I know what's the purpose of open resetlogs. I am preparing for OCP, and I think I have to know not only how and when to ...
    Hanspeter FuchsHanspeter Fuchs
    Aug 22, 2006 at 5:34 am
    Aug 25, 2006 at 8:31 pm
  • We have an update statement that runs in 3 minutes with no trace or a level 1 trace, but ran for 2 hours and we killed it with a level 12 trace. we got 20,000 'direct path read temp ' waits, but ONLY ...
    Aug 22, 2006 at 5:09 pm
    Aug 23, 2006 at 12:36 pm
  • Run the following query, trying to build a dynamic sql statement, but CANNOT suppress the statement itself from spooling (Redhat EL 4/Ora 10.1.3): " set ECHO OFF set TERMOUT OFF set FEEDBACK OFF set ...
    Johan MullerJohan Muller
    Aug 14, 2006 at 6:50 pm
    Aug 16, 2006 at 12:27 pm
  • The subject line says it all. To install 9204 on RHEL4, you must install patch 4198954. This consists of 2 RPM files: compat-libcwait-2.1-1.i386.rpm compat-oracle-rhel4-1.0-5.i386.rpm Installing ...
    Jared StillJared Still
    Aug 12, 2006 at 12:41 am
    Aug 14, 2006 at 5:13 pm
  • On Windows 2003, how can you manually connect to the database and then start a database using a new pfile? I am used to UNIX and just being able to login to sqlplus as sysdba but that doesn't work on ...
    J. DexJ. Dex
    Aug 29, 2006 at 6:57 pm
    Aug 30, 2006 at 1:06 pm
  • Hi, I am doing Testing on Oracle 9i RAC databases now. Ours is a 2-node RAC on IBM HACMP with GPFS. The TNS entry on the client side, I use is given below: MYDB = (DESCRIPTION = (ENABLE=BROKEN) ...
    Anurag VermaAnurag Verma
    Aug 25, 2006 at 5:17 pm
    Aug 28, 2006 at 10:56 pm
  • Folks, Is there anyone using the "Maxtor OneTouch III FireWire drive" with Linux and 10G RAC? It seems that the Maxtor II FrieWire drives listed in document ...
    Hameed, AmirHameed, Amir
    Aug 24, 2006 at 6:24 pm
    Aug 27, 2006 at 1:38 pm
  • -- http://www.freelists.org/webpage/oracle-l application/ms-tnef attachment: winmail.dat
    John DunnJohn Dunn
    Aug 22, 2006 at 10:14 am
    Aug 22, 2006 at 2:03 pm
  • Hi please Is advisable to set dbwr_io_slaves to a value higher than 0 in a single cpu (normal pc having one hard disk) on microsoft windows 2000 xp or 2003, 10gr2. Some experience on using it, I had ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Aug 21, 2006 at 4:01 pm
    Aug 21, 2006 at 11:53 pm
  • As some of you will have picked up I am in a relatively new position. One of the things sadly lacking is any sort of pro-active monitoring routine. This is something that I want to introduce, but my ...
    Niall LitchfieldNiall Litchfield
    Aug 16, 2006 at 9:34 am
    Aug 19, 2006 at 1:20 pm
  • I am working on Siebel application and have found few stuff are working slow and doing detailed traces with Waits shows that only wait events are SQL*Net message to client' SQL*Net message from ...
    Sanjay MishraSanjay Mishra
    Aug 9, 2006 at 9:03 pm
    Aug 10, 2006 at 3:49 pm
  • Hi, We have installed on sun solaris 10 having 2GB RAM and 2GB swap file. In our system 4-5 application starts at same time and each requires about 180 connections to the database. So about ...
    Harvinder SinghHarvinder Singh
    Aug 25, 2006 at 8:24 pm
    Sep 3, 2006 at 1:43 pm
  • Folks For an upcoming High Hybrid Transaction Load Benchmark on RAC with Solaris 10/Oracle 10g, need to define the File system setup Qs Is QFS Certified for Solaris 10/Oracle RAC 10g? Qs If ...
    Aug 29, 2006 at 7:07 am
    Sep 1, 2006 at 1:12 pm
  • Hi List, I am really facing a very tough situation since three days. Our datawarehouse db, oracle 9i (9205, 1.6TB) on HP-SUPERDOME got crashed due to the filesystem corrupt. Unfortunately, all the ...
    Syed Jaffar HussainSyed Jaffar Hussain
    Aug 28, 2006 at 7:35 am
    Aug 30, 2006 at 7:32 pm
  • Friends, This is on oracle / AIX5.3L on IBM P595 machine which has got 64 CPUs and ~200G RAM. Export of a 100GB schema in this database takes 11+ hours. The reason export being slow, I feel, ...
    Aug 24, 2006 at 5:43 pm
    Aug 24, 2006 at 6:15 pm
  • Does anyone know of a way to invalidate or completely flush a single cursor? I'm doing some performance testing of queries that are having trouble with bind variable peeking and sharing plans between ...
    Allen, BrandonAllen, Brandon
    Aug 21, 2006 at 9:30 pm
    Aug 22, 2006 at 5:05 pm
  • Hi, I was wondering whether anyone has experienced poor backup times with oracle databases on RAID 5? We are using netbackup in conjunction with rman to backup a 1.5TB database that takes about 16 ...
    Naqi MirzaNaqi Mirza
    Aug 18, 2006 at 6:51 am
    Aug 21, 2006 at 10:21 am
  • Okay, I'm a little OLTP-slow, so please be patient with this issue. I've got a table that's used heavily in an OLTP manner, residing in a DW (really an ODS). It averages 21,000,000 logical reads per ...
    Herring Dave - dherriHerring Dave - dherri
    Aug 18, 2006 at 2:25 am
    Aug 18, 2006 at 11:02 pm
  • We have an issue where we need to drop and recreate tables, indexes, triggers, stored procedures, etc. The programmer involved has contacted me because they have to do this via a stored procedure ...
    Scott CanaanScott Canaan
    Aug 14, 2006 at 4:02 pm
    Aug 17, 2006 at 11:36 am
  • List, I have created a separate user, call it USER granted: sql grant connect, resource, dba to USER; then sql grant sysdba to USER; I can query v$pwfile_users and see USER in there as sysdba. So why ...
    Joe SmithJoe Smith
    Aug 15, 2006 at 1:41 pm
    Aug 16, 2006 at 9:55 am
  • I've looked at the documentation and I believe that I need Oracle 10g to use the mapping table with a partitioned IOT. I tried it with 9.2 and got "ORA-25182: feature not currently available for ...
    Thomas DayThomas Day
    Aug 14, 2006 at 3:57 pm
    Aug 14, 2006 at 6:09 pm
  • We have found that we do not always get the 10046 explain plan that gives us the LIO and PIO for each row source with a level 12 report. This is what we are doing. alter session set ...
    Aug 4, 2006 at 3:20 pm
    Aug 12, 2006 at 10:18 pm
  • Folks A 4-node RAC BIG benchmark with Oracle 10g / AIX 5.3L using a Hybrid Banking App. is underway. Qs1 Does Cache fusion(Traffic between the nodes thru the interconnects) continue to be an ...
    Aug 1, 2006 at 10:32 am
    Aug 10, 2006 at 6:10 pm
  • Hi List, How does a non-technical person access a 9i database in MS Access via ODBC? Thanks, Roger Xu This e-mail is intended solely for the person or entity to which it is addressed and may contain ...
    Roger XuRoger Xu
    Aug 9, 2006 at 5:01 pm
    Aug 10, 2006 at 1:29 pm
  • My friends, So they've asked me to provide a graph. On the Y axis is number of connections on the X axis is either queries or transactions per second. I plan on digging into the statspack tables, in ...
    Collier,Joshua W - JDDO-6Collier,Joshua W - JDDO-6
    Aug 2, 2006 at 9:09 pm
    Aug 3, 2006 at 4:19 pm
  • Hi, we all know to build large indexes using many fast methods like parallel, nologging, etc. how can i speed up dropping large local index partitions with sizes exceeding 400GB? it takes a couple of ...
    Anand RaoAnand Rao
    Aug 28, 2006 at 1:59 am
    Aug 29, 2006 at 6:29 pm
Group Navigation
period‹ prev | Aug 2006 | next ›
Group Overview
grouporacle-l @

239 users for August 2006

Jared Still: 53 posts Kevin Closson: 45 posts Niall Litchfield: 44 posts Allen, Brandon: 33 posts Charles Schultz: 31 posts Tanel Poder: 29 posts Bobak, Mark: 27 posts Anjo Kolk: 26 posts Rjamya: 23 posts VIVEK_SHARMA: 22 posts Christian Antognini: 21 posts Dennis Williams: 21 posts Jonathan Lewis: 16 posts Carel-Jan Engel: 15 posts LS Cheng: 15 posts Reidy, Ron: 15 posts Syed Jaffar Hussain: 15 posts David Sharples: 14 posts Mark Strickland: 14 posts Norman Dunbar: 14 posts
show more