Re: Which SQL is executing

SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE; Sam - Original Message - From: Chuan Zhang To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 9:30 AM Subject: Which SQL is executing Hi All,

Redo Log contention

Hello all, How does one measure if there is a contention for redo logs? 1. Is it that I see that the Log file parallel write has waited for more than 0 (zero)? or 2. You divide:- redo log space requests/no. of redo log entries 0.0002 Please advise. rgds, raja Get 250 color business

RE: Friday Chocolate thought.

Well Mark, that was amazing !!! If you haven't already tried Marks recipe (posted in March) I urge you to try it. Absolutely gorgeous. Lee -Original Message- Sent: 01 June 2001 21:35 To: Robertson Lee - lerobe; Multiple recipients of list ORACLE-L Lee, Have fun, as for me, I'm

Re: urgent regarding server manager..

Saurabh, I believe the only command line option for server manager is @script So you'll need to create a .sql script that contains the connect statement. Keep in mind that server manager is going away in 9i so you should start using sqlplus for 8i+. HTH, -- Anita --- Saurabh Sharma

Re: SP2-0575: Use of Oracle SQL feature not in SQL92 Entry Level.

Thank you very much, Ruth, but it doesn't our problem. We have same tnsnames in our server and client machines. Best regards. Miguel. 01/06/2001 20.51 Ruth Gramolini [EMAIL PROTECTED] 01/06/2001 20.06

RE: Friday Chocolate thought.

Sorry did I mention that it was even nicer, slightly warm with double cream poured over the top -Original Message- Sent: 04 June 2001 10:16 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Thanks, Lee. It was bad enough that you had to let us know you were going to make chocolate cake, but

RE: Friday Chocolate thought.

Thanks, Lee. It was bad enough that you had to let us know you were going to make chocolate cake, but then you have to go and flaunt how good it was! I bet you were the type to bring candy to school when you didn't have enough for the whole class ;) -- Anita --- Robertson Lee - lerobe

Re: DBA_OBJECTS

Bunyamin, Why don't you use v$locked_object ? "Bunyamin K. Karadeniz" wrote: I want to select locked_objects in a view.I runCREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS ASSELECT sn.username, m.sid, m.type, DECODE(m.lmode, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share'

RE: COCO Proposal Review

So tell me Lee, how was the choccy cake? :) -Original Message- Lee - lerobe Sent: Monday, June 04, 2001 08:55 To: Multiple recipients of list ORACLE-L Damn, thought it was something to do with Chocolate -Original Message- Sent: 02 June 2001 00:15 To: Multiple recipients

RE: COCO Proposal Review

Already put the verdict out mate. Tremendous You were right though. I couldn't wait for it to cool down even, never mind 24 hours. My sister already wants me to make another dozen !! Lee -Original Message- Sent: 04 June 2001 11:31 To: Multiple recipients of list ORACLE-L So

Re: DBA_OBJECTS

Because your privileges to select against DBA_OBJECTS was granted through a role and role privileges are disabled in views. You'll need to have select privileges explicitly granted on the underlying objects. HTH, -- Anita --- Bunyamin K. Karadeniz [EMAIL PROTECTED] wrote: I want to select

RE: Auto Extend

Hi John, I still haven't learned not to make sweeping statements on mailing lists = ) I expected someone to raise SMON or checkpoint overheads so I added necessarily very deliberately. Agreed, I'd tend to keep the number of files down to a reasonable number but I've run a database with 3,500

Re: What causes a last_analyzed date of 00-000-00?

Cherie, The only bug I'm aware of on this is a bug I encountered on 8.1.6 (bug 1161906), but it was fixed in 8.1.7.0.0, so you shouldn't be encountering it on 8.1.7.1 and AFAIK it did not happen in 7.3.x. Bug 1161906 resulted in 00-000-00 dates in last_analyzed when stats were computed on

Re: urgent regarding server manager..

1. upgrade to unix 2. start using sqlplus instead of server manager, its going away joe Saurabh Sharma wrote: hi all, i want help regarding automation of connecting to server manager through script file. i want when i run script, it automatically launch svrmgr program and

performance impact of optimizer_search_limit

Hi, Oracle 8.0.5 AIX 4.3.3 I have improved the response time of one of my 8 table join queries by increasing optimizer_search_limit from the default 5 to 8. At the value of 8 the plan changes and has made a 10 min query run in under 5 seconds. The optimizer is set to CHOOSE with the statistics

