Re: ADMIN PLZ REPLY - FW: !!Please Read - Oracle-L moving!!

Thanks a lot, Bruce. Much appreciated. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - The list archives here will be available as long as Fat City continues to be in existence, so those of you who are searching for old topics are quite welcome to use the facilities here

Re: Oracle 8.1.7 can only use the first 15th indexes?

Let's be realistic: any table with 15 indexes PROBABLY needs a little bit of a re-design exercise? ;) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - snip (I assume the report intended to say the first 15 indexes on a specific table, 'cos the data dictionary alone has

Re: Oracle 8.1.7 can only use the first 15th indexes?

The first 15 indexes CREATED? Joking, are they? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I've just been reading a report for one of our systems and it says that Oracle 8.1.7 will only use the first 15 indexes created. Any index created after the 15th will be ignored

Has anyone done any scalability work on dbms_lock?

issues. Any ideas? TIA. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Has anyone done any scalability work on dbms_lock?

. No need to background anything. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Has anyone done any scalability work on dbms_lock?

. Much better if I can do the lot in PL/SQL. Thanks again. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Has anyone done any scalability work on dbms_lock?

by Fuerstein et al(not a real popular book, but I like it)... there is a nifty wrapper for DBMS_LOCK. I based my code off of that. Ah yes, I know the book. May not be popular, but I used it a lot a while ago and it's solid. Thanks, will look that up. Cheers Nuno Souto [EMAIL PROTECTED

Re: Re[2]: Oracle vs Mysql

, SQL*Graph does deserve a honorable mention, then there was PRO*Pascal, SQL*QMS. Very good, but never really pushed by Oracle. And I STILL pronounce Pro*Pascal as Pro*Rascal, after all the probs it gave me on demos... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

Re: Oracle vs Mysql

can't beat them, join them... :) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Excellent reasoning Nuno. I hadn't thought of that. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services

Re: Oracle vs Mysql

in favour of OpenOffice. If the reply is yes, then come back and we'll talk again. If the reply is no, ask for the reasons and use PRECISELY the same to argue in favour of Oracle. Don't even bother with MySQL. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

Re: Should we stop analyzing?

Dunno how he does it. But I'd settle for my replies from my ISP to make it here... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - How do you know they're nodding if they call you on the phone? Distinct rattling sound? :-) -- Please see the official ORACLE-L FAQ: http

Re: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES

Since when is redo log writing performance handled by DB_WRITERS or DBWR_IO_SLAVES? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Now, the Sr DBA here is screaming about the performance since I made the change, in particular, he says he's seeing high redo latch contention

Re: Should we stop analyzing?

and you can guess why the RBO IS NOT being removed from Oracle10g. . . . Bingo!... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Should we stop analyzing?

Yahwoll, mein herr! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, January 09, 2004 6:09 AM Waddya mean, propaganda sheets? We never release propaganda - everything always works the way we say

Re: Should we stop analyzing?

Thanks. Sounds SUPER! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I'd settle for a flag I could turn on and off, saying: do/do not change stats for this object. snip Available in Oracle 10g - lock stats. -- Please see the official ORACLE-L FAQ: http

Re: table reorganizations

it just shattered BTW: Hippo Birdie! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - soul, you'll see that I'm a real sweetheart. Humble and modest, too. Mirror, mirror on the wall, -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno

Re: Should we stop analyzing?

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

Re: Book (was) oaktable people

- Original Message - (And unlike my presentations, I promise that there is no profanity in the book...) You mean you gloss over BCHR? Shame on you! ;) Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET

Re: Upgrade

I'm confused: did you REALLY expect anything out of microslop to work according to expectation? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Dick, What kind of a nautical person are you??? the NT box will not even make a good anchor because the sides are flat

Re: Should we stop analyzing?

down my neck is to overload the system even more with a full analyze... But that may be just me. Best regards - and Happy New Year, To you too. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat

Re: RE: large pl/sql table sucking up all memory on a server

That works. I prefer thumb presses, they worked for the Inquisition and they lasted 500 years... dr Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I think Ill get a taser and fry the next person who does it. :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: Should we stop analyzing?

Hehehe! You rat! :D Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Or update HIVAL and DISTCNT and ROWCNT statistics using dbms_stats regularly... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat

Re: SQL CASE Statement

If you are in 8i, then it won't work. Only after 9i is the SQL and PL/SQL SQL engine the same. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Any clues on why does a CASE block does not work in an INSERT-APPEND-SELECT statement called in a sql block in an UNIX script? If I

Re: RE: large pl/sql table sucking up all memory on a server

