FAQ

Search Discussions

571 discussions - 2,800 posts

  • Dear List, Can anyone send me a list of dba interview questions? Thanks, Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? ...
    System managerSystem manager
    Oct 23, 2003 at 8:14 pm
    Oct 29, 2003 at 3:34 pm
  • I enjoy immensely reading Cary's book, but I have some questions that I want to ask publicly. Recently, I made a comment about Chris Lawson's book being a "Dale Carnegie book for a DBA" and now I see ...
    Mladen GogalaMladen Gogala
    Oct 3, 2003 at 3:14 pm
    Oct 6, 2003 at 7:59 pm
  • I was at the Wash DC Oracle conference yesterday and the key note address was about the future direction of Oracle. It was pretty positive about Grid technology and blade servers. Anyone out there ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Oct 16, 2003 at 3:04 pm
    Oct 28, 2003 at 10:29 pm
  • Hi to all! We have an old app that manages something that my boss calls: boolean dates. He told me that exists an algorithm that manages dates as a boolean format. We have several tables in this ...
    Jose Luis DelgadoJose Luis Delgado
    Oct 22, 2003 at 3:19 pm
    Oct 23, 2003 at 8:54 pm
  • Cary, I don't mean to ask you to brag, but can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it ...
    Michael MilliganMichael Milligan
    Oct 21, 2003 at 4:49 pm
    Oct 27, 2003 at 6:04 am
  • http://www.crn.com/sections/BreakingNews/dailyarchives.asp?ArticleID=45368 Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- ...
    Goulet, DickGoulet, Dick
    Oct 22, 2003 at 9:24 pm
    Oct 27, 2003 at 9:14 pm
  • Hi all, when you would consider to put a table a cache... rgds gb Want to chat instantly with your online friends? Get the FREE Yahoo! Messenger http://mail.messenger.yahoo.co.uk -- Please see the ...
    Gunnar BerglundGunnar Berglund
    Oct 21, 2003 at 7:39 am
    Oct 23, 2003 at 7:39 pm
  • Anybody with a quick and dirty (elegant would be nice too), to munge output from a nslookup output file to a delimited file? 'File content: Server: dns1.mci.com Address: 199.249.19.1 Name ...
    Johan MullerJohan Muller
    Oct 1, 2003 at 12:59 pm
    Oct 2, 2003 at 8:24 pm
  • how many projects actually have SLAs? Ive been on 5 projects and none of them have had them. Its always been. Customer: 'It's Slow' Me: What is? Customer: The application. Make it fast. Me: Define ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Oct 7, 2003 at 7:24 pm
    Oct 15, 2003 at 6:39 pm
  • RE: Query Tuning HelpJust checking to see if anyone has been able to clone a 9.2 DB from one machine to another. I have never had a problem doing this prior to 9.2, and am just wondering if I have ...
    John BlakeJohn Blake
    Oct 27, 2003 at 9:24 pm
    Oct 31, 2003 at 5:19 pm
  • Ok, I'll bite. What happened to Howard Rogers ? Original Message ----- HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this ...
    SdfSdf
    Oct 23, 2003 at 1:24 pm
    Oct 30, 2003 at 8:34 pm
  • We are an Application Service Provider--we maintain a set of servers in a colocation facility and our customers use our application via the Web. Security is a paramount concern, of course, and only ...
    Paul BaumgartelPaul Baumgartel
    Oct 24, 2003 at 3:14 pm
    Oct 27, 2003 at 6:29 pm
  • John, I rebuild the FND_CONCURRENT_REQUESTS indexes every four months [and the table itself, occassionally]. This Saturday I will also be rebuilding some ALR indexes. Which WorkFlow Indexes do you ...
    Hemant K ChitaleHemant K Chitale
    Oct 14, 2003 at 3:39 pm
    Oct 21, 2003 at 4:49 am
  • This is for non-transactional data load instances. The guys here sware that by using smaller temporary tables(not global temp tables) they can increase the speed of the data loads. Not worried about ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Oct 20, 2003 at 1:39 pm
    Oct 27, 2003 at 12:04 pm
  • Kirti, I had upgraded a database from 8.1.7.4 to 9.2.0.4. Before the upgrade, performance is good. After upgrade, one query run time from 2 min to 12 hours. Of course, I re-analyzed all tables and ...
    Joan HsiehJoan Hsieh
    Oct 1, 2003 at 3:54 pm
    Oct 3, 2003 at 7:34 pm
  • Hi All, Could somebody help me in finding the actual size of an oracle table in GB. TIA, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Pillai, Rajesh INET ...
    Pillai, RajeshPillai, Rajesh
    Oct 15, 2003 at 7:24 pm
    Oct 17, 2003 at 8:49 pm
  • List, How can I user comma " ' " in my update statement? update tablea set fielda =' james'ste Camp 'first,'sec' ' Thanks, Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see ...
    Hamid AlaviHamid Alavi
    Oct 9, 2003 at 5:59 pm
    Oct 13, 2003 at 5:24 am
  • I just passed the Net8 Administration OCP exam. This was my last exam, so I suppose I am now an OCP for Oracle8i. Thanks to everyone for their helpful tips. Some people said (or implied) that this is ...
    DENNIS WILLIAMSDENNIS WILLIAMS
    Oct 16, 2003 at 7:24 pm
    Oct 19, 2003 at 11:54 pm
  • Guys, Does it make sense to separate data and index segments into separate tablespaces if you create a single logical volume and all files are striped using the SAME methodology ? Thanks vikas -- ...
    Vikas kawatraVikas kawatra
    Oct 8, 2003 at 3:34 pm
    Oct 10, 2003 at 12:24 am
  • I have 2 tables, Rqmt and Resource, same structure. I need to take all almost-one-million records from Rqmt and insert them to Resource. So far this worked ok: DECLARE RowCount NUMBER := 0; BEGIN ...
    Maryann AtkinsonMaryann Atkinson
    Oct 16, 2003 at 3:54 pm
    Oct 17, 2003 at 9:04 pm
  • Hi, list. Ya, I'm still alive and kickin'. We have this small database that's running a weird vendor application. (We get all the gems.) It's on Solaris 5.8, Oracle 8.1.7.2 The database suddenly went ...
    Barbara BakerBarbara Baker
    Oct 9, 2003 at 5:09 pm
    Oct 10, 2003 at 7:24 pm
  • Hi, For those like me still working on an Oracle 716 (hold the laughs), how do we coalesce a tablespace? Rgds, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ross ...
    Ross ColladoRoss Collado
    Oct 27, 2003 at 1:04 am
    Oct 27, 2003 at 6:34 pm
  • that question is diagrammed and answered in tom kytes new book. :) im waiting to get asked it. there is a new ault book out on interview questions. I dont think they are very tough. I think ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Oct 24, 2003 at 2:29 pm
    Oct 25, 2003 at 11:39 am
  • Cary, I don't mean to ask you to brag, but can you please tell me if your new book, of which I've heard good things, is different in any way than other Oracle Performance Tuning books out. Does it ...
    Michael MilliganMichael Milligan
    Oct 21, 2003 at 5:44 pm
    Oct 22, 2003 at 7:54 am
  • Morning folks, the developers here are looking at a view with a where clause which specifies : WHERE 1=1 AND ............... AND ............... etc. I'd seen this used before as a way of tweaking ...
    Hately, Mike (LogicaCMG)Hately, Mike (LogicaCMG)
    Oct 21, 2003 at 11:44 am
    Oct 21, 2003 at 6:29 pm
  • Anyone got a "1, 2, 3" for using transportable tablespaces? Got a client that thinks this might be a good solution to transfer large amounts of data. This is HP/UX and should be 8.1.7.4... Any ...
    Michael KlineMichael Kline
    Oct 10, 2003 at 7:14 pm
    Oct 23, 2003 at 12:54 am
  • Hello, I am trying to concatenate several records with simple sql. Is this possible? -- Thanks, Jake Johnson jake_at_plutoid.com Plutoid - http://www.plutoid.com - Shop Plutoid for the best prices on ...
    Jake JohnsonJake Johnson
    Oct 21, 2003 at 12:09 am
    Oct 22, 2003 at 2:19 pm
  • OK, well I thought it was funny. Doing a google search on some Oracle stuff, I found the following page. http://www.dba-oracle.com/bp/bp_book6_utils.htm Scroll down a bit? Do you see the funny part? ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 6, 2003 at 6:39 pm
    Oct 7, 2003 at 10:44 am
  • Please send me an email, if you are interested. Free email with personality! Over 200 domains! http://www.MyOwnEmail.com Looking for friendships,romance and more? http://www.MyOwnFriends.com -- ...
    System managerSystem manager
    Oct 20, 2003 at 3:09 pm
    Oct 20, 2003 at 9:39 pm
  • Okay, anyone using Financials... E-Business suite... Oracle 11i... whatever you want to call it... I am trying to apply SOME kind of security to my databases. It appears that it is critical for ...
    April WellsApril Wells
    Oct 15, 2003 at 12:39 pm
    Oct 18, 2003 at 7:44 am
  • A script dumps out table info. (sqlplus on aix 4.3.3 and oracle 8.1.7). I cannot suppress the PROMPT @path/scriptname and PROMPT spool off statements from the report output. The script contains both ...
    Johan MullerJohan Muller
    Oct 13, 2003 at 4:49 pm
    Oct 16, 2003 at 6:19 pm
  • I have an Oracle 8.1.7.0 database running on an MS2000 server. A few times a day the database just stops running for no reason. There are no messages in the alert or trace logs. Nothing in the Event ...
    Smith, Ron L.Smith, Ron L.
    Oct 14, 2003 at 8:14 pm
    Oct 15, 2003 at 2:04 pm
  • I was thinking about putting together a database that contains a list of DBAs, servers, databases, and applications. The database would be used by the Helpdesk and Management to see who is ...
    Smith, Ron L.Smith, Ron L.
    Oct 30, 2003 at 3:29 pm
    Oct 31, 2003 at 2:19 pm
  • Guys, it's oracle 9.2.0.3/Win2K. say for some reason (NOT recovery): i want to drop a datafile from a tablespace which has more than 1 datafile.how to do it ? Doc 111316.1 says u need to drop the ...
    Prem Khanna JPrem Khanna J
    Oct 29, 2003 at 4:54 am
    Oct 29, 2003 at 5:34 pm
  • Important: Please read the following Oracle Alert. We strongly recommend that you do not connect the Oracle Database directly to the Internet. Got your attention? That is what is in the Alert. These ...
    Tjambu_fatcity_at_yahoo.com.auTjambu_fatcity_at_yahoo.com.au
    Oct 23, 2003 at 1:24 pm
    Oct 27, 2003 at 7:19 am
  • I have an index on the two columns used in this query. Why would the optimizer choose an index full scan over an index fast full scan? My question isnt why an index is used, but the type of index ...
    Rgaffuri_at_cox.netRgaffuri_at_cox.net
    Oct 23, 2003 at 7:09 pm
    Oct 25, 2003 at 2:04 am
  • Hi gurus, Oracle 8.1.7.3 on Sun Solaris One of our databases has been updated by Shareplex, and we have a huge performance problem.... Shareplex is the only process running on this database. Here is ...
    Luc.Demanche_at_astrazeneca.comLuc.Demanche_at_astrazeneca.com
    Oct 23, 2003 at 3:29 pm
    Oct 23, 2003 at 10:59 pm
  • I just received "Effective Oracle by Design" and reading the foreword I noticed not only the familiar names of Connor McDonald, Anjo Kolk and Mogens Norgaard, but I also saw this list mentioned ...
    Mladen GogalaMladen Gogala
    Oct 22, 2003 at 7:59 pm
    Oct 23, 2003 at 7:24 pm
  • I have a database that was populated using an export from an US7ASCII Oracle database. The current database is WE8ISO8859P1 which is not a superset of US7ASCII. So I can't change the characterset ...
    Thomas DayThomas Day
    Oct 22, 2003 at 5:34 pm
    Oct 23, 2003 at 1:19 pm
  • Hi all, we have an application which needs data from other environment (which is actually SAP db). Currently we have implemented it the way we create flat files and put them in using pl/sql ...
    Gunnar BerglundGunnar Berglund
    Oct 20, 2003 at 5:39 am
    Oct 21, 2003 at 2:24 pm
  • Management have been grumbling about the cost of TOAD Professional licenses, and have been "recommended" a cheaper product called PL/SQL Developer by Allround Automations (available from Inthink ...
    Paul VincentPaul Vincent
    Oct 15, 2003 at 3:59 pm
    Oct 17, 2003 at 8:39 am
  • First time I've seen this note: 189702.1 Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Jared.Still_at_radisys.com Fat City Network Services -- 858-538-5051 ...
    Jared.Still_at_radisys.comJared.Still_at_radisys.com
    Oct 6, 2003 at 11:34 pm
    Oct 12, 2003 at 4:59 am
  • Hi List, Can you help me please, What are the database parameters that i have to increase or modify in order to increase the speed of my ddl statments,i have a statment that delete a table with 40000 ...
    Walid AlkaakatiWalid Alkaakati
    Oct 9, 2003 at 8:29 am
    Oct 10, 2003 at 4:34 pm
  • I've got Cary's book for about a week now and I have a comment. On page 12 he defines response time as "The elapsed time between the end of an inquiry or demand on a computer system and the beginning ...
    Wolfgang BreitlingWolfgang Breitling
    Oct 7, 2003 at 6:09 pm
    Oct 7, 2003 at 9:54 pm
  • Well.... I've brought my share of children into the world, thats for sure.... I'd wager I have more than just about anyone else here on Oracle-L in fact... Anyone have more than 5?? Also, I'm rapidly ...
    Freeman Robert - ILFreeman Robert - IL
    Oct 3, 2003 at 5:09 pm
    Oct 6, 2003 at 8:49 pm
  • Hello everyone, Env: 8.1.7.4, SunOs 5.8 64 Bit We seem to hitting bug 1262161. The bug seems to imply that tables with triggers behind them do not reuse blocks on the freelist. We have a table that ...
    Kaing, LengKaing, Leng
    Oct 1, 2003 at 6:19 am
    Oct 4, 2003 at 1:34 am
  • I was creating some trace files yesterday and came across one of these problems that shows up occasionally (then I forget about it). When I ran my query using ALTER SESSION SET sql_trace=true ...
    Henry PorasHenry Poras
    Oct 1, 2003 at 1:34 pm
    Oct 2, 2003 at 5:44 pm
  • Hi!! I am trying to change the size of my tablespace TEMP, I am not an Administrator but we really need to make this tablespace smaller. Already the size is 13214 Mgs, and this tablaspace is on a ...
    Teresita CastroTeresita Castro
    Oct 1, 2003 at 2:24 am
    Oct 1, 2003 at 4:24 pm
  • 11

    dual

    List, here is a rtfm question which I was scared to ask, but its bothering me too much so I just can't stay quite : "why do multiple inserts into sys.dual complete sucessfully when connected as ...
    Bulbultyagi_at_now-india.net.inBulbultyagi_at_now-india.net.in
    Oct 30, 2003 at 4:54 pm
    Oct 30, 2003 at 11:24 pm
  • John, My apologies for the delay. I hadn't logged on to my email last night. Here's the output from my site 11.0.3 "Purge Obsolete Workflow Runtime Data" set to AGE=90 days [ITEM_TYPE and ITEM_KEY ...
    Hemant K ChitaleHemant K Chitale
    Oct 16, 2003 at 3:19 pm
    Oct 25, 2003 at 2:59 am
Group Navigation
period‹ prev | Oct 2003 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions571
posts2,800
users358
websiteoracle.com

358 users for October 2003

Mladen Gogala: 161 posts Jared.Still_at_radisys.com: 98 posts Ryan: 84 posts DENNIS WILLIAMS: 72 posts Jamadagni, Rajendra: 72 posts Goulet, Dick: 51 posts Mercadante, Thomas F: 42 posts Tanel Poder: 42 posts Mladen Gogala: 39 posts Khedr, Waleed: 38 posts Cary Millsap: 37 posts Wolfgang Breitling: 36 posts Jared Still: 34 posts Tim Gorman: 34 posts Rachel Carmichael: 32 posts Bellow, Bambi: 30 posts Jesse, Rich: 29 posts AK: 27 posts Daniel W. FInk: 26 posts Paul Drake: 25 posts
show more
Archives