Re: Help! ORA-00164 - autonomous trans problem in 8.1.7 NOT in 8.1.5

Doug, This is a case where something slipped by in one release, but was caught in a later release (shades of Personal Oracle 8.0.3 which had complete EE functionality by mistake). 8i doesn't support autonomous transactions within distributed transactions, but it wasn't officially prevented with

RE: COCO Proposal Review

Good! I just saw your other post.. I have to concur - the cake is out of this world!! Glad I brought a smile to another chocolate lovers face.. Mark -Original Message- Lee - lerobe Sent: Monday, June 04, 2001 11:40 To: Multiple recipients of list ORACLE-L Already put the verdict out

RE: Redo Log contention

log parallel write and log file sync are good indications of redo log problems. This isn't directly considered contention but more like the disk medium is too slow to keep up. redo log space requests generally are log buffer related, meaning the buffer may be too small. Walking on water and

9i download

I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4 times now in the last 2 days. Walking on water and developing software from a specification are easy if both are

RE: Renaming columns ...

Hi Raj, 1. There is a way to do it. And Mr. Steve A. has some good info about it ( its implications) on his web site. (Sorry I do not have a direct URL link to it). I believe this works for all versions. 2. Yes, it does. I have played with it on my test database. However, I will not do this

Re: Check/Remove stray shared_memory_segment and semaphore

this is the error in my trace file and can U tell me where to find for this doc about glibc- cat ora_810.trc *** DUMP FILE SIZE IS LIMITED TO 0 BYTES *** - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Friday, June 01, 2001

Re: Check/Remove stray shared_memory_segment and semaphore

I was looking all day long for this doc.. can U point me to the right doc number .. Cheers - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, June 02, 2001 6:56 PM Not necessary to use glibc-2.1, Oracle has a patch for using with

RE: Renaming columns ...

Kirti, Thanks for the info, BTW are there any significant advantages of moving NOT NULL columns towards HEAD of the table? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here

RE: Oracle 9i is on technet (NT)

That's definitely what they do. Anyone want to sell me a Sparc box? Not you Spence, the shipping costs would bankrupt me !!! = ) Mike -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Database writer

Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the additional db writer processes? I added db_writer_processes to the init file, the instance started so I am

OPS, TAF and jAVA

We are looking at using TAF (never used before) for application fail over. First, any guidelines we should be aware of in general. Second any specific concerns using TAF with applications using JAVA. Any stuff on how does TAF and OPS work in harmony? Regards Murali Vallath

RE: COCO Proposal Review

Ingredients: 225g soft unsalted butter 375g dark muscovado sugar 2 large eggs - beaten 1 teaspoon vanilla extract 100g best dark chocolate - melted 200g plain flour 1 teaspoon bicarbonate of soda 250ml boiling water 23*13*7cm loaf tin Preheat the oven to 190c/gas mark 5, put in a baking sheet

Oracel Support was Re: MaterializeRe: Snapshot Logs Explanation Needed

Hi All, Anita is absolutely right. Before making any changes to the data dictionary call Oracle support. Before using undocumented parameters call Oracle Support. Before doing anything that you do not know all of the side effects for, CALL ORACLE

RE: Renaming columns ...

There is an oracle-supplied *.sql file to do this ...in the rdbms/admin directory as i recall. You will, of course, have to RTFM online and do some tinkering. I am so old that I can't remember much more about this, but anything to do with Diana sure perks me up. ahem. || -Original

RE: Oracle 9i is on technet (NT)

Now I would bet Linux will be next, not NT Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Does this

Re: Steps for removing jobs

Usefull article, but it missed one useful bit... * You can only manage your own jobs, even if you're a DBA user. -Not quite true, check out the DBMS_IJOB package. Does the same things as DBMS_JOB (submit, change delete jobs, etc) but lets you specify the 'owning' user. I found it in the

RE: 9i download

I found you absolutely have to use get right, anything from oracle site you generally have to download a few times to get it to actully work, sometimes I am lucky. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA

RE SQLServer archiving

Hi James, Well his clients disagree with you, and since they have actually worked with him, I prefer to trust their judgement. And while SQL2000 may have logs mirrored by the database, SQLServer 7 did not. Dave James Xing wrote snip Your friend is

RE: Database writer

Look under ps. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Hi all, I added db writer

