Re: Cheap table lock?

On 2002.09.27 20:33 tony ynot wrote: Is Select ... For Update; a cheap table lock? It seems whenever code uses this statement all the records in the cursor are locked until the cursor is closed. Fancy that! It works as described in the manual! Who would say? -- Mladen Gogala -- Please

Re: Backups

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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL

Re: Table Scans

=o.object_id AND o.object_type='TABLE' AND standard.bitand(x.flag,524288)0 AND o.owner'SYS'; -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: OEM changes

PROTECTED] (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). -- Mladen Gogala -- Please see

Re: reorg and rebuild

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

Re: IO wait

servers and who knows what he's doing. Preferably, you'll get somebody from Simon Trevaglia's (my hero) school of thought. Experience tells me that sites which have people like that are normally functioning well with close to 100% uptime (I know, I know). -- Mladen Gogala -- Please see

Re: Cursor Sharing

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

Re: ORA-00600: ???

PROTECTED] (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). -- Mladen Gogala -- Please see the official

Re: Install Oracle 8i on Windows XP?

step in the desktop Since when is return to the dinosaurs called evolution? progression after XP. Donward progression, that is. Just press Ctrl-Alt-Del. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City

Re: Install Oracle 8i on Windows XP?

remedies are still in the process. Winning over Java and open source in the usual Microsoft way will probably not be possible. The MS way means strongarming PC dealers and threatenning clients to revoke licenses if they deploy a hostile OS. -- Mladen Gogala -- Please see the official ORACLE-L FAQ

Re: Install Oracle 8i on Windows XP?

On 2002.07.28 14:03 Eric D. Pierce wrote: On 27 Jul 2002 at 17:03, Mladen Gogala wrote: On 2002.07.27 19:58 Eric D. Pierce wrote: Silly masturbatory bigotry. I suppose you think it is a good thing to drive all the NT people to using SQL Server by acting like a typical snobby

Re: OT : Basic Critical O.S. Values that Trigger Problem Alert

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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Table Naming Conventions

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

Re:

information (like subscribing). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

Jared, please do something

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

Re: d/w for a central bank

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

Re: UNIX Q: How do I delete files beginning with #

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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ

Re: Monitoring occurence of snaphot too old

') 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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: missed Anjo's webcast..

is fundamentally sound and I agree with it wholeheartedly. I'm just not yet ready to completely discard and ignore BHR. May be it's a superstiton, may be I'm in this business for too long, but I believe that it can give me an indicator whether I have a problem or not. -- Mladen Gogala -- Please see

Re: Moving a Directory Across File Systems -- Unix

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

Re: Houston, do I have a problem?

to the professional advice. Loook under damagement. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: Explain Plan Question

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

Re: LOG_ARCHIVE_DEST and NFS

it done. I even tried it unsuccessfully on 2 SUN E450 machines after reading the NFS3 specification document, but it wouldn't work. I suspect that about the only thing you can do is to re-write NFS yourself. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: RMAN recovery stuck

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

Re: It took more than an hour to update 10,000 records

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

Re: Export to tape

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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http

Re: Oracle Linking

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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http

Re: Tuning methodology (was T3's) and use of NetApp's

the allocation latch. After many hours of trying, I finally gave up trying to understand the algorithm. Can you, please, shed some light on that? Thanks! -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network

Re: Identify unused indexes in 8i ?

). You may also send the HELP command for other information (like subscribing). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego

Re: Identify unused indexes in 8i ?

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

Re: woo hoo

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

Re: convert long raw to varchar2

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

Re: doubt in INDEX

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

Re: OPS Sequences: nocache == order ??

(larger number before the smaller one). Please, o OPS gods and godesses, help me out and I'll sacrifice you a beer when I see you. Mladen Gogala -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City

Re: OPS Sequences: nocache == order ??

is the same thing as NOCACHE and whether it is possible to have a NOCACHE sequence which will return numbers in an incorrect order (larger number before the smaller one). Please, o OPS gods and godesses, help me out and I'll sacrifice you a beer when I see you. Mladen Gogala

Re: Oracle on windows vs Redhat

has 70 GB of disk drives (SCSI IIW), 1300 MHZ Athlon, 640MB RAM, NVIDIA VANTA with 32 MB and Creative Labs PCI 128 soundcard. Performance was almost identical. Now, if you ask me which OS I prefer, Linux wins hands down. After all, I am a UNIX elitist SOB. -- Mladen Gogala -- Please see

