RE: STARTUP Force

So, if you are recovering you would use it? I feel my reply was quite a reasonable one then, if you are shuting down normally, don't use it.. I only told her to use it as a last resort, and a recovery situation is pretty much a last resort.. In my book anyway.. And I did actually only learn abou

RE: Ora 8i OCI application on a Ora7 client - Windows NT

It's crazy: the following happened: The OCI application worked fine on my maschine. I installed Dev6i. Then the OCI app did not work. I copyed the OCI.DLL for Ora8i into the same directory as the OCI app and then it worked again. :-) This caused me to think, that the OCI app needs the OCI.DLL of

RE: How to insert data in LOBs

If you use CLOB, you can insert text in the same way as with varchar2. If you have BLOB, you'll probably need the function utl_raw or dbms_lob. However with BFILE, you should create a directory with the stmt: CREATE DIRECTORY and insert using BFILENAME expression. Then you have the function EMPTY_

Re: SQL parameter for batch runs [NT]

Hi Sean, I'm no NT expert but I had to manage an Oracle 8.0.5/ NT database last year. I've used the osdba and osoper group. The daily cold backup, database export, statistics,... jobs were connecting to the database using '/ as sysdba' or '/ as sysoper'. The jobs were scheduled by AT. So no passw

RE: Parameter obsolete

It is an underscored one since 8i. Therefore you should not set it. Regards from Madrid. > -Mensaje original- > De: Beatriz Martínez Jiménez [SMTP:[EMAIL PROTECTED]] > Enviado el: jueves 8 de febrero de 2001 18:16 > Para: Multiple recipients of list ORACLE-L > Asunto: Paramet

RE: Buffer Gets

Jack, My understanding of a buffer get is a request for data from a data buffer (ex. DB_BLOCK_BUFFER) therefore showing an approximate amount of CPU resources used, as every time a request to a buffer is sent it takes a CPU cycle. HTH Mark -Original Message- [EMAIL PROTECTED] Sent: Thu

RE: Scripts -- Scripts -- Scripts

Pablo, Check out Steve Adams web site http://www.ixora.com.au/ This guy is the guru of guru's in my book, and he has loads of scripts on his site. Regards Mark -Original Message- ksksksk Sent: Thursday, February 08, 2001 05:06 To: Multiple recipients of list ORACLE-L Hi List, Does

Change Default Editor for SqlPlus in Windows

Hi, I wonder if anyone can tell me how to change the text editor which is invoked using the edit command in sqlplus( Plus80w ) in the Windows enviroment. I enjoy the Unix tool vi, and have a windows/Dos based vi editor I would like to use instead of Notepad. For those intreseted in the tool visit

Export with BLOB table take very long time.

Hi List, When i export my database with BLOB tables we take very long time, can GURU tell me what do i need to check ? Tran __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -

RE: sync objects between user's

Try this script, you will need to change user names etc, but it should work.. col table_name format a30 col column_nameformat a30 col medph2_format format a30 col med_test_formatformat a30 set feed off set lines 150 set pages 66 spool match_schema.lst -- -- MATCHING

RE: What is the URL showing web servers' popularity

I think you mean this one: http://www.netcraft.com/whats/ Regards, Mike. -Original Message- Sent: 08 February 2001 16:27 To: Multiple recipients of list ORACLE-L I remember seeing a Web page somewhere that showed what web servers large companies are using. I think it's from an Oracle

RE: STARTUP Force

Reading again, forget what I said.. lol.. It was too early.. -Original Message- Sent: Friday, February 09, 2001 09:16 To: Multiple recipients of list ORACLE-L So, if you are recovering you would use it? I feel my reply was quite a reasonable one then, if you are shuting down normally, d

RE: urgent! ora-00600[17003][89907688][0][1]