Re: 9i download

I could never successfully download the file. I ended up getting the CD. [EMAIL PROTECTED] 06/04/01 11:15AM I keep trying to download 9i and the files keep being invalid gzip files. Anyone else have this problem or have successfully downloaded this monster? I have downloaded each file 3-4

Re: Renaming columns ...

This is right from Guru Steeve Adam's site No, if the table is referred to in any stored PL/SQL program units, you must first drop those program units and then manually delete the rows for that table (based on its OBJ# from OBJ$) from the 4 data dictionary tables beginning with IDL. The IDL

RE: Renaming columns ...

Yes renaming a column is supported, in fact you can change almost every aspect of a table online. it works parallel to existing table, right before switching them over, it gets the latest DML applied, then switches over. Walking on water and developing software from a specification are easy if

RE: Check/Remove stray shared_memory_segment and semaphore

I have it. If you want the tar file just e-mail me directly and I send it to you. -Original Message- Sent: Monday, June 04, 2001 10:21 AM To: Multiple recipients of list ORACLE-L I was looking all day long for this doc.. can U point me to the right doc number .. Cheers -

RE: 9i download

Note sure if your using a download manager Chris, I used ReGet (Tucows.com) the other day to get 8.1.7.3 and it worked really great. - E -Original Message- Sent: Monday, June 04, 2001 9:22 AM To: Multiple recipients of list ORACLE-L I could never successfully download the file. I ended

RE: Oracle 9i is on technet (NT)

I want one too, I need one for home to run StarOffice. A Starfire(?) would be all right I think. Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 1:41 PM

RE: Oracle 9i is on technet (NT)

In a perfect world maybe, but 80% or more of the business world is using some form of windows!! -Original Message- Sent: Monday, June 04, 2001 12:10 PM To: Multiple recipients of list ORACLE-L It just proves what we all knew . Unix Not NT. Never NT ... -Original

RE: Database writer

Kev, Trying to add multiple DBWR processes on NT is useless since NT uses asynch. I/O. If you remember, all the Oracle processes (DBWR, LGWR, CKPT, ARCH, etc.) run as threads under the oracle.exe process. Multiple DBWR processes are definitely a Unix thing! Also, here's something from

Re: Database writer

There is a tool in the WinNT Resource Kit that lets you look at individual threads per process. I don't remember what the name is, but it's in there. Try doing a select against v$session and v$bgprocess you should from v$bgprocess you should get a DBW0 and DBW1 under the listing of

RE: Database writer

Kevin, I apologize for asking but this is for the benefit of others possibly. But how did you determine that your instance may require an additional DBWR process. What led you to think that you had an bottleneck with only one process? Thanks, Ethan -Original Message- Sent: Monday,

RE: Renaming columns ...

Column position has no value what so ever. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 11:31 AM To: Multiple recipients of list ORACLE-L Kirti,

RE: Database writer

Hi, Kevin, Maybe this query will help: SQLselect PROGRAM from v$process where PROGRAM like '%DBW%'; Regards Vadim Gorbounov Oracle DBA -Original Message- Sent: Monday, June 04, 2001 11:56 AM To: Multiple recipients of list

RE: Oracle 9i is on technet (NT)

That has been known for some time. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 9:51 AM To: Multiple recipients of list ORACLE-L Does this prove

Re: COCO Proposal Review

Poor Ethan, his serious post about Oracle training has been morphed into chocolate cake recipes. Come on folks, give him a break. Jared On Friday 01 June 2001 16:14, Post, Ethan wrote: All, I have just thrown together a proposal I plan on sending out to a bunch of Oracle related groups

RE: Database writer

Unless Oracle changed the way it reported this, that won't work on NT. Oracle On NT didn't used to report bg procs in the program field of v$session. This may have changed with 8i. I haven't worked with 8i on NT. Used to have to join v$session and v$bgprocess on paddr. Rodd Holman

RE: Renaming columns ...

Kevin, see this link ... http://otn.oracle.com/docs/products/oracle9i/doc_library/901_doc/server.901/ a90117/tables.htm#12596 this link will be broken, but put it on one line and click ... there is a complete example ... BTW Oracle has done one job very well ... the 9i document search

RE: Database writer

