Search Discussions

689 discussions - 2,322 posts

  • Are any of the floks from the list meeting during the IOUG-A live in Florida. I am attending and would like to join the meeting. Murali Vallath Get your FREE download of MSN Explorer at ...
    Murali VallathMurali Vallath
    Apr 17, 2001 at 1:51 am
    Apr 18, 2001 at 8:45 pm
  • Hi DBAs and SAs, I had a task to do housekeep ...\bdump\alertSID.log What logs usually Oracle system need to housekeep, and what are these directory cdump, bdump and udump for ? Thank you for your ...
    Sinardy XingSinardy Xing
    Apr 24, 2001 at 2:04 am
    Apr 25, 2001 at 8:21 pm
  • Sinclair was a brand of personal computers that came out in the UK about 20 years ago, If memory serves, they started of with the ZX 81 which had a whole 1K of memory. Their next offering was the ...
    Apr 4, 2001 at 7:09 pm
    Apr 5, 2001 at 5:59 pm
  • Disclaimer: I am *not* trying to start a religious war, and I am *not* trying to advocate DB2. I am simply offended. Thus this post. As some may remember, I'm doing an evaluation of Oracle vs DB2 vs ...
    Dennis TaylorDennis Taylor
    Apr 24, 2001 at 4:28 pm
    Apr 25, 2001 at 8:15 pm
  • Stupid "BUSH" time! Stupid US people select Bush as president. Stupid DBAs. Stupid job mkt. Stupid software Engineer! I am considering to change to be a nurse associate or something like that. Best ...
    Robert ChenRobert Chen
    Apr 13, 2001 at 9:46 pm
    Apr 17, 2001 at 4:40 pm
  • What's your experience about the temporary table design? I read Michael Ault's Orcale8 Administartion and Management, it says "For Cost-based optimization, it should be 4 times of the largest ...
    CC HarvestCC Harvest
    Apr 12, 2001 at 8:32 am
    Apr 18, 2001 at 7:01 pm
  • Are you using uniform extents? We are told they are not really = and actually are not the same at all over time. Thanks, --- TheOracleDBA theoracledba_at_lycos.com On Thu, 19 Apr 2001 15:25:31 Peter ...
    The Oracle DBAThe Oracle DBA
    Apr 23, 2001 at 5:45 pm
    Apr 26, 2001 at 8:32 pm
  • Hello List, For those of you that use Perl or would like to use Perl for your regular DBA tasks, I have a request. Do you have any tasks you perform with a series of SQL scripts, shell scripts, etc, ...
    Jared StillJared Still
    Apr 23, 2001 at 5:52 pm
    Apr 25, 2001 at 8:42 pm
  • I foresee the database being sold as a turn key product configured by Oracle at a reduced price. In order to receive the discount the purchaser would have to agree not to mess with the init.ora ...
    MacGregor, Ian A.MacGregor, Ian A.
    Apr 25, 2001 at 9:44 pm
    Apr 30, 2001 at 4:37 pm
  • Hello everyone, After moving the listener.log and compressed, there is no more log for the listener. Could anyone help me please ? Thanks. Nguyen
    Nguyen Thanh-trucNguyen Thanh-truc
    Apr 24, 2001 at 3:07 pm
    Apr 25, 2001 at 8:02 pm
  • Hi all, I need to permanently get rid off some files from the database. I did this: alter database datafile '/orafs/ora1/oradata/LUCP/users02.dbf' offline drop rm the file from physical directory ...
    Andrea OracleAndrea Oracle
    Apr 12, 2001 at 4:29 pm
    Apr 14, 2001 at 2:02 am
  • Who said unix is unix, not me. I have worked w/ HPUX, Digital Unix, Linux, and Solaris. All of these support some form of automatic shutdown/startup scripts found in rc.d directorires, etc. I can not ...
    Gene SaisGene Sais
    Apr 2, 2001 at 3:22 pm
    Apr 11, 2001 at 5:23 am
  • Hi Folks, I know lot of Metastink info floating around...so I thought I would post this for fun/info . I got this response from Metastink .. "Thank you for your comments on Metalink, the more ...
    Raj SakthiRaj Sakthi
    Apr 3, 2001 at 1:43 pm
    Apr 4, 2001 at 6:13 pm
  • Hi Intelligent DBA's I was wondering if anyone knows how to create a trigger that would fire off at database startup time and run a script to do full table scans on several tables to get them into ...
    Kevin KostyszynKevin Kostyszyn
    Apr 5, 2001 at 8:25 pm
    Apr 9, 2001 at 10:44 pm
  • How can I change this pl/sql code, in the while-statement maybe so that if the field OWNER_NO is NULL, then it should be written six characters? The code looks like this: "IF recCursor.OWNER_NO is ...
    Apr 19, 2001 at 3:21 pm
    Apr 20, 2001 at 12:40 pm
  • Hi, My database is noarchive mode, what should I do to prevent from lossing any transactions ? Like for example incresed the REDO buffer to ... (daily buffer)? Will this decrese the performance ? any ...
    Sinardy XingSinardy Xing
    Apr 5, 2001 at 9:47 am
    Apr 7, 2001 at 10:16 pm
  • I've got a developer that says they need the unix password for oracle so they can do a trace and run tkprof without having to jump through a bunch of hoops. Anyone set up trace so someone other than ...
    David TurnerDavid Turner
    Apr 20, 2001 at 7:05 pm
    Apr 24, 2001 at 5:13 am
  • Hello list, We are beginning a proyect in ORACLE, and I wonder myself if there is any place where I could find any real implementation, or any experience (good or horrible.....) for orienting ...
    Beatriz MartinezBeatriz Martinez
    Apr 19, 2001 at 7:16 am
    Apr 23, 2001 at 5:01 pm
  • right now, I understand US people also just belive TV or news. The news always controlled by goverment or service for the goverment. This fact is for sure that US is high-handed and arbitrary. US ...
    Robert ChenRobert Chen
    Apr 16, 2001 at 8:45 pm
    Apr 17, 2001 at 4:33 pm
  • Dick, Thanks! SAME also suggests using the "outer half" of each disk for data storage...as I/O performance is increased due to the natural circular shape of the platter. My question...how do you ...
    Apr 24, 2001 at 3:07 am
    Apr 25, 2001 at 12:50 am
  • Hello all, I need help. I need to write a shell script (aix box), when ever some loads a piece of software. How is this possible using unix shell scripting? can some one please send a skeleton of it ...
    Viraj LuthraViraj Luthra
    Apr 10, 2001 at 1:57 am
    Apr 11, 2001 at 6:37 pm
  • I think I've seen an answer to this, but I never needed it before. If anyone can help, I would greatly appreciate it. We are trying to ftp files from one server to another. (Archive logs for ...
    Terry BallTerry Ball
    Apr 3, 2001 at 4:55 pm
    Apr 4, 2001 at 3:25 pm
  • Listers, Can someone tell me how to automate procedure execution from within Oracle. I would like to execute this procedure at 10:00 p.m. sqlplus execute jrunit Thank in advance. abdullatif
    Abdul latifAbdul latif
    Apr 20, 2001 at 6:35 pm
    Apr 30, 2001 at 12:54 am
  • I am executing a SQLLDR shell file from a server :: sourceserv; RDBMS AIX 4.3.2 into a database on server:: destserv; RDBMS 8.1.5 AIX 4.3.3 using a SQL*Net connect string destserv_destSID ...
    Apr 23, 2001 at 2:51 pm
    Apr 24, 2001 at 8:20 pm
  • The subject of Veritas came up at work today, and I'm curious. How widely used is Veritas in Oracle environments? Best regards, Jonathan Gennick mailto:jonathan_at_gennick.com * 906.387.1698 ...
    Jonathan GennickJonathan Gennick
    Apr 2, 2001 at 4:10 pm
    Apr 4, 2001 at 4:29 pm
  • Hi ! Is there a way to get GMT time within PL/SQL independent from the local time(zone), I'm looking for a function similar to SYSDATE, but it should return GMT instead of the local time. TIA Andreas ...
    Haunschmidt Andreas VASL/FASHaunschmidt Andreas VASL/FAS
    Apr 3, 2001 at 3:34 pm
    Apr 3, 2001 at 8:48 pm
  • Listers, I was involved in a meeting today, strictly as a listener (no pun intended). A consultant made the statement that pinned packages are subject to being aged out of the shared pool, using an ...
    Apr 27, 2001 at 12:36 am
    Apr 30, 2001 at 5:56 pm
  • Anyone implemented SBDBs recenetly? A client is comparing them to a cluster solution involving Fail-Safe. We are recommending SBDB and trying to go to 817 also (on 80521 now). Also this is NT if that ...
    The Oracle DBAThe Oracle DBA
    Apr 26, 2001 at 5:49 pm
    Apr 30, 2001 at 2:59 pm
  • Hello folks! I am working in SUN solaris 5.6 with Oracle 8i. I want to implement MTS on the Oracle server. Next we are running with Rule based optimizer and we want to change to costbased optimizer ...
    Apr 24, 2001 at 9:21 am
    Apr 25, 2001 at 1:15 am
  • Hey, Guys: I need to decalre a cursor inside a FOR .. LOOP, because the variables in SELECT statement for the CURSOR are coming from FOR .. LOOP. How could I do this? DECLARE V_AKTIV_NR ...
    Wendy YWendy Y
    Apr 3, 2001 at 6:07 pm
    Apr 4, 2001 at 7:11 pm
  • If I remember right .... we should be having a Birthday Party for Oracle-L list. Thanks everyone for making this list a wonderful, learning community. Thanks Jared and Bruce for providing this ...
    Jamadagni, RajendraJamadagni, Rajendra
    Apr 26, 2001 at 12:54 pm
    Apr 27, 2001 at 8:00 pm
  • SET ORACLE-L MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: aheda_at_cdotd.ernet.in Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, ...
    Apr 2, 2001 at 7:34 am
    Apr 26, 2001 at 9:54 pm
  • I've got a such error when run a PL/SQL scripts on Windows 2000, Orcale 8.1.7 with 128MB memory ORA-04030: out of process memory when trying to allocate 257280 bytes (PLS non-lib hp,PAR.C:parchk:ptb) ...
    Dorozhkin, AntonDorozhkin, Anton
    Apr 21, 2001 at 11:21 am
    Apr 25, 2001 at 5:50 pm
  • Well, I just went to open a TAR and discovered yet another Metalink catastrophe. Not content with slow service and error messages they've come up with a new one: When I go to create a TAR it asks me ...
    Miller, JayMiller, Jay
    Apr 19, 2001 at 6:45 pm
    Apr 19, 2001 at 8:08 pm
  • All, Is there a method for allowing a non DBA user to kill their own (and only their own) session. I have had a trawl through Metalink and have seen various methods (using procedures) of doing it but ...
    lerobe - Lee Robertsonlerobe - Lee Robertson
    Apr 17, 2001 at 2:46 pm
    Apr 19, 2001 at 6:42 pm
  • How can one determine via code (PL/SQL) whether or not the current session is connected "directly" (via the Bequeath protocol) or via SQL*Net? The solution needs to work for both V7 & V8. -- Charlie ...
    Charlie MenglerCharlie Mengler
    Apr 18, 2001 at 4:50 pm
    Apr 19, 2001 at 5:16 pm
  • The database is running in NOARCHEVELOG mode : Oracle manual says that 'you can skip tablespaces, but skipped tablespace that has not been offline or read-only since its last backup will be lost if ...
    Rahul DandekarRahul Dandekar
    Apr 11, 2001 at 7:32 pm
    Apr 18, 2001 at 6:35 pm
  • Have you seen this? http://www.oracle.com/ip/deploy/database/featurestory/index.html?wintergrp.h tml Regards, Patrice Boivin Systems Analyst (Oracle DBA) Bedford Institute of Oceanography Fisheries ...
    Boivin, Patrice JBoivin, Patrice J
    Apr 5, 2001 at 2:22 pm
    Apr 5, 2001 at 5:36 pm
  • List, I am playing with the idea of loading my PC with Linux and Oracle for test purposes( We have to migrate from Novell in the near future). What have you found to be the most compatible and ...
    Ron RogersRon Rogers
    Apr 2, 2001 at 7:57 pm
    Apr 4, 2001 at 7:52 pm
  • All I am sure this question has come up here before. I need to get the limited number of rows from a table at a time (say 20 rows ) using sql . I know this can be achieved using PL/SQL. This is ...
    Surjit SharmaSurjit Sharma
    Apr 3, 2001 at 1:04 pm
    Apr 4, 2001 at 3:10 pm
  • this is not to bring up a heated debate over the two platforms... I am making a proposal to move the current access 97 databases to an oralce platform running solaris.... I would like to put in the ...
    Roy FergusonRoy Ferguson
    Apr 30, 2001 at 5:46 pm
    Apr 30, 2001 at 9:09 pm
  • I find a lot of the discussions about Oracle's pricing be too much when not taking into account anything else way to funny. First off, yes I could get SQL Server for a whole lot less then Oracle but ...
    Kimberly SmithKimberly Smith
    Apr 25, 2001 at 8:40 pm
    Apr 26, 2001 at 9:40 pm
  • Steve, I heard about this SAME philosophy at the last NorthEast Oracle Users Group meeting from a individual who works on the utilities for Oracle in the New England Development Office. Although we ...
    Apr 20, 2001 at 3:45 pm
    Apr 23, 2001 at 6:04 pm
  • How can I in a sqlloader, the control file replace a ? with a 0 at the same as it i sloading the data into the database? The ? could be anywhere in any field. Roland Sköldblom -- Please see the ...
    Apr 6, 2001 at 10:36 am
    Apr 19, 2001 at 6:52 pm
  • Listers, Currently running a Dev2k 2.1 web enabled application using 7.3.4 on an HP-UX V2500 16 processor box with the Forms servers and OAS 3.x running on 5 HP-UX "D" class machines and the Reports ...
    Apr 12, 2001 at 11:35 pm
    Apr 17, 2001 at 4:47 pm
  • O Esteemed and Wise Colleagues, (My first sending of this didn't seem to make it to the list... Knowing our mail server it may show up in a few weeks!) How do application (Forms or other) users ...
    Yosi GreenfieldYosi Greenfield
    Apr 11, 2001 at 7:45 pm
    Apr 13, 2001 at 4:29 pm
  • LoL! The "Winter Corporation"? Which databases were included? The Olympics one that IBM did on DB2? The Terraserver database? The SETI one? 2500 Transactions per second is the fastest they did? A ...
    Mohan, RossMohan, Ross
    Apr 5, 2001 at 6:30 pm
    Apr 6, 2001 at 4:24 pm
  • Is there a way to kill (other than kill session) a thread that is doing an insert - nologging? I have tried "alter system kill session" to no avail. It gives me the message "marked for kill" but the ...
    Chesebro, EricChesebro, Eric
    Apr 4, 2001 at 6:32 pm
    Apr 5, 2001 at 9:03 pm
  • Hi, I issue the command "alter database backup controlfile to trace", expecting my trace file to reside in the user_dump_dest directory. connect / as sysdba; startup ...
    CHAN Chor Ling Catherine (CSC)CHAN Chor Ling Catherine (CSC)
    Apr 26, 2001 at 7:41 am
    Apr 28, 2001 at 3:44 pm
  • I have heard, but have not been able to confirm that May is Oracle's fiscal year-end. Does anyone have any information regarding this? I have also heard that May, being Oracles' year-end is the best ...
    Tom SchrueferTom Schruefer
    Apr 26, 2001 at 4:22 pm
    Apr 27, 2001 at 3:02 pm
Group Navigation
period‹ prev | Apr 2001 | next ›
Group Overview
grouporacle-l @

421 users for April 2001

Eric D. Pierce: 84 posts Jkstill_at_cybcon.com: 75 posts Dgoulet_at_vicr.com: 62 posts Mohan, Ross: 54 posts Tim Sawmiller: 50 posts Gogala, Mladen: 45 posts Mark Leith: 45 posts Kevin Kostyszyn: 36 posts David A. Barbour: 34 posts Steve Adams: 34 posts Hillman, Alex: 29 posts Boivin, Patrice J: 27 posts Ruth Gramolini: 27 posts Ron Rogers: 26 posts Haskins, Ed: 25 posts Rachel Carmichael: 23 posts Deshpande, Kirti: 22 posts Paquette stephane: 22 posts Dennis Taylor: 21 posts Jacques Kilchoer: 21 posts
show more