RE: How to drop a system event trigger - endless loop?
You can also set the hidden parameter _system_trig_enabled=FALSE in your init file. The use of this parameter is discussed in the documentation (Chapter 7 of the 817 migration guide) and it disables any system triggers (the new Oracle8i event triggers) you may have in your database. Quote is from http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_datab ase_id=FORp_id=178529.999. Regards, Bruce -Original Message- Sent: Wednesday, 6 June 2001 3:00 you could also do svrmgrl alter trigger trigger_name disable; -- From: Rachel Carmichael[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 11:01 PM go in through svrmgrl or connect via sqlplus using / as sysdba this will log you in without executing the trigger and you can then drop it From: Andor, Gyula [EMAIL PROTECTED] Date: Tue, 05 Jun 2001 07:20:38 -0800 Hi Gurus ! I created a trigger on logon event. The trigger seems to be falling into an endless loop, so I can't login. How colud I drop this trigger. I created this trigger with ON DATABASE clause. Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: query using OR operator
Try using the primary key value like if PRD_LVL_CHILD is the primary key then just add a where cond using and operator like PRD_LVL_CHILD0. This will make the usage of index in the table PRCMSTEE. May be this is not the actual way, but we have tuned several queries like this and they all are working fine and doing well in our applns. -- On Tue, 05 Jun 2001 21:30:26 Suhen Pather wrote: List, I require help with tuning a query. SELECT PRC_TYPE FROM PRCMSTEE WHERE PRD_LVL_CHILD = 505 OR PRD_LVL_CHILD IN (SELECT PRD_LVL_PARENT FROM PRDMSTEE WHERE PRD_LVL_CHILD = 505 ) / Query Plan -- SELECT STATEMENT[CHOOSE] Cost=84 Rows=5026 Bytes=30156 FILTER TABLE ACCESS FULL PRCMSTEE [ANALYZED] TABLE ACCESS BY INDEX ROWID PRDMSTEE [ANALYZED] INDEX UNIQUE SCAN PRDMSTEEP1 [ANALYZED] Execution Plan -- 0 SELECT STATEMENT Optimizer=CHOOSE (Cost=84 Card=5026 Bytes=3 0156) 10 FILTER 21 TABLE ACCESS (FULL) OF 'PRCMSTEE' (Cost=84 Card=5026 Byt es=30156) 31 TABLE ACCESS (BY INDEX ROWID) OF 'PRDMSTEE' (Cost=2 Card =1 Bytes=7) 43 INDEX (UNIQUE SCAN) OF 'PRDMSTEEP1' (UNIQUE) (Cost=1 C ard=1) Statistics -- 0 recursive calls 4 db block gets 237373 consistent gets 0 physical reads 0 redo size 541 bytes sent via SQL*Net to client 424 bytes received via SQL*Net from client 2 SQL*Net roundtrips to/from client 0 sorts (memory) 0 sorts (disk) 6 rows processed I am trying to reduce the logical IO for this query. The query performs a full table scan on PRCMSTEE, which accounts for the total cost of the query and high LIO. I have run individual parts of the query and the LIO stays lows except when the OR operator is used. I know that the OR operator would supress the use of an index, but I also tried using a index HINT, to force the use of the index, but Oracle favours doing a full table scan on PRCMSTEE. There is an INDEX on PRD_LVL_CHILD of PRCMSTEE. Is there a way to rewrite the query to reduce the LIO? Thanks and Regards Suhen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: SUMMARY: Thanks everyone - tru64
On Tuesday 05 June 2001 13:15, Koivu, Lisa wrote: 10. Benchmarking Solaris E10K/64CPU against Compaq GS-160/16CPU favored the Compaq! WOW The same can be said for a loaded ( 16 way ) IBM RS6000 S80 running AIX. *Much* less than an E10k and equivialent processing power. 2. Sun is ex-pen-sive! Compaq wins in this comparison. Again, the IBM solution is also less money than Sun. 7. If it's possible, consider IBM/AIX. IBM's sales force is highly trained in administration so you can talk real system architecture with them (not that I'm an admin or architect, I am neither). IBM's support is also top notch. Yeah, but you still gotta listen pretty closely to the sales pitch. The *are* sales folks after all. Intestingly, the DH Brown report put AIX on top of the unix heap for several year, that is until this year, when Solaris edged it out. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
job queue process parameters....
Hi, Are job_queue_interval and job_queue_process parameters applicable to both dedicated and parallel server? any changes regarding this in 8i. rgds amar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amar Kumar Padhi 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: query using OR operator
Hi Suhen, The UNION ALL will return duplicates from the two queries, whereas the original query will not, right? So the query is tuned, but it returns a different result set. Do you agree? Best regards, - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: limit number of sessions from an OSUSER or a machine?
Perhaps 2 could be accomplished by a database after login trigger that uses raise_application_error if the count of sessions from the machine is too high. This will depend on what version of Oracle you are on. Bruce -Original Message- Sent: Wednesday, 6 June 2001 4:05 To: Multiple recipients of list ORACLE-L On Tuesday 05 June 2001 15:18, Guang Mei wrote: 1. Is there any way to limit how many sessions from a particular OSUSER? If yes, how? use CREATE PROFILE, and assign the profile to the user(s). This is per database user, not OS user. 2. Is there a way to limit how many sessions from a particular machine (which uses db link to access out oracle db)? If yes, how? Sorry, have no idea about this one. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Which SQL is executing
Hi, Sam, Thanks for your information. To my understanding,the script you gave is for all the queries. There is still no way to figure out which query is running. Chuan, - Original Message - From: Sam Roberts To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 5:00 PM Subject: Re: Which SQL is executing SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE; Sam - Original Message - From: Chuan Zhang To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 9:30 AM Subject: Which SQL is executing Hi All, From v$open_cursor, I know every SQL opened and parsed in one session. Is there any way to know which SQL is running. Or put another way, canall the SQLs in one session be sorted in timing order dynamically? Any clue would be much appreciated. Chuan
RE: query using OR operator
Greg, Correct me if I am wrong but both will return duplicates since the OR operator is used. The primary key is on PRD_LVL_CHILD.PRDMSTEE. Regards Suhen Hi Suhen, The UNION ALL will return duplicates from the two queries, whereas the original query will not, right? So the query is tuned, but it returns a different result set. Do you agree? Best regards, - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore 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: Suhen Pather 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: How to remove corrupted blocks from datafile.
This what I did last time it happened to me. (Bear in mind that this was Oracle 7.3 and so rowid format is different for later releases of Oracle). In sqlplus select the following from the table with the corruption SQL SELECT /*+ ROWID(TABLE_NAME) */ DOC_ID, ROWID 2 FROM TABLE_NAME 3 WHERE ROWID BETWEEN '..' AND '..'; This will stop at the corrupted row. eg. 7085.4234.0009 - this is a hexidecimal representation The first 8 digits are the block number (Block no. 28805 in hex is 7085). The next four are the row and the final four are the file number. The last record before the corrupted block in this case will be 7084..0009. The first record of the corrupted block in this case will be 7085..0009. The first record after the corrupted block in this case will be 7086..0009. To get these unaffected rows back into the table do the following. create table table_name_tmp as select * from table_name where 1 = 2; This will create a temporary table the same as your original. Next backup the original table structure so you can recreate it. exp username/password file=table_name.dmp rows=n tables=TABLE_NAME then imp username/passwd file=table_name.dmp indexfile=table_name.sql Make the necessary amendments to the indexfile (take REM statements and connect statements out) Next insert the uncorrupted rows into the temporary table. SQL INSERT INTO TABLE_NAME_TMP SELECT /*+ ROWID(TABLE_NAME) */ * 2 FROM TABLE_NAME 3 WHERE ROWID BETWEEN '..' 4 AND '7084..0009'; Next insert the rows after the corruption SQL INSERT INTO TABLE_NAME_TMP SELECT /*+ ROWID(TABLE_NAME) */ * 2 FROM TABLE_NAME 3 WHERE ROWID BETWEEN '7086..0009' 4 AND '..'; Next drop the original table drop table table_name; and then run your sql file (indexfile) to create the table and associated indexes. @table_name After this reapply all grants (run the recreate grant script) and finally insert new rows. insert into table_name select * from table_name_tmp; Lee Robertson The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Where can I find openworld 2000 white papers?
http://www.oracle.com/start/oowsessionsearch/index.html HTH, Rajesh -Original Message- Sent: Wednesday, June 06, 2001 10:32 AM To: Multiple recipients of list ORACLE-L Hi DBA Gurus, I am looking for whitepapers and presentations of Oracle Openworld 2000. Where can I find them? Anybody can help me in this regard? TIA and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ranganath K 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: Rajesh Dayal 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: Which SQL is executing
Hi Chuan, Still your question is not clear to me. But I am sending you some scripts, may be these would help you: This gives SQL-TEXT, Oracle-User-name, machine-name and program-name for the user executing the SQLs. set pagesize 50 set head on set linesize 70 select sa.sql_text,s.username,s.machine,s.programfrom v$sqlarea sa,v$session swhere s.sql_address=sa.addressand s.sql_hash_value=sa.hash_valueorder by sa.buffer_gets desc/ This will give all SQLs currently executingincluding this one. SELECT u.sid, SUBSTR(u.username,1,12) user_name, s.sql_textFROM v$sql s, v$session uWHERE s.hash_value = u.sql_hash_valueORDER BY user_name/ HTH, Rajesh -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chuan ZhangSent: Wednesday, June 06, 2001 11:25 AMTo: Multiple recipients of list ORACLE-LSubject: Re: Which SQL is executing Hi, Sam, Thanks for your information. To my understanding,the script you gave is for all the queries. There is still no way to figure out which query is running. Chuan, - Original Message - From: Sam Roberts To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 5:00 PM Subject: Re: Which SQL is executing SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE; Sam - Original Message - From: Chuan Zhang To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 9:30 AM Subject: Which SQL is executing Hi All, From v$open_cursor, I know every SQL opened and parsed in one session. Is there any way to know which SQL is running. Or put another way, canall the SQLs in one session be sorted in timing order dynamically? Any clue would be much appreciated. Chuan
RE: Which SQL is executing
Try this out my friend: select s.sid sid, c.sql_text sql_text, c.address address, ltrim(to_char(c.hash_value,'99'),' ') hash_value, substrb(' ',1,2) execcur from v$open_cursor c, v$session s where c.saddr = s.saddr and c.hash_value != s.sql_hash_value and s.sid in (THE_SID_U_ARE_INTERESTED_IN)unionselect s.sid sid, c.sql_text sql_text, c.address address, ltrim(to_char(c.hash_value,'99'),' ') hash_value, substrb('* ',1,2) execcur from v$open_cursor c, v$session s where c.saddr = s.saddr and c.hash_value = s.sql_hash_value and s.sid in (THE_SID_U_ARE_INTERESTED_IN); The currently executing cursor will be the one with* in the execcur column. HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Chuan ZhangSent: Wednesday, June 06, 2001 08:25To: Multiple recipients of list ORACLE-LSubject: Re: Which SQL is executing Hi, Sam, Thanks for your information. To my understanding,the script you gave is for all the queries. There is still no way to figure out which query is running. Chuan, - Original Message - From: Sam Roberts To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 5:00 PM Subject: Re: Which SQL is executing SELECT T.SQL_TEXT FROM V$SQLTEXT T,V$SESSION S WHERE S.SQL_ADDRESS=T.ADDRESS ORDER BY T.PIECE; Sam - Original Message - From: Chuan Zhang To: Multiple recipients of list ORACLE-L Sent: Monday, June 04, 2001 9:30 AM Subject: Which SQL is executing Hi All, From v$open_cursor, I know every SQL opened and parsed in one session. Is there any way to know which SQL is running. Or put another way, canall the SQLs in one session be sorted in timing order dynamically? Any clue would be much appreciated. Chuan
Creating and Oracle 7 DB from an Oracle 8 DB
Hi, Its a long and boring story but I have an Oracle8 database andI need to create anOracle 7 database from it to support one of our applications. The schema of the Oracle 8 db does not have any oo features and is, in theory, it functionally compatable with an Oracle 7 db. But I understand that there are issues with using export from oracle 8 and import to oracle 7, I.e it is incompatable. Has anyone had any experience in doing this or any suggestions on ways of doing it? And by the way the data in tables needs to be copied from 8 to 7 also. Cheers Tim AllenDesignerRamesys (Professional Services) Ltd( Phone: 01788 822133 . Fax : 01788 822144 + Address : Eldon Way, Motorway Ind. Estate, Crick, Northants, NN6 7SL * E-mail : [mailto:tim.allen@ramesys.com] [ The views and opinions expressed in the email are the sender's own ][ and do not necessarily represent the views and opinions of Ramesys LTD ]
Re: OT-Passing variables to a awk/sed script
Hello List, This must be piece of cake for the UNIX gurus. Trying to pass parameters to a simple awk script. Getting stuck.=20 First q., can we do that.=20 If yes I need to solve the foll. problem, In a huge text file locate for abc/xyz and replace it with a supplied = parameter value. This paramter must of course, be able to take on any = value during the run of the program. Any help or tips on that would be highy appreciated. Thanks Satish Satish, It depends on the system you are on. The old original awk does not allow parameters to be passed to it, but the newest can take -v parameter_name=value On many systems, the new awk is called 'nawk', but not everywhere. Try 'man awk/man nawk' on your system and check which one takes the -v flag. HTH Stephane Faroult Oriole Corporation -- Diese E-Mail wurde mit http://de.mail-inspector.de verschickt Mail Inspector ist ein kostenloser Service von http://www.is-fun.net Der Absender dieser E-Mail hatte die IP: 195.25.229.12 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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).
Trouble.. Standby Database. Urgent!!
hi all, I need ur help urgently. i've created a standby database with the below mentioned steps.. 1. copied consistent backup of datafiles folder to standby site. 2. created standby control file and sent to target location. 3. switch logfile current and copied to target. 4. copied init.ora and changed parameters for standby. at the standby site. 1. startup nomount ok 2. alter database mount standby database. ok 3. recover standby database ... this last recovery statement is giving lot of msgs like..log applied.. then same logfile not needed for this recovery. can not open file..etc. I'm copying the archived log from primary to standby standby_archive_dest location. here are the actual errors.. SVRMGR recover standby database;ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for thread 1ORA-00289: suggestion : D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-00280: change 708915 for thread 1 is in sequence #505Specify log: {RET=suggested | filename | AUTO | CANCEL}autoORA-00308: cannot open archived log 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-27041: unable to open fileOSD-04002: unable to open fileO/S-Error: (OS 2) The system cannot find the file specified. has anybody any idea of what's causing this problem. what i feel is there i may have wrongly configured the standby_archive_dest in init.ora at standby. any help is greatly appreciated. thanks. saurabh sharma
RE: How to remove corrupted blocks from datafile.
Just for the sake curiosity I think we should try to salvage the records which are stored after the corrupted blocks. Following SQL may be helpful for this purpose: SQL SELECT /*+ ROWID(TABLE_NAME) */ DOC_ID, ROWID 2 FROM TABLE_NAME 3 WHERE substr(ROWID,1,8) '7085' and 4 substr(ROWID,15,4) = '0009' This could happen that only one Data block is corrupted and rest all next to that are fine. Of course we need to find out this by hit and trial method. Please correct me if I am wrong Rajesh -Original Message- Lee - lerobe Sent: Wednesday, June 06, 2001 12:21 PM To: Multiple recipients of list ORACLE-L This what I did last time it happened to me. (Bear in mind that this was Oracle 7.3 and so rowid format is different for later releases of Oracle). In sqlplus select the following from the table with the corruption SQL SELECT /*+ ROWID(TABLE_NAME) */ DOC_ID, ROWID 2 FROM TABLE_NAME 3 WHERE ROWID BETWEEN '..' AND '..'; This will stop at the corrupted row. eg. 7085.4234.0009 - this is a hexidecimal representation The first 8 digits are the block number (Block no. 28805 in hex is 7085). The next four are the row and the final four are the file number. The last record before the corrupted block in this case will be 7084..0009. The first record of the corrupted block in this case will be 7085..0009. The first record after the corrupted block in this case will be 7086..0009. To get these unaffected rows back into the table do the following. create table table_name_tmp as select * from table_name where 1 = 2; This will create a temporary table the same as your original. Next backup the original table structure so you can recreate it. exp username/password file=table_name.dmp rows=n tables=TABLE_NAME then imp username/passwd file=table_name.dmp indexfile=table_name.sql Make the necessary amendments to the indexfile (take REM statements and connect statements out) Next insert the uncorrupted rows into the temporary table. SQL INSERT INTO TABLE_NAME_TMP SELECT /*+ ROWID(TABLE_NAME) */ * 2 FROM TABLE_NAME 3 WHERE ROWID BETWEEN '..' 4 AND '7084..0009'; Next insert the rows after the corruption SQL INSERT INTO TABLE_NAME_TMP SELECT /*+ ROWID(TABLE_NAME) */ * 2 FROM TABLE_NAME 3 WHERE ROWID BETWEEN '7086..0009' 4 AND '..'; Next drop the original table drop table table_name; and then run your sql file (indexfile) to create the table and associated indexes. @table_name After this reapply all grants (run the recreate grant script) and finally insert new rows. insert into table_name select * from table_name_tmp; Lee Robertson The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Rajesh Dayal 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).
dbsnmp package
Hi all gurus, My question is how can I query the database for which packages are installed? I wonder if dbsnmp is installed? Thank you. Bunyamin
Problem with RMAN
List hi! Oracle 8.1.7 EE on WinNT. During instalation of database, package DBMS_RCVCAT was not installed but I have packages DBMS_RCVMAN, DBMS_BACKUP_RESTORE. What should I do? TIA, Sonja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?windows-1250?Q?Sonja_=8Aehovi=E6?= 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: job queue process parameters....
Yes - and from 8i (I think) upwards you can bind a job to a particular instance. hth connor --- Amar Kumar Padhi [EMAIL PROTECTED] wrote: Hi, Are job_queue_interval and job_queue_process parameters applicable to both dedicated and parallel server? any changes regarding this in 8i. rgds amar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Amar Kumar Padhi 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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 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: Compute statisics
Hi Jared, My post was to meant to imply that (say) if (in a single query - and thats the important bit I missed out) there were two tables, one with stats, and one without, then the one without will use defaults (as quoted in chapter 8 of the same manual) I was trying to imply that if you've only got half the stats, then on a query-by-query basic, you're most likely to toggle between - 'good' CHOOSE (since all the stats are present for the objects in this query) - 'bad' CHOOSE (since some defaults are chosen for object missing statistics) - RULE (for queries where all objects have no stats) Cheers Connor --- Jared Still [EMAIL PROTECTED] wrote: On Tuesday 05 June 2001 01:20, Connor McDonald wrote: Sounds like nonsense to me...If you have half statistics, then the optimizer is going to use defaults for the others, Conner, Are you sure about that? From the Optimizer chapter in the tuning manual: If the data dictionary contains statistics for at least one of the accessed tables, then the optimizer uses a cost-based approach and optimizes with a goal of best throughput. If the data dictionary contains no statistics for any of the accessed tables, then the optimizer uses a rule-based approach. This is the default value for the parameter. ... If the optimizer uses the cost-based approach for a SQL statement, and if some tables accessed by the statement have no statistics, then the optimizer uses internal information (such as the number of data blocks allocated to these tables) to estimate other statistics for these tables. That coupled with the fact that when viewing the plan table you can see the CBO's use of the statistic would make me think otherwise. Is there some documentation that I missed that supports the CBO using defaults for analyzed tables when some of them are _not_ analyzed? Or did I just misunderstand your post? Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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 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: OPTIMIZER_INDEX_COST_ADJ OPTIMIZER_INDEX_CACHING
Given that OPTIMIZER_INDEX_CACHING is presumably meant to the indicative of how much of an index is cached, then setting it to your buffer hit ratio would seem like a reasonable starting point. Cheers Connor --- [EMAIL PROTECTED] wrote: Oracle 8.0.5.2.1 -- yeah, I know I know... we are going to 8.1.7 eventually AIX 4.3.3 Hey allLooking at our init parameters today after reading Tim Gorman's White Paper The Search for Intelligent Life in the Cost Based Optimizer and these 2 stood out like a sore thumb. Both are at the default values: OPTIMIZER_INDEX_COST_ADJ = 100 OPTIMIZER_INDEX_CACHING = 0 We have an OLTP and a DSS database and I am looking at changing the OPTIMIZER_INDEX_CACHING = 90 for both and setting the OPTIMIZER_INDEX_COST_ADJ to a reasonable value based on db sequential reads vs. db scattered reads as a guideline any suggestions/recommendations/words of warning/flogging?There is some scattered info on this on Metalink but I'm looking for some real-world improvements or headaches. Thanks to all in advance and hopefully I won't have to type HELP so someone can ask me if I'm an idiot :-) John D. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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 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: Trouble.. Standby Database. Urgent!!
Actually there may be no problem at all. Your standby database might be up to date, the last available archive log file has been applied to your standby database and Oracle tried to apply the next archive log file 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 and did not find it, since you did not copied it to the standby server or it does not even exist - yet - in the primary site. Check if the file missed by Oracle exists on the standby site archive directory. Actually if you use managed standby database, Oracle can transfer the archived logs to the standby database through SQLNet and can make the standby database applie them automatically. But you will need Enterprise Edition Licences to do this:-(( If you move the archived log files from the primary site to the standby manually, it can work very well too, without additional licence fees. In this case create soma batch files for moving the files and applying them to the standby site. The triggering of the batch files can be achieved by OS specific scheduling commands. Actually we implemented it this way and it's working fine for us. HTH, Tamas Szecsy -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 10:21 AMTo: Multiple recipients of list ORACLE-LSubject: Trouble.. Standby Database. Urgent!! hi all, I need ur help urgently. i've created a standby database with the below mentioned steps.. 1. copied consistent backup of datafiles folder to standby site. 2. created standby control file and sent to target location. 3. switch logfile current and copied to target. 4. copied init.ora and changed parameters for standby. at the standby site. 1. startup nomount ok 2. alter database mount standby database. ok 3. recover standby database ... this last recovery statement is giving lot of msgs like..log applied.. then same logfile not needed for this recovery. can not open file..etc. I'm copying the archived log from primary to standby standby_archive_dest location. here are the actual errors.. SVRMGR recover standby database;ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for thread 1ORA-00289: suggestion : D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-00280: change 708915 for thread 1 is in sequence #505Specify log: {RET=suggested | filename | AUTO | CANCEL}autoORA-00308: cannot open archived log 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-27041: unable to open fileOSD-04002: unable to open fileO/S-Error: (OS 2) The system cannot find the file specified. has anybody any idea of what's causing this problem. what i feel is there i may have wrongly configured the standby_archive_dest in init.ora at standby. any help is greatly appreciated. thanks. saurabh sharma
RE: How to identify sql texts which are having open cursor?
See the script I just posted in the thread: Which SQL is executing? This may help you out.. Mark -Original Message- Sent: Tuesday, June 05, 2001 11:34 To: Multiple recipients of list ORACLE-L select, by user, from v$sqlarea, a list of cursors in the pool from a typical user. (see sql_addr and hash_value for joins). I am sure someone somewhere has a script you can run to do this. mit gluck Hans || -Original Message- || From: Shantanu Talukder [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, June 05, 2001 6:14 PM || To: Multiple recipients of list ORACLE-L || Subject: How to identify sql texts which are having open cursor? || || || Our application is using up open_cursor limits of 500. || We are suspecting that application code written in || Java || are not closing cursors explicitly. || Is there a way to idntify those sql code which are not || closing cursor? || We just don't want to increase open_cursor parameter || in init.ora and bounce the db without identifying sql. || || || HTH, || Shantanu || || --- Kirsh, Gary [EMAIL PROTECTED] wrote: || Jared, || || I think that the default java_pool_size is 20M, not || 30M. || || Gary || || || -Original Message- || Sent: Tuesday, June 05, 2001 4:01 PM || To: Multiple recipients of list ORACLE-L || || || || Take a look at the SGA with: || || select * from v$sgastat || order by 1,2; || || You will likely see 30M dedicated to the || java pool, as that is the default. This || can be cut back substantially if you are || not making use of java. || || Jared || || || On Tuesday 05 June 2001 05:01, C.S.Venkata || Subramanian wrote: || One of my co-worker came with this ques. In the || init.ora file he had set || the shared_pool_size to 10M and || db_block_buffers=1024 and redolog buffer || to || 32768. but when he did sho sga in the sql*plus || prompt he got the following || output || || Total System Global Area 41297948 bytes || Fixed Size75804 bytes || Variable Size 32755712 bytes || Database Buffers8388608 bytes || Redo Buffers 77824 bytes || || Doing a select on V$SGA also gave the same result. || || My shared pool size is only 10M, why it is showing || nearly 40M. From where || did oracle derive the extra MB's? I ran throu the || oracle manual and got || only answer for database buffers. || || Can any one tell from where these extra MB's come || to Oracle from the OS. || || TIA || || Venkat || || || Get 250 color business cards for FREE! || http://businesscards.lycos.com/vp/fastpath/ || -- || Please see the official ORACLE-L FAQ: || http://www.orafaq.com || -- || Author: Jared Still ||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: Kirsh, Gary ||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). || || || __ || Do You Yahoo!? || Get personalized email addresses from Yahoo! Mail - only $35 || a year! http://personal.mail.yahoo.com/ || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Shantanu Talukder || 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
RE: OT RE: Database writer
Thought it was Paul Katner.. Oh well.. Mark -Original Message- Sent: Tuesday, June 05, 2001 05:07 To: Multiple recipients of list ORACLE-L No winner! I drink the freaking beer all by myself. I think I'll pour myself a Smithwick's...somewhere in Dublin...aaa! (Jefferson Starship) || -Original Message- || From: Jerry C [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, June 05, 2001 11:32 AM || To: Multiple recipients of list ORACLE-L || Subject: Re: OT RE: Database writer || || || So... no winner Ross? || || Do we get the answer?? || || || - Original Message - || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Sent: Monday, June 04, 2001 4:25 PM || || || Yea, NT blows. Blows like a fresh wind against the empire. || || || (1st one to name that song lyric reference and i buy you a beer. || NT bigots and their families summarily excused from this offer.:) || || || -Original Message- || || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || || Sent: Monday, June 04, 2001 2:16 PM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: Database writer || || || || || || Doubt, didnt' see NT, boy NT blows. || || || || I hate how it doesn't list out the processes. || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 1:18 PM || || To: [EMAIL PROTECTED]; Christopher Spence || || || || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || || Look under ps. || || || || Really? On NT? || || || || Jared || || || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 11:56 AM || || To: Multiple recipients of list ORACLE-L || || || || || || Hi all, || || I added db writer processes last week to try and || || improve performance || || of one || || of my 8.1.7 db's on NT. Does anyone know if there is a || || way to see if || || Oracle actually started the additional db writer || || processes? I added || || db_writer_processes to the init file, the instance || started so I am || || assuming || || that the db writer processes are working. But we all know || || what happens || || when we assume something. Any ideas would be appreciated. || || || || Sincerely, || || Kevin Kostyszyn || || DBA || || Dulcian, Inc || || www.dulcian.com || || [EMAIL PROTECTED] || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Christopher Spence || || 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: Mohan, Ross ||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). || || || _ || Do You Yahoo!? || Get your free @yahoo.com address at http://mail.yahoo.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jerry C || 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,
RE: contents of SGA
The defaults are in the initSID.ora file, which is the initialization file that Oracle reads upon startup. If you are running Oracle 8 then you cna usually find this file in ORACLE_HOME/admin/SID/pfile Open the file and look for the parameter JAVA_POOL_SIZE and change as necessary, and then bounce the instance.. HTH Mark -Original Message- Subramanian Sent: Wednesday, June 06, 2001 06:15 To: Multiple recipients of list ORACLE-L Thanks, From where does these default values come?? Is there any file or table or Oracle default. -- On Tue, 05 Jun 2001 05:36:51 Rachel Carmichael wrote: you are confusing the size of the SGA (System Global Area) which is 40M with the size of the shared pool, which you set to 10M The shared pool is contained within the SGA, but is NOT the only component of the SGA. Also, depending on the version of Oracle you are running there may be default values associated with structures like the java pool which will add to the size of the SGA. Rachel From: C.S.Venkata Subramanian [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: contents of SGA Date: Tue, 05 Jun 2001 04:01:08 -0800 One of my co-worker came with this ques. In the init.ora file he had set the shared_pool_size to 10M and db_block_buffers=1024 and redolog buffer to 32768. but when he did sho sga in the sql*plus prompt he got the following output Total System Global Area 41297948 bytes Fixed Size75804 bytes Variable Size 32755712 bytes Database Buffers8388608 bytes Redo Buffers 77824 bytes Doing a select on V$SGA also gave the same result. My shared pool size is only 10M, why it is showing nearly 40M. From where did oracle derive the extra MB's? I ran throu the oracle manual and got only answer for database buffers. Can any one tell from where these extra MB's come to Oracle from the OS. TIA Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.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 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). Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: C.S.Venkata Subramanian 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: Mark Leith 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: dbsnmp package
Bunyamin, select * from dba_objects where object_name like '%DBSNMP%'; "Bunyamin K. Karadeniz" wrote: Hi all gurus,My question is how can I query the database for which packages are installed?I wonder if dbsnmp is installed?Thank you.Bunyamin -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
F45webm memory usage
Dear list, We are Oracle Apps site, one of the problem we are having is memory leak with f45webm processes. We had 4G of memory on the web server tier where the Form server run, when we run the prtmem command, it reported that 3.5G was used by user (application), using the memps command I can see the private area (I think this is the heap area of the process) of the f45webm is chewing up a lot of memory. We had opened tar with Oracle Support and applied all the patches suggested and also upgrade to the latest Form patchset, nothing seem to bring down the heap size. I further investigated and found something which I couldn't make sense of, I observed the paging rate and scan rate using sar throughout the day, there was not much happening, just a tiny bit of paging activities, if the box is using 3.5G of 4G, I would expected to see a lot of paging and scanning activities. Is anyone out there have similar problem with f45webm memory usage. I remembered reading something about Oracle server process do not release heap memory when it was done with it, it was up to the OS to reclaim it. In order words, the heap side shown is not really what is being used, sort of like a high water mark. Would the f45webm processes exhibits similar behaviour?? Also the prtmem and memps command, the number they displayed represent virtual or physical memory? I got a feeling is virtual because the total size included shared as well, but my SA said it is physical memory, any ideal?? KC
RE: Further adventures with Oracle Management Server
Paul The only workaround I found for this was to upgrade to Win2K. Then using the service recovery option - so that when the service fails, it just restarts it. You get a few recovery options with Win2K for services: Restart the service Run a file Restart the computer Take no action Which you can specify for: Fist Failure Second Failure Subsequent Failures I set each failure to restart the service.. And it works fine.. Sorry I can't help with NT though.. Upgrade it's a LOT better..:) Regards Mark -Original Message- Sent: Wednesday, June 06, 2001 10:23 To: Multiple recipients of list ORACLE-L Hi folks, firstly, many thanks for the advice about the resources.ora not found message. I've followed the advice to simply create the folder given in the message, and to move a copy of the resources.ora file, which exists elsewhere, to the folder. I did this, and OMS starts cleanly now. So thanks once again! And for my next problem... OK, so I've set the Management Server service to start automatically (this is running on an NT server, just to recap). Likewise, the repository database starts automatically when the system is rebooted. Unfortunately, the system appears to try and start the Management Server service before the database Start service has completed, so the Management Server fails to start. Does anyone have any idea how to tell the Management Server service not to start until the database service has started up? Or has anyone encountered this and figured out a cunning workround? Thanks again for the help! Paul Paul Vincent Database Administrator, University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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).
OEM 2.1 cannot contact agent on a node
Hi - me again, still having lots of fun with Oracle Enterprise Manager 2.1! Having got OMS working, I fired up the OEM 2.1 console, and gave it a list of nodes to discover. It found one of the 8.1.6 nodes (an NT box), and the 7.3.4 node (a Sun box), but failed on two others (an 8.1.6 Sun box and an 8.0.5 NT box) with the message: Discovery failed: VNI-4009: Cannot contact agent on the node. Now, the 8.1.6 Sun box hadn't got its Intelligent Agent started, so that was soon rectified. However, the 8.0.5 NT box DOES have a running Intelligent Agent (the Service name is Agent80), and on the server, the Agent80 service shows up when I do a net start command. The documentation suggested I check the server was using TCP/IP - which it is. I also came back to my workstation and tried pinging the server, and it pings successfully. But despite trying everything I can think of - even stopping and restarting the Agent80 service on the 8.0.5 box, I still can't get OEM 2.1 to discover the node successfully. Any ideas, please? Cheers, Paul Paul Vincent Database Administrator, University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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: Further adventures with Oracle Management Server
Sorry I'm not much help, but I remember reading about a parameter in one of the OEM docs that governs retries, time delays. 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] mailto:[EMAIL PROTECTED] -Original Message- From: Mark Leith [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 8:37 AM To: Multiple recipients of list ORACLE-L Subject:RE: Further adventures with Oracle Management Server Paul The only workaround I found for this was to upgrade to Win2K. Then using the service recovery option - so that when the service fails, it just restarts it. You get a few recovery options with Win2K for services: Restart the service Run a file Restart the computer Take no action Which you can specify for: Fist Failure Second Failure Subsequent Failures I set each failure to restart the service.. And it works fine.. Sorry I can't help with NT though.. Upgrade it's a LOT better..:) Regards Mark -Original Message- Sent: Wednesday, June 06, 2001 10:23 To: Multiple recipients of list ORACLE-L Hi folks, firstly, many thanks for the advice about the resources.ora not found message. I've followed the advice to simply create the folder given in the message, and to move a copy of the resources.ora file, which exists elsewhere, to the folder. I did this, and OMS starts cleanly now. So thanks once again! And for my next problem... OK, so I've set the Management Server service to start automatically (this is running on an NT server, just to recap). Likewise, the repository database starts automatically when the system is rebooted. Unfortunately, the system appears to try and start the Management Server service before the database Start service has completed, so the Management Server fails to start. Does anyone have any idea how to tell the Management Server service not to start until the database service has started up? Or has anyone encountered this and figured out a cunning workround? Thanks again for the help! Paul Paul Vincent Database Administrator, University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Boivin, Patrice J 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).
8i for solaris on intel
Hi, I have a Solaris test system on Intel. This is first time I installed Solaris. I am trying to findout in i can install the oracle 9i on this system. Can someone enlighten me. I don't mind installing any version as it is for test purposes, but 9i will be a great thing to do novice
Re: How to remove corrupted blocks from datafile.
Hi Uday, I don't know in which version dbv is stable; but, I know dbv was very buggy product. I recommend: - add event="10231 trace name context forever, level 10" to init.ora. This will eliminate corrupted blocks during full table scan. Note that this event is used while reading from disk. It does not effect cached blocks. - rebounce db. - create new table as select * from corrupted_table New table will not contain corrupted block. Following event should be used if blocks are accessed through index: event="10233 trace name context forever, level 10" udaycb wrote: Hi, I found some corrupted blocks in one of the datafile. I have created the temp table by select all the records (excluding the records in corrupted blocks) from corrupted table, and dropped the table, renamed the temp table back to original. After this when i run DBV on that file, it still shows there are some corrupted blocks in the file. i have two questions, 1 How do i calculate how many records i have lost? 2 How do i remove corrupted blocks from the blocks? Can anyone tell me ... Thanks in advance Uday Name: winmail.dat winmail.datType: DAT Dosyas (application/x-unknown-content-type-dat_auto_file) Encoding: 7bit -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: query using OR operator
both will return duplicates since the OR operator is used. select ename from emp where mgr = 1 or mgr in (1); -- If there are three rows where mgr = 1, this query will return three rows. select ename from emp where mgr = 1 union all select ename from emp where mgr in (1) -- But this returns six rows. In rewriting your query to tune it, you changed the sql from the form used in the first example to the form used in the second. So for your query, if there is ever a row in the table where the CHILD column value = 105 and in that same row the PARENT column value is also 105, you will get duplicates in the new tuned query that would not have appeared in the old one. Maybe you have a check constraint on these two columns to guarantee that will never happen
Re: Trouble.. Standby Database. Urgent!!
has log 505 made it over to the standby yet, you should start reading the docs, if log 505 is not there yet, than that is the way its SUPPOSED to work. joe Saurabh Sharma wrote: hi all, I need ur help urgently. i've created a standby database with the below mentioned steps.. 1. copied consistent backup of datafiles folder to standby site. 2. created standby control file and sent to target location. 3. switch logfile current and copied to target. 4. copied init.ora and changed parameters for standby. at the standby site. 1. startup nomountok 2. alter database mount standby database. ok 3. recover standby database ... this last recovery statement is giving lot of msgs like..log applied.. then same logfile not needed for this recovery. can not open file..etc. I'm copying the archived log from primary to standby standby_archive_dest location. here are the actual errors.. SVRMGR recover standby database; ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for thread 1 ORA-00289: suggestion : D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 ORA-00280: change 708915 for thread 1 is in sequence #505 Specify log: {RET=suggested | filename | AUTO | CANCEL} auto ORA-00308: cannot open archived log 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001 ORA-27041: unable to open file OSD-04002: unable to open file O/S-Error: (OS 2) The system cannot find the file specified. has anybody any idea of what's causing this problem. what i feel is there i may have wrongly configured the standby_archive_dest in init.ora at standby. any help is greatly appreciated. thanks. saurabh sharma -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
Heads up on nasty bug on NT
Hi all! Just a warning for those of you running Oracle on NT. There's an extremely nasty bug specific to 8.1.6/8.1.7 on NT/Win2K (not sure if it affects 8.1.5) where a datafile that is resize or autoextended exactly on a 4GB boundary cannot be resized. Bug 1668488. Options: 1. PITR prior to when the datafile extended 2. Force the db open (requires full db export and rebuild). 3. Clone a subset of the db containing the corrupted datafile(s), force it open, export affected tablespaces and import them into the original db. 4. Drop the corrupted datafiles to open the db and then drop the tablespace to which the datafiles belong. Options 2 3 can result in logical corruption as there's no way to rollback any uncommitted transactions that have already been forced to disk. Bug is not fixed in 8.1.6; it's scheduled for the 8.1.7.2 patchset. Those of you with autoextend on your datafiles should modify the maxsize to be less than 4GB or turn off autoextend. HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: Creating and Oracle 7 DB from an Oracle 8 DB
why not run version 7 export against the oracle 8 database(its been more than 4 years since i've played with a 7 database). or am i missing something here? joe Tim Allen wrote: Hi, Its a long and boring story but I have an Oracle 8 database and I need to create an Oracle 7 database from it to support one of our applications. The schema of the Oracle 8 db does not have any oo features and is, in theory, it functionally compatable with an Oracle 7 db. But I understand that there are issues with using export from oracle 8 and import to oracle 7, I.e it is incompatable. Has anyone had any experience in doing this or any suggestions on ways of doing it? And by the way the data in tables needs to be copied from 8 to 7 also. Cheers Tim Allen Designer Ramesys (Professional Services) Ltd ( Phone: 01788 822133 . Fax: 01788 822144 + Address: Eldon Way, Motorway Ind. Estate, Crick, Northants, NN6 7SL * E-mail : [mailto:[EMAIL PROTECTED]] [ The views and opinions expressed in the email are the sender's own ] [ and do not necessarily represent the views and opinions of Ramesys LTD ] -- Joe Testa http://www.oracle-dba.com Performing Remote DBA Services, need some backup DBA support? For Sale: Oracle-dba.com domain, its not going cheap but feel free to ask :) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph S. Testa 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).
problems when running dbstart
Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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).
LOT (Little OT): Interesting Oracle related URL's.
Hello everyone. I am currently finishing off our company website, and am putting together the links section. This is going to be used to link to COOL resources for Oracle, Sybase -aahem- SQLServer DBAs. I was wondering if any of you have, like me, a list of URLs that you swear by for your needs with Oracle - and of course Sybase and SQLServer (hell and DB2) if you use them. If so would you mind either posting them to the list (I'm sure others would benefit from this) or sending them directly to me? I have my own list of links, but this site is for DBAs at the end of the day, so I thought I would get your input :) Also, are there any HTML/Web experts out there that would mind giving our site the once over when I publish it to the web? I have put a fair bit of work in to it, but feedback is always extremely helpful (the site is for RDBMS tools, but this is not a plug - I'm only interested in design and usage). If so contact me off the list - [EMAIL PROTECTED] Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: dbms_java and file permissions
Thanks for taking a shot Jared. I'm just starting with Java, learnin' as I go. Sorry I didn't post the query initially. It was basically a select * from dba_java_policy wheregrantee = 'TISSD'. External calls to the OS will be as the oracle user which would be hard to limit however it is happening in certain situations and I don't know this for a fact but I believe these calls shouldn't make it to the OS if there are restrictions. I may be off on that but /export/home/oracle is also owned by Oracle and I wasn't allowed to do an ls on that directory unless I had explicitely granted permission to it. Also I can't do an ls on /u20/app/oracle/testjunk.file which is explictly restricted (still owned by Oracle on OS) but I can still ls the directory (even though I tried to restrict access) or even move the file. Strange. Here's the response I got from Metalink forums. Hi. This issue must be handled by an analyst in the Internet Languages group. Unfortunately at this time we do not have technical forum support for Internet Languages within MetaLink. For assistance from Oracle Support on this issue, you will need to log an iTAR. iTAR functionality is accessible via the TARs option on MetaLink Home. I'lltry the TAR approach and see if I get anywhere. Thanks again - Brian Jared Still [EMAIL PROTECTED] wrote: Brian,I've still gotta lot to learn about Java, but I'll takea stab at this.First off, what query did you use to produce the outputbelow?Do external processes run via Java run as Oracle? I'm guessing that they do, but I could be wrong, and don'thave time to test this right now.If so, this will likely put a limit on your abilities to restrict access to directories owned by Oracle.Hope some of this helps.JaredOn Tuesday 05 June 2001 07:41, Brian Wisniewski wrote: 8.1.7.1 on Solaris 7 I created a small java procedure to be able to call O/S commands from within the database (using Ask Tom's example). Works a little too well because I can't seem to restrict access to the oracle directories which is obviously a major concern. Here are the list of ! ! privileges I granted/restricted to the owner of the java procedure. KIND GRANTE TYPE_ TYPE_NAME NAME ACTION -- - -- -- - GRANT TISSD SYS java.io.FilePermission /export/home/oracle/bsw/scripts/java read RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/ read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/- read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/test* read,write,execute,delete RESTRICT TISSD SYS java.io.FilePermission /u20/app/oracle/testjunk.file read,write,execute,delete GRANT TISSD SYS java.io.FilePermission /usr! ! /bin/* execute GRANT TISSD SYS java.lang.RuntimePermission * writeFileDescriptor 9 rows selected. As you can see I tried numerous ways to restrict access to /u20/app/oracle files and had very limited luck. Each time I added a new restriction I logged out of the tissd account and back in. On the flip side I had to grant access to /export/home/oracle/bsw/scripts/java to allow files to be read there. I don't understand why unlimited access is being allowed to the files which should be the most restricted. The tissd user was NOT granted DBA privs nor the JAVASYSPRIV or JAVAUSERPRIV roles. I've read the 8.1.7 Java Developers Guide Chapter 5 on security and haven't found the answer there either. This worked, which I didn't think it should. SQL exec rc('/usr/bin/ls /u20/app/oracle'); admin jre oraInventory oradata oui product testjunk.file Return code is 0 And this failed. SQL exec rc('/usr/bin/ls /u20/app/oracle/*'); Return code is 2 Doing an ls on the file failed SQL exec rc('/usr/bin/ls /u20/app/oracle/testjunk.file'); Return code is 2 But moving it worked fine. AAUUUGGGHHH!!! SQL exec rc('/usr/bin/mv /u20/app/oracle/testjunk.file /u20/app/oracle/testfile.junk'); Return code is 0 Just your regular ol' IDIOT asking for HELP. Thanks - BrianDo You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail.
Re: problems when running dbstart
Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: OT RE: SUMMARY: Thanks everyone - tru64
On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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).
OT RE: organizational culture / RE: TUSC and Kevin Loney
Jaren, clue me in. what's the metric? -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/6/2001 2:20 AM On Tuesday 05 June 2001 11:13, Post, Ethan wrote: I say we all go to Steve's house and play a game of Survivor to see who the most powerfull DBA in the world is. ^^ Mladen would win. Jared -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Mohan, Ross 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: OT RE: Database writer
Paul Cantor (sp?) and Grace Slick were the driving force..i'm impressed. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/6/2001 5:41 AM Thought it was Paul Katner.. Oh well.. Mark -Original Message- Sent: Tuesday, June 05, 2001 05:07 To: Multiple recipients of list ORACLE-L No winner! I drink the freaking beer all by myself. I think I'll pour myself a Smithwick's...somewhere in Dublin...aaa! (Jefferson Starship) || -Original Message- || From: Jerry C [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, June 05, 2001 11:32 AM || To: Multiple recipients of list ORACLE-L || Subject: Re: OT RE: Database writer || || || So... no winner Ross? || || Do we get the answer?? || || || - Original Message - || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Sent: Monday, June 04, 2001 4:25 PM || || || Yea, NT blows. Blows like a fresh wind against the empire. || || || (1st one to name that song lyric reference and i buy you a beer. || NT bigots and their families summarily excused from this offer.:) || || || -Original Message- || || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || || Sent: Monday, June 04, 2001 2:16 PM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: Database writer || || || || || || Doubt, didnt' see NT, boy NT blows. || || || || I hate how it doesn't list out the processes. || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 1:18 PM || || To: [EMAIL PROTECTED]; Christopher Spence || || || || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || || Look under ps. || || || || Really? On NT? || || || || Jared || || || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 11:56 AM || || To: Multiple recipients of list ORACLE-L || || || || || || Hi all, || || I added db writer processes last week to try and || || improve performance || || of one || || of my 8.1.7 db's on NT. Does anyone know if there is a || || way to see if || || Oracle actually started the additional db writer || || processes? I added || || db_writer_processes to the init file, the instance || started so I am || || assuming || || that the db writer processes are working. But we all know || || what happens || || when we assume something. Any ideas would be appreciated. || || || || Sincerely, || || Kevin Kostyszyn || || DBA || || Dulcian, Inc || || www.dulcian.com || || [EMAIL PROTECTED] || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Christopher Spence || || 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: Mohan, Ross ||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). || || || _ || Do You Yahoo!? || Get your free @yahoo.com address at http://mail.yahoo.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jerry C || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 || San Diego, California-- Public Internet access / || Mailing Lists ||
RE: OT RE: SUMMARY: Thanks everyone - tru64
I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: OEM 2.1 cannot contact agent on a node
Hi, I think you need to install the 8.1.6 agent on the NT box in question (assuming that your OMS is on 8.1.6) Going by that logic I would love to know how 7.3.4 on the SUN node worked (I have no experience with SUN) We had a similar situation where OMS was on 8.1.7 but the other databases which were 8.1.5 had problems and it was rectified by installing the 8.1.7 agent on the systems. It worked! Someone please correct me if I am wrong coz I am a novice - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 5:13 PM Hi - me again, still having lots of fun with Oracle Enterprise Manager 2.1! Having got OMS working, I fired up the OEM 2.1 console, and gave it a list of nodes to discover. It found one of the 8.1.6 nodes (an NT box), and the 7.3.4 node (a Sun box), but failed on two others (an 8.1.6 Sun box and an 8.0.5 NT box) with the message: Discovery failed: VNI-4009: Cannot contact agent on the node. Now, the 8.1.6 Sun box hadn't got its Intelligent Agent started, so that was soon rectified. However, the 8.0.5 NT box DOES have a running Intelligent Agent (the Service name is Agent80), and on the server, the Agent80 service shows up when I do a net start command. The documentation suggested I check the server was using TCP/IP - which it is. I also came back to my workstation and tried pinging the server, and it pings successfully. But despite trying everything I can think of - even stopping and restarting the Agent80 service on the 8.0.5 box, I still can't get OEM 2.1 to discover the node successfully. Any ideas, please? Cheers, Paul Paul Vincent Database Administrator, University of Central England -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent 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: novicedba 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).
OT: Oracle price politics
Hi, Few days ago someone posted a link to a newsletter about the slashing of the prices of Oracle products in Japan and that Larry Ellison would announce price reductions that will apply worldwide. Someone can send me the link ?? TIA, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: OT-Passing variables to a awk/sed script
For something as you have described, it is relatively simple: the_val=$1 #set a script variable to the passed value cat text_file | sed s.abc/xyz.$the_val.g new_file mv new_file text_file Keep it as simple as possible. -Original Message- From: Satish Iyer [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 8:30 PM To: Multiple recipients of list ORACLE-L Subject:OT-Passing variables to a awk/sed script Hello List, This must be piece of cake for the UNIX gurus. Trying to pass parameters to a simple awk script. Getting stuck. First q., can we do that. If yes I need to solve the foll. problem, In a huge text file locate for abc/xyz and replace it with a supplied parameter value. This paramter must of course, be able to take on any value during the run of the program. Any help or tips on that would be highy appreciated. Thanks Satish File: ATT8.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: William Rogge 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: LOT (Little OT): Interesting Oracle related URL's.
This list is by far incomplete, but it is the links i have on my site currently. I have about 50-100 different sites, I only put the ones I most frequently use or like on my site. I am going to go through the rest and finishing adding links as well. I left out some good ones here I know, but my list is currently at home not here as I just cleaning up my machine. IXOra.com (Steve Adam's Site) http://ixora.com.au/ Oracle Technet http://technet.oracle.com OraPub (Craig Shallahamer's Website) www.orapub.com DBA Support http://www.dbasupport.com/ Thomas Kyte's Website http://osi.oracle.com/~tkyte/ Connor McDonald's Web Site http://www.oracledba.co.uk/ Hotsos (Cary Millsap's Site) www.hotsos.com Jared Still's Website http://www.cybcon.com/~jkstill/util/util_master.html Thomas Cox's Website http://www.geocities.com/tbcox23/ Evergreen Database Technologies http://www.evdbt.com/ Biju's Web Site http://www.bijoos.com/oracle/index.htm OraBugFinder http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html Vampire D's Oracle Den (Christopher R. Spence's Site) www.vampired.net Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, June 06, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Hello everyone. I am currently finishing off our company website, and am putting together the links section. This is going to be used to link to COOL resources for Oracle, Sybase -aahem- SQLServer DBAs. I was wondering if any of you have, like me, a list of URLs that you swear by for your needs with Oracle - and of course Sybase and SQLServer (hell and DB2) if you use them. If so would you mind either posting them to the list (I'm sure others would benefit from this) or sending them directly to me? I have my own list of links, but this site is for DBAs at the end of the day, so I thought I would get your input :) Also, are there any HTML/Web experts out there that would mind giving our site the once over when I publish it to the web? I have put a fair bit of work in to it, but feedback is always extremely helpful (the site is for RDBMS tools, but this is not a plug - I'm only interested in design and usage). If so contact me off the list - [EMAIL PROTECTED] Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Christopher Spence 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: OT RE: SUMMARY: Thanks everyone - tru64
Can I try out for a flying monkey role! :o) -Original Message- Sent: Wednesday, June 06, 2001 8:11 AM To: Multiple recipients of list ORACLE-L I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Farnsworth, Dave 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: OT RE: SUMMARY: Thanks everyone - tru64
PLEASE I want to be the wicked witch!!! 8] April Wells Corporate Systems Amarillo Texas -Original Message- Sent: Wednesday, June 06, 2001 8:41 AM To: Multiple recipients of list ORACLE-L Can I try out for a flying monkey role! :o) -Original Message- Sent: Wednesday, June 06, 2001 8:11 AM To: Multiple recipients of list ORACLE-L I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Farnsworth, Dave 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). The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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: SUMMARY: Thanks everyone - tru64
According to a technical representative at Oracle in Rochester, NY, Oracle no longer develops on Solaris. He stated that they have changed to HP-UX for development. He said the reason was instability with Solaris. "Koivu, Lisa" wrote: Kevin, sure I will. I just didn't want to muck up the list. Here's what I found. If anyone has any comments to add, please do. My question was about the utilities across different flavors of Unix and if they mean the same thing. vmstat, iostat are the same, however the switches may be a bit different. sar is system V only. truss you must purchase a license for. top is freeware. There is a utility called 'collect' that does something similar to top. The response regarding tru64 has been overwhelmingly positive. Some of the positive comments I received: 1. C compiler (Kernighan and Richie) is not ANSI compliant and may affect any 3rd party apps. 2. Compaq hardware used to be lagging in Oracle (Apps) patch releases. Not anymore. 3. The journaling filesystem makes mistakes like unplugging the wrong cord (oops!) a simple fix instead of hours of downtime. 4. Security - Since tru64 is not 'mainstream', e.g. marketed everywhere extremely popular, intimate knowledge for hacking the os is not widely known. So obscurity works in your favor. 5. Clustering technology is mature, solid and proven. 6. tru64 is indeed a first tier platform for Oracle. 7. Compaq's support is rated as 'very helpful'. 8. tru64 has the ability to quickly clone a filesystem. 9. OPS can reside on a filesystem on tru64. 10. Benchmarking Solaris E10K/64CPU against Compaq GS-160/16CPU favored the Compaq! WOW 11. For 9i, Oracle licensed also the TruCluster technology from Compaq. Oracle RAC (Real Application Cluster, new names for OPS) for 9i will only initially be available on tru64, truly first tier. Caveats/ Other comments: 1. Sun, relying on their own proprietary hardware, may be hurting themselves in the long run. 2. Sun is ex-pen-sive! Compaq wins in this comparison. 3. The future of Sun and Compaq seems a bit shaky right now, but they should pull through in the long run. 4. There's a bug in tru64 that doesn't allow one listener to service databases with different versions. Workaround is multiple listeners (no big deal) 5. Oracle does develop on Sun hardware. Calling OWWS for a Solaris system may net an answer quicker than running tru64. 6. Avoid the ultra sparc-2 chips from Sun. They have a problem with bad caches causing random reboots. I saw this at a previous employer. 7. If it's possible, consider IBM/AIX. IBM's sales force is highly trained in administration so you can talk real system architecture with them (not that I'm an admin or architect, I am neither). IBM's support is also top notch. Special thanks to the following people for their responses: Scott Shafer Ron Morton Lee Robertson Jerry Hess Michael Hand Murali Vallath Joe Hatchel Mike Kurt Ray Stell Darren Browett Stephen Andert Stefan Moeding And, the one and only clown Ross Mohan Like I said, I'm overwhelmed at how helpful everyone is. -Original Message- From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: Thanks everyone - tru64 Lisa: How about contributing a summary of the feedback? Kevin -Original Message- Sent: Tuesday, June 05, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I just wanted to say thank you to everyone who responded to me when I asked for info on tru64 Unix. I received much more info and feedback than I ever expected! This list is extremely helpful and I am very appreciative of how willing people are to answer questions. I just hope I contribute enough to make up for how much everyone here has helped me. HELP! Have a great day, all. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about viruses and other defects. Cendant Corporation or Affiliates are not liable for any loss or damage arising in any way from this message or its attachments. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Toepke, Kevin M INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing
Re: How to remove corrupted blocks from datafile.
I'm sure you'll receive lots of good advice, but here goes some more (maybe not good?): The Velpuri Backup and Recovery book has some very good descriptions of exactly how to cope with this. There are a number of packages you can use to flag the blocks as bad and effectively stop them from being used, or recover them, whichever the case may be. Of course, it's always a good idea to check the actual hardware first! Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, 6 June 2001 06:42 Hi, I found some corrupted blocks in one of the datafile. I have created the temp table by select all the records (excluding the records in corrupted blocks) from corrupted table, and dropped the table, renamed the temp table back to original. After this when i run DBV on that file, it still shows there are some corrupted blocks in the file. i have two questions, 1 How do i calculate how many records i have lost? 2 How do i remove corrupted blocks from the blocks? Can anyone tell me ... Thanks in advance Uday -- 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: OT RE: SUMMARY: Thanks everyone - tru64
I'd like to apply for evil-flying-monkey-thing or failing that, the muchkin who says Follow the yellow brick road! first. I have previous experience of being evil, flying and saying Follow the yellow brick road!. I have studied being a monkey to degree level. I'm ready for my closeup. Regards, Mike Hately, Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Heads up on nasty bug on NT
Shouldn't you have just stopped at the first sentance :-)) -Original Message- Sent: 06 June 2001 12:56 To: Multiple recipients of list ORACLE-L Hi all! Just a warning for those of you running Oracle on NT. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: SV: problems when running dbstart
You should rename it to max_transaction_branches . It's a typo error. I do typo errors very frequently, too. Mikael Granhed wrote: Thanks for your help, now it doesn't complain about "open_links" when i rename it. Now it's problem with the "max_transaktion_bransches". Should I rename that variable too? /Mikael -Ursprungligt meddelande- Frn: Danisment Gazi Unal (Unal Bilisim) [SMTP:[EMAIL PROTECTED]] Skickat: den 6 juni 2001 15:01 Till: Multiple recipients of list ORACLE-L mne: Re: problems when running dbstart Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: Mikael Granhed 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California
SV: problems when running dbstart
Thanks for your help, now it doesn't complain about open_links when i rename it. Now it's problem with the max_transaktion_bransches. Should I rename that variable too? /Mikael -Ursprungligt meddelande- Från: Danisment Gazi Unal (Unal Bilisim) [SMTP:[EMAIL PROTECTED]] Skickat: den 6 juni 2001 15:01 Till: Multiple recipients of list ORACLE-L Ämne: Re: problems when running dbstart Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: Mikael Granhed 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: OT RE: SUMMARY: Thanks everyone - tru64
On Wed, 6 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: - -I wonder if we on the list made our own show of Wizard of OZ -who would be the StrawMan, TinMan, Lion, and, well...Dorothy. - -Applications are being accepted for good witch, bad witch, and -the wizard, of course. - -I've got dibs on ToTo i'll stick to Shrek, fits me better. i'm just an ogernight sucess.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Creating and Oracle 7 DB from an Oracle 8 DB
Tim, AFAIK you can run the version 7 export utility against the version 8 database, but you have to run the catexp7.sql script on the 8 database? Something like that.. have never done it :) Regards Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Tim AllenSent: Wednesday, June 06, 2001 10:06To: Multiple recipients of list ORACLE-LSubject: Creating and Oracle 7 DB from an Oracle 8 DB Hi, Its a long and boring story but I have an Oracle8 database andI need to create anOracle 7 database from it to support one of our applications. The schema of the Oracle 8 db does not have any oo features and is, in theory, it functionally compatable with an Oracle 7 db. But I understand that there are issues with using export from oracle 8 and import to oracle 7, I.e it is incompatable. Has anyone had any experience in doing this or any suggestions on ways of doing it? And by the way the data in tables needs to be copied from 8 to 7 also. Cheers Tim AllenDesignerRamesys (Professional Services) Ltd( Phone: 01788 822133 . Fax : 01788 822144 + Address : Eldon Way, Motorway Ind. Estate, Crick, Northants, NN6 7SL * E-mail : [mailto:tim.allen@ramesys.com] [ The views and opinions expressed in the email are the sender's own ][ and do not necessarily represent the views and opinions of Ramesys LTD ]
Re: organizational culture / RE: TUSC and Kevin Loney
On Tue, 5 Jun 2001,Jared Still scribbled on the wall in glitter crayon: -On Tuesday 05 June 2001 11:13, Post, Ethan wrote: - I say we all go to Steve's house and play a game of Survivor to see who - the most powerfull DBA in the world is. - ^^ - -Mladen would win. - -Jared - - that would depend on the game of survivor we played.;-) i do admit to having soem experience at it.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William 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: Oracle price politics
--- Forwarded Message Follows --- ERPcentral - http://www.erpcentral.com Oracle slashes prices in Japan. Global cuts next? http://www.erpcentral.com cw360.com June 4, 2001 Oracle could be on the verge of announcing significant price cuts around the world after its Japanese operation slashed database prices this week. The company is refusing to comment on speculation, saying chief executive officer Larry Ellison will be making a major pricing announcement to coincide with the launch of the 9i database at Oracle OpenWorld later this month. Oracle confronts pricing, user issues http://www.erpcentral.com Computerworld June 4, 2001 Cuts pricing in Japan Dan Verton, Computerworld Oracle Corp.'s Japanese unit last week slashed prices for the company's database software by 25 percent and increased volume discounts to 35 percent, raising hopes among U.S. users that the cuts herald lower prices here. Street Fight: Oracle http://www.erpcentral.com Forbes.com, June 4, 2001 With sagging earnings and lack of guidance for its soon-to-be-announced fourth quarter, Oracle has been slapped with no less than nine analyst downgrades since early March. Shares of the database software provider have dropped 67% from their 52-week high, giving the stock a latest 12-month price-to-earnings ratio of just 14. Is it time to buy America's second-largest independent software concern? --- If you enjoy reading ERPCentral's Newsletter, please tell a friend or colleague about it. Anyone can sign up for a free subscription on our Web site at http://www.erpcentral.com (c) Copyright 2000 Idem Est Technologies Ltd. All rights reserved. All product names contained herein are the trademarks of their respective holders. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 02:46 To: Multiple recipients of list ORACLE-L Hi, Few days ago someone posted a link to a newsletter about the slashing of the prices of Oracle products in Japan and that Larry Ellison would announce price reductions that will apply worldwide. Someone can send me the link ?? TIA, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Mark Leith 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).
dbms_utility.analyze_schema OR dbms_stats ?
Oracle 8.1.7 AIX 4.3.3 I looked at the docs and it appears Oracle wants you to use dbms_stats to generate statistics for cbo. I am currently using dbms_utility.analyze_schema. Should I change to dbms_stats (i know it doesnt give you chained rows, avg free space, # of unused blocks)? Are there any advantages over dbms_utility.analyze_schema? What does everyone here use to generate their stats? Thanks. Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: OT RE: SUMMARY: Thanks everyone - tru64
As I stand a towering 5 feet 7, I could always qualify as a member of the Lollipop League or was that Guild Lee -Original Message- Sent: 06 June 2001 14:11 To: Multiple recipients of list ORACLE-L I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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).
Help for Unix text file processing
Hey all, I am looking for some commands like ( grep, egrep, sed etc) to do the following on a Unix box. 1. Command to take out all the blank line from a text file. The blank line may include tabs and whitespaces. 2. Command to take out the trailing and starting blanks and tabs from the each line of the text file. 3. Command for the above two tasks combined. Thanks in advance. Dharminder Kumar This e-mail and any attachments may contain confidential and privileged information. If you are not the intended recipient, please notify the sender immediately by return e-mail, delete this e-mail and destroy any copies. Any dissemination or use of this information by a person other than the intended recipient is unauthorized and may be illegal. Unless otherwise stated, opinions expressed in this e-mail are those of the author and are not endorsed by the author's employer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kumar, Dharminder 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: SUMMARY: Thanks everyone - tru64
This surely does sound the Wiz of Oz, Solaris unstable ? Tru64, get real. -Original Message- From: Scott Canaan [mailto:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:31 AM To: Multiple recipients of list ORACLE-L Subject: Re: SUMMARY: Thanks everyone - tru64 According to a technical representative at Oracle in Rochester, NY, Oracle no longer develops on Solaris. He stated that they have changed to HP-UX for development. He said the reason was instability with Solaris. Koivu, Lisa wrote: Kevin, sure I will. I just didn't want to muck up the list. Here's what I found. If anyone has any comments to add, please do. My question was about the utilities across different flavors of Unix and if they mean the same thing. vmstat, iostat are the same, however the switches may be a bit different. sar is system V only. truss you must purchase a license for. top is freeware. There is a utility called 'collect' that does something similar to top. The response regarding tru64 has been overwhelmingly positive. Some of the positive comments I received: 1. C compiler (Kernighan and Richie) is not ANSI compliant and may affect any 3rd party apps. 2. Compaq hardware used to be lagging in Oracle (Apps) patch releases. Not anymore. 3. The journaling filesystem makes mistakes like unplugging the wrong cord (oops!) a simple fix instead of hours of downtime. 4. Security - Since tru64 is not 'mainstream', e.g. marketed everywhere extremely popular, intimate knowledge for hacking the os is not widely known. So obscurity works in your favor. 5. Clustering technology is mature, solid and proven. 6. tru64 is indeed a first tier platform for Oracle. 7. Compaq's support is rated as 'very helpful'. 8. tru64 has the ability to quickly clone a filesystem. 9. OPS can reside on a filesystem on tru64. 10. Benchmarking Solaris E10K/64CPU against Compaq GS-160/16CPU favored the Compaq! WOW 11. For 9i, Oracle licensed also the TruCluster technology from Compaq. Oracle RAC (Real Application Cluster, new names for OPS) for 9i will only initially be available on tru64, truly first tier. Caveats/ Other comments: 1. Sun, relying on their own proprietary hardware, may be hurting themselves in the long run. 2. Sun is ex-pen-sive! Compaq wins in this comparison. 3. The future of Sun and Compaq seems a bit shaky right now, but they should pull through in the long run. 4. There's a bug in tru64 that doesn't allow one listener to service databases with different versions. Workaround is multiple listeners (no big deal) 5. Oracle does develop on Sun hardware. Calling OWWS for a Solaris system may net an answer quicker than running tru64. 6. Avoid the ultra sparc-2 chips from Sun. They have a problem with bad caches causing random reboots. I saw this at a previous employer. 7. If it's possible, consider IBM/AIX. IBM's sales force is highly trained in administration so you can talk real system architecture with them (not that I'm an admin or architect, I am neither). IBM's support is also top notch. Special thanks to the following people for their responses: Scott Shafer Ron Morton Lee Robertson Jerry Hess Michael Hand Murali Vallath Joe Hatchel Mike Kurt Ray Stell Darren Browett Stephen Andert Stefan Moeding And, the one and only clown Ross Mohan Like I said, I'm overwhelmed at how helpful everyone is. -Original Message- From: Toepke, Kevin M [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Subject: RE: Thanks everyone - tru64 Lisa: How about contributing a summary of the feedback? Kevin -Original Message- Sent: Tuesday, June 05, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I just wanted to say thank you to everyone who responded to me when I asked for info on tru64 Unix. I received much more info and feedback than I ever expected! This list is extremely helpful and I am very appreciative of how willing people are to answer questions. I just hope I contribute enough to make up for how much everyone here has helped me. HELP! Have a great day, all. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the recipient accepts full responsibility for taking protective and remedial action about
Re: problems when running dbstart
See http://tahiti.oracle.com/pls/tahiti/tahiti.initora for a list of all init params.. -Joe - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 9:51 AM Thanks for your help, now it doesn't complain about open_links when i rename it. Now it's problem with the max_transaktion_bransches. Should I rename that variable too? /Mikael -Ursprungligt meddelande- Från: Danisment Gazi Unal (Unal Bilisim) [SMTP:[EMAIL PROTECTED]] Skickat: den 6 juni 2001 15:01 Till: Multiple recipients of list ORACLE-L Ämne: Re: problems when running dbstart Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: Mikael Granhed 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). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Raube 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: OT RE: Database writer
Does that mean I can get a beer? -Original Message- Sent: Wednesday, June 06, 2001 01:08 To: 'Mark Leith '; 'Multiple recipients of list ORACLE-L ' Paul Cantor (sp?) and Grace Slick were the driving force..i'm impressed. -Original Message- To: Multiple recipients of list ORACLE-L Sent: 6/6/2001 5:41 AM Thought it was Paul Katner.. Oh well.. Mark -Original Message- Sent: Tuesday, June 05, 2001 05:07 To: Multiple recipients of list ORACLE-L No winner! I drink the freaking beer all by myself. I think I'll pour myself a Smithwick's...somewhere in Dublin...aaa! (Jefferson Starship) || -Original Message- || From: Jerry C [mailto:[EMAIL PROTECTED]] || Sent: Tuesday, June 05, 2001 11:32 AM || To: Multiple recipients of list ORACLE-L || Subject: Re: OT RE: Database writer || || || So... no winner Ross? || || Do we get the answer?? || || || - Original Message - || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || Sent: Monday, June 04, 2001 4:25 PM || || || Yea, NT blows. Blows like a fresh wind against the empire. || || || (1st one to name that song lyric reference and i buy you a beer. || NT bigots and their families summarily excused from this offer.:) || || || -Original Message- || || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || || Sent: Monday, June 04, 2001 2:16 PM || || To: Multiple recipients of list ORACLE-L || || Subject: RE: Database writer || || || || || || Doubt, didnt' see NT, boy NT blows. || || || || I hate how it doesn't list out the processes. || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 1:18 PM || || To: [EMAIL PROTECTED]; Christopher Spence || || || || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || || Look under ps. || || || || Really? On NT? || || || || Jared || || || || || || Walking on water and developing software from a || || specification are easy if || || both are frozen. || || || || Christopher R. Spence || || Oracle DBA || || Fuelspot || || || || || || || || -Original Message- || || Sent: Monday, June 04, 2001 11:56 AM || || To: Multiple recipients of list ORACLE-L || || || || || || Hi all, || || I added db writer processes last week to try and || || improve performance || || of one || || of my 8.1.7 db's on NT. Does anyone know if there is a || || way to see if || || Oracle actually started the additional db writer || || processes? I added || || db_writer_processes to the init file, the instance || started so I am || || assuming || || that the db writer processes are working. But we all know || || what happens || || when we assume something. Any ideas would be appreciated. || || || || Sincerely, || || Kevin Kostyszyn || || DBA || || Dulcian, Inc || || www.dulcian.com || || [EMAIL PROTECTED] || || -- || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || -- || || Author: Christopher Spence || || 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: Mohan, Ross ||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). || || || _ || Do You Yahoo!? || Get your free @yahoo.com address at http://mail.yahoo.com || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Jerry C || INET: [EMAIL PROTECTED] || || Fat City Network Services-- (858) 538-5051
RE: problems when running dbstart
It should be MAX_TRANSACTION_BRANCHES Unless it is all in another language? And Oracle works with other languages? Maybe.. Mark -Original Message- Granhed Sent: Wednesday, June 06, 2001 02:51 To: Multiple recipients of list ORACLE-L Thanks for your help, now it doesn't complain about open_links when i rename it. Now it's problem with the max_transaktion_bransches. Should I rename that variable too? /Mikael -Ursprungligt meddelande- Från: Danisment Gazi Unal (Unal Bilisim) [SMTP:[EMAIL PROTECTED]] Skickat: den 6 juni 2001 15:01 Till: Multiple recipients of list ORACLE-L Ämne: Re: problems when running dbstart Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) 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: Mikael Granhed 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: Mark Leith 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: LOT (Little OT): Interesting Oracle related URL's.
Just to add http://www.jlcomp.demon.co.uk for Johnathan Lewis's excellent site Cheers Connor --- Christopher Spence [EMAIL PROTECTED] wrote: This list is by far incomplete, but it is the links i have on my site currently. I have about 50-100 different sites, I only put the ones I most frequently use or like on my site. I am going to go through the rest and finishing adding links as well. I left out some good ones here I know, but my list is currently at home not here as I just cleaning up my machine. IXOra.com (Steve Adam's Site) http://ixora.com.au/ Oracle Technet http://technet.oracle.com OraPub (Craig Shallahamer's Website) www.orapub.com DBA Support http://www.dbasupport.com/ Thomas Kyte's Website http://osi.oracle.com/~tkyte/ Connor McDonald's Web Site http://www.oracledba.co.uk/ Hotsos (Cary Millsap's Site) www.hotsos.com Jared Still's Website http://www.cybcon.com/~jkstill/util/util_master.html Thomas Cox's Website http://www.geocities.com/tbcox23/ Evergreen Database Technologies http://www.evdbt.com/ Biju's Web Site http://www.bijoos.com/oracle/index.htm OraBugFinder http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html Vampire D's Oracle Den (Christopher R. Spence's Site) www.vampired.net Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, June 06, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Hello everyone. I am currently finishing off our company website, and am putting together the links section. This is going to be used to link to COOL resources for Oracle, Sybase -aahem- SQLServer DBAs. I was wondering if any of you have, like me, a list of URLs that you swear by for your needs with Oracle - and of course Sybase and SQLServer (hell and DB2) if you use them. If so would you mind either posting them to the list (I'm sure others would benefit from this) or sending them directly to me? I have my own list of links, but this site is for DBAs at the end of the day, so I thought I would get your input :) Also, are there any HTML/Web experts out there that would mind giving our site the once over when I publish it to the web? I have put a fair bit of work in to it, but feedback is always extremely helpful (the site is for RDBMS tools, but this is not a plug - I'm only interested in design and usage). If so contact me off the list - [EMAIL PROTECTED] Cheers Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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: Christopher Spence 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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 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
Re: OPS, TAF and jAVA
I have seen number of TAF papers on metalink and google. But wanted to get some user experience. This input is great. Thanks Murali Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Date: Tue, 05 Jun 2001 01:19:36 -0800 Yes. Search on MetaLink. Look in the Net8 docs. There are a lot of options and some significant constraints. It might take a while for you to do the research and analysis and to figure out what works best for your system(s), running your application(s). Attached is one paper, but don't stop with it alone. It was simply handy, so I attached it. I don't remember where I got it - probably off MetaLink, but it could be an extract from the Oracle docs. The formatting is butt-ugly, so it was probably a cut-and-paste deal. I chose it to include because it doesn't gloss over the transparent application failover bit as much as most. It isn't entirely transparent in all (many?) cases! See the section 6. Coding for Failover in the attached file. There is some much more detailed information on this somewhere - I just don't have it at hand. When I was initially researching this, I found a long daisy chain of references on MetaLink. You didn't mention what version of Oracle you are using - on the server or on the client(s)! It is important. For example, I believe that dynamic instance registration is only available in 8i. Instance roles in an 8i OPS environment may make a difference also. The construction of the clients' tnsnames.ora entries will likely depend on the client version as well - and you may have several different client versions to contend with. TAF against an OPS cluster works very well if the application is amenable and everything is configured properly. I have set it up so that most connections/sessions/queries into an extremely hot OLTP system could automagically fail over to an alternate node within 20 seconds in most outage scenarios. (Your mileage may vary - considerably.) Be aware of the TCP timeout issue - as mentioned in this paper. Tuning TCP timeout is not an Oracle issue, it is a system issue, but if a node goes entirely belly up, your client connections will be waiting on a TCP timeout. Don't forget to tune and test it. Tuning instance recovery is important to minimize the brownout period - the time required for a surviving instance to perform instance recovery on behalf of a failed instance and for reconfiguration of the lock table,... This can be somewhat bounded in 8i. There is some material on this in the OPS manuals and in the Oracle8i Tuning manual. Most importantly, test everything rigorously - instance failure, listener failure, node crash, all types of clients, etc. You don't want your application to hang when something goes wrong on that brand new highly available OPS system for which you just spent the big bucks! Also, have a plan for switch-back and/or fail-back - perhaps different mechanisms for different clients and different server-side processes. Considering the entire processing cycle of the application is sometimes not considered early enough in the planning. How are cron jobs and other batch-lookin' thingies going to behave? How will they fail over in the event of a prolonged node outage? When can they switch-back to their primary home without clobbering performance by inducing mass quantities of OPS overhead? How do you choreograph the entire inter-node process shifting ballet for both fail-over and switch|fail-back? Is there a central autority or does each client do its own thing? (TAF implies the latter). What happens if there is some kind of false alarm? (e.g. What if only half the clients fail over - due to a localized transient network glitch perhaps? Does that induce extreme OPS-specific performance problems?) I can't speak to Java. (Heck, I can't even speak Java!) However, there seem to be significant differences between the TAF capabilities of thick and thin Java since thick is (?) built on an OCI layer, but thin isn't. (And there can be significant differences in thick thin compatibility/issues with CURSOR_SHARING=FORCE! Or so I hear.) Thankfully, your request was quite reasonable - guidelines, concerns, tips, etc. I hope this helps, but it is definitely going to take some work on your part! I'm not trying to scare you, or anyone else, off of OPS. I just have visions/nightmares about what will happen when 9i (You won't need a DBA anymore! ) and Real Application Clusters (Easy, trouble-free parallel server for the masses! ) hit the street! OPS may not be rocket science, but it isn't exacty paint by the numbers either. And I'll wager that even a much more user-friendly RAC still won't be, in spite any propaganda to the contrary! -Don Granaman [Certifiable OraSaurus] OPS - Not just for breakfast anymore! - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, June 04, 2001 11:22 AM We are looking at
stupid question about indexes and partitions
Ok i have a table range partitioned on date. I have prefixed local indexes also. so far so good. I created an index, non partitioned, using simple create index index_name on table(field20); Is that now assumed to be a global index? I can't find any docs to say one way or the other. thanks, joe Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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).
TWO-TASK SERVER ????
Hi Friends Iam getting this error frequently..So could you guys explain what's about it?? and What I need it do?? Mine is oracle8 on NT *** 2001.06.01.19.48.37.703 *** SESSION ID:(89.7330) 2001.06.01.19.48.37.703 FATAL ERROR IN TWO-TASK SERVER: error = 12571 *** 2001.06.01.19.48.37.703 ksedmp: internal or fatal error Current SQL information unavailable - no session. - Call Stack Trace - TIA Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota 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: OT RE: Database writer
sigh :) Mark, I'll be as happy as you if I can get my stars and stripes ass over to GB and buy us *both* a Smithwick's. || -Original Message- || From: Mark Leith [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, June 06, 2001 9:26 AM || To: Lyris; Mohan, Ross || Subject: RE: OT RE: Database writer || || || Does that mean I can get a beer? || || -Original Message- || From: Mohan, Ross [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, June 06, 2001 01:08 || To: 'Mark Leith '; 'Multiple recipients of list ORACLE-L ' || Subject: RE: OT RE: Database writer || || || Paul Cantor (sp?) and Grace Slick were || the driving force..i'm impressed. || || -Original Message- || From: Mark Leith || To: Multiple recipients of list ORACLE-L || Sent: 6/6/2001 5:41 AM || Subject: RE: OT RE: Database writer || || Thought it was Paul Katner.. || || Oh well.. || || Mark || || -Original Message- || Sent: Tuesday, June 05, 2001 05:07 || To: Multiple recipients of list ORACLE-L || || || No winner! I drink the freaking beer all by myself. || || I think I'll pour myself a Smithwick's...somewhere in || Dublin...aaa! || || || (Jefferson Starship) || || || -Original Message- || || From: Jerry C [mailto:[EMAIL PROTECTED]] || || Sent: Tuesday, June 05, 2001 11:32 AM || || To: Multiple recipients of list ORACLE-L || || Subject: Re: OT RE: Database writer || || || || || || So... no winner Ross? || || || || Do we get the answer?? || || || || || || - Original Message - || || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || || Sent: Monday, June 04, 2001 4:25 PM || || || || || || Yea, NT blows. Blows like a fresh wind against the empire. || || || || || || (1st one to name that song lyric reference and i buy || you a beer. || || NT bigots and their families summarily excused from || this offer.:) || || || || || -Original Message- || || || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || || || Sent: Monday, June 04, 2001 2:16 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: RE: Database writer || || || || || || || || || Doubt, didnt' see NT, boy NT blows. || || || || || || I hate how it doesn't list out the processes. || || || || || || Walking on water and developing software from a || || || specification are easy if || || || both are frozen. || || || || || || Christopher R. Spence || || || Oracle DBA || || || Fuelspot || || || || || || || || || || || || -Original Message- || || || Sent: Monday, June 04, 2001 1:18 PM || || || To: [EMAIL PROTECTED]; Christopher Spence || || || || || || || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || || || Look under ps. || || || || || || Really? On NT? || || || || || || Jared || || || || || || || || || Walking on water and developing software from a || || || specification are easy if || || || both are frozen. || || || || || || Christopher R. Spence || || || Oracle DBA || || || Fuelspot || || || || || || || || || || || || -Original Message- || || || Sent: Monday, June 04, 2001 11:56 AM || || || To: Multiple recipients of list ORACLE-L || || || || || || || || || Hi all, || || || I added db writer processes last week to try and || || || improve performance || || || of one || || || of my 8.1.7 db's on NT. Does anyone know if there is a || || || way to see if || || || Oracle actually started the additional db writer || || || processes? I added || || || db_writer_processes to the init file, the instance || || started so I am || || || assuming || || || that the db writer processes are working. But we all know || || || what happens || || || when we assume something. Any ideas would be appreciated. || || || || || || Sincerely, || || || Kevin Kostyszyn || || || DBA || || || Dulcian, Inc || || || www.dulcian.com || || || [EMAIL PROTECTED] || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Christopher Spence || || || 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: Mohan, Ross || ||INET:
RE: Heads up on nasty bug on NT
Thanks for the input... rgds amar -Original Message- Sent: Wednesday, June 06, 2001 5:57 PM To: Multiple recipients of list ORACLE-L Shouldn't you have just stopped at the first sentance :-)) -Original Message- Sent: 06 June 2001 12:56 To: Multiple recipients of list ORACLE-L Hi all! Just a warning for those of you running Oracle on NT. The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe 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: Amar Kumar Padhi 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: Renaming columns ...
I have done this on 8.1.6 by : Altering the table to add the new column; Copying the contents of the old column to the new one; Altering the table to drop the old column... [EMAIL PROTECTED]@fatcity.com on 06/05/2001 06:13:49 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: This will work: RENAME TABLE_NAME TO table_name_2; create table TABLE_NAME as select * from table_name_2; DROP TABLE table_name_2; Note you don't need to issue a 'commit' after after create table or drop table. Also, when you do create table as select from another table there is no need to specify the columns. The new table you created will have the same columns as the tables you're selecting your data from. -Original Message- From: Helen rwulfjeq [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 3:45 PM To: Multiple recipients of list ORACLE-L Subject: RE: Renaming columns ... will this work? RENAME TABLE_NAME TO table_name_2; create table TABLE_NAME ( column_name_you_want...) as select * from table_name_2; COMMIT; DROP TABLE table_name_2; COMMIT; HTH Deshpande, Kirti [EMAIL PROTECTED] wrote: Hi Raj, 1. There is a way to do it. And Mr. Steve A. has some good info about it ( its implications) on his web site. (Sorry I do not have a direct URL link to it). I believe this works for all versions. 2. Yes, it does. I have played with it on my test database. However, I will not do this on a Production database as it involves a direct DML to modify sys.COL$. And Oracle does not recommend doing such things to your databases. I am not sure if renaming column is supported in 9i. Anyone else know for sure? If you are using 8i, the safe way to address this is to add a new column to the table, populate it with the contents from the old, and drop the old column. If the column is not nullable, and if there are plenty of nullable columns towards the end of the table, I suggest considering reorganization of the table. I just did that (! ! reorg) in the last couple of weeks with a 60Mil row table to get the new not nullable columns towards the 'head' of the table. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jamadagni, Rajendra [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 8:51 AM To: Multiple recipients of list ORACLE-L Subject: Renaming columns ... Hi all, although I am searching information on Metalink and OTN, I just want to ask this question to the list ... 1. Is it possible to rename a column? (we have lots of columns that need to be renamed). Which version supports it? 2. Does renaming automatically takes care of indexes? Coding will be a lot of manual labor, but that's okay we can handle it. Thanks in advanc! ! e 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 ! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti 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). Do You Yahoo!? Yahoo! Mail Personal Address - Get email at your own domain with Yahoo! Mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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
Re: OT RE: SUMMARY: Thanks everyone - tru64
Well, I'm one of the Munchkins. Terry Mohan, Ross wrote: I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Terry Ball 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: SUMMARY: Thanks everyone - tru64
Yea, Lisa get real. Next time, don't talk to anyone or do any research. Just follow the party line, OK? :) -Original Message- Sent: Wednesday, June 06, 2001 10:42 AM To: Multiple recipients of list ORACLE-L This surely does sound the Wiz of Oz, Solaris unstable ? Tru64, get real. -Original Message- Sent: Wednesday, June 06, 2001 9:31 AM To: Multiple recipients of list ORACLE-L According to a technical representative at Oracle in Rochester, NY, Oracle no longer develops on Solaris. He stated that they have changed to HP-UX for development. He said the reason was instability with Solaris. Koivu, Lisa wrote: Kevin, sure I will. I just didn't want to muck up the list. Here's what I found. If anyone has any comments to add, please do. My question was about the utilities across different flavors of Unix and if they mean the same thing. vmstat, iostat are the same, however the switches may be a bit different. sar is system V only. truss you must purchase a license for. top is freeware. There is a utility called 'collect' that does something similar to top. The response regarding tru64 has been overwhelmingly positive. Some of the positive comments I received: 1. C compiler (Kernighan and Richie) is not ANSI compliant and may affect any 3rd party apps. 2. Compaq hardware used to be lagging in Oracle (Apps) patch releases. Not anymore. 3. The journaling filesystem makes mistakes like unplugging the wrong cord (oops!) a simple fix instead of hours of downtime. 4. Security - Since tru64 is not 'mainstream', e.g. marketed everywhere extremely popular, intimate knowledge for hacking the os is not widely known. So obscurity works in your favor. 5. Clustering technology is mature, solid and proven. 6. tru64 is indeed a first tier platform for Oracle. 7. Compaq's support is rated as 'very helpful'. 8. tru64 has the ability to quickly clone a filesystem. 9. OPS can reside on a filesystem on tru64. 10. Benchmarking Solaris E10K/64CPU against Compaq GS-160/16CPU favored the Compaq! WOW 11. For 9i, Oracle licensed also the TruCluster technology from Compaq. Oracle RAC (Real Application Cluster, new names for OPS) for 9i will only initially be available on tru64, truly first tier. Caveats/ Other comments: 1. Sun, relying on their own proprietary hardware, may be hurting themselves in the long run. 2. Sun is ex-pen-sive! Compaq wins in this comparison. 3. The future of Sun and Compaq seems a bit shaky right now, but they should pull through in the long run. 4. There's a bug in tru64 that doesn't allow one listener to service databases with different versions. Workaround is multiple listeners (no big deal) 5. Oracle does develop on Sun hardware. Calling OWWS for a Solaris system may net an answer quicker than running tru64. 6. Avoid the ultra sparc-2 chips from Sun. They have a problem with bad caches causing random reboots. I saw this at a previous employer. 7. If it's possible, consider IBM/AIX. IBM's sales force is highly trained in administration so you can talk real system architecture with them (not that I'm an admin or architect, I am neither). IBM's support is also top notch. Special thanks to the following people for their responses: Scott Shafer Ron Morton Lee Robertson Jerry Hess Michael Hand Murali Vallath Joe Hatchel Mike Kurt Ray Stell Darren Browett Stephen Andert Stefan Moeding And, the one and only clown Ross Mohan Like I said, I'm overwhelmed at how helpful everyone is. -Original Message- Sent: Tuesday, June 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Lisa: How about contributing a summary of the feedback? Kevin -Original Message- Sent: Tuesday, June 05, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I just wanted to say thank you to everyone who responded to me when I asked for info on tru64 Unix. I received much more info and feedback than I ever expected! This list is extremely helpful and I am very appreciative of how willing people are to answer questions. I just hope I contribute enough to make up for how much everyone here has helped me. HELP! Have a great day, all. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected during transmission. By reading the message and opening any attachments, the
Re: Heads up on nasty bug on NT
I know it sounds AOL-ish, but: Ditto! Cheers Nuno Souto [EMAIL PROTECTED] http://www.users.bigpond.net.au/the_Den - Original Message - Thanks Anita!! -- 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: stupid question about indexes and partitions
Joe : You probably know some of this already, but here is a summary of indexes on partitioned tables * Local indexes are just indexes that are equi-partitioned with the table * Local prefixed indexes have the partition columns as the leading column(s) in the index * Local non-prefixed indexes do not * Global indexes are indexes that are not equi-partitioned with the table * Global partitioned indexes are partitioned, but differently than the talbe * Global non-partitioned indexes are not partitioned. It looks like you have a global non-partitioned index there. Kevin -Original Message- Sent: Wednesday, June 06, 2001 10:32 AM To: Multiple recipients of list ORACLE-L Ok i have a table range partitioned on date. I have prefixed local indexes also. so far so good. I created an index, non partitioned, using simple create index index_name on table(field20); Is that now assumed to be a global index? I can't find any docs to say one way or the other. thanks, joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Toepke, Kevin M 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: Heads up on nasty bug on NT
Anita, Thank you so much for this info. Cheers! - Kirti -Original Message- From: A. Bardeen [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 6:56 AM To: Multiple recipients of list ORACLE-L Subject: Heads up on nasty bug on NT Hi all! Just a warning for those of you running Oracle on NT. There's an extremely nasty bug specific to 8.1.6/8.1.7 on NT/Win2K (not sure if it affects 8.1.5) where a datafile that is resize or autoextended exactly on a 4GB boundary cannot be resized. Bug 1668488. Options: 1. PITR prior to when the datafile extended 2. Force the db open (requires full db export and rebuild). 3. Clone a subset of the db containing the corrupted datafile(s), force it open, export affected tablespaces and import them into the original db. 4. Drop the corrupted datafiles to open the db and then drop the tablespace to which the datafiles belong. Options 2 3 can result in logical corruption as there's no way to rollback any uncommitted transactions that have already been forced to disk. Bug is not fixed in 8.1.6; it's scheduled for the 8.1.7.2 patchset. Those of you with autoextend on your datafiles should modify the maxsize to be less than 4GB or turn off autoextend. HTH, -- Anita __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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: Deshpande, Kirti 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).
Can the initABCD.ora file be changed during an RMAN migration
Is there any reason I should not modify the parameter file AFTER I copy it to the new host but BEFORE I restore the controlfile, datafiles, etc.? We are planning to move our database from one SPARC/Solaris box to another. Since the file system, operating system, and Oracle version (8.1.6) will be identical I figured that using Recovery Manager to do the migration would be best. The first step (after installing Oracle) is to copy the parameter file to the new host. There are a few changes I have been wanting to make to the parameter file but have not because it would require bouncing the database. I know I don't want to change db_block_size - but what else should I not change? Chris Rezek Oracle DBA DotClick Corporation http://www.dotclick.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Chris Rezek 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: Trouble.. Standby Database. Urgent!!
We use standby databases as well and our method is prety muc as yours is. So, my biggest question is . is that the correct directory for the Archive Files ??? and did you actually copy the files to that directory ?? "D:\ORACLE\ORA81\DATABASE\ARCHIVE" It seems a straight forward error it can't find the file ARC00505.001 in the above directory. It does not say the file is corrupt or mangled in any way . just that it can not find it. Definitely check the archive log destination parameter and make sure it is set to what you wanted. -Original Message-From: Saurabh Sharma [mailto:[EMAIL PROTECTED]]Sent: Wednesday, June 06, 2001 3:21 AMTo: Multiple recipients of list ORACLE-LSubject: Trouble.. Standby Database. Urgent!! hi all, I need ur help urgently. i've created a standby database with the below mentioned steps.. 1. copied consistent backup of datafiles folder to standby site. 2. created standby control file and sent to target location. 3. switch logfile current and copied to target. 4. copied init.ora and changed parameters for standby. at the standby site. 1. startup nomount ok 2. alter database mount standby database. ok 3. recover standby database ... this last recovery statement is giving lot of msgs like..log applied.. then same logfile not needed for this recovery. can not open file..etc. I'm copying the archived log from primary to standby standby_archive_dest location. here are the actual errors.. SVRMGR recover standby database;ORA-00279: change 708915 generated at 06/06/01 12:19:56 needed for thread 1ORA-00289: suggestion : D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-00280: change 708915 for thread 1 is in sequence #505Specify log: {RET=suggested | filename | AUTO | CANCEL}autoORA-00308: cannot open archived log 'D:\ORACLE\ORA81\DATABASE\ARCHIVE\ARC00505.001ORA-27041: unable to open fileOSD-04002: unable to open fileO/S-Error: (OS 2) The system cannot find the file specified. has anybody any idea of what's causing this problem. what i feel is there i may have wrongly configured the standby_archive_dest in init.ora at standby. any help is greatly appreciated. thanks. saurabh sharma
RE: SUMMARY: Thanks everyone - tru64
Well, that certainly matches my recent experience. I know of more than one very large customer having trouble with Sun and another large academic site who swapped 80-odd sun servers for AIX. Makes NT look more and more like the dot in dot com everyday. EG -Original Message- Sent: Wednesday, June 06, 2001 9:31 AM To: Multiple recipients of list ORACLE-L According to a technical representative at Oracle in Rochester, NY, Oracle no longer develops on Solaris. He stated that they have changed to HP-UX for development. He said the reason was instability with Solaris. Koivu, Lisa wrote: Kevin, sure I will. I just didn't want to muck up the list. Here's what I found. If anyone has any comments to add, please do. My question was about the utilities across different flavors of Unix and if they mean the same thing. vmstat, iostat are the same, however the switches may be a bit different. sar is system V only. truss you must purchase a license for. top is freeware. There is a utility called 'collect' that does something similar to top. The response regarding tru64 has been overwhelmingly positive. Some of the positive comments I received: 1. C compiler (Kernighan and Richie) is not ANSI compliant and may affect any 3rd party apps. 2. Compaq hardware used to be lagging in Oracle (Apps) patch releases. Not anymore. 3. The journaling filesystem makes mistakes like unplugging the wrong cord (oops!) a simple fix instead of hours of downtime. 4. Security - Since tru64 is not 'mainstream', e.g. marketed everywhere extremely popular, intimate knowledge for hacking the os is not widely known. So obscurity works in your favor. 5. Clustering technology is mature, solid and proven. 6. tru64 is indeed a first tier platform for Oracle. 7. Compaq's support is rated as 'very helpful'. 8. tru64 has the ability to quickly clone a filesystem. 9. OPS can reside on a filesystem on tru64. 10. Benchmarking Solaris E10K/64CPU against Compaq GS-160/16CPU favored the Compaq! WOW 11. For 9i, Oracle licensed also the TruCluster technology from Compaq. Oracle RAC (Real Application Cluster, new names for OPS) for 9i will only initially be available on tru64, truly first tier. Caveats/ Other comments: 1. Sun, relying on their own proprietary hardware, may be hurting themselves in the long run. 2. Sun is ex-pen-sive! Compaq wins in this comparison. 3. The future of Sun and Compaq seems a bit shaky right now, but they should pull through in the long run. 4. There's a bug in tru64 that doesn't allow one listener to service databases with different versions. Workaround is multiple listeners (no big deal) 5. Oracle does develop on Sun hardware. Calling OWWS for a Solaris system may net an answer quicker than running tru64. 6. Avoid the ultra sparc-2 chips from Sun. They have a problem with bad caches causing random reboots. I saw this at a previous employer. 7. If it's possible, consider IBM/AIX. IBM's sales force is highly trained in administration so you can talk real system architecture with them (not that I'm an admin or architect, I am neither). IBM's support is also top notch. Special thanks to the following people for their responses: Scott Shafer Ron Morton Lee Robertson Jerry Hess Michael Hand Murali Vallath Joe Hatchel Mike Kurt Ray Stell Darren Browett Stephen Andert Stefan Moeding And, the one and only clown Ross Mohan Like I said, I'm overwhelmed at how helpful everyone is. -Original Message- Sent: Tuesday, June 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Lisa: How about contributing a summary of the feedback? Kevin -Original Message- Sent: Tuesday, June 05, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I just wanted to say thank you to everyone who responded to me when I asked for info on tru64 Unix. I received much more info and feedback than I ever expected! This list is extremely helpful and I am very appreciative of how willing people are to answer questions. I just hope I contribute enough to make up for how much everyone here has helped me. HELP! Have a great day, all. Lisa Koivu Oracle Database Administrator 954-935-4117 The information in the electronic mail message is Cendant confidential and may be legally privileged, it is intended solely for the addressee(s) access to this internet electronic mail message by anyone else is unauthorized. If you are not the intended recipient, any disclosure, copying, distribution or any action taken or omitted to be taken in reliance on it is prohibited and may be unlawful. The sender believes that this E-mail and any attachments were free of any virus, worm, Trojan horse, and/or malicious code when sent. This message and its attachments could have been infected
Re: organizational culture / RE: TUSC and Kevin Loney
Well it is dependent on the type of game, I admit. Mladen is a (large) former Greco Roman wrestler, so if it's physical, he's got a good chance. Jared On Wednesday 06 June 2001 05:55, Thater, William wrote: On Tue, 5 Jun 2001,Jared Still scribbled on the wall in glitter crayon: -On Tuesday 05 June 2001 11:13, Post, Ethan wrote: - I say we all go to Steve's house and play a game of Survivor to see who - the most powerfull DBA in the world is. - ^^ - -Mladen would win. - -Jared - - that would depend on the game of survivor we played.;-) i do admit to having soem experience at it.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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).
PATROL Availability Suite for Oracle
Would appreciate feedback positive and/or negative from anyone who is using PATROL Availability Suite for Oracle. And if ye had a look but decided against it why?. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA Nobody loves me but my mother... and she could be jivin' too. - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Oracle price politics
They can cut 80% and it would still be expensive. But it is nice to see they are finally getting some brains. Yeah, I think Oracle should always be expensive, but ludicrus is just not acceptable, specially when they are KILLING their main partner (Sun). Sun is laying off the ENTIRE company but upper managment for 1 week, all travel expenses need to be pre-approved, and their standard hiring freeze. Yes, I think the market is hurting a little right now, but if you got a product (Sun and Oracle both do) it is your marketing and pricing that will make it much more difficult. It is like the old theory, I got 100 apples, I can sell them at $2 a piece and sell 20 of them. Or I can sell them for $1 and sell all of them. When you get apples for $.50 both are profitable, just one is better. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, June 06, 2001 10:32 AM To: Multiple recipients of list ORACLE-L --- Forwarded Message Follows --- ERPcentral - http://www.erpcentral.com Oracle slashes prices in Japan. Global cuts next? http://www.erpcentral.com cw360.com June 4, 2001 Oracle could be on the verge of announcing significant price cuts around the world after its Japanese operation slashed database prices this week. The company is refusing to comment on speculation, saying chief executive officer Larry Ellison will be making a major pricing announcement to coincide with the launch of the 9i database at Oracle OpenWorld later this month. Oracle confronts pricing, user issues http://www.erpcentral.com Computerworld June 4, 2001 Cuts pricing in Japan Dan Verton, Computerworld Oracle Corp.'s Japanese unit last week slashed prices for the company's database software by 25 percent and increased volume discounts to 35 percent, raising hopes among U.S. users that the cuts herald lower prices here. Street Fight: Oracle http://www.erpcentral.com Forbes.com, June 4, 2001 With sagging earnings and lack of guidance for its soon-to-be-announced fourth quarter, Oracle has been slapped with no less than nine analyst downgrades since early March. Shares of the database software provider have dropped 67% from their 52-week high, giving the stock a latest 12-month price-to-earnings ratio of just 14. Is it time to buy America's second-largest independent software concern? --- If you enjoy reading ERPCentral's Newsletter, please tell a friend or colleague about it. Anyone can sign up for a free subscription on our Web site at http://www.erpcentral.com (c) Copyright 2000 Idem Est Technologies Ltd. All rights reserved. All product names contained herein are the trademarks of their respective holders. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 02:46 To: Multiple recipients of list ORACLE-L Hi, Few days ago someone posted a link to a newsletter about the slashing of the prices of Oracle products in Japan and that Larry Ellison would announce price reductions that will apply worldwide. Someone can send me the link ?? TIA, Antonio Belloni -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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: Mark Leith 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: Christopher Spence 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
RE: OT RE: SUMMARY: Thanks everyone - tru64
I think that Ross should be the lion! hhehehhehehe whoo hoo -Original Message- Sent: Wednesday, June 06, 2001 10:49 AM To: Multiple recipients of list ORACLE-L Well, I'm one of the Munchkins. Terry Mohan, Ross wrote: I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Terry Ball 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: Kevin Kostyszyn 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: problems when running dbstart
Off the top of my head I would say that you have a parameter called open_link in your init which is not valid. -Original Message- Sent: Wednesday, June 06, 2001 5:21 AM To: Multiple recipients of list ORACLE-L Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed 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: Kimberly Smith 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: OT RE: SUMMARY: Thanks everyone - tru64
I'll be riding in yer basket, Mark. EG Arf, Arf. || -Original Message- || From: Mark Leith [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, June 06, 2001 10:32 AM || To: Multiple recipients of list ORACLE-L || Subject: RE: OT RE: SUMMARY: Thanks everyone - tru64 || || || Can I be Dorothy? :- || || -Original Message- || Sent: Wednesday, June 06, 2001 02:51 || To: Multiple recipients of list ORACLE-L || || || PLEASE I want to be the wicked witch!!! || || || 8] || || || April Wells || Corporate Systems || Amarillo Texas || || -Original Message- || Sent: Wednesday, June 06, 2001 8:41 AM || To: Multiple recipients of list ORACLE-L || || || Can I try out for a flying monkey role! :o) || || -Original Message- || Sent: Wednesday, June 06, 2001 8:11 AM || To: Multiple recipients of list ORACLE-L || || || || I wonder if we on the list made our own show of Wizard of OZ || who would be the StrawMan, TinMan, Lion, and, well...Dorothy. || || Applications are being accepted for good witch, bad witch, and || the wizard, of course. || || I've got dibs on ToTo || || || || -Original Message- || To: Mohan, Ross || Cc: Multiple recipients of list ORACLE-L || Sent: 6/6/2001 8:03 AM || || On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in || glitter crayon: || || -I AM AN IDIOT || || HOLD IT! that's *my* job on this list, thank you. i've || worked long and || hard to be the best idiot is can so i *deserve* the job.;-) || || -- || Bill Shrek Thater Certifiable ORACLE DBA || Telergy, Inc.[EMAIL PROTECTED] || ~~ || You gotta program like you don't need the money, || You gotta compile like you'll never get hurt, || You gotta run like there's nobody watching, || It's gotta come from the heart if you want it to work. || ~~ || You have junk mail. || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: Mohan, Ross || 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: Farnsworth, Dave || 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). || || || || The information contained in this e-mail is strictly || confidential and for || the intended use of the addressee only; it may also be || legally privileged || and/or price sensitive. Notice is hereby given that any || disclosure, use or || copying of the information by anyone other than the intended || recipient is || prohibited and may be illegal. If you have received this || message in error, || please notify the sender immediately by return e-mail. || || Corporate Systems, Inc. has taken every reasonable || precaution to ensure that || any attachment to this e-mail has been swept for viruses. || We accept no || liability for any damage sustained as a result of software || viruses and || advise you carry out your own virus checks before opening || any attachment. || || -- || Please see the official ORACLE-L FAQ: http://www.orafaq.com || -- || Author: April Wells || 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: Mark Leith || INET: [EMAIL PROTECTED] || || Fat City Network Services--
RE: dbms_utility.analyze_schema OR dbms_stats ?
All: From reading the release notes for 9i it appears that ANALYZE table and DBMS_UTILITY.ANALYZE_SCHEMA are desupported in 9i. The only supported way to generate stats in 9i is DBMS_STATS. In addition, DBMS_STATS can generate stats for tables in parallel and make use of the new MONITORING feature to only generate stats on tables with stale statistics. In addition, do not mix calls. Use one or the other. According to the Docs, ANALYZE can not delete and does not overwrite some stats generated by DBMS_STATS and vise versa. I have run into the situation where calls where mixed and got really strange results until stats were deleted using both methods and regenerated. Kevin -Original Message- Sent: Wednesday, June 06, 2001 10:56 AM To: Multiple recipients of list ORACLE-L Oracle 8.1.7 AIX 4.3.3 I looked at the docs and it appears Oracle wants you to use dbms_stats to generate statistics for cbo. I am currently using dbms_utility.analyze_schema. Should I change to dbms_stats (i know it doesnt give you chained rows, avg free space, # of unused blocks)? Are there any advantages over dbms_utility.analyze_schema? What does everyone here use to generate their stats? Thanks. Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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: Toepke, Kevin M 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: OT RE: Database writer
You need to apply for the UKOUG, and get your Co. to do it on expenses :) Birmingham is the second capital of England - and the ICC is not a bad venue - especially when you are in the Hilton that is joined next door by a bridge over Broad Street (a great place for pubs). I remember one year practically crawling over that bridge after the mid week bash! Oh what fun.. I'm more of a lager drinker oO(or is that iza laaager drinku) though, so you can buy me a Stella :) -Original Message- Sent: Wednesday, June 06, 2001 03:22 To: [EMAIL PROTECTED]; Lyris sigh :) Mark, I'll be as happy as you if I can get my stars and stripes ass over to GB and buy us *both* a Smithwick's. || -Original Message- || From: Mark Leith [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, June 06, 2001 9:26 AM || To: Lyris; Mohan, Ross || Subject: RE: OT RE: Database writer || || || Does that mean I can get a beer? || || -Original Message- || From: Mohan, Ross [mailto:[EMAIL PROTECTED]] || Sent: Wednesday, June 06, 2001 01:08 || To: 'Mark Leith '; 'Multiple recipients of list ORACLE-L ' || Subject: RE: OT RE: Database writer || || || Paul Cantor (sp?) and Grace Slick were || the driving force..i'm impressed. || || -Original Message- || From: Mark Leith || To: Multiple recipients of list ORACLE-L || Sent: 6/6/2001 5:41 AM || Subject: RE: OT RE: Database writer || || Thought it was Paul Katner.. || || Oh well.. || || Mark || || -Original Message- || Sent: Tuesday, June 05, 2001 05:07 || To: Multiple recipients of list ORACLE-L || || || No winner! I drink the freaking beer all by myself. || || I think I'll pour myself a Smithwick's...somewhere in || Dublin...aaa! || || || (Jefferson Starship) || || || -Original Message- || || From: Jerry C [mailto:[EMAIL PROTECTED]] || || Sent: Tuesday, June 05, 2001 11:32 AM || || To: Multiple recipients of list ORACLE-L || || Subject: Re: OT RE: Database writer || || || || || || So... no winner Ross? || || || || Do we get the answer?? || || || || || || - Original Message - || || To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] || || Sent: Monday, June 04, 2001 4:25 PM || || || || || || Yea, NT blows. Blows like a fresh wind against the empire. || || || || || || (1st one to name that song lyric reference and i buy || you a beer. || || NT bigots and their families summarily excused from || this offer.:) || || || || || -Original Message- || || || From: Christopher Spence [mailto:[EMAIL PROTECTED]] || || || Sent: Monday, June 04, 2001 2:16 PM || || || To: Multiple recipients of list ORACLE-L || || || Subject: RE: Database writer || || || || || || || || || Doubt, didnt' see NT, boy NT blows. || || || || || || I hate how it doesn't list out the processes. || || || || || || Walking on water and developing software from a || || || specification are easy if || || || both are frozen. || || || || || || Christopher R. Spence || || || Oracle DBA || || || Fuelspot || || || || || || || || || || || || -Original Message- || || || Sent: Monday, June 04, 2001 1:18 PM || || || To: [EMAIL PROTECTED]; Christopher Spence || || || || || || || || || On Monday 04 June 2001 10:16, Christopher Spence wrote: || || || Look under ps. || || || || || || Really? On NT? || || || || || || Jared || || || || || || || || || Walking on water and developing software from a || || || specification are easy if || || || both are frozen. || || || || || || Christopher R. Spence || || || Oracle DBA || || || Fuelspot || || || || || || || || || || || || -Original Message- || || || Sent: Monday, June 04, 2001 11:56 AM || || || To: Multiple recipients of list ORACLE-L || || || || || || || || || Hi all, || || || I added db writer processes last week to try and || || || improve performance || || || of one || || || of my 8.1.7 db's on NT. Does anyone know if there is a || || || way to see if || || || Oracle actually started the additional db writer || || || processes? I added || || || db_writer_processes to the init file, the instance || || started so I am || || || assuming || || || that the db writer processes are working. But we all know || || || what happens || || || when we assume something. Any ideas would be appreciated. || || || || || || Sincerely, || || || Kevin Kostyszyn || || || DBA || || || Dulcian, Inc || || || www.dulcian.com || || || [EMAIL PROTECTED] || || || -- || || || Please see the official ORACLE-L FAQ: http://www.orafaq.com || || || -- || || || Author: Christopher Spence || || || 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
RE: Spotlite question
I have it monitoring a NT database but can't get OS stats from it. Of course they could just put it sucks on the page and that would be enough for me. -Original Message- [mailto:[EMAIL PROTECTED]] Sent: Tuesday, June 05, 2001 5:50 PM To: Multiple recipients of list ORACLE-L Ron, I wasn't confusing the server and client information - it was just that there web page is out of date regarding supported servers. Kevin pointed me in the correct direction - Oracle running on an NT server is supported. This is indicated in the readme file you get when you download the trial. Regards, Bruce -Original Message- Sent: Tuesday, 5 June 2001 11:43 To: Multiple recipients of list ORACLE-L I think you are confusing the Server and the Client information. The client that runs the Spotlite has to be Windows 95/98/2000/NT. I have Spotlite monitoring a Novell server. I worked with the spotlite development team for release 2.c that limited the trace file naming convention to 8 char. It works great. From my pc Win 98 I can monitor the production database and development database (Novell) and a test server (Linux) ROR mª¿ªm [EMAIL PROTECTED] 06/04/01 10:15PM Nick, Does spotlight support an Oracle server running on NT? The requirements page says: Server Oracle versions from 7.3.3 and above Solaris (2.5, 2.6, 2.7) HP-UX (10.20, 11.00/32 bit, 11.00/64 bit) AIX (4.2, 4.3) Digital (v4.0d, v4.0f) which seems to me to say the Oracle server must be running on Unix and not NT. but then the PDF data sheet says Spotlight requires Windows 95/98/2000/NT and a SQL*Net connection to any Oracle server (7.3.3 or greater) Which is correct? Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -Original Message- Sent: Tuesday, 5 June 2001 11:20 you can download a free fully functional trial version of Spotlight on Oracle from the Quest Website at http://www.quest.com/spotlight_oracle/ there is a link to 'download trial' on the left hand side. You can click on the screenshot to get a full size image... but it will tell you everything you need to know about your instance... and what init.ora parameters you can change to improve it. Nick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) 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: Kimberly Smith 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: stupid question about indexes and partitions
Hi Joe, Here is a blurb from the 8.1.6 Concepts Guide (Chapter 11, under 'Prefixed and Nonprefixed Global Partitioned Indexes'): 'Nonpartitioned indexes are treated as global prefixed nonpartitioned indexes' I ran into the same stupid question not too long ago. HTH, Regards - Kirti -Original Message- From: Joseph Testa [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 9:32 AM To: Multiple recipients of list ORACLE-L Subject: stupid question about indexes and partitions Ok i have a table range partitioned on date. I have prefixed local indexes also. so far so good. I created an index, non partitioned, using simple create index index_name on table(field20); Is that now assumed to be a global index? I can't find any docs to say one way or the other. thanks, joe _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joseph Testa 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: Deshpande, Kirti 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: Shared Pool info - V$sqlarea.
He also gave the presentation at the IOUG-A in Orlando recently, so it should be available from their CD's/archives or whatever. It's a neat presentation. Way too many people and monitoring products want you do keep increasing db_block_buffers until your BCHR is about 99.9% or so. It's pure nonsense, of course. Once I worked on a large SAP site, where the SAP Early Watch kept saying the problems in the system were due to the BCHR being too low. That went on for a few months while performance became progressivly worse. When the customer passed the 1G mark (for the buffer cache alone) they called me/Premium Services and the wait interface showed all the wait time to be with the free buffer waits event, meaning the DBWR couldn't keep up (no async IO, therefor making the buffer cache bigger made the problem bigger, etc.). We set up multiple database writers to simulate async IO (long story) and it all worked nicely... This is not to say anything bad about Early Watch, but to say something bad about the ratio-based/checklist tuning method :-))). A. Bardeen wrote: Raj, One statement caught my eye: The buffer cache hit ratio is 99% My bet is you've got some very inefficent SQL. As is typically the case, application tuning has the biggest effect on performance. I'd suggest checking out Cary Millsap's excellent paper Why 99% Database Buffer Cache Hit Ratio is NOT Ok (available with free registration): http://www.hotsos.com/catalog/mtime.html HTH, -- Anita --- Raj Gopalan [EMAIL PROTECTED] wrote: Thanks Chris. The problem I am facing is 100% CPU usage and memory paging out at times. I tought the starting point is v$sqlarea. Purchasing of Precise SQL or SQL Vision can not happen here immediately. The RAM size is 512MB and SGA is 210MB. The buffer cache hit ratio is 99%. I was just wondering is there any way to find out the cause of this problem? TIA Cheers Raj -Original Message- Sent: 01 June 2001 19:51 To: Multiple recipients of list ORACLE-L Oracle has no guarentee how long statistics and plans will be available for statements, depending on the activity of the database they may be there for 2 seconds they may be there for 2 weeks. Products like Precise SQL and SQL Vision Lab help in that manor where they capture transactions and activity continuously in a non-intrusive manor. This is the only guarenteed way to get 99.999% of the transactions. Walking on water and developing software from a specification are easy if both are frozen. Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Friday, June 01, 2001 12:16 PM To: Multiple recipients of list ORACLE-L DBAs The statistics in v$sqlarea is getting flushed very often. In the morning I found the a query which has more than 10,000 disk reads as the top one. But now the top most query with disk reads has not more than 100 disk reads. I have not bouncd the DB or flushed the shared pool. The overall library cache hit ratio is 97%.where us SQLAREA hit ratio is 60%. Any Idea what could be reason? TIA, Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan 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: Christopher Spence 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: Raj Gopalan 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
RE: SUMMARY: Thanks everyone - tru64
My question is, if they are developing on HP-UX, why was 9i for SPARC released first? 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] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, June 06, 2001 9:31 AM To: Multiple recipients of list ORACLE-L According to a technical representative at Oracle in Rochester, NY, Oracle no longer develops on Solaris. He stated that they have changed to HP-UX for development. He said the reason was instability with Solaris. Koivu, Lisa wrote: Kevin, sure I will. I just didn't want to muck up the list. Here's what I found. If anyone has any comments to add, please do. My question was about the utilities across different flavors of Unix and if they mean the same thing. vmstat, iostat are the same, however the switches may be a bit different. sar is system V only. truss you must purchase a license for. top is freeware. There is a utility called 'collect' that does something similar to top. The response regarding tru64 has been overwhelmingly positive. Some of the positive comments I received: 1. C compiler (Kernighan and Richie) is not ANSI compliant and may affect any 3rd party apps. 2. Compaq hardware used to be lagging in Oracle (Apps) patch releases. Not anymore. 3. The journaling filesystem makes mistakes like unplugging the wrong cord (oops!) a simple fix instead of hours of downtime. 4. Security - Since tru64 is not 'mainstream', e.g. marketed everywhere extremely popular, intimate knowledge for hacking the os is not widely known. So obscurity works in your favor. 5. Clustering technology is mature, solid and proven. 6. tru64 is indeed a first tier platform for Oracle. 7. Compaq's support is rated as 'very helpful'. 8. tru64 has the ability to quickly clone a filesystem. 9. OPS can reside on a filesystem on tru64. 10. Benchmarking Solaris E10K/64CPU against Compaq GS-160/16CPU favored the Compaq! WOW 11. For 9i, Oracle licensed also the TruCluster technology from Compaq. Oracle RAC (Real Application Cluster, new names for OPS) for 9i will only initially be available on tru64, truly first tier. Caveats/ Other comments: 1. Sun, relying on their own proprietary hardware, may be hurting themselves in the long run. 2. Sun is ex-pen-sive! Compaq wins in this comparison. 3. The future of Sun and Compaq seems a bit shaky right now, but they should pull through in the long run. 4. There's a bug in tru64 that doesn't allow one listener to service databases with different versions. Workaround is multiple listeners (no big deal) 5. Oracle does develop on Sun hardware. Calling OWWS for a Solaris system may net an answer quicker than running tru64. 6. Avoid the ultra sparc-2 chips from Sun. They have a problem with bad caches causing random reboots. I saw this at a previous employer. 7. If it's possible, consider IBM/AIX. IBM's sales force is highly trained in administration so you can talk real system architecture with them (not that I'm an admin or architect, I am neither). IBM's support is also top notch. Special thanks to the following people for their responses: Scott Shafer Ron Morton Lee Robertson Jerry Hess Michael Hand Murali Vallath Joe Hatchel Mike Kurt Ray Stell Darren Browett Stephen Andert Stefan Moeding And, the one and only clown Ross Mohan Like I said, I'm overwhelmed at how helpful everyone is. -Original Message- Sent: Tuesday, June 05, 2001 12:02 PM To: Multiple recipients of list ORACLE-L Lisa: How about contributing a summary of the feedback? Kevin -Original Message- Sent: Tuesday, June 05, 2001 11:37 AM To: Multiple recipients of list ORACLE-L I just wanted to say thank you to everyone who responded to me when I asked for info on tru64 Unix. I received much more info and feedback than I ever expected! This list is extremely helpful and I am very appreciative of how willing people are to answer questions. I just hope I contribute enough to make up for how much
RE: OT RE: SUMMARY: Thanks everyone - tru64
Damn! You beat me to it! -- Anita --- April Wells [EMAIL PROTECTED] wrote: PLEASE I want to be the wicked witch!!! 8] April Wells Corporate Systems Amarillo Texas -Original Message- Sent: Wednesday, June 06, 2001 8:41 AM To: Multiple recipients of list ORACLE-L Can I try out for a flying monkey role! :o) -Original Message- Sent: Wednesday, June 06, 2001 8:11 AM To: Multiple recipients of list ORACLE-L I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Farnsworth, Dave 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). The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen 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
OT WAS: SUMMARY: Thanks everyone - tru64
Only if the story line matches up to Pink Floyd's Dark Side of the Moon as well as the original WoZ... Careful taking the bad witch part - monkeys may have to fly out of your butt! Scott Shafer San Antonio, TX 210-581-6217 And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grâce via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue. --Jay Trigg -Original Message- From: Mohan, Ross [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 06, 2001 8:11 AM To: Multiple recipients of list ORACLE-L Subject: RE: OT RE: SUMMARY: Thanks everyone - tru64 I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: 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: How to identify sql texts which are having open cursor?
How about sys.V_$OPEN_CURSOR to get the SIDs, and then try to get the query they are executing ? HTH, Remco -Oorspronkelijk bericht- Van: Shantanu Talukder [mailto:[EMAIL PROTECTED]] Verzonden: woensdag 6 juni 2001 0:14 Aan: Multiple recipients of list ORACLE-L Onderwerp: How to identify sql texts which are having open cursor? Our application is using up open_cursor limits of 500. We are suspecting that application code written in Java are not closing cursors explicitly. Is there a way to idntify those sql code which are not closing cursor? We just don't want to increase open_cursor parameter in init.ora and bounce the db without identifying sql. HTH, Shantanu --- Kirsh, Gary [EMAIL PROTECTED] wrote: Jared, I think that the default java_pool_size is 20M, not 30M. Gary -Original Message- Sent: Tuesday, June 05, 2001 4:01 PM To: Multiple recipients of list ORACLE-L Take a look at the SGA with: select * from v$sgastat order by 1,2; You will likely see 30M dedicated to the java pool, as that is the default. This can be cut back substantially if you are not making use of java. Jared On Tuesday 05 June 2001 05:01, C.S.Venkata Subramanian wrote: One of my co-worker came with this ques. In the init.ora file he had set the shared_pool_size to 10M and db_block_buffers=1024 and redolog buffer to 32768. but when he did sho sga in the sql*plus prompt he got the following output Total System Global Area 41297948 bytes Fixed Size75804 bytes Variable Size 32755712 bytes Database Buffers8388608 bytes Redo Buffers 77824 bytes Doing a select on V$SGA also gave the same result. My shared pool size is only 10M, why it is showing nearly 40M. From where did oracle derive the extra MB's? I ran throu the oracle manual and got only answer for database buffers. Can any one tell from where these extra MB's come to Oracle from the OS. TIA Venkat Get 250 color business cards for FREE! http://businesscards.lycos.com/vp/fastpath/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Kirsh, Gary 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). __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shantanu Talukder 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: Daemen, Remco 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: dbms_utility.analyze_schema OR dbms_stats ?
As far as I can work out, DBMS_STATS is purely for optimizer decisions (presumably thats why they didn't call it DBMS_ANALYZE). (If you believe the doco) you can get faster and better stats with DBMS_STATS (particularly in terms of partition-wise stats). I'm using both at the moment, in my case, a weekly dbms_stats to help the optimiser, and a monthly analyze to help me (chain rows etc etc). hth connor --- Gene Sais [EMAIL PROTECTED] wrote: Oracle 8.1.7 AIX 4.3.3 I looked at the docs and it appears Oracle wants you to use dbms_stats to generate statistics for cbo. I am currently using dbms_utility.analyze_schema. Should I change to dbms_stats (i know it doesnt give you chained rows, avg free space, # of unused blocks)? Are there any advantages over dbms_utility.analyze_schema? What does everyone here use to generate their stats? Thanks. Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais 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). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue Do You Yahoo!? Get your free @yahoo.co.uk address at http://mail.yahoo.co.uk or your free @yahoo.ie address at http://mail.yahoo.ie -- 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 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).
What stands for i in Oracle 8i
Hi, I am just curious about to know for what that i stands for in Oracle 8i. Can any one shed some light? Thanks, Muths Do not go where the path may lead, go instead where there is no path and leave a trail.
RE: OT RE: SUMMARY: Thanks everyone - tru64
I don't really care who's what, as long as I can still play Pink Floyd's Dark Side of the Moon to it. But since we're lobbying for parts, I guess I'll audition for the Tin Man due to his lack of heart ;) Jim -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) PLEASE I want to be the wicked witch!!! 8] April Wells Corporate Systems Amarillo Texas -Original Message- Sent: Wednesday, June 06, 2001 8:41 AM To: Multiple recipients of list ORACLE-L Can I try out for a flying monkey role! :o) -Original Message- Sent: Wednesday, June 06, 2001 8:11 AM To: Multiple recipients of list ORACLE-L I wonder if we on the list made our own show of Wizard of OZ who would be the StrawMan, TinMan, Lion, and, well...Dorothy. Applications are being accepted for good witch, bad witch, and the wizard, of course. I've got dibs on ToTo -Original Message- To: Mohan, Ross Cc: Multiple recipients of list ORACLE-L Sent: 6/6/2001 8:03 AM On Tue, 5 Jun 2001,Mohan, Ross scribbled on the wall in glitter crayon: -I AM AN IDIOT HOLD IT! that's *my* job on this list, thank you. i've worked long and hard to be the best idiot is can so i *deserve* the job.;-) -- Bill Shrek Thater Certifiable ORACLE DBA Telergy, Inc.[EMAIL PROTECTED] ~~ You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. ~~ You have junk mail. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross 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: Farnsworth, Dave 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). The information contained in this e-mail is strictly confidential and for the intended use of the addressee only; it may also be legally privileged and/or price sensitive. Notice is hereby given that any disclosure, use or copying of the information by anyone other than the intended recipient is prohibited and may be illegal. If you have received this message in error, please notify the sender immediately by return e-mail. Corporate Systems, Inc. has taken every reasonable precaution to ensure that any attachment to this e-mail has been swept for viruses. We accept no liability for any damage sustained as a result of software viruses and advise you carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: April Wells 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). -- Jim Hawkins Lead SAPR/3 Oracle Database Administrator MEMC Electronic Materials, Inc. 600 Pearl Drive St. Louis, MO 633376 9636) 474-7832 [EMAIL PROTECTED] (work) [EMAIL PROTECTED] (home) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jim Hawkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists