RE: Bye...

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Automatic or Uniform allocation

Ron, I agree, uniform sizing is best. I hardly ever use automatic except for small development databases and small MISC tablespaces and even then I think Why didn't I use use uniform 64K ? Cheers, Chris Quoting Ron Rogers [EMAIL PROTECTED]: Brad, For LMT's I prefer uniform sizing that I

RE: pga_aggregate_target and a memory leak

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED

RE: What to look for in STATSPACK report

searching and replacing or something. ..that should get you started though. ...sorry for the not so helpful post, but maybe this will trigger something. chris -Original Message- Sent: Thursday, January 22, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Jared, I played YAPPPACK

Re: FW: Disk capacity planning

. A combination of paper calculations, testing, experience and looking at comparable systems will help to provide a good estimate. Cheers, Chris Quoting Mladen Gogala [EMAIL PROTECTED]: Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os per second can they perform

RE: 9iAS Calender Servlet

I did a quick and dirty one in pl/sql. No security, or checks on content yet though. I'd be more than happy to send it to you. It might be kind of ugly...i've not done a ton of coding. (something I am actively working on. Let me know, Chris -Original Message- Sent: Wednesday, January

after the discussion yesterday on db2/mysql/postgresql....

I thought this might be relevant and interesting... http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr ack=NL-93 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858

RE: Does SQL Server have a wait interface?

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: FW: Disk capacity planning

Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't

Re: What to look for in STATSPACK report

then all's OK. (BTW I'm aware that buffer cache hit ratio statistics in isolation aren't a good indicator of performance good or bad.) HTH Cheers, Chris Quoting Mogens Nørgaard [EMAIL PROTECTED]: Hi Helmut, There are so many opinions about this that it's hard to point at one specific document

RE: ORA-904 after table rename

I went through a similar problem with the 904 error. I had to use oradebug to get a trace file to be produced. Good luck, Chris -Original Message- Sent: Monday, January 19, 2004 8:14 AM To: Multiple recipients of list ORACLE-L It turns out that the user had configured TOAD to use

Re: powerbuilder in rbo and multiple constraint question...

Chris, I've worked on a large Powerbuilder App for a number of years. We used CBO all the time under 7.3.2, 7.3.4 and 8.1.7. You're right Powerbuilder per se requiring RBO is rubbish. Cheers, Chris Dunscombe Quoting Chris Stephens [EMAIL PROTECTED]: I'm working with a 3rd party vendor

powerbuilder in rbo and multiple constraint question...

responded by saying the redundant constraints wouldn't be a problem in sql server. ...something I'm almost positive they haven't validated either. Thanks! chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network

Re: table reorganizations

Rachel, Thanks for the idea but the system is running 8i. I'll remember it for the future. Chris Quoting Rachel Carmichael [EMAIL PROTECTED]: Chris, Have you considered using dbms_redefinition for your second case? That would allow you to reorg and swap the tables without locking for any

RE: table reorganizations

daily the table would end up being at least twice as large as necessary and therefore impcat the performance of FTS. These examples were both on 8i but I don't think 9i would make any difference. Pls let me know the details if 9i does make a difference. Cheers, Chris Quoting Mercadante

RE: table reorganizations

level where it can be allocated to any tablespace in the future. In the second the table-swap was first implemented under Oracle 7 so alter table move wasn't available. I hope this explains the reasoning. Chris Quoting Niall Litchfield [EMAIL PROTECTED]: Hi Chris Richard, I agree

Re: table reorganizations

and source tables are swapped, hence table-swap. The new source table is now available to the application and the original source is truncated and ready to be the target in 24 hrs time. Cheers, Chris Dunscombe Quoting Richard Foote [EMAIL PROTECTED]: MessageHi Thomas, Never say never (oh

RE: Oracle Warehouse Builder Tutorial

that previous releases. Chris -Original Message- Sent: Friday, January 09, 2004 10:55 AM To: Multiple recipients of list ORACLE-L Would love to know! -Original Message- Stahlke, Mark Sent: Friday, January 09, 2004 11:34 AM To: Multiple recipients of list ORACLE-L Greetings, Does

RE: Any good product / option for Source code control

Cary, You recall correctly, just checked the website and it's distributed under the GPL with no costs mentioned. There are also a number of other interesting utilities for download also under the GPL. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: WinCVS has worked well

RE: Difference on ArchiveLog

The logical explanation is that activity in your database varies from day to day. Try sitting back and keeping the size the same for a while and watch the space taken. Chris -Original Message- From: Mauricio Vilez [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 07, 2004

ora1652 question...

would imagine there is an event to set so that I can generate a trace file. Any other suggestions of nailing this down would be appreciated. ..and so I don't have to ask about events anymore...where do I find what event means what? Thanks, Chris -- Please see the official ORACLE-L FAQ: http

RE: RE: Hit Ratio

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Who fired the trigger

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: SQL and PL/SQL tuning template document required urgently

Dennis, Excellent recommendation, Guy Harrison's book (2nd Edition) is excellent the best I've seen on SQL tuning. I've used it for a number of years. I had the 1st edition and then bought the 2nd when it came out. Cheers, Chris -Original Message- Sent: 29 October 2003 15:49

RE: RE: OCP 9i New Features for DBAs

the answers when marking yourself just to be on the safe side. I must point out that on a couple of occaisions the book was right when I initially thought it was wrong. Cheers, Chris -Original Message- Sent: 20 November 2003 18:35 To: Multiple recipients of list ORACLE-L Chris, Care

SQL comparison addition: Resolution...

being a bug in 9203. Not sure which bug. Support insisted that we patch to 9204 and the problem went away. Thanks for everyone's help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

RE: RE: OCP 9i New Features for DBAs

it all seemed to be 9.0. Hope all goes well when you take your exam. Cheers, Chris -Original Message- Sent: 12 November 2003 18:25 To: Multiple recipients of list ORACLE-L im going to take it soon. I was going to just read howard rogers guide then the otn one. you think

RE: HTML DB

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: SQL comparison addition:

I'll try tracing the session. Global.client_dim is just a table with client info and a column that corresponds to client logins to enable row level security. Thanks for the suggestions. As stated earlier..i'll post the resolution. chris -Original Message- Sent: Tuesday, November 11

RE: (looong) PCTFREE, PCTUSED and ASSM

Tanel, Maybe a PQ FTS needs to resolve migrated rows immediately as it's possible that the migrated row is located in a block that's allocated to a different PQ slave. Chris -Original Message- Sent: 12 November 2003 15:49 To: Multiple recipients of list ORACLE-L As a strange thing

OCP 9i New Features for DBAs

Hi, I'm currently studying for this exam but can't find info to say whether the exam covers 9.2 or just 9.0. Anyone any clues Thanks, Chris Dunscombe -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Dunscombe, Chris INET: [EMAIL PROTECTED] Fat City Network

SQL comparison question...

')||'|' |REPORTS_DELTA| SQL select '|'||reports_login||'|' 2 from global.client_dim 3 where reports_login='REPORTS_DELTA'; '|'||REPORTS_LOGIN||'|' |REPORTS_DELTA| ...that doesn't appear to be it. any ideas? Thanks for any help! Chris -- Please

SQL comparison addition:

SELECT count(*) 2 FROM global.client_dim a 3* WHERE TRIM(sys_context('userenv','session_user')) =TRIM(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network

RE: SQL comparison addition:

','session_user') = a.REPORTS_LOGIN; Daniel Chris Stephens wrote: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE sys_context('userenv','session_user') = a.REPORTS_LOGIN SQL / COUNT(*) -- 1 ...but we had a problem 2 weeks ago where

RE: SQL comparison addition:

, WI USA -Original Message- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Tuesday, November 11, 2003 11:19 AM To: Multiple recipients of list ORACLE-L Subject: SQL comparison addition: I just tried: 1 SELECT count(*) 2 FROM global.client_dim a 3* WHERE

RE: SQL comparison addition:

global.client_dim a 3* WHERE sys_context('userenv','session_user') = trim(a.REPORTS_LOGIN) SQL / COUNT(*) -- 0 I'm going to open a tar on this. I will email the resolution. ...and check for any more suggestions! :) Chris -Original Message- Sent: Tuesday, November 11

Apps HR Info - OID/SSO/Portal

? ...or information outside of the docs? Thanks! Chris

Trapping Portal Login

pose the question in hopes of a quick and easy response. Thanks Chris

RE: RE: wait/notify syntax for unix help please

There's no problem with waiting after the process has already finished, you'll just get a non-zero return code the wait but evrything will still work fine. Chris -Original Message- Sent: 27 October 2003 18:54 To: Multiple recipients of list ORACLE-L if you attemp to wait after

RE: wait/notify syntax for unix help please

${PID_WAIT} HTH Chris Dunscombe -Original Message- Sent: 27 October 2003 16:09 To: Multiple recipients of list ORACLE-L I need to parallelize some sql operations and Im running them from unix scripts. I want to spawn off a few in the background from a master script, then have the master

RE: Opinions sought on possible TOAD replacement

Paul, I've used PL/SQL Developer by Allround Automations to develop PL/SQL procs, packages and it's fine including a well featured de-bugger. I believe that a site licence costs $3,000. As to it being a DBA tool I'd have to say it's not in the same league as TOAD Xpert with DBA module. Chris

RE: LMT and Fragmentation

Niall, I played around with autoallocate on 8.1.7 a while back and came to the same conclusions as yourself. Chris -Original Message- Sent: 13 October 2003 21:54 To: Multiple recipients of list ORACLE-L A week or so ago Jesse (I think) suggested a test to see whether auto-allocate

RE: EMC Snapshot Technology

cached. Since I'm a SAN newbie, I'm starting with the Introduction to SAN paper, and reading my way up. I don't want to raise a red flag until I can prove it. Please keep me in mind with whatever path you take. And if you present your findings let me know, I would love to read'em. Thanks. Chris

RE: Re[2]: Cary's Book - new topic

, 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat

RE: RE: Desupport of RBO

07, 2003 5:16 PM To: Grabowy, Chris; 'Multiple recipients of list ORACLE-L ' For right now, I am unable to comment on anything 10g. Thanks for understanding! Robert -Original Message- To: Multiple recipients of list ORACLE-L Sent: 10/7/2003 3:44 PM Nope. Mr Freeman are you out

RE: Small Oracle db

list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

interesting article...

Title: RE: RE: Cary's Book - new topic http://www.eweek.com/article2/0,4149,1312906,00.asp

Sujatha.Madan@optus.net.au

Title: Message I've been looking to do this for a while...would you mind sharing the script?? Thanks either way!! chris -Original Message- From: Sujatha Madan [mailto:[EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 11:29 PM To: Multiple recipients of list ORACLE-L

RE: Desupport of RBO

Title: RE: Desupport of RBO At the recent NYOUG conference, they were handing out special preview copies of Oracle 10g New Features by our very own Robert Freeman Page 11 has a section entitled...Collecting Data Dictionary Statistics...this is done using the

RE: Openworld Papers

Unlike IOUG, if I remember correctly, OracleWorld's presentations were publicly available via their websiteon the first or was it the second day of the conference. I could not make it to the conference, but I was watching some of the keynotes and reading over their presentations during

RE: RE: Desupport of RBO

PM To: Multiple recipients of list ORACLE-L did he mention any benchmarked performance improvements from gathering statistics on the system tablespacE? From: Grabowy, Chris [EMAIL PROTECTED] Date: 2003/10/07 Tue PM 03:34:25 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

RE: RE: Unintentional Humor

(or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: Seems odd to me....(bug?)

PROTECTED] Sent: Friday, October 03, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Subject: Re: Seems odd to me(bug?) Chris, normally you should get only the table or view does not exist, but you are also getting ora-0604 which leads me to the conclusion that there's more to it them

RE: alter system

!!!...and everyone's help for that matter! chris -Original Message- Sent: Friday, October 03, 2003 10:11 AM To: Chris Stephens Then, you have to use oradebug. It goes like this: oradebug setmypid oradebug event 942 trace name errorstack forever, level 10 You MUST be connected as sysdba in order

RE: Seems odd to me....(bug?)

never had problems with. that did not solve it. ...I will try Mladen's suggestion next. chris -Original Message- From: April Wells [mailto:[EMAIL PROTECTED] Sent: Friday, October 03, 2003 4:49 AM To: Multiple recipients of list ORACLE-L Subject: RE: Seems odd to me(bug

Seems odd to me....(bug?)

by an existing object Any ideas? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Off Topic: PC Firewall Recommendation

Try Zonealarm. It's free. I have a wireless router, which has a built in firewall. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of KENNETH JANUSZSent: Monday, September 29, 2003 10:05 AMTo: Multiple recipients of list ORACLE-LSubject: Off

RE: FTP big file to little laptop

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: FTP big file to little laptop

may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: equivalent for isdate, isnumeric

subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)

mode). Confusing I know but somehow true. As an aside I don't think this applies to the likes of HP-UX. I'm fairly sure that running 32bit HP-UX 11 on 64 bit hardware will not allow 64 bit Oracle to run. HTH Chris Dunscombe -Original Message- Sent: 11 September 2003 21:39 To: Multiple

RE: 64 bit Oracle (8.1.7) on a 32 bit AIX kernel (AIX 4.3.3)

5L. Cheers, Chris -Original Message- Sent: 12 September 2003 15:30 To: Multiple recipients of list ORACLE-L Thanks for the response. I have Metalink note 231901.1 which explains the options for installing 8.1.7 on AIX 5L, so I understand what I have to do (after reading it three times

RE: Copying statistics : used a lot ????

') 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET

RE: Oracle Masters exam

that my company won't be shelling the $$$ out and my pockets are nowhere near that deep. It's too bad. It seems like it would be fun. Chris -Original Message- Sent: Thursday, September 04, 2003 10:20 AM To: Multiple recipients of list ORACLE-L So, it's nothing like OCP where you get

Oracle's Masters program....

they have to write and end up only completing around 30% of that section. A little bit of info on it for you anyway. If there is anything you would like to know about it I can try to find out for you. It'll be interesting to see if this thing takes off. Chris -- Please see the official

OT: The Coming Job Boom

like these? Below is a link to the article, which requires membership... http://www.business2.com/articles/mag/0,1640,51816,00.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

RE: The Coming Job Boom...cnn has a an article on the job boom su

PROTECTED] Quad/Tech Inc, Sussex, WI USA -Original Message- From: Grabowy, Chris [mailto:[EMAIL PROTECTED]] Sent: Friday, August 29, 2003 9:31 AM To: Multiple recipients of list ORACLE-L Subject: OT: The Coming Job Boom My apologies for this OT post. There is an article

RE: Oracle World anyone?

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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED

RE: Move selected tables

ability to do anything about it depends on how much control they have over introduction of new code. Good luck, -Chris -Original Message- From: Smith, Ron L. [mailto:[EMAIL PROTECTED] Sent: Monday, August 04, 2003 12:14 PM To: Multiple recipients of list ORACLE-L Subject: Move

RE: Redo Logs Problem

: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE

RE: How to display FLOAT in 99999.999 format

immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

nothing directly related to Oracle...but certainly relevant...

Title: nothing directly related to Oracle...but certainly relevant... http://story.news.yahoo.com/news?tmpl=story=/nm/20030729/tc_nm/tech_jobs_dc_1 the world is changing quickly. Chris Current DBA in-progress...future ???

RE: Oracle Banner

Yes it is.  We actually had to do it for a canned app that checked the exact version of the database...for no apparent reason.  The app would only run on 8.1.6 and we were running 8.1.7...so we just created a table with the exact same structure as v$_version and update the table to reflect

RE: Oracle Banner

- From: Chris Stephens [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 3:04 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle Banner Yes it is. We actually had to do it for a canned app that checked the exact version of the database...for no apparent reason. The app would only run

RE: Problem with Autotrace ?

afraid I don't have anything add to the original question, I was going to suggest the obvious grant PLUSTRACE but I reviewed the thread and saw that was already dealt with. -Chris -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Sent: Monday, July 28, 2003 5:14 PM

RE: dbms_job

, you have to beg support for the 8i install script, but the 9i install script is included in $ORACLE_HOME/rdbms/admin. There are some notes about this in some of the forums at metalink ( I searched 'dbms_system dbms_support'). HTH, -Chris -Original Message- From: [EMAIL PROTECTED

bad press for oracle....

Title: bad press for oracle http://rss.com.com/2110-1017_3-5053453.html?type=pt=rss=feed=news

DB_BLOCK_SIZE??? Survey.

for OLTP/DWs. I promise to tally the results and share them with everyone. mailto:[EMAIL PROTECTED] Many thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: Veritas like RMAN?

-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: faq broke? -- Other options

Title: RE: faq broke? -- Other options There was an astTom article in the latest issue of Oracle magazine that went over how to do this (I don't think it was specific to 9i) and then went on to explain why you WOULDNT want to do this. -Original Message- From: Hallas, John, Tech Dev

RE: Empty String is interpreted as NULL

are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Find the table's name that using sequences

Well, there could be business logic reasons as to why you would have one sequence per table. Also, I don't know if I would ever go with one sequence for many tables, sounds like a bottle neck to me. And how would one sequence for many tables impact scalability?? Or having lots of users

RE: full usefullness of CURRENT OF ???

I believe (I could be totally wrong here) the reason for the CURRENT OF is both for performance and consistency. The second example has to run the update statement seperately. CURRENT OF can go directly to the row(s) affected. CURRENT OF still has to modify each block header in the

RE: full usefullness of CURRENT OF ???

]] Sent: Friday, July 11, 2003 3:09 PM To: Multiple recipients of list ORACLE-L Subject: RE: full usefullness of CURRENT OF ??? --- Chris Stephens [EMAIL PROTECTED] wrote: Also, the CURRENT OF locks the table so that no one can modify (or even read) it while the transaction is taking place

RE: salary question

The beer is cheaper in Canada... -Original Message- Sent: Monday, July 07, 2003 7:54 AM To: Multiple recipients of list ORACLE-L Check out the Canadian results... http://www.payscale.com/salary-survey/aid-10747/raname-SALARY/fid-7031/

Raid 0+1 vs. mirrored pairs

of having sets of mirrored pairs. That way I can separate tables, indexes, redo logs, rollbacks, etc. Is my admin right? Are raid 0+1 setups the best of the best? Better than sets of mirrored pairs? Thank you in advance. Chris

RE: perl DBI/DBD: can I pass in an array as parameter?

have typos in the perl code. But the concept should work. -Chris LEGAL NOTICE: Unless expressly stated otherwise, this message is confidential and may be privileged. It is intended for the addressee(s) only. Access to this e-mail by anyone else is unauthorized. If you are not an addressee

RE: SELECT Output Default Ordering ?

be unlawful. If you are not an addressee, please inform the sender immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

Test please ignore

. -- Chris J. Guidry Principal Engineer, DCSI Phone: (314) 895-6516 Fax: (314) 895-6453 Email: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guidry, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Rebuilding MLOG tables

://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: SAME technology question .....

sentence above). -Chris -Original Message- From: Johnson, Michael [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 1:35 PM To: Multiple recipients of list ORACLE-L Subject: SAME technology question . A couple years ago, Juan Louiza(sp) of Oracle Corporation put out

Re: How to Uninstall apps1

..) than If u perform single instance installs, clones etc... It can be done though... The real problem with multiple instances/cloningis that registry settings are hard-coded. HTH's Chris BlaisPrincipal DBA BlazingPathways Inc. PS. The following weremy opinion only

Re: How to Uninstall apps1

..) than If u perform single instance installs, clones etc... It can be done though... The real problem with multiple instances/cloningis that registry settings are hard-coded. HTH's Chris BlaisPrincipal DBA BlazingPathways Inc. PS. The following weremy opinion only

Re: How to Uninstall apps1

updatablecausing registry to grow) HTH's Chris blais Principal DBA BlazingPathways Inc. Do you Yahoo!? Free online calendar with sync to Outlook(TM).

RE: How to Uninstall apps1

advancd server,we've had to become fairlyefficient at de-installing -) HTH's, Chris Blais Principal DBA BlazingPathways Inc. [EMAIL PROTECTED]--- RE: How to Uninstall apps11i "Senthil Kumar D" <

Oracle text question

this is clear. Thanks for any input. Happy Friday!!! Chris

RE: Unix host name change - what happens to db?

://www.orafaq.net -- Author: Sarnowski, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

RE: linux intel support matrix

From: Weaver, Walt [EMAIL PROTECTED] They make you work in the afternoon --Walt Weaver Bozeman, Montana You mean sometimes you aren't at work? Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must

Re: dbshut script - shutdown or shutdown immediate

From: Joan Hsieh [EMAIL PROTECTED] Chris, We hang on shutdown immediate, not startup. That's why I choose to use shutdown abort. Well, in that case of course you'd use it, but personally, if it was me, I'd want to find out why it was hanging, and fix that instead. I'm not suggesting shutdown

RE: Remote DBA

. Chris Berry [EMAIL PROTECTED] Systems Administrator JM Associates Without change, something sleeps inside us, and seldom awakens. The sleeper must awaken. -- Duke Leto Atreides _ STOP MORE SPAM with the new MSN 8 and get 2 months

  1   2   3   4   5   6   >