FAQ

Oracle > oracle-l > May 2002

Search Discussions

637 discussions - 3,081 posts

  • I posted my list of Good DBA vs. Bad DBA on the DBA Pipeline (www.revealnet.com), and it was suggested I share it here, which I am doing.... comments most welcome. (If you saw this list on Revealnet, ...
    Freeman, RobertFreeman, Robert
    May 6, 2002 at 7:13 pm
    May 9, 2002 at 11:48 pm
  • We are having this debate. What is a 'Production DBA'? Right now all of the DBAs do some of everything. In an effort to focus more DBA time on infrastructure, damagement is floating the idea of ...
    Peter BarnettPeter Barnett
    May 29, 2002 at 8:20 pm
    May 31, 2002 at 9:39 pm
  • Hi all, Did some investigation about statistical sampling this weekend since we are going to optimize our analyze process soon, and would like some input from all you orabrains on this one. I opened ...
    Jack SilveyJack Silvey
    May 21, 2002 at 9:43 pm
    May 29, 2002 at 11:43 pm
  • Dear List, When I query dba_extents, Iam getting response after half an hour to 40 minutes, but when I query any other dictionary view it is spontaneous. Everything else is fine in the database and ...
    Janardhana Babu DongaJanardhana Babu Donga
    May 9, 2002 at 5:58 pm
    May 9, 2002 at 11:13 pm
  • A question has been posed to me, when to switch from NT to unix for oracle. Is it when the NT box starts getting out of memory issues, number of transactions, size of db? just looking for some ball ...
    JOE TESTAJOE TESTA
    May 23, 2002 at 1:48 pm
    May 30, 2002 at 7:20 pm
  • I just just wanna go lie on a beach naked on some remote island far far away and not think of anything for a month. Here is the issue..... I have a query that looks like this ... select a.f1, a.f2, ...
    Johnson, MichaelJohnson, Michael
    May 17, 2002 at 9:23 pm
    May 20, 2002 at 8:48 pm
  • XML = Extensible Markup Language, which is actually a subset of SGML;P (Standard Generalised Markup Language) It allows a web type developer to create their own "user defined" tags, that web ...
    Mark LeithMark Leith
    May 1, 2002 at 10:13 am
    May 6, 2002 at 1:43 pm
  • Dear gurus: I just added a data file to a big tablespace (11GB) that has only one table. Unfortunately, when it was being backed up, the file head head corrupted. I don't have any backup of this ...
    Xie, TomXie, Tom
    May 15, 2002 at 4:58 pm
    May 22, 2002 at 12:23 pm
  • Okay, my background is OLTP, but we are looking at a data warehousing project here.... any and all help appreciated! Specifically: does anyone have any experience with a product called "SAS ...
    Rachel_Carmichael_at_Sonymusic.comRachel_Carmichael_at_Sonymusic.com
    May 3, 2002 at 10:08 pm
    May 8, 2002 at 12:08 am
  • Good HR: You are a valued asset, you will be paid what you are worth. Bad HR: I'm sorry, your job description has a high and low salary range and you are bumped up against the high range. Any ...
    Freeman, RobertFreeman, Robert
    May 8, 2002 at 3:58 pm
    May 13, 2002 at 1:28 pm
  • Thanx Stephane . I did the same STAARSHIP TECHNOLOGIES www.staarship.com Kranti Pushkarna Project Leader Tel: +91-22-6931557 " Failure to prepare is preparing to fail " -----Original Message----- ...
    Kranti pushkarnaKranti pushkarna
    May 1, 2002 at 7:38 am
    May 31, 2002 at 4:28 pm
  • Hello: Out of curiosity how would you classify a Jr. DBA, a Mid Level DBA, and a Sr. DBA? I know how our HR department makes the division but would be interested in knowing how other people might ...
    Jay WadeJay Wade
    May 30, 2002 at 6:08 pm
    May 31, 2002 at 8:07 pm
  • Lisa, There is only so much you can control via a model, since it remains a process away from the DB, and cannot be enforced via privileges, etc. So, we are always in the hands of Dom Phoc (and their ...
    Keith PetersonKeith Peterson
    May 2, 2002 at 5:54 pm
    May 9, 2002 at 12:08 am
  • As a side note, please please please become familiar with OpenVMS and more importantly Oracle on OpenVMS before tackling this. At least as far up as 8i, Oracle has really done themselves a disservice ...
    Jesse, RichJesse, Rich
    May 23, 2002 at 3:33 pm
    May 24, 2002 at 9:13 pm
  • Ok i'm messing with dimensions. dm_time to be exact: create table dm_time ( calendar_date date not null, calendar_month number(2) not null, calendar_qtr number(1) not null, calendar_year number(4) ...
    Joe TestaJoe Testa
    May 20, 2002 at 11:08 pm
    May 22, 2002 at 9:38 pm
  • Anyone on the list done a comparison(or worked with both) MySQL and Oracle and can give me the good/bad points of My SQL? Doing interviewer thing and someone has My SQL who would like to move into ...
    Joe TestaJoe Testa
    May 31, 2002 at 2:38 pm
    May 31, 2002 at 11:14 pm
  • Are these addons to OEM worth buying? Thanks Peter Schauss Northrop Grumman Corporation schaupe_at_mail.northgrum.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author ...
    Schauss, PeterSchauss, Peter
    May 10, 2002 at 3:58 pm
    May 14, 2002 at 1:58 am
  • I am new to his books, three chapters in. The first release of the "Data Warehouse Toolkit" defines a data warehouse much as a data mart is today. Today we think of a data warehouse as having a ...
    MacGregor, Ian A.MacGregor, Ian A.
    May 22, 2002 at 12:48 am
    May 24, 2002 at 3:43 pm
  • Hi All Is there any method in Oracle to capture or order the rows in a table in the order they were entered. I tried it with rowid but when a row is deleted, the rowid corresponding to this row is ...
    systems_ho/VGIL_at_vguard.satyam.net.insystems_ho/VGIL_at_vguard.satyam.net.in
    May 15, 2002 at 6:08 am
    May 17, 2002 at 8:13 am
  • ERWin and ERStudio are basically in the 3,000 to 4,000 price range, depending on what add-ons you take and yearly maintenance license. When I reviewed them in 2001Q4, ERStudio was the only one that ...
    Grabowy, ChrisGrabowy, Chris
    May 1, 2002 at 5:48 pm
    May 3, 2002 at 12:48 am
  • Hi Can anybody explain the events like SQL*Net message from client,rdbms ipc message PX Idle Wait,slave wait ... Can I assume a i/o bottleneck from the following statistics as most of the i/o events ...
    S BS B
    May 16, 2002 at 9:33 am
    May 23, 2002 at 10:19 pm
  • Hello, Oracle 8.1.6 on HP-UX 11.0 WFM_ADMIN_at_VGRAFO select num_rows,last_analyzed,monitoring from user_tables where table_name = 'NOTES_LOG'; NUM_ROWS LAST_ANAL MON ---------------- ------- 1585697 ...
    BALA,PRAKASH (Non-HP-USA,ex1)BALA,PRAKASH (Non-HP-USA,ex1)
    May 15, 2002 at 5:03 pm
    May 16, 2002 at 6:48 pm
  • HI AGAIN, JUST WANT TO CHECK WITH YOU GUYS, MY LISTENER.LOG IS GETTING BIG I TRY TO RENAME IT THEN CREATE A NEW LISTENER.LOG BUT STILL THE OLD ONE IS USING BY ORACLE. HOW CAN I TRUNCATE THE ...
    Hamid AlaviHamid Alavi
    May 1, 2002 at 5:18 pm
    May 2, 2002 at 12:18 pm
  • Hello all, because I am an human being I am also looking for the easiest solution :-) So, I need to have a training session concerning basic oracle features. I wonder if anyone of you know place/site ...
    Kminerva_at_jippii.fiKminerva_at_jippii.fi
    May 6, 2002 at 9:08 am
    May 9, 2002 at 10:06 pm
  • List: We've been fighting problems for several days. I've sort of overwhelmed myself with data, but I don't know what any of it means. Solaris 2.6, Oracle 8.0.5, MTS Users complain of extreme ...
    Baker, BarbaraBaker, Barbara
    May 23, 2002 at 10:13 pm
    May 28, 2002 at 11:08 am
  • Summary: it works! SQL SELECT * FROM v$version; BANNER Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE 9.2.0.1.0 Production TNS for Solaris ...
    Toepke, Kevin MToepke, Kevin M
    May 22, 2002 at 2:38 pm
    May 23, 2002 at 7:06 pm
  • Hi Tim and Connor, Thanks you all for your very helpful feedback. I do appreciate it very much. In fact, we are in development at this point, so the database is small and transaction volume is very ...
    Meomeo NguyenMeomeo Nguyen
    May 24, 2002 at 5:12 pm
    May 28, 2002 at 4:38 pm
  • Hi all, My export dumps are too big (80 GB) for my filesystem and I'm looking for a way to compress them on the fly -ie without taking *.dmp to disk first but straight *.dmp.gz Anybody with an idea ...
    Simon WaibaleSimon Waibale
    May 16, 2002 at 9:38 am
    May 20, 2002 at 2:33 pm
  • We have some UNIX batch processes that send us e-mails when they have finished. Does anyone have any experience of sending a SMS message to a mobile phone? Simon Fox Room 221 Furlong House Queens ...
    FOX, SimonFOX, Simon
    May 13, 2002 at 1:03 pm
    May 14, 2002 at 9:53 am
  • Dear list ! There is something strange going on in my production DB. There is a program that reads fom 2 huge tables (A and B - select only) and writes a fraction of records into some third table ...
    Andrey BronfinAndrey Bronfin
    May 27, 2002 at 12:53 pm
    May 28, 2002 at 10:03 pm
  • Hi All, I need to perform a consistent backup for my whole database every Friday by using operating system utilities. My database has been currently operating in NOARCHIVELOG mode, so the only files ...
    Meomeo NguyenMeomeo Nguyen
    May 23, 2002 at 11:33 pm
    May 26, 2002 at 4:43 pm
  • I don't know whether this is a tangent, but I notice that on the windows platform, "compressed" exports can still get 85% compression when zipping them with WinZip. Obviously Oracle "compressed=y" ...
    Boivin, Patrice JBoivin, Patrice J
    May 16, 2002 at 3:08 pm
    May 16, 2002 at 5:57 pm
  • Hi I am getting "ORA-000060: Deadlock detected" error.I know this is the deadlock situation.But my question is how to correct this problem. Thx -Seema Join the world’s largest e-mail service with MSN ...
    Seema SinghSeema Singh
    May 15, 2002 at 7:18 pm
    May 16, 2002 at 1:18 pm
  • Slap me if this is a dumb question. Here's my pay methods SQL SELECT ASCII(PAY_METHOD), PAY_METHOD, COUNT(*) 2 FROM LEISURE_PLAN_MASTER_TEMP 3 WHERE MEMBERSHIP_CLASS = 'D' 4 GROUP BY PAY_METHOD ...
    Koivu, LisaKoivu, Lisa
    May 3, 2002 at 11:43 pm
    May 7, 2002 at 3:58 am
  • Hi All! My client run big update 20,000 statements. I need to know how many rows was updated (it's could be any number). I thinking about triggers, but this table can be updated not only with this ...
    Greg FaktorGreg Faktor
    May 30, 2002 at 1:48 pm
    May 30, 2002 at 6:58 pm
  • Hi, Does Oracle reccommend having the initial and next extents set at the same values??? I am tidying up a current schema and the values are non uniform all the way through- any comments would be ...
    Malik, FawziaMalik, Fawzia
    May 28, 2002 at 4:18 pm
    May 29, 2002 at 3:18 pm
  • All I know this has been mentioned on this list before but I forget... Which is the script in $ORACLE_HOME/rdbms/admin folder that contains the list of all events? TIA Babu -- Please see the official ...
    Babu NagarajanBabu Nagarajan
    May 14, 2002 at 7:48 pm
    May 15, 2002 at 2:58 pm
  • 12

    WAITS

    Hi I checked wait in my database and found the following are top 5 waits. Event Waits single-task message 1,411,047 log file sync 326,222 SQL*Net more data to client 7,363,877 control file parallel ...
    Seema SinghSeema Singh
    May 9, 2002 at 6:18 pm
    May 15, 2002 at 12:58 am
  • Hello, I was wondering if there is any tool or script which can get the SQL and its associated bind values from 10046 (level 12) trace file and format it in a readable way.. Any hints will be highly ...
    Mohammed.Ahsanuddin_at_VerizonWireless.comMohammed.Ahsanuddin_at_VerizonWireless.com
    May 7, 2002 at 11:18 pm
    May 10, 2002 at 7:48 pm
  • Does anyone know of or have a list of new features/fixes for Release 2 of 9i? I can't find anything on oracle.com except XML XML XML. Just wondering if OiD gets any better, I guess. :) TIA, Rich ...
    Jesse, RichJesse, Rich
    May 3, 2002 at 7:38 pm
    May 6, 2002 at 10:30 pm
  • Any messages in the alert file, like dynamic lock allocation or resource allocation ? In Oracle8 locks and resources for OPS are dynamically allocated from the shared pool after the initial values of ...
    Anjo KolkAnjo Kolk
    May 2, 2002 at 7:29 pm
    May 3, 2002 at 3:43 pm
  • Do not believe everything which is printed. Unless of course you believe that the authors of 'The little Red Book' or 'Mein Kampf' had the best of vision of how the world should be. In other words, ...
    Stephane FaroultStephane Faroult
    May 1, 2002 at 8:28 am
    May 3, 2002 at 2:53 pm
  • List, slightly off topic but Unix OS I need to join lines/ words in a file. So that it must be in a readable Oracle format. They are seperated by a newline. Here is a snippet of what the file looks ...
    Suhen PatherSuhen Pather
    May 29, 2002 at 3:58 am
    May 30, 2002 at 6:48 pm
  • _tru64_directio_disabled Stands for Direct IO support Disabled Current Default Value of _tru64_directio_disabled is FALSE ? Qs What would be the SAFE & Advisable to set _tru64_directio_disabled to ...
    VIVEK_SHARMAVIVEK_SHARMA
    May 26, 2002 at 3:23 pm
    May 30, 2002 at 5:38 pm
  • Before any public outcry I checked in with, and got permission, from list moderator to make this posting!!! Acknowledging we're geographically remote for most members of this list..... (but maybe ...
    O'Neill, SeanO'Neill, Sean
    May 28, 2002 at 2:28 pm
    May 30, 2002 at 2:53 pm
  • I was wondering if anyone might have tried this before, because I can't seem to get it to work. I'd like to be able to determine which unit of measure to concatenate to a value by using a decode ...
    Yexley Robert D Contr Det 1 AFRL/WSIYexley Robert D Contr Det 1 AFRL/WSI
    May 20, 2002 at 3:08 pm
    May 24, 2002 at 7:18 am
  • hi, I am a beginner in Oracle and I need help. I need to implement a interactive connection of oracle with web. I need to save data from web to database, make a kind of processing and send a response ...
    Keith CarneyKeith Carney
    May 18, 2002 at 4:43 pm
    May 22, 2002 at 3:53 pm
  • ever wonder why SQLPlus is so damn robost? It can do just about anything... in a messy and time consuming way sometimes, but it is rock solid. "About 15 years ago, Sqlplus WAS Oracle". Nothing else ...
    Keith PetersonKeith Peterson
    May 17, 2002 at 2:53 pm
    May 17, 2002 at 11:23 pm
  • Hi List, When I try to create a new database (8.1.7) under sun solaris I got the following error: ORA-03113: end-of-file on communication channel Any Idea? Any help realy appreciated. This is the ...
    Hamid AlaviHamid Alavi
    May 2, 2002 at 6:28 pm
    May 3, 2002 at 4:58 pm
  • Under what conditions would an 'alter index .. rebuild' actually case the size of the index to increase by about 12 percent? Matt Adams - GE Appliances - matt.adams_at_appl.ge.com Contrary to popular ...
    Adams, Matthew (GEA, MABG, 088130)Adams, Matthew (GEA, MABG, 088130)
    May 31, 2002 at 3:39 pm
    May 31, 2002 at 8:23 pm
May 2002
12345…13
Group Navigation
period‹ prev | May 2002 | next ›
Group Overview
grouporacle-l @
categoriesoracle
discussions637
posts3,081
users399
websiteoracle.com

399 users for May 2002

DENNIS WILLIAMS: 110 posts Jared.Still_at_radisys.com: 96 posts Tim Gorman: 90 posts Rachel Carmichael: 68 posts Rachel_Carmichael_at_Sonymusic.com: 56 posts Stephane Faroult: 50 posts Dgoulet_at_vicr.com: 49 posts Grabowy, Chris: 47 posts Jack Silvey: 47 posts Jesse, Rich: 43 posts Yechiel Adar: 39 posts Mercadante, Thomas F: 34 posts Ron Rogers: 34 posts Anjo Kolk: 30 posts Sergey V Dolgov: 29 posts Yechiel Adar: 29 posts Gene Sais: 28 posts Jamadagni, Rajendra: 28 posts Steven Lembark: 28 posts Cherie_Machler_at_gelco.com: 27 posts
show more
Archives