FAQ

Search Discussions

158 discussions - 819 posts

  • I've read the tahiti doc of (nearly) the same name [0], but it really didn't do too much. I'm pretty sure I've posted about this but it's a high priority for me now. Sad story, short: my level 0 ...
    Don SeilerDon Seiler
    Nov 15, 2007 at 10:53 pm
    Mar 4, 2008 at 2:32 pm
  • I'm reading many hundreds of gigabytes from a 9iR2 database to a 10gR2 database through a database link. Some of the tables I am reading are rather wide, with average column lengths of between 500 ...
    David AldridgeDavid Aldridge
    Nov 7, 2007 at 5:52 pm
    Nov 26, 2007 at 11:14 pm
  • I've been reading through the Oracle PL/SQL Users Guide and Reference from various years and noticed that the 11g documentation seems to be "lightening up" a little. The jovial and personal tone ...
    J BuchananJ Buchanan
    Nov 4, 2007 at 6:27 pm
    Nov 7, 2007 at 10:03 am
  • Hey all, Using GC 10.2.0.3.0, has anyone customized the webpages? Specifically, I'm looking to reduce the refresh time on the "Top Activity" from 15 seconds to 30 and 60 for use over VPN. DB Control ...
    Rich JesseRich Jesse
    Nov 19, 2007 at 5:10 pm
    Nov 21, 2007 at 4:37 pm
  • Hi, I am using following command to delete files from o/s older than 24 hours. /usr/bin/find /u01/log/*.log -mtime +0 -exec ls -l {} \; Is there any way I can delete files older than 6 hours. I am ...
    Ajay ThotangareAjay Thotangare
    Nov 27, 2007 at 4:16 pm
    Aug 8, 2008 at 7:03 pm
  • Has anyone else tried setting this hidden parameter and found it didn't disable the HASH GROUP BY feature? It's suggested in Metalink 387958.1 as a workaround to the "wrong results" bug (4604970) ...
    Allen, BrandonAllen, Brandon
    Nov 29, 2007 at 10:10 pm
    Nov 30, 2007 at 7:19 pm
  • Hello, Now that Oracle has announced the "existence" of the Oracle VM "thing", do people think that this is actually useful to run your DBs on ? Personally I only see this as convenient way to run ...
    Nilo SeguraNilo Segura
    Nov 13, 2007 at 11:38 pm
    Nov 16, 2007 at 9:41 pm
  • I am writing a query that is grouping by 1 hour blocks over a period of time as follows I am pretty sure the answer involves using "where not exists", but I can't get the dates I want to return ...
    Ryan_gaffuri_at_comcast.netRyan_gaffuri_at_comcast.net
    Nov 27, 2007 at 3:31 pm
    Nov 27, 2007 at 10:46 pm
  • Hi, all. We had an event the other night that's baffling, and I'm hoping someone on here can help me figure out how to shed more light on it. Specifically, our Oracle (10G, 10.2.0.1.0, SLES 9 with ...
    Mason Loring BlissMason Loring Bliss
    Nov 29, 2007 at 4:18 pm
    Nov 30, 2007 at 6:20 pm
  • I'd like to lay bare some aspects of my instance and see what everyone thinks. I've recently been re-reading Kevin Closson's series on over-configuring DBWRs [0], and had some questions. First of ...
    Don SeilerDon Seiler
    Nov 28, 2007 at 6:59 pm
    Nov 29, 2007 at 5:59 pm
  • Greetings, We are looking at implementing dataguard, 10.2.0.3.0 Enterprise Edition Oracle on Red Hat Linux. The question has been raised as to whether the O/S version must be the same on the primary ...
    William WagmanWilliam Wagman
    Nov 19, 2007 at 8:19 pm
    Nov 21, 2007 at 11:54 pm
  • And now for Solaris, AIX and HP as well. Gints Plivna http://www.gplivna.eu 2007/10/26, Ted Coyle : -- http://www.freelists.org/webpage/oracle-l
    Gints PlivnaGints Plivna
    Nov 14, 2007 at 8:09 am
    Nov 15, 2007 at 4:30 pm
  • windows server 2000 oracle 8.1.7.4 onr local DNS doesn't seem to resolve some host names, so i changed the stanzas in tnsnames.ora to use the IP numbers. this works fine on my XP workstation and i ...
    Bill thaterBill thater
    Nov 8, 2007 at 7:33 pm
    Nov 9, 2007 at 4:19 am
  • i'm a unix guy not a windows guy. at the new job we use windows and 8.1.7. could someone point me at the FM that shows me how to create a service so i can get a database with files already in place ...
    Bill thaterBill thater
    Nov 2, 2007 at 2:53 pm
    Nov 2, 2007 at 9:30 pm
  • all, i have 2 nodes RAC 10.2.0.3 on UX in 8k blocksize, what is the best MTU size to be set? should I set 8k too? I have the problem with high disk utilization, which causing node eviction, the FC is ...
    Ujang JaenudinUjang Jaenudin
    Nov 15, 2007 at 5:11 am
    Nov 19, 2007 at 2:32 am
  • Hi List, I am maintaining above mentioned database. We will switch to automactic archive log transfer ( log_archive_dest_state_2 = ENABLE ). Until that happens archive logs are transferred using OS ...
    Ranko MosicRanko Mosic
    Nov 1, 2007 at 11:25 pm
    Nov 14, 2007 at 11:50 pm
  • I've got a RAC install where the Oracle session racgimon@ (TNS V1-V3) is generating ORA-25228 errors every 10 seconds. I know this because I've created an ON SERVERERROR trigger that writes ORA- ...
    Herring Dave - dherriHerring Dave - dherri
    Nov 7, 2007 at 11:37 pm
    Nov 13, 2007 at 4:44 am
  • morning everyone, Anyone out there familiar with setting up very big and very fast Oracle? If you could start from scratch, how would you architect your system? What are some of the options that ...
    RobynRobyn
    Nov 5, 2007 at 2:51 pm
    Nov 8, 2007 at 8:34 pm
  • Hi all, Can someone shed some light on how to tune this sql statement? Oracle version 10.2 SELECT T143.C1,C490021100,C1000000001,C200000020 FROM aradmin.T143 WHERE (((T143.C200000020 LIKE ('Eagle' || ...
    Robin LiRobin Li
    Nov 27, 2007 at 8:47 pm
    Nov 28, 2007 at 7:38 pm
  • Greetings, I am still trying to get my head around this issue of LOCAL_LISTENER & REMOTE_LISTENER parameters. I am running a two node RAC cluster on RHEL4, Oracle 10.2.0.3.0 EE. ASM and DBMS are ...
    William WagmanWilliam Wagman
    Nov 16, 2007 at 12:52 am
    Nov 19, 2007 at 11:06 pm
  • Hi, I need to move certain datafiles to another partition which is recently made available. I can move/rename files after taking them offline - although I would prefer if RMAN can do this while the ...
    Dhimant PatelDhimant Patel
    Nov 7, 2007 at 9:14 pm
    Nov 12, 2007 at 8:39 am
  • Anyone ever have problems where an agent starts uploading data with a bad COLLECTION_TIMESTAMP? We're getting ORA-14400 errors - "Inserted Partition Key does not map to any partition". The table ...
    Taylor, Chris DavidTaylor, Chris David
    Nov 7, 2007 at 2:21 pm
    Nov 8, 2007 at 1:27 pm
  • Folks, Is there is way to pass MRBC as a hint to a SQL statement? The DB is 10.2.0.2. I have tried /*+ (db_file_multiblock_read_count,16) */ but it did not work. May be it is not possible but I want ...
    Hameed, AmirHameed, Amir
    Nov 7, 2007 at 3:41 pm
    Nov 7, 2007 at 8:01 pm
  • Hi all, on a given server, with multiple db instances, is there a known method to see how much load individual db is putting on the system? when i say db, i mean who db, including all sessions, ...
    RjamyaRjamya
    Nov 21, 2007 at 8:07 pm
    Nov 23, 2007 at 2:58 pm
  • Hey all, Has anyone heard of CBO bugs on tables with 0 rows or a low row count (<6)? Appparently sub-optimal plans were generated causing performance issues. The solution was to delete statistics on ...
    Best, DavidBest, David
    Nov 29, 2007 at 8:00 pm
    Nov 30, 2007 at 2:39 pm
  • Hi Setup Large read only table (100 million rows) in a DW that is required to be based mainly in memory for performance reason. Version 10.2.0.1 I have some queries that I can not find information ...
    Rob DempseyRob Dempsey
    Nov 16, 2007 at 1:04 pm
    Nov 17, 2007 at 3:13 am
  • Hi, we are having a web application that ist o be online availyble 7x24. We plan for the scenario that the application needs a software update (new tables, modified tables et. al.) Management and ...
    Antje.Stejskal_at_ppimedia.deAntje.Stejskal_at_ppimedia.de
    Nov 12, 2007 at 9:47 am
    Nov 13, 2007 at 6:12 pm
  • Anyone know of a process or hack for exporting tables and data from a 9.2.0.4 DB into a 7.3 export format? Our company has a product that's used by some partner companies. One of these partners is ...
    James ParkhurstJames Parkhurst
    Nov 9, 2007 at 12:44 pm
    Nov 9, 2007 at 4:48 pm
  • I don't think this was intended for just me. From: Job Miller Sent: Wednesday, November 07, 2007 7:33 AM To: Stephens, Chris Subject: Re: use of nested tables to resolve many to many relationships ...
    Stephens, ChrisStephens, Chris
    Nov 7, 2007 at 2:37 pm
    Nov 8, 2007 at 1:20 am
  • We recently had a locking/blocking problem on two different 10.2.0.3 RAC systems. I ran a query similar to below to get more information: select sid, serial#, program, module, action, username, ...
    DeanDean
    Nov 1, 2007 at 3:55 pm
    Nov 3, 2007 at 10:04 am
  • Hi Anyone put some points on how checkpoint happening in RAC? For example intance1 checkpointed at time T1 and instance2 checkpointed at time T2 Now in case of instance1 failure,how instanace2 does ...
    Ahmed kdnlAhmed kdnl
    Nov 28, 2007 at 7:07 am
    Dec 4, 2007 at 4:41 am
  • In one of our reporting environments (OSEE 10.2.0.2) we have optimizer_dynamic_sampling cranked up to 5. We have a case where dynamic sampling is pushing the CBO to choose a poor plan. Our situation ...
    Charles SchultzCharles Schultz
    Nov 30, 2007 at 8:45 pm
    Dec 2, 2007 at 1:18 am
  • Folks, Does anyone know what process does the dynamic memory resizing when ASSM is enabled? Also, what is the frequency of this operation or is it triggered by some event? From the v$sga_dynamic ...
    Hameed, AmirHameed, Amir
    Nov 30, 2007 at 2:50 pm
    Dec 1, 2007 at 8:57 am
  • Greetings, Running Oracle 10.2.0.3.0 EE on RHEL4 on a two node RAC cluster we get the error below on compiling the included PL/SQL trigger with SQL Developer the database. I can't for the life of me ...
    William WagmanWilliam Wagman
    Nov 27, 2007 at 9:04 pm
    Nov 28, 2007 at 10:44 am
  • Greetings, We are trying to track down a problem which occurred a month ago and the developers have requested that I restore a database incrementally. This is Oracle 10gR2 and we are using RMAN to do ...
    William WagmanWilliam Wagman
    Nov 20, 2007 at 6:56 pm
    Nov 23, 2007 at 9:38 pm
  • Gurus, ORACLE 9.2.0.6 EE on Solaris Can I reduce the size of original undo tablespace (UNDO1) which has grown to 15 GB due to heavy import activity, by creating a second undo tablespace(UNDO2) and ...
    BalaBala
    Nov 16, 2007 at 8:11 pm
    Nov 21, 2007 at 7:16 pm
  • Hi all, I have a situation where a client wants to exercise system DR recovery. The current system is RAC with IBM's HACMP. However, this DR exercise will be done using 100% backup/restore from ...
    FmhabashFmhabash
    Nov 16, 2007 at 10:59 pm
    Nov 19, 2007 at 3:06 am
  • Hi DBAs. The instance with Oracle 10g DB on Windows 2003 SP1 box suddenly crashed last night with the following error in the alert log file. ORA-07445: exception encountered: core dump ...
    Khan, Muhammad SKhan, Muhammad S
    Nov 12, 2007 at 3:30 pm
    Nov 13, 2007 at 3:05 am
  • all, 2 nodes linux rhel4.4 IA 64 node 1 has 4 processors node 2 has 8 processors oracle RAC 10.2.0.3 have the problem that intermittently listener down. could not found some valuable info from ...
    Ujang JaenudinUjang Jaenudin
    Nov 8, 2007 at 11:55 am
    Nov 12, 2007 at 12:26 am
  • Has anybody ever seen a trace file with this name before : fint_ora_26608_ANONYMOUS.trc ? Unfortunately the file is timestamped at the same time as PMON terminated with an error, so it might be ...
    Finn JorgensenFinn Jorgensen
    Nov 7, 2007 at 12:37 am
    Nov 7, 2007 at 3:27 pm
  • Hello, list. At Statspack age, 'CPU Time' value in section 'Top 5 Timed Events' was calculated as the difference of 'CPU used by this session' values between two snapshots: select 'CPU', ...
    Luis Fernando CerriLuis Fernando Cerri
    Nov 1, 2007 at 3:20 pm
    Nov 5, 2007 at 1:47 pm
  • Greetings, I have come up against this situation before and have never been quite sure how to handle it. Running 10gR2 on RHEL 4 EE. In a home grown application there are a series of tables in which ...
    William WagmanWilliam Wagman
    Nov 30, 2007 at 1:11 am
    Nov 30, 2007 at 4:28 pm
  • Hello all, Trying to create a database on Linux RHE5 with a new install of 10gR2 that i downloaded. Have had the same core dump ever time i try to startup nomount. I've look through posts, lists, ...
    Lyall BarbourLyall Barbour
    Nov 27, 2007 at 2:27 pm
    Nov 28, 2007 at 10:41 am
  • Hi In a TKPROF output such as follows: call count cpu elapsed disk query current rows ------- ------ -------- ---------- ---------- ---------- ---------- Parse 1 0.00 0.00 0 0 0 0 Execute 7045 8.68 ...
    AmonteAmonte
    Nov 21, 2007 at 12:00 pm
    Nov 23, 2007 at 5:21 am
  • Oracle can, on occasion, generate an execution plan which returns incorrect results. In our 10.2.0.3 database we have two SQL queries which should give identical result sets, but don't. Outside of a ...
    Henry PorasHenry Poras
    Nov 16, 2007 at 8:42 pm
    Nov 19, 2007 at 7:32 pm
  • hello everyone, I'm trying to move data back and forth between MS SQL and Oracle and apparently to do so, **from** MS SQL to Oracle, there's some fast connectors from persistentsys.com If I try to ...
    Cosmin IoanCosmin Ioan
    Nov 15, 2007 at 10:32 pm
    Nov 16, 2007 at 3:09 pm
  • Hey all, In the past few weeks, I've had my full RMAN backups fail with ORA-230. Checking on logs and timings, I believe that the scheduled RMAN archivelog backups are coinciding with the controlfile ...
    Rich JesseRich Jesse
    Nov 14, 2007 at 2:50 pm
    Nov 14, 2007 at 4:09 pm
  • Production - RHEL 4.0, 64-bit Oracle 9.2.0.8 SE1 Test - RHEL 4.0, 32-bit Oracle 9.2.0.5, SE1 Development - RHEL 4.0, 32-bit Oracle 9.2.0.5 EE (Named user license) I have a developer trying to do an ...
    Sandra BeckerSandra Becker
    Nov 13, 2007 at 5:55 pm
    Nov 14, 2007 at 3:41 pm
  • Folks, I am installing Oracle clusterware 10.2.0.1 on two linux ES 4.0 servers at home. I am using NFS for shared storage. The problem I am having is that after installation of the clusterware ...
    Hameed, AmirHameed, Amir
    Nov 6, 2007 at 5:59 pm
    Nov 11, 2007 at 9:13 pm
  • Greetings, I have been playing around trying to grant execute on a trigger to a particular user. After playing with this for a while and reading docs I have come to the conclusion that execute on a ...
    William WagmanWilliam Wagman
    Nov 1, 2007 at 8:12 pm
    Nov 1, 2007 at 10:55 pm
Group Navigation
period‹ prev | Nov 2007 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions158
posts819
users215
websiteoracle.com

215 users for November 2007

Taylor, Chris David: 34 posts Alex Gorbachev: 26 posts Allen, Brandon: 23 posts Niall Litchfield: 22 posts Finn Jorgensen: 21 posts Don Seiler: 16 posts Jared Still: 16 posts Krish.hariharan_at_quasardb.com: 16 posts Hrishy: 13 posts Rich Jesse: 12 posts Vlad Sadilovskiy: 12 posts Dan Norris: 11 posts Ryan_gaffuri_at_comcast.net: 11 posts William Wagman: 11 posts Goran bogdanovic: 10 posts Andrew Kerber: 9 posts Dennis Williams: 9 posts Gints Plivna: 9 posts Herring Dave - dherri: 9 posts Mercadante, Thomas F (LABOR): 9 posts
show more
Archives