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. It won't be going away. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 rather more than 15 indexes). -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 unless specified via a hint. Is this correct? I haven't heard of this before. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Has anyone done any scalability work on dbms_lock?
As in: does it present an inherent or hidden performance problem when a lot of sessions try to lock/release the same lock? Or how many lock/release per second. Or some other idea of how efficient it is? Need to use it in a design, but not sure of any potential performance hits or scalability 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 hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Has anyone done any scalability work on dbms_lock?
- Original Message - Or how many lock/release per second. Or some other idea of how efficient it is? Depends on the work done between acquiring the lock and releasing it. Not really. I'm asking how many lock/releases can be done before the thing starts putting a serious load on the system. And if the load it imposes is linear. When sessions acquire the same lock (as asked), only one session can do the work in a given moment. So, it doesn't scale. There will be overhead, but that also is relative to the duration of the work done while the lock is held. So, the overhead is MOL linear? Ie, if the amount of work is very small and the number of requests is very high, nothing is gonna suddenly go South? Maybe AQ can help, by doing the work asynchronously in the background and so lift the serialization from the primary proces(ses)? The work is very small indeed. 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 and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Has anyone done any scalability work on dbms_lock?
- Original Message - On a light-weight test on 8.1.7.4 at 700MHz on W2000 - About 15,000 request/release per second if you are using an ID sounds plenty good to me. Thanks a lot. Bear in mind that each request or release will hit the enqueue latch a couple of times, so you could get contention for the latch in the two high-speed options. OK. Will look out for these just in case. Bottom line - for high-speed OLTP type of work, I don't think you will get away with more than a dozen request/release cycles per transaction. Not a worry, it's a workflow app. A few users but not much load, a little volume. I just need to make sure a given sequence of operations is not undertaken by more than one user per group (one lock/group) and a table lock is way too heavy to do this. Forms 9i, so it's not easy to fudge it with a C exit and I don't like servlets. 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Has anyone done any scalability work on dbms_lock?
- Original Message - nuno-- what level are you trying to scale it to? Not much. A few hundred users, maybe 20 or so may need the lock. However, this app may explode in # users, so I want to make sure I'm not creating a monster. how long will you hold the locks? only long enough to pass a key to a servlet. I used it last year because only one process could run at a time. That's what I want, one process per lock. seemed to have similiar over head to 'select for update'. That's weird? I thought it didn't involve table access? If you look at the PL/SQL Packages book 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] -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Re[2]: Oracle vs Mysql
- Original Message - Jonathan, I've been around for a long time. I've seen things like DataLens for Lotus123, SQL*Calc, Easy*SQL, then there was an Oracle Beat ya: Oracle Add-In for Lotus 123. Using Ora*Net (Async), V4.1.4. 1987. And demoed to the press that same year. g,dr (which BTW was classified by a local expert journo - a la Celko - as a ho-hum technology. Then a few years later M$ delivered ODBC and this same journo called it the way of the future! One wonders) version of then popular DB2 tool, which looked like an IBM 3874 terminal on top of VT320, 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://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 - To REMOVE yourself from this mailing list, send an E-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).
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-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Oracle vs Mysql
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 15, 2004 4:04 AM Hi, I've been asked by management to explore the pros and cons of Mysql vs Oracle. The database in question will be a web based text and multimedia retrieval system. The size will be around 100 Gb. Can someone let me know the advantages of Oracle over Mysql or the problems we can face using Mysql for example support issues or availability/performance issues. Thanks in advance Mujeeb Ask your damagement if they are ready to give up on Microslop Office 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://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 - To REMOVE yourself from this mailing list, send an E-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).
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://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 - To REMOVE yourself from this mailing list, send an E-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).
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 and redo log buffer waits which he says validates his contention that we need to get back to using DBWR_IO_SLAVES. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Should we stop analyzing?
- Original Message - Wouldn't it be nice if dbms_stats could do an incremental refresh, tracking ONLY stats changes that might make a difference to execution plan: I'd settle for a flag I could turn on and off, saying: do/do not change stats for this object. I know which of them need to be analyzed and which don't. Better than Oracle will ever, deltas or no deltas, workload managers or not. a) Allow for dbms_stats to collect, store and compare changes to historical execution plans, using historical SQL from STATSPACK (or new 10g workload views) Sadly, this workload feature of 10g if I know anything about how Oracle works, will evolve into another monster elephant gun. Completely forgetting the problem out there is in most cases mosquito-size and can be addressed with a simple fly-swat. Yes, there is such a thing as over-engineering a solution. This will be one of them. And like anything that is over-engineered, it will be buggy - sorry Pete, feature-reluctant. Or perheaps document-challenged? And it will create a bad name for itself while the developers evolve it until Oracle 12r2... b) Allow the DBA control about whether to implement the new statistics That, sadly, is totally outside of Oracle's plans for the traditional production DBA role in future. It would cost these clients many thousands of dollars to have adjusted these plans, and management says If it ain't broke, why fix it. My problem too. Try and convince a damager that something that is working fine should have thousands of buckeroos spent on it to become compatible with new CBO! Like Heck it's gonna happen... Cripes, I know quite a few sites here that are STILL running Prime computers with Prime Information (for those who don't know, look-up Pick in google), 13 years after the company vanished! And no plans whatsoever to update. Why? Heck, it WORKS! Talk about TCO, eh? Oracle made a big-deal about going to the CBO in 11i, yet when we look at the SQL, a significant number of statement employ the rule hint! Connect-the-dots 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://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 it does! :) -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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://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 - To REMOVE yourself from this mailing list, send an E-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).
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 Souto 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 from this mailing list, send an E-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).
Re: Should we stop analyzing?
- Original Message - The issue here is that very few people understand how the CBO works, or what the statistics do, or how to use them properly. And a seriously *big* component of that problem is that Oracle keeps changing/patching/modifying the CBO and how it reacts to certain combinations of information, on EVERY SINGLE point version! It's virtually impossible for a typical DBA to find the time to fully test all the combinations and find out what works where and how. Hence why this type of thread becomes so useful. Do they clone the production database, change the statistics, prove that the system can complete it's batch job in 8 hours, then install ? I doubt it. Exactly my point above. Not feasible. So, what's the alternative given that: 1- the information in Oracle's own doco is far from complete or covering all bases? 2- the CBO like any other piece of code, is sometimes buggy? 3- You, Don, SA, and so many others who have the time to investigate this may in turn not have the time to produce the detailed doco that is needed to understand how the CBO works in all situations? Is dynamic sampling the solution? I don't think so: if anything, it will enhance/increase the problems caused by 1 and 2. approach, while the 10g developers are pissed that the CBO has been getting a bum-rap because of crappy statistics. coughitwouldhavehelpediftheyhadfixedthecodebackin7/8/9insteadofdelivering 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 hosting services - To REMOVE yourself from this mailing list, send an E-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).
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: [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 from this mailing list, send an E-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).
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 and it will drag on the bottom during a small wind or current. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Should we stop analyzing?
- Original Message - I'd like to start a debate, which perhaps has already taken place, but if so I don't recall it: Should we stop analyzing tables and indexes? As a regular thing, yes. Unless there is a clear case for doing it often: highly variable tables. And even then, I want to know WHEN to analyze: when they are empty or when they are full? Looking back, I can recall several places where they analyzed every weekend, and on Monday the system could very well behave differently. and usually for the worse. I recall a particular PS site where every time we analyzed, we got into trouble... That was with 8.0 and there was nothing we could do other than stop analyzing. Which we did and the problems went away (on that particular table). Makes sense if the optimizer has some new/different information to consider. Yeah, but the $64K question is: HOW do you know that the optimizer has something different to consider? There is nothing (other than seat-of-the-pants feeling or prior knowledge of behaviour of app) that will tell you that. On the other hand, it feels so intuitively right to constantly have up-to-date stats, doesn't it? No, not at all. I'm really against this tune-every-minute approach. From my point of view, I want to get the darn thing running OK and then LOCK IT IN so it doesn't blow in my face unexpectedly. I'll gladly trade the last 10% of performance I might (and I stress the might) get for a system that behaves reasonably well and STAYS that way all the time! Makes for quiet nights, full of sleep. And at my age I like those more and more... I'd like to know what practical and philosofical ideas you guys have on this topic. Well, my approach has always been: get the thing to perform within 10-20% of optimal and lock it in so it won't suddenly go South. It's much more important for me not to spring surprises on users than to give them a system that's only tuned optimally for 5 minutes before I next run the stats. And the last thing I want when all hell breaks loose and I've got the site manager breathing 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 City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 replace the case block with a decode function then it works Whereas in a sql command prompt, both DECODE and CASE yields results. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: RE: large pl/sql table sucking up all memory on a server
This is probably old hat for you, but given it's Unix (Sun) and it's a client process, wouldn't you be able to use ulimit to stop memory allocation growing past a certain size? The other thing I'd try is to limit memory through the resource control in Oracle. But that is highly version 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 up. didnt realize this was a feature. yeah, I know i can 'tell' them to do it. I was hoping to disallow it though. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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: 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Hit Ratio
- Original Message - Actually, it isn't SAP. I was simply creating a set of MV's based on SAP tables in another database. Fair enough. I wonder what I need to tune to fix this? stop creating those tables? D Seriously: aren't you getting the I/O as mostly writes during 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Re: New TPC benchmarks
- Original Message - I beg to differ. When I ask for 2 external storage units of 14 drives apiece (DAS), and they look at me like I obviously have no clue about their intentions of a 3 drive RAID something other than 10 config, a configuration that they can download just by showing them a link to there is a HUGE difference in terms of reality when we talk about a system with 2240 disk spindles and one of 2 external storage units of 14 drives each. Not even remotely related... In fact, in most places I go to if I show them the numbers in that link, they'll just ignore me and go buy whatever crap the IBM sales rep is flogging that week! Now, of course these documents are useful to find out what sorts of tricks they do re services in Windoze and so on. I've found those other ways. In fact, they are documented in M$'s Tech Notes. But yes, the docs above are also 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 - To REMOVE yourself from this mailing list, send an E-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).
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-defined, and very carefully designed hash key. Not something you can usually get away with in a dynamic table of 19 billion rows. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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.. Which well know Oracle Guru published this (and continues to display it on his web-page) ? -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: dc_used_extents ,dc_free_extents and dc_histogram_defs
The interesting fact of course is that the beta program of 10g was announced in newsgroups AFTER it had closed for all intents and purposes to the general public... And quite frankly, Oracle could do a LOT WORSE than let customers like Mogens definitely join. Just a feeling, mind you. If Oracle 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, the program may not even get announced unless it's big enough. IIRC, the beta program for 9.2 was open to only a small number of customers and wasn't announced to the world at large, whereas the 10g program was announced (again IIRC - it's 4 am for me and I haven't had my first coffee yet!) at OracleWorld in San Fran in September? Of course, there are some companies that are almost always invited to join the beta program for the database because of the type of customer they are and the type of work they do - customers like Amazon, for example, may fall into that category. Customers like Mogens definitely don't. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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://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 - To REMOVE yourself from this mailing list, send an E-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).
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 be, to further annoy your customers. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 knock the DBA unconscious and prop up his head to fool an eye retina scan, à la James Bond, but by that argument any username or IP address or whatever else you use is meaningless. -- -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: for years I have been using korn shell
- Original Message - -What is everyone else using out there? -Do you think I should make an issue of this one? Paula, that mob is having you on. If they know even the most basics of Unix shell scripting, they should be using the comment convention as the first line of any of their scripts. As in: #!/bin/csh to make their code run in the C-shell NO MATTER what your shell might be. If they don't do that and expect you to use their shell, get on to them quick and as heavy as you can. That's just unacceptable in this day and age. I used the bourne shell for scripting 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 City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 key in the parent, you must also update the natural key everywhere it appears as an fk. This gets really ugly when you think about making modifications to the schema. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 lCounter int; Begin UPDATE counter_table SET counter := counter+1 WHERE counter_name = 'table name' RETURNING counter INTO lCounter; End; -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 08, 2003 12:30 AM One of the guys here did some research and found that files over 32GB can cause data dictionary corruption. anyone have problems with this? we are using an automated transportable tablespace process with alot of logic and between many instances and servers. we would prefer not to complicate the logic by having to introduce additional tablespaces to transport(cant do multiple datafiles in one tablespace because the datafiles need to be atomic to be transported). so anyone use datafiles larger than 32GBs. What happened? I know most of you dont, but we are in a unique situation. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 from this mailing list, send an E-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). -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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? -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: redhat/oracle
Akshally, it's a pity Oracle stopped support for Apple's Unix. My 7.0 version for Apple's A/UX was one of the most stable and solid ports I ever played with. If anything, OSX is even more solid and better performing than A/UX ever was. Oh yes, the Finder desktop running inside Unix 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 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 - To REMOVE yourself from this mailing list, send an E-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).
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://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 - To REMOVE yourself from this mailing list, send an E-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).
Re: What happened to Howard Rogers ?
It's not unique to Australia and yes, they make you sign a piece of paper to say anything you do between 9am and 5pm belongs to the company... Not just Oracle, BTW. Everyone does that. I wonder what that would do to those who claim one consulting gig = one book... Oh, while I'm here: did 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 think they can claim that in the US unless you sign some documents first. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, October 25, 2003 4:39 PM Howard's response is below. Hopefully this makes things clearer for those who are still interested. I worked for Oracle for 4 years, producing my own stuff in my own time, to elaborate on questions that perplexed me, and about which I would often get asked by Oracle course students -because the official material either didn't cover it, covered it badly, or just plain mis-informed. Oracle claimed copyright on the lot, so I had to remove the material (Lydian Third is a site which copied the lot first, and despite repeated requests still hasn't removed it). In June this year, I asked for permission to have a website again, offering to have all material and content vetted by anyone Oracle cared to choose for the job, before it went up. They refused. I also asked for permission to stay at home when I wasn't training, so that I could do research on Oracle matters. They refused that too. In August, I therefore resigned. I finished work *for* Oracle on October 6th. I had two weeks of leisure, and now I contract back to Oracle, teaching much as before. Only this time, I get to write my own material, and when I'm not training, I can stay at home and do real research. I was never sacked by Oracle. Regards HJR -- -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 what happened with Howard Rogers, I think it's a brave Oracle employee who participates in extra-curricular activities that involve the products of their employer. We are richer for it when it happens (thanks Pete, Vladimir), but I don't blame anyone at Oracle for their discretion. (And yes, I can give you a dissertation on how the work-for-hire doctrine under Australian copyright and employment law works. Whether or not this leads you to form the same abuse of process conclusions against Oracle as I did, is entirely a matter for the reader :-) ). -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Re: WHERE 1 = 1 (any info on this)
- Original Message - im assuming this is an old 'trick' from RBO days. Alot of these are still floating around. Wasnt there one when you wanted to force a full table scan you would go where num_field = 1 + 0; the + 0 forced the full table scan? I was on a project earlier this year and one guy told people to use it. Actually, that one is still valid. Along with using any function around a predicate column. In general, an expression instead of the column name in a predicate will force ignoring of any conventional indexes on that column. Of course, function-based indexes 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 hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 PROTECTED] - Original Message - the 1=1 is in there to avoid doing repetitive index scans for single rowids, when the app knows the result set is going to be manipulated rowid's for a large subset of the table. I would guess your DUAL/CBO example had some similar effect. Is anyone familiar enough with this tweak to explain it ? -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Can someone please verify this for me?
- Original Message - I haven't tried using these before, but I do notice that your 'create role' syntax appears to be incorrect for this usage. Sorry for the late reply, folks. Rugby World Cup got in the way... :D Yeah, found out what the problem was after all. I assumed that authid definer was redundant (which was the case I was trying to get to work), so I left it out of the statement. That caused the 6565 error. Once I put authid current_user or authid definer back in the statement, all was well. It appears that a SET ROLE only works in a procedure, IF one 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 [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 - To REMOVE yourself from this mailing list, send an E-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).
Re: any ever work with Use Cases to model a database?
- Original Message - What experiences have you had? If not what kind of requirements documents do you use? Im particularly interested in people who have worked on projects with relational back ends and object oriented front ends. It seems very difficult to get these two models to work together cohesively. We used RUP and URL models as well as their use cases. Worked quite well. Once the BAs finished their URL object model and use case models, it was a matter basically of the lead Java designer and the lead Oracle designer getting together and hacking out a preliminary logical data model into Designer. Then the Oracle guys went away for a few days to hack out the final design, which then got reviewed by the Java designers to make sure it did everything they expected. Then it was on to the usual entity-table antics of Designer... All the db interface was handled by PL/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: [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 from this mailing list, send an E-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).
Re: SAME and separating disk and index tablespaces
- Original Message - the striped array. However, this does not improve access time. If you have your tables and indexes on the same striped array, necessarily the two I/O's have to be done sequentially, incurring two times access time at a minimum. However, if you separate the two into different arrays, then you can access them in parallel, starting to get data from each disk array in 1* access time. YOU can do that. But Oracle doesn't. Strictly: first indexes, then data pointed to by those indexes. So, no point from the performance perspective in separating. 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://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Can someone please verify this for me?
I have a problem with the new procedure based roles, Secure Application Roles. The following is taken from an example in ASKTOM. Basically, I'm trying to setup a role that is enabled or not by a procedure. The original code from Tom: [EMAIL PROTECTED] l 1 create or replace procedure turn_on_role 2 authid current_user 3 as 4 begin 5 execute immediate 'set role new_role identified by password'; 6* end; [EMAIL PROTECTED] create role new_role identified by password; Role created. [EMAIL PROTECTED] set role none; Role set. [EMAIL PROTECTED] select * from session_roles; no rows selected [EMAIL PROTECTED] set role new_role; set role new_role * ERROR at line 1: ORA-01979: missing or invalid password for role 'NEW_ROLE' [EMAIL PROTECTED] exec turn_on_role; PL/SQL procedure successfully completed. [EMAIL PROTECTED] select * from session_roles; ROLE -- NEW_ROLE [EMAIL PROTECTED] Now, if I try this using what I need: 1 create or replace procedure turn_on_role 2 authid current_user 3 as 4 begin 5 execute immediate 'set role new_role'; 6* end; and then try to run it: exec turn_on_role; I get 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 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 - To REMOVE yourself from this mailing list, send an E-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).
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 Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Unintentional Humor
- Original Message - Doing a google search on some Oracle stuff, I found the following page. http://www.dba-oracle.com/bp/bp_book6_utils.htm Scroll down a bit? Do you see the funny part? Hehehe! The ones I didn't know about are the ones ending in capital O... :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, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: STUPID LD_LIBRARY_PATHING!!@@@!@!@!@!
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, October 07, 2003 6:24 AM You have listed the reasons why many folks don't use the supplied oraenv scripts. It has long been necessary to modify the dbshut and dbstart scripts as well, if you use them, as they have in the past not worked so well. Been awhile since I've even used them, so they may have improved while I wasn't looking. They do work fine in most ports now, Jared. Having said that, LD_LIB* is not usually set at all. They also have different names depending 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] -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Cary's book
- Original Message - education and my life in general. No, until there aren't more jobs, I'll keep on the safe side. That's the part where crisis and CYA methodology jump in. I have no solution, but, unfortunately, I don't have Christ-like qualities that are asked from me in every new performance tuning book. And the blonde down the isle is so attractive. Well, at least she'll never accuse you of having an on-going issue... :) Yes, unfortunately those of us who have had the courage and accepted the responsibility of bringing children to the world have to sometimes take the bad with the good. For the sake of getting those kids out the door with a good education. Worse yet if we also have to support mums and dads way past the age where they can take care of themselves. Much worse yet if they are on the other side of the world. It's all part of that thing they call responsibility. Doesn't mean we cannot speak up. But it has to be done in a slightly different way. The art is in learning how far you can push. And where. And when. It's hard, but a few hard knocks are the best lesson. Has the role of DBA changed? Hell yeah! I've been claiming that for years, and why. But few have listened to the warning signs. Now, it's hit with a thud. Wake up call time. I agree with Robert: move to a place where you can be effective. Or change the world. Now, those of us with kids cannot afford to change the world. And even without kids, at 50 is not my idea of fun to form a union. Way past that. So, moving is the option. And all that comes with it like you pointed out: learning the ropes in the new organization. It ain't easy. Been there done that for the last 3 years. Much better now, but it was a shock. One hint: pick 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://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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Cary's book - Rapidly moving OT....
- Original Message - Ooops, did I send private instead of public? Apologies if so. It's late here and I'm half asleep already. Just waiting for the flu pills to kick in. in fact... Anyone have more than 5?? 3 here. Only 2 now. Also, I'm rapidly becomming a single parent, as my wife and I are divorcing after 15 years of mariage and I'm taking custody of the kids. That sucks. Sorry to hear it's come to that. It's a heavy burden. At any rate, I do choose my battles that is a lesson I learned long ago. You choose what is important to battle and what to leave behind. I used to take up every gauntlet thrown at my feet, problem was that I'd have so many battles going on that I'd loose them all Now, I pick and choose the important ones. Yup. Very good advice. I'd only add: learning what is important is an on-going exercise. It takes a while when we've been used to the years past. When all that was needed was shake the tree. Not that easy now. But DBAs are renowned for being able to use their brains. That's where things can get better. Our future is unknown, and always born in pain, C'mon, not always *that* pessimistic. I don't 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 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Off Topic: PC Firewall Recommendation
- Original Message - I don't need to test my vulnerabilities. I know my vulnerabilities are working well. Hehehe! As we'd say in my local newsgroup: Check yuor settings! I second that https://grc.com website. It is a great resource for testing your vulnerabilities! Too true. But the best solution by far if you have a high speed cable or ADSL connection is to get hold of one of those Netgear or Dlink firewall/router boxes. Not only do you get peace of mind that works with ANY box connected to it (be it Windoze or Lunix), but you also get a hub and shared connect 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 PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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] -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 PROTECTED] Sent: Saturday, September 27, 2003 2:54 AM If you are using Solaris with 2GB of memory, it will be awfully difficult, if not impossible, to run 6 instances of Oracle8i simultaneously. Basically, because of the use of semaphores and the way Solaris manages memory, I would say you could run 3 or 4 instances , depending on their size. But to have all six up and running, especially if you have to create them, will not work. Oracle usually needs 1 GB per instance while you are creating a database. While running it, you would not necessarily need that much. I advice you to upgrade the memory on the server to 8 GB. I suggest you budget 1 GB per Oracle instance. RWB Reginald W. Bailey IBM Global Services - ETS SW GDSD - Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager) [EMAIL PROTECTED] [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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Offshore protests
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Hyderabad. USS Enterprise will have to be renamed to USS Utar Pradesh, with captain Sanjay and Mr. Spock at the helm. I can definitely see a value there. 'sOK. But I swear the first time I see anyone 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://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Hiding passwords
- Original Message - In Windows2000 you can encrypt a file... Not sure how well that would work though, since if you install your software as local administrator (not good practice) then anyone else who logs in as administrator would be able to see / run the file too... Here is a little known trick of NTFS file systems. It's called data streams. D:\del file.txt D:\echo Some stuff file.txt D:\echo and its password file.txt:pwd D:\dir Volume in drive D is OS Volume Serial Number is A4BA-68F3 Directory of D:\ 24/09/2003 11:19p 13 file.txt (note the file size!) D:\type file.txt Some stuff D:\type file.txt:pwd The filename, directory name, or volume label syntax is incorrect. D:\more file.txt:pwd and its password D:\ I'm sure there are some interesting uses to be explored here to hide Oracle passwords! ;) Note: the hidden data stream name can be ANY filename string and is subject to security. This was used initially in NTFS to support the Mac resource fork file format in file servers. It is still there and won't go away any time soon as IIS uses it. MS Knowledge base article 105763 discusses this in detail. You can also search google 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://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: What is a large database?
- Original Message - Do you really think the standard of database administrators in Australia is low? What is it that you are expecting? When projects sponsored and supported by such large companies as IBM and Oracle get 27 DBAs and 30 developers, one has to start asking EXACTLY 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-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: What is a large database?
- Original Message - Surpising enough the write cache on the disk array was set to 0 and 100% for the read cache on this particular RAID 5 system which does lots of small writes for the application making things even worse. Hehehe! Can never win, eh? :) The DBA also sugested but the BCHR is 99.7% which means that blah , blah , blah and in Oracle terms performance is very good. Ah yes, the ratios! How much longer is that one gonna linger... Another thing that came up in my furious conversation with them was but the disks has enough capacity blah blah blah, why do we need additional disks. but, isn't a 256Gb disk faster than an 80Gb disk anyway? It's what the hardware vendor told me! No offense to any Oracle DBA in Australia as we all know there are some excellent DBA's here like Connor, Steve, Mark Gurry, Guy Harrison, Nuno Sunto, Howard Rogers, etc, etc I dunno about the others and I certainly don't consider myself excellent. But I suspect most will agree with me: given the poor standard of DBAs in Australia, I'd rather not be associated with that title, thank you very much. minor rant Is it too much to ask to have my name 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 San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 or whatever security desk operators I've had to turn down in past when they've looked for DBA job. Oh, yes, some of them had over 20 years administrator experience in large organizations, also lots of experience with 24x7 operations etc ;) -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: offshoring article
- Original Message - They're hired by the people who came out of those very same universities. Most often McKinsey et al are hired to OK decisions that management have a hard time OK'ing themselves for various reasons. To be fair, of all the consulting companies that make money out 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 PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Oracle Masters exam
- Original Message - dollar cost of that. I remind you folks that Oracle is a for profit venture. It's not Oracle's responsibility to make anything affordable. It's the responsibility of Oracle to generate revenue, it is the expectation of Oracle shareholders (of which I am one) that Oracle will do such a thing. I don't care if Larry is the 6th richest guy in the universe, so what? Why does that compel him to give you anything? I'm a shareholder too and I expect its value to go up. If Oracle has a predatory attitude and a bad image in the market, their long term future and value for me as a shareholder is damaged. I don't give a rat's arse about initiatives that deal with short term profit grabbing, if I know they'll damage the company (and my share value) in the long term. It's got nothing to do with Oracle being a charity or not. It's got EVERYTHING to do with their shares RETAINING their value in the long term. Which I as a shareholder demand. I'm not interested in bubbles. It's all pure market driven. If people stop signing up for classes or OCP exams, Oracle will in quick fashion figure out why and change things. They have: they created the masters. MOTS. If people keep signing up for classes and taking the OCP, then viola, no. voila. viola is a musical instrument. they have hit the sweet spot and will generate some revenue too. Exactly how big is that revenue and how much of it goes to third party organisations instead of Oracle shareholders is what I want to know. Socialism doesn't work folks, let's face it. What's share value got to do with socialism? If the OCP Masters credentials are worth the money, then spend it. If they are not, don't spend it. If enough people don't spend the money, 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] -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Oracle Masters exam
- Original Message - It's too bad. It seems like it would be fun. What for? Make the employer shell out another BIG bunch of notes? To get a piece of paper that says on that date and with that hardware one could perform a backup and a restore? What does that say about the ability to lead a group of developers, or design the strategy for database access or solve a really nasty performance problem without forcing re-development or re-tooling? Or any of a million other tasks truly knowledgeable people get asked to perform? No wonder TK doesn't want to talk about it: it's laughable, and he prides himself in being a serious expert. The single fact the masters was created is the perfect admission at long last the OCP was nothing but a sham. Everyone knows it, some just insist on continuing the good old PC stuff (go with the flow, let it ride, etc). It is the simple truth: its value as a certification was and always will be nill. That the masters is being sold as the new be-all-end-all is even more demeaning. 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 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 [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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Offshore threat
- Original Message - It doesn't work in only one direction. While jobs are bieng lost to cheaper labor markets, Indian companies now have to compete with frighteningly efficient giants like Nike, Coca Cola, IBM, Microsoft, GM, Union Carbide and others. On IT? I thought we were talking about that? even with all our PHB's and damagement. How messed up is everybody else? The You do NOT want to know, believe me... non-aggressive gentleman from India. Lawyers do need a killer instinct, DBAs do Well, one of my colleagues likes to call me the bad cop. He calls himself the worse cop. He reckons we do the act to perfection! ;) On the other hand: the BAs that work with me quietly leave the room when I'm in one of my low-sugar days. Let's just say you're not the only big fella: I'm well over 200 myself and most of it is the stuff that can slam a golf ball 300 yards away... :D But anyways, I'm not just a DBA anymore and that's what I wanted to talk about. Here is our chance. Hmmm, all serious now. It's been obvious for years that being just a DBA doesn't cut it any longer. The traditional day-to-day operation of the VAST majority of databases does NOT warrant full employment of a DBA. Note: I am NOT saying that a super-DBA isn't needed. I'm saying that the vast majority of sites does NOT need one. Which leaves a VERY small market for supers or masters. Now, markets being what they are and the fact that Indians are a lot more than others except Chinese, dictates that for the vast majority of sites out there a junior DBA qualification is MORE than enough. Or even an outsourced one. (there is NOTHING demeaning to Indians or Chinese in what I just said. So please, spare me the usual offended Surat or Wong crap. I work with Chinese and Indians and every single one of them knows EXACTLY what I think about this and no one is offended by it: on the contrary. Glad we cleared that. Let's move on.) And it has NOTHING to do with the version of Oracle or how automatic it is, as much as it may pain Larry and his upgrade cycles. You can make V7.3 as reliable and not needing maintenance as you will 10g and there is nothing Larry can do about that. It all depends on what the system is and what the requirements are. I know of a Peoplesoft HR site that has been running a 7.3 server on NT4 for 8 years without missing a beat. Anyone wants to discuss value for money in this case? What I suggest to other DBAs here is based on my own experience in bridging the gap to do other things. Two simple key words: spread out. One strategy: capitalise on your strengths. Don't waste too long learning the intricacies of all those X$ views: you are NOT Steve Adams nor do you have his motivations and conditions. And your employer doesn't give a royal freakin damn if X$* are performance monitoring views or porn monitoring views. By all means learn about their existence. And read about them. But STOP RIGHT THERE. Besides if you are truly going to take any advantage of all that jazz, you'll need access to the application code itself. So you can re-design certain aspects and make them behave properly. Don't fool yourself: just exactly how many times have you succeeded in doing that with SAP OR JDE OR Peoplesoft? Or even that small third party J2EE crap that eats up CPU at a rate that makes Microsoft blush? See what I mean? It helps if your employer is a software house, but they are a MINORITY. Forget it. Of course we all like to argue and talk here about details of obscure waits, setting event 1009812398901283948 forever on level 8127348 and checking the effect of that on X$MXYZPTLK. However, that has its place and time. The problem is: if you do that on your company's place and time and you can't come up at the end of it with a tangible and LARGE improvement in profitability (stuff the performance, profit is where it's at!), you are toast in the eyes of your boss. And with good reason: you are an expensive overhead and a pretentious git who thinks he's a Steve Adams. Sorry to be brutal. I warned I AM nasty, so there! :D Take it from someone who was a DBA-only 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 and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Re: Application DBA
- Original Message - Degree/OCP achievement doesn't teach f all - in my opinion - though it does prove your memory isn't shot. I can think of much cheaper and much more reliable and credible ways of checking my memory... :) lot. The reason, for example, that I personally prefer graduates to non-graduates *experience equal* is that generally graduates are better thinkers and problem solvers. Agreed 100%. But OCP is NOT a graduation, and it will NEVER be one. Until it is part of an official education syllabus. And not part of Larry's or any other commercial organization's pockets. And yes, I'm against private education. For a number of reasons that are not pertinent here. is worth it, the certificate probably not. Of course as far as recruiters are concerned ensuring your CV includes the words 'I don't have an OCP because...' followed by a decent explanation will generally get you through all the filters that say OCP required/preferred. Ain't software great. Hehehe! :D On architects, and at least in the UK, those who advertise themselves as such in the IT field are breaking the law http://www.hmso.gov.uk/acts/acts1997/97022--f.htm#20 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 and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 and London to Montreal because it was cheaper here. This is all business as usual. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Offshore threat
- Original Message - forever. Now it's time to wake up and see that IT is becoming a job like another where you most hold to your job instead of going to job interview just for fun. A lot of people don't believe this when I say it, but when I started in IT in 1975 what we got now was quite normal. Minus the foreign outsourcing phenomena. We had service bureaus then, but they stayed in the same country. Mostly. To me, it's all back to normal. Except I now earn a bucket load more. Am I truly better off? Nope: I have two kids, two dogs and a fat cat to support... ¦Þ 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Offshore threat
- Original Message - A - This is social engineering at its finest. B - There is no security without PHYSICAL security C - If you don't check up on your outsourcer, then you can apparently get the shirt stolen off your back... what scares me is these guys KNEW which boxes to go to to get the secret info. IOW, they KNEW the site internally, they have a plan and it's proceeding. I think I'm gonna cancel the holiday, September is here... PS: who is the IDIOT that leaves this stuff unencrypted and open to stealing? My laptop has no secret stuff, but because I work in a military installation EVERYTHING in it is encrypted, it has boot manager hard passwords, XP hard passwords, no diskette drive and God only knows what else I could cram in it. It takes me a few minutes to go through all the security every morning. And there is nothing wrong 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, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Re: Application DBA
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] more and more employers are requiring OCPs and 'related degrees' such as computer science or a masters degree. At least in the US they are. How are things in other parts of the world? For an application DBA? Exactly which part of the degree or OCP prepares or qualifies one for such a job specification? Matter of fact, where is application DBA defined in Oracle education or any other IT education organization? Which courses from Oracle prepare one for that? While we're there, I wish someone explained the same for database architect. Or architect, for that matter. As soon as someone does, and how can the OCP certification prepare one for everything up to and including the second coming, I'll go for it. Until then, I just see it as a low-life exploitation scheme to milk even more $$$ out of the customer base. Sorry if I sound cynical, but that's it. As I said: I'm open to an explanation. Never received it. Now, here: there are a few idiots around who insist that everyone working in a 9ir2 project must be OCP and have at least 5 years 9ir2 experience. They are the same that will insist on 5 years of 10g experience as soon as it comes out. As well as of course OCP. And that's for a job spec of code cutter. There are also those of course who don't give a damn, provided the person is an el-cheapo third-world recent arrival who can be had for peanuts and will accept any salary anyway. Usually these are the ones that run a project with 10 code cutters and 20 DBAs. Heck, DBAs can be sold for a much higher margin than a code cutter! And preciously next to nothing in between. pessimistic moah? Narh, just been there, done that and seen it all over 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 hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 Americans. Read about another politicized IT worker in No Americans Need Apply. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 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 - To REMOVE yourself from this mailing list, send an E-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).
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 -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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] Sent: Wednesday, August 27, 2003 12:19 AM i thought the only two unix players out there now are HP and Solaris. who else is out there? -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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 hasnt had a call from a recruiter when 9i came out about how much 9i experience you have. They dont ask you about any of the new features. They just want to know how long you used it. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Hey Jared!!
- Original Message - Well if you REALLY want to know how I feel about these types of idiots, I'd much prefer them to be publicly hanged, drawn quartered. Webcasting it would be very appriopriate too. Agreed. Difficulty is in finding them. BTW, if any1 saw Wayne Bastow's message 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 PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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: [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 from this mailing list, send an E-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).
Re: Re: OT - Linux books ??
- Original Message - how different is it to administer oracle on different flavors of unix? Im running into some annoying nuassances in syntax between solaris korn shell and hp-unix korn shell. is it just little syntax differences or is there alot more to it? You sure it's HP korn-shell? The default shell looks like korn, but it isn't. Looks like bourne as well, but again: it isn't. It is indeed the Posix shell, which is about right between the other 2. The only shell I've always found is reliable is the old bourne shell. Just about the same everywhere. Once again, the default HP one is NOT the bourne shell even though it is called sh. Of course you lose the niceties of command history and such, but if you're writing admin scripts what the heck do you need history for? Let's not touch the C-shell... As for administration of Unix itself: yikes! Depends which was the original Unix flavour: ATT System V or Berkeley BSD. SunOS was mostly BSD, Solaris got a lot of SystemV in it. HP was mostly BSD, but it got a lot of the SV stuff into it until HP decided to become Posix-compliant. Since then, it's been potluck. This basically means that features 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] -- 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 - To REMOVE yourself from this mailing list, send an E-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).
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. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Row level security and latch waits - LONG email...
- Original Message -
Policy function:
DPA42HP92.DP_PREDICATE_FUNCTION_PKG.DP_PREDICATE_FUNCTION
RLS view :
SELECT CURRENCY,CURRENCY_CODE,CURRENCY_DESC,CURRENCY_KEY FROM
DPA42HP9
2.DPR70_CURRENCY_D DPR70_CURRENCY_D WHERE (CURRENCY_CODE in (select
value_
v
from dp_security_values
where group_id in (select group_id from dp_upd_user_groups where
comp_group_id =
sys_context('dp_comp_group_id_ctx','comp_group_id'))
as you can see the context variable is being used in the generated
predicate clause
That makes perfect sense now.
Thanks a lot for the feedback.
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
-
To REMOVE yourself from this mailing list, send an E-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).
Re: Row level security and latch waits - LONG email...
- Original Message -
lets execute another query
SQL select count(*) from dpr70_gl_acct_balance_f;
COUNT(*)
--
2974
from v$SQL
SQL_TEXT
PARSE_CALLS EXECUTIONS FIRST_LOAD_TIME LOADS LAST_LOAD_TIME
--- -- --- -- ---
SELECT text from dp_security_text where object_name = :b1
and
comp_group_id = sys_context('dp_comp_group_id_ctx','comp_group_id')
7 24 2003-08-20/09:29:34 2 2003-08-20/10:39:44
Notice again parse_calls does not change
The above SQL is the predicate clause being generated every time
I don't think this is the issue at all. The SQL in the function
that generates the predicate WILL use bind variables and that
is perfectly expected. That's why you don't see an increase in parses
on the SQL INSIDE the function.
What will not use bind variables is this bit:
SQL select count(*) from dpr70_gl_acct_balance_f;
because the added predicate is a string without bind syntax.
However, I think if the added predicate string contains 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: 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
-
To REMOVE yourself from this mailing list, send an E-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).
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 PROTECTED] Date: 2003/08/20 Wed AM 11:21:59 EDT To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Re: Row level security and latch waits My understanding was that the rls predicate was added at parse time (hence the importance of the contexts and avoiding things like 'sysdate') But also if I remember correctly, this behaviour was changed in v9 to process the security function with each execution (and hence probably increase the amount of parsing going on). You might want to have a play the the _dynamic_policies parameter (or something like that) which can be used to revert the 8i behaviour (which should reduce parsing to a degree) hth connor --- Nuno Souto [EMAIL PROTECTED] wrote: - Original Message - - Use context values within predicates, as bind variables NOTE THIS LINE. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Re: Row level security and latch waits
- Original Message - - Use context values within predicates, as bind variables NOTE THIS LINE. None of that implies it's not appending a where clause like it was explained. It uses the context values (if that's the case) in a function which then returns a string. That string is then appended as a predicate to the original statement. That means the original statement is then re-parsed. It's the reason why you need query-rewrite enabled in FGAC. So, you get a lot of parsing. I don't know of any way of passing a context value as a true bind variable in a return string 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 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 - To REMOVE yourself from this mailing list, send an E-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).
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 Souto 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 from this mailing list, send an E-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).
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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 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 from this mailing list, send an E-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).
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 PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 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 - To REMOVE yourself from this mailing list, send an E-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).
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 PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 01, 2003 1:44 AM Just got this email from my SysAdmin when I asked for access to sar. Anyone know what he is talking about? We are on AIX 4 and 5. I cannot give you direct access to the sar command. Because of the parameters the command allows, it would be equivalent to giving full root access. If you could give me some details on the kind of information you would like to be able to collect, maybe we could set up some kind of command to obtain it. -- 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: Union quries: INTERSECT, MINUS, etc
- Original Message - I'm doing research for an article on union queries. I'm interested in finding examples of problems that were solved using UNION, UNION ALL, INTERSECT, or MINUS, with the latter two being of special interest because I don't see them used very often. If you can think of an interesting problem you've solved using one of these keywords, I'd love to hear about it. UNION is useful to implement arcs. INTERSECT I've used very successfully with two CONNECT BY queries to retrieve all possible paths of travel between two points A and B in a table 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-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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 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 from this mailing list, send an E-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).
Re: imp table data, but not PK indexes?
- Original Message - 2) export data with constraints=n rows=y indexes=n direct=y recordlength=65535 ^^ Do you find that makes a real difference? I haven't had much success with it... Also, if you plan to shorten your downtime by first exporting/importing the structure from online database and then transferring data during downtime, you have to worry about your sequences, because they have probably incremented after structure export and data export. Thus a simple script has to be done for that (thanks John ;). Good point, thanx! Tanel. 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 - To REMOVE yourself from this mailing list, send an E-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).
Re: imp table data, but not PK indexes?
- Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, July 20, 2003 2:04 AM as PK comes under 'constraints' you might also have to do constraints=N also... On Sat, 19 Jul 2003 07:04:23 -0800, Ganesh Raja [EMAIL PROTECTED] wrote : Use the Indexes = N Option and Create the Index Seperatley .. Yes, but IIRC CONSTRAINTS=Y is an exp parameter, not imp? Best way to handle these things is to export twice. Once with all the bells and whistles turned on but ROWS=N (this gives you a small export file with all the schema logic added 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://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 - To REMOVE yourself from this mailing list, send an E-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).
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 PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
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, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Re: Object Types in PL/SQL
- Original Message - how does the object features improve performance of the jdbc? its fairly common now to have a java or .net(which we are using) and an Oracle backend. When we started to use JDBC, one of the things I noticed was some very unusual network traffic. Certainly more than I was expecting given the level of statements being executed. A few traces showed a lot of traffic by JDBC driver itself trying to find information about the parameters involved in a ExecutableStatement. I believe this is specific to JDBC 2 and its new MetaData functionality, but I don't know for sure. A little bit of experimentation showed that if we created an object type definition for each table involved in our procedures and used the object type to pass the parameters (each parameter is a column) to the stored procedures, the network traffic dropped dramatically. Now we use a package for each table with an object type matching the table columns used as the single parameter to each function/procedure. Each package has as a minimum a MNG_table and a DEL_table procedure, with the first one handling both INSERT and UPDATE (depending if PK is set to NULL or not). We also write getters to access the data, returning a REF CURSOR typed on the same object type. This is not only blinding fast but the network traffic is negligeable. your comments would be much appreciated. Not really comments, just the experience so far. It might change in the next version. So far it seems to work like a charm, so we're sticking with it. The next step is to get a few of the hierarchical accesses done via O-R views returning a single object with an array for the child object types. First trials seem very promising, but I have to wait for the 9i upgrade: 8i lets me do only one level 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-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-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).
Re: Object Types in PL/SQL
- Original Message - We actually don't use Object Types that much (who does anyway ;). But I have to say, that I'm a little bit disappointed by Oracle's implementation (Ever I do. Only way to use some of the DMBS_* library items and one of the best ways of speeding up Java/JDBC 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://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 - To REMOVE yourself from this mailing list, send an E-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).