Re: Function-Based Index not working

On 2002.09.05 22:18 Rachel Carmichael wrote: I love automagic things :) so I can leave the table alone right now there are all of 7 rows in it Rachel Given the size of the the table, may be you should try partitioning it? -- Mladen Gogala -- Please see the official ORACLE-L FAQ

Re: No space left on device - but I have lots left.

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

Re: View Locks

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

Re: count(*)

-Mail message to: [EMAIL PROTECTED] (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). -- Mladen Gogala

Re: newbie seeks career direction: become a DBA or DEVELOPER?

with a completed OCP you have a lot to learn before you master the ways of the force. Good luck! -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538

Re: newbie seeks career direction: become a DBA or DEVELOPER?

sarcasm is, most definitely, a necessary precondition for becoming a good DBA. I developed it into an art form. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: Data Warehouse Hardware Recommendations

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

Re: news server

On 2002.05.23 07:08 Yechiel Adar wrote: I am looking for the address of oracle news server. metalink.oracle.com -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

Re: RedHat

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

Re: newbie seeks career direction: become a DBA or DEVELOPER?

for the rest of us, techies. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: 8.1.7.4

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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Oracle and OpenVMS (was: Rename Column in 9iR2)

OpenVMS for me. I'll stick with the mainstream. Unix rulez! OpenVMS was a nice system, DEC products were beautifully engineered but their marketing sucked big time. They fully deserved what happened to them. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author

Re: Bitmap vs btree - how to tell? how to test?

) completely unsuitable for the OLTP environment. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

Re: Media Recovery needed

='/arch'; SET AUTORECOVERY ON e) Recover the database by using the following command: RECOVER DATABASE; When you get the rely Media Recovery complete., type 'ALTER DATABASE OPEN;' and you are done. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com

Re: Media Recovery needed

On 2002.05.27 02:33 Simon Waibale wrote: Hi Mladen Gogala, Thanks for your input, I did use similar approach to your suggestion save I left everthing to oracle! 1) svrmgrl 2) connect internal 3) startup mount; 4) recover automatic database; 5) alter database open; That means

Re: Media Recovery needed

Message- Sent: Monday, May 27, 2002 2:38 AM To: Multiple recipients of list ORACLE-L On 2002.05.27 02:33 Simon Waibale wrote: Hi Mladen Gogala, Thanks for your input, I did use similar approach to your suggestion save I left everthing to oracle! 1) svrmgrl 2) connect

Re: joining word/ lines in a file

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

Re: Any Equivalent of SAR command in NT/2000

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

Re: How to grant privileges on all the tables of owner1 to owner2?

dba,sysdba to owner2; Now, owner2 will have select/insert/delete access to all tables owned by owner1. -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

Re: Where is Oracle9i Release README shipped with 9.2.0.1

, 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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL

Re: Where is Oracle9i Release README shipped with 9.2.0.1

to: [EMAIL PROTECTED] (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). -- Mladen Gogala -- Please see

Re: profile

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

Re: Patch a Patch

: 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). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City

Re: Can we find SQL user

-Mail message to: [EMAIL PROTECTED] (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). -- Mladen Gogala

Re: SQL Question

message to: [EMAIL PROTECTED] (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). -- Mladen Gogala

Re: SunOS 5.8 I/O buffer size?

the HELP command for other information (like subscribing). -- Mladen Gogala -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public

Re: procedure/function error

or is undefined ORA-06550: line 1, column 7: PL/SQL: Statement ignored pl help me in this regard thanking all of u purushottam hegde - Do you Yahoo!? Free online calendar with sync to Outlook(TM). -- Mladen Gogala Oracle DBA -- Please

Re: A new form of ORA-1555

supported with a very new feature like FBQ. The experience taught me a lesson about ora-600 and alike. I really wouldn't want to depend on a feature that is very, very new. I'd much rather use logminer instead. That's just me. Mladen Gogala Oracle DBA Phone:(203) 459-6855

Re: A new form of ORA-1555

use logminer instead. That's just me. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com

Re: skip scan index

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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L

Re: skip scan index