Maybe it is a library cache lock problem. However you should ask to Support. Regards. > -Mensaje original- > De: grace lim [SMTP:[EMAIL PROTECTED]] > Enviado el: viernes 9 de febrero de 2001 2:56 > Para: Multiple recipients of list ORACLE-L > Asunto: urgent! ora-00600[17003][89

RE: Export with BLOB table take very long time.

Try with a bigger buffer. At least with one of 10m. Regards. > -Mensaje original- > De: Bao Jenny [SMTP:[EMAIL PROTECTED]] > Enviado el: viernes 9 de febrero de 2001 10:22 > Para: Multiple recipients of list ORACLE-L > Asunto: Export with BLOB table take very long time. > > Hi

Re: How to insert data in LOBs

thanks it worked fine. but how if i want to insert some file(text,word) or some image file to a blob. and i did'nt understood how to querry such table with LOBs. thanks again for the guidance. saurabh - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent

Re: Change Default Editor for SqlPlus in Windows

In the login.sql text file of your working directory, place a line like this: define _editor=c:\winnt\notepad.exe >>> [EMAIL PROTECTED] 02/09/01 04:30AM >>> Hi, I wonder if anyone can tell me how to change the text editor which is invoked using the edit command in sqlplus( Plus80w ) in the Wind

Re: Export with BLOB table take very long time.

What is the buffer size? Use a large value, like 100 or even bigger. >>> [EMAIL PROTECTED] 02/09/01 04:22AM >>> Hi List, When i export my database with BLOB tables we take very long time, can GURU tell me what do i need to check ? Tran __ D

ORA-04020: deadlock detected while trying to lock object...

Need guru! :) At attempt to compile procedure we're getting subj. Nevertheless there is no more sessions accessing the schema. About environment: Oracle8i Enterprise Edition Release 8.1.6.0.0 - 64bit Production PL/SQL Release 8.1.6.0.0 - Production CORE8.1.6.0.0 Production TNS for Sola

Re: Change Default Editor for SqlPlus in Windows

do you want to use some other editor instead of notepad? there is an option in plus80w under Edit menu to define new editor which will become ur default editor. open plus80w connect , go to Edit/editor/define..it will ask for new editor. close. hope it'll solve. saurabh - Original Message --

OT: Submitting a URL to Search engines

Hi, I have been roped into creating a web page for my daughter's school! So I am learning lots about HTML at a huge rate. The actual creation of the site will be fun (I hope). But I will need to make all the search engines aware of the URL of the new site. - How do I do this? I have seen ISPs of

RE: Buffer Gets

A buffer get is simply an I/O request that didn't need to access the disk directly because the required buffer was still in memory. >>> [EMAIL PROTECTED] 02/09/01 04:15AM >>> Jack, My understanding of a buffer get is a request for data from a data buffer (ex. DB_BLOCK_BUFFER) therefore showin

RE: ORA-04020: deadlock detected while trying to lock object...

I saw this note on MetaLink that may help. Rick Error: ORA 4020 Text: deadlock detected while trying to lock object %s%s%s%s%s --- Cause: While trying to lock a library object, a deadlock is detected. Explan

Re: Change Default Editor for SqlPlus in Windows

Denham Eva wrote: > > Hi, > > I wonder if anyone can tell me how to change the text editor which is > invoked using the edit command in sqlplus( Plus80w ) in the Windows > enviroment. I enjoy the Unix tool vi, and have a windows/Dos based vi editor > I would like to use instead of Notepad. > For

RE: Abnormal shutdown of database and listener alert_NDBDEV.log [1/2]

I think the problem could be that that you listener has gone tit's up, your database can't register with it, the logs are full, the system had crashed, and lightning has struck the golfer in the field swinging his club wildley at a small orange ball stuck in the snow! Really, we need a little mor

Re: How to insert data in LOBs

No, you can't just use an insert statement to do this. There is a lot of information out on metalink about this. Take a look at the dbms_lob package or sql*loader. - Brian --- Saurabh Sharma <[EMAIL PROTECTED]> wrote: > hi all, > i want to know how to insert values i.e. text/word or images > i

RE: Unable to Drop Rollback Segment/Tablespace

Hello, Could you try this. Startup mount; Alter database create datafile 'your deleted files' as 'your deleted file'; Alter database datafile 'created datafile' offline drop; Alter database open; Hope this helps you Regards Baskar -Original Message- Sent: 08 February 2001 23:41 To: Mu

Database Re-org tools

We are in the process of selecting 3rd party DB Reorg tool for our enterprise. Our choices are: 1) BMC 2) CA-Platinum 3) Quest Any suggestion about the tools or some other tool will be highly appreciated. regards: Uttam majumdar PG&E National Energy Group and any other company reference

RE: Database Re-org tools

We reviewed all of them. BMC's DBReorg seemed to be the best. We chose to ignore the fancy GUI part of the apps and just went for performance, ease of use and reliability. DBReorg is working great and their support, the few times we had questions, has been excellent. Ron Smith Database Adminis

Re: OT: Submitting a URL to Search engines

Hi, www.addme.com is a start Jack "Oweson Flynn"

Abnormal shutdown of database and listener alert_NDBDEV.log [2/2]