dependent and I'm not sure which version you running. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 30, 2003 5:39 AM it filled up the pga and then used 'swap' space on the hard drive. this filled

Re: On the front page of OTN

Yes, saw that 2. SED rules! Oh Yeah! ;D Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Quite a surprise to find this on the front page of OTN http://otn.oracle.com/pub/articles/dulaney_sed.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

Re: Hit Ratio

the create? Therefore it should be very little off the buffers, no? Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Hit Ratio

¦D Unreal, eh? that's SAP for you... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Just thought I would share my hit ratio with y'all. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network

Re: Re: New TPC benchmarks

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

Re: New TPC benchmarks

Gives a whole new meaning to the expression surrogate key... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 16, 2003 7:19 PM Not just hash clusters, single-table hash clusters with user

Re: Little competition

Well, I guess it's all about self-tuning, all this parameter stuff is out of date... :) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Little competition for you all :) It's a two part question: a.. What's wrong with the following piece of expert analysis ? b

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

thinks the good old days of in-house elites are back, they're dead wrong. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Generally, the announcements are made at events like OracleWorld, through OTN and so forth that the beta program is open. Depending on the release

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

Amen... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I really do not intend to go with the flow. Fortunately, there are other databases and oracle's behavior is motivating me to start giving them serious considerations. -- Please see the official ORACLE-L FAQ: http

Re: dc_used_extents ,dc_free_extents and dc_histogram_defs

Isn't that what Oracle has always done? I've got a funny feeling it's gonna start biting back really hard... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - guys decide to put out a limited production version? Prolonging the hype would not serve any useful purpose, except may

Re: Re: RE: Re: Stop using SYS, SYSTEM?

Facetious, but correct. What you need is auditing. Not clipping userids. Achieves nothing. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - What I was saying is that having a different username for each DBA helps you identify the WHOM. Of course a hacker could always cut

Re: for years I have been using korn shell

almost exclusively until very recently. I'm now using Korn shell, even in Linux where it is not installed by default and bash seems the way to go. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat

Re: How do you genrate primary keys?

Exactly. Get a design with three or four levels of PK/FK relationships and watch the cascading everytime a mistyped natural PK needs to be edited to the correct value. It's just not practical. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - eg. if you update the natural

Re: Re[2]: How do you genrate primary keys?

Dangerous. The UPDATE is not the same as a SELECT with lock. It has a read component that won't lock and a write component that WILL lock at write time. That is not what you want. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - What about doing it in one step? Declare

Re: file sizes over 32GB

I think there was something in Metaclick about files in 32-bit OS's not being able to extend much over 32Gb, even with extensions. That's Unix flavours and 32-bit Windoze. Much larger than that and you are definitely in exclusive 64-bit territory. Cheers Nuno Souto [EMAIL PROTECTED

Re: redhat/oracle

Would you like a multiple choice answer or is it not obvious? ;) where was that copy of free QNX again?... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - so now that Linux has made it are we going to have a Linux provider melt down? with no open source/free versions left

Re: redhat/oracle

was NOT an invention of OSX, I'm afraid... :) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I keep asking my boss for a powerbookG4, but he won't bite for some reason ;). I keep telling him I need one to test the development version of Oracle on OSX. -- Please see

Re: ** other oracle forums

There are more than you can poke a stick at. One wonders... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Google is your friend. Just search for Oracle dba mailing lists and a whole slew of results are returned. -- Please see the official ORACLE-L FAQ: http

Re: What happened to Howard Rogers ?

anyone suggest Howard had been sacked? I don't recall seeing that said anywhere here. There was a troll suggesting that in c.d.o.s., but that was just that: a troll. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - is that copyright thing something unique to Australia? I dont

Re: Mauve databases use least RAM

HJR's saga still rates as one of the all-time dumbass knee-jerk reactions from Oracle damagement. And yes, I sincerely hope this message gets circulatedto as many Oracle VPs as it can. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - At the risk of opening old wounds, after

Re: Re: WHERE 1 = 1 (any info on this)

were made just for that. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: WHERE 1 = 1 (any info on this)