. I don't have the 9i instance that I can use for testing right now, but tonight, at home, I'll give you the counter example. The bottom line is that the only way to execute a skip scan with a B*Tree index is to go and read it whole. No other way. Mladen Gogala Oracle DBA Phone:(203) 459

Re: skip scan index

trace name flush_cache'; alter system flush shared_pool; Thanks! How did you come accross this little gem? -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538

Re: Parallel Query Server died

') 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: 10i

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

Re: quickest method

goldberg device. Actually, it was blazingly fast in test, I left the project before it hit production... -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] Behalf Of Mladen Gogala Sent: Thursday, May 15, 2003 12:27 AM To: Multiple recipients of list ORACLE-L

Re: Parallel Query Server died

Shuan, this sounds like a problem for support. Are you using I/O slaves? Mladen, There's only a line in the .trc file: kxfpqsrls: Timed out trying to release slave 4:1 -- resignaling Shuan -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: question about large pool

. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Monday, June 02, 2003 4:35 PM To: Multiple recipients of list ORACLE-L for some reason we have 100MB large pool. I dont think we need it at all. I read that its only

Re: Shit of the day

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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen

Re: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink o

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

Re: ??? Linux/Oracle 8.1.7 2GB file size limit ???

') 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: SYS not able to GRANT -- Strange !

: 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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City

Re: World premier performance of the BAARF party logo

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

Re: World premier performance of the BAARF party logo

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

Re: Opinions of high-volume DDL and data population

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

Re: Undo Analyze Table

not producing the desired result and it is taking ages now. is there any way to undo that? Regards, Hussain Ahmed Qadri DBA SKMCHRC -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services

JDBC and MTS

and netstat -s. The NIC is 1GB Ethernet and I would be very surprised if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala

Re: JDBC and MTS

? Yes it is. Application server is a Solaris8 box (SUN 450). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: JDBC and MTS

if approximately 100 users could kill it with a JDBC application. They could use DBA as a human sacrifice, though. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: 10046 madness

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

Re: controlfile backup obsolete

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

Re: Thanks -- RE: Scritp to Generate Create Table ??

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

Re: oracle authentication from windows

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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala

Re: RAC vs. OPS a comparison

for other information (like subscribing). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: IO Topology Anyone???

-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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network

Re: Migrating 8i OPS to RAC 9.2

segments for each instance to minimize pinging and each instance has it's own tablespace for rollback segments. There can be only one undo tablespace in 9i instance. Have you experimented with AUM and RAC? Can I have each instance look into its own undo tablespace? -- Mladen Gogala Oracle DBA

Re: SMON taking 50% of CPU and certain queries hanging

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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala

Re: Oracle on Linux

PROTECTED] (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). -- Mladen Gogala Oracle DBA -- Please see

Re: Column level security

to: [EMAIL PROTECTED] (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). -- Mladen Gogala Oracle DBA -- Please

Re: Oracle 9.2 RAC on Win2K?

, beefed up PC boxes vs. a single, 16-CPU IBM P690 with the latest 960 CPUs and AIX 5.2. You can benchmark price and performance. I'd be very intrigued to find out the outcome. It is very hard to predict it properly (wink, wink). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L

Re: Performance

. Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL PROTECTED] -Original Message- Sent: Friday, June 27, 2003 5:20 PM To: Multiple recipients of list ORACLE-L Hi list, SCENARIO LAB DB = Oracle 8.1.7.4.0 on Suse Linux 7.2 PRODUCTION DB = Oracle 8.1.7.4.0 on HP-UX B

Re: Performance

file scattered read', then it is the execution plan that is causing trouble. Try the DBA 101 red book, written by Gaja Viyadanthaya (hopefully, I didn't misspell his name), Marlene and comp. It's a book which has answers precisely to questions like yours. Mladen Gogala Oracle DBA Phone

Re: Filesystem for Linux production database server?

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). -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL

Re: Filesystem for Linux production database server?

ignored it. JFS on AIX honors it and I hoped that it does so on Linux as well. As for XFS, I must say that (and I am a former SGI user and a life-long admirer) I don't know anybody using it. -- Mladen Gogala Oracle DBA#define _GNU_SOURCE #include stdio.h #include fcntl.h #include sys/types.h

Re: Redo Copy Latch contention ??

made a huge improvement in performance. Anjo. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

  1   2   3   4   5   6   7   8   9   10   >