Re: Oracle OS level security
--- Jared Still <[EMAIL PROTECTED]> wrote: > On Thursday 28 November 2002 03:53, O'Neill, Sean wrote: > > > We has a Standard Operating Procedure which states that whilst > DBA's have a > > access to data they will not change it. A recognition of the DBA's > > capabilties but stating on paper company trust they will "behave" > > themselves. > > Auditors are usually bean counters (accountants). > > They don't trust anybody. Jared -- not necessarily so. Back at the company at which I was employed longest and where I learned to be a DBA, the auditors didn't have a CLUE about how to deal with databases and auditing of them. The data center would say in their audit paperwork "database auditing is done via controls installed by the application managers" and the application managers would say "database auditing is done via controls installed by the data center". And I would be instructed to SHUT UP and tell the auditors only the least amount of information I could get away with. The auditors bought it, year after year. I finally, just before I left, sat down and had a heart to heart talk with one of the auditors, explaining that they had had a development DBA (me) with total production access for years. It was too much work for them to develop a database auditing process, at least, they didn't get one even started before I left. __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael 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: LGWR using lots of CPU time, low CPU usage
for a front row seat at this gunfight, I will gladly buy at least one round :) --- Tim Gorman <[EMAIL PROTECTED]> wrote: > ...turn your back on this list for a few days and look what happens > (besides > 440 new emails to scan-and-delete)... > > Well Jared, I can't think of any more potent weapon than single-malt > scotch. > Shotglasses at sunset... > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Wednesday, November 27, 2002 12:44 PM > > > > they'll both be here in two weeks, I'm selling tickets to the fight > now > > :) > > > > > > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > > You best be careful, Jared. You KNOW how uptight and evil Tim can > be! > > > :) > > > > > > -Original Message- > > > Sent: Wednesday, November 27, 2002 9:56 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Oh boy, is my face red! > > > > > > I remembered that of course, as soon as I saw this. > > > > > > I need to keep better track of who I'm plagierizing. :) > > > Jared > > > > > > > > > > > > > > > > > > > > > "Cary Millsap" <[EMAIL PROTECTED]> > > > Sent by: [EMAIL PROTECTED] > > > 11/26/2002 03:05 PM > > > Please respond to ORACLE-L > > > > > > > > > To: Multiple recipients of list ORACLE-L > > > <[EMAIL PROTECTED]> > > > cc: > > > Subject:RE: LGWR using lots of CPU time, low CPU > > > usage > > > > > > > > > The ultimate sincerest form of flattery is for someone to > attribute > > > something smart to you that you wish you had done but, alas, did > not > > > actually do. > > > > > > (It was Tim Gorman who posted the excellent analogy.) > > > > > > > > > Cary Millsap > > > Hotsos Enterprises, Ltd. > > > http://www.hotsos.com > > > > > > Upcoming events: > > > - Hotsos Clinic, Dec 9-11 Honolulu > > > - Hotsos Clinic 101, Jan 7-9 Knoxville > > > - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen > > > - 2003 Hotsos Symposium, Feb 9-12 Dallas > > > > > > > > > -Original Message- > > > [EMAIL PROTECTED] > > > Sent: Tuesday, November 26, 2002 4:07 PM > > > To: Multiple recipients of list ORACLE-L > > > > > > > >And "old school" is still right about not putting RedoLogs > onto > > > RAID5. > > > > > > > From what I'm being told, this is not your father's RAID5. > This is > > > what > > > > > > >they tell me: > > > > > > > The CPU hands the IO to the disk controller and rather than do > the > > > > physical disk IO while the process waits, the disk controller > > > caches > > > > it to local memory and says done. Therefore, effectively there > is > > > no > > > > wait for IO and it doesn't matter if we are RAID 5 or RAID 0+1, > > > > the system is NOT waiting for the IO. He said the only time > there > > > might > > > > be a delay is during the cache's battery refresh times. I > checked > > > your > > > > dates and it was not occurring during those times. Also, if you > > > look > > > > at the iostat statistics under the 'wait' and '%w' headers you > will > > > > see all zeros. > > > > > > Debi, > > > > > > That is true, up to a point. > > > > > > Think of the cache as a water tank. You have a garden hose > > > filling up the tank. You can keep increasing the water > > > pressure for a while. > > > > > > But the outlet at the other end of the tank has a fixed > > > capacity. It flows 10 GPM, and no more. > > > > > > What happens when you increase the flow at the intake to > > > 20 GPM? > > > > > > The tank fills up. > > > > > > When the tank fills up, your intake flow will need to decrease, > > > because you can only flow 10 GPM at the outlet. > > > > > > Now, think of the outlet as writing to disk, the RAID5 cache > > > is the water tank, and your database is the inlet that wants > > > to run at 20 GPM. > > > > > > If your database activity will never be intensive enough to > > > stress the cache like this, no problem. But 'never' is a > > > very long time. > > > > > > If any of this sound familiar, Cary Millsap posted a very similar > > > explanation a few weeks ago. > > > > > > Plagierism is the sincerest form of flattery. :) > > > > > > Jared > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: > > > 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.com > > > -- > > > Author: Ca
question: about table(s) ?
can we arrange tables in a heirarchy form, just like we have folders and under folders we have files. so this way we sort of divide workspace. say for company_A i create folder A and in it we can place files for that company. and similarly we can create a folder for company_B. Hence we can separate workspaces for better organization and management etc. so how can we accomplish as above, when we work with database ? is there a way we can arrange tables (of the database) in a heirarchy similar to folders and files ? say i have one installation of oracle on a particular computer. so how does one create separate table spaces, say for two different company or projects ? (say company_A and company_B are unrelated to each other) __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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 OS level security
On Thursday 28 November 2002 03:53, O'Neill, Sean wrote: > We has a Standard Operating Procedure which states that whilst DBA's have a > access to data they will not change it. A recognition of the DBA's > capabilties but stating on paper company trust they will "behave" > themselves. Auditors are usually bean counters (accountants). They don't trust anybody. > > On a more practical point with NT/W2K Oracle audit trail can be set to > write audit trail records to the event logs. DBA's can be prevented from > changing the event logs. So now it would take at least 2 people to > instigate a fraud. Hey this might foster even better relations between > DBA's and SA's ;) OS level audit trails won't track block level hacking, such as with BBED. Jared > > Just my 2 cent worth :) > - > Seán O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > > >> From: [EMAIL PROTECTED] > >> Date: Tue, 26 Nov 2002 14:40:24 -0800 > >> Subject: Oracle OS level security > >> > >>Dear list, > >> > >>Let me toss a hypothetical situation at you. > > etc. etc. > > This message, including attached files, may contain confidential > information and is intended only for the use by the individual > and/or the entity to which it is addressed. Any unauthorized use, > dissemination of, or copying of the information contained herein is > not allowed and may lead to irreparable harm and damage for which > you may be held liable. If you receive this message in error or if > it is intended for someone else please notify the sender by > returning this e-mail immediately and delete the message. > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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 OS level security
On Thursday 28 November 2002 12:03, Tim Gorman wrote: > My $0.02... > > Oracle9i provides the AUDIT_SYS_OPERATIONS parameter, which will audit only > to the OS audit trail. Thus, anything that SYSDBA does can be audited. > > The reason for the OS audit-trail only? Because SYSDBA can always erase a > DB audit trail (even if the act of erasure is still audited). All SYSDBA > however, can be prevented from reading or modifying the OS audit trail. This doesn't prevent a SA with DBA knowledge from wreaking havoc. > I believe the only secure configuration for an Oracle database has the > "software owner" (typically named "oracle") and OS_SYSDBA and OS_SYSOPER > groups under control of SysAdmins only. Those with SYSDBA do not need > access to that OS account or those OS groups. SA's still a problem. > > The real problem is DBAs ourselves, who seem to treasure day-to-day usage > of the Oracle software owner and membership of private accounts in the > OS_SYSDBA and OS_SYSOPER groups... Personally, I log into the 'oracle' or 'root' account only as needed. Except on NT of course, where I need admin access to do my job properly. Maybe in a larger shop that wouldn't be necessary, but in a small shop it's very difficult to have an SA at your side when needed for admin level access. Jared > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, November 28, 2002 4:53 AM > > > Jared, > > > > Very interested in the "thread" you hypothetical raised. I'm working in > > a pharamceutical site which is subject to FDA and other regualtions part > > of which is the whole buisness of audit trails. > > > > We has a Standard Operating Procedure which states that whilst DBA's have > > a > > > access to data they will not change it. A recognition of the DBA's > > capabilties but stating on paper company trust they will "behave" > > themselves. > > > > On a more practical point with NT/W2K Oracle audit trail can be set to > > write > > > audit trail records to the event logs. DBA's can be prevented from > > changing > > > the event logs. So now it would take at least 2 people to instigate a > > fraud. Hey this might foster even better relations between DBA's and > > SA's ;) > > > > Just my 2 cent worth :) > > - > > Seán O' Neill > > Organon (Ireland) Ltd. > > [subscribed: digest mode] > > > > >> From: [EMAIL PROTECTED] > > >> Date: Tue, 26 Nov 2002 14:40:24 -0800 > > >> Subject: Oracle OS level security > > >> > > >>Dear list, > > >> > > >>Let me toss a hypothetical situation at you. > > > > etc. etc. > > > > This message, including attached files, may contain confidential > > information and is intended only for the use by the individual > > and/or the entity to which it is addressed. Any unauthorized use, > > dissemination of, or copying of the information contained herein is > > not allowed and may lead to irreparable harm and damage for which > > you may be held liable. If you receive this message in error or if > > it is intended for someone else please notify the sender by > > returning this e-mail immediately and delete the message. > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: O'Neill, Sean > > 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.com -- Author: Jared Still 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: LONG's
Imagine 5 tables, all with the same 4 column concatenated primary key. Yes, it gets ugly early. Now, create a table with those 4 columns, and one additional column, which happens to be a LONG RAW. Take all of the data for each table, *except* for the Pk columns, compress it with some unknown algorithm, and stuff it all into the single LONG RAW column. Do this for all 5 tables. There you have it, a performance sucking, impossible to get at, pile of barnyard droppings. You *can* get at the data, but only through ABAP, SAP's own version of COBOL. Fortunately, most tables are not stored this way. Unfortunately, the one you really need usually is. Take a look at the SAPR3.RFBLG table. Re your install: You *will* need SAP consultants. If you are a DBA, they *will* assume you are an evil entity and do everything they can to circumvent you. They *will* know a lot about SAP, but not nearly as much about Oracle as they think they do. Jared On Thursday 28 November 2002 07:28, Yechiel Adar wrote: > Can you explain a little about SAP cluster/pool? > They are going to put SAP in our system and anything I can learn beforehand > will be welcome. > > Yechiel Adar > Mehish > - Original Message - > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > Sent: Tuesday, November 26, 2002 7:42 PM > > > Ah, I missed that it was SAP. > > > > Yeah, they don't like you mucking about with their schema. > > > > I would like to see their cluster/pools go *away*! > > > > They are a major pain at times. > > > > Jared > > > > > > > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 11/26/2002 07:54 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > > cc: > > Subject:RE: LONG's > > > > > > > > Thanks all for the suggestions. I think I'll take a look at COPY and the > > PL/SQL options since I've used them before, and C & Perl are not in my > > repertoire, I'm ashamed to say ;) To shed a little more light on the > > requirement, I'm researching the best (subjective) way to convert > > dictionsry-managed TS's to locally-managed in an 8.1.7.3, Tru64 hosted DB > > running SAP R/3. The convert-in-place procedure > > [dbms_space_admin.tablespace_migrate_to_local] does not change extent > > management for the segment. > > > > Jared, I'd consider converting them, but SAP is a little posessive of > > their > > Clusters/Pools. > > > > Mike H. > > > > -Original Message- > > Sent: Monday, November 25, 2002 6:39 PM > > To: [EMAIL PROTECTED] > > Cc: [EMAIL PROTECTED] > > > > > > Mike, > > > > Conner pointed out that you could use C. > > > > You can also use Perl with DBI and DBD::Oracle if you like, and have > > someone there that can use it. > > > > Why not just convert them to CLOB and LOB? > > > > Jared > > > > > > > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 11/25/2002 07:59 AM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:LONG's > > > > > > OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I > > find out that the same restriction exists on Alter Table ... Move. So, > > is there any other option to move these tables from one tablespace to > > another without exp/imp or converting them to LOB? > > > > Thanks, > > Mike > > > > This transmission is intended only for use by the addressee(s) named > > herein and may contain information that is proprietary, confidential > > and/or legally privileged. If you are not the intended recipient, you are > > hereby notified that any disclosure, copying, distribution, or use of the > > information contained herein (including any reliance thereon) is STRICTLY > > PROHIBITED. If you received this transmission in error, please > > immediately > > > > contact the sender and destroy the material in its entirety, whether in > > electronic or hard copy format. Thank you. > > > > > > > > +**+ > > This transmission is intended only for use by the addressee(s) named > > herein and may contain information that is proprietary, confidential > > and/or legally privileged. If you are not the intended recipient, you are > > hereby notified that any disclosure, copying, distribution, or use of the > > information contained herein (including any reliance thereon) is STRICTLY > > PROHIBITED. If you received this transmission in error, please > > immediately contact the sender and destroy the material in its entirety, > > whether in electronic or hard copy format. Thank you. > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Hand, Michael T > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- 858-538-5051 http://www.fatcity.com > > San Diego, California-- Mailing list and web hosting services > >
RE: Understanding CPU time and profile
So what if the user is using PQO? Would this control the total (sum) of all the CPU time used by all processes involved in the query? Waleed -Original Message- Sent: Thursday, November 28, 2002 4:59 PM To: Multiple recipients of list ORACLE-L I'm testing profile to limit end users doing ad-hoc queries. I have a query that is taking 51740 cpu unit according to v$sesstat. In the doc, the unit is "Amount of CPU time (in 10s of milliseconds)" so its 517 seconds. I've created a profile with cpu_per_call limit of 3000, the unit is in hundredths of seconds, so 30 seconds. Once the profile created the query fails and when I checked the cpu in v$sesstat it went from 10692 to 21547 so 10855 so 108 seconds. It should have been around 30 seconds, no ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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.com -- Author: Khedr, Waleed 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).
Understanding CPU time and profile
I'm testing profile to limit end users doing ad-hoc queries. I have a query that is taking 51740 cpu unit according to v$sesstat. In the doc, the unit is "Amount of CPU time (in 10s of milliseconds)" so its 517 seconds. I've created a profile with cpu_per_call limit of 3000, the unit is in hundredths of seconds, so 30 seconds. Once the profile created the query fails and when I checked the cpu in v$sesstat it went from 10692 to 21547 so 10855 so 108 seconds. It should have been around 30 seconds, no ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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: SYSOPER?
I am !!! --- Tim Gorman <[EMAIL PROTECTED]> a écrit : > Q: How many people use the SYSOPER privilege? > > ...just curious... > > Please respond only if the answer is affirmative -- > I suspect the number of responses will be quite > small... > > P.S.I have never worked at an place where it is > used, of which I'm aware. That in itself should > speak volumes of the current importance of database > security... > = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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).
SYSOPER?
Q: How many people use the SYSOPER privilege? ...just curious... Please respond only if the answer is affirmative -- I suspect the number of responses will be quite small... P.S. I have never worked at an place where it is used, of which I'm aware. That in itself should speak volumes of the current importance of database security...
Re: Oracle OS level security
My $0.02... Oracle9i provides the AUDIT_SYS_OPERATIONS parameter, which will audit only to the OS audit trail. Thus, anything that SYSDBA does can be audited. The reason for the OS audit-trail only? Because SYSDBA can always erase a DB audit trail (even if the act of erasure is still audited). All SYSDBA however, can be prevented from reading or modifying the OS audit trail. I believe the only secure configuration for an Oracle database has the "software owner" (typically named "oracle") and OS_SYSDBA and OS_SYSOPER groups under control of SysAdmins only. Those with SYSDBA do not need access to that OS account or those OS groups. The only occasion that access is needed is during software installation/maintenance and Oracle is doing a reasonably good job with OUI to make even this a task which can be performed by SysAdmins assisted by DBAs. Even when this isn't the case, such access can be temporary and audited at the OS-level. The real problem is DBAs ourselves, who seem to treasure day-to-day usage of the Oracle software owner and membership of private accounts in the OS_SYSDBA and OS_SYSOPER groups... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 4:53 AM > Jared, > > Very interested in the "thread" you hypothetical raised. I'm working in a > pharamceutical site which is subject to FDA and other regualtions part of > which is the whole buisness of audit trails. > > We has a Standard Operating Procedure which states that whilst DBA's have a > access to data they will not change it. A recognition of the DBA's > capabilties but stating on paper company trust they will "behave" > themselves. > > On a more practical point with NT/W2K Oracle audit trail can be set to write > audit trail records to the event logs. DBA's can be prevented from changing > the event logs. So now it would take at least 2 people to instigate a > fraud. Hey this might foster even better relations between DBA's and SA's > ;) > > Just my 2 cent worth :) > - > Seán O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > > >> From: [EMAIL PROTECTED] > >> Date: Tue, 26 Nov 2002 14:40:24 -0800 > >> Subject: Oracle OS level security > >> > >>Dear list, > >> > >>Let me toss a hypothetical situation at you. > etc. etc. > > This message, including attached files, may contain confidential > information and is intended only for the use by the individual > and/or the entity to which it is addressed. Any unauthorized use, > dissemination of, or copying of the information contained herein is > not allowed and may lead to irreparable harm and damage for which > you may be held liable. If you receive this message in error or if > it is intended for someone else please notify the sender by > returning this e-mail immediately and delete the message. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > 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.com -- Author: Tim Gorman 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: DBA OCP, Developer OCP
The word "Certified" excites most HR types ;) - Kirti -Original Message- Sent: Thursday, November 28, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I am wondering if HR departments are using the Developer OCP to screen candidates, and if that practice is correlated with the hiring of more qualified employess. Depends on your perspective I guess, I know there is a bit of a debate re. DBA OCP, I was wondering if the same debate exists for the Developer side. : ) Pat. -Original Message- Sent: Thursday, November 28, 2002 1:19 PM To: Multiple recipients of list ORACLE-L "Boivin, Patrice J" wrote: > > Just wondering during my lunch break... > > Are the Developer OCP credentials comparable to the DBA OCP, in terms of > validity? > > Regards, > Patrice Boivin. > How should it be understood :-) ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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.com -- Author: Boivin, Patrice J 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.com -- Author: Deshpande, Kirti 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: LGWR using lots of CPU time, low CPU usage
...turn your back on this list for a few days and look what happens (besides 440 new emails to scan-and-delete)... Well Jared, I can't think of any more potent weapon than single-malt scotch. Shotglasses at sunset... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 12:44 PM > they'll both be here in two weeks, I'm selling tickets to the fight now > :) > > > --- "Fink, Dan" <[EMAIL PROTECTED]> wrote: > > You best be careful, Jared. You KNOW how uptight and evil Tim can be! > > :) > > > > -Original Message- > > Sent: Wednesday, November 27, 2002 9:56 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Oh boy, is my face red! > > > > I remembered that of course, as soon as I saw this. > > > > I need to keep better track of who I'm plagierizing. :) > > Jared > > > > > > > > > > > > > > "Cary Millsap" <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 11/26/2002 03:05 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: LGWR using lots of CPU time, low CPU > > usage > > > > > > The ultimate sincerest form of flattery is for someone to attribute > > something smart to you that you wish you had done but, alas, did not > > actually do. > > > > (It was Tim Gorman who posted the excellent analogy.) > > > > > > Cary Millsap > > Hotsos Enterprises, Ltd. > > http://www.hotsos.com > > > > Upcoming events: > > - Hotsos Clinic, Dec 9-11 Honolulu > > - Hotsos Clinic 101, Jan 7-9 Knoxville > > - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen > > - 2003 Hotsos Symposium, Feb 9-12 Dallas > > > > > > -Original Message- > > [EMAIL PROTECTED] > > Sent: Tuesday, November 26, 2002 4:07 PM > > To: Multiple recipients of list ORACLE-L > > > > > >And "old school" is still right about not putting RedoLogs onto > > RAID5. > > > > > From what I'm being told, this is not your father's RAID5. This is > > what > > > > >they tell me: > > > > > The CPU hands the IO to the disk controller and rather than do the > > > physical disk IO while the process waits, the disk controller > > caches > > > it to local memory and says done. Therefore, effectively there is > > no > > > wait for IO and it doesn't matter if we are RAID 5 or RAID 0+1, > > > the system is NOT waiting for the IO. He said the only time there > > might > > > be a delay is during the cache's battery refresh times. I checked > > your > > > dates and it was not occurring during those times. Also, if you > > look > > > at the iostat statistics under the 'wait' and '%w' headers you will > > > see all zeros. > > > > Debi, > > > > That is true, up to a point. > > > > Think of the cache as a water tank. You have a garden hose > > filling up the tank. You can keep increasing the water > > pressure for a while. > > > > But the outlet at the other end of the tank has a fixed > > capacity. It flows 10 GPM, and no more. > > > > What happens when you increase the flow at the intake to > > 20 GPM? > > > > The tank fills up. > > > > When the tank fills up, your intake flow will need to decrease, > > because you can only flow 10 GPM at the outlet. > > > > Now, think of the outlet as writing to disk, the RAID5 cache > > is the water tank, and your database is the inlet that wants > > to run at 20 GPM. > > > > If your database activity will never be intensive enough to > > stress the cache like this, no problem. But 'never' is a > > very long time. > > > > If any of this sound familiar, Cary Millsap posted a very similar > > explanation a few weeks ago. > > > > Plagierism is the sincerest form of flattery. :) > > > > Jared > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > 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.com > > -- > > Author: Cary Millsap > > 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
Anybody using profile to limit ressources
On 817/aix, the end-users will have access to query data in an ad-hoc fashion. We want to limit the problems. I want to limit per queries so I guess that I must used cpu_per_call. I'm currently testing some queries and checking statistics CPU used when call started to see how much a query consumes. CPU used when call started and CPU used by this session shows the same value, I thought there would be different. Anybody using profile to limit ressources ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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: Internals: setting oracle event 10052 -turn off smon from cleaning deleted objects (bug)
Hi: THis event 10052(Stop SMON from cleaning OBJ$) is most commonly used in OPS/RAC environments to avoid the the so called spinning behavior of SMON and to avoid the ORA-600 (16224). It is absolutely safe to use this event as it just asks the SMON to skip some of the regular garbage cleaning activities (In this case cleaning up the OBJ$ entries). The only thing you see in your database is the SYS table OBJ$ will be full of garbage's of the entries with non existing tables/object names. You can once in a while restart the database without the event 10052 which cleans up the OBJ$, Normally SMON does lots of garbage cleaning (!?) during the life cycle of the instance like cleaning the UET$,FET$ (in dictionary Managed Table space databases) in every 5 minutes,SEG$(once in 125 minutes?), Shrinking the rollback segments once in 12hrs unless you set the event 10512 apart from the regular stats update when you set the MONITORING options. In a short answer, yes.. you can set the event as suggested !! Best Regards, K Gopalakrishnan -Original Message- Rosenthal Sent: Thursday, November 28, 2002 8:04 AM To: Multiple recipients of list ORACLE-L cleaning deleted objects (bug) Hi.. we are several months away from upgrading to 8.1.7.4 from 8.1.7.1 to resolve several oracle bugs including smons behavior of crashing when cleaning up oracle space from deleted entries in the obj$ table. In the meantime, Oracle suggested we set the 10052 event to turn of Smon from performing obj$ space cleanup. We are a four node ops cluster (HP), 3 oltp and 1 batch. Questions: 1)What kind of entries are cleaned up. 2)Is there a danger to extent management in the obj$ table of "deleted but no cleaned up entries". 3)Is it reasonable to just shut down one node once a week, restart it for 20 minutes with smon enabled during our maintenance window and restart with 10052 re-enabled? 4)Any suggestions, pointers, or folks with bad experiences using this event? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas Rosenthal 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.com -- Author: K Gopalakrishnan 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: Data Warehousing books for Oracle 9i (once again)
Thanks for the reference, Stephane! Gary Dodge was the primary author of "Oracle8 Data Warehousing" and "Essential Oracle8i Data Warehousing", both from John Wiley and Sons (not Oracle Press). I was his co-author. We started "Essential Oracle9i Data Warehousing" late last year, but for a variety of reasons we will not be completing that. Most of the reasons have to do with objections from family and personal conscience on starting another after-hours book project, coupled with our desire to reorganize the book (into an end-to-end case-study) and our inability to find facilities to make that happen within the period specified by Wiley. ...remember how Margaret Mitchell took 50 years to write "Gone with the Wind"? Well, that type of schedule is certainly gone with the wind, especially for technical computer books... I can recommend "Essential Oracle8i DW", which would have the obvious lack of mention of external tables, table functions, and other 9i features like OLAP and data mining features, but has a lot of discussion on materialized views, direct-path/append loading, parallel execution, partitioning, and other important still-relevant topics... ...plus, the thing of which I am most proud: the incorporation of relevant quotes from Monty Python, Mel Brooks, Peter Sellers, The Three Stooges, and other masters of data warehousing at the start of each chapter. I am especially proud of the Monty Python quote from "The Meaning of Life" about the "machine that goes *ping*" which begins the chapter on Oracle Parallel Server -- talk about serendipity!... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 2:04 PM > Just to clarify. > > The Oracle 8 Data Warehousing I feel that did not > really cover what it was supposed was the one from > Oracle Press not the one from Tim Gorman. > > Tim Gorman has wrote 2 good books (maybe more ?) on DW > : Oracle8 Data Warehousing, Essential Oracle8i Data > Warehousing: Designing, Building, and Managing Oracle > Data Warehouses . > > > > --- Stephane Paquette <[EMAIL PROTECTED]> a > écrit : > Even 1$ is too much for "Oracle8 Data > Warehousing" ! > > > > We're not yet on 9i so I've not checked about that > > kind of book. > > For DW only, check Ralph Kimball's book and the IBM > > red book site( http://www.redbooks.ibm.com/). There > > is > > an excellent document (PDF) about datawarehousing in > > general. > > The data warehouse institute > > (http://www.dw-institute.com) offers papers and > > training. > > > > On 8i, I can recommend Tim Gorman's book. > > > > DW are never reorganised but updated on the > > frequency > > needed by the business needs. > > > > HTH > > > > --- "Jesse, Rich" <[EMAIL PROTECTED]> a écrit > > : > > > Yes, I know -- old topic, but a search thru the > > 440 > > > DW posts on the fatcity > > > archives didn't reveal much. > > > > > > Not having much of any knowledge on DW/DM, I > > picked > > > up the Oracle Press' > > > "Oracle8 Data Warehousing" book for $1 on the > > > clearance rack in hopes that > > > an overall view of the procedures necessary for > > > DW/DM building and > > > maintenance to give me some idea of what I'm up > > > against. > > > > > > I can't help but be completely confused by this > > book > > > because it doesn't seem > > > to cover DW/DM maintenance at all. It has a > > chapter > > > dedicated to various > > > ways to populate the DW/DM, but not how to keep > > the > > > data up-to-date. Do DWs > > > get completely regenerated on a > > > daily/weekly/periodic basis? This just > > > doesn't seem feasible to me, especially for large > > > (1T+) DWs. > > > > > > Am I missing something? Are newer revs of this > > book > > > better? Are there any > > > better DW books geared specifically for Oracle9i? > > > Does Martha know that > > > John is really her long-lost brother? > > > > > > From past posts (Jared's?), I'm thinking that we'd > > > be at least picking up > > > Kimball's DW Toolkit, 2nd Ed. and hopefully we'll > > > get some training in for > > > this, too, but I would like something specific to > > > DWs on Oracle 9i. > > > > > > > > > TIA! :) > > > Rich > > > > > > > > > Rich Jesse > > System/Database > > > Administrator > > > [EMAIL PROTECTED] Quad/Tech > > > International, Sussex, WI USA > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Jesse, Rich > > > 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
Re: Anyone knowing about Unix groups
A few years back, www.tek-tips.com was a promising and varied Q&A forum. I haven't participated lately so I can't say if it still is, but it is worth a try. It has UNIX and shell forums... - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 10:04 AM > http://www.ugu.com > > - Kirti > > -Original Message- > Sent: Thursday, November 28, 2002 2:59 AM > To: Multiple recipients of list ORACLE-L > > > Hallo, > > anyone whom knows about any website where you can ask questions about unix and shell-programming? > > Thanks in advance. > > Roland > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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.com > -- > Author: Deshpande, Kirti > 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.com -- Author: Tim Gorman 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: a PL/SQL design question.
Andrey Please forgive me if this sounds like a theoretical solution, since I don't have the time to try it out relevant to your situation. But what about using the trigger to call a procedure which is an autonomous transaction ? You do this by placing the following anywhere in the declare section of the SP: pragma AUTONOMOUS_TRANSACTION This will allow the operation to take place and commit, completely independent of the master transaction. My 2 cents' worth. HTH. Ferenc Mantfeld -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 29, 2002 4:34 AM To: Multiple recipients of list ORACLE-L Subject:a PL/SQL design question. Dear gurus! I'm looking for a solution to the following problem: I need a way to run a certain stored procedure as soon as a record is inserted into a certain table. A trigger is not feasible for this, since I do not want the execution of the procedure to be a part of the transaction that inserts a row into the table. I want the insertion to be visible to all the users (i.e. committed) as soon as the insertion is done, and then, as a separate transaction of its own, to run the stored procedure. Suggestions , please ? Thanks a lot ! << File: ATT3.html >> -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: mantfield 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:Gurkha
Dale Thanks for that correction. I am enlightened. Regards : Ferenc Mantfeld -Original Message- From: [EMAIL PROTECTED] [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 28, 2002 8:34 PM To: Multiple recipients of list ORACLE-L Subject:Re: Monitoring Tool Evaluation methodology Hi Ferenc > Why don't companies do more DD before naming products ? The Gurkhas were > special forces in the British Army, trained to DESTROY and DEMOLISH ! So, > is this an electronic version of it (eGurkha) ? Not likely to score points > with the Brits for installing this on their systems eh ? Not at all - quite the reverse in fact. The Gurkha regiment still exists and is highly respected in the UK. The Gurkha regiment is renowned for its toughness, loyalty and tenacity. Regards Dale --- The Freeware DBATool: The easy way to generate the DDL re-creation scripts for your Oracle database + DDL to HTML conversion for instant documentation. http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- Author: mantfield 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 policy document
I have some documentation at http://www.geocities.com/oraworld/cds/server/DBPolicy.html HTH, Krishna - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 5:08 AM > Hi Folks, > > We've recently started to partake in development of a quality manual for our > site. Part of this will be an IT Policy Document which will in turn have a > section on "Oracle Policy". My initial thoughts are that it will include > sections on: > > - Security (including Audit Trails) > - Projects > - Configuration & Installation > - Data loading > - Backup & Recovery > > If anyone has a similar type of Oracle policy document they would be willing > to share I'd appreciate it, or if you have any constructive input as to > "areas" which should be included, or if you know of any useful sources for > material for same pleez let me know. > > With thanks in advance :) > - > Seán O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > > > > This message, including attached files, may contain confidential > information and is intended only for the use by the individual > and/or the entity to which it is addressed. Any unauthorized use, > dissemination of, or copying of the information contained herein is > not allowed and may lead to irreparable harm and damage for which > you may be held liable. If you receive this message in error or if > it is intended for someone else please notify the sender by > returning this e-mail immediately and delete the message. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: O'Neill, Sean > 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.com -- Author: Krishna Rao Kakatur 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: a PL/SQL design question.
Andrey Bronfin wrote: > Dear gurus! > I'm looking for a solution to the following problem: > I need a way to run a certain stored procedure as soon as a record is > inserted into a certain table. > A trigger is not feasible for this, since I do not want the execution of the > procedure to be a part of the transaction that inserts a row into the table. > I want the insertion to be visible to all the users (i.e. committed) as soon > as the insertion is done, and then, as a separate transaction of its own, to > run the stored procedure. > Suggestions , please ? > Thanks a lot ! Keyword = AUTONOMOUS TRANSACTION -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: DBA OCP, Developer OCP
I am wondering if HR departments are using the Developer OCP to screen candidates, and if that practice is correlated with the hiring of more qualified employess. Depends on your perspective I guess, I know there is a bit of a debate re. DBA OCP, I was wondering if the same debate exists for the Developer side. : ) Pat. -Original Message- Sent: Thursday, November 28, 2002 1:19 PM To: Multiple recipients of list ORACLE-L "Boivin, Patrice J" wrote: > > Just wondering during my lunch break... > > Are the Developer OCP credentials comparable to the DBA OCP, in terms of > validity? > > Regards, > Patrice Boivin. > How should it be understood :-) ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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.com -- Author: Boivin, Patrice J 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: a PL/SQL design question.
here is my answer. -Original Message-From: Andrey Bronfin [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 28, 2002 12:34 PMTo: Multiple recipients of list ORACLE-LSubject: a PL/SQL design question.
a PL/SQL design question.
Re: DBA OCP, Developer OCP
"Boivin, Patrice J" wrote: > > Just wondering during my lunch break... > > Are the Developer OCP credentials comparable to the DBA OCP, in terms of > validity? > > Regards, > Patrice Boivin. > How should it be understood :-) ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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: Monitoring Tool Evaluation methodology
What versions of Oracle are you using? I am proposing de-installing PATROL at our work place (It is the same one I took pride in installing and supporting a few years ago). Got tired of : The "next release" will support all the new features (LMTs, partitioning etc). But all these are currently in use, and so databases using those are taken out PATROL's care ! - Kirti -Original Message- Sent: Thursday, November 28, 2002 1:54 AM To: Multiple recipients of list ORACLE-L eGurkha ? Why don't companies do more DD before naming products ? The Gurkhas were special forces in the British Army, trained to DESTROY and DEMOLISH ! So, is this an electronic version of it (eGurkha) ? Not likely to score points with the Brits for installing this on their systems eh ? Toyota made a similar blunder with their MR2 in Spain, France and Portugal (pronounce the letters MR2 in any of these languages, and it sounds like Toyota Merda , yes ?). On the serious side, look at how much memory this occupies. I just came back from an engagement where BMC PAtrol was installed on a W2K server, and it consumed 900 MB of REAL memory to give a bunch of mostly meaningless information (but oh so impressive), not a pretty picture. Another thing to do is when the vendor explains all the wonderful features of what it is supposed to do, make sure you have a large shovel nearby. Then again, I have been wrong before (and not ashamed to admit it). Ferenc Mantfeld -Original Message- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 28, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Subject:Monitoring Tool Evaluation methodology We are evaluating a monitoring Tool (eGurkha) for Unix/NT/Oracle monitoring What features should be Looked into while Evaluating ? Are there any Best practices for doing this kind of Evaluation ? Any Comments on this tool in particular by any who might have used this tool ? eGurkha Monitoring Tool has the following Features :- Operating System (NT / Unix) CPU Utilization Pattern (Includes multi CPU support) Memory / Swap / Paging pattern Disk IO pattern per Partition Process Limits and Monitor Daemon processes Network Ports in use Packets Traffic Errors / Retries Congestion, Network Delays DATABASE Status - Up / Down Tablespace monitoring Datafile monitoring Locks monitoring Session monitoring Rollback Segment Monitoring Memory structures monitoring Sort Efficiency monitoring Redo Log Monitoring Oracle processes monitoring - CPU , Memory Utilized -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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: NT Memory Leak 7.3.4
Title: NT Memory Leak 7.3.4 I think that you need to check if users are terminating connections. The connections are part of the oracle.exe memory, so if the user just close his machine at the end of day it may be possible that the treads are accumulating and using memory. Yechiel AdarMehish - Original Message - From: Bowes, Chris To: Multiple recipients of list ORACLE-L Sent: Wednesday, November 27, 2002 6:44 PM Subject: NT Memory Leak 7.3.4 Hi, Does anyone know of a memory leak for Oracle 7.3.4.0 on Windows NT 4.0? A friend of mine is having to reboot monthly as the oracle73.exe grows to all of the memory on the machine when the SGA is pegged at 40M. As of today, the Oracle73.exe was at 210M and growing. They will be rebooting today. I know that the Oraclexx.exe starts less than the SGA and grows as it is used, but I haven't seen it go beyond the SGA settings. I have told him he needs to upgrade to 7.3.4.4 or 7.3.4.5. Is this good advice (they cannot go to 8)? Thank you in advance. --Chris
Test. please ignore
-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Anyone knowing about Unix groups
http://www.ugu.com - Kirti -Original Message- Sent: Thursday, November 28, 2002 2:59 AM To: Multiple recipients of list ORACLE-L Hallo, anyone whom knows about any website where you can ask questions about unix and shell-programming? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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.com -- Author: Deshpande, Kirti 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).
Test please ignore
office -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Khedr, Waleed 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).
DBA OCP, Developer OCP
Just wondering during my lunch break... Are the Developer OCP credentials comparable to the DBA OCP, in terms of validity? Regards, Patrice Boivin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J 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).
Internals: setting oracle event 10052 -turn off smon from cleaning deleted objects (bug)
Hi.. we are several months away from upgrading to 8.1.7.4 from 8.1.7.1 to resolve several oracle bugs including smons behavior of crashing when cleaning up oracle space from deleted entries in the obj$ table. In the meantime, Oracle suggested we set the 10052 event to turn of Smon from performing obj$ space cleanup. We are a four node ops cluster (HP), 3 oltp and 1 batch. Questions: 1)What kind of entries are cleaned up. 2)Is there a danger to extent management in the obj$ table of "deleted but no cleaned up entries". 3)Is it reasonable to just shut down one node once a week, restart it for 20 minutes with smon enabled during our maintenance window and restart with 10052 re-enabled? 4)Any suggestions, pointers, or folks with bad experiences using this event? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonas Rosenthal 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: IOUG 2003
sounds like then if i dont go to conference that i dont have to join, bwahahahaha happy turkey day to you US folks. joe Don Granaman wrote: I renewed my membership for 3 years at OracleWorld, so got a significant discount from the $125/year. I mentioned the registration discount for the IOUG-A live! conference registration and they said that was changing too. The person I talked to said that in the future, IOUG membership would be "automatic with conference registration". I'm not quite sure what that means if one is already in IOUG, but I suspect that it means there is no discount! Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 3:44 PM Yea $125, since i wont be attending in 2003, i'm really thinking about unjoining at that price. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa 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 policy document
Anything for developpers ? Here, I'll have to develop an Oracle developper guide to maximise developper knowledge and minimise DBA intervention ;-). I would see that fit in an Oracle policy. Also, part of our DBA stuff, we have a section called Application documentation where we have the physical data model for all applications (sometimes we have to reverse engineer ...) --- "O'Neill, Sean" <[EMAIL PROTECTED]> a écrit : > Hi Folks, > > We've recently started to partake in development of > a quality manual for our > site. Part of this will be an IT Policy Document > which will in turn have a > section on "Oracle Policy". My initial thoughts are > that it will include > sections on: > > - Security (including Audit Trails) > - Projects > - Configuration & Installation > - Data loading > - Backup & Recovery > > If anyone has a similar type of Oracle policy > document they would be willing > to share I'd appreciate it, or if you have any > constructive input as to > "areas" which should be included, or if you know of > any useful sources for > material for same pleez let me know. > > With thanks in advance :) > - > Seán O' Neill > Organon (Ireland) Ltd. > [subscribed: digest mode] > > > > This message, including attached files, may contain > confidential > information and is intended only for the use by the > individual > and/or the entity to which it is addressed. Any > unauthorized use, > dissemination of, or copying of the information > contained herein is > not allowed and may lead to irreparable harm and > damage for which > you may be held liable. If you receive this message > in error or if > it is intended for someone else please notify the > sender by > returning this e-mail immediately and delete the > message. > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: O'Neill, Sean > 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). > = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= 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: LONG's
Can you explain a little about SAP cluster/pool? They are going to put SAP in our system and anything I can learn beforehand will be welcome. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Tuesday, November 26, 2002 7:42 PM > Ah, I missed that it was SAP. > > Yeah, they don't like you mucking about with their schema. > > I would like to see their cluster/pools go *away*! > > They are a major pain at times. > > Jared > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/26/2002 07:54 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > cc: > Subject:RE: LONG's > > > > Thanks all for the suggestions. I think I'll take a look at COPY and the > PL/SQL options since I've used them before, and C & Perl are not in my > repertoire, I'm ashamed to say ;) To shed a little more light on the > requirement, I'm researching the best (subjective) way to convert > dictionsry-managed TS's to locally-managed in an 8.1.7.3, Tru64 hosted DB > running SAP R/3. The convert-in-place procedure > [dbms_space_admin.tablespace_migrate_to_local] does not change extent > management for the segment. > > Jared, I'd consider converting them, but SAP is a little posessive of > their > Clusters/Pools. > > Mike H. > > -Original Message- > Sent: Monday, November 25, 2002 6:39 PM > To: [EMAIL PROTECTED] > Cc: [EMAIL PROTECTED] > > > Mike, > > Conner pointed out that you could use C. > > You can also use Perl with DBI and DBD::Oracle if you like, and have > someone there that can use it. > > Why not just convert them to CLOB and LOB? > > Jared > > > > > > "Hand, Michael T" <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 11/25/2002 07:59 AM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:LONG's > > > OK, so you can't CTAS on tables with LONG or LONG RAW columns, and now I > find out that the same restriction exists on Alter Table ... Move. So, > is there any other option to move these tables from one tablespace to > another without exp/imp or converting them to LOB? > > Thanks, > Mike > > This transmission is intended only for use by the addressee(s) named > herein and may contain information that is proprietary, confidential > and/or legally privileged. If you are not the intended recipient, you are > hereby notified that any disclosure, copying, distribution, or use of the > information contained herein (including any reliance thereon) is STRICTLY > PROHIBITED. If you received this transmission in error, please immediately > > contact the sender and destroy the material in its entirety, whether in > electronic or hard copy format. Thank you. > > > > +**+ > This transmission is intended only for use by the addressee(s) named > herein and may contain information that is proprietary, confidential > and/or legally privileged. If you are not the intended recipient, you are > hereby notified that any disclosure, copying, distribution, or use of the > information contained herein (including any reliance thereon) is STRICTLY > PROHIBITED. If you received this transmission in error, please immediately > contact the sender and destroy the material in its entirety, whether in > electronic or hard copy format. Thank you. > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Hand, Michael T > 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.com > -- > Author: > 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.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, Califo
Re: IOUG 2003
I renewed my membership for 3 years at OracleWorld, so got a significant discount from the $125/year. I mentioned the registration discount for the IOUG-A live! conference registration and they said that was changing too. The person I talked to said that in the future, IOUG membership would be "automatic with conference registration". I'm not quite sure what that means if one is already in IOUG, but I suspect that it means there is no discount! Don Granaman [OraSaurus] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, November 27, 2002 3:44 PM Yea $125, since i wont be attending in 2003, i'm really thinking about unjoining at that price. joe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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- mailx option
-r option of mailx provides you a way to specify reply to address. Thanks Shaleen - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 6:18 AM > --=_MAILER_ATTACH_BOUNDARY1_2002112841948211540383426 > Content-Type: text/plain; charset=us-ascii > > Hi Gurus, > > > This is slightly off the subject. > > > Here I am trying to automate one report and send it to group of DBAs via mail > > > I am using mailx. I am not able to find out the option of setting sender's name and reply-to address. I searched the man pages but couldn't find it. Currently I am doing this. > > > $ report.sh | mailx -s "Daily Report" address1 address2 > > > My requirement is that the person will be receive this mail should see my name in the 'from' column and if the person reply to the mail, reply should come to my personal address. > > > Can sombody help. > > > ~Dilip > > > > > > > > > > Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com > Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in > > --=_MAILER_ATTACH_BOUNDARY1_2002112841948211540383426 > Content-Type: text/html; charset=us-ascii > > Hi Gurus, > This is slightly off the subject. > Here I am trying to automate one report and send it to group of DBAs via mail > I am using mailx. I am not able to find out the option of setting sender's name and reply-to address. I searched the man pages but couldn't find it. Currently I am doing this. > $ report.sh | mailx -s "Daily Report" address1 address2 > My requirement is that the person will be receive this mail should see my name in the 'from' column and if the person reply to the mail, reply should come to my personal address. > Can sombody help. > ~Dilip > > > > Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com";>http://email.indiatimes.comBuy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in";>http://www.planetm.co.in > > --=_MAILER_ATTACH_BOUNDARY1_2002112841948211540383426-- > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: dilip7772002 > 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.com -- Author: orafaq 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: The future DBAs?
Detailed plan for transition from order clerk to DBA: OCP How to become an order clerk: More difficult (no certification exams... yet!) Don Granaman [certifiable OraSaurus & reluctant OCP] - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, November 25, 2002 11:23 PM Wow! Do they offer a detailed plan for your career path from taking orders at LL Bean to storage/networking/data modeling/computer wrangling /SA intimidating/Managerial confusing/Vendor chucking/scripting god/ put-together-an-entire-infrastructure-during-a-break/space eating/ caffeine freaking/Scotch guzzling guru? What I wanna know is, "How do I become an order clerk?" Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman 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).
OT- mailx option
Hi Gurus, This is slightly off the subject. Here I am trying to automate one report and send it to group of DBAs via mail I am using mailx. I am not able to find out the option of setting sender's name and reply-to address. I searched the man pages but couldn't find it. Currently I am doing this. $ report.sh | mailx -s "Daily Report" address1 address2 My requirement is that the person will be receive this mail should see my name in the 'from' column and if the person reply to the mail, reply should come to my personal address. Can sombody help. ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com Buy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in --=_MAILER_ATTACH_BOUNDARY1_2002112841948211540383426 Content-Type: text/html; charset=us-ascii Hi Gurus, This is slightly off the subject. Here I am trying to automate one report and send it to group of DBAs via mail I am using mailx. I am not able to find out the option of setting sender's name and reply-to address. I searched the man pages but couldn't find it. Currently I am doing this. $ report.sh | mailx -s "Daily Report" address1 address2 My requirement is that the person will be receive this mail should see my name in the 'from' column and if the person reply to the mail, reply should come to my personal address. Can sombody help. ~Dilip Get Your Private, Free E-mail from Indiatimes at http://email.indiatimes.com";>http://email.indiatimes.comBuy Music, Video, CD-ROM, Audio-Books and Music Accessories from http://www.planetm.co.in";>http://www.planetm.co.in --=_MAILER_ATTACH_BOUNDARY1_2002112841948211540383426-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: dilip7772002 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).
Oracle policy document
Hi Folks, We've recently started to partake in development of a quality manual for our site. Part of this will be an IT Policy Document which will in turn have a section on "Oracle Policy". My initial thoughts are that it will include sections on: - Security (including Audit Trails) - Projects - Configuration & Installation - Data loading - Backup & Recovery If anyone has a similar type of Oracle policy document they would be willing to share I'd appreciate it, or if you have any constructive input as to "areas" which should be included, or if you know of any useful sources for material for same pleez let me know. With thanks in advance :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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 OS level security
Jared, Very interested in the "thread" you hypothetical raised. I'm working in a pharamceutical site which is subject to FDA and other regualtions part of which is the whole buisness of audit trails. We has a Standard Operating Procedure which states that whilst DBA's have a access to data they will not change it. A recognition of the DBA's capabilties but stating on paper company trust they will "behave" themselves. On a more practical point with NT/W2K Oracle audit trail can be set to write audit trail records to the event logs. DBA's can be prevented from changing the event logs. So now it would take at least 2 people to instigate a fraud. Hey this might foster even better relations between DBA's and SA's ;) Just my 2 cent worth :) - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] >> From: [EMAIL PROTECTED] >> Date: Tue, 26 Nov 2002 14:40:24 -0800 >> Subject: Oracle OS level security >> >>Dear list, >> >>Let me toss a hypothetical situation at you. etc. etc. This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean 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: Anyone knowing about Unix groups
do google search on '+Unix +user +group'. you get about 2M results. I am sure one will be ok for you. Next time please do this BEFORE mailing the ORACLE list. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Thursday, November 28, 2002 10:58 AM > Hallo, > > anyone whom knows about any website where you can ask questions about unix and shell-programming? > > Thanks in advance. > > Roland > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > 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.com -- Author: Yechiel Adar 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).
Anyone knowing about Unix groups
Hallo, anyone whom knows about any website where you can ask questions about unix and shell-programming? Thanks in advance. Roland -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Monitoring Tool Evaluation methodology
Hi Ferenc > Why don't companies do more DD before naming products ? The Gurkhas were > special forces in the British Army, trained to DESTROY and DEMOLISH ! So, > is this an electronic version of it (eGurkha) ? Not likely to score points > with the Brits for installing this on their systems eh ? Not at all - quite the reverse in fact. The Gurkha regiment still exists and is highly respected in the UK. The Gurkha regiment is renowned for its toughness, loyalty and tenacity. Regards Dale --- The Freeware DBATool: The easy way to generate the DDL re-creation scripts for your Oracle database + DDL to HTML conversion for instant documentation. http://www.DataBee.com/dt_home.htm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Oracle Alert
Anybody using Oracle Alert, is there a free download available for this somewhere..?
RE: Monitoring Tool Evaluation methodology
eGurkha ? Why don't companies do more DD before naming products ? The Gurkhas were special forces in the British Army, trained to DESTROY and DEMOLISH ! So, is this an electronic version of it (eGurkha) ? Not likely to score points with the Brits for installing this on their systems eh ? Toyota made a similar blunder with their MR2 in Spain, France and Portugal (pronounce the letters MR2 in any of these languages, and it sounds like Toyota Merda , yes ?). On the serious side, look at how much memory this occupies. I just came back from an engagement where BMC PAtrol was installed on a W2K server, and it consumed 900 MB of REAL memory to give a bunch of mostly meaningless information (but oh so impressive), not a pretty picture. Another thing to do is when the vendor explains all the wonderful features of what it is supposed to do, make sure you have a large shovel nearby. Then again, I have been wrong before (and not ashamed to admit it). Ferenc Mantfeld -Original Message- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 28, 2002 5:44 PM To: Multiple recipients of list ORACLE-L Subject:Monitoring Tool Evaluation methodology We are evaluating a monitoring Tool (eGurkha) for Unix/NT/Oracle monitoring What features should be Looked into while Evaluating ? Are there any Best practices for doing this kind of Evaluation ? Any Comments on this tool in particular by any who might have used this tool ? eGurkha Monitoring Tool has the following Features :- Operating System (NT / Unix) CPU Utilization Pattern (Includes multi CPU support) Memory / Swap / Paging pattern Disk IO pattern per Partition Process Limits and Monitor Daemon processes Network Ports in use Packets Traffic Errors / Retries Congestion, Network Delays DATABASE Status - Up / Down Tablespace monitoring Datafile monitoring Locks monitoring Session monitoring Rollback Segment Monitoring Memory structures monitoring Sort Efficiency monitoring Redo Log Monitoring Oracle processes monitoring - CPU , Memory Utilized -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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.com -- Author: mantfield 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 to transfer data in different NLS_CHARACTER
??? wrote: > > Dear all , > >How to transfer data from 2 oracle server with different NLS_LANG ? > > NLS_LANG=Traditional Chinese_Taiwan.ZHT16BIG5 > NLS_LANG=American_America.WE8ISO8859P1 > > Thanks in advance. > Martin Chen > Martin, Although I have of late had some interest in chinese character sets, I am still a novice at the way Oracle implements and handles them, but basically one character set has to be a superset of the other if you want things to work. If ZHT16BIG5 is the two-byte code it looks to be AND if codes 0 to 255 match the corresponding code in WE8ISO8859P1, then you can probably export from the 'western' database and import into the 'eastern' one (not the other way round). Personally I would worry about the 128 to 255 range, which contains all the various accentuated or plainly weird characters which spice up German, French, Italian, Danish, Norwegian, Swedish, Finnish, Icelandic perhaps, Spanish, and slavic languages (I hope to have forgotten nobody). If you cannot find them in ZHT, even if you do not use them, I fear that West will stay west, that east will stay east, and that the twain shall not meet, at least as far as imp and exp are concerned. I think that in that case the best you have to do is to rely on plain flat files, which you can doctor at will if needed. Then tell SQL*Loader something plausible about the character set, and it should work. -- HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult 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).