FAQ

Search Discussions

182 discussions - 1,159 posts

  • We are getting ready to hire a JAVA Developer, and I was asked if I wanted to ask some questions relating to the database.... or to see if we get along. Connection pooling comes to mind, not ...
    Joel.Patterson_at_crowley.comJoel.Patterson_at_crowley.com
    Jan 8, 2007 at 4:35 pm
    Jan 11, 2007 at 4:19 pm
  • I have spent the afternoon reviewing the DST issues (database and JVM) that take affect in March. After looking at MetaLink notes 359145.1, 396387.1, 396671.1, 397281.1, 402742.1, 396906.1, 396670.1 ...
    Fedock, John \(KAM.RHQ\)Fedock, John \(KAM.RHQ\)
    Jan 22, 2007 at 9:38 pm
    Feb 1, 2007 at 12:35 am
  • Folks, Had a quick question for the folks out here - how many people are using, or looking at using Standard Edition with RAC in lieu of EE? Are the cost savings worth the annoyance of the ...
    Matthew ZitoMatthew Zito
    Jan 2, 2007 at 11:39 pm
    Jan 6, 2007 at 1:47 am
  • Hi List, I've got a production database that currently has a terminated session stuck in the rollback state and v$session_wait shows it is waiting on 'latch free' for the 'cache buffer chains' ...
    Allen, BrandonAllen, Brandon
    Jan 9, 2007 at 9:01 pm
    Jan 10, 2007 at 8:31 pm
  • Folks, Has anyone ever configured a DataGuard setup with three databases? 1 is the prime and the other two are the standby's, but in an ordered way. Dick Goulet, Senior Oracle DBA 45 Bartlett St ...
    Richard J. GouletRichard J. Goulet
    Jan 15, 2007 at 6:46 pm
    Jan 22, 2007 at 4:17 pm
  • Hi all, I think the question has been asked before but I'm hoping that 10.2.0.3 has changed things - can we do a compress on the fly with expdb now? Ie. using mknod. Has anyone managed to get this to ...
    Leng KaingLeng Kaing
    Jan 9, 2007 at 6:54 am
    Jan 15, 2007 at 2:56 am
  • Hi, We are thinking to have a process that will archive data from our production database to another database, or somewhere else ..... For example, data of an old customer, info of an old product, ...
    Luc DemancheLuc Demanche
    Jan 30, 2007 at 3:59 pm
    Feb 6, 2007 at 11:58 am
  • All, Know what irks me to no end about Metalink? If you *know* the document number that you want to read and search for it, don't you think it would be the first freeking document listed in the ...
    Mercadante, Thomas F \(LABOR\)Mercadante, Thomas F \(LABOR\)
    Jan 12, 2007 at 7:01 pm
    Jan 18, 2007 at 7:21 pm
  • Hi all, We are running a batch process to insert data from one table to another. The data inserted is over than 10 million rows. We had about 20GB of UNDO tablespace. UNDO_RETENTION is 7200. When we ...
    Ram RamanRam Raman
    Jan 23, 2007 at 6:19 am
    Jan 27, 2007 at 6:53 am
  • Hi I have a DWH query which IMHO should do partition prunning but it does not. The query is as follows: SELECT a11.id_tp_busq id_tp_busq, a14.dt_busqueda dt_busqueda, a11.id_site id_site, a13.de_site ...
    LS ChengLS Cheng
    Jan 5, 2007 at 12:19 pm
    Feb 8, 2007 at 6:14 pm
  • I have a developer 6i forms application, when they search on one particular screen, screen intermittently hangs for about 3 to 4 minutes. when I look at the back end the session is waiting on "SQL ...
    Dd yakkaliDd yakkali
    Jan 5, 2007 at 6:49 pm
    Jan 10, 2007 at 6:57 pm
  • HI I have a little problem with the mviews and there logs i have a 10.2 g db that holds the mviews and a 9.2 i that holds the log files Problem is that the log files are getting very big while fast ...
    Vincent verpoortVincent verpoort
    Jan 16, 2007 at 2:52 pm
    Jan 25, 2007 at 7:11 pm
  • Greetings, I have been running dbms_stats.gather_schema_stats against test/development database for some time and recently added estimate_percent = dbms_stats.auto_sample_size Since which time ...
    William WagmanWilliam Wagman
    Jan 5, 2007 at 7:12 pm
    Jan 9, 2007 at 12:08 am
  • Hi I have this query SELECT TUH_NVPAGINA.ID_SECCION AS ID_SECCION, TUD_FEDIA.ID_TIPO_DIA AS ID_TIPO_DIA, TUD_FEDIA.ID_MES AS ID_MES, count(distinct TUH_NVPAGINA.TX_COOKIE_SESION) CNT FROM ...
    AmonteAmonte
    Jan 30, 2007 at 2:43 pm
    Feb 21, 2007 at 7:31 pm
  • Following up on my post from Friday regarding an optimizer plan to use an index join rather than a simple index lookup. Wolfgang Breitling pointed out that the optimizer estimated that the query ...
    Baumgartel, PaulBaumgartel, Paul
    Jan 23, 2007 at 4:41 pm
    Feb 1, 2007 at 4:09 pm
  • Below is an actual email I received. I bet a server would have to be marinated a longggggg time to be edible. Hello We have a 2 -3 months contract need with a large client of us in St Louis for a ...
    Kerber, AndrewKerber, Andrew
    Jan 18, 2007 at 1:21 pm
    Jan 22, 2007 at 9:30 pm
  • I will show my ignorance here and ask for what reasons an application might not work with RAC when more than one instance is added. Oracle should be able to handle any locks, although there may be ...
    John HallasJohn Hallas
    Jan 29, 2007 at 9:22 am
    Feb 1, 2007 at 11:28 am
  • We are one of the lucky shops to use a lot of Solaris & Veritas. Kinda makes me wonder what caused such a big problem.... Is this an example of "a butterfly flaps its wings in Asia, causing a ...
    Charles SchultzCharles Schultz
    Jan 10, 2007 at 8:35 pm
    Jan 16, 2007 at 6:45 pm
  • List, Our corporate wiz kid has decided to migrate our Oracle 10g database from Linux to Windows2003 on Vmware. Are there any special setup instruction needed to make this work properly? Any ...
    Ron RogersRon Rogers
    Jan 3, 2007 at 8:27 pm
    Jan 10, 2007 at 5:08 pm
  • I'm new to RMAN and have a recovery question. We're recovering our test database to a point in time. The database is around 60 gig. When we start recovery, will RMAN re-create, restore and then ...
    DIANNA GIBBSDIANNA GIBBS
    Jan 24, 2007 at 11:11 pm
    Jan 30, 2007 at 6:32 am
  • As pl/sql is one of my weak points, I was wondering if anyone had any working examples of converting TABLE to VARRAY in a pl/sql wrapper? I am browsing the documentation ...
    Charles SchultzCharles Schultz
    Jan 19, 2007 at 9:02 pm
    Jan 25, 2007 at 9:12 pm
  • Has anyone seen the following condition in 8.1.7 on Solaris 9, all 64 bit: The database appears to be frozen. New connections do not reject, but don't come back to the client either. Dedicated server ...
    Richard J. GouletRichard J. Goulet
    Jan 22, 2007 at 7:25 pm
    Jan 23, 2007 at 1:01 am
  • Our listener log has grown too large and I want to back it up. It is my understanding that it can't be truncated because it is an open file. What are other people doing to resolve this issue? This is ...
    J. DexJ. Dex
    Jan 11, 2007 at 2:44 pm
    Jan 12, 2007 at 11:21 pm
  • I've been on a crusade against my developers lately after having had enough of fields being added to already-insane primary keys. Today I was given a script to add a field to make what is now a ...
    Don SeilerDon Seiler
    Jan 27, 2007 at 4:48 am
    Jan 30, 2007 at 11:16 am
  • We are planning on upgrading our databases from 9i to 10G and we'd like to hear from people who have gone through this process. What release of 10G are you on? Are there any performance issues? Any ...
    Ana ChotoAna Choto
    Jan 22, 2007 at 2:43 pm
    Jan 23, 2007 at 11:50 pm
  • I am trying to evaluate a value for optimizer_index_caching. The default setting is 0 which tell CBO to ignore the probability that an index block is in memory Ok, it is obviously false since some ...
    Polarski, BernardPolarski, Bernard
    Jan 22, 2007 at 11:17 am
    Jan 23, 2007 at 1:07 am
  • Hello. Version - 10.1.0.5.0. User C is NOT able to select (ORA-1031) from a View V in Schema A (On which C has select privilege), which is based on a table in Schema B. If user C is granted Select ...
    Shivaswamy RaghunathShivaswamy Raghunath
    Jan 2, 2007 at 7:00 pm
    Jan 2, 2007 at 9:05 pm
  • I have 2 nodes, with public, private and virtual IP addresses assigned and installation of CRS fails miserably. Oracle support is dragging its feet for a week and I am unable to get a competent ...
    Mladen GogalaMladen Gogala
    Jan 31, 2007 at 8:59 pm
    Feb 2, 2007 at 3:43 am
  • Hi all, I am currently working on a 1.5T DSS running on 8k blocksize. This db is 90% of the time doing sequential reads. Was wondering if we go for a 16k or 32k blocksize just on index alone would ...
    Arun chakrapani raoArun chakrapani rao
    Jan 10, 2007 at 4:40 am
    Jan 10, 2007 at 5:53 pm
  • This email is subject to Terms and Conditions as found in our Email Legal Notice which forms part of this email message in terms of section 11 of the Electronic Communications and Transaction Act 25 ...
    Denham EvaDenham Eva
    Jan 3, 2007 at 8:19 am
    Jan 4, 2007 at 2:40 pm
  • Has anybody seen this new Oracle security book by David Litchfield? Would anybody recommend buying it? I have been working on a security project for a defense contractor and wonder if it is worth ...
    Joe SmithJoe Smith
    Jan 29, 2007 at 7:53 pm
    Jan 31, 2007 at 12:59 pm
  • All, Since my pl/sql is less than stellar, well, way less than that; i was hoping to get some direction on how to pass an array of records back to the calling application? i have initialized a record ...
    Bryan WellsBryan Wells
    Jan 30, 2007 at 3:34 pm
    Jan 31, 2007 at 12:35 pm
  • Does anybody have a good understanding of how the maxthr metric is computed or how it's used by the CBO? I'm just curious because I've gathered system stats 5 times in the past few days and keep ...
    Allen, BrandonAllen, Brandon
    Jan 18, 2007 at 11:42 pm
    Jan 23, 2007 at 10:54 am
  • Does anyone have a script for Windows that will archive old network log and trace files and also remove any that are more than a month old (or at least be able to run under a monthly scheduled task)? ...
    J. DexJ. Dex
    Jan 7, 2007 at 10:10 pm
    Jan 8, 2007 at 3:44 pm
  • As it seems, the corruption should be in the free space in the SYSTEM tablespace. I just have no clue what to do with that. (Besides, wouldn't RMAN just skip the really free space?.) If it was for ...
    Uldis.Pavuls_at_tietoenator.comUldis.Pavuls_at_tietoenator.com
    Jan 2, 2007 at 10:58 am
    Jan 3, 2007 at 7:32 pm
  • Good morning, We are planning a migration to unicode. Actually we are using Oraclce9.2.0.6 and we also want to move to 10.2 First of all, regarding the Unicode conversion, here are my questions ...
    Luc DemancheLuc Demanche
    Jan 10, 2007 at 2:34 pm
    Jan 31, 2007 at 2:06 pm
  • Hello all I have a quite busy Oracle APPS database running in HPUX. Today during peak hour I saw this in alert Thu Jan 18 10:19:50 2007 Beginning log switch checkpoint up to RBA [0x17d1.2.10], SCN ...
    AmonteAmonte
    Jan 18, 2007 at 11:17 am
    Jan 25, 2007 at 5:20 pm
  • Folks In a 3 TB TEST Database in 10gR2, a 700 GB Table needs to be DROPPED. This Table is present in a Unique Tablespace. Which of the following Options is Most Advisable w.r.t. performance, speed & ...
    VIVEK_SHARMAVIVEK_SHARMA
    Jan 22, 2007 at 6:17 pm
    Jan 23, 2007 at 6:58 am
  • I need to restore my production database to a new node but I'm getting the following errors: ORA-19507: failed to retrieve sequential file, handle="PRDRUBY_14478_1_611444563", parms="" ORA-27029 ...
    Sandra BeckerSandra Becker
    Jan 14, 2007 at 2:27 am
    Jan 16, 2007 at 6:50 pm
  • Since Moving to 10,2 some open cursor problems have surfaced. Here's an example of the code: // collect the ProcessInstances in this Stream's ParentStream that depe nd (status transition) on ...
    MacGregor, Ian A.MacGregor, Ian A.
    Jan 10, 2007 at 11:14 pm
    Jan 14, 2007 at 5:31 am
  • Has anyone received their IOUG abstract approval/rejection email?? I believe for the last couple of years the emails were sent out around Dec 21/22/23. -- http://www.freelists.org/webpage/oracle-l
    Grabowy, ChrisGrabowy, Chris
    Jan 8, 2007 at 4:37 pm
    Jan 13, 2007 at 8:13 am
  • On one of our Microsoft Servers, I have been asked to compress all of the Oracle software directories and files. Will that cause any issues? What is the best way to compress them? Your Hotmail ...
    J. DexJ. Dex
    Jan 8, 2007 at 3:05 am
    Jan 9, 2007 at 8:37 am
  • Hi, I am running the following script and getting errors: begin dbms_stats.gather_schema_stats(ownname= 'HS',estimate_percent= 100,degree= dbms_stats.auto_degree,granularity= 'AUTO',method_opt= 'FOR ...
    Oracle-l-bounce_at_freelists.orgOracle-l-bounce_at_freelists.org
    Jan 31, 2007 at 11:04 pm
    Feb 2, 2007 at 4:46 pm
  • Oracle-l list, I just got confirmation from Oracle Support of a new problem I found with the timezone patches. I've been told a note/alert will be released on Metalink within a few days once they've ...
    Allen, BrandonAllen, Brandon
    Jan 31, 2007 at 8:34 pm
    Feb 2, 2007 at 4:40 pm
  • Is there any reason why an INSERT using binds and the same INSERT using literals should differ in performance of the execution phase? (I'm aware of the difference with respect to parse phase.) Paul ...
    Baumgartel, PaulBaumgartel, Paul
    Jan 30, 2007 at 7:58 pm
    Jan 31, 2007 at 10:31 pm
  • Has anyone researched or found a good paper on the impact to the changes going to daylight savings time early and if it will have any impact on our Oracle databases? If the servers know what to do, ...
    Kline.MichaelKline.Michael
    Jan 24, 2007 at 1:55 pm
    Jan 29, 2007 at 3:27 pm
  • What might cause a query using NL (in 9204) use Hash Outer Join (in 9208) when all optimizer and memory parameter being same. I checked optimizer parameter values using 10053 trace. The tables ...
    RjamyaRjamya
    Jan 25, 2007 at 8:59 pm
    Jan 26, 2007 at 3:52 pm
  • What would you buy? Is this even possible? -- http://www.freelists.org/webpage/oracle-l
    Ethan PostEthan Post
    Jan 19, 2007 at 10:22 pm
    Jan 22, 2007 at 5:21 pm
  • Any thoughts gang? I'll be so glad when the 8.1.6 is all gone. Maks From: Willinger.Lisa Sent: Wednesday, January 17, 2007 11:57 AM To: DBAs Subject: Connecting...ORA-03134: Connections to this ...
    Kline.MichaelKline.Michael
    Jan 17, 2007 at 5:02 pm
    Jan 22, 2007 at 11:29 am
  • Hi, We were installing oracle on 32GB RAM server and configured the Shared_pool to 1GB and PGA to 3GB, so wondering what the maximum numbers of memory can be allocated for buffer cache or How much ...
    Oracle-l-bounce_at_freelists.orgOracle-l-bounce_at_freelists.org
    Jan 18, 2007 at 8:40 pm
    Jan 22, 2007 at 2:07 am
Group Navigation
period‹ prev | Jan 2007 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions182
posts1,159
users217
websiteoracle.com

217 users for January 2007

Allen, Brandon: 54 posts Niall Litchfield: 36 posts Kevin Closson: 31 posts Joel.Patterson_at_crowley.com: 29 posts Mercadante, Thomas F \(LABOR\): 26 posts Dennis Williams: 24 posts Jared Still: 24 posts Oracle-l-bounce_at_freelists.org: 24 posts Polarski, Bernard: 23 posts GovindanK: 21 posts Wolfgang Breitling: 21 posts Rjamya: 20 posts Laimutis Nedzinskas: 19 posts Mladen Gogala: 19 posts Bobak, Mark: 18 posts Charles Schultz: 18 posts Kerber, Andrew: 16 posts LS Cheng: 16 posts Baumgartel, Paul: 15 posts Richard J. Goulet: 15 posts
show more
Archives