Search Discussions

364 discussions - 1,709 posts

  • Hello All, I've made a few changes. They are tentative. Please send any feedback directly to me. Messages will no longer carry the "Reply-To:" header line. Use "Reply to All" to reply to the list ...
    Steve AdamsSteve Adams
    Sep 2, 2004 at 9:15 pm
    Sep 28, 2004 at 7:04 pm
  • My 10 commandments of Database administration ... Anyone want to add to this? Thou shalt backup thy database. Thou shalt test thy database backup, often. Thou shalt remove as many single points of ...
    Freeman Robert - ILFreeman Robert - IL
    Sep 22, 2004 at 4:13 pm
    Sep 30, 2004 at 10:35 am
  • Hi guys, Is that true that you cannot connect to Oracle 9.2.0 on Intel + XP machine "WITHOUT A LISTENER?" I got this from metalink Problem: You could get an ORA-09352 on version 7.x of the database, ...
    Sinardy XingSinardy Xing
    Sep 19, 2004 at 11:04 pm
    Sep 27, 2004 at 1:32 pm
  • This quote appears in the following article: http://www.computerworld.com/hardwaretopics/storage/story/0,10801,95694,00.html?nas=DM-95694 " When it's in operation in 2011 at a site still to be ...
    Sep 8, 2004 at 11:03 am
    Sep 10, 2004 at 7:20 pm
  • Hi: I want to implement both 9i Data Guard and RMAN on one of our servers (AIX 5.2, Oracle 64 bit). This server is in the process of being tested. It will go into production sometime in ...
    Manjula KrishnanManjula Krishnan
    Sep 1, 2004 at 12:50 pm
    Sep 9, 2004 at 2:38 pm
  • Does anyone happen to have a reasonable explaination on what happens to a query when you try to access tables accross db_links ?? Does it still use the indexes on the remote machine ?? Does it bring ...
    Kevin LangeKevin Lange
    Sep 22, 2004 at 4:39 pm
    Sep 23, 2004 at 2:41 pm
  • Before anything apologizes to Jared, because he is not only on of the best expert in perl, but too loves Perl. But as you know I'm a developer too (that is the reason for the strange behaviour), so I ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Sep 29, 2004 at 8:05 am
    Sep 30, 2004 at 8:04 am
  • Guys, In order to manage and provide easier d/r for the oracle infrastructure = I have setup a centralized rman catalog and for redundancy another copy = of the same. Here is my concern: We are going ...
    Sep 15, 2004 at 9:50 am
    Oct 5, 2004 at 12:51 pm
  • Hi all, Would you have some tips on how I can implement something in the db, which can get a bit of impression on me to my boss. Just got a new job and would like to do something to impress him. Hope ...
    Sep 30, 2004 at 3:09 pm
    Oct 4, 2004 at 8:33 am
  • What is the best solution for 100's of oracle client installs - it isn't = Oracle Names anymore, it likely isn't installing of each and every = client. =20 -Is it LDAP and/or OID? =20 -Is there any ...
    Sep 15, 2004 at 9:52 am
    Sep 17, 2004 at 1:25 pm
  • anyone developing new systems with it? anyone have it in production on anything other than OEM or RMAN instances? -- http://www.freelists.org/webpage/oracle-l
    Sep 21, 2004 at 8:47 am
    Sep 24, 2004 at 10:55 pm
  • Has anyone ever heard of these guys? http://www.antssoftware.com/index.htm Someone just today pointed them out to me. They make some impressive claims for the performance of their product. They claim ...
    Jonathan GennickJonathan Gennick
    Sep 1, 2004 at 8:04 am
    Sep 2, 2004 at 6:05 pm
  • Hi, I have a process that overtime slowly gets slower and slower (execution plans are the same) A rebuild of the table / index fixes this and makes it go quick again. I know that we shouldn't need to ...
    David SharplesDavid Sharples
    Sep 1, 2004 at 6:18 am
    Sep 2, 2004 at 6:37 am
  • Just wanted to see what people have resorted to using in real world practice with the spfile. With 9i, are you still using the init file or have you migrated to using the spfile ? If still using the ...
    Spears, BrianSpears, Brian
    Sep 24, 2004 at 10:13 am
    Sep 25, 2004 at 11:52 pm
  • I can do backup and recovery in my sleep.... I can create databases, and I am not a bad SQL tuning fellow I must say.. But, if there were to be an Oracle inqusition, I would have to confess that the ...
    Freeman Robert - ILFreeman Robert - IL
    Sep 30, 2004 at 4:12 pm
    Oct 1, 2004 at 12:34 pm
  • Object Oriented programming is all about reuse so our java guys made a universal update statement that updates all columns in a table, even unchanged columns. I know its bad, but its a major re-write ...
    Sep 28, 2004 at 10:32 am
    Sep 28, 2004 at 1:25 pm
  • Guys, I have user years of experience on AIX, Solaris and lots of useful = kornshell scripts to monitor and such. I have not always been real = happy with OEM although I admit it has matured over the ...
    Sep 16, 2004 at 9:10 am
    Sep 17, 2004 at 2:53 am
  • Hi list, Sorry for starting two thread about the same, but I found Tom Kyte says "well, tuning TCP vs IPC would give you marginal improvements. http://asktom.oracle ...
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Sep 1, 2004 at 9:44 pm
    Sep 9, 2004 at 2:54 pm
  • My boss thinks that this could cause problems. I say it's OK to have, say three Oracle instances (or more) sharing the binaries, as long as we have enough memory and space. He thinks we should ...
    Ana ChotoAna Choto
    Sep 29, 2004 at 1:10 pm
    Sep 30, 2004 at 7:09 am
  • i hope i addressed this right - its my first post. i am looking at RAC to provide an HA environment on Linux (most likely Redhat AS3) assuming we dont want to use raw file system, are my only options ...
    Stephen EvansStephen Evans
    Sep 13, 2004 at 9:07 am
    Sep 29, 2004 at 7:45 pm
  • According to the security alert, all Oracle versions below have to be upgraded before applying the security patches. Looks like I have about 18 databases to upgrade....uuuugggghhhhh! David ...
    David WagonerDavid Wagoner
    Sep 22, 2004 at 4:24 pm
    Sep 24, 2004 at 1:56 pm
  • 13


    Hi Friends, I am having a very fundamental doubt, what is the order of retrival of the clauses when all are inclueded in the select stament like. Where Group by having order by. eg : select ...
    Srinivas TSrinivas T
    Sep 20, 2004 at 12:30 am
    Sep 23, 2004 at 11:48 pm
  • Hi all, I have a mystery on my hands. There must be a good explanation, but so far it has eluded me; I'm hoping someone out there will know the answer. Configuration: Oracle 64-bit on Solaris ...
    Janine A SiskJanine A Sisk
    Sep 14, 2004 at 2:53 pm
    Sep 15, 2004 at 11:30 am
  • I am sitting in a class and instructor told us that count(*) reads rowcount from segment header in some (or most?) cases rather than doign the good ol' FTS. He can't remember exact details, so this ...
    Sep 2, 2004 at 6:24 pm
    Sep 3, 2004 at 9:13 am
  • I'm trying to understand why I'm seeing a high number of I/Os for inserts. Inserts are through SQL*Loader conventional patch. Average row length is 129 bytes, no longs or blobs. The table has five ...
    Mark StricklandMark Strickland
    Sep 22, 2004 at 2:39 pm
    Oct 12, 2004 at 6:45 pm
  • Ok, database is on Solaris8. So, I wrote this query: 1 select sid, 2 serial#, 3 username, 4 machine, 5 logon_time, 6 osuser, 7 sql_text, 8 executions, 9 buffer_gets 10 from v$session vs, 11 ...
    Bobak, MarkBobak, Mark
    Sep 17, 2004 at 1:29 pm
    Sep 17, 2004 at 6:44 pm
  • Hi All, We have some issue with rsh between 2 servers. OS: Solaris: 8 Running apps 11.5.9. I am able to perform rsh from srvr A to srvr B. but cant do from Srvr B to Srvr A. ( I have included the ...
    Kommareddy, Srinivas (GE Healthcare, non-ge)Kommareddy, Srinivas (GE Healthcare, non-ge)
    Sep 15, 2004 at 11:32 pm
    Oct 20, 2004 at 2:11 pm
  • is it possible to identify the original names of columns that are no longer used (as in ALTER TABLE SET UNUSED COLUMN cname)? thanks, chaim http://www.learntorah.net http://www.ixora.com.au/ - For ...
    Sep 24, 2004 at 8:33 am
    Sep 24, 2004 at 12:19 pm
  • Can someone send or post a copy of ass.awk? Thanks. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To search the ...
    Jeremiah WiltonJeremiah Wilton
    Sep 12, 2004 at 11:49 pm
    Sep 13, 2004 at 1:45 pm
  • List, I have heared the best number for Initras is the number of CPU but what about the Freelists is there any standard for this parameter too. Any idea for any standards for these two parameters? ...
    Hamid AlaviHamid Alavi
    Sep 9, 2004 at 10:34 am
    Sep 10, 2004 at 8:07 am
  • Hi All! I'm looking for code example to how send an email notification using Windows DOS scripting. Thanks. Greg -- To unsubscribe - mailto:oracle-l-request_at_freelists.org&subject=unsubscribe To ...
    Greg FaktorGreg Faktor
    Sep 8, 2004 at 10:02 am
    Sep 8, 2004 at 5:11 pm
  • Has anyone used this parameter in 9i ( I have a real turkey of a vended application that is a resource hog. The queries have too many outer joins, select distincts and minus's to count ...
    Peter BarnettPeter Barnett
    Sep 1, 2004 at 2:19 pm
    Sep 3, 2004 at 2:49 pm
  • Hi, We need to transfer large amount of data daily from Oracle database to SQL Server Database. We have 3 options: Use DTS of SQL Server Use Linked server of SQL Server Use BCP in SQL Server First 2 ...
    Harvinder SinghHarvinder Singh
    Sep 29, 2004 at 12:38 pm
    Nov 7, 2004 at 4:20 pm
  • Our shared pool is filling up and slowing down batch updates. Is there a way to correct this problem besides frequent commits, or enlarging the shared pool? Ron=20 -- ...
    Smith, Ron L.Smith, Ron L.
    Sep 28, 2004 at 1:54 pm
    Sep 29, 2004 at 8:54 am
  • I'm sure this is a fairly common desire, however I haven't found any good answers yet. We have some applications that do not yet demand any of the scalability, availability or performance features of ...
    Marc SlemkoMarc Slemko
    Sep 26, 2004 at 4:24 pm
    Sep 28, 2004 at 8:46 am
  • We now have to support Mysql...besides the mysql site are there any good forums or sites or books to check out? This is for two small databases, very simple. Kathy This transmission contains ...
    Duret, KathyDuret, Kathy
    Sep 17, 2004 at 8:49 am
    Sep 20, 2004 at 9:01 am
  • Hi all, I just got a new job as a production dba and have already had a chance to read up a bit of online docs and the documentation (mostly "how-to" guides, step-bystep instructions written by the ...
    Sep 15, 2004 at 9:41 pm
    Sep 17, 2004 at 1:17 pm
  • I just spotted something puzzling. I was checking the sizing of some Oracle 8i tables, using TOAD's Schema Browser. There are tables and indexes which have initial and next extent sizes of 409600 ...
    Paul VincentPaul Vincent
    Sep 15, 2004 at 1:41 am
    Sep 16, 2004 at 7:18 am
  • Greetings, Is there a routine you follow for testing patch sets, such as an upgrade from to thanks, Josh C. -- To unsubscribe - ...
    Josh CollierJosh Collier
    Sep 3, 2004 at 1:09 pm
    Sep 3, 2004 at 1:56 pm
  • Howdy! (Been awhile since I've been on this list...) 2 Questions: 1) What's the best way to convert a physical standby to a logical standby? The physical has been running for awhile now. 2) How can I ...
    Orr, SteveOrr, Steve
    Sep 27, 2004 at 2:23 pm
    Sep 30, 2004 at 2:43 pm
  • How can I create a query that determine a rows that has not been updated for the last 10 business days. That would be the last 2 weeks not including the weekend. Glen Bernas Database Administrator ...
    Bernas, glenBernas, glen
    Sep 24, 2004 at 1:30 pm
    Sep 24, 2004 at 2:49 pm
  • Dear Gurus, I have been running my database in noarchive mode and I want to switch to Archivelog mode. I am running Oracle 7.3.4. I have three groups of redo logs that are 20MB each. My question is ...
    Aamgm serviceAamgm service
    Sep 22, 2004 at 5:38 am
    Sep 23, 2004 at 7:54 am
  • Looking for some advice here. Windows 2000 Oracle We are running several instances on the machine, but the memory allocated to them is far under the RAM available. ie. I shouldn't be OS ...
    Sep 21, 2004 at 9:46 am
    Sep 22, 2004 at 9:25 pm
  • Hello List, If I am dropping a LMT Tablespace and it takes a long time, how can I know that the process is running, not hanged. Can anyone let me know what are the internal functionality of drop ...
    Sep 19, 2004 at 2:16 am
    Sep 21, 2004 at 11:31 am
  • One of the posts on "Cure for Madness" brought up consistent null = handling which Oracle does not do. For instance, "Select Column1 + Column2 from TableA;" returns null if either or both = columns ...
    MacGregor, Ian A.MacGregor, Ian A.
    Sep 2, 2004 at 7:01 pm
    Sep 3, 2004 at 10:56 am
  • Hi everyone, Oracle released last night alert #68 covering fixes for many security bugs in Oracle. PeteFinnigan.com found security bugs in the new 10gR1 scheduler functionality. Our security advisory ...
    Pete FinniganPete Finnigan
    Sep 1, 2004 at 7:30 pm
    Sep 2, 2004 at 10:08 pm
  • EE on Lintel RH AS 2.1 OLTP ~200 connections. Today a have observed figures below in statspack report Statistic Total per Second per Trans --------------------------------- ------------------ ...
    Sep 23, 2004 at 5:49 pm
    Oct 6, 2004 at 6:09 pm
  • Hi all, The ENV is oracle / Aix5.2L. we would like to have different oracle inventory (in /etc) for different oracle homes.The reason for doing this is : one instance is not affected by ...
    Prem Khanna JPrem Khanna J
    Sep 30, 2004 at 3:19 am
    Sep 30, 2004 at 2:13 pm
  • Hi does any knows how to you get the undo information in a trace file? Thanks Juan Carlos Reyes Pacheco OCP -- http://www.freelists.org/webpage/oracle-l
    Juan Carlos Reyes PachecoJuan Carlos Reyes Pacheco
    Sep 28, 2004 at 11:27 am
    Sep 29, 2004 at 6:23 pm
  • On the tables I have here, in a database, the following produce the same update. The question is: Should they? That is, is this something the SQL spec says is supposed to work this way, or is ...
    Sep 28, 2004 at 11:01 am
    Sep 28, 2004 at 2:19 pm
Group Navigation
period‹ prev | Sep 2004 | next ›
Group Overview
grouporacle-l @

312 users for September 2004

Gogala, Mladen: 52 posts Bobak, Mark: 45 posts Paula_Stankus_at_doh.state.fl.us: 44 posts Jared Still: 42 posts Mercadante, Thomas F: 41 posts Goulet, Dick: 39 posts Niall Litchfield: 34 posts Mark W. Farnham: 33 posts Juan Carlos Reyes Pacheco: 32 posts Freeman Robert - IL: 31 posts Carel-Jan Engel: 28 posts Rjamya: 27 posts Jesse, Rich: 26 posts Ganesh Raja: 25 posts Nuno Souto: 25 posts Wolfson Larry - lwolfs: 25 posts Ryan_gaffuri_at_comcast.net: 24 posts Wolfgang Breitling: 23 posts Cary Millsap: 22 posts Lex de Haan: 22 posts
show more