Repeat 2 times 80003060 80003064 80003064 [..0d..0d] 80003070 800D0D28 [...(] =20 ksllt ksimlgds_ [8000307C, 800030E4) =3D 0800 = ... Dump of memory from 0x8000308C to 0x800030E4 80003080

Re: Submitting a URL to Search engines

- Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Friday, February 09, 2001 14:05 > - Where do I get a list of all these search engines - I can only think of > the top 5 or 6 like Yahoo and Google! > http://www.searchenginewatch.com/links/ hth,

sgadefbaanIV.dbf

Hi Gurus I don't know How this file generated by database, What is significance of this file?? Can I delete this file??? Is there any use ??? Thanks in advance Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at htt

RE: Submitting a URL to Search engines

Try this site: http://www.1-add-url.com -Original Message- Flynn Sent: Friday, February 09, 2001 12:05 To: Multiple recipients of list ORACLE-L Hi, I have been roped into creating a web page for my daughter's school! So I am learning lots about HTML at a huge rate. The actual creatio

Re: urgent! ora-00600[17003][89907688][0][1]

Please check for all other invalids in your system and compile them first manually and see if that package is also validated. Then compile your forms. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Thu, 08 Feb 2001 17:55:30 -0800 gu

No Subject

SET ORACLE-L NOMAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Psycharis Nektarios INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Resouce Allocation

Dear friends I have a little problem I have a table here the description ... create table my_table ( id number primary key. namevarchar2(20), address varchar2(50), notesvarchar2(4000) ); and then ... I inserted one record, and I wanna know ... How to count a resour

RE: Database Re-org tools

Export/Import - comes with the database. David A. Barbour Oracle DBA - ConnectSouth 512-681-9438 [EMAIL PROTECTED] -Original Message- Sent: Friday, February 09, 2001 7:21 AM To: Multiple recipients of list ORACLE-L We are in the process of selecting 3rd party DB Reorg tool for our ent

RE: ORA-04020: deadlock detected while trying to lock object...

It also memory related issue. Reboot your(tired) box (if possible) and try again. You will see objects will be compiled without locking problem and will be much fast Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: Fri, 09 Feb 200

RE: Abnormal shutdown of database and listener alert_NDBDEV.log [1/2]

Is somebody copied your listener.ora and tnsnames.ora on other system for working with new database with same name and using these files without changing DB/SIDname. It happened to us last week when one of our group member did that on new box and old box listener/database went down. Regards Rafi

RE: Resouce Allocation

analyze the table in compute mode. Then select bytes from user_tables where table_name = 'MY_TABLE'; -Original Message- Sent: 09 February 2001 14:56 To: Multiple recipients of list ORACLE-L Dear friends I have a little problem I have a table here the description ... cre

Re: sgadefbaanIV.dbf

No removal is required. It is generated as a result of your database and goes away when you shutdown database. Oracle uses this file in it dbstart script to check whether database is up or not. Regards Rafiq Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTE

RE: Oracle 816 on linux

This is due to redhat-7. The glibc that ships with rh7 is incompatible with oracle. (All versions - Although I haven't tried the 8.1.7.0.1 w/ OPS yet.) You have to install a backwards compatible rpms and edit a few oracle makefiles to get oracle to work on rh7. Running in this environment is defi

Re: ORA-29521 with Corba Advice ?

Hello, Our database is in UTF8. When I run intjvm2.sql I've got : ERROR: ORA-06550: line 1, column 29: PLS-00553: character set name is not recognized ORA-06550: line 0, column 0: PL/SQL: Compilation unit analysis terminated begin if :jvmrmaction = 'FULL_REMOVAL' or :jvmrmaction = 'GRADE_REMOV

Abnormal shutdown of database and listener alert_NDBDEV.log [1/2]

To: <[EMAIL PROTECTED]>, <[EMAIL PROTECTED]> Date: Fri, 9 Feb 2001 16:29:54 +0530 Message-ID: <[EMAIL PROTECTED]> MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="=_NextPart_000_006B_01C092B5.88C128B0" X-Priority: 3 (Normal) X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook IMO

Re: sgadefbaanIV.dbf

This file tells the Oracle shadow processes the address of the SGA when the process first connects to the database. Donot remove it. If the process cannot find this file, it assumes the database is down. Eveleen Please respond to [EMAIL PROTECTED] "Raghu Kota" <[EMAIL PROTECTED]> on 02/09

RE: Change Default Editor for SqlPlus in Windows

define _editor="d:\gnu\gvim" in your glogin.sql -Original Message- Sent: Friday, February 09, 2001 4:30 AM To: Multiple recipients of list ORACLE-L Hi, I wonder if anyone can tell me how to change the text editor which is invoked using the edit command in sqlplus( Plus80w ) in the Wind

RE: Hit Ratio fallen through the floor at 31% since a db crash ye

How about hiring a consultant? -Original Message- Sent: Thursday, February 08, 2001 4:41 PM To: Multiple recipients of list ORACLE-L It had only been up for a few weeks. It could be the buffer cache. -Original Message- ] Sent: Thursday, Febru

RE: Oracle 816 on linux

The Metalink Doc ID is: Note:121176.1 -Original Message- Sent: Friday, February 09, 2001 10:42 AM To: Multiple recipients of list ORACLE-L This is due to redhat-7. The glibc that ships with rh7 is incompatible with oracle. (All versions - Although I haven't tried the 8.1.7.0.1 w/ OPS y

Re[2]: sgadefbaanIV.dbf

One other point, If you manually delete this file the DB will crash. To some good degree it totally disappears in 8i. Dick Goulet Reply Separator Author: "Mohammad Rafiq" <[EMAIL PROTECTED]> Date: 2/9/2001 7:35 AM No removal is required. It is gene

Re: Re[2]: sgadefbaanIV.dbf

shutdown abort also removes in case your database crash ,connect internal and shutdown abort will remove it or alternately deletion is the only option. If it remains there, database will not start. Regards Rafiq To: "Mohammad Rafiq" <[EMAIL PROTECTED]>,Multiple recipients of list ORAC

RE: ORA-04020: deadlock detected while trying to lock object...

Hi When you are compiling an object, Oracle has to pin the dependent objects in an exclusive mode. In rare cases, you may go in to deadlock situations if your dependent objects has some form of recursive relationship and need to be compiled too . I would suggest to find the dependent objects (

RE: Extent allocation

Indeed, the Concepts Manual affirms this in Chapter 4. So why can't they correct the information regarding TRUNCATE? Just after the section on extent allocation, the book states that the privilige needed to TRUNCATE a table is DELETE ANY TABLE, when in fact it should be DROP ANY TABLE. Jared

!!**** Urgent HELP (Table Deleted In Production )

Dear Friends In product databace one of the developer had deleted a table and commited it , database is in online backup but no export backup or table backup Please tell me how can the table be recovered please guide me the exact detaied steps torecover the table After getting the reply i will

FW: [ Danone ] - Hung Oracle Query

Can someone have alook at the problem below please and advise. I am stumped. Regards > -Original Message- > From: jmydde - James Myddelton > Sent: 09 February 2001 16:33 > To: lerobe - Lee Robertson > Cc: rkilbe - Robert Kilbey > Subject: [ Danone ] - Hung Oracle Query > > >

RE: Scripts -- Scripts -- Scripts

Thanks Chana, your scripts are great Thanks Mark, I already know Steve Adams' site, the problem is that the kind of scripts I'm looking for are not there. I need simple scripts that generate table creation commands, procedure creation, etc.. TOAD does it, but I need the scripts !!! thanks anyw

RE: Extent allocation

Title: RE: Extent allocation I found a document on metalink   #69343.1 that pretty much explains it.  Unfortunately, it makes it sound like you can never be sure of the sizing you choose, because it looks at the size of the first two open blocks, rather than finding a block that fits what you

optimizer_mode = first_rows and ora-1652

I gave it 36 hours, it never showed so here it is again. My apologies if it's a duplicate. Can someone give me an explanation for this? I'm trying to tune a sql statement. optimizer_mode is set to choose in the init.ora. The select pulls from 6 tables. As is it does full table scans on all

SV: Re[2]: sgadefbaanIV.dbf

In spite of its file extension the content of my sgadef.dbf (Oracle 8.0.5.0.0 Enterprise on Solaris) is pure text. It says: "This file is now obsolete. It will be removed in a future release. To determine whether an instance is up, you should check for the existence of the PMON process associate

Re: MINUS VS NOT IN

On Thu, 8 Feb 2001, Peter Hazelton wrote: > Considering the following: > > Query One > > select distinct icons from inpatient > minus select distinct icons from ptca; > > Query 2 > > select distinct icons from inpatient > where icons NOT IN(select distinct icons from ptca) > > Query number one be

Re: !!**** Urgent HELP (Table Deleted In Production )

Hi Saroj, If the table data isn't updated too often you can go back to an older export and import the table. If not, are you in archive log mode? Check your alert.log file for errors on the system datafile and let us know the status of your database to provide an accurate answer. -Rocky   "Dash, S

RE: Extent allocation

What do you want, miracles? :-) As you probably remember, DELETE ANY TABLE was indeed the privilege required to issue a TRUNCATE command, when TRUNCATE first became available (release 7.0, I think). They changed it early on to DROP ANY TABLE (7.1?), but the documentation has apparently been

Re: optimizer_mode = first_rows and ora-1652

Not sure about the 1652 error, but have you looked into setting the optimizer_index_cost_adj parameter? Try playing around with this. Default is 100. I had good luck at one client by using 4. YMMV of course. >>> [EMAIL PROTECTED] 02/09/01 12:01PM >>> I gave it 36 hours, it never showed so

Re: FW: [ Danone ] - Hung Oracle Query

Why do you even have the tables consumer_phone and consumer_email included in the query? Obviously you don't care if they have entries in them, and you're not selecting any info out of them. Remove them and see what happens. >>> [EMAIL PROTECTED] 02/09/01 11:41AM >>> Can someone have alook at

Re: Re[2]: sgadefbaanIV.dbf

Thank you so much to all Gurus for indepth info. >From: "Mohammad Rafiq" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: Re: Re[2]: sgadefbaanIV.dbf >Date: Fri, 09 Feb 2001 08:32:58 -0800 > >shutdown abort also removes in c

Re: Database Re-org tools

Save your money with Export/Import. Is not so difficult, in fact I think is the easiest way. It can't help you with 24x7 database. But sometimes it can help you in this case too. Depends how much you lose or earn when database is down. - Original Message - To: Multiple recipients of li

RE: TU Enqueue types

TX is transaction lock. Can't find any info on the other 2... --Scott Shafer San Antonio, TX > -Original Message- > From: Hagedorn, Linda [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, February 08, 2001 10:36 PM >

Re: optimizer_mode = first_rows and ora-1652

If Oracle finds that the query will select more than 2 or 3% of the rows it will choose a full table scan. Ruth - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Friday, February 09, 2001 12:01 PM > I gave it 36 hours, it never showed so here it i

RE: Scripts -- Scripts -- Scripts

Pablo, is this the kind of script you want ? (see below) - this table script doesn't handle partitions though. it also uses utl files. if so mail me back channel and i'll send them to you hope it helps Brian. /* *** */ /* backup

RE: MINUS VS NOT IN

Jared, Cool little trick with your SQL prompt there, care to share how you did it? Cheers Mark -Original Message- [EMAIL PROTECTED] Sent: Friday, February 09, 2001 05:35 To: Multiple recipients of list ORACLE-L On Thu, 8 Feb 2001, Peter Hazelton wrote: > Considering the following: >

Re:RE: MINUS VS NOT IN

Mark, It's a pretty simple one, cause I do it all the time. check out the 'set prompt' command in SQL*Plus and 'set time on'. Dick Goulet Reply Separator Author: "Mark Leith" <[EMAIL PROTECTED]> Date: 2/9/2001 11:25 AM Jared, Cool little tric

RE: urgent! ora-00600[17003][89907688][0][1]

Well I am not a guru, but I am going to take a shot. I had a very similar internal error on a version 7.3.4 database. I was compiling stored procedures as well. I called Oracle Support, and was told to apply a patch. In my case I had changed three lines of code. I commented one out and renamed

Re: !!**** Urgent HELP (Table Deleted In Production )

Hi Saroj If the table has been dropped or truncated then you have to do media recovery which means that you have to: 1. restore the backup 2. Do the point-in-time recovery and then stop the recovery just before the table deletes. 3. Open the database using resetlogs. This

RE: MINUS VS NOT IN

A few questions for Peter Hazelton Why the use of distinct in the set operation in query one when dupicates will be tossed by it? What's the purpose of the distinct in the subquery of query two? For Jared, have you tried using a hash antijoin hint inside the subquery? Ian MacGregor Stanfo

RE: TU Enqueue types

>From the metalink...Even the reference guide, does not mention this enqueue.. Document bug. JI "Enqueue used during AJV

Priority Paging on Solaris

Has anyone enabled priority paging on Solaris and did you experience any performance gains as a result? (10-300% performance gains possible according to Sun.) For a description here's a link: http://www.sun.com/sun-on-net/performance/priority_paging.html Comments? Recommendations? Steve Orr -

RE: Extent allocation

Hi Patrick, No. Its not locally managed tablespace. Shakeel Qureshi [EMAIL PROTECTED] --- Tim Sawmiller <[EMAIL PROTECTED]> wrote: > Somewhere in the depths of Oracle 8.1 documentation, > you will find a description of the extent algorithm. > It's supposed to be more "enlightened" in > allocatin

Re: Priority Paging on Solaris

Yes and Yes. Also, the document skips over some other parameters you should set in addition to priority_paging=1 Check out http://www.unixinsider.com/unixinsideronline/swol-07-1999/swol-07-filesystem3_p.html which lists these also: set fastscan=131072 set handspreadpages=131072 set maxpgio=

Fw: Applying patches - minimizing database down time

- Original Message - To: <[EMAIL PROTECTED]> Sent: Thursday, February 08, 2001 8:52 PM > Steve, > > Seems like a fast, secure procedure. One question though, > > Why would you issue the 'shutdown abort' in step 5 ? You never quite know > how long instance recovery will take. > > Someone

RE: 8.1.7 DB and auto registration with Listener

Hi Kirti, i had support on call today : they say it's probably generic but were speculating about a normal behavior not documented. But as pmon registers correctly when the instance is started, i had to insist they fill a bug. I will let you know Regards At 13:15 08/02/2001 -0800, you wrote: >

RE: Applying patches - minimizing database down time

Look again at step 5. The sequence is: alter system checkpoint; shutdown abort; startup; shutdown immediate; The theory is that the checkpoint may take awhile but the database is still available. Then the shutdown abort - startup - shutdown immediate sequence get's us to a consistent state as re

Re: Priority Paging on Solaris

Hi I have enabled the priority paging on Solaris in my earlier job. priority paging is particularly effective for the file system based databases. The system performance used to take a nose dive during hot backup and enabling and playing around cachefree parameter helped us to resolve the prob

RE: Oracle 816 on linux

Interesting! I was just planning to upgrade my red hat 6.1 server with oracle to the newest version. Good thing I am on this mailing list! -Original Message- Sent: Friday, February 09, 2001 9:33 AM To: Multiple recipients of list ORACLE-L The Metalink Doc ID is: Note:121176.1 -Or

RE: MINUS VS NOT IN

On Fri, 9 Feb 2001, MacGregor, Ian A. wrote: > A few questions for Peter Hazelton Why the use of distinct in the set operation >in query one when dupicates will be tossed by it? What's the purpose of the distinct > in the subquery of query two? > > For Jared, have you tried using a hash ant

RE: MINUS VS NOT IN

On Fri, 9 Feb 2001, Mark Leith wrote: > Jared, > > Cool little trick with your SQL prompt there, care to share how you did it? > > Cheers > > Mark Here's the script: REM setprmpt.sql - unix version REM set prompt to first 3 chars of machine,name, database name, user name -- thanks to ted moor

RE: TU Enqueue types

Title: RE: TU Enqueue types Thanks Riyaj.  I called support and had them look up TC.  They're saying they think it has something to do with checkpoints.  I've asked them for specifics and will post them when Oracle replies.  Regards, Linda   -Original Message- From: [EMAIL PROTECT

RE: TKPROF

YES THIS IS AN ORACLE FINANCIALS DATABASE - RULE BASED OPTIMIZER -IM CURIOUS ABOUT THIS, BECAUSE I DOUBT THE EXPLAIN (Please NOO!!) - Has anyone had rubbish back from EXPLAIN ? SAM -Original Message- Sent: Thursday, February 08, 2001 12:17 PM To: Multiple recipients of list ORACLE

Re: Parameter obsolete

Yes, that's what the error message is all about. - Original Message - From: Beatriz Martínez Jiménez To: Multiple recipients of list ORACLE-L Sent: Thursday, February 08, 2001 11:15 AM Subject: Parameter obsolete Hello list, This question is not a matter or l

RE: STARTUP Force

Yeah, me too,, force the checkpoint,shutdown abort, startup,shutdown normal - (5 mins max) - you can then schedule legato or whatever backup. been working fine for 3 years on multiple instances. (famous last words) Sam -Original Message- Sent: Friday, February 09, 2001 2:51 AM To: Multi

RE: urgent! ora-00600[17003][89907688][0][1]

accdg. to metalink oracle... i need to upgrade my database to 816. since 815 is no longer supported. At 04:04 AM 2/9/01 -0800, you wrote: >Maybe it is a library cache lock problem. However you should ask to Support. > >Regards. > >> -Mensaje original- >> De: grace lim [SMTP:[EMAIL PROTEC