FAQ

Search Discussions

452 discussions - 2,979 posts

  • Has anyone read the 'SQL Tuning Book' by Dan Tow from oreilly? It looks to be very good and I was thinking of picking it up. Any comments on the quality of the book would be much appreciated ...
    Chris StephensChris Stephens
    Feb 6, 2004 at 10:20 pm
    Feb 15, 2004 at 3:27 pm
  • <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" Moving db to linux -----Original Message-----From: Nelson, Allan Sent: Wednesday, February 25, 2004 12:23 PMTo ...
    Thater, WilliamThater, William
    Feb 25, 2004 at 11:55 am
    Feb 29, 2004 at 8:28 am
  • Hi DBA, I'm starting to take a look at the "Capacity Planner" tool from the Diagnostics Pack. Great tool, collects info on lots of interesting statistics ... from databases Response time Wait events ...
    Luc.Demanche_at_astrazeneca.comLuc.Demanche_at_astrazeneca.com
    Feb 2, 2004 at 2:18 pm
    Feb 9, 2004 at 5:48 pm
  • I just went through an episode in which I changed a parameter setting using scope=spfile, attempted to bounce my instance, and found that I was hosed. Fortunately, I had an up-to-date text version of ...
    Jonathan GennickJonathan Gennick
    Feb 18, 2004 at 10:57 pm
    Feb 20, 2004 at 4:12 pm
  • Hi I took sometime to do a paper, to help newbies in tunning, this is not to become they expert, but at least they know there are statistics in the database If you get some time, and give some ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Feb 25, 2004 at 12:41 pm
    Mar 16, 2004 at 1:22 am
  • Dear All, any idea when 10g will be available for Windows environment? Thanks Jay Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to ...
    JayJay
    Feb 12, 2004 at 3:25 am
    Feb 20, 2004 at 7:22 am
  • Is there a quick way to count number of rows in a table? Don't want to do select count(*) from..... on a table (such as GL_BALANCES) with more than 250 million rows. If you are not an intended ...
    Potluri, Venu (CT Appl Suppt)Potluri, Venu (CT Appl Suppt)
    Feb 17, 2004 at 8:27 pm
    Feb 20, 2004 at 10:07 am
  • According to screenshots from http://otn.oracle.com/obe/obe10gdb/install/linuxinst/linuxinst.htm it looks like the installer checks to see if it's running on a "certified" Linux. I thought the latest ...
    Jesse, RichJesse, Rich
    Feb 2, 2004 at 4:04 pm
    Feb 23, 2004 at 8:47 am
  • Hi It may be a silly thing to ask, but I am stuck right now. I have been given a task to find out the indexes which need to be rebuilt. There are around 3000 Indexes. I know I can run the following ...
    Vidya kalyanaramanVidya kalyanaraman
    Feb 13, 2004 at 8:45 am
    Feb 25, 2004 at 12:44 pm
  • Users receiving "unable to launch a dedicated server process. ora-12500 in an Oracle Apps 11i database. Processes were 298 with processes in init.ora of 400. Stopped apache and restarted it and ...
    Jeffrey BeckstromJeffrey Beckstrom
    Feb 18, 2004 at 1:11 pm
    Feb 20, 2004 at 1:36 pm
  • Hi! What parameters need to be set to allow connect / as sysdba on 9i? On my db this is disabled. Only "connect sys/pwd_at_database as sysdba" works. Any ideas? This is 9.2 on HP-UX. Thanks, Helmut ...
    Daiminger, HelmutDaiminger, Helmut
    Feb 5, 2004 at 10:35 am
    Feb 6, 2004 at 4:26 pm
  • I noticed this book on Oracle replication. http://tinyurl.com/3fvuj Has anyone out there in radio land given the book a good enough look to have an opinion on it. The reason I ask is that I recently ...
    Stephen.Lee_at_DTAG.ComStephen.Lee_at_DTAG.Com
    Feb 27, 2004 at 8:42 am
    Feb 27, 2004 at 6:59 pm
  • OK, let me be more specific. I have used toad,nav,PL/SQL developer for several years. (I still need to research benthic & tora). My team (of 40+ users) who are all using sqlplus, comprises of 25-30 ...
    Sue JohnsonSue Johnson
    Feb 20, 2004 at 7:55 am
    Feb 25, 2004 at 2:28 am
  • academic textbooks have them. The silbershatz book 'database systems concepts' has it in chapter 12. Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    Feb 6, 2004 at 12:36 pm
    Feb 24, 2004 at 2:50 pm
  • List, I have a very unusual request from users to have UNDO_RETENTION set to 5 days. Normally I set to about 5 hours, not days. Don't ask why. They have inherited a bad design that requires flashing ...
    Arup NandaArup Nanda
    Feb 12, 2004 at 5:42 am
    Feb 16, 2004 at 4:24 am
  • The OCM practicum is run against a free version of linux. just go to www.oracle.com/certification and read about where to download it. Please see the official ORACLE-L FAQ: http://www.orafaq.com To ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    Feb 24, 2004 at 8:03 am
    Feb 26, 2004 at 9:21 pm
  • I am trying to use a trigger to turn on tracing for a specified user. I copied the example from Cary Millsap's _Optimizing Oracle Performance_. The text of the trigger is: create or replace trigger ...
    Schauss, PeterSchauss, Peter
    Feb 13, 2004 at 4:36 pm
    Feb 18, 2004 at 11:39 am
  • I want to start playing around with this. I have Redhat 7.1 sitting at home. Can I run 9iAS on this(I dont know anything about 9iAS yet). Or do I have to get another version? Is there a cheap or free ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    Feb 26, 2004 at 8:36 am
    Mar 3, 2004 at 11:26 am
  • Hi, I asked recently to Tom if I could do an extract ddl from utl_file from 9.2.4 and run in 9.2, Because I can't run patches. Tom obviously said NO. But what can go wrong, except something not ...
    Juan Cachito Reyes PachecoJuan Cachito Reyes Pacheco
    Feb 27, 2004 at 1:32 pm
    Feb 28, 2004 at 8:17 am
  • Hi DBAs, My sysadmin asked me if he can use a tool called Diskeeper to defrag the disks on our Windows servers. Did someone know that tool? What could be the impact on the Oracle datafiles? Thank you ...
    Luc.Demanche_at_astrazeneca.comLuc.Demanche_at_astrazeneca.com
    Feb 6, 2004 at 8:16 pm
    Feb 11, 2004 at 8:23 am
  • Good morning all, We just installed a new fast disk farm with fiber channels. For production we are using raid 10. My SA set in up with a stipe size of 64K based on the size of most of the ...
    Ruth GramoliniRuth Gramolini
    Feb 20, 2004 at 2:40 pm
    Feb 29, 2004 at 7:02 pm
  • is it really that bad for you to give developers the ability to kill sessions? if your afraid of general alter system privileges you can wrap it in a package? Please see the official ORACLE-L FAQ ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    Feb 24, 2004 at 12:39 pm
    Feb 25, 2004 at 11:33 am
  • I am running Oracle 9i Rel 2 V. 9.2.0.4 on Windows 2000 Advanced Server = SP4. Our database was originally created a couple of years ago on 9i Standard = by someone else. Now I'm here and we've ...
    Freeman, DonaldFreeman, Donald
    Feb 10, 2004 at 9:17 pm
    Feb 15, 2004 at 2:24 am
  • In my mind, the single most important reason to understand internals is to be able to handle just about any database recovery problem that might confront you. If you understand how the database works ...
    Freeman Robert - ILFreeman Robert - IL
    Feb 27, 2004 at 10:24 am
    Mar 1, 2004 at 10:58 pm
  • My team has been asked to assess some performance issues with a SAP database. The SAP team sent us one of those SAP EaryWatch Reports to ostensibly help us with diagnosis. I don't pretend to be any ...
    Thomas JeffThomas Jeff
    Feb 9, 2004 at 3:14 pm
    Feb 12, 2004 at 9:51 am
  • <!-- /* Style Definitions */ p.MsoNormal, li.MsoNormal, div.MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman";} a:link, span.MsoHyperlink {color:blue ...
    Cary MillsapCary Millsap
    Feb 24, 2004 at 1:36 am
    Feb 24, 2004 at 4:16 pm
  • Hi Everyone! We are having intermittent and irregular performance issues with one of our home-grown reports from our SAP system. I tried running a SQL trace, but it was insufficient to our needs. Is ...
    Vergara, Michael (TEM)Vergara, Michael (TEM)
    Feb 19, 2004 at 5:41 pm
    Feb 20, 2004 at 1:54 pm
  • I don't know if it's really a solution. I remember that some people using plain text e-mail programs didn't like messages in HTML format so I always sent e-mails to the list in Outlook's "plain text" ...
    Jacques KilchoerJacques Kilchoer
    Feb 18, 2004 at 11:39 pm
    Feb 20, 2004 at 1:48 pm
  • is there a practical need to do that? I typically just turn autoextend on for all my files and have code that monitors the bytes in all my segments in a tablespace vs. the size of the datafile and I ...
    Ryan.gaffuri_at_cox.netRyan.gaffuri_at_cox.net
    Feb 11, 2004 at 1:28 pm
    Feb 12, 2004 at 10:24 am
  • Hi All, A simple SQL*PLUS question. How to get a dynamic prompt in SQL*PLUS? I have put the code to set prompt as "Username_at_Db_name SQL " in login.sql, the prompt is stationary. It doesn't change ...
    Naveen, Nahata (IE10)Naveen, Nahata (IE10)
    Feb 24, 2004 at 1:13 am
    Jul 14, 2004 at 7:38 am
  • A query (with an order by) is able to satisfy it's column list by scanning an index. This scan will return the rows in sorted order, but the query still executes a sort (confirmed by 10046 trace) ...
    Daniel FinkDaniel Fink
    Feb 25, 2004 at 1:30 pm
    Feb 27, 2004 at 11:43 am
  • Good morning all, I must admit I never paid attention to the Linux posts. Since I was stuck on Windows for the foreseeable future, yada yada... Well all that's changed. This morning I was just ...
    Koivu, LisaKoivu, Lisa
    Feb 25, 2004 at 8:07 am
    Feb 25, 2004 at 4:23 pm
  • We have ORACLE database run under SUN solaris 9 and ORACLE 9.2.0.4. While wd doing "FULL" database export, we got lots of error like: . . exporting table AQ$_INTERNET_AGENTS 0 rows exported . ...
    Dba1 mccDba1 mcc
    Feb 23, 2004 at 10:35 am
    Feb 24, 2004 at 2:08 am
  • Would anyone happen to know why the code below the dashed line gives as error the following 3 lines? Both my C:\oracle\admin\Oracle9i\pfile\init.ora as well as my C:\oracle\admin\Ora9i\pfile\init.ora ...
    Maryann AtkinsonMaryann Atkinson
    Feb 14, 2004 at 9:25 pm
    Feb 19, 2004 at 1:38 am
  • Dear ALL Can SQL*PLUS Worksheet work on Oracle Enterprise Manager Console standalone ? Or I need to login into oracle management server ? I am not able to do a simple select query from the sqlplus ...
    Kean JacintaKean Jacinta
    Feb 11, 2004 at 9:09 am
    Feb 17, 2004 at 7:59 pm
  • Has anyone done any recent testing on the effect of optimizer_max_permutations. I recall seeing a note on metalink once said the CBO would change the way in which it permuted join orders if the ...
    Jonathan LewisJonathan Lewis
    Feb 9, 2004 at 3:51 pm
    Feb 14, 2004 at 7:47 am
  • I am experimenting with creating tablespaces/datafiles on a new NetApp filer we got installed. The sysadmin configured a dedicated volume out the the 9tb behemoth with a stripe size of 128k, which he ...
    Carmen RusuCarmen Rusu
    Feb 10, 2004 at 7:55 pm
    Feb 11, 2004 at 2:24 pm
  • 16

    RMOUG

    Did anyone get a headcount for a list get together Wed evening at RMOUG? I saw some interest but no plans. Who all is speaking? I know I recognize some of the names from here. Is there anyone local ...
    Stephen AndertStephen Andert
    Feb 6, 2004 at 8:15 pm
    Feb 9, 2004 at 4:47 pm
  • Does anyone know how to choose the screen that TOAD defaults to when you open it? I am so annoyed by the SQL screen coming up first. I know this option used to be available but I can't find it in the ...
    Koivu, LisaKoivu, Lisa
    Feb 4, 2004 at 2:09 pm
    Feb 4, 2004 at 6:04 pm
  • Neither MetaLink nor Google have ever heard of ORa-21607, save the same stuff you saw from oerr. Time for an iTar Jared "Vergara, Michael (TEM)" Sent by: oracle-l-bounce_at_freelists.org 02/22/2004 ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Feb 23, 2004 at 12:45 pm
    Feb 24, 2004 at 10:10 am
  • Now Oracle does not track which rows are locked. How processes know when a lock has been released? I can't find it in the docs. I'm assuming there is something similiar to an SCN written to the block ...
    RyanRyan
    Feb 13, 2004 at 4:13 am
    Feb 17, 2004 at 11:49 am
  • Hey all, I'm trying to see if I can determine the actual date of a DATE column in 8.1.7.4.0 on HP/UX given a DUMP of the column. When I: SELECT DUMP(mydatecol) FROM mytab; I get this from the single ...
    Jesse, RichJesse, Rich
    Feb 25, 2004 at 3:07 pm
    Feb 26, 2004 at 12:43 pm
  • Hi All, How to find out the long running job. I guess, we can select the login time from v$session whose status = 'ACTIVE'; My co-dba said that, he killed a long running job and the jobis currently ...
    Kommareddy, Srinivas (MED, Wissen Infotech)Kommareddy, Srinivas (MED, Wissen Infotech)
    Feb 17, 2004 at 8:45 am
    Feb 18, 2004 at 7:16 pm
  • Dear All, We are starting a new oracle development project and my boss wants me to prepare "Oracle Development- Best practice" document/presentation kind of stuff. Basically this is to avoid common ...
    Jaysingh1_at_optonline.netJaysingh1_at_optonline.net
    Feb 7, 2004 at 11:35 pm
    Feb 9, 2004 at 7:59 pm
  • Wanted to look through the old archives and can't Sure I am doing something simple wrong but am brain dead. Installed a new 8.1.7 instance on Solaris. I have checked my, home director, my oracle ...
    Duret, KathyDuret, Kathy
    Feb 7, 2004 at 7:20 pm
    Feb 9, 2004 at 4:04 pm
  • Ryan, where do you see anything about Linux on the OCP sales page? Please see the official ORACLE-L FAQ: http://www.orafaq.com To unsubscribe send email to: oracle-l-request_at_freelists.org put ...
    Mladen GogalaMladen Gogala
    Feb 24, 2004 at 9:26 am
    Feb 25, 2004 at 8:31 am
  • Just for fun, I counted the events in 9.2. Here's the result: SQL show release release 902000400 SQL select count(*) from v$event_name; COUNT(*) 401 SQL In 10g, there are 808 different events. Wow, ...
    Mladen GogalaMladen Gogala
    Feb 24, 2004 at 1:28 pm
    Feb 25, 2004 at 7:42 am
  • Hello, Can someone help me figure out how user A can truncate table in user b schema? Isnt this drop any table priv? Oracle 8.1.7 Thanks
    ViktorViktor
    Feb 13, 2004 at 8:57 pm
    Feb 19, 2004 at 5:46 am
  • �I have installed 9024 and am trying to run dbca (via WebTerm X on my PC) and I cannot enter text into the Global db and SID. This has happened to me before with the installer and I have had to go to ...
    Catherine LeBlancCatherine LeBlanc
    Feb 10, 2004 at 10:20 pm
    Feb 16, 2004 at 8:44 am
  • I'm taking an academic database class. My professor showed us that when you have a block split and the parent node(s) split, you end up with a new level. I'm assuming oracle 'redistributes' the ...
    RyanRyan
    Feb 6, 2004 at 3:31 am
    Feb 6, 2004 at 6:05 pm
Group Navigation
period‹ prev | Feb 2004 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions452
posts2,979
users320
websiteoracle.com

320 users for February 2004

Mladen Gogala: 208 posts Jared.Still_at_radisys.com: 92 posts Ryan.gaffuri_at_cox.net: 90 posts Juan Cachito Reyes Pacheco: 82 posts Niall Litchfield: 82 posts Tanel Põder: 66 posts Mladen Gogala: 65 posts DENNIS WILLIAMS: 56 posts Bobak, Mark: 51 posts Jonathan Lewis: 51 posts Jamadagni, Rajendra: 50 posts Jared Still: 48 posts Mercadante, Thomas F: 47 posts Cary Millsap: 46 posts Koivu, Lisa: 46 posts Jesse, Rich: 45 posts Jacques Kilchoer: 41 posts Jonathan Gennick: 38 posts Paul Drake: 37 posts Powell, Mark D: 35 posts
show more
Archives