FAQ

Search Discussions

494 discussions - 2,392 posts

  • We have experienced intermittent problems (slow response time) with our oltp database today. There appears to be a large number of latch free events and the p2 parameter is indicating an issue with ...
    Tracy RahmlowTracy Rahmlow
    Jan 7, 2004 at 10:39 pm
    Jan 11, 2004 at 12:29 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Hi, I've been asked by management to explore the pros and cons of Mysql vs Oracle. The database in question will be a web based text and ...
    Mujeeb ChowdhryMujeeb Chowdhry
    Jan 14, 2004 at 5:04 pm
    Jan 26, 2004 at 12:39 am
  • Dear Oracle-L subscriber, Due to changing circumstances, the Oracle-L mailing list has found a new home. Fatcity.com has graciously hosted Oracle-L for several years, and I thank Bruce Bergman for ...
    Jared StillJared Still
    Jan 22, 2004 at 6:49 am
    Jan 29, 2004 at 3:14 pm
  • Content-Type: multipart/alternative; boundary="----_=_NextPart_001_01C3D556.6A90BCC0" ------_=_NextPart_001_01C3D556.6A90BCC0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding ...
    Shrake, JoleneShrake, Jolene
    Jan 7, 2004 at 7:39 pm
    Jan 12, 2004 at 10:14 am
  • Are job post allowed on the new list? =20 -----Original Message----- From: OraStaff Sent: Thursday, January 22, 2004 1:59 PM To: oracle-l_at_freelists.org Subject: [oracle-l] Oracle DBA Position ...
    Boyle, Christopher J.Boyle, Christopher J.
    Jan 22, 2004 at 9:34 pm
    Jan 27, 2004 at 5:44 pm
  • Jared, I think your conclusions must have assumptions: The SQL was written "correctly". The data structures wrer designed and layed out properly. Here, we can AssUMe neither. :) Food for thought.. ...
    Jesse, RichJesse, Rich
    Jan 2, 2004 at 5:54 pm
    Jan 14, 2004 at 9:29 am
  • Hi! We want to introduce a performance monitoring policy here. We are using the STATSPACK utility. What are sections in statspack reports to look for? What are threshold numbers for these values? ...
    Daiminger, HelmutDaiminger, Helmut
    Jan 19, 2004 at 6:24 am
    Feb 7, 2004 at 11:43 am
  • ('binary' encoding is not supported, stored as-is) Bzzzt. Oracle won because it actually delivered a database that could be recovered from after a system crash. Which Ingres never did despite their ...
    Nuno Pinto do SoutoNuno Pinto do Souto
    Jan 20, 2004 at 4:29 am
    Jan 21, 2004 at 2:44 pm
  • Hi list, has someone observed the presence of some odd combinations of characters in the body of the mails of this mailing-list? Combinations like this one: 20=3D Do I miss anything? Is it a ...
    Mario CariggiMario Cariggi
    Jan 29, 2004 at 10:14 pm
    Jan 30, 2004 at 11:01 pm
  • Conner McDonald's book just came out and it looks to be pretty good. Any more books in the pipeline? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ryan INET ...
    RyanRyan
    Jan 5, 2004 at 10:34 pm
    Jan 19, 2004 at 12:44 am
  • Have a question on backups in a DW environment. Our DW is somewhat small at the moment but projected to grow. I seem to be having a hard time trying to convince the sys admin that I don't want ...
    MkbMkb
    Jan 9, 2004 at 9:24 pm
    Jan 11, 2004 at 7:14 pm
  • Hello Listers, A normal sql query from a data warehouse tool called Sagent. SELECT COL1, COL2, COL3 FROM TABLE ORDER BY 3; The table has approximately 2 mil records. table has 22 indexes. The ...
    Denham EvaDenham Eva
    Jan 7, 2004 at 5:29 am
    Jan 8, 2004 at 2:34 pm
  • Dear List, I want to upgrade from 8.1.5 to 8.1.7 on windows 2000 what's the safest way to do this upgrade. If any body knows any url or have any kind of document it would be very helpful. Thanks & ...
    Hamid AlaviHamid Alavi
    Jan 5, 2004 at 5:24 pm
    Jan 6, 2004 at 10:09 pm
  • Thanks a lot for your reply, Cary. One follow-up question. What would motivate "a chat" of sometimes 5, sometimes 10-20 'SQL*Net message to/from client' consecutive wait lines emitted to the trace ...
    Boris DaliBoris Dali
    Jan 1, 2004 at 4:29 pm
    Jan 6, 2004 at 7:29 pm
  • I've been asked if I can remove the [oracle-l] from the subject header. probably. Just don't have time to do it for a day or so. Any other issues, let me know. Jared
    Jared StillJared Still
    Jan 23, 2004 at 3:05 pm
    Jan 26, 2004 at 6:45 pm
  • One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    Jan 20, 2004 at 7:19 pm
    Jan 26, 2004 at 4:35 pm
  • Hi all, I'm not sure if this question has been posted or not. I inheritated an Oracle9i (9.2.0.4) database which contains all dictionary-managed tablespaces. This small database is approx. 1 GB and ...
    Paula WinklerPaula Winkler
    Jan 5, 2004 at 10:39 pm
    Jan 15, 2004 at 7:49 pm
  • While perusing the HOTSOS site, I noticed that the deadline for the discounted registration for the HOTSOS conferences ends after tomorrow. If you're thinking of going, you may want to check it out ...
    Jared StillJared Still
    Jan 6, 2004 at 1:59 am
    Jan 6, 2004 at 11:44 pm
  • If you are considering MySQL or other open-source applications, the following article discusses some of the more subtle issues related to open source, particularly if you sell applications based on ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Jan 27, 2004 at 4:23 pm
    Feb 3, 2004 at 2:08 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Rather than installing the Oracle client on every client PC, we have been:- installing client on 1 PC - copying directory to a network ...
    Jeffrey BeckstromJeffrey Beckstrom
    Jan 6, 2004 at 6:39 pm
    Jan 14, 2004 at 2:54 am
  • Hello: I was looking through some OCP questions posted on the web and came across the one below. I believe the answer is (D), because the join type would be dependent on the number of rows within the ...
    Jay WadeJay Wade
    Jan 6, 2004 at 6:44 pm
    Jan 8, 2004 at 5:19 pm
  • I didn't mean to scold... you post way more information than I usually do! And I answer whilst eating breakfast at times too :) Richard *is* right, the problem is, the sql statement is misformed but ...
    Rachel CarmichaelRachel Carmichael
    Jan 7, 2004 at 2:34 pm
    Jan 8, 2004 at 12:09 pm
  • This is the new list commands. Ecartis Help File ** By Rachel Blackman, JT Traub and Ryan T. Dean TO GET A LIST OF LISTS: Send a message to the ecartis account on the server with a subject of ...
    Fred CollingtonFred Collington
    Jan 23, 2004 at 2:10 pm
    Oct 13, 2004 at 5:21 am
  • Hello all, Has anyone seen a website/document that shows the Oracle versions, and what features each version has?? I'm looking for something that goes back to Oracle's earlier versions, 5, 4, 3.. ...
    Grabowy, ChrisGrabowy, Chris
    Jan 29, 2004 at 9:18 pm
    Jan 30, 2004 at 4:19 pm
  • Content-Type: text/plain; name="ReadMe.txt"; charset="us-ascii" Content-Transfer-Encoding: 7bit The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary ...
    Nuala CullenNuala Cullen
    Jan 8, 2004 at 7:24 pm
    Jan 30, 2004 at 3:09 pm
  • kirti-- would you recommend avoiding pga_aggregate_target for now? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: http://www.fatcity.com San Diego, California -- Mailing ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    Jan 21, 2004 at 8:04 pm
    Jan 24, 2004 at 6:19 pm
  • We have recently completed a successful upgrade P10 with the inclusion of the list's own Mogens Norgaard and the semi-retired Dave Ensor (the past Jonathan Lewis). For a full list of speakers, ...
    Daniel FinkDaniel Fink
    Jan 28, 2004 at 2:19 pm
    Feb 10, 2004 at 1:17 am
  • I'm in the process of revamping our backup system (which is mostly inherited from another DBA), and had a few questions about rman I've come across as I review the system. 'copy' vs. 'backup'. In our ...
    Daniel HanksDaniel Hanks
    Jan 27, 2004 at 9:58 pm
    Jan 30, 2004 at 8:44 am
  • We're developing some schema update scripts for an in-house application, which includes renaming an existing table, and creating a new version using the original name. No problem... or so I ...
    Norris, Gregory T [ITS]Norris, Gregory T [ITS]
    Jan 16, 2004 at 3:09 pm
    Jan 21, 2004 at 12:19 pm
  • I've been asked to provide value for the Transactions Per Minute going through our primary OLTP production database. I believe I can use deltas in SCN values to measure "transactions" which do ...
    Charlie_Mengler_at_HomeDepot.comCharlie_Mengler_at_HomeDepot.com
    Jan 28, 2004 at 3:29 pm
    Jan 29, 2004 at 4:09 pm
  • Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's ...
    Rhojel_Echano_at_sgs.comRhojel_Echano_at_sgs.com
    Jan 13, 2004 at 6:29 am
    Jan 21, 2004 at 6:54 pm
  • Dear Friends, I am trying to send output from SQLPlus to Excel file. If any one did the same before please let me know. Thank You Mudhalvan M.M -- Please see the official ORACLE-L FAQ ...
    Mudhalvan, MoovarkkuMudhalvan, Moovarkku
    Jan 20, 2004 at 4:44 am
    Jan 21, 2004 at 6:49 am
  • Hi list, sorry to pester you with questions regarding boson OCP questions . i have scheduled for #1Z0-031 exam and so desperately need help from this list . please bear with me for while . look at ...
    Prem Khanna JPrem Khanna J
    Jan 7, 2004 at 11:24 am
    Jan 9, 2004 at 1:29 pm
  • Greetings fellow-DBA-folk: When I run several queries, I am getting very strange results. Selecting * from apple returns the expected data records, but count(*) does not. Selecting anything other ...
    Stephen AndertStephen Andert
    Jan 7, 2004 at 7:49 pm
    Jan 7, 2004 at 11:39 pm
  • Hi All, My manager wants to get all the unique wait events from the trace file. I tried the below but how do i get DISTICT wait event name? Any help would be really appreciated. $ grep -i WAIT ...
    Jaysingh1_at_optonline.netJaysingh1_at_optonline.net
    Jan 22, 2004 at 4:09 pm
    Jan 22, 2004 at 9:24 pm
  • <!-- /* Font Definitions */ @font-face {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0; mso-font-charset:2; mso-generic-font-family:auto; mso-font-pitch:variable; mso-font-signature:0 268435456 ...
    Jeroen van SluisdamJeroen van Sluisdam
    Jan 6, 2004 at 2:54 pm
    Jan 21, 2004 at 5:59 am
  • any recommendations? of course besides the oracle docs and technet, which i think i downloaded all that i need. joe -- Joseph S Testa Chief Technology Officer Data Management Consulting p ...
    Joe TestaJoe Testa
    Jan 9, 2004 at 7:59 pm
    Jan 9, 2004 at 11:09 pm
  • Env: Windows 2000/NT/HP-UX/Solaris/Linux Oracle Databases: 7.3 to 9.2.0.4 I am looking for any good product/option for centralized source code control. Any pointer or experiences shall be ...
    M RafiqM Rafiq
    Jan 7, 2004 at 6:34 pm
    Jan 8, 2004 at 9:29 pm
  • My question, Richard, is can a person pass the exam just by studying what is correct? Or is it necessary to work harder to acquire some "veneer of false knowledge" specifically in order to pass the ...
    Cary MillsapCary Millsap
    Jan 7, 2004 at 3:59 pm
    Jan 8, 2004 at 2:19 pm
  • Hi! I have this table with ~4,000,000 entries When i do a SELECT COUNT(*) FROM TABLE_NAME it takes 4 hours to give me the result, this is way too much Im running Oracle 9.2.0.4.0 on RedHat AS 3 These ...
    Jordi Adame VJordi Adame V
    Jan 29, 2004 at 11:54 pm
    Jan 30, 2004 at 6:33 pm
  • Hi friends ! I'm about to upgrade a DB rom Oracle 8.1.6 EE 32-bit to Oracle 8.1.7 EE 32-bit on HP-UX 11.11 Are there any known issues, pitfalls etc. thta I'd better be aware of before i begin ? ...
    Andrey BronfinAndrey Bronfin
    Jan 29, 2004 at 1:33 pm
    Jan 29, 2004 at 9:26 pm
  • Is this a genuine mail...? I'm a part of the list. -----Original Message----- Sent: Thursday, January 22, 2004 1:56 PM To: venu.andem_at_wipro.com Dear Oracle-L subscriber, Due to changing ...
    Venu GopalVenu Gopal
    Jan 22, 2004 at 8:29 am
    Jan 27, 2004 at 6:04 pm
  • Folks: Jan 1, 1968. When I query a column of type 'DATE', it returns me the default format, dd-mon-yy. I know I can use to_char(date_col,'YYYYMMDD') etc... to define many output formats. What can I ...
    Droogendyk, HarryDroogendyk, Harry
    Jan 23, 2004 at 5:39 pm
    Jan 23, 2004 at 8:54 pm
  • As in: does it present an inherent or hidden performance problem when a lot of sessions try to lock/release the same lock? Or how many lock/release per second. Or some other idea of how efficient it ...
    Nuno SoutoNuno Souto
    Jan 21, 2004 at 12:49 pm
    Jan 23, 2004 at 4:24 am
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Is there a way to log into sqlplus without the username and password available to anyone who wants to grab it? -- Please see the official ...
    RyanRyan
    Jan 16, 2004 at 6:04 pm
    Jan 16, 2004 at 8:34 pm
  • I have created a seperate listener for external procedures for one of my SIDs. My question is, if I want to do the same for another SID in the same instance, what ensures that each external procedure ...
    John DunnJohn Dunn
    Jan 8, 2004 at 12:19 pm
    Jan 9, 2004 at 6:04 pm
  • What does a DBA do? What should a DBA do? Interesting short list, or maybe not so short. http://dbasupport.com/oracle/ora9i/resolutions.shtml -- Please see the official ORACLE-L FAQ ...
    Jared StillJared Still
    Jan 7, 2004 at 1:34 am
    Jan 8, 2004 at 8:44 pm
  • I got one here. I'll start without all the details to see if the answer is something simple that can be answered without the ugly details, trace files, etc. The app calls a procedure in a package ...
    Stephen.Lee_at_DTAG.ComStephen.Lee_at_DTAG.Com
    Jan 29, 2004 at 10:59 pm
    Jan 30, 2004 at 10:01 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" I have found that the vast majority of time that Oracle chooses this method, my statistics are stale and the query is sub-optimal. One ...
    RyanRyan
    Jan 27, 2004 at 2:24 am
    Jan 27, 2004 at 11:14 pm
  • Hi All, Is there anyway to find out from data dictionary views when was a database procedure/function last executed. Would like know the solution for 8i and 9i databases. We have some older code in ...
    Prasada.Gunda_at_hartfordlife.comPrasada.Gunda_at_hartfordlife.com
    Jan 22, 2004 at 4:19 pm
    Jan 27, 2004 at 9:29 pm
Group Navigation
period‹ prev | Jan 2004 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions494
posts2,392
users347
websiteoracle.com

347 users for January 2004

Mladen Gogala: 99 posts Tanel Poder: 82 posts DENNIS WILLIAMS: 67 posts Jonathan Lewis: 67 posts Ryan.gaffuri_at_cox.net: 65 posts Jkstill_at_cybcon.com: 64 posts Jared.Still_at_radisys.com: 62 posts Goulet, Dick: 61 posts Bobak, Mark: 55 posts Jamadagni, Rajendra: 54 posts Mladen Gogala: 48 posts Rachel Carmichael: 46 posts Jesse, Rich: 40 posts Mercadante, Thomas F: 33 posts Niall Litchfield: 33 posts Paul Drake: 29 posts Tim Gorman: 28 posts Wolfgang Breitling: 28 posts Nuno Souto: 24 posts Thater, William: 23 posts
show more
Archives