need to compare long data against varchar2
Title: need to compare long data against varchar2 I need to devise a method of comparing the TEXT column of dba_views against varchar2. End result I want to find the views that reference a particular table within its text. example (which ~obviously~ will not work): select view_name from dba_views where text like '%table_name% I understand that a query or PL/SQL procedure of this sort would be long running, but getting the concept to work would be a start. TIA
FW: need to compare long data against varchar2
Title: FW: need to compare long data against varchar2 This worked for me. I got the getlong code from a post by ORACLEtune on expertsexchange. select object_name from dba_objects where object_id in (select obj# from sys.view$ where getlong('sys.view$','text',rowid) like '%table_name%') ~~ create or replace function getlong( p_tname in varchar2, p_cname in varchar2, p_rowid in rowid ) return varchar2 as l_cursor integer default dbms_sql.open_cursor; l_n number; l_long_val varchar2(4000); l_long_len number; l_buflen number := 4000; l_curpos number := 0; begin dbms_sql.parse( l_cursor, 'select ' || p_cname || ' from ' || p_tname || ' where rowid = :x', dbms_sql.native ); dbms_sql.bind_variable( l_cursor, ':x', p_rowid ); dbms_sql.define_column_long(l_cursor, 1); l_n := dbms_sql.execute(l_cursor); if (dbms_sql.fetch_rows(l_cursor)0) then dbms_sql.column_value_long(l_cursor, 1, l_buflen, l_curpos , l_long_val, l_long_len ); end if; dbms_sql.close_cursor(l_cursor); return l_long_val; end getlong; -Original Message- From: Markham, Richard Sent: Friday, February 21, 2003 10:20 AM To: oracle-l ([EMAIL PROTECTED]) Subject: need to compare long data against varchar2 I need to devise a method of comparing the TEXT column of dba_views against varchar2. End result I want to find the views that reference a particular table within its text. example (which ~obviously~ will not work): select view_name from dba_views where text like '%table_name% I understand that a query or PL/SQL procedure of this sort would be long running, but getting the concept to work would be a start. TIA
alert log suppression
Title: alert log suppression Is it possible to suppress successful DDL within the alter log? For example, I have a cron job that coalesces 300+ tablespaces which creates a couple line entry for each. I would like to get feedback only if the DDL has actually failed. TIA
RE: Sun Solaris
Title: RE: Sun Solaris sunhelp.org for general. sunmanagers.org for critical. requires summary post and is more restrictive. -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Subject: Sun Solaris List, Does anybody know a Sun Solaris e-mail list/forum that's useful like this one is for Oracle? thanks, David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ehresmann, David 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: alert log suppression
Title: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- Markham, Richard [EMAIL PROTECTED] wrote: Is it possible to suppress successful DDL within the alter log? For example, I have a cron job that coalesces 300+ tablespaces which creates a couple line entry for each. I would like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: alert log suppression
Title: Message Thanks for the info Igor. In addition to thisI am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option),you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" [EMAIL PROTECTED] wrote: Is it possible to suppress successful DDL within the alter log? For example, I have a cron job that coalesces 300+ tablespaces which creates a couple line entry for each. I would like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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: alert log suppression
Title: Message ok good thats what I had expected, I found that the particular TS was created differently in another instance. Thanks for your time. -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 2:39 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, I have here versions 8.1.5 and 9.2. Both show allocation type "UNIFORM" for LMTs with uniform extent size (exceptLM SYSTEM and UNDO tablespaces in 9.2 , for which "SYSTEM" allocation type is shown), and allocation type "USER" for dictionary managed tablespaces. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 2:09 PM Subject: RE: alert log suppression Thanks for the info Igor. In addition to thisI am curious of how to determine that a given TS's extents are UNIFORM. dba_tablespaces shows allocation_type of user for a known UNIFORM TS. TIA -Original Message-From: Igor Neyman [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 1:30 PMTo: Multiple recipients of list ORACLE-LSubject: Re: alert log suppression Richard, If you are using UNIFORM extents (which is usually the best option),you don't need to do any coalescing on LMTs. Igor Neyman, OCP DBA[EMAIL PROTECTED] - Original Message - From: Markham, Richard To: Multiple recipients of list ORACLE-L Sent: Monday, December 16, 2002 1:00 PM Subject: RE: alert log suppression ok. They are LMT's with PCTINCREASE 0. I'm running 8.1.7.4 and I believe that SMON requires PCTINCREASE 0 to do routine coalescing.perhaps you have further to add to your post. -Original Message- From: Connor McDonald [mailto:[EMAIL PROTECTED]] Sent: Monday, December 16, 2002 12:00 PM To: Multiple recipients of list ORACLE-L Subject: Re: alert log suppression The obvious question being why you are coalescing tablespaces --- "Markham, Richard" [EMAIL PROTECTED] wrote: Is it possible to suppress successful DDL within the alter log? For example, I have a cron job that coalesces 300+ tablespaces which creates a couple line entry for each. I would like to get feedback only if the DDL has actually failed. TIA = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= 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).
sqlplus ~no~output
Title: sqlplus ~no~output for the sake of select * against a pinned table I want row output totally turned off. in the past I thought set serveroutput off, set termout off, set pagesize 0 was sufficient, but its still dumping row data on me. What have I forgotten ? TIA
RE: full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user Choudhary out of curiousity, is itunderstood that you will need todrop the same recently imported indexes from the data TS before running the import into the index TS ? or will subsequent import cause a rebuild on the incoming indexes? -Original Message-From: Choudhary Rajendra (TTL_LKO) [mailto:[EMAIL PROTECTED]]Sent: Friday, November 08, 2002 2:38 AMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user ifyou have toimport all indexes,constraints to a single tablespacethenfollowing procedurewillwork 4)After importing datachange the default tablespace to index tablespace ,ensure that no other ts quota(except index ts) is given to the schema .Grant sufficient quota on index tablespace . 5) do import with ignore=Y ,rows=no,indexes=y,constraints=y ,It will create indexes and constraints on index ts. 6) Revert back the default tablespace . Rajendra -Original Message-From: Magaliff, Bill [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: full exp/imp of user to new tablespace; same user Richard: if all of the objects are going into a single tablespace, make sure that new user has default tablespace set properly to the new TS and that s/he has a proper quota on that TS (I start with UNLIMITED). Also, make sure that user has a quota of ZERO on the TS from which the data was exported - otherwise the default import behavior will put the objects into the TS from which they were taken. Then just run the import (remembering, of course, to take all your small rollback segments offline and leave just one large rollback segment on line). If you want Indexes in a separate TS, then here's what I do: 1) set all as listed above, but make sure the user has unlimited quotas on both data and index TS 2) import data only - I use "constraints=n grants=n indexes=n" to insure it's only table data that gets in 3) import again with only the indexfile option, which will create a sql script 4) Edit the indexfile to remove stuff you don't want. . .I usemacros in my text editor to remove (in this order): ** all the lines beginning with "REM ...xRows imported" ** "REM CREATE TABLE " statements - start with that string and delete until the next semi-colon (end of the CREATE TABLE statement); these first two are for clarity only - so that I end up with a script that ONLY includes what I want, not all the other stuff, even though it's commented out. ** all remaining instances of the string "REM " (REM followed by two spaces) - this you must do to get all the ALTER TABLE statements properly. this leaves you with clean sql to just create constraints and indexes 5) do global search/replace for the index tablespace name (which is enclosed in double-quotes), putting in the name of the TS you want. 6) remove the line at the top that says "connect username" - you should connect first b4 running the script 7) save the file! 8) run the script to create all the indexes HTH bill -----Original Message-From: Markham, Richard [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
full exp/imp of user to new tablespace; same user
Title: full exp/imp of user to new tablespace; same user I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips.
RE: Out of procee memory problem ..
Title: RE: Out of procee memory problem .. what is 4,50,000 ? -Original Message- From: Satyendra K Khare [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 07, 2002 8:34 AM To: Multiple recipients of list ORACLE-L Subject: Out of procee memory problem .. This is the error message come whenever a process run in which number of rows inserted into a big table (~1400 rows/min), and when this process (called from forms) inserted around 4,50,000 entries in the table it fails and flushes the following message: ORA-04030 Out of Process memory when trying to allocate 528 Bytes (call heap , user umc) ORA-06512 at OBJ.PS_MATCH, Line 1298 ORA-06512 at line 1 PS: Down the database and up it again solve the problem but the reason is unknown to me. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satyendra K Khare 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: SPIN_COUNT - 8i obsolete? What now?
Title: RE: SPIN_COUNT - 8i obsolete? What now? additional factors: log_checkpoint_timeoutlog_checkpoint_intervalfast_start_io_target90% size of smallest redo log alter system checkpoint -Original Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 07, 2002 9:24 AMTo: Multiple recipients of list ORACLE-LSubject: RE: SPIN_COUNT - 8i obsolete? What now? log_buffer has nothing to do with log switches. Just with checkpointing and some other things I can't think of right now. Size of online redo logfiles does. Jack -Original Message-From: Denham Eva [mailto:[EMAIL PROTECTED]]Sent: donderdag 7 november 2002 14:29To: Multiple recipients of list ORACLE-LSubject: RE: SPIN_COUNT - 8i obsolete? What now? Already running on 100% caffeine_level saturation :) Maybe your right, the contention could be elsewhere, the other issue I have been investigating is LGWR process? With increasing the LOG_BUFFER from 512 to a Meg in size, as I have at times very high redo log switch, however they average about 3-4 an hour? Anyway the idea is to keep investigating. Regards Denham -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 07, 2002 1:59 PM To: Multiple recipients of list ORACLE-L Subject: Re: SPIN_COUNT - 8i obsolete? What now? Denham Eva wrote: Hello Guru's I have run a script which indicates that of the three redo log latches two had occurences of sleeps. To overcome this usually you increase SPIN_COUNT by 50% or so. When trying to ALTER SYSTEM SET SPIN_COUNT = 3000; Present system is set as 2000. I get the following error. * ERROR at line 1: ORA-25138: SPIN_COUNT initialization parameter has been made obsolete Now what? what can I do to overcome the sleeps issues? Increase caffeine_level. Seriously, is it a problem? A real bottleneck? You should begin to worry if you do not have worse contention elsewhere. -- 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). DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: full exp/imp of user to new tablespace; same user
Title: RE: full exp/imp of user to new tablespace; same user well now I can say I'm spoiled. I was given more than enough information to to accomplish the task (done) and a new tool to boot! =) Thanks alot everyone. -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 07, 2002 10:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: full exp/imp of user to new tablespace; same user And if all else fails (not that the advice already given will!), we have a tool that can manipulate the DDL for the users objects VERY quickly and easily, through a rule based change (e.g. Modify ALL tables storage clauses within USERS schema to TABLESPACE): http://www.cool-tools.co.uk/products/dbatool.html It's free, have at it! HTH Mark -Original Message- Sent: 07 November 2002 14:44 To: Multiple recipients of list ORACLE-L Extra security could be to give zero quota on other tablespaces. -Original Message- Sent: donderdag 7 november 2002 14:59 To: Multiple recipients of list ORACLE-L I have a full export of user to where I need to import all his objects/grants but into a NEW tablespace. What's the easiest way I can assure that ~everything~ is imported. Will I need to use a combination of INDEXFILE and other procedures or will a full export; drop tablespace; create new tablespace; alter user's default tablespace; full import suffice for all objects? Thanks for any tips. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: System Tablespace and Autoextend
Title: RE: System Tablespace and Autoextend I have read complaints about SYS.IDL% objects having PCTINCREASE 50 and space problems when they extend, in the forums. I went to check and mine are already set to 0 along with 2147483645 MAXEXTENTS. I created a TAR and verified with Oracle that altering storage options for sys/system objects was supported as long as they were not decreased below the defaults. The exception was that if you have a large MAXEXTENTS on the object then you could decrease PCTINCREASE or set it to 0. I have checked NEXTEXTENT values and there are some objects which aren't ready to extend but when/if they do (probably result of migration) they will consume 250mb which to me is obviously excessive. I haven't taken any action of course after all it is SYSTEM!, but PCTINCREASE of 50 on objects that have grown a couple times does inevitably invite space consumption issues at some point in the future. -Original Message- From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] Sent: Thursday, November 07, 2002 12:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: System Tablespace and Autoextend FWIW I'd go with Dennis here. I don't like AUTOEXTEND on the SYSTEM tablespace. (In fact I'm not overenamoured of AUTOEXTEND on any datfile, except maybe on dev and sandbox databases). If the SYSTEM tablespace isn't used for rollbacks (apart from the SYSTEM rollback) or temporary segments and the auditing information is written to it's own tablespace then I can't think of a set of circumstances that would cause the SYSTEM tablespace to rapidly fill up. System upgrade/migrations are the exception to this rule but in general a DBA would plan ahead for those occasions anyway. -Original Message- Sent: Thursday, November 07, 2002 4:29 PM To: Multiple recipients of list ORACLE-L I've been running with autoextend on (though limited to 2Gig) and never had a problem. -Original Message- Sent: Thursday, October 24, 2002 5:26 PM I run my SYSTEM tablesaces in autoextend, and have for some time. I run them that way from the point of database creation and have never had a problem. There were some problems with autoextend in earlier versions of 8 (and I think they managed to migrate to early 8i versions as well) with 2GB boundaries, but those have all been corrected. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration -Original Message- Sent: Thursday, October 24, 2002 4:46 PM Sam - I haven't made the system tablespace autoextend because I can't easily recover the space if it overextends. I would rather take the risk that something hits an error from a lack of space in the system tablespace. With other tablespaces you can always rebuild the tablespace if you need to. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, October 24, 2002 1:27 PM Hello All, I have heard several times that if the SYSTEM tablespace runs out of space and needs to autoextend (assuming autoextend is turned on for the data file), then you run the risk of the database crashing and of data dictionary corruption. I have never personally encountered this problem, so I have no experience on what actually does happen. I looked in metalink for documents on this, but turned up nothing. Does anybody have experience on the dangers of allowing the SYSTEM tablespace to autoextend and also any documents on Metalink or OTN that describe this problem? We are running Oracle versions 7.3.4, 8.0.5, 8.1.7, and 9.2. All our Oracle versions are running on Windows NT (or Windows 2000). Thanks for any feedback. Sam Bootsma, OCP [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) 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 DBA with SAP Needed
Title: RE: Oracle DBA with SAP Needed What does Base Salary is 55K-to maybe high 60s Firm. mean? You can throw the possibility of a raise out the window? =) -Original Message- From: OraStaff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, November 06, 2002 9:49 AM To: Multiple recipients of list ORACLE-L Subject: Oracle DBA with SAP Needed If you are an Oracle DBA With SAP experience looking for a stable company where you can work within a great team environment, this company in Toledo, Ohio is the place for you. This Fortune 500 employer has experienced steady growth over the hundred years it has been in business and is looking for a top notch candidate. This company is located in a very reasonable cost of living area and offers a varied choice of neighborhood communities. If you are looking for a place to grow within your career in a smaller city atmosphere this is the opportunity to check out. Relocation Assistance is provided. PLEASE DO NOT send your resume for this position UNLESS you have the skills outlined below for this position. DO NOT send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. *Requirements: -MUST be a team player. -3+ years Oracle DBA experience. -SAP experience -Must have experience with:Installation, Backup and recovery, Implementation, Conversion, Performance tuning, Troubleshooting, Development, Database Design, Monitoring, and Support. -MUST have excellent communications skills -Major plusses are: SQL Backtrack, DB Artisan, Powerbuilder, Shell scripting and experience with Sybase and/or SQL Server. Base Salary is 55K-to maybe high 60s Firm. The employer itself offers a comprehensive medical plan, dental insurance, life insurance, sick leave and disability plans, a retirement plan, vacation days, a 401K Plan, and much more. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: one/Toledo/DBA-SAP/Jenni I pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the position described above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re Raid 5+
Title: RE: Re Raid 5+ Jared raid 5 is good over a single disk for the read speed and the fact you can rebuild if a disk is lost. A raid 5 write includes the additional overhead of calculating parity, no question about it. My raid 1+0 spindles are faster than my raid 5 when it comes to writes. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, November 04, 2002 1:54 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re Raid 5+ I cannot fathom Raid 5 being faster than Raid 1 for writes. Well in sequential writes like redo log, copy redo log to archive log and many other cases raid 5 will be faster. Care to explain how RAID5 will be faster for a redo log write, because I don't have that understanding of it. If I'm wrong, I welcome the correction. 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).
RE: LOCALLY MANAGED TABLESPACE
Title: RE: LOCALLY MANAGED TABLESPACE Metalink Note: 93771.1 -Original Message- From: Seema Singh [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 2:49 PM To: Multiple recipients of list ORACLE-L Subject: LOCALLY MANAGED TABLESPACE Hi I am thinking to change our few dictinary manages tablespace to locally managed tablespace.Can any one experienced any issues with locally managed tablespace? Do any one experience what gain after changing to locally managed tablespace? Thx -Seema _ Unlimited Internet access for only $21.95/month. Try MSN! http://resourcecenter.msn.com/access/plans/2monthsfree.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh 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: RMAN - It's Here
Title: RE: RMAN - It's Here do list members get a I post where you post discount? =) -Original Message- From: Freeman, Robert [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 24, 2002 10:44 AM To: Multiple recipients of list ORACLE-L Subject: RMAN - It's Here Just a note that my new book Oracle9i RMAN Backup and Recovery (with co-author Matthew Hart) is out now! Enjoy! And remember, if you like it, I wrote it. If you don't like it.. hm let's see then Tim Gorman wrote it. RF Robert G. Freeman - Oracle OCP Oracle Database Architect CSX Midtier Database Administration Author of several Oracle books you can find on Amazon.com! Londo Mollari: Ah, arrogance and stupidity all in the same package. How efficient of you. -Original Message- Sent: Thursday, October 24, 2002 9:55 AM To: Multiple recipients of list ORACLE-L MIB, hey I saw that movie too. ;o) -Original Message- Sent: Thursday, October 24, 2002 8:14 AM To: Multiple recipients of list ORACLE-L Oracle SNMP Support Reference Guide has the MIBs documented. That can be found under the Oracle Enterprise Manager docs. On Wed, Oct 23, 2002 at 03:19:22PM -0800, John Kanagaraj wrote: Kevin, This is great! Can we get a list of all the OIDs that Oracle uses? Can you also let the group know if any additional plug-ins are required for Perl to work with SNMP? John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- Sent: Wednesday, October 23, 2002 3:54 PM To: Multiple recipients of list ORACLE-L Yes. You can use PERL to do such things such as getting the database state, name, consistent gets, system block gets, etc from SNMP: #!/usr/local/bin/perl use BER; use SNMP_Session; use SNMP_util; use Getopt::Std; getopts(h:i:); my($host, $community, $response, $bindings, $binding, $value, @oid, @retvals); my $session; $host = $opt_h; $community = public; $db_index = $opt_i; # Database State $oid[0] = '.1.3.6.1.2.1.39.1.9.1.1.2.2'; #Database Name $oid[1] = '.1.3.6.1.2.1.39.1.7.1.4.' . $db_index . '.7.100.98.95.110.97.109.101.1'; # Consistent Block Gets $oid[2] = 'enterprises.111.4.1.1.1.2.' . $db_index; # System Block Gets $oid[3] = 'enterprises.111.4.1.1.1.4.' . $db_index; my @retvals = SNMP_util::snmpget ( $host, @oid ); -Original Message- Sent: Wednesday, October 23, 2002 5:20 PM To: Multiple recipients of list ORACLE-L Thanks Dennis, Gary I have tools at my disposal to monitor the db, and I have no problem with that. I was just reading through snmp and was intrigues by the idea that I could get some information without running scripts through sqlplus interface and if so how to accomplish that. I know it is doable because IA does that, just wondering if it would be feasible to do it be some scripting ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Wednesday, October 23, 2002 6:04 PM To: Multiple recipients of list ORACLE-L Raj - I'm no expert on SNMP, so maybe someone that is more knowledgeable will reply. I believe that SNMP underlies most of the monitoring tools on the market today. OEM may even use SNMP. I can see two approaches for you. 1. You write your own tool that will issue SNMP alerts. Perhaps this would be a Unix daemon process that executes database queries, and then based on what it finds, issues SNMP alerts. 2. Use an existing tool to accomplish what you want. If your desire is to create a database monitoring tool that you can give away for free, then sell to CA for a lot of money, take path #1. If your goal is to become a better DBA, then I would go with #2. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, October 23, 2002 4:39 PM To: Multiple recipients of list ORACLE-L Has anyone implemented basic DB monitoring using snmp MIB information rather than running queries against the db? I am looking into this and have no clue or available docs on how to do this (esp on AIX). If someone can point me to the right direction, I would really appreciate that. TIA Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and
RE: Deploying a 6i Form to the web
is Forms 6i Server not an option? -Original Message-From: Fink, Dan [mailto:[EMAIL PROTECTED]]Sent: Wednesday, October 23, 2002 6:14 PMTo: Multiple recipients of list ORACLE-LSubject: Deploying a 6i Form to the web One of our developers (not a duhveloper) has asked if I know how (step by step instructions) to deploy a 6i form to the web. He has only found theoretical info and needs more hands on info. I have no clue (unless it can be done using UNDO internal structures...) Any websites, books, presentations, etc. are greatly appreciated... Dan Fink
RE: oraperf comment
I'm a little confused when one is talking about putting indexes and tables into seperate TABLESPACES and the other is talking about seperate DISKS. To any extent, I cant imagine how seperating IO typesacrossphysical controllers could be anything but rewarding. Yet, splitting across "DISKS" and splitting across "SPINDLES" are two different concepts. You have striping so you can benefit from more heads to do more IO and you'll only benefit morewithhaving more spindles, ~again~, to handle more IO. Splitting these across multiple spindles has proven performance gains for me andI think the "Never split index and data files to different sets of disks." has a bit of ~a CACHE will solve everything mentality~ (no pun intended). ORACLE will feast on a disk cache especially with 11i applications, butthats not to say it doesn't help. Please correct me as i'm looking for guidance. =) -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 5:44 AMTo: Multiple recipients of list ORACLE-LSubject: Re: oraperf comment Hello Tim I beg to differ. Without raid it is better to put indexes and tables on different disks and controllers. This way Oracle can do I/O to a table for user A while doing I/O to the index for user B. It is better if you can find the high I/O areas of the database and split them across disks, but as a rule of thumb splitting indexes and tables make sense (again - when you work without raid). Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 12:39 AM Subject: Re: oraperf comment Ray, I don't know exactly what was intended with the comment, but I agree with your interpretation. --- As far as any other reasons for the comment... RANT In terms ofmyths that have persisted with Oracle over the years, the ideathat some performance benefitexists from I/Oparallelism due to separating tables and indexes to different devices has been especially persistent. I've even heard it described as "conventional wisdom". As a matter of fact, there is no possibility for "parallelism" benefits on indexed I/O operations. Never has been;might neverbe (though "never" is a long time)... /RANT The reason is that navigating a B*Tree index structure is inherently sequential. Think about it -- first you have to access the "root" block. Looking inside the contents of the "root" directs you to the next "branch" or "leaf" block in the index B*Tree structure.You cannotseek for the next block in parallel; you've got to look inside one block in order to know what block to access next. Then, once you've accessed down to the final "leaf" block, reading its contents tells you which row in the table to access. If you are doing a "range scan" operation, then you have to go back to the index "leaf" block in order to find the next table row to access. The name of the wait-event forthis type ofI/O (a.k.a. "db file sequential read", a.k.a. single-block random-access read)also suggests this "sequentialiality" (is thata word?). Jeff Holt wrote a great paper on the reasons for the apparent mis-naming of the wait-events "db file sequential read" and "db file scattered read" -- I'm sure that it is downloadable from http://www.hotsos.com. Even when "asynchronous I/O" is available and configured, indexed I/O operations are still essentially synchronous (and non-parallel)... There is a possibility of some form of "parallelization" in "range-scan" operations, but there is no evidence that this is happening. For example, while performing an indexed range-scan,if we wanted to read a batch of index entries from the index "leaf blocks" and submit a list of I/O requests for data blocks on the corresponding table, we could do so. However, when I've performed "truss" operations on an Oracle server process performing such a range-scan operation (at least through Oracle8i), I've not seen this happening. Purely generic "read()" operations, one at a time, sequentially... --- The only real advantages of separating tables from indexes into different tablespaces are: different recoverability requirements indexes can be rebuilt instead of restored data(tables and clusters)must be restored -- cannot be "rebuilt" from anything different types of I/O requests indexes are predominantly accessed using single-block, random read I/O (i.e. UNIQUE scans, RANGE scans, FULL scans) relatively seldom are accessed with multi-block sequentially-accessedread I/O
RE: oraperf comment
Tim, point well said. Thank you. -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Tuesday, October 22, 2002 11:15 AMTo: Multiple recipients of list ORACLE-LSubject: Fw: oraperf comment ...resending, as the original send encountered some kind of "locking problem" at fatcity... - Original Message - From: Tim Gorman To: [EMAIL PROTECTED] Sent: Tuesday, October 22, 2002 6:35 AM Subject: Re: oraperf comment Why?What are the chances of preciselythat scenariohappening, as opposed to Oracle doing concurrent I/O to tables for both users A and B? Or to indexes for both users A and B simultaneously? Splitting tables and indexes into separate tablespaces makes sense, but mainly for recovery purposes. This has little to do with the placement of the datafiles of those tablespaces ondevices(non-RAID or RAID). Generally, indexes tend to cache extremely well in Oracle (because they are more compact and because of the nature of the I/O), so they usually don't get as much physical I/O as tables. Check V$FILESTAT on a busy application to prove it for yourself... After seeing this performance data, why would you place a datafile/tablespace which only gets a small amount of I/O on one device while placing a much busier datafile/tablespace onto another device, just because one contains indexes and the other tables? Please think in terms of I/O counts, not poorly-conceived but oft-repeated "conventional wisdom". Keep indexes and tables segregated to different tablespaces, but for decisions on placement of datafiles upon devices, use empirical performance data only. - Original Message - From: Yechiel Adar To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 3:43 AM Subject: Re: oraperf comment Hello Tim I beg to differ. Without raid it is better to put indexes and tables on different disks and controllers. This way Oracle can do I/O to a table for user A while doing I/O to the index for user B. It is better if you can find the high I/O areas of the database and split them across disks, but as a rule of thumb splitting indexes and tables make sense (again - when you work without raid). Yechiel AdarMehish - Original Message - From: Tim Gorman To: Multiple recipients of list ORACLE-L Sent: Tuesday, October 22, 2002 12:39 AM Subject: Re: oraperf comment Ray, I don't know exactly what was intended with the comment, but I agree with your interpretation. --- As far as any other reasons for the comment... RANT In terms ofmyths that have persisted with Oracle over the years, the ideathat some performance benefitexists from I/Oparallelism due to separating tables and indexes to different devices has been especially persistent. I've even heard it described as "conventional wisdom". As a matter of fact, there is no possibility for "parallelism" benefits on indexed I/O operations. Never has been;might neverbe (though "never" is a long time)... /RANT The reason is that navigating a B*Tree index structure is inherently sequential. Think about it -- first you have to access the "root" block. Looking inside the contents of the "root" directs you to the next "branch" or "leaf" block in the index B*Tree structure.You cannotseek for the next block in parallel; you've got to look inside one block in order to know what block to access next. Then, once you've accessed down to the final "leaf" block, reading its contents tells you which row in the table to access. If you are doing a "range scan" operation, then you have to go back to the index "leaf" block in order to find the next table row to access. The name of the wait-event forthis type ofI/O (a.k.a. "db file sequential read", a.k.a. single-block random-access read)also suggests this "sequentialiality" (is thata word?). Jeff Holt wrote a great paper on the reasons for the apparent mis-naming of the wait-events "db file sequential read" and "db file scattered read" -- I'm sure that it is downloadable from http://www.hotsos.com. Even when "asynchronous I/O" is available and configured, indexed I/O operations are still essentially synchronous (and non-parallel)... There is a possibility of some form of "parallelization" in "range-scan" operations, but there is no evidence that this is happening. For example, while performing an indexed range-scan,if we wanted to read a batch of index entries from the index "leaf blocks"
RE: Archive files and their Management
Title: Archive files and their Management I'm up for my backup and recovery class here soon, butthis conversation has brought up questions that I think some of you wouldn't mind discussing anyway. I see whereimplementing archive logs requires that youmodify the database startup procedure to turn on archiving before opening the database.At thispoint the DBA should do an immediate "baseline"backup (orafaq =)) which implies a hot/online backup.I amcurious how thisgoes with point in timecold backups. ie.DBA does a cold backup opens the database in archive log mode.Can you apply accumulated archive logsto a restore fromcold backup ?perhaps there are issues with the control file information. -Original Message-From: Naveen Nahata [mailto:[EMAIL PROTECTED]]Sent: Friday, October 18, 2002 7:53 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Archive files and their Management theoretically only the archive files after the backup started are needed. but there might be issues of a corruptedbackup, and to guard against that we have a policy of keeping archive files for one week. you should also keep checking your backups by restoring them to a separate location periodically regards Naveen -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Friday, October 18, 2002 4:49 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Archive files and their Management Our policy is to keep archive for the last 2 days at least. We are doing daily backup so it gives us the option to restore from the last backup or the one before without restoring archive logs. Yechiel AdarMehish - Original Message - From: Denham Eva To: Multiple recipients of list ORACLE-L Sent: Friday, October 18, 2002 12:28 PM Subject: Archive files and their Management Greetings Gurus Just wondering... Our archive log's directory has grown substantially and space is becoming an issue. How do you know which archive files is safe to delete? In other words... Do you delete all archive files older than the last backup? Should you keep all archive files until it is obviously pointless? Please advise. Many thanks Denham Eva Oracle DBA "UNIX is basically a simple operating system, but you have to be a genius to understand the simplicity." Dennis Ritchie. DISCLAIMER This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. TFMC, its holding company, and any of its subsidiaries each reserve the right to monitor and manage all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be views of any such entity. This e-mail message has been scanned for Viruses and Content and cleared by MailMarshal - For more information please visit www.marshalsoftware.com
RE: Archive files and their Management
Title: RE: Archive files and their Management ok thanks for the info. The following was MISLEADING: http://www.orafaq.com/faqdbabr.htm Section: How does one put a database into ARCHIVELOG mode? To enable ARCHIVELOG mode, simple change your database startup command script, and bounce the database I took that as every startup would need to include the new commands. -Original Message- From: Jay Hostetter [mailto:[EMAIL PROTECTED]] Sent: Friday, October 18, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: RE: Archive files and their Management I'm not quite sure what you mean by modify the database startup procedure. You must be in MOUNT mode to change between archive and noarchive. You don't need to change the mode each time you startup you database. Once you put a database in archivelog mode, you are in that mode until you change it - no matter how many startup/shutdowns you do. It doesn't matter if you have a cold vs. hot backup. As long as you have database backup and all of your archivelogs, you can do a point-in-time recovery from that backup until your last archivelog. Jay [EMAIL PROTECTED] 10/18/02 12:09PM I'm up for my backup and recovery class here soon, but this conversation has brought up questions that I think some of you wouldn't mind discussing anyway. I see where implementing archive logs requires that you modify the database startup procedure to turn on archiving before opening the database. At this point the DBA should do an immediate baseline backup (orafaq =)) which implies a hot/online backup. I am curious how this goes with point in time cold backups. ie. DBA does a cold backup opens the database in archive log mode. Can you apply accumulated archive logs to a restore from cold backup ? perhaps there are issues with the control file information. -Original Message- Sent: Friday, October 18, 2002 7:53 AM To: Multiple recipients of list ORACLE-L theoretically only the archive files after the backup started are needed. but there might be issues of a corrupted backup, and to guard against that we have a policy of keeping archive files for one week. you should also keep checking your backups by restoring them to a separate location periodically regards Naveen **DISCLAIMER This e-mail message and any files transmitted with it are intended for the use of the individual or entity to which they are addressed and may contain information that is privileged, proprietary and confidential. If you are not the intended recipient, you may not use, copy or disclose to anyone the message or any information contained in the message. If you have received this communication in error, please notify the sender and delete this e-mail message. The contents do not represent the opinion of DE except to the extent that it relates to their official business. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jay Hostetter 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 zip a file on From Unix shell script
I'm curious how you get sendmail/mailx to send a file as an attachment? I suppose it can be done. -Original Message-From: Tim Gorman [mailto:[EMAIL PROTECTED]]Sent: Thursday, October 17, 2002 11:59 AMTo: Multiple recipients of list ORACLE-LSubject: Re: How to zip a file on From Unix shell script you can download it at http://www.gnu.org/software/gzip/gzip.html... - Original Message - From: WLSH To: Multiple recipients of list ORACLE-L Sent: Thursday, October 17, 2002 9:34 AM Subject: Re: How to zip a file on From Unix shell script Thanks, all: We have compress available currently, but not gzip or zip. We will try compress. Mark Richard [EMAIL PROTECTED] wrote: RWB is correct - and the good news is that WinZip (a likely program at thedestination of your email) handles tar-ed and compress-ed files fine. Ofcourse it may pay to add the .zip extension to the filename so that themail client knows what to do with it.Reginald.W.Bailey@jp morgan.com To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Sent by: cc: [EMAIL PROTECTED] Subject: Re: How to zip a file on From Unix shell script 17/10/02 09:38 Please respond to ORACLE-L You can use compress or gzip to compress a file. compress -v [filename]should compress the file and tell you the percentage as well. Gzip is a GNUutility that may be on your system. These utilities may not be in yourcurrent path.RWBWLSH <[EMAIL PROTECTED]>@fatcity.com on 10/16/2002 0! ! 5:43:33 PMPlease respond to [EMAIL PROTECTED]Sent by: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>cc:Hello, list:We have a unix nightly job which will send an email to a user. However, thefile size is very large, so we need to zip the file before we send it out.Does anyone know the syntax or command of zipping a file from UNIX ?Regards,[EMAIL PROTECTED]Do you Yahoo!?Faith Hill - Exclusive Performances, Videos, morefaith.yahoo.com--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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mai! ! ling list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Privileged/Confidential information may be contained in this message.If you are not the addressee indicated in this message(or responsible for delivery of the message to such person),you may not copy or deliver this message to anyone.In such case, you should destroy this message and kindly notify the senderby reply e-mail or by tele! ! phone on (61 3) 9612-6999.Please advise immediately if you or your employer does not consent toInternet e-mail for messages of this kind.Opinions, conclusions and other information in this messagethat do not relate to the official business ofTransurban City Link Ltdshall be understood as neither given nor endorsed by it.-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Mark RichardINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services--! ! ---To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Regards,[EMAIL PROTECTED] Do you Yahoo!?Faith Hill - Exclusive Performances, Videos, morefaith.yahoo.com
SNP acronym?
Title: SNP acronym? What does the background job queue acronym SNP stand for ?
RE: OEM can't seem to discover 1 instance
Title: RE: OEM can't seem to discover 1 instance John I had the same issue recently where before the same instance had been discovered. I had deleted the node after having removed one instance from the server. Before it discovered all three and now it discovers only one of two. Go figure. I have temporarily resorted to a manual configuration for this instance for the time being. -Original Message- From: John Weatherman [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 5:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: OEM can't seem to discover 1 instance It is in the oratab. I have cycled several times John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 17, 2002 4:50 PM To: Multiple recipients of list ORACLE-L Are there entries in your oratab for this instance? After adding this entry, if not there, recycle the IA and try again. Phil Wilson ([EMAIL PROTECTED]) DBA, Operations Group SkillSoft, Learning Solutions for the Human Enterprise 506.462.1124(w) 506.447.0334(c) -Original Message- Sent: Thursday, October 17, 2002 5:11 PM To: Multiple recipients of list ORACLE-L Anybody seen anything like this? I am running 9.2.0.1 OEM auto discovery. The Intelligent Agent is running on the target node. For some reason, it seems unable to discover 1 instance, the other 3 on that node are found. TNS seems ok, I can connect to the instance from other boxes without any difficulty. I have removed the snmp_ro.ora and recycled the IA, Management Server, etc. Still can't find this instance. It is finding 9i (r1 and r2) instances. This is an 8i instance (8.1.7.4) but I don't think that's it, as the development version on another node is found just fine. TIA, John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 17, 2002 2:47 PM To: Multiple recipients of list ORACLE-L Yes, there is. You might notice that someone has issued a create database command because all of your data will be gone fishing. When the noise level reaches 500 decibels, someone has issued CREATE DATABASE command on your production database, which, of course, no longer exists. System accounting should be able to tell you who has logged in as oracle and from which PC. Then you go and publicly execute that person by beating him to the pulp with a baseball bat (so called Soprano method) -Original Message- From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 17, 2002 12:42 PM To: Multiple recipients of list ORACLE-L Subject: auditing CREATE DATABASE Is there a way of capturing info on people who issue CREATE DATABASE statements? My Oracle Support technician says auditing won't catch this, only catches successful attempts. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- 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: Gogala, Mladen 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: John Weatherman 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
RE: stupid RMAN question
Joe are you on UNIX? you could pipe the stdout to a program called tee -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 11:14 AMTo: Multiple recipients of list ORACLE-LSubject: stupid RMAN question Ok i've been thru all of the 817 docs multiple times, searched metalstink, read the chapters in backup/recovery 101 multiple times. Where in the heck is the "spool" command for rman? Can i only spool stuff(and its an either to a file or to the screen, not both?) using the log parameter when starting rman. if I've started rman with out the log parm, there is no way to open a spool file? I'm currently stuck on 817 rman if that makes a difference. thanks, joe
RE: Phew ... Finally Migrated
Title: Phew ... Finally Migrated I appreciate the feedback Raj. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Monday, October 14, 2002 11:24 AMTo: Multiple recipients of list ORACLE-LSubject: Phew ... Finally Migrated Over the weekend we migrated all our production systems on 9201 on AIX. I know it is not all that important, but thought I'd let everyone know. I also learned the magic of commit=y/n setting on imp. I have one table (it had a long column) that was taking 6600 seconds to import with commit=y. After looking up Metalink, I changes the commit=y to commit=n, the same import finishes in 1010 seconds. I have 14G of undo tablespace, so I changed commit=n for import on all tables with long columns ... the time for import was reduced dramatically. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art!
RE: 8.1.7.2 or 8.1.7.4
Title: RE: 8.1.7.2 or 8.1.7.4 Vaidya I'm running 8.1.7.2 on all instances when I go to upgrade it will probably be 9iR2 starting with a test db, then from there, onto the least important db upwards. Of course I'm stalling to let all the venturous customers test thease new realeases (and abundantly advancing I might add) out for me =). I haven't had an issue where I couldn't get support because I wasn't at .3 or .4, nor has an issue arose in .2 that left me no choice to upgrade... -Original Message- From: Rachna Vaidya [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: 8.1.7.2 or 8.1.7.4 Which patch is recommended? Which is more stable? Obvious answer from Oracle Support was 8.1.7.4 for the reason that it was latest. But some of my friends have advised 8.1.7.2 Any opinions? Thanks, -Rachna -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachna Vaidya 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: Advice needed on move to Sun 15K (losing spindles)
Title: RE: Advice needed on move to Sun 15K (losing spindles) Lets say a guy only has one finger on each hand to tie his shoe (mirroring). If he had five fingers (striping) he can accomplish the job quite a bit faster. Now give him 1000 shoes to tie and listen to him bitch about how he could use a work partner (spindle). Now give him the ability to lie so when management asks the team many shoes they have tied, they can stretch the truth a little bit (cacheing) =) -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Friday, October 11, 2002 2:46 PM To: Multiple recipients of list ORACLE-L Subject: RE: Advice needed on move to Sun 15K (losing spindles) I've cussed and discussed the topic of one big stripe versus multiple small stripes with different people and have yet to come across anyone who has conducted a real test of various scenarios. If you stripe across all disks, then you have the advantage of guaranteed, perfectly balance I/O -- there's certainly something to be said for that! But, then you have a mix of reads and writes going across all drives too. A good argument can be made for taking those parts of the database that tend to be only one kind of operation -- for example, archive logs are writes -- and putting them in their own area. So the drives handling the writing of archived logs are doing only one kind of operation (or are they?!), but you subtract from the drives allocated for other operations. But then there is the issue of: Just exactly how do hard drives work? For example, when doing a large write only operation (like creating an archived log) is the drive really doing this neat and tidy write only, one track after the next, each track right beside the other? Or does the drive actually write a little bit, read a little bit (like a check sum or verify operation), then write some more. And when writing, does it do this smooth, nicely contiguous write, all in one operation? Or does it write a little bit (like an OS buffer full), then move to a different track to update an allocation table (then perhaps read the allocation table), then perhaps go pick up a timing mark, etc.? I suspect some of the answer is dependent on the number of drives and controllers available. (And I must say, that when I read your original question, I wondered why on earth would an organization ready to drop a bundle on a 15K be scrounging for drives -- if I interpreted your post correctly. Is this a Dilbert sort of thing?) The only time I have striped across all drives was the only time I was in a position to make that decision. This was a few years ago, and it was when I did Solaris/AIX admin. It was on a Sparc 4500 with 6 250Mhz CPU's. Since we did not have an Oracle DBA, and I didn't have the time or inclination to devote to setting up and maintaining and official OFA compliant structure, I just made one giant (considered giant at the time) 250 Gb filesystem that would hold all things Oracle and be done with it. I made two 30-drive (8.4 Gb drives) stripes and mirrored them using Solstice Disk Suite. There were 10 wide scsi controllers. Each controller had a 6-drive JBOD attached to it. An eleventh controller had an additional JBOD to be used for hot spares. As you might guess, with a I/O pipe this big, there was no way the 6 CPU's could generate enough I/O to bog things down or even cause a hint of an I/O wait. So the stripe across all drives does work. In my case, I had 60 drives on 10 controllers to work with. Could this have been made more efficient by making a collection of smaller stripes? I have never found anyone who could answer that. The Disk Suite folk can tell you that there is an optimal striping configuration for Disk Suite if we leave Oracle out of the picture. But with Oracle in the picture, who knows? One configuration that sounds reasonable is to put data files with random reads and writes on one stripe, put even numbered redo logs on a stripe, put odd numbered redo logs on a stripe, put archived logs on a stripe. The reasoning (or arm-chair theory) behind the even/odd redo logs is that at a log switch, one file system can be doing writes, while the other is doing reads for the log archiving. This is sorta kinda the way we do things at our shop here with some modifications depending on the app -- like maybe dedicate a stripe to servicing the outrageous temp requirements of a data warehouse (more correctly, a data landfill). If you have only a few drives, my inclination (with no proof whatsoever) is that the one big stripe approach might be a good idea. Thus far, all I have ever gotten on this subject is a lot of religion and very few proven facts. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services
RE: Is it possible to copy one db to another if the SID is differ
Title: RE: Is it possible to copy one db to another if the SID is differ or consider note: 174625.1 -Original Message- From: Stephen Lee [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 09, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Subject: RE: Is it possible to copy one db to another if the SID is differ One thing to keep in mind (If I recall correctly): If you are using rman repository, the database ID (DBID) of the copied database will be the same as the old database. You will have to create a second schema in the repository if you plan on backing up both the new and the old databases using the same catalog database. -Original Message- Qn : Is it possible to copy one database to another if the source database name is different from the target database name ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee 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 place in the business (was RE: DBA work load)
Title: RE: DBA place in the business (was RE: DBA work load) you can write down the known heiarchy, then encompass that within a circle. add a picture of the DBA holding the sphere in his hand or better yet if you really want to get creative, place it on his back and have him poised like Atlas. There should be a minimum of 1,000 words in that picture =). -Original Message- From: IT - Database (Do Not Use) [mailto:[EMAIL PROTECTED]] Sent: Monday, October 07, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Subject: RE: DBA place in the business (was RE: DBA work load) We have a similar structure Infrastructure - DBA - Sys Admin - Network Admin -Original Message- Sent: Sunday, September 29, 2002 7:53 AM To: Multiple recipients of list ORACLE-L Hello Peter We have an infrastructure division that divides into two departments: system programming and DBA. Organization chart for us will be: CEO - CIO - Infrastructure - DBA. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, September 26, 2002 11:13 AM I've found the thread on DBA workload valuable and interesting. It endorses points made repeatedly over the past years, basically the highly variable nature of the job. This variability is giving us a small problem. Our dba work (shared between two of us) tends to function in the background, and of course because we do it so damn well (!!), our impact on the running of the organisation is pretty low. Kind of 'reverse exception' effect, if you will. There is now a desire to formalise the role of the dba function within the organisation, and nobody has the first idea of how to define, in an organisational / structural sense just how the dba role slots in. I'm talking about organsiational charts, herarchies etc, that sort of thing. Not just across the org, but particularly within the IT domain too. Specifically, dba impacts from the low-level hardware side, right up to application development, with everything in between. And that already spans several existing lines of management responsibility. Our problem has added spice as we are (trying) to operate a matrix management system, which repeatedly throws up intriguing political dimensions. Anybody ever been down this particular route? Any thoughts much appreciated, peter edinburgh * This e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments. http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robson, Peter 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: IT - Database (Do Not Use) 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
RE: Backups
Title: RE: Backups It would be interesting to see how you would explain how either cp or dd (which know nothing of archive log mode, or the concept of hot backup, itself, none the less) is going to keep things consistent, when these utilities themselves are for point in time operations. -Original Message- From: John Weatherman [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L Subject: RE: Backups This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands 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: Ron Rogers 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: Ruth Gramolini 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: John Weatherman 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
RE: RE: Backups
Title: RE: RE: Backups Yes I personally run Veritas Netbackup for both cold and RMAN. A fiber SAN has its added benefits as well =). I have never really explored the implications of these other utilities. My head filled with many distasteful visuals. Yes, I agree with you and I realize that I am spoiled knocking on wood. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, October 03, 2002 1:38 PM To: Markham; Richard; Multiple recipients of list ORACLE-L Subject: Re:RE: Backups I've used cpio, dd, and fbackup to do hot and cold backups before, but never again. With those utilities the burden of keeping track of what is on which tape rests with you and normally a stubby pencil pad of paper because you know what won't be available when you need to do a recovery. They do work be assured, but the administrative overhead is just not worth it anymore, even for a small shop. Get a copy of Veritas or OmniBack or some other software package that does library management for you and preferably integrates with RMAN. Life can be so much easier!! Dick Goulet Reply Separator Subject: RE: Backups Author: Markham; Richard [EMAIL PROTECTED] Date: 10/3/2002 10:03 AM It would be interesting to see how you would explain how either cp or dd (which know nothing of archive log mode, or the concept of hot backup, itself, none the less) is going to keep things consistent, when these utilities themselves are for point in time operations. -Original Message- Sent: Thursday, October 03, 2002 12:18 PM To: Multiple recipients of list ORACLE-L This doesn't sound right. Put the database in hot backup mode, backup (whether using cp to a staging point like the poster here is doing or straight to tape using dd or dump or some other utility), come out of hot backup mode. Why wouldn't you be able to recover? John P Weatherman Database Administrator Replacements Ltd. -Original Message- Sent: Thursday, October 03, 2002 10:18 AM To: Multiple recipients of list ORACLE-L If you want to be able to use any OS backup for restore/recovery that database must be closed when you do the backup. If it is not, you won't be able to recover. Just a thot, Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 03, 2002 9:08 AM Robyn, We used the DD method on pre 7.1 oracle with RAW devices. It worked fine except that it used a lot of tape dumping a raw device when only a small portion was used. Using a dd command to place a copy of the data on tape should not be a problem if a restoral is needed. The dd function is just another OS method of copying data to a tape. I don't know for sure but I think there might be some issues about transportability of the dd tape. Other users will know about the transportability issues. Ron ROR mª¿ªm [EMAIL PROTECTED] 10/02/02 08:08PM Hello, I need some info about backups. I am working on a customer site, and have implemented both exports and hot backups. Both jobs copy to a separate mount point, and a job scripted by another individual then moves the files to tape. Here's the problem - he's using a dd command, primarily because it provides a succinct output he can email to non-technicals. The file system is built on a 12 disk A1000 array. We've provided him with a ufsdump script, but he's doesn't want to use it. Can the system be recovered from this tape? Has anyone ever relied on a dd for a daily backup method? The system is Oracle 9i on Solaris 8. Robyn -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robyn Anderson Sands 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: Ron Rogers 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: Ruth Gramolini INET: [EMAIL
RE: how to find out the patch applied on different env.
Title: RE: how to find out the patch applied on different env. FILENAME adphrept.sql DESCRIPTION SQL script that creates a report file showing the patching history of all patches also can be used in conjuction with the following SQL, this tends to be more granular: SELECT * FROM AD_PATCH_DRIVERS WHERE PATCH_DRIVER_ID IN (SELECT PATCH_DRIVER_ID FROM AD_PATCH_RUNS WHERE PATCH_RUN_ID IN (SELECT PATCH_RUN_ID FROM AD_PATCH_RUN_BUGS WHERE ORIG_BUG_NUMBER='1' and UPPER(APPLIED_FLAG)='Y')) -Original Message- From: sesuraj m [mailto:[EMAIL PROTECTED]] Sent: Tuesday, October 01, 2002 11:58 PM To: Multiple recipients of list ORACLE-L Subject: how to find out the patch applied on different env. Dear all, I have a situation where I need to find out the patches applied on different Oracle Application 11i (11.5.5) env. We have two environment PROD and TEST. It seems that there are some patches applied to TEST in the past few months. I would like to know what patches are applied on TEST env: Database stack Application stack $APPL_TOP Technology stack (Forms, reports, Jinitiator). There is neither manual logging system where I can find the patch details nor locating the files applpatch.txt or applptch.txt on the server. Is there any other way I can easily find out the difference between those two instances in respect to patches? Thanks in advance. Michael Sesuraj OCP. _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sesuraj m 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 D.B.A. required in M.A.
Title: RE: Oracle D.B.A. required in M.A. Is it that or is it a new goal to get a developer than can play part time DBA or vice versa and reap all the benefits for the price of one? -Original Message- From: ltiu [mailto:[EMAIL PROTECTED]] Sent: Wednesday, October 02, 2002 1:15 PM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle D.B.A. required in M.A. You know what, this means the people who are hiring does not know what they are looking for. Gene Sais wrote: lol, i love #1 #2, developer but not a development dba. good luck in your search, quite a few requirements :) gene [EMAIL PROTECTED] 10/02/02 11:50AM In my company, we require Oracle D.B.A. to maintain development and production Oracle databases. This is a permanent position. Our compnay is 24 yrs. old company. Our company is situated on Route 128 in M.A. We require the candidate urgently. If interested, please send your resumes within the next two days to the following e-mail: [EMAIL PROTECTED] Following are the details for the job: Our environment: Solaris 7 and solaris 8. Databases versions: 804, 8.1.6.1, 8.1.7.3 OLTP databases and datawarehouse. Veritas File System. Middleware: Tuxedo and MQ series Quest, DataMirror - Replication products Apps: WebLogic Following is the skill set for the candidate: Following are essential requirements for an Oracle DBA. 1. Must have worked as Oracle developer at least 3 years. 2. Must have been working as Oracle DBA at least for the last 3 years in a PRODUCTION environment in 8i. (We don't want development DBA's). 3. Must have excellent knowledge in installing Oracle software and its products. Must have installed patches in his earlier job. 4. Thorough knowledge in Backup and Recovery procedures. Must be able to solve scenarios during the interview. 5. Good knowlege in Oracle tuning process. Must be able to solve scenarios during the interview. 4. Must have good knowledge in running various statistical packages like STATSPACK. 5. Excellent knowledge in shell programming and understanding of awk and sed usage. 6. Must be very familiar with Solaris 7 and higher versions. Must have general understanding of tuning/performance processes involved on Unix level. Should be able to give us various scenarious he/she faced during his career in tuning. 7. Must have good understanding of PL/SQL, SQL. 8. Must be familiar with OMS and its tools. 9. Must have thorough understanding of RAID concepts and its use in Oracle. And good knowledge on Oracle OFA methodology - -- This is must. 10. Must have good knowledge on normalization techniques. 11. Must be familiar with Oracle Standby databases and their running. -- This is essential. 12. Good communication skills and team work. Optional but would have weightage: 1. Oracle 9i knowledge 2. Oracle RAC environment experience. 3. Datawarehous knowledge and issues involved in setting up production datawarehouses 4. Understanding of Veritas 5. Knowledge about design tools like Oracle Designer/ERwin 6. Knowledge about Quest 7. Knowledge about DataMirror 8. General understanding of WebLogic 9. Understanding Tuxedo or MQM 10. Knowledge in C programing. Rao -- ltiu 3/4 OCP 9i Eh? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu 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: Degrade a database??
Title: RE: Degrade a database?? I can't think of any better way to back out of anything other than a restore from disk or tape. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 26, 2002 2:48 PM To: Multiple recipients of list ORACLE-L Subject: Degrade a database?? Hello All, We are in the process of upgrading a database from 8.0.6 to 8.1.7. The upgrade is not a problem. We have been asked to come out with a fast rollback strategy in case we have to fall back, say after a week, to the 8.0.6 database with no data loss. Any fresh ideas? Thanks Raj -- 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).
migrating 8.x-9i and charsets
Title: migrating 8.x-9i and charsets Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:If the old National Character Set is UTF8, then the new National Character Set will be UTF8. Otherwise, the National Character Set is changed to AL16UTF16. the character set at the time was AMERICAN_AMERICA.WE8ISO8859P1 which my understanding is that the character set would become AL16UTF16. I never could get the character set scanner to accept the tochar=AL16UTF16 or tochar=al16utf16 parameter(s). It would result in CSS-00115: invalid character set name AL16UTF16 or CSS-00115: invalid character set name al16utf16. I went forward with the upgrade. I would like to know if there is anything I can do to check the data after this change or did the ccscan need only need to be ran against converting to UTF8. This test database houses the 11i applications objects. TIA for any information
RE: migrating 8.x-9i and charsets
Title: RE: migrating 8.x-9i and charsets what I found odd after reading the migration manual is that the 9i upgrade database is still showing: NLS_CHARACTERSET WE8ISO8859P1 NLS_NCHAR_CHARACTERSET WE8ISO8859P1 I haven't found any issues with functionality, keeping in mind this two tier instance doesn't contain any buisness data either. Most of this questioning is derived from my lack of understanding the charsets, not knowing what warrants choosing one over the other, and well maybe the part about the conversion possibly creating truncated or expanded data. again TIA to anyone who has any input. -Original Message- From: Markham, Richard [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 25, 2002 9:28 PM To: Multiple recipients of list ORACLE-L Subject: migrating 8.x-9i and charsets Ron I was reading your response about converting to UTF8 and it has risen some curiosity with my situation and recent upgrade of a DB from 8.1.7.2 to 9.1.0.3. A snippet from the migration manual states:If the old National Character Set is UTF8, then the new National Character Set will be UTF8. Otherwise, the National Character Set is changed to AL16UTF16. the character set at the time was AMERICAN_AMERICA.WE8ISO8859P1 which my understanding is that the character set would become AL16UTF16. I never could get the character set scanner to accept the tochar=AL16UTF16 or tochar=al16utf16 parameter(s). It would result in CSS-00115: invalid character set name AL16UTF16 or CSS-00115: invalid character set name al16utf16. I went forward with the upgrade. I would like to know if there is anything I can do to check the data after this change or did the ccscan need only need to be ran against converting to UTF8. This test database houses the 11i applications objects. TIA for any information
RE: DBA work load
Title: RE: DBA work load yea I was going to add that as much as the hardware trend has demanded redundancy for failover so it would make sense that a production shop would apply that to its personnel as well. -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 10:58 AM To: Multiple recipients of list ORACLE-L Subject: RE: DBA work load just to add into the mix. it also depends on how much development is going on and if you are involved in that as well. I have 3 new applications going live next month, all brand-new databases and one project lead who doesn't understand the concept of a design spec and who keeps handing me major changes in email. If you have that, in addition to production, in a 24x7 shop, then you need help There should be at leat 2 DBAs -- what if you get sick or (as one of my bosses used to say) what if you get hit by a truck? --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: Tony - I agree with Tim. This reminds me of the practice years ago of measuring the productivity of COBOL programmers by measuring their LOC (lines of code) production. Number of instances, how large, the number of developers or end users all have an effect. But how this all works out depends on many factors that are hard to quantify. Take 24x7 for example. All my instances are 24x7. I support production plants that are running 3 shifts at times. But, knock on wood, Oracle is pretty reliable and I usually don't get called. Some of our Unix servers have been up over a year. But I wouldn't classify my 24x7 alongside some eCommerce sites where the company's revenue depends on that site being up every minute. There is a lot of difference between developers. An experienced developer you've worked with for many years won't need the detailed assistance that a new developer will. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Monday, September 23, 2002 8:43 PM To: Multiple recipients of list ORACLE-L I'm trying to justify hiring another DBA, and management wants more justification. I have put together the usual reasons, but they want Industry Standards, like how many Databases can one DBA manage. Or how many GB/DBA or endusers/DBA? Does anyone keep these kind of stats? thanks __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: tony ynot 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: DENNIS WILLIAMS 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). __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.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: rebuilding an instance from a cpio file?
Title: RE: rebuilding an instance from a cpio file? here's an excellent link that will give you more than you asked for. http://www.onlamp.com/pub/a/bsd/2002/07/11/FreeBSD_Basics.html -Original Message- From: Don [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 24, 2002 2:54 PM To: Multiple recipients of list ORACLE-L Subject: rebuilding an instance from a cpio file? I have a huge cpio file that a sys admin created when it was decided to remove an instance (8i) from a test server. I don't know for certain what to do with this file, but I'd like to get that instance back up and running long enough to do an export of the db. Can somebody help with the syntax to list out the contents of the cpio file? I have read the man pages, but I can't figure out the syntax to just list the cpio contents. Thx, in advance, for you help. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don 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).
moving non system segments
Title: moving non system segments I was playing around with Tim Gorman's hc.sql (health check) and would like to move these objects into the USER tablespace. I would like assistance in additional things to consider. I haven't actualy used the command but believe I would use: ALTER object_type owner.segment_name MOVE new_tablespace; am curious if there is an issue with access against in transit objects. .The following non-SYS accounts have objects in SYSTEM ts . AURORA$JIS$UTILITY$ (67 segments using 1.09Mb) . CSMIG (7 segments using 0.19Mb) . MDSYS (31 segments using 1.27Mb) . ORDSYS (10 segments using 0.21Mb) . OSE$HTTP$ADMIN (3 segments using 0.05Mb) . SYSTEM (160 segments using 2.80Mb)
RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my
Title: RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my i had the same issue where all my data files were moved to the same slice which fortunately i had a large slice. i ended up doing the manual upgrade steps through the Migration manual. -Original Message- From: DiFelice, Sebastian [mailto:[EMAIL PROTECTED]] Sent: Friday, September 20, 2002 11:13 AM To: Multiple recipients of list ORACLE-L Subject: RE: migrated from 8.1.5 to 8.1.7 and Migration Assistant moved my When I upgraded and migrated from 8.1.5 to 8.1.7 the Universal Installer/Migration Assistant moved my $ORACLE_BASE from /disk03/app/oracle to /disk03/app/oracle/product/8.1.5 (which is my $ORACLE_HOME) without prompting me for the move. SD -Original Message- Sent: Friday, September 20, 2002 10:19 AM To: Multiple recipients of list ORACLE-L my can you better explain what the question is? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, September 20, 2002 9:48 AM To: Multiple recipients of list ORACLE-L $OR can anyone tell me why this happened? Sebastian DiFelice DBA/Database Analyst Thomson Intelligence Data (617)856-1587 www.intelligencedata.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DiFelice, Sebastian 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: Mercadante, Thomas F 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: DiFelice, Sebastian 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: Listener load balance
are either of you or any one on this list working with 11i applications? I am curious as to how the load balancing works against the hard coding of web service infomation in the FND profile options which seems to only provide configurationfor one application tier.Does the second tier only contain oneentry for itself within its listener.ora and all the initialrouting is handled by the first tier?I haven't implemented this but Ienvision thatduring navigationwithin the apps the clients connection would be redirected to the web addresses definedin the profile options causing issues with established connections.Ihope to be able to periodicaly duplicate my first application tierto a second tier and could use some insight on what to consider in this scenario. Perhaps a good doc source would suffice. -Original Message-From: Yechiel Adar [mailto:[EMAIL PROTECTED]]Sent: Wednesday, September 18, 2002 5:09 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Listener load balance Hello Ramon I think that you have an error in your parameters. As far as I know (not much) the second network card have a different TCP/IP address. You have to put this address in the added line in listener.ora and add (load_balance=on). (ADDRESS_LIST = (load_balance=on) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = newnetwork card address)(PORT = 1526)) --- Added ) In the tnsnames you have to use load_balance=on and put both addresses and ports in the address list: (description= (address list= (load_balance=on) (address=(protocol=TCP,host=225.125.110.5,port=1521)) (address=(protocol=TCP,host=newnetwork card address,port=1526)) This way the clients will use both address. Yechiel AdarMehish - Original Message - From: Ramon E. Estevez To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 10:19 PM Subject: Re: Listener load balance Tks Kevin, I didn't setup the DNS to do that. I ping myserver and is using the new address. Don't know how to do it either. What I am planning to do is to setthe manually the ip address to the both port. I am using local names. (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.5)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = 225.125.100.6)(PORT = 1526)) --- Added Ramon - Original Message - From: Kevin Lange To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 17, 2002 12:03 PM Subject: RE: Listener load balance Your HOSTNAME of 'myserver' would tell you which. Since you have the same hostname on the listener, both ports would currently be using the same IP address. Did you setup DNS so that the cards share a Hostname ? -Original Message-From: Ramon E. Estevez [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 17, 2002 9:43 AMTo: Multiple recipients of list ORACLE-LSubject: Listener load balance Hi list, Scenario Win2000 server, 8.1.7. I added anetwork card to my DB Server. I want the listener to accept connections for the 2 IP address to make load balance. I just added a line to the listener file with a different port. How can I assure that the port 1521 is listening for the net address 01 and the port 1526 in the address 02 ? Is that correct ? --- LISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1)) ) (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1521)) ---Original (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 1526)) --- Added ) ) (DESCRIPTION = (PROTOCOL_STACK = (PRESENTATION = GIOP) (SESSION = RAW) ) (ADDRESS = (PROTOCOL = TCP)(HOST = myserver)(PORT = 2481)) ) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = C:\Oracle\Ora8I) (PROGRAM = extproc) ) (SID_DESC = (GLOBAL_DBNAME = ORCL) (ORACLE_HOME = C:\Oracle\Ora8I) (SID_NAME = ORCL) ) ) TIA, Ramon E. Estevez[EMAIL PROTECTED]809-565-3121
RE: Estat Bstat
Title: RE: Estat Bstat you could always have the utl*stat report output interpreted by oraperf.com for free. -Original Message- From: Ora NT DBA [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 2:14 PM To: Multiple recipients of list ORACLE-L Subject: Re: Estat Bstat Try running from svrmgr instead of from sqlplus. If you are using a version of oracle that does not have sqlplus you should be using statspack instead. John John [EMAIL PROTECTED] wrote: I am trying to run utlbstat and utlestat for the first time. The output is not formatted very well. Does anyone have a cleaner version? R. Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA 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: log_file_sync io wait question
Title: RE: log_file_sync io wait question well if you have mirrored members that exist on the same disk thats an issue, if this same disk houses the currently used datafiles that would add to the situation. I placed my redo on a seperate raid-1 and dropped the member mirrors and see better stats. I have a buffer size 1mb but I am using 11i applications. Also consider your log file sizes, the larger the more it has to flush at a given time, but the smaller the more often it has to flush all theses consideration above need to be configured according to what you have available hardware-wise. HTH -Original Message- From: Pat Howe [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 18, 2002 1:09 PM To: Multiple recipients of list ORACLE-L Subject: log_file_sync io wait question We have a canned package that we use to insert approx 100 records/second into one table (oltp environment). Each record is just under 1K (datatypes = number and varchar). There are several indexes that are build on the table as the records are inserted. Each and every record is committed. Therefore we are flushing the 'redo log buffer' to disk (online redo logfiles) 100 times per second (once per commit). Not surprisingly we have noticed IO waits which we believe are associated with our 'Redo Log buffer'. Namely ; log_file_sync = 180 waits/sec log_file_parallel_write = 180 waits/sec We tried resizing the 'redo log buffer' from 16K to 256K - but we did not notice any improvements. Neither Log switching or archiving seem to be excessive. 100 records per second seems to be our maximum speed without the application queuing up and Oracle showing very high waits on log_file_sync and log_file_parallel_writes. Does anyone know how we might be able to minimize the IO waits? Thanks in advance. ENVIRONMENT oracle : Oracle 8.1.7.4 os : Sun Sparc Solaris 8 box : 8x8 E10K IO : Hitachi SANS unit through fiber and Brocade switch _ Patrick J. Howe -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe 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: backup controlfile to trace
Title: RE: backup controlfile to trace a non-full proof method that I use is T_FILE=$(ls -1rt /$ORACLE_HOME/admin/udump | tail -1) this will assign $T_FILE to the newest file existing in UDUMP. -Original Message- From: Ray Stell [mailto:[EMAIL PROTECTED]] Sent: Tuesday, September 17, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: backup controlfile to trace 8.1.7 For scripting purposes, what is the logic for finding the trc file from alter database backup controlfile to trace cmd? This seems really stupid not being able to direct the output. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell 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 Version on Unix
Title: RE: Oracle Version on Unix Chapter 7 Section Changing the Word-Size of your Current Release within the Oracle 9i Database Migration Manual. I dont see why you couldn't do: file ${ORACLE_HOME}/bin/oracle to determine the word size. -Original Message- From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 3:04 PM To: Multiple recipients of list ORACLE-L Subject: Oracle Version on Unix I know this was discussed a short time ago, but how do I determine if the Oracle 817 version installed on a Sun Unix box is 32 or 64 bit? I'm looking at migrating to 9.2/64 bit and noticed that I cannot directly migrate a 32bit version to 64 bit. Thanks Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, September 11, 2002 2:18 PM To: Multiple recipients of list ORACLE-L My house is insured and I'm contemplating a ground up redecoration. As for being an infidel, the God is great and Larry Wall is his prophet. I'm a true believer. -Original Message- From: Naveen Nahata [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks Please don't use wrong words like these for the Al Qaida members, you risk termed an 'infidel' and getting your house attacked by a suicide bomber :-) -Original Message- Sent: Wednesday, September 11, 2002 9:44 PM To: Multiple recipients of list ORACLE-L Nope. Developers are not normal users and Al Quaida members are not normal members of society. Both are very dangerous. -Original Message- From: Stephane Faroult [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 11:09 AM To: Multiple recipients of list ORACLE-L Subject: RE: Re: View Locks I have a problem with normal users monitoring locks. Do you consider developers to be normal users? Given the number of locking problems which you can trace back to the code, I would have no problem in that case. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroul INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing
RE: Decode
Title: RE: Decode an example straight from 9i SQL Reference should do SELECT product_id, DECODE (warehouse_id, 1, 'Southlake', 2, 'San Francisco', 3, 'New Jersey', 4, 'Seattle', 'Non-domestic') quantity_on_hand FROM inventories; -Original Message- From: Ruth Gramolini [mailto:[EMAIL PROTECTED]] Sent: Wednesday, September 11, 2002 2:59 PM To: Multiple recipients of list ORACLE-L Subject: Decode Hello everyone, I am having a senior moment and I have forgetten the syntax for 'decode'. Can anyone give me a hint. I have leant out my sql books and of course I need them now. Thanks in advance, Ruth Gramolini Oracle DBA, Vermont Department of Taxes -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: methodology to keep only certain programs to connect to
what are the drawbacks with such a trigger, what if the code went invalid and would not compile is it possible that you could lock yourself out, or would the base login functionality still work regardless or the status of this trigger? -Original Message-From: Mercadante, Thomas F [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 12:24 PMTo: Multiple recipients of list ORACLE-LSubject: RE: methodology to keep only certain programs to connect to Joe, I use the following with decent success on a logon database trigger: -- Set a unique string for the session and update the session info. client_info_str := 'WTWLOGIN_' || LTRIM(dbms_random.value,'.'); DBMS_APPLICATION_INFO.SET_CLIENT_INFO(client_info_str); -- look into the v$session view for the session just connected. SELECT program, username, osuser, terminal, machine INTO loc_program, loc_username, loc_osuser,loc_terminal,loc_machine FROM V$SESSION WHERE client_info=client_info_str; From here, you can test the loc_program variable against the loc_username to see if the combination is correct. Stuff like: IF loc_username='TESTLOGIN'then RAISE kill_Login; END IF; EXCEPTION WHEN kill_Login THEN RAISE_APPLICATION_ERROR(-20999,'Login''s using this account and this tool are Invalid'); Hope this helps! Tom Mercadante Oracle Certified Professional -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Tuesday, September 10, 2002 11:58 AMTo: Multiple recipients of list ORACLE-LSubject: methodology to keep only certain programs to connect to I've been tasked to ensure only certain app programs access the database. I'm thinking on-logon trigger, check the program field from v$session. unfortunately v$session is for all sessions, i can't seem to find the view that tells me only MY info during login. I only want the sid, serial#, username and program for my just now connection to the database. Does this exist or am I going about this the wrong way? We're thinking of checking those fields to make sure sql*plus, toad, etc can't connect as a particular user(even though the password is known out in the community). any ideas would be greatly appreciated. joe
RE: ALTER TABLE MOVE command causes table to grow
Title: RE: ALTER TABLE MOVE command causes table to grow you didn't mention the PCT_INCREASE of this segment. -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Subject: ALTER TABLE MOVE command causes table to grow Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my medium tablespace. The table ended up growing 50%. I had anticipated it might grow somewhat given the PCTFREE of 10% but freeing up that space in the blocks should, at most, have caused it to grow by 10% (assuming that 10% was completely full). Does anyone have ideas as to why it would have grown by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: ALTER TABLE MOVE command causes table to grow
Title: RE: ALTER TABLE MOVE command causes table to grow just to be certain we are on the same page, you mention uniform sizing which is on the tablespace level, so I want to make sure the PCT_INCREASE you provided was pulled from dba_segments. if so then i'd say a bit more info would need to have some light shed on it persay was there much DML put against this table last week. a PCT_FREE of 10% wouldn't be such a good idea for a table with varying length column data. -Original Message- From: Miller, Jay [mailto:[EMAIL PROTECTED]] Sent: Thursday, September 05, 2002 2:43 PM To: Multiple recipients of list ORACLE-L Subject: RE: ALTER TABLE MOVE command causes table to grow pct increase is 0 (uniform sizing) -Original Message- Sent: Thursday, September 05, 2002 2:00 PM To: Multiple recipients of list ORACLE-L you didn't mention the PCT_INCREASE of this segment. -Original Message- mailto:[EMAIL PROTECTED] ] Sent: Thursday, September 05, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Had an annoying surprise last week. A table had grown unexpectedly large and I scheduled a time over the weekend to move it to its own tablespace from my medium tablespace. The table ended up growing 50%. I had anticipated it might grow somewhat given the PCTFREE of 10% but freeing up that space in the blocks should, at most, have caused it to grow by 10% (assuming that 10% was completely full). Does anyone have ideas as to why it would have grown by so much? Indexes are in a different tablespace and the only other change was from an extent size of 4 meg to one of 25 meg. Both are dictionary managed tablespaces. Oracle 8.1.7.2 Solaris 2.6 Thanks, Jay Miller -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).
connection output on clone instance
Title: connection output on clone instance can anyone guide me in changing the connect output: Connected to: Oracle8i Enterprise Edition Release 8.1.7.2.0 - Production With the Partitioning option JServer Release 8.1.7.2.0 - Production Where Production will be replaced with TEST
RE: arg list too long in unix
Title: RE: arg list too long in unix go into the top dir and run find . -name cz-session-* | xargs rm -f or find . -name cz-session-* -exec rm -f {} \; the first runs faster but keep in mind that in other scenarios xargs splits stdin into file names on space and newline. -Original Message- From: Nuno Souto [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 29, 2002 7:43 AM To: Multiple recipients of list ORACLE-L Subject: Re: arg list too long in unix Use the xargs command. Read about it in the man pages. Or use find, but that is more complex. Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - OS: SOlaris 2.8 DB: 8i In the clean up process of the following files, I am trying to list out the files that start with cz. cz-session-returnui177_11Jan02_0959AM_33509.txt cz-session-Applet178_11Jan02_0959AM_34108.txt cz-session-returnui175_11Jan02_0959AM_20504.txt cz-session-DHTML176_11Jan02_0959AM_22335.txt cz-session-returnui179_11Jan02_1000AM_34566.txt cz-session-Applet180_11Jan02_1000AM_34818.txt cz-session-BatchSingle181_11Jan02_1001AM_07757.txt cz-session-BatchSingle182_11Jan02_1001AM_11687.txt cz-session-BatchSingle183_11Jan02_1001AM_14010.txt cz-session-BatchSingle184_11Jan02_1001AM_17708.txt cz-session-BatchSingle185_11Jan02_1001AM_20029.txt but when I issue ls -ltr cz* , I am getting arg list too long error. I 70,000-80,000 files that needs to be removed from the directory. I cant list them using ls -ltr *session* as this string may change. I have to identify the files that srart with cz only. can somebody through somelight on this. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nuno Souto INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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: ROWNUM strangeness?
Title: RE: ROWNUM strangeness? show the full sql please, perhaps its how you are grouping your conditions Paul Baumgartel wrote: I've been given a query to investigate. The performance varies extremely depending on whether the entire result set is fetched or a ROWNUM n clause is attached; that makes sense to me. What doesn't make sense is the following: if we add WHERE ROWNUM 50, the query returns 24 rows. If we add WHERE ROWNUM 1000, the query returns 336 rows! I don't know the size of the entire result set (I'm running a count right now), but if the result set consists of at least 336 rows, shouldn't WHERE ROWNUM 50 return 49 rows? TIA! = Paul Baumgartel, Adept Computer Associates, Inc. [EMAIL PROTECTED] __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists 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).
os date, sysdate time synchronization
Title: os date, sysdate time synchronization I am considering ntpd to synchronize my server times but I wanted to check if there are any issues with actively synchronizing the system time when there is an oracle database involved. Does the db maintain its own time clock after its started so that the timestamps in the control file are not affected by outside adjustments? I am curious of what anyone had had to deal with or consider in this type of scenario. TIA for any information.