You can see that at operating system level using next sentence: ps -ef | grep dbwr 04/06/2001 17.55 Kevin Kostyszyn [EMAIL PROTECTED] 04/06/2001 18.10 Por favor, responda a [EMAIL

Re: Database writer

On Monday 04 June 2001 10:16, Christopher Spence wrote: Look under ps. Really? On NT? Jared Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001

RE: Oracle 9i is on technet (NT)

I vote we do. I am actually trying to see if an Sun Ultra 1 will run Oracle 9i without any problems. If it does, I will through like 25 of them on ebay. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot

RE: Database writer

Have you tried v$bgprocess ? Regards Mark -Original Message- Kostyszyn Sent: Monday, June 04, 2001 04:56 To: Multiple recipients of list ORACLE-L Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if

RE: Renaming columns ...

Title: RE: Renaming columns ... To add to Kirti's' comments - The same applies for columns that have default values defined. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is

RE: On the question of What is a Large Database Anyway ?

Can anyone refer me to a site that lists this book as available.. -Original Message- Sent: Monday, June 04, 2001 6:15 AM To: Multiple recipients of list ORACLE-L Cary wrote the intro (and, along with Scott Gossett of Oracle University, Craig Shallahamer and a few other unknowns) did

Re: Size, what is it?

Hi Mogens I agree with all your statements. What I am trying to figure out is what is it that streches the machine. I was quite surprised to see an E450 doing 10GB of transaction logs per day. Pure OLTP using stored procs. I was hoping to get

RE: TUSC and Kevin Loney

I guess I am the last to discover this, but Kevin now works for TUSC. No Patrice - you were not the last! I thought Kevin was 'independent', so where did you get this info from? Anyway, TUSC is big in the Oracle area, and I wouldn't be surprised. John Kanagaraj -- Please see the official

RE: Idea for Very Cool 9i.x Feature

Ethan, http://technet.oracle.com:2000 I recently complained to Oracle about their usage of non standard port numbers (which sometimes are blocked by companies, like ours). So, I received a reply (within 8 hours Surprise !) that Oracle is in the process of moving to standard port numbers for

RE: Renaming columns ...

HELP ! -Original Message- From: PHU,JULIA (HP-Sunnyvale,ex2) [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 2:21 PM To: Multiple recipients of list ORACLE-L Subject: RE: Renaming columns ... ALTER TABLE table_name MODIFY ( new_col_name DATATYPE); It works for me

OT RE: Database writer

Yea, NT blows. Blows like a fresh wind against the empire. (1st one to name that song lyric reference and i buy you a beer. NT bigots and their families summarily excused from this offer.:) || -Original Message- || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || Sent: Monday,

ora-600

Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official

Re: TUSC and Kevin Loney

See: http://www.tusc.com/oracle/news/20010222a.html WORLD-RENOWNED ORACLE EXPERT KEVIN LONEY JOINS TUSC CHICAGO (Feb. 22, 2001) -- TUSC, the Oracle Experts, has announced a second major appointment in the past week with the hiring of world-renowned Oracle database administrator Kevin M.

OT RE: Renaming columns ...

ARE YOU AN IDIOT || -Original Message- || From: Deshpande, Kirti [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 4:17 PM || To: Multiple recipients of list ORACLE-L || Subject: RE: Renaming columns ... || || || HELP ! || || -Original Message- || From:

RE: Oracle 9i is on technet (NT)

Nope. HP-UX and AIX are in the next batch. BSOD will be there in August and Linux not before the late October. May be you'll even have to wait for the last week of Novebmer to give thanks to the Oracle Corp. -Original Message- Sent: Monday, June 04, 2001 2:23 PM To: Multiple recipients

RE: performance impact of optimizer_search_limit

DDES! This parameter is session modifiable. To wit: SVRMGR alter session set optimizer_search_limit=400; ORA-00068: invalid value 400 for parameter optimizer_search_limit, must be between 3 and 255 So, IF (you='heavily certified') THEN (wave OCP pigskin over dbms, wait for

Re: 9i download

Is that ReGet Junior or Deluxe? Or, does it make a difference? Also, has anyone tried Download Accelerator Plus? It seems to be a similar product. Thanks, Ken Janusz, CPIM I'll second that. It's the only way to get a clean download from technet. Jared On Monday 04 June 2001

RE: When are the various Bckground process stated during the DATA

RTFalert.log. It contains the start order/timestamp for each. Happy R'ing! - Ross || -Original Message- || From: Rajaram [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 3:46 PM || To: Multiple recipients of list ORACLE-L || Subject: When are the various Bckground process

Re: OCP Model Questions

Hi, I have got this response from many and checked that the site is OK. May be the problem is with your proxy. I too can't access any site from my office which has an underscore within url, not the case when I access from my home. I think this is something to do with Proxy settings. Please

RE: Training Database

Hi John, Here is an archived (my personal) post from Mladan Gogala related to a similar question... Hope this helps.. Regards, -Original Message- From: Mladen Gogala [SMTP:[EMAIL PROTECTED]] Sent: Monday, January 10, 2000 10:54 PM To: oracle

Re: Windows ME and Net8

I would try using the WIN2K Client CD. Good Luck April Wells wrote: We have several clients, mostly running NT or 98, and we have been able to get Net8 to install fine. Using the same CD, we cannot get it to install on Windows ME. I have been trying to get an answer as to support from

RE: ora-600

Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, -

OT RE: TUSC and Kevin Loney

And Rachel works for Godiva. || -Original Message- || From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] || Sent: Monday, June 04, 2001 4:37 PM || To: Multiple recipients of list ORACLE-L || Subject: Re: TUSC and Kevin Loney || || || and Steven Feuerstein works for Quest || || ||

Re: OCP Model Questions

Remove the ). from the url and it works. http://smart_and_handsome.tripod.com/oracle.html Krishna Kakatur [EMAIL PROTECTED] 06/04/01 03:44PM Hi, I have got this response from many and checked that the site is OK. May be the problem is with your proxy. I too can't access any site from my

RE: Database writer

It's right there SID = 2, SERIAL# = 1. The name column is the THREAD running the background process. The program column is the PROCESS under NT which is ORACLE80.EXE. Oracle on NT runs ALL the oracle processes under one process with many threads that's why you need the join to v$bgprocess

RE: ora-600

It means that you should be calling 1-800-223-1711 and have your CSI ready instead of having fun on this mailing list.. -Original Message- Sent: Monday, June 04, 2001 4:11 PM To: Multiple recipients of list ORACLE-L Hi Friends What does it mean?? ORA-00600: internal error code,

RE: Renaming columns ...

Oops! My apology. It was for datatype changed. Erased what I said. -Original Message- Sent: Monday, June 04, 2001 1:59 PM To: Multiple recipients of list ORACLE-L How does it know which column to rename? At 11:21 AM 6/4/01 -0800, you wrote: ALTER TABLE table_name MODIFY (

RE: Database writer

Well duh? :) Sorry, but isn't the Database Writer an Oracle process? -Original Message- Sent: Monday, June 04, 2001 08:46 To: Multiple recipients of list ORACLE-L But I don't see any Processors for DBWr except ORACLE80.EXE!! SIDSERIAL#SCHEMANAME

Re: Idea for Very Cool 9i.x Feature

On Monday 04 June 2001 10:56, Post, Ethan wrote: Where do we submit our ideas for enhancement ideas anyway? If you haven't already, join IOUG. That is where official enhancement requests come from. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still

RE: OT RE: TUSC and Kevin Loney

Steve Feuerstein works for Quest Wow, cool, interesting. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Monday, June 04, 2001 5:28 PM To: Multiple recipients of list

RE: ora-600

Well, is the answer for all ORA 600's, I have noticed there are different ones. One of my fellow employees just called me and told me that the production instance at a clients site just went down with ORA 600. He said that it said in paren's, (with complications). Now what in the good lords

RE: 9i download

I use it on a 56k dial up, and it works great!! Mark -Original Message- [EMAIL PROTECTED] Sent: Monday, June 04, 2001 09:44 To: Multiple recipients of list ORACLE-L Is that ReGet Junior or Deluxe? Or, does it make a difference? Also, has anyone tried Download Accelerator Plus? It

RE: ora-600

Raghu, as Mladen said .. it means that u have hit an oracle bug.. generally the first parameter tells Oracle what code path encountered the bug. Other parameters are specific and relavant measures that might vary based on what the first parameter is. In addition, ora-600 is accompanied by a

RE: ora-600

Ora-600 . thats the new race where they make you run around sending them this and that 600 times before they tell you we have no Idea. Its the Oracle Catch-All error. Call Support. They will probably want to see any dump or trace files generated. -Original Message- Sent:

RE: TUSC and Kevin Loney

Can't let that happen! If that happened, there would be Tusc DB 1.0 and all us oracle guru's will be useless against that product. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message-

Re: don't anger the xoxolate gods / Re: Idea for Very Cool

At 11:16 AM 6/4/01 -0800, you wrote: the punishment for further offence will be to be reborn as a human sized cochroach made to work in marketing. But you are repeating yourself Dennis Taylor One man's beach is another man's erosion. -- Please see the

Re: Database writer

Kevin, What size is your redo log buffer? Jared On Monday 04 June 2001 08:55, Kevin Kostyszyn wrote: Hi all, I added db writer processes last week to try and improve performance of one of my 8.1.7 db's on NT. Does anyone know if there is a way to see if Oracle actually started the

Compute statisics

I have just received some notes from one our applications support, and they suggest after I compute statistics for the objects within their schema, that I then delete those statistics where num_rows * avg_row_len 65000 ?? What affect could this possibly have on the system ? I thought you would

RE: TUSC and Kevin Loney

Who is Kevin Loney? -Original Message- Sent: Monday, June 04, 2001 6:55 PM To: Multiple recipients of list ORACLE-L Can't let that happen! If that happened, there would be Tusc DB 1.0 and all us oracle guru's will be useless against that product. Walking on water and developing

how to run procedure containig REF CURSOR as datatype

Hi, What value to pass as io_cursor in the following procedureHow to run the procedures containing REF CURSOR.. create or replace package GetRateSchedules_pkg as TYPE t_cursor is REF CURSOR; procedure GetRateSchedules( temp_id_acc int,acc_cycle_id int,default_pl

RE: TUSC and Kevin Loney

And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think Steve Adams is on the hit list. As far as I am aware, some of the very respectable 'big guns' at Quest are: Gaja, Eyal Aronoff, Guy Harrison (yes - the one from the 'Oracle SQL tuning'

RE: TUSC and Kevin Loney

At TUSC, there are more authors than Rich Niemiec, Mike Ault, and Kevin Loney. There are also Brad Brown, Joe Trezzo, Tony Catalano. -Ari On Mon, 4 Jun 2001, John Kanagaraj wrote: And tusc has a partnership w/ quest. Weird. tusc does a lot of their recruiting at Barnes and Noble. I think

RE: NT script question ???

Go to http://www.activestate.com, get perl, DBI DBD::Oracle and you'll have all the cripting tools that you'll ever need. Associative arrays, state of the art reuglar expressions, functions, format commands and well documented ways of accessing the oracle database from within a script (O'Reilly

export causes segmentation fault

Hi, A friend of mine ran an export and got segmentation fault. It seems to be a bug with 8.1.6 on Solaris 5.8 and relates to character sets. Below is the info supplied by him. Anyone has experienced the same problem or could give a suggestion what to try? I searched Metalink and could not

Re: TUSC and Kevin Loney

On Monday 04 June 2001 16:35, Khedr, Waleed wrote: Who is Kevin Loney? http://www.kevinloney.com Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051

RE: Database writer

Title: RE: Database writer you can download a free fully functional trial version of Spotlight on Oracle from the Quest Website at http://www.quest.com/spotlight_oracle/ there is a link to 'download trial' on the left hand side. You can click on the screenshot to get a full size image... but

Re: TUSC and Kevin Loney

Oracle8/8i DBA Handbook Author visit www.kevinloney.com He is pretty good in Oracle . - SathishB - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 04, 2001 7:35 PM Who is Kevin Loney? -Original Message- Sent: Monday, June 04,

RE: Database writer

Nick, Does spotlight support an Oracle server running on NT? The requirements page says: Server Oracle versions from 7.3.3 and above Solaris (2.5, 2.6, 2.7) HP-UX (10.20, 11.00/32 bit, 11.00/64 bit) AIX (4.2, 4.3) Digital (v4.0d, v4.0f) which seems to me to say the Oracle server must

Re: OT RE: TUSC and Kevin Loney

the heck you say! Good chocolate or none at all... Callebrut From: Mohan, Ross [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: OT RE: TUSC and Kevin Loney Date: Mon, 04 Jun 2001 13:27:38 -0800 And Rachel works for Godiva. ||

RE: ora-600

ora-600 is a severe error and the codes in parens are debugging codes for Oracle Support CALL SUPPORT when you get an ora-600 and ora-7445 From: Kevin Kostyszyn [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: ora-600 Date:

  1   2   >