| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> 8.03 Intelligent Agent on NT4.0 SP5
Hi,
I have a problem with the Intelligent Agent Service on NT4.0 SP5. The Oracle Server is version 8.0.3, and yes, I know that it is no longer supported. This is being evaluated and used for training.
The Agent service will not start. If you let it go it eventually comes up with:
Could not start the OracleAgent Service on \\PCXXXX
Error 2186 The service is not responding to the control function
And thereafter DBSNMP.EXE whacks the CPU, (100% from then on), and cannot be killed through the task manager, only a reboot will fix it. No resource kit for kill.
Oracle was installed (and reinstalled 3 times) in an account that has full Administrator privilege.
I wonder whether this is an SP5 thing?
I have got a few unexplored avenues, but was interested whether anyone has come up against this before.
TIA. Tony
-- S. Anthony Sequeira Wait for the ricochet Opinions expressed herein are my own and do not necessarily represent those of my employer ------------------------------ From: Winnie_Liu_at_infonet.com Date: Tue, 13 Jun 2000 09:44:46 -0700 Subject: Re: Migration Probs I don't think that it's a two step migration. It's only one step as long as you are on at least 7.3.X. But correct me if I am wrong! Winnie :) "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> on 06/13/2000 08:14:50 AM Please respond to ORACLE-L_at_fatcity.com To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC) Subject: Re: Migration Probs I think this has to be a two step migration: 1) to 8.0.x and 2) from 8.0.x to 8.1.x. Ruth ----- Original Message ----- To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 13, 2000 8:46 AMReceived on Tue Jun 13 2000 - 09:23:24 CDT
> Hi Dba's,
> I am trying to migrate 7.3.4 to 8.1.6 on sun sparc but in vain,
> when i start the mig utility manually by using
> mig pfile=init.ora it gives an error as below
>
> $ mig pfile=INIT.ORA
> starting up database ...
> mounting database ...
> opening database ...
>
> #^ connect (internal)
>
> drop table grant_mig_priv$;
> create table grant_mig_priv$ (
> name varchar2("M_IDEN"),
> owner varchar2("M_IDEN"),
> grantorname varchar2("M_IDEN"), /* grantor user
number
> */
> granteename varchar2("M_IDEN"), /* grantee user
number
> */
> privilege# number not null, /* table privilege
number
> */
> sequence# number not null, /* unique grant
sequence
> */
> parent rowid, /*
parent
> */
> option$ number, /* null = none, 1 = grant
option
> */
> col# number); /* null = table level, column id if column
grant
> */
>
>
> insert into grant_mig_priv$
> select o.name,
> u4.name,u1.name,u2.name,privilege#,sequence#,parent,option$,col#
> from objauth$ auth ,user$ u1,user$ u2,user$ u3,obj$ o,user$ u4
> where u1.user# = auth.grantor#
> and u2.user# = auth.grantee#
> and o.obj# = auth.obj#
> and o.type <> 10
> and u4.user# = o.owner#
> and o.owner# = u3.user#
> and u3.name like 'SYS%';
> ORA-01552: cannot use system rollback segment for non-system tablespace
> 'USERS'
>
> Now I have rollback segments which are public and down below and which
has
> also been specified in the init.ora file.
> Can somebody please let me know as to what is the probs and how I can
solve
> this
> Thanks in advance
> Arun
> ________________________________________________________________________
> Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com
>
> --
> Author: ARUN K C
> INET: arun_k_c_at_hotmail.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
-- Author: Ruth Gramolini INET: rgramolini_at_tax.state.vt.us Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: Winnie_Liu_at_infonet.com Date: Tue, 13 Jun 2000 09:48:09 -0700 Subject: Re:How to set the job's interval But the problem for this is, if the job run @15th minute for about 5 minutes, then the next time it will start @35th minutes for another 5 minutes, then the time after that will be @55th minute etc... If he does not mind that, then the formula will work. I still find that the best way to make the database to run the job in a particurlar time and interval is CRON! Winnie :) dgoulet_at_vicr.com on 06/13/2000 07:31:25 AM Please respond to ORACLE-L_at_fatcity.com To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Winnie Liu/HQ/ISC) Subject: Re:How to set the job's interval The DBMS_JOB submit and next_date procedures require a character string that it can evaluate into a date. Therefore all of the tricks you know for converting data into dates works. In your case try the following: "sysdate+(15/60)/24" The point is to get the job to start at the correct time. ____________________Reply Separator____________________ Author: cyhu_at_eachnet.com Date: 6/12/00 6:58 PM Hi,can anyone tell me how to set the job's interval so that the job can run at 15,30,45,60 minutes every hour. Thanks in advance. ------------------------------- http://www.eachnet.com Tel(O)??86-21-52340871/0872*667 E-mail??cyhu_at_eachnet.com ??Eachnet.com - CHINA's LARGEST ON-LINE CONSUMER TRADING COMMUNITY?? ------------------------------- -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: "Ruth Gramolini" <rgramolini_at_tax.state.vt.us> Date: Tue, 13 Jun 2000 12:51:20 -0400 Subject: Re: How much Unix? You either have to have a lot of UNIX or a very nice SA. I have the latter. Ruth ----- Original Message ----- From: Richard Ji <richard_at_letsplay.com> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> Sent: Tuesday, June 13, 2000 11:00 AM Subject: RE: How much Unix?
> In my opnion, a DBA( who support Oracle on Unix) should have at least an
> entry level of System Administrator's knowledge about Unix. The more the
> better. I have seen and heard about too many DBA waste a lot of time
> trouble shooting because they don't know enough about Unix or was
> misinformed by their SAs. Some times it's best to take matter into your
own
> hands instead of relying too much on the SA.
>
> Richard Ji
>
> -----Original Message-----
> Sent: Monday, June 12, 2000 7:45 PM
> To: Multiple recipients of list ORACLE-L
>
>
> If your an Oracle DBA, How much Unix should you know? Shell programming?
> etc....
>
>
------------------------------ From: "Robin Li" <rli_at_nyp.org> Date: Tue, 13 Jun 2000 13:01:04 -0400 Subject: chained rows -- Hi all, Our monitoring tool reports that there are chained rows in the database. We analyze the schema once a week and get no rows returned from: select owner, table_name, chain_cnt/num_rows*100 "chain%" from dba_tables where num_rows <> 0 and chain_cnt <> 0; The tech person from the monitoring tool's company told us that they determined chained rows by 'select value from v$sysstat where name ='table fetch continued row'; We do have a value returned from that query: VALUE ---------- 24132 My question is: how to find out which table has the chained row? TIA Robin **************************************************************** * Robin Li * * Technical Specialist, DBA Phone#: (212) 297-3073 * * FCG Management Services Fax#: (212) 297-4231 * * 333 East 38th Street, 2nd fl. E-mail: rli_at_nyp.org * * New York, NY 10016 * **************************************************************** ------------------------------ From: Kiran Kumar <KKumar_at_rpsrx.com> Date: Tue, 13 Jun 2000 12:58:53 -0400 Subject: RE: export error check your column name in the table which you are dumping.do the following steps prepare the index file for that table you are dumping and check whether the same table is existing and also check the columns bye -----Original Message----- From: Gurgaon, DBA (CAP, GECSI, CONTRACTOR) [mailto:DBA.Gurgaon_at_geind.GE.com] Sent: Tuesday, June 13, 2000 5:10 AM To: Multiple recipients of list ORACLE-L Subject: export error Hi to All I'm trying to export full database and I'm getting this error EXP-00008: ORACLE error 904 encountered ORA-00904: invalid column name EXP-00000: Export terminated unsuccessfully Below is also the export logfile attached. my Oracle version is 8.1.5 on Sun Solaris 2.7 thanks in advance Vikas <<exp_log.doc>> ------------------------------ From: Kiran Kumar <KKumar_at_rpsrx.com> Date: Tue, 13 Jun 2000 13:01:51 -0400 Subject: RE: RE Startup on boot during the sync execution it tries to update the master file system file.By exectuing 3 times we are giving enough time to complete the SYNC process nothing else -----Original Message----- From: john.j.kanagaraj_at_shell.com.bn [mailto:john.j.kanagaraj_at_shell.com.bn] Sent: Monday, June 12, 2000 9:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: RE Startup on boot <snip> # sync; sync; sync; poweroff
>(Note: I have no idea why they sync three times, but every sysadmin
> I've ever met does. I've checked, and a single time would be enough.
> Must be some weird tribal tradition.)
Guy, The three 'sync's are akin to 'die, die, die' - shoot the alien thrice just to be sure! Seriously, I used to type in 'sync' at the keyboard when I am thinking about the next command to run - previous versions of UNIX used to flush buffers once in about 15 secs and 'sync' was a way to start it off. Disks were small and slow those days (20Mb to start with and 80Mb max) and UNIX systems were known to 'hang' often... John Kanagaraj Brunei Shell Petroleum http://www.geocities.com/john_sharmila God so loved the world that He didn't send a committee! (See John 3:16 for details) ** Opinions expressed here are solely mine and not necessarily those of my employer ** ------------------------------ From: Ken Komoto <kgkomoto_at_ucdavis.edu> Date: Tue, 13 Jun 2000 10:06:09 -0700 Subject: RE: Where are you from ? Davis, California, USA Home of the University of California, Davis campus ============================================================ Kenneth Komoto Email: kgkomoto_at_ucdavis.edu Office of the Registrar Phone: (530)752-7197 University of California Fax : (530)752-0329 Davis, Ca 95616 ------------------------------ From: John Lewis <jlewis_at_punchnetworks.com> Date: Tue, 13 Jun 2000 10:08:27 -0700 Subject: RE: Oracle 7.3.4 limitations on NT Actually I had rather good luck with 8.x on NT. The database zipped right along. It was smallish ( under 1 gig ) with maybe max 40 users. -----Original Message----- From: Jesse, Rich [mailto:Rich.Jesse_at_qtiworld.com] Sent: Tuesday, June 13, 2000 9:27 AM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle 7.3.4 limitations on NT Yes, the one limitation of Oracle7 on NT is that it crashes frequently, requiring instance (and usually) database recovery. Don't do it. I haven't tried Oracle8 Server (EE) on NT because of all the corruption problems we had with 7.3.4. I moved the database to OpenVMS. Good luck! If you're running on NT, you'll need it. Rich Jesse System/Database Administrator rjesse_at_qtiworld.com Quad/Tech International, Sussex, WI USA
> -----Original Message-----
> From: ALEMU Abiy [mailto:abiy.alemu_at_criltechnology.com]
> Sent: Tuesday, June 13, 2000 09:07
> To: Multiple recipients of list ORACLE-L
> Subject: Oracle 7.3.4 limitations on NT
>
>
> Does somebody has documentations on Oracle limitations on NT platform
> (especially on the number of records and concurrent connected users) ?
>
> Thank you !!!
>
> --------------------------------------------------------------
> --------------
> --------
> @biy @lemu
> Cril Telecom Software
> France
>
> --
> Author: ALEMU Abiy
> INET: abiy.alemu_at_criltechnology.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
------------------------------------------------------------------------ This message has been scanned for viruses with Trend Micro's Interscan VirusWall. -- Author: Jesse, Rich INET: Rich.Jesse_at_qtiworld.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: "Cole, Bill" <bcole_at_lsfi.com> Date: Tue, 13 Jun 2000 13:12:17 -0400 Subject: RE: Would you allow this? It's the job of a DBA to list all the bad things that could happen in this case and give advice about the rationality of such a request. And recover from any stupidity visted on the database by such an action. In this case, you're an advisor and the advisee doesn't have to follow your sage cautionary tale. I can see/feel/hear your frustration. At the end of the day, though, it's someone else's job on the line. /Bill
> -----Original Message-----
> From: Lisa_Koivu_at_gelco.com
> Sent: Tuesday, June 13, 2000 12:55 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Would you allow this?
>
> How many of you would allow a vendor to come in and do a demo on a
> PRODUCTION
> DATABASE?
>
> I am being overridden. I am being told to allow it, it's their database
> and if
> they hose it (who knows what this thing is going to do?) it's their
> problem.
> What? It's just a reporting tool, but STILL! I am concerned about it
> starting
> runaway queries and eating up resources reserved for CUSTOMERS.
>
> Can you feel my headache all the way from Minneapolis.... I should just
> take
> the afternoon off.
> Lisa
>
>
> --
> Author:
> INET: Lisa_Koivu_at_gelco.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
------------------------------ From: "Thapliyal, Deepak" <DThapliyal_at_ea.com> Date: Tue, 13 Jun 2000 10:15:49 -0700 Subject: RE: catproc and others you do not need to run catrep unless you are using replication -----Original Message----- From: Steff Gonos [mailto:steff_gonos_at_yahoo.com] Sent: Tuesday, June 13, 2000 9:27 AM To: Multiple recipients of list ORACLE-L Subject: catproc and others When you complete an installation there are some scripts in the ORACLE/RDBMS/ADMIN library things like CATREP and CATEXP... what other scripts should be run to have a "complete" system ? Thanks. Steff Gonos Litton - TASC ===== ******************************************************* The opinions expressed herein are mine. Get your own opinions! ******************************************************* Steff Gonos steff_gonos_at_yahoo.com __________________________________________________ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.com -- Author: Steff Gonos INET: steff_gonos_at_yahoo.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: Gaja Krishna Vaidyanatha <gajav_at_yahoo.com> Date: Tue, 13 Jun 2000 10:14:24 -0700 (PDT) Subject: RE: TEMP tablespace size in a Data Warehouse Alex, You raise a valid point on the history and behavior of the "analyze...estimate statistics;" and I think this needs to be clarified. Yes, prior to 7.3.0 the estimate sampled only the first "x%" of the table, where x is the percentage specified in the command or 1064 rows or whatever(when no sample size is given). I think in and about version 7.3.3, this behavior changed and in my understanding the process of estimation does what I term as "sequential randomized estimation". In this process, the estimation of statistics is done by sampling the x% from a chunk of read worth - db_file_multiblock_read_count. Which means, effectively the estimate worked just like a full table scan where all the blocks were read, but the sampling and calculation of statistics was done on the sample size, on a chunk-by-chunk basis. In Oracle 8i, we finally have "true randomized estimation". Thanks for bringing up this point. Cheers, Gaja. --- Alex Hillman <alex_hillman_at_physia.com> wrote:
> Isn't it true that in 8i it if you use estimate Oracle get
> specified
> percentage of data randomly and before 8i it took specified
> percentage of
> data from the beginning of the table and therefore in 8i we
> can use smoller
> percentage with more reliable results?
>
> Alex Hillman
>
> -----Original Message-----
> Sent: Tuesday, June 13, 2000 12:38 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Charlie,
>
> On a 1 TB implementation, we used the "rule of thumb" of (1.5
> *
> size of the largest table) as required temporary tablespace.
> The database release was in 7.3.4 and 8.0.5. This sizing was
> done keeping in mind, not only the need for temp segments
> during
> application sorts and index creations, but also for the
> potential need to perform a "full analyze" on the table with
> the
> "compute statistics" option. You are aware that a table
> analyze
> automatically induces analyze of all the relevant indexes on
> the
> said table.
>
> Having said that, it needs to be mentioned here that after a
> table reaches a certain size threshold (environment-specific
> but
> usually in 10s of Gb), it is almost processor/computation
> prohibitive to do "computes". While 8.0 and above does allow
> "parallel analyzes" by the use of the dbms_utility.
> analyze_part_object procedure, the sheer cost of performing a
> compute is sometimes infeasible.
>
> For most environments "estimates with sample sizes of 16% or
> above have been known to be statistically adequate". The
> statistical confidence interval for a 16% sample-size analyze
> is
> between 83-91%. I have used a sample size of 20% across the
> board for the past 5 years and it worked for me. Depending on
> the degree of skewness in your data, your mileage may vary.
> But
> at least you have a number to start with.
>
> If the usual sort-related parameters have been tuned, it is
> relevant to mention here that the number of tables that are
> analyzed at a given time, is going to have a direct impact on
> the size of the temporary tablespace.
>
> Best Regards,
>
> Gaja.
>
> --- Charlie Mengler <charliem_at_mwh.com> wrote:
> > Is there any "rule of thumb" that can be used to guesstimate
> > the appropriate size
> > of the TEMP tablespace in a data warehouse instance? For
> > example
> > XXX% of total size or
> > TEMP should be 1.YY * the size of the largest table or
> > TEMP should be 1.ZZ * the size of the largest index or
> > ??????
> >
> > Along these lines what can be done to minimize or reduce the
> > amount of TEMP
> > that is needed & what are the trade-offs involved. (This is
> > beside the "obvious"
> > response WRT to sorts & Sort Area Size.)
> >
> > --
> > Charlie Mengler Maintenance
> > Warehouse
> > charliem_at_mwh.com 5505 Morehouse
> > Drive
> > 858-552-6229 San Diego, CA
> > 92121
> > Always be sincere about your enthusiasm, whether you mean it
> > or not.
> > --
> > Author: Charlie Mengler
> > INET: charliem_at_mwh.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > 538-5051
> > San Diego, California -- Public Internet access /
> > Mailing Lists
> >
>
--------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail
> > message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> > and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from).
> > You may
> > also send the HELP command for other information (like
> subscribing).
>
>
> =====
> Gaja Krishna Vaidyanatha | 3460 West Bayshore Road,
> Manager - Integration | Palo Alto, CA 94303
> & Consulting Services | gaja_at_brio.com
> Global Alliances | (650)-565-4442
> Brio Technology | www.brio.com
>
> "Opinions and views expressed are my own and not of Brio
> Technology"
>
> __________________________________________________
> Do You Yahoo!?
> Yahoo! Photos -- now, 100 FREE prints!
> http://photos.yahoo.com
> --
> Author: Gaja Krishna Vaidyanatha
> INET: gajav_at_yahoo.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> San Diego, California -- Public Internet access /
> Mailing Lists
>
--------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail
> message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru')
> and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from).
> You may
> also send the HELP command for other information (like
> subscribing).
>
===== Gaja Krishna Vaidyanatha | 3460 West Bayshore Road, Manager - Integration | Palo Alto, CA 94303 & Consulting Services | gaja_at_brio.com Global Alliances | (650)-565-4442 Brio Technology | www.brio.com "Opinions and views expressed are my own and not of Brio Technology" __________________________________________________ Do You Yahoo!? Yahoo! Photos -- now, 100 FREE prints! http://photos.yahoo.com ------------------------------ From: Henry Poras <HPoras_at_ctp.com> Date: Tue, 13 Jun 2000 11:32:32 -0400 Subject: RE: Where are you from ? Another from Cambridge, MA Henry -----Original Message----- ------------------------------ From: Gautam_Reddy_at_Dell.com Date: Tue, 13 Jun 2000 12:16:29 -0500 Subject: RE: adding a check condition There would be a overhead on both trigger and a check constraint. Constraint would be better than a trigger this is based on testing done some time ago. Thx Gautam Reddy 728-3656(512) gautam_reddy_at_dell.com www.dell.com -----Original Message----- From: Rachel Carmichael [mailto:carmichr_at_hotmail.com] Sent: Tuesday, June 13, 2000 6:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: adding a check condition yes it adds to the overhead! and it will affect performance on every insert and update. Oracle has to get the check condition from the data dictionary. since you want this check on EVERY column, it might be faster to do it all at once in a before-insert/before-update trigger. Rachel
>From: "Anand Raman" <araman_at_india-today.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>Subject: adding a check condition
>Date: Mon, 12 Jun 2000 22:57:04 -0800
>
>Hi guys
>In a database which i am desiging to prevent users from entering blank
>spaces into columns i am also
>adding a check condition like check column <> ' ' to almost every column..
>Does this add to the overhead of the table and will it have any performance
>effect ..
>Thanx
>Anand
>
>--
>Author: Anand Raman
> INET: araman_at_india-today.com
>
>Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
>San Diego, California -- Public Internet access / Mailing Lists
>--------------------------------------------------------------------
>To REMOVE yourself from this mailing list, send an E-Mail message
>to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
>the message BODY, include a line containing: UNSUB ORACLE-L
>(or the name of mailing list you want to be removed from). You may
>also send the HELP command for other information (like subscribing).
________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Author: Rachel Carmichael INET: carmichr_at_hotmail.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: "William Beilstein" <BeilstWH_at_obg.com> Date: Tue, 13 Jun 2000 13:19:06 -0400 Subject: RE: Would you allow this? Lisa, Your employer sounds like a complete moron. If I was you, I would start = looking for another job. One of these days (maybe now), the database is = going to be hosed and YOU will get the blame for it happening.
>>> "Allin, Sean" <sallin_at_trimarine-usa.com> 06/13/00 01:32PM >>>
heartfelt sympathies -----Original Message----- Sent: Tuesday, June 13, 2000 9:55 AM To: Multiple recipients of list ORACLE-L How many of you would allow a vendor to come in and do a demo on a PRODUCTION DATABASE? I am being overridden. I am being told to allow it, it's their database = and if they hose it (who knows what this thing is going to do?) it's their = problem. What? It's just a reporting tool, but STILL! I am concerned about it starting runaway queries and eating up resources reserved for CUSTOMERS. Can you feel my headache all the way from Minneapolis.... I should just take the afternoon off. Lisa --=20 Author:=20 INET: Lisa_Koivu_at_gelco.com=20 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --=20 Author: Allin, Sean INET: sallin_at_trimarine-usa.com=20 Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: Brian_McQuillan_at_gelco.com Date: Tue, 13 Jun 2000 13:27:44 -0400 Subject: RE: Re[2]: Where are you from Ooooooo that's a low blow for all us nice people who call New Jersey home ! Brian Originally from Glasgow, Scotland now working in NY, but living in Morristown New Jersey ! Michael Boligan <mboligan_at_healthvision.com> on 06/13/2000 12:55:17 PM Please respond to ORACLE-L_at_fatcity.com To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Brian McQuillan/GELCO) Subject: RE: Re[2]: Where are you from I thought you were only supposed to give the exit if you are from New Jersey :) Mike Boligan Needham, Ma USA -----Original Message----- Sent: Tuesday, June 13, 2000 10:31 AM To: Multiple recipients of list ORACLE-L OH for crying out loud!! And here I just got trashed by Jared for turning this place into a "Dear Abbey" site!!! OH Well, Andover, Mass, USA, exit 42 off of I-93. About 20 miles north of Boston. At least that's where I work. Home is 45 miles further north in Goffstown, NH. (Gods Country). Dick Goulet Senior Oracle DBA Vicor Corporation -- Author: INET: dgoulet_at_vicr.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Author: Michael Boligan INET: mboligan_at_healthvision.com Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ------------------------------ From: "Cale, Rick T (Richard)" <RICHARD.T.CALE_at_saic.com> Date: Tue, 13 Jun 2000 10:22:48 -0700 Subject: RE: Oracle 7.3.4 limitations on NT Not necessarily. I'll be the first to agree that UNIX,etc is a better OS. Depending on your needs,etc NT can work quite well. I have been running on NT for about 5 yrs supporting 7 different Oracle NT shops in that 5 years and probably bad luck to say this but I have not had even 1 crash because of the OS. I have been running 7.3 up to 8.0.5. I know a lot of folks on this list use NT successfully. Most complaints you will hear are of the "jump-on-the_bandwagon" variety. This certainly does not answer your question but I think they are in the concepts manual. Rick
> -----Original Message-----
> From: Jesse, Rich [SMTP:Rich.Jesse_at_qtiworld.com]
> Sent: Tuesday, June 13, 2000 12:27 PM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Oracle 7.3.4 limitations on NT
>
> Yes, the one limitation of Oracle7 on NT is that it crashes frequently,
> requiring instance (and usually) database recovery. Don't do it.
>
> I haven't tried Oracle8 Server (EE) on NT because of all the corruption
> problems we had with 7.3.4. I moved the database to OpenVMS.
>
> Good luck! If you're running on NT, you'll need it.
>
> Rich Jesse System/Database Administrator
> rjesse_at_qtiworld.com Quad/Tech International, Sussex, WI
> USA
>
>
> > -----Original Message-----
> > From: ALEMU Abiy [mailto:abiy.alemu_at_criltechnology.com]
> > Sent: Tuesday, June 13, 2000 09:07
> > To: Multiple recipients of list ORACLE-L
> > Subject: Oracle 7.3.4 limitations on NT
> >
> >
> > Does somebody has documentations on Oracle limitations on NT platform
> > (especially on the number of records and concurrent connected users) ?
> >
> > Thank you !!!
> >
> > --------------------------------------------------------------
> > --------------
> > --------
> > @biy @lemu
> > Cril Telecom Software
> > France
> >
> > --
> > Author: ALEMU Abiy
> > INET: abiy.alemu_at_criltechnology.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
>
>
> ------------------------------------------------------------------------
>
> This message has been scanned for viruses with Trend Micro's Interscan
> VirusWall.
> --
> Author: Jesse, Rich
> INET: Rich.Jesse_at_qtiworld.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
------------------------------ From: "Khedr, Waleed" <Waleed.Khedr_at_FMR.COM> Date: Tue, 13 Jun 2000 13:21:10 -0400 Subject: RE: Without using sysdate A good guess would be one of the date columns in one of the v$<tables> that keep changing with time. e.g. checkpoint or SCN -----Original Message----- From: Jared Still [mailto:jkstill_at_bcbso.com] Sent: Tuesday, June 13, 2000 12:27 PM To: Multiple recipients of list ORACLE-L Subject: Re: Without using sysdate Write an external C procedure to use localtime and return the current month. Not sure what the value is in this though. Using
 |
 |