AFAIK, it has two origins: 1- To make editing text sql scripts easier, in terms of alignment between the predicates. 2- As a trick to enhance the WHERE clause in blocks in Forms, very old versions. Other than that never heard it made the slightest difference to the CBO. Cheers Nuno Souto [EMAIL

Re: Older IT Workers becoming a hot commodity

Don't you go giving them any ideas... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Experience? Are you certified in that? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services

Re: Can someone please verify this for me?

explicitly indicates the authid clause in the procedure (or package) creation. Without that, it's 6565. With it, all works fine. Go figure... Thanks a lot for all the help from all the replies, too many for me to thank individually. Now, to make this work with a login trigger... Cheers Nuno Souto

Re: any ever work with Use Cases to model a database?

/SQL packages, one per table or logical object. All access was through these, using object types as parameters. It works well with JDBC and is tremendously fast. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET

Re: SAME and separating disk and index tablespaces

. From other perspectives, heaps of reasons. But NOT from the performance perspective. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Can someone please verify this for me?

a ORA-6565 error: Cannot execute SET ROLE from within stored procedure Any ideas what am I missing here? 9.2.0.1, Win2K. Did the usual searches everywhere including Metaclick, nothing that I can relate to... TIA for any help. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L

Re: Can someone please verify this for me?

Nope. Tried with that one as well, same result. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Maybe you should try with DBMS_SESSION.SET_ROLE? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network

Re: Unintentional Humor

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

Re: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!

on the *nix port. All I usually do is go through the Oracle Admin for Unix manual (or words to that effect, the darn thing keeps changing name!), find out the specifics of the port I'm using and add them to oraenv. After that, everything (usually) works well. Cheers Nuno Souto [EMAIL PROTECTED

Re: Cary's book

the organization very carefully. Last thing you want is to be outsourced... Then of course, there are those of us that were allowed to keep all their Oracle shares when they left. Real estate is the way to go. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

Re: Cary's book - Rapidly moving OT....

believe the IT market will get better for DBAs, but there are other areas where the skills can be used and the future is brighter. And people who can demonstrably use their brains are always an asset. Even though not all damagers will admit to it, mostly they know it's true. Cheers Nuno Souto [EMAIL

Re: Off Topic: PC Firewall Recommendation

thrown into the bargain. And it survives the grc.com test. Add an anonymous proxie for your browsing and you're as safe as you can get. Except for e-maul. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL

Re: Big table, small table

- Original Message - Why would taking an index off make this query faster? What doesn't the CBO know that not using an index is the best path? The physical sequence of the rows in the smaller table vis-a-vis the range you're querying on. Cheers Nuno Souto [EMAIL PROTECTED

Re: Solaris /etc/system values for Oracle8i

Precisely! Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, September 28, 2003 12:54 AM What the heck was that? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: Offshore protests

suggesting we outsource driving taxis or milking cows to Mars via Internet, I'll spew!... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Hiding passwords

for some details. Use alternate data streams. Careful: this is used by some virus writers!!! Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: What is a large database?

what does being a DBA in this country mean... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: What is a large database?

spelled properly? Or am I being singled out for any particular reason? /minor rant Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

Re: What is a large database?

you should send them over to Australia. At least they'd be better than the standard of dba we get here... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - In Estonian language, the word administrator also means receptionist. Guess how many former hotel receptionists

Re: offshoring article

of telling people that water runs downhill, McKinsey are among the very best. guess where Louis Gerstner worked before IBM and Nabisco. Jobs for the boys?... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL

Re: Oracle Masters exam

, then something will happen. Thats how a market driven economy works. Exactly. Another certification will crop up. And another. In the meantime, the shareholder value is eroded. Since no one in his right mind will want any part of a company that can't get it right. Cheers Nuno Souto [EMAIL PROTECTED

Re: Oracle Masters exam

OCP where you get the certification when you spew out certain amount of the green stuff? I wonder how long will it take before seeing oracle masters who don't know how to take a hot backup. They'll be able to take a hot backup, rest assured. With milk and two sugars, please. Cheers Nuno Souto

Re: Offshore threat

7 years ago, folks: change. Now. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Re: Application DBA

wish it was the same here Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: Offshore threat

Well, you could find a job in Canada, no? Can you find one in India too? I don't think so. So it's not business as usual. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - When working at International Air Transport Association (IATA), the company moved around 60 jobs from Geneva

Re: Offshore threat

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

Re: Offshore threat

with that! This is what these idiots get for outsourcing to irresponsible outsourcers. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Re: Application DBA

again. It's all a sham. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web

Re: Offshore threat

LOL! Funny how this globalisation bull only works in one direction, eh? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - ** Another programmer who lost his job to an Indian outsourcer is willing to relocate in India. But Indian officials have told him they don't hire

Re: Application DBA

- Original Message - Usually, the term used is devlopment DBA. sniperoo http://www.dep.state.pa.us/dep/deputate/oit/SDM/inHTML/HtmlFiles/SDM/StyleGu ide/SECURITYANDACCESSPOLICY.htm and some will insist they be OCPs... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see

Re: Guild of DBAs

- Original Message - asked to hold on the TAR call for a dozen ORA-600 errors? Or negotiating with a bunch of developers for using bind variable? Oh, can I bring the blunt implement? Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net

Re: Re: OT - Linux books ??

Apart form all the others you've already heard about, Fujitsu and some of their subsidiaries also have their own Unix flavour. I believe Unisys and NCR also have their own. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

Re: Re: Nature of Oracle-l has changed

Hey, all you gotta do is tell them 5 years. Like, it makes a difference to what they know of it? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, August 27, 2003 9:59 PM in the technical business. Who

Re: Hey Jared!!

with the virus, it was a spoof as well. He was on hols at the time. Just checked. Probably some1 infected who had his and oracle-l's addies in their adress book. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL

Re: Hey Jared

Darn bleeding users Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Windows would be a wonderful OS, if people would just quit installing applications. Solitaire runs. ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET

Re: Re: OT - Linux books ??

will be very much the same in principle, but located in different directory structures, used with different utilities, and have slightly different parameters. Welcome to the joys of Unix incompatibility with itself. No wonder people are going Linux. Oh! Hang-on a tick... Cheers Nuno Souto [EMAIL PROTECTED

Re: OEM

S. Don't say that in front of any of the Oracle boffins... It's like a religion. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 25, 2003 4:29 AM Piece of junk. I'll stick with the scripts

Re: Row level security and latch waits - LONG email...

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

Re: Row level security and latch waits - LONG email...

a reference to a context variable, which is what Tom is talking about, it might well be the case this will act as a kind of bind variable even though the syntax is not the correct one. Anyone found if that is the case? Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ

Re: Re: Row level security and latch waits

Interesting. I didn't get Connor's reply... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, August 21, 2003 1:49 AM so in 9i dbms_rls increases the soft parses? From: Connor McDonald [EMAIL

Re: Re: Row level security and latch waits

which is appended as a predicate. It certainly is not explained anywhere in the manual how to do it and I couldn't find anything in the literature and asktom either. Appreciate if anyone can explain how. A dynamically generated string is not the same as a bind variable. Cheers Nuno Souto [EMAIL

Re: Is there any certification for Systems Analyst/Designer ?

Unfortunately not anymore. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Is there any certification for Systems Analyst/Designer ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno

Re: Is there any certification for Systems Analyst/Designer ?

you got a point there... Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I would have said fortunately ... ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: More On 10G

no please! Do NOT light a match Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - Sure smells like an IBM SP2 environment to mesomeone light a match or open a windowplease -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto

Re: Question on views

- Original Message - 'view' crafted for that detection is going 'stale'. sounds fishy to me... getting a smoke screen as I suspect? Bingo! Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL

Re: It's an Oracle Fun Friday!

now, ther's a thought to ruin my whole weekend... Thanks, Paula... :D Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, August 09, 2003 2:34 AM or Stephen - something even worse -- Please see

Re: OT -- Boston Globe job listings

IMHO, that's not your 2 cents: it's worth a *lot* more. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - My 2 cents: why not outsource CEOs too? That would REALLY save big $. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL

Re: sar

That's weird. I'm not aware of any security issues relating to sar and its use. Sounds like paranoia mode just because the thing might have the setuid bit on. Which means nothing as far as security goes, unless sar allows interactive command shells. Which it doesn't. Cheers Nuno Souto [EMAIL

Re: Union quries: INTERSECT, MINUS, etc

that implements flight legs. So don't go around saying it isn't used: I need it or the RAAF can't book people to flights. ;) Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858

Re: Re: Union quries: INTERSECT, MINUS, etc

- Original Message - what do you mean by 'arc'? have a look: http://www.docm.mmu.ac.uk/online/SAD/T07/erd2.htm much better explanation than I can give here. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto

Re: imp table data, but not PK indexes?

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

Re: imp table data, but not PK indexes?

and takes no time at all). The next one is with CONSTRAINTS=N, ROWS=Y, INDEXES=N, DIRECT=Y. This one is used for bulk data load. With these two exports, one can do just about any manipulation needed. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

Re: Recent reports on outages caused by DB2 and 9iRAC issues

- Original Message - I'm all for summary executions due to the latter... :-) How nice. Fortunately, SAC doesn't much listen to your ideas... Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL

Re:

- Original Message - help aren't you beyond help? :D Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Re: Object Types in PL/SQL

of hierarchical object. After that, it's XML all the way through! If the customer doesn't kick us all out b4... ;) Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services

Re: Object Types in PL/SQL

interaction. Not a pure OO implementation, but then again I don't need one: just a way to get the work done efficiently. Plus the object-relational views are quite nice to return object hierarchies (in 9i...). Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http

  1   2   >