RE: Apps Login Error
SET ORACLE-L DIGEST -Original Message- Sent: Tuesday, August 07, 2001 1:46 AM To: Multiple recipients of list ORACLE-L Hi List - After installing Apps 11.5.2 I am attempting to login for the first time. I can login as sysadmin through 'personal homepage' without a problem. But when I try to access individual modules by clicking on the links under 'application', I get the following: APP-FND-01508: Failed to connect I click OK and it takes me to the next error: There are no valid navigations for this responsibility Anybody knows what the problem could be? TIA Dennis Meng Database Administrator Focal Communications 847-954-8328 -- 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: Raymond Lee Meng Hong 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 needed
Title: Help needed HI DBA Guru's It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this.. The pc name who was connected. The time when he/she executed the process What was the command given to execute the same.. Pls... Guruji's help me... with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf Deewaker G.V..vcf
Re: Max two dates
THANK YOU SO MUCH . BUNYAMIN - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 7:21 PM Is this what you are looking for: select activity_date from (select activity_date from sbc order by activity_date desc) where rownum 3 -Original Message- Sent: Monday, August 06, 2001 11:52 AM To: Multiple recipients of list ORACLE-L I have a date field and I want to select rows with max 2 date values. How can I do that? Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash 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: Bunyamin K. Karadeniz 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: computer history stories - Now: Age discrimination?
Spot on, Rachel! I misguidedly joined Mensa several years ago, and let my membership lapse after a year or two, when it became clear the level of debate was as you describe. The overbearing aura of smugness in most of the magazine articles, and most members' inability to LISTEN at meetings just became too irritating. Mensa's really the Society for people who both have high IQs AND want everyone to know it! Paul Vincent Database Administrator, University of Central England -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: 06 August 2001 20:24 To: Multiple recipients of list ORACLE-L Subject: RE: computer history stories - Now: Age discrimination? oh I don't know... I can't tell you how many Mensa members I've met whose level of verbal sparring is did not did too did not your mama wears army boots -- 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: dynamic sql problem
Hi there, It could just be that you are missing your semicolons ';' off the end of your statements. Cheers, Kev. __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 06 August 2001 21:57 To: Multiple recipients of list ORACLE-L HI, I am running a stored procdures which contains following dynamic sql ..i am getting error: ORA-00936 missing expression. for the bold statement while rest of statements r properly executing.. what might be the reason.. and temp_ are variables declared.. and name1,name2,name3 are dynamically generated table names.. str := 'alter table'||' '||name2||' '||'disable constraint'||' '||temp1_cons; execute immediate str; str := 'alter table'||' '||name3||' '||'disable constraint'||' '||temp_cons; execute immediate str; str :='update '||' '||name2||' '||' set id_sess=id_sess + '||' '||temp_id_sess_2; execute immediate str; str :='update '||' '||name3||' '||' set id_sess = id_sess +'||' '||temp_id_sess_3; execute immediate str; str :='create table'||' '||enum||' '||'as select * from'||' '||name1||' '||'union select * from'||' '||name2||' '||'union select * from'||' '||name3; execute immediate str; Thanks Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Harvinder Singh 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: Thomas, Kevin 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: computer history stories - Now: Age discrimination?
yep, I learned that lesson years ago when I joined. I expected interesting, stimulating conversation. I got kids quarrelling. I've always figured if you have brains and/or talent, you usually don't need to brag about it. If you have to brag, you have a self-esteem problem. From: Paul Vincent [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: computer history stories - Now: Age discrimination? Date: Tue, 07 Aug 2001 00:10:42 -0800 Spot on, Rachel! I misguidedly joined Mensa several years ago, and let my membership lapse after a year or two, when it became clear the level of debate was as you describe. The overbearing aura of smugness in most of the magazine articles, and most members' inability to LISTEN at meetings just became too irritating. Mensa's really the Society for people who both have high IQs AND want everyone to know it! Paul Vincent Database Administrator, University of Central England -Original Message- From: Rachel Carmichael [mailto:[EMAIL PROTECTED]] Sent: 06 August 2001 20:24 To: Multiple recipients of list ORACLE-L Subject: RE: computer history stories - Now: Age discrimination? oh I don't know... I can't tell you how many Mensa members I've met whose level of verbal sparring is did not did too did not your mama wears army boots -- 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). _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- 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).
Unknown RBS
Hi all, I have question below here .. (Solaris 7 Oracle 8.1.6) I startup my database with this parameter db_name = MyDB instance_name = MyDB service_names = MyDB control_files = (/export/home/basic/MyDB/ctl/control01.ctl, /export/home/basic/MyDB/ctl/control02.ctl, /export/home/basic/MyDB/ctl/control03.ctl) open_cursors = 100 max_enabled_roles = 30 db_block_buffers = 9280 shared_pool_size = 12670976 large_pool_size = 614400 java_pool_size = 0 log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 processes = 50 log_buffer = 163840 background_dump_dest = /export/home/basic/MyDB/dump/bdump core_dump_dest = /export/home/basic/MyDB/dump/cdump user_dump_dest = /export/home/basic/MyDB/dump/udump db_block_size = 4096 remote_login_passwordfile = none os_authent_prefix = compatible = 8.1.0 sort_area_size = 65536 sort_area_retained_size = 65536 SQL select name from v$rollname; NAME --- SYSTEM RBS0 RBS1 RBS2 Where are these RBS* rollback segments come from ? Because I am not include the ROLLBACK_SEGMENTS = ( RBS0, RBS1, RBS2 ) parameters Thank you, Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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).
how to stop a killed session bothering me ?
Dear gurus ! I have killed a session while it was populating a big table. Now the session is marked KILLED in v$session. It's serial# is keeping being incremented , so i assume that a rollback (of rows inserted into that big table by that session) is going on there in the background. This rollback runs for several hours already preventing me from DMLing that big table. Is there a way to stop that rollback / drop / truncate that table ? Thanks a lot in advance . Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
how to stop a killed session bothering me ?
Dear all ! I have killed a session while it was populating a big table. Now the session is marked KILLED in v$session. It's serial# is keeping being incremented , so i assume that a rollback (of rows inserted into that big table by that session) is going on there in the background. This rollback runs for several hours already preventing me from DMLing that big table. Is there a way to stop that rollback / drop / truncate that table ? Thanks a lot in advance . Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
Precise
Is no-one on this list using Precise SQL or Precise Pulse?. Has anyone heard of them or evaluated them?. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [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: computer history stories - Now: Age discrimination?
Well, thanks for the vote of confidence there Christopher! :) I will start off by saying - I am *not* a DBA, though I am fully aware of all that the job entails what with selling performance, tuning and management tools to you guys on a daily basis. I am *trained* to do the job - and have done a hell of a lot of reading and testing and playing.. The one thing I will say is that you guys - the DBAs - are for the most part not very impressed by our type of company when the sales critter that calls you (me) does not know what they are talking to you about. With this in mind I have made it my job to learn as much as I can - both in and out of work hours - to be just as much up to speed on the databases we deal with as you - the DBAs. I could competently look after an Oracle or SQLServer database if thrown in the deep end (though I may not be a performance expert like Kirti or Gaja) or have written a book on any subject that I have chosen to learn - or in fact published my IQ to people around the world :) The same goes with HTML JAVA programming - I'm no expert but can certainly hold my own! By the way I finally published our new site over the weekend www.cool-tools.co.uk, and included your very own site in our links section, the site was FULLY done by myself. I don't claim to be an expert - and I don't think that I did in my original posting - but then I don't usually run to an expert for him to fix a problem that I'm having (though I have on the odd occasion turned to the list for advice:) ) I usually just sink my teeth in to a manual or online, test, play and learn on my own two feet. Being 22 I think I have pretty a good head start - and hey If you didn't know what I did @ 22, and your only 26 I should be a GURU by the time I reach your age? Jealous? :) Cheers Mark -Original Message- Spence Sent: Monday, August 06, 2001 05:57 To: Multiple recipients of list ORACLE-L I would be curious of HOW WELL he knows those things. Anyone can learn most of everything out there, but to be able to do it and do it well is another thing. Also when you go so many directions like that, you never work on the same thing for long, which means you need to be able to jump back into something else VERY quickly or there is no sense learning it in the first place. There is one thing as being good at many things, but when the sh%t really hits the fan, you call someone that knows what their doing, not the jack of all trades. I being 26, I found myself becoming a jack of all trades, and I think I still am. I did not like that, so I picked up Oracle about 3.5 years ago and decided I am going to take one thing, and be damn good at it. I was a good system admin and adapted very well. But I did not get the luxery of REALLY knowing everything about what I was using. Although I generally can figure things out extremely quick where it appears I know it. I! was not comfortable with my accomplishments, I wanted to know more and more. I could not do that doing what I was doing, broad generalization was not how I wanted to be. With an iq of 147, I think I can be considered a very quick learner. I know for a fact that 4 years ago when I was 22, I could not do all of what was claimed in previous email by Mark (Oracle DBA, Sybase Admin, SQL Server DBA, JAVA, HTML) and consider myself great at it. Although you can be very comfortable with them, comfort can be obtained in very short time frames. True talent to play as an allstar takes years, no matter how smart you are and what ya doing. I once met a street sweeper who was going on to 50 years old, I asked him why did he not try to find a better job. His answer was Because I am the best street sweeper there ever was. After saying that, I had a new found respect for him and was detirmined to seek the same motivation in my life. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Friday, August 03, 2001 11:17 AM To: Multiple recipients of list ORACLE-L But Kevin, having all under his belt doesn't mean he's ever used it. Maybe we're not slackers afterall. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 10:15 AM WOW, now I feel like slacker:) KK - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 7:51 AM Cheers Lee! Out of curiosity how old did you think I was? I was actually turned down for cigarettes a few months back!! I couldn't believe it!! I'm 22 BTW (only 6 years above the legal limit!). Already got Oracle Admin, SQLServer admin, HTML JAVA programming under my belt - with a little Sybase ASE around the
RE: Help needed
RTFM on auditing - this should provide all that you need. A good start would be to read: Oracle Concepts Guide - Chapter 28 - Auditing. HTH Mark -Original Message- Sent: Tuesday, August 07, 2001 09:00 To: Multiple recipients of list ORACLE-L HI DBA Guru's It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this.. The pc name who was connected. The time when he/she executed the process What was the command given to execute the same.. Pls... Guruji's help me... with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- 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: Help needed
Title: RE: Help needed If on oracle 8i, you may also consider database triggers to prevent ddl stmts, userwise. rgds amar -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: Help needed RTFM on auditing - this should provide all that you need. A good start would be to read: Oracle Concepts Guide - Chapter 28 - Auditing. HTH Mark -Original Message- Sent: Tuesday, August 07, 2001 09:00 To: Multiple recipients of list ORACLE-L HI DBA Guru's It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this.. The pc name who was connected. The time when he/she executed the process What was the command given to execute the same.. Pls... Guruji's help me... with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- 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: Which, View, to, check, storage, parameter, change, status, since, date?
Seema, I don't think you can actually tell what storage parameters have actually been changed from any of the DBA tables, I think this is a case for auditing on an ALTER statement for the tables you are interested in. You can however tell when the last DDL was performed against a certain table by looking at the LAST_DDL_TIME column in the DBA_OBJECTS view. HTH Mark -Original Message- Sent: Monday, August 06, 2001 07:06 To: Multiple recipients of list ORACLE-L since, date? Hi Gurus Let I have one table TAB_1 having max extent 121.I have changed max extents 230 from 121.Which View will show the table TAB_1 storage parameter has changed.In DBA_SEGMENTS I can only get storage parameter.But,I want to know which are the objects which storage parameter changed since 10 days. Thanks in advance. -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: Re: Whatever became of ORAC
I reckon the best scene was when Orac plays a chess game against a pro, and the stake is the ship and Blake's life. The game is a variant with a truly awesome yet simple rule change - you can move whenever you like, rather than waiting for the other guy all the time. Orac in his a-retentive voice is casually making about one move to the other guy's four, and the intonation manages to make it totally clear that he wins the game out of self-respect rather than because he gives a damn about the wager. Greg Solomon Oracle Geezer -Original Message- Sent: Monday, 06 August 2001 17:51 To: Multiple recipients of list ORACLE-L In the UK, ORAC was a computer of the cult TV series Blake's Seven. Orac was the most sophisticated artifical intelligence in the universe. It had an amazing array of technical abilities but it also had some problems. Problems It had a snappy voice and was often impatient with anyone unfortunate enough to ask it a question. It also showed little concern for the rest of the crew who it regarded with scorn. In short, Orac would much rather spend time contemplating the mysteries of the universe than spending time with mere mortals. Sorry for the sideline ! Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. Knaves House, Knaves Beech Business Centre Loudwater, High Wycombe Buckinghamshire , HP10 9QR, United Kingdom Telephone: +44 (0) 1494 540235 Facsimile: +44 (0) 1494 488824 E Mail: [EMAIL PROTECTED] -- Orr, Steve sorr@rightnoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] w.com cc: Sent by: Subject: Whatever became of ORAC root@fatcity. com 06/08/2001 17:21 Please respond to ORACLE-L Do anyone know whatever became of ORAC. It was an attempt to build an open source web-based DBA tool in Perl but it doesn't look like much has happened. Here's a link. http://www.tux.org/orac-dba/news.html Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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)... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Solomon 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: Help needed
look up auditing it is your friend ;) joe Deewaker G.V. wrote: HI DBA Guru's It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this.. The pc name who was connected. The time when he/she executed the process What was the command given to execute the same.. Pls... Guruji's help me... with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. (: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- Joe Testa 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: Joe 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).
RE: completely off-topic question...
I read the Silmarillion - It's a hard go the first time, but it grows on you. I especially liked the stories in Beleriand, the creation of the rings, the capture of the twin silmarils on their pillars of light and the fall of that island - can't remember its name now. Most of its kings had names that started with Ar- . The travels of the elves, the creation of the dwarves, the Ainur and the Valar, the Illuvatar, Morgoth and Melkor. I soaked up that book, it is so broad in scope that it creates a world in itself. I must have read it four or five times at least. Much of it hints at ancient legendary events in our own history, as if it contained echoes of our own distant past. Tolkien did a lot of work with anglo-saxon and the Gaelic languages and he used that to help him weave a whole world. The elves from the East, that echoes the Gaelic stories of the Tuatha de Danaan. The Valar remind me of them a bit. There were some useful resource items published on Middle-Earth by a company called I.C.E. - but they were forced into bankruptcy as soon as work on the upcoming movie started... a very sad state of affairs. Granted they were pushing a role-playing game, but they had published good detailed descriptions of all the characters in the Middle-Earth related stories, and had resource materials, scenarios and detailed maps as well. Bree and The Barrow Downs, Isengard, Mirkwood, Angmar, all the modules struck me as being of very high quality. Overall I think I.C.E. did an outstanding job and they encourage people my age to explore Middle-Earth in detail and develop a strong liking for Tolkien's works. They did more in that regard for me than Christopher Tolkien (J.R.R.'s son) ever did with all those drafts he published. I.C.E. just couldn't compete with the allure of big movie revenues, the upcoming movie appears to have a stranglehold on Tolkien-related mechandising now, they are forcing web sites to close, and some companies were forced to shut down. Ref. Re. I.C.E. materials http://www.chapter-one.com/merp/products.html#ref http://www.chapter-one.com/merp/products.html#ref ; re. the upcoming movie trilogy that is trying to control the appearance of all Tolkien products, à la Star Wars for merchandising: http://www.lordoftherings.net/index_flat.html http://www.lordoftherings.net/index_flat.html This is the same nonsense that took place when Paramount decided to revamp Star Trek to make it more popular. OK, no more OT topics from me for this week, the list is getting overwhelmed with them. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Yosi Greenfield [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 1:55 AM To: Multiple recipients of list ORACLE-L Subject:Re: completely off-topic question... Oy - I could NOT get through The Silmarillion, even though I loved the Hobbit (I was but a kid), and I really liked the Trilogy (although I admit to skipping lots of the songs and such...) Some people really read The Silmarillion, huh? -- 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).
Re: 8.1.5/HP-UX 11/all_objects view
Kirti, thanks for the clarification. joe Deshpande, Kirti wrote: Joe/Mike: If the synonyms are PUBLIC they will appear in ALL_OBJECTS and ALL_SYNONYMS. If these are PRIVATE synonyms, they will not appear in ALL_OBJECTS, even if the user has access to the table. With access to the table PRIVATE synonyms will appear in ALL_SYNONYMS, else not. What type of synonyms are we dealing with here? Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Joe Testa [SMTP:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 8:26 PM To: Multiple recipients of list ORACLE-L Subject: Re: 8.1.5/HP-UX 11/all_objects view ok unless i'm missing something here(which i could be, as i'm battling installing a stupid printer under linux but thats another story). all_objects shows all objects you own or have access to. all_synonyms show all synonyms you own AND all public synonyms. so if you there is a public synonym on an object you dont have access to it won't appear in all_objects but will appear in all_synonyms. Anyone care to straighten me out, or did i get it right :) joe Vergara, Michael (TEM) wrote: Hi All! My question for today is 'when is an object supposed to be displayed in the ALL_OBJECTS view?'. I have a schema id which is a legacy id - left over from a previous version of our data warehouse. In this legacy schema are synonyms for the tables in the new schema. Grants and all are ok. When I log in as a user with the correct (I think) roles assigned, I want to do a select of ALL_OBJECTS and see what objects are still referenced in the legacy schema. However, these synonyms do not appear. They're in ALL_SYNONYMS, but not ALL_OBJECTS. I can query the synonyms in a select statement so I know I have rights. Why do I not see these objects in ALL_OBJECTS? Thanx, Mike --- == = Michael P. Vergara | Don't worry about the world coming to an end Oracle DBA | today. It's already tomorrow in Australia. Guidant Corporation | - Charles Schulz -- 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) -- Joe Testa 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: Joe 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).
Re: Precise
I've tested it. It's good but expensive. You can have an accounting and transform it into with graphics showing you the waits in order of importance. When I say accounting I mean that save all sqls through a period of time. F.e. you want to know what happens in the night window and then schedule the tool to save all the activity and then you can see what was the worst wait. Then you can easily compare with the same day of another week. It doesn't consume much memory. However it could consume much space in file system depending on what you want to save. And except for explain plans it doesn't connect to database. Regards. --- O'Neill, Sean [EMAIL PROTECTED] wrote: Is no-one on this list using Precise SQL or Precise Pulse?. Has anyone heard of them or evaluated them?. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Unknown RBS
maybe this is public rollback segment. - Original Message - From: Sinardy [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 5:36 PM Subject: Unknown RBS Hi all, I have question below here .. (Solaris 7 Oracle 8.1.6) I startup my database with this parameter db_name = MyDB instance_name = MyDB service_names = MyDB control_files = (/export/home/basic/MyDB/ctl/control01.ctl, /export/home/basic/MyDB/ctl/control02.ctl, /export/home/basic/MyDB/ctl/control03.ctl) open_cursors = 100 max_enabled_roles = 30 db_block_buffers = 9280 shared_pool_size = 12670976 large_pool_size = 614400 java_pool_size = 0 log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 processes = 50 log_buffer = 163840 background_dump_dest = /export/home/basic/MyDB/dump/bdump core_dump_dest = /export/home/basic/MyDB/dump/cdump user_dump_dest = /export/home/basic/MyDB/dump/udump db_block_size = 4096 remote_login_passwordfile = none os_authent_prefix = compatible = 8.1.0 sort_area_size = 65536 sort_area_retained_size = 65536 SQL select name from v$rollname; NAME --- SYSTEM RBS0 RBS1 RBS2 Where are these RBS* rollback segments come from ? Because I am not include the ROLLBACK_SEGMENTS = ( RBS0, RBS1, RBS2 ) parameters Thank you, Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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). W±ë zØ^¡÷âr¥9,BÅm¶ÿà (§Ú©Êëa¢·!jb 7!jb'ɨh¡ÊrqZ´(È×ÂäIêïǬó9ßÎtçQ@_Î|ç9ÓRjpâz jX¢¹âhû'׫ëZqǬ³óX§¸¬¶ÄèDCTL¨º» ÷ë¢kaÉX§X¬¶Ç§u©Ä1¨¥ë,j ¸¬´k«¹ör+rr§¢×\ ²¥)à¡òâ²Ñ®®æ§v)í é²Æ xb)Üç^jX§yÊ'µ¨§x5%9,Bè®Ø^©¡ùX§X¬·*.Á©í¶Þ騽ç_®¢éÉ©l¢Ç§vØ^ BÏr¦jw_¢º- êâú+«b¢ybë.nÇ+¸§
Re: how to stop a killed session bothering me ?
You should wait for PMON ending its job of rollback the transaction of that killed session. Since one of the releases of 8i that duty is a new one for the SMON. You have few options. If you are in a hurry, you could do shutdown abort. First issue an alter system checkpoint; just in case a maybe possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup orapid of PMON or SMON depending on the release However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear all ! I have killed a session while it was populating a big table. Now the session is marked KILLED in v$session. It's serial# is keeping being incremented , so i assume that a rollback (of rows inserted into that big table by that session) is going on there in the background. This rollback runs for several hours already preventing me from DMLing that big table. Is there a way to stop that rollback / drop / truncate that table ? Thanks a lot in advance . Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Help needed
Deewaker, you can run the listed srcipt to find the users that are connected to your server. With a little modification you can get all of the information you need. ROR mª¿ªm + user1.sql++ COLUMN SU FORMAT A8 HEADING 'ORACLE|USER ID' JUSTIFY LEFT COLUMN OSU FORMAT A8 HEADING 'SYSTEM|USER ID' JUSTIFY LEFT COLUMN STAT FORMAT A8 HEADING 'SESSION|STATUS' JUSTIFY LEFT COLUMN SSID FORMAT 99 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT COLUMN SSER FORMAT 99 HEADING 'ORACLE|SERIAL|NO' JUSTIFY RIGHT COLUMN SPID FORMAT A9 HEADING 'ORACLE|SESSION|ID' JUSTIFY RIGHT COLUMN TXT FORMAT A28 HEADING 'CURRENT STATEMENT' JUSTIFY CENTER WORD COLUMN LOGTIME FORMAT A10 HEADING 'LOGIN|TIME' JUSTIFY RIGHT SELECT S.USERNAME SU, S.OSUSER OSU, to_char(S.LOGON_TIME,'MM-DD- HH:MI:SS') LOGTIME, S.STATUS STAT, S.SID SSID, S.SERIAL# SSER, LPAD(P.SPID,9) SPID, SUBSTR(SA.SQL_TEXT,1,540) TXT FROM V$PROCESS P, V$SESSION S, V$SQLAREA SA WHERE P.ADDR=S.PADDR AND S.USERNAME IS NOT NULL AND S.SQL_ADDRESS=SA.ADDRESS (+) AND S.SQL_HASH_VALUE=SA.HASH_VALUE (+) ORDER BY 1,3,6; +end user1.sql ++ [EMAIL PROTECTED] 08/07/01 04:00AM HI DBA Guru's It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this.. The pc name who was connected. The time when he/she executed the process What was the command given to execute the same.. Pls... Guruji's help me... with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. *: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers 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: Weird -904 Problem
Do you create the table with any strange symbol or in lowercase or mixing lower and upper or within spaces..?, As f.e.: create table weird ( Weird Field NUMBER ); Regards. --- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] wrote: Howdy, I had an interesting situation today. The application was trying to insert rows into a table and was getting a -904 error for invalid column. The actual problem was that the tablespace containing the indexes was full and the index was unable to extend. That was in the alert log. However, when doing a tkprof on their sql statements, it showed every sql statement getting a -904. It doesn't seem like it should do that. Has anyone seen this before? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Unknown RBS
Sinardy, They are the RBS's that are created when you created the database. You only need the specify the RBS in the init.ora when they are public RBS that need to be identified if you use MTS. If your connections are DEDICATED then you do not have to place them in the init.ora but it will not hurt anything if you do. List, Correct me if I got it wrong. ROR mª¿ªm [EMAIL PROTECTED] 08/07/01 05:36AM Hi all, I have question below here .. (Solaris 7 Oracle 8.1.6) I startup my database with this parameter db_name = MyDB instance_name = MyDB service_names = MyDB control_files = (/export/home/basic/MyDB/ctl/control01.ctl, /export/home/basic/MyDB/ctl/control02.ctl, /export/home/basic/MyDB/ctl/control03.ctl) open_cursors = 100 max_enabled_roles = 30 db_block_buffers = 9280 shared_pool_size = 12670976 large_pool_size = 614400 java_pool_size = 0 log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 processes = 50 log_buffer = 163840 background_dump_dest = /export/home/basic/MyDB/dump/bdump core_dump_dest = /export/home/basic/MyDB/dump/cdump user_dump_dest = /export/home/basic/MyDB/dump/udump db_block_size = 4096 remote_login_passwordfile = none os_authent_prefix = compatible = 8.1.0 sort_area_size = 65536 sort_area_retained_size = 65536 SQL select name from v$rollname; NAME --- SYSTEM RBS0 RBS1 RBS2 Where are these RBS* rollback segments come from ? Because I am not include the ROLLBACK_SEGMENTS = ( RBS0, RBS1, RBS2 ) parameters Thank you, Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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: Ron Rogers 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: ORA-00600 on Production DB - Need advice
I thought that was the question, how to get service on an ITAR. Oh well, it was Monday after all. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 06, 2001 5:12 PM Ruth Gramolini wrote: 1-800-223-1711 I have what used to be Silver Support and that works. When I had wht used to be Bronze Support I didn't have an 800 number. Good luck! Ruth and they are going to tell you that you have to file an iTAR with metalink first. -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] One ping to rule them all, One ping to find them, One ping to bring them all, And in the MUTX bind them. I am the computer your mother warned you about. -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Access to Oracle sql conversion question
Oracle version 7.3.2 Access Sql that works SELECT FIRST([columnName]) as ftmp from [tablename] where etc Oracle doesn't work... looks like FIRST function doesn't exist.. How can I replace this functionality with Oracle SQL? Any help greatly appreciated! Steve Johnston -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Steve 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: Unknown RBS
Look up the dba_rollback_segs. Maybe there are public. In other words maybe it was created with create public rollback segment stmt. Therefore issue an: select owner,segment_name from sys.dba_rollback_segs; --- Sinardy [EMAIL PROTECTED] wrote: Hi all, I have question below here .. (Solaris 7 Oracle 8.1.6) I startup my database with this parameter db_name = MyDB instance_name = MyDB service_names = MyDB control_files = (/export/home/basic/MyDB/ctl/control01.ctl, /export/home/basic/MyDB/ctl/control02.ctl, /export/home/basic/MyDB/ctl/control03.ctl) open_cursors = 100 max_enabled_roles = 30 db_block_buffers = 9280 shared_pool_size = 12670976 large_pool_size = 614400 java_pool_size = 0 log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 processes = 50 log_buffer = 163840 background_dump_dest = /export/home/basic/MyDB/dump/bdump core_dump_dest = /export/home/basic/MyDB/dump/cdump user_dump_dest = /export/home/basic/MyDB/dump/udump db_block_size = 4096 remote_login_passwordfile = none os_authent_prefix = compatible = 8.1.0 sort_area_size = 65536 sort_area_retained_size = 65536 SQL select name from v$rollname; NAME --- SYSTEM RBS0 RBS1 RBS2 Where are these RBS* rollback segments come from ? Because I am not include the ROLLBACK_SEGMENTS = ( RBS0, RBS1, RBS2 ) parameters Thank you, Regards Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinardy 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: computer history stories - Now: Age discrimination?
I stand by what I had said earlier, I think you've done a great job Mark. There is nothing wrong with being good at many things and not yet an expert at something, especially at the age of 22. I think I am more of a jack of all trades and not yet an expert on anything. When I started here about three years ago I thought I knew stuff about computers, but it turns out I really didn't know anything. Now I build my own PC's and PC's for my friends and family. It doesn't bother me to have all of this knowledge floating around. You know, my father has been Sr VP of several company's and held other executive postitions and one of the main reasongs that he is looked upon in his industry so well is because he started from the bottom and worked his way to the top. When he comes up with an engineering idea it usually isn't questioned because he could implement it himself if he wanted too. Oops, starting to ramble, anyway, keep up the good work!! KK -Original Message- Sent: Tuesday, August 07, 2001 6:21 AM To: Multiple recipients of list ORACLE-L Well, thanks for the vote of confidence there Christopher! :) I will start off by saying - I am *not* a DBA, though I am fully aware of all that the job entails what with selling performance, tuning and management tools to you guys on a daily basis. I am *trained* to do the job - and have done a hell of a lot of reading and testing and playing.. The one thing I will say is that you guys - the DBAs - are for the most part not very impressed by our type of company when the sales critter that calls you (me) does not know what they are talking to you about. With this in mind I have made it my job to learn as much as I can - both in and out of work hours - to be just as much up to speed on the databases we deal with as you - the DBAs. I could competently look after an Oracle or SQLServer database if thrown in the deep end (though I may not be a performance expert like Kirti or Gaja) or have written a book on any subject that I have chosen to learn - or in fact published my IQ to people around the world :) The same goes with HTML JAVA programming - I'm no expert but can certainly hold my own! By the way I finally published our new site over the weekend www.cool-tools.co.uk, and included your very own site in our links section, the site was FULLY done by myself. I don't claim to be an expert - and I don't think that I did in my original posting - but then I don't usually run to an expert for him to fix a problem that I'm having (though I have on the odd occasion turned to the list for advice:) ) I usually just sink my teeth in to a manual or online, test, play and learn on my own two feet. Being 22 I think I have pretty a good head start - and hey If you didn't know what I did @ 22, and your only 26 I should be a GURU by the time I reach your age? Jealous? :) Cheers Mark -Original Message- Spence Sent: Monday, August 06, 2001 05:57 To: Multiple recipients of list ORACLE-L I would be curious of HOW WELL he knows those things. Anyone can learn most of everything out there, but to be able to do it and do it well is another thing. Also when you go so many directions like that, you never work on the same thing for long, which means you need to be able to jump back into something else VERY quickly or there is no sense learning it in the first place. There is one thing as being good at many things, but when the sh%t really hits the fan, you call someone that knows what their doing, not the jack of all trades. I being 26, I found myself becoming a jack of all trades, and I think I still am. I did not like that, so I picked up Oracle about 3.5 years ago and decided I am going to take one thing, and be damn good at it. I was a good system admin and adapted very well. But I did not get the luxery of REALLY knowing everything about what I was using. Although I generally can figure things out extremely quick where it appears I know it. I! was not comfortable with my accomplishments, I wanted to know more and more. I could not do that doing what I was doing, broad generalization was not how I wanted to be. With an iq of 147, I think I can be considered a very quick learner. I know for a fact that 4 years ago when I was 22, I could not do all of what was claimed in previous email by Mark (Oracle DBA, Sybase Admin, SQL Server DBA, JAVA, HTML) and consider myself great at it. Although you can be very comfortable with them, comfort can be obtained in very short time frames. True talent to play as an allstar takes years, no matter how smart you are and what ya doing. I once met a street sweeper who was going on to 50 years old, I asked him why did he not try to find a better job. His answer was Because I am the best street sweeper there ever was. After saying that, I had a new found respect for him and was detirmined to seek the same motivation in my life. Do not criticize someone until you walked a mile in their shoes, that way when you criticize
OT, but maybe not
I know, sorry I've gotten an Alzheimer moment here, but there is someone on the list working with my old employer, the USAF, on Oracle HR I do believe. I'd like to ask that individual if he/she 'd like to comment on the following: Defense Department to use PeopleSoft for payroll, HR The U.S. Department of Defense has hired PeopleSoft Inc. to provide a new human resources and payroll software system for its 3.1 million military personnel around the world. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62850_NLTPM%2C00.html Seems to me that if they spent a pile of on Oracle's stuff why on earth would one spend additional to implement a different one? Dick Goulet -- 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 -- suggestions to ensure nerdiness in potential IT staff
You trying to seduce me, Mrs Robinson? ;0) -Original Message- Sent: Friday, August 03, 2001 8:01 PM To: Multiple recipients of list ORACLE-L baby! :) From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Fri, 03 Aug 2001 10:12:42 -0800 And I was... 6 :0) g -Original Message- Sent: Wednesday, August 01, 2001 10:39 PM To: Multiple recipients of list ORACLE-L and in 1981 I was divorcing my first husband -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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/intl.asp -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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: For those who got Code Red in the face
I would check quickly for these files, http://vil.nai.com/vil/virusSummary.asp?virus_k=99177 Presence of the files: c:\inetpub\scripts\root.exe c:\progra~1\common~1\system\MSADC\root.exe d:\inetpub\scripts\root.exe d:\progra~1\common~1\system\MSADC\root.exe. Also make sure your virus protection is up to date, it should let you know if the back door put in by the latest code red is on your machine. -Original Message- From: Jack C. Applewhite [mailto:[EMAIL PROTECTED]] Sent: Monday, August 06, 2001 6:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: For those who got Code Red in the face Our webserver got hit a couple of weeks ago. It got cleaned up and the security patch(es) applied. I thought nothing more about it. However, I think it or a variant got three of our other Win2k servers that don't run IIS at all. Yesterday I found a strange process, VMGR32.exe, chewing up 50% CPU on our production db server. The file, in C:\WinNT\System32, was dated 07/30/2001 08:40pm. Another file, acer4.exe, of exactly the same size, 272KB, had exactly the same datetime. Neither file shows the usual Version tab in the Properties window (after right click on the file). I searched the Microsoft site and did a Google search on both, with zero hits. Suspicious... I checked out http://www.net-security.org/text/articles/coverage/code-red/ but couldn't see any similarities until it suggested running netstat -an to see if your server was connecting to dozens of random IP addresses at port :80. I did and ours was! I changed the service Remote Administration Service (which loads VMGR32.exe) to Manual and rebooted the servers. The connections to random IP addresses at port :80 have stopped and VMGR32.exe is no longer running as a process. I also installed Win2k Service Pack 2. I hope I've squashed this worm! Have I? Are the port :80 connections and VMGR32.exe related or have I been chasing the wrong culprit? The NT sysadmin at our colocation facility isn't a lot of help (one reason we're looking to switch pretty soon!), so I'm kind of at a loss. Any suggestions? Thanks. Jack Jack C. Applewhite Database Administrator/Developer OCP Oracle8 DBA iNetProfit, Inc. Austin, Texas www.iNetProfit.com [EMAIL PROTECTED] (512)327-9068 -Original Message- [EMAIL PROTECTED] Sent: Monday, August 06, 2001 2:24 PM To: Multiple recipients of list ORACLE-L New worm targets same systems as Code Red Security analysts warned that a new and potentially dangerous worm began circulating over the weekend, targeting the same Windows-based servers as the high-profile Code Red worm. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62834_NLTAM%2C00.html -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack C. Applewhite 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: Anderson, Brian 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: Bozeman
Cool. Thanks for the info, Yosi. I'll take a look. --Walt Weaver Bozeman, Montana -Original Message- Sent: Monday, August 06, 2001 5:15 PM To: Multiple recipients of list ORACLE-L Walt (the resident Bozemanian), and All, I don't know if you heard or saw, the cover story in Inc magazine this week was all about Bozeman (and some other places). Some absolutely beautiful pictures in there too. (I shoulda posted this on Friday. When you're on extended vacation, Friday is much the same as Monday, and Friday I was out mostly.) Yosi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yosi Greenfield 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: Weaver, Walt 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: Master/master with diff username possible ?
Henrik, No, in 8.1.7 I don't see an easy way of doing this. You could accomplish this in 9i with multi-level updatable snapshots/materialized views as I mentioned, but the conflict resolution gets rather tricky and results in a lot more network traffic as the changes have to be sent back up and down multiple levels. HTH, -- Anita --- Henrik Ekenberg [EMAIL PROTECTED] [EMAIL PROTECTED] wrote: Hello Anita Thanks for your answer. We need to share some tables between different software. So we need to replicate these tables to different schemas. One of these schemas will probably be on an other machine. Then will we replicate these schemas to different sites. You can't replicate one snapshot in 8.1.7, so we can't use snapshot to solve our problem. Regards H. Ekenberg On Sun, 5 Aug 2001, A. Bardeen wrote: -!-Henrik, -!- -!-Multi-master replication requires that the schemas be -!-identical on all sites. In addition you cannot -!-replicate within the same site. -!- -!-9i now allows updatable snapshots of updatable -!-snapshots although it has the same restriction as -!-multi-master in that the schemas must be identical. I -!-believe it also has the restriction that you cannot -!-replicate within the same site. -!- -!-I'm assuming that by replicating from one schema to 3 -!-schemas you were referring to replicating within the -!-same db. I'm not sure why you would need to do this -!-nor how you could accomplish this unless you wrote -!-your own replication code. -!- -!-As far as replicating to different schemas in -!-different db's, the usual workaround is to replicate -!-to the same schema and then use synonyms. -!- -!-HTH, -!- -!--- Anita -!- -! Henrik Ekenberg [EMAIL PROTECTED] -!-[EMAIL PROTECTED] wrote: -!- Hello, -!- -!- We are running 8.1.7 on Solaris 8 on E4500. -!- We need to replicate one table from one schema to 3 -!- other schema and the -!- replicate these 3 schemas to other sites. -!- We can't use snapshot on snapshots because Oracle -!- will do a complete -!- refresh each time. -!- Is there any trick to replicate to different schema -!- with master/master. -!- -!- If you have any advice please let me know. -!- -!- Thanks -!- H. Ekenberg -!- -!- -!- -! -!- Experience is a hard teacher because she gives the -!- test first, -!- the lesson afterward. -!- -!- -- Vernon Law -!- -!- H.Ekenberg -!- Anoto AB -!- E-mail :[EMAIL PROTECTED] Tel -!- +46 (0)8 410 78 500 -!- -!- -!- -!- -- -!- Please see the official ORACLE-L FAQ: -!- http://www.orafaq.com -!- -- -!- Author: Henrik Ekenber -!- INET: [EMAIL PROTECTED] -!- [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!? -!-Make international calls for as low as $.04/minute with Yahoo! Messenger -!-http://phonecard.yahoo.com/ -!- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED] [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!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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
RE: how to stop a killed session bothering me ?
If you did a shutdown abort, wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 07, 2001 8:21 AM To: Multiple recipients of list ORACLE-L You should wait for PMON ending its job of rollback the transaction of that killed session. Since one of the releases of 8i that duty is a new one for the SMON. You have few options. If you are in a hurry, you could do shutdown abort. First issue an alter system checkpoint; just in case a maybe possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup orapid of PMON or SMON depending on the release However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear all ! I have killed a session while it was populating a big table. Now the session is marked KILLED in v$session. It's serial# is keeping being incremented , so i assume that a rollback (of rows inserted into that big table by that session) is going on there in the background. This rollback runs for several hours already preventing me from DMLing that big table. Is there a way to stop that rollback / drop / truncate that table ? Thanks a lot in advance . Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: HAWKINS, JAMES W [IT/1000] 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).
PLS-00993: cursor variables cannot be passed as RPC arguments or
I am getting this error when trying to call a packaged procedure, with an in/out ref cursor, across instances and servers. Both instances are 8.0.4. (database and PL/SQL) The documentation (below) implies that this should be possible with my version of PL/SQL. Is this just a lie, or am I doing something wrong? PLS-00993: cursor variables cannot be passed as RPC arguments or results Cause: An attempt was made to pass a cursor variable to or from a remote subprogram, which is not allowed. For example, a remote procedure cannot be used to open a cursor variable because remote subprograms cannot return the values of cursor variables. Action: Change the subprogram call to reference a local database. Or consider an upgrade to PL/SQL 2.3, where this restriction is not present, or rewrite your application using OCI or precompiler. --- Thanks David Jones ACNielsen, Oxford, UK -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jones, David 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, but maybe not
well glad i'm not in(military) anymore, as i know what peopleslop is like and am glad my records/payroll wont be in there. joe [EMAIL PROTECTED] 08/07/01 10:20AM I know, sorry I've gotten an Alzheimer moment here, but there is someone on thelist working with my old employer, the USAF, on Oracle HR I do believe. I'dlike to ask that individual if he/she 'd like to comment on the following:Defense Department to use PeopleSoft for payroll, HRThe U.S. Department of Defense has hired PeopleSoft Inc. to provide a new humanresources and payroll software system for its 3.1 million military personnelaround the world.http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62850_NLTPM%2C00.htmlSeems to me that if they spent a pile of on Oracle's stuff why on earthwould one spend additional to implement a different one?Dick Goulet-- 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-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: how to stop a killed session bothering me ?
Yes, but it is painless in comparison with the one done through shutdown immediate. --- HAWKINS, JAMES W [IT/1000] [EMAIL PROTECTED] wrote: If you did a shutdown abort, wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 07, 2001 8:21 AM To: Multiple recipients of list ORACLE-L You should wait for PMON ending its job of rollback the transaction of that killed session. Since one of the releases of 8i that duty is a new one for the SMON. You have few options. If you are in a hurry, you could do shutdown abort. First issue an alter system checkpoint; just in case a maybe possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup orapid of PMON or SMON depending on the release However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear all ! I have killed a session while it was populating a big table. Now the session is marked KILLED in v$session. It's serial# is keeping being incremented , so i assume that a rollback (of rows inserted into that big table by that session) is going on there in the background. This rollback runs for several hours already preventing me from DMLing that big table. Is there a way to stop that rollback / drop / truncate that table ? Thanks a lot in advance . Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: HAWKINS, JAMES W [IT/1000] 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens
RE: Re: Whatever became of ORAC
Oddly, Orac reminded me a lot of Rachel's Mensa friends... Brian Norrell Manager, MPI Development QuadraMed 511 E John Carpenter Frwy, Su 500 Irving, TX 75062 (972) 831-6600 -Original Message- Sent: Tuesday, August 07, 2001 6:16 AM To: Multiple recipients of list ORACLE-L I reckon the best scene was when Orac plays a chess game against a pro, and the stake is the ship and Blake's life. The game is a variant with a truly awesome yet simple rule change - you can move whenever you like, rather than waiting for the other guy all the time. Orac in his a-retentive voice is casually making about one move to the other guy's four, and the intonation manages to make it totally clear that he wins the game out of self-respect rather than because he gives a damn about the wager. Greg Solomon Oracle Geezer -Original Message- Sent: Monday, 06 August 2001 17:51 To: Multiple recipients of list ORACLE-L In the UK, ORAC was a computer of the cult TV series Blake's Seven. Orac was the most sophisticated artifical intelligence in the universe. It had an amazing array of technical abilities but it also had some problems. Problems It had a snappy voice and was often impatient with anyone unfortunate enough to ask it a question. It also showed little concern for the rest of the crew who it regarded with scorn. In short, Orac would much rather spend time contemplating the mysteries of the universe than spending time with mere mortals. Sorry for the sideline ! Steve Parker Technical Consultant LIS -- Logistics Internet Systems Ltd. Knaves House, Knaves Beech Business Centre Loudwater, High Wycombe Buckinghamshire , HP10 9QR, United Kingdom Telephone: +44 (0) 1494 540235 Facsimile: +44 (0) 1494 488824 E Mail: [EMAIL PROTECTED] -- Orr, Steve sorr@rightnoTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] w.com cc: Sent by: Subject: Whatever became of ORAC root@fatcity. com 06/08/2001 17:21 Please respond to ORACLE-L Do anyone know whatever became of ORAC. It was an attempt to build an open source web-based DBA tool in Perl but it doesn't look like much has happened. Here's a link. http://www.tux.org/orac-dba/news.html Steve Orr -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve 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)... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Solomon 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: Norrell, Brian 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
RE: how to stop a killed session bothering me ?
Pay Oracle now or pay Oracle later If you did a shutdown abort, wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce 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: GAD! Access to Oracle sql conversion question
It always amazes me how 20 seconds after I post a question to a newsgroup for all to see that I find a solution that answers! Thanks anyway for the bandwidth... -- Original Message -- Reply-To: [EMAIL PROTECTED] Date: Tue, 07 Aug 2001 05:55:23 -0800 Oracle version 7.3.2 Access Sql that works SELECT FIRST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Steve 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 -- suggestions to ensure nerdiness in potential IT staff
nah, your wife would get upset. now, if you tempted me with more Friday recipes, that would be a different story :) From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Tue, 07 Aug 2001 06:40:26 -0800 You trying to seduce me, Mrs Robinson? ;0) -Original Message- Sent: Friday, August 03, 2001 8:01 PM To: Multiple recipients of list ORACLE-L baby! :) From: Guy Hammond [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: OT -- suggestions to ensure nerdiness in potential IT staff Date: Fri, 03 Aug 2001 10:12:42 -0800 And I was... 6 :0) g -Original Message- Sent: Wednesday, August 01, 2001 10:39 PM To: Multiple recipients of list ORACLE-L and in 1981 I was divorcing my first husband -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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/intl.asp -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guy Hammond 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/intl.asp -- 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).
Re: ORA-00600 on Production DB - Need advice/Still Searching
David, What is your setting for LARGE_POOL and have you tried decreasing it? Also, this is frequently caused by 3rd party software, such as AutoSecure, that does additional authorization. Also check to ensure that user oracle (or whatever user you're using to start the db) has not been removed from the dba group in the /etc/group file. HTH, -- Anita --- [EMAIL PROTECTED] wrote: Denny/Kirti, Thanks for the replies. The bug finder is kinda cool. I'd already been through about one third of the entries it found, but I looked through the rest. No real help. Can't log in to shut down the DB. Whether I try svrmgrl or sqlplus, I get asked for a password or told I have insufficient privileges. There aren't any additional trace files. Here's the output of the ulimit -a command: qe2n1: /u014/oradata/ifastrn/usr/bin/ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) 196608 stack(kbytes)196608 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 kmtune shows me the following: maxssiz 0X0C00 maxssiz_64bit 0x4000 swapmem_on 0 dbc_max_pct 50 Total physical and swap meory (from top) is: Memory: 364536K (264244K) real, 423812K (340152K) virtual, 6453348K free David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Denny Koovakattu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-00600 on Production DB - Need advice .tenet.edu 08/06/2001 12:44 PM Hi David, To get the proper output for ulimit, use /usr/bin/ulimit -a or sh ulimit -a Also the following information should help in trying to debug the problem. 1. Total Physical Memory 2. Total Disk Swap Configured 3. The output of kmtune or the kernel parameters maxdsiz, maxdsiz_64bit, swapmem_on, dbc_max_pct 4. The output of ulimit (Use /usr/bin/ulimit -a ) Have you tried restarting the database ? Regards, Denny [EMAIL PROTECTED] wrote: Mondays, gotta love em, they make Fridays worth the wait. I've got Ta production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an ora-600 when users try to log in. I've created a TAR (3 hours ago), but haven't gotten any response. Here's the error: ERROR: ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], [], [], [], [], [ Metalink has a couple of messages stating that this is an OS problem related to the ulimit size, availability of virtual memory, and the ability to create a pga. Suggested remedy is to increase the ulimit. My SA has dismissed this as a cause. I've knocked all the users off, but still can't log in. When I run ulimit I get the following: qe2n1: /u001/app/oracle/product/8.1.7/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 _ 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: 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 stop a killed session bothering me ?
Right, as we like to say 'you can pay smon now or you can pay him later' but he will get his due. Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 10:50 AM If you did a shutdown abort, wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 07, 2001 8:21 AM To: Multiple recipients of list ORACLE-L You should wait for PMON ending its job of rollback the transaction of that killed session. Since one of the releases of 8i that duty is a new one for the SMON. You have few options. If you are in a hurry, you could do shutdown abort. First issue an alter system checkpoint; just in case a maybe possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup orapid of PMON or SMON depending on the release However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear all ! I have killed a session while it was populating a big table. Now the session is marked KILLED in v$session. It's serial# is keeping being incremented , so i assume that a rollback (of rows inserted into that big table by that session) is going on there in the background. This rollback runs for several hours already preventing me from DMLing that big table. Is there a way to stop that rollback / drop / truncate that table ? Thanks a lot in advance . Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: HAWKINS, JAMES W [IT/1000] 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from
RE: how to stop a killed session bothering me ?
Jim, No, since 7.3 SMON does the rollback in the background upon startup. If a user session attempts to access a row that is part of an uncommitted transaction that needs rolling back then that user session will take over the rollback of that transaction. HTH, -- Anita --- HAWKINS, JAMES W [IT/1000] [EMAIL PROTECTED] wrote: If you did a shutdown abort, wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 (314) 694-4417 [EMAIL PROTECTED] -Original Message- Sent: Tuesday, August 07, 2001 8:21 AM To: Multiple recipients of list ORACLE-L You should wait for PMON ending its job of rollback the transaction of that killed session. Since one of the releases of 8i that duty is a new one for the SMON. You have few options. If you are in a hurry, you could do shutdown abort. First issue an alter system checkpoint; just in case a maybe possible recover problem later. You see that it is a little risky. With a shutdown immediate, you might wait a lot. Even that you could afford it because of the dangerous of the abort option. The other is to issue through svrmgrl or sqlplus depending on the release an oradebug wakeup orapid of PMON or SMON depending on the release However there is a little chance that with this you could hurry the PMON for the rollback of the transaction. You can see how much work the PMON or SMON have to do through v$transaction: select b.sid,a.used_ublk from v$transaction a,v$session b where addr=taddr and b.status='KILLED'; Regards. --- Andrey Bronfin [EMAIL PROTECTED] wrote: Dear all ! I have killed a session while it was populating a big table. Now the session is marked KILLED in v$session. It's serial# is keeping being incremented , so i assume that a rollback (of rows inserted into that big table by that session) is going on there in the background. This rollback runs for several hours already preventing me from DMLing that big table. Is there a way to stop that rollback / drop / truncate that table ? Thanks a lot in advance . Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: HAWKINS, JAMES W [IT/1000] 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!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the
EMC Timefinder
Hi Folks, Good Morning. I am very new to this forum, So Please bear with me for any mistakes. I am also relatively new to the oracle 8 front(I am coming back to oracle after a gap of 4 years). So the question may be stupid. We are trying to set up an environment using Oracle 8.1.7, Emc Timefinder and RMAN. While there are no documents to describe how to do the setup on this, We did find some notes. But those are with oracle 7.0. Is someone on the group has this kind of setup? If so, Can you update me on the process?? Any Pros and Cons to go with this? Thanx for all responses Srikanth VS [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Valuthur, Srikanth 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: computer history stories - Now: Age discrimination?
M...beer I think your sort of bringing up that whole nature nurture issue, good lord that's a tough one. I would tend to agree that a person could have a high IQ, or a high ability to learn, but if they are not in an environment that promotes learning then they may not fullfill their abilities. On the other hand, someone in an environement that doesn't promote learning could still take upon themselves to educate themselves. (and don't knock any spelling errors, I am well aware of the fact that I can't spell!) KK -Original Message- Walt Sent: Tuesday, August 07, 2001 11:00 AM To: Multiple recipients of list ORACLE-L I thought IQ was related to the culture one grows up in, not something you're born with. In other words, if you're white and raised in a middle/upper-class environment your chance at doing well on an IQ test are orders of magnitude greater than for other people. I, of course, did very well on an IQ test when I was a teenager. Then I discovered beer and, well, things have gone, um, a bit downhill since then. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Monday, August 06, 2001 1:49 PM To: Multiple recipients of list ORACLE-L Yes, people are born with IQ, not smarts. I also believe you can alter your IQ slightly. From what I understand (which may be wrong) is IQ is simply how many gallon tank you were blessed with. It does not measure how much you filled this tank. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Weaver, Walt 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: Oracle Bug #1311597
Ethan, This is not an Oracle bug, but an AIX bug. The Oracle patch for this bug was merely a workaround until IBM released an APAR with the fix. You need the fix for IBM's lio_listio() problem (APAR IY15138). The fix is part of collective fix PTF U473812 (there may be a newer APAR out there that includes this). HTH, -- Anita --- Post, Ethan [EMAIL PROTECTED] wrote: I have run into this one on an 8.1.6 database AIX 4.3.3. I know there is an AIX patch but I am not the admin and may need a quicker solution to get async io back up. Anyone know if this still exist on 8.1.7.x for AIX 4.3.3.0? Thanks, Ethan http://www.geocities.com/epost1 -- This e-mail is intended for the use of the addressee(s) only and may contain privileged, confidential, or proprietary information that is exempt from disclosure under law. If you have received this message in error, please inform us promptly by reply e-mail, then delete the e-mail and destroy any printed copy. Thank you. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan 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!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.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:Precise
Hope this is not a duplicate, but I did get an error from Fatcity. Something about a locking issue?? Sean, Heard of, evaluated, pretty darn nice, did not support our environment at the time (HP-UX), and was too expensive for the tastes around here then. Dick Goulet Reply Separator Author: O'Neill; Sean [EMAIL PROTECTED] Date: 8/7/2001 2:15 AM Is no-one on this list using Precise SQL or Precise Pulse?. Has anyone heard of them or evaluated them?. Sean :) Rookie Data Base Administrator Oracle 7.3.3, 8.0.5, 8.1.7 - NT, W2K [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). -- 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).
Privileges
Title: Privileges I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when developing a procedure/package in Procedure Builder under program units, and then dragging it down to the bottom as user1 procedures, an error stating 'insufficient privileges on owner1.tablename' is received. Any ideas?? I have researched the 'grant execute on procedure' privilege but I don't see why I would need to do this for the table owner. My understanding of this privilege is to grant another user access to the procedure and maintain security in this way, instead of having to grant access to each user individually. Laura
Code Red
So does anyone know how to get rid of the virus if you got it? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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).
Optimizer Mode......how to choose the right one?
Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Privileges
this is documented, standard behavior you cannot use privileges granted via a role to write a stored procedure. Grant all on the table to user1 directly from owner1 and the procedure will run. Or, probably better, would be to develop the procedure as owner1 and grant execute on it to user1, or to the role. From: Burton, Laura L. [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Privileges Date: Tue, 07 Aug 2001 08:00:42 -0800 I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when developing a procedure/package in Procedure Builder under program units, and then dragging it down to the bottom as user1 procedures, an error stating 'insufficient privileges on owner1.tablename' is received. Any ideas?? I have researched the 'grant execute on procedure' privilege but I don't see why I would need to do this for the table owner. My understanding of this privilege is to grant another user access to the procedure and maintain security in this way, instead of having to grant access to each user individually. Laura _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- 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).
FW: computer history stories - Now: Age discrimination?
I did a B.A. Psych, and you are correct, IQ ratings are culturally biased. The one administered by the military to screen WW-2 applicants was blatantly biased. Over the years they (meaning the people who want to sell IQ exams to school boards and government agencies) tried to address this, but our university psychology prof told us that they haven't been able to do it very well. That was in the late eighties, maybe they managed to do it by now, but I seriously doubt it. The other problem is that IQ stands for Intelligence Quotient - it was age-specific, and was intended originally to be used to assess children's development. I.e. at a certain age, you are supposed to know certain things, and they use this quotient when evaluating children. I don't know if they still debate this, it struck me as problematic at best, even though I like Piaget very much. Another problem is that people have been comparing IQ test results, and found that some races tend to score better than others. This has been used to support some pretty twisted perspectives, and has helped foster stereotypes. In the early nineties the tables turned a bit when the stats showed that asians tended to score higher than caucasians, which was a good thing in my opinion, it stirred the pot. The whole problem is that IQ scores may indicate something in a general sense, but they are not all that precise in my opinion. The other problem, same as for most tests is... a high score indicates that you scored high on that particular test, it says nothing about the test's validity. Do tests accurately reflect reality? In most cases I think that is debatable, as anyone who did an IT certification lately would attest. To muddy the waters even more, to justify the validity of exams they usually rely on correlations, which don't indicate cause and effect much. So a high correlation can indicate a concurrence, but nobody really knows why. When a test does not fit with expectations... they change the scoring formula to make it fit other established exams! At least the IQ test is not a self-report, like so many of those psychology exams are. Self-reports are notoriously inaccurate, they are based on what people believe about themselves, which you can appreciate if you spent half an hour asking probing questions to people you know. Re. people using things without understanding why they might be accurate, I would point to the Myers-Briggs personality types exam that is so popular now, do the HR people who use it understand the theory behind that one? It has to do with alchemy, archetypes and a bag full of other esoteric concepts from C.G. Jung. I like C.G. Jung, though he is diametrically opposed to so much of the computing/statistics obsession that exists in north american psychology today. As a student of Freud he was dismissed as a quack by most north-american psychologists. I personally believe he was closer to the truth than many. These are my (pointed) opinions of course. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Weaver, Walt [SMTP:[EMAIL PROTECTED]] mailto:[SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:00 PM To: Multiple recipients of list ORACLE-L Subject:RE: computer history stories - Now: Age discrimination? I thought IQ was related to the culture one grows up in, not something you're born with. In other words, if you're white and raised in a middle/upper-class environment your chance at doing well on an IQ test are orders of magnitude greater than for other people. I, of course, did very well on an IQ test when I was a teenager. Then I discovered beer and, well, things have gone, um, a bit downhill since then. --Walt Weaver Bozeman, Montana, USA -Original Message- Sent: Monday, August 06, 2001 1:49 PM To: Multiple recipients of list ORACLE-L Yes, people are born with IQ, not smarts. I also believe you can alter your IQ slightly. From what I understand (which may be wrong) is IQ is simply how many gallon tank you were blessed with. It does not measure how much you filled this tank. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com http://www.orafaq.com -- Author: Weaver, Walt INET: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
RE: Privileges
You cannot use privileges granted through a role to create packages and procedures. They have to be directly granted to the user creating the packages and procedures. -Original Message- Sent: Tuesday, August 07, 2001 12:01 PM To: Multiple recipients of list ORACLE-L I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when developing a procedure/package in Procedure Builder under program units, and then dragging it down to the bottom as user1 procedures, an error stating 'insufficient privileges on owner1.tablename' is received. Any ideas?? I have researched the 'grant execute on procedure' privilege but I don't see why I would need to do this for the table owner. My understanding of this privilege is to grant another user access to the procedure and maintain security in this way, instead of having to grant access to each user individually. Laura -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce 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 Bug #1311597
Ethan, I have 8.1.7 on AIX 4.3.3. Don't have 8.1.6.x anymore. I have used exp/imp extensively with the 8.1.7.0 database with no problems. However, we do have the APAR applied that Anita mentioned. You can check if the APAR is applied or not using the following command: /usr/sbin/instfix -i | grep IY15138 HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: A. Bardeen [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 10:28 AM To: Multiple recipients of list ORACLE-L Subject: Re: Oracle Bug #1311597 Ethan, This is not an Oracle bug, but an AIX bug. The Oracle patch for this bug was merely a workaround until IBM released an APAR with the fix. You need the fix for IBM's lio_listio() problem (APAR IY15138). The fix is part of collective fix PTF U473812 (there may be a newer APAR out there that includes this). HTH, -- Anita --- Post, Ethan [EMAIL PROTECTED] wrote: I have run into this one on an 8.1.6 database AIX 4.3.3. I know there is an AIX patch but I am not the admin and may need a quicker solution to get async io back up. Anyone know if this still exist on 8.1.7.x for AIX 4.3.3.0? Thanks, Ethan http://www.geocities.com/epost1 -- 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: how to stop a killed session bothering me ?
gee, I thought it was pay Oracle now AND pay Oracle later :) From: Page, Bruce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: how to stop a killed session bothering me ? Date: Tue, 07 Aug 2001 07:16:08 -0800 Pay Oracle now or pay Oracle later If you did a shutdown abort, wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce 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/intl.asp -- 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).
Re: OT, but maybe not
Dick, that's me. I'm working on the Defense Civilian Personell System - distinct from the military personell system. This is the first I've heard of them choosing Peopleslop, although its no worse than Oracle GHR. My guess, knowing how the guvm'nt works, is that this is a case of different toys in different sandboxes. It does seem wasteful, but then the guv does not have a profit motive... Scott Shafer San Antonio, TX [EMAIL PROTECTED] wrote: I know, sorry I've gotten an Alzheimer moment here, but there is someone on the list working with my old employer, the USAF, on Oracle HR I do believe. I'd like to ask that individual if he/she 'd like to comment on the following: Defense Department to use PeopleSoft for payroll, HR The U.S. Department of Defense has hired PeopleSoft Inc. to provide a new human resources and payroll software system for its 3.1 million military personnel around the world. http://computerworld.com/nlt/1%2C3590%2CNAV47_STO62850_NLTPM%2C00.html Seems to me that if they spent a pile of on Oracle's stuff why on earth would one spend additional to implement a different one? Dick Goulet _ 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: Scott Shafer 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 Mode......how to choose the right one?
Hi there, Unfortunately you can't just throw things like FIRST_ROWS at a select statement to make it run faster. The person who wrote the statement should have taken into account such things as: a) Size of tables, ordering, which is the driving table b) Indexes, are the being used, running statements through explain plan will show you where the bottlenecks are...failing that TKPROF will identify potential problem areas with your database. c) Size of queries, joins etc. Too many developers do not write code to be efficient, as long as it returns the correct values it doesn't matter whether it takes 2 minutes or 2 hours... I've spent a number of hours/days/weeks/months tidying up poorly optimised code, it's an absolute nightmare for the DBAs and it doesn't look good on the developers. Cheers, Kev. (a cheesed off developer...not a DBA!) __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 07 August 2001 17:06 To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Thomas, Kevin 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: Privileges
Laura, You need to do the grants directly to the user that is creating the procedure/package. Major pain. I didn't believe the developers when they told me that, but after adequate testing I realized they were right. Roles are still good for managing security of the rest of the db users, it's just managing the developers that is a pain because of this. Have fun. Stephen Andert [EMAIL PROTECTED] 08/07/01 09:00AM I have granted 'all' to a table owned by owner1 to a role. I granted this role to user1. User1 can access this table via SQL*Plus and Developer. However, when developing a procedure/package in Procedure Builder under program units, and then dragging it down to the bottom as user1 procedures, an error stating 'insufficient privileges on owner1.tablename' is received. Any ideas?? I have researched the 'grant execute on procedure' privilege but I don't see why I would need to do this for the table owner. My understanding of this privilege is to grant another user access to the procedure and maintain security in this way, instead of having to grant access to each user individually. Laura
RE: Code Red
Read http://aris.securityfocus.com/alerts/codered2/010805-Analysis-CodeRedII.pdf http://aris.securityfocus.com/alerts/codered2/010805-Analysis-CodeRedII.pdf 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: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Subject:Code Red So does anyone know how to get rid of the virus if you got it? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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). -- 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).
Re: GAD! Access to Oracle sql conversion question
That's the ignosecond right after you press send. RBG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, August 07, 2001 11:22 AM It always amazes me how 20 seconds after I post a question to a newsgroup for all to see that I find a solution that answers! Thanks anyway for the bandwidth... -- Original Message -- Reply-To: [EMAIL PROTECTED] Date: Tue, 07 Aug 2001 05:55:23 -0800 Oracle version 7.3.2 Access Sql that works SELECT FIRST -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnston, Steve 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: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Weird -904 Problem
Hi, I got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. I get the following error: EXP-8: ORACLE error 904 encounteredORA-00904: invalid column nameEXP-0: Export terminated unsuccessfully. No idea why this happened?I am not sure if this is connected to the 904 mentioned here. Rgds, Jyoti From: Christian Trassens <[EMAIL PROTECTED]> Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Subject: Re: Weird -904 Problem Date: Tue, 07 Aug 2001 06:06:26 -0800 Do you create the table with any strange symbol or in lowercase or mixing lower and upper or within spaces..?, As f.e.: create table weird ( "Weird Field" NUMBER ); Regards. --- "Carle, William T (Bill), NLCIO" <[EMAIL PROTECTED]> wrote: Howdy, I had an interesting situation today. The application was trying to insert rows into a table and was getting a -904 error for invalid column. The actual problem was that the tablespace containing the indexes was full and the index was unable to extend. That was in the alert log. However, when doing a tkprof on their sql statements, it showed every sql statement getting a -904. It doesn't seem like it should do that. Has anyone seen this before? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), NLCIO 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Jyoti N 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: Code Red
The worm is just memory resident, so a reboot should get rid of it, BUT without the patch, you'll get it right back. The problem for the new version is it deposits a trojan backdoor on your server. Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus scanners are releasing versions also. Check with your anti-virus site. -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Code Red So does anyone know how to get rid of the virus if you got it? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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 Mode......how to choose the right one?
I agree with you Kevin, but we have to live with developers, and here (I am sure it happens everywhere) they blame almost all performance problems to the DBA and most of us, DBA's, know that their sql code is the first thing they should look at... I know that the code of the application that is running here is pretty deficient, and the worst part is that it was purchased like that and developers here don't like to mess with the original code of the application, so I guess it is up to me... Now punctual comments, a) Size of tables, ordering, which is the driving table Most of the tables are huge, so are their indexes b) Indexes, are the being used, running statements through explain plan will show you where the bottlenecks are...failing that TKPROF will identify potential problem areas with your database. Indexes are being used, I've traced several processes... c) Size of queries, joins etc. The most important queries are big and do a lot of joins I have told them that... but as I said, they are not willing to make potential changes to the application... Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -Mensaje original- De: Thomas, Kevin [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 07 de Agosto de 2001 10:37 a.m. Para: Multiple recipients of list ORACLE-L Asunto: RE: Optimizer Mode..how to choose the right one? Hi there, Unfortunately you can't just throw things like FIRST_ROWS at a select statement to make it run faster. The person who wrote the statement should have taken into account such things as: a) Size of tables, ordering, which is the driving table b) Indexes, are the being used, running statements through explain plan will show you where the bottlenecks are...failing that TKPROF will identify potential problem areas with your database. c) Size of queries, joins etc. Too many developers do not write code to be efficient, as long as it returns the correct values it doesn't matter whether it takes 2 minutes or 2 hours... I've spent a number of hours/days/weeks/months tidying up poorly optimised code, it's an absolute nightmare for the DBAs and it doesn't look good on the developers. Cheers, Kev. (a cheesed off developer...not a DBA!) __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 07 August 2001 17:06 To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Thomas, Kevin 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
Re: OT : Way OT
My guess is that everyone's got too much time on their hands these days...
The market'll pick up, and the list will soften up.
I hope, on both counts.
Yosi
Kevin Kostyszyn wrote:
Wow!!! You're correct sir!!:)
KK
-Original Message-
Thomas F
Sent: Monday, August 06, 2001 2:42 PM
To: Multiple recipients of list ORACLE-L
Wow!
you can tell we are approaching a full moon. this list is getting a bit
nasty!
Tom Mercadante
{Very Humble} Oracle Certified Professional
--
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Yosi Greenfield
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: Code Red
Yeah, that's what I read. I had applied the patch and I don't have Code red or Code Red II, however it appears that I have something else. It doesn't seem to have worked but it looks like someone tried to deface our website. It's just a message that says f--k the us government and f--k poisonbox, not sure what to do with it yet. KK -Original Message- Brian Sent: Tuesday, August 07, 2001 12:56 PM To: Multiple recipients of list ORACLE-L The worm is just memory resident, so a reboot should get rid of it, BUT without the patch, you'll get it right back. The problem for the new version is it deposits a trojan backdoor on your server. Mcafee dat 4152 is supposed to find the trojan, I'm sure other virus scanners are releasing versions also. Check with your anti-virus site. -Original Message- From: Kevin Kostyszyn [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 11:56 AM To: Multiple recipients of list ORACLE-L Subject: Code Red So does anyone know how to get rid of the virus if you got it? Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Anderson, Brian 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: Optimizer Mode......how to choose the right one?
When using first rows, you force the cost based optimizer, in which the order of the tables does not matter. Order of the tables only matters when using the ORDERED hint or using rbo AND there is a tie ranking. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 07, 2001 12:37 PM To: Multiple recipients of list ORACLE-L Hi there, Unfortunately you can't just throw things like FIRST_ROWS at a select statement to make it run faster. The person who wrote the statement should have taken into account such things as: a) Size of tables, ordering, which is the driving table b) Indexes, are the being used, running statements through explain plan will show you where the bottlenecks are...failing that TKPROF will identify potential problem areas with your database. c) Size of queries, joins etc. Too many developers do not write code to be efficient, as long as it returns the correct values it doesn't matter whether it takes 2 minutes or 2 hours... I've spent a number of hours/days/weeks/months tidying up poorly optimised code, it's an absolute nightmare for the DBAs and it doesn't look good on the developers. Cheers, Kev. (a cheesed off developer...not a DBA!) __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 07 August 2001 17:06 To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Thomas, Kevin 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
RE: Optimizer Mode......how to choose the right one?
If you are using 8.x + I would recommend looking at Statspack over utilbstat. It comes installed with 816+ and available for download on 8.x+. It is fairly easy to configure and a great utility. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 07, 2001 12:48 PM To: Multiple recipients of list ORACLE-L 1) How often do you rebuild your indexes? 2) What does your utlb and utle report say? 3) Have you done any explain plans or tkprofs on your sql code? Sql may not be using indexes. 4) Try using a hint of rule on your sql code to see if it runs better that way 5) Do you have a lot of chaining going on. 6) Do you have enough rollback segments and are they sized right 7) what are the size of your redo logs and how often are you check pointing? 8) Do you have auditing turned on.? A lot of tracing going on? Best would be to run utlb and utle reports. I would send you to www.perfmon.com to get a quick analysis but this site has been under construction for several days and I don't know of another site that will analyze this reports. Someone else may know of another site that analyzes utlb/utle reports. kathy -Original Message- Sent: Tuesday, August 07, 2001 9:06 AM To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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). Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret 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
RE: Optimizer Mode......how to choose the right one?
What type of transactions are running, update, insert, delete, or select? -Original Message- Sent: Tuesday, August 07, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Take a look at index_caching parameters, they can make a big difference when using cost mode, Oracle's settings are very poor. I have a good article on my site www.vampired.net under Performance which is a great discussion about making the CBO work for you and not against you. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 07, 2001 12:06 PM To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Wong, Bing 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 Mode......how to choose the right one?
thanks Christopher, I'll take a look and let you know, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -Mensaje original- De: Christopher Spence [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 07 de Agosto de 2001 10:56 a.m. Para: Multiple recipients of list ORACLE-L Asunto: RE: Optimizer Mode..how to choose the right one? Take a look at index_caching parameters, they can make a big difference when using cost mode, Oracle's settings are very poor. I have a good article on my site www.vampired.net under Performance which is a great discussion about making the CBO work for you and not against you. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 07, 2001 12:06 PM To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Veronica Levin 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 Mode......how to choose the right one?
If the transaction having problem is a SELECT statement and does SORT, then I think the sort_area_size is too small. Can you show us the SQL? -Original Message- Sent: Tuesday, August 07, 2001 9:37 AM To: Multiple recipients of list ORACLE-L Hi there, Unfortunately you can't just throw things like FIRST_ROWS at a select statement to make it run faster. The person who wrote the statement should have taken into account such things as: a) Size of tables, ordering, which is the driving table b) Indexes, are the being used, running statements through explain plan will show you where the bottlenecks are...failing that TKPROF will identify potential problem areas with your database. c) Size of queries, joins etc. Too many developers do not write code to be efficient, as long as it returns the correct values it doesn't matter whether it takes 2 minutes or 2 hours... I've spent a number of hours/days/weeks/months tidying up poorly optimised code, it's an absolute nightmare for the DBAs and it doesn't look good on the developers. Cheers, Kev. (a cheesed off developer...not a DBA!) __ Kevin Thomas Technical Analyst Deregulation Services Calanais Ltd. Tel: 0141 568 2314 Fax: 0141 568 2366 http://www.calanais.com -Original Message- Sent: 07 August 2001 17:06 To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Thomas, Kevin 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: Wong, Bing 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).
negative value for buffer cache hit ratio
Dear gurus ! I have a negative value for buffer cache hit ratio in my DB which is up for some 4 months . Any ideas why ? Thanks in advance. SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) / 2 (SUM(DECODE(a.name,'consistent gets',value,0)) + 3 SUM(DECODE(a.name,'db block gets',value,0) * 100 buffer cache hit ratio 4 FROM v$sysstat a; buffer cache hit ratio -- -52.99284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
multimaster replication
Dear gurus ! Finally , they caught me ;-( I need to implement multimaster replication (asynchronous) among 2 databases. A couple of general questions before i start : - Is it a must for the 2 DBs to be of the same version (release) ? - Is it a must for the 2 DBs to run on the same O/S, hardware etc ... ? - Do U have to replicate among 2 schemas with the same names ? - Are there any general bugs / issues ? Something to be aware of ? - And , the most important , i'd be very happy if u , gurus , could send me some scripts , how-tos , manuals , articles , your thoughts - simply anything related to advanced replication. Many thanks in advance. Andrey. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
PARTITION attache to SYNONYM
Hi All, Wondering if anyone has seen anything like this. I have filed a TAR. When adding next month's partition to a table a synonym was used accidently. However, the partition was created and shows up in dba_tab_partitions. However, I cannot modify of drop the partition. ALTER TABLE synonym_name drop PARTITION partition_name; returns no such table ALTER TABLE table_name drop PARTITION partition_name; returns no such partition. I have built another structure to hold the data but does anyone know the consequences if I dorp the ysnonym. TIA Dave -- Dave Morgan DBA, Cybersurf Office: 403 777 2000 ext 284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Dave Morgan 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).
Installing Oracle 9i
Friends : I am installing the database Oracle 9i. And it have suggested a parameter value 100mb for redo log file. I am confused with this value, i think it is too big. The blocksize is 8192 Connections simultaneous is 100 Where am I doing any mistake ? Eriovaldo [EMAIL PROTECTED] _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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 Mode......how to choose the right one?
Most of the transactions are select, and updates.. Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -Mensaje original- De: Wong, Bing [mailto:[EMAIL PROTECTED]] Enviado el: Martes, 07 de Agosto de 2001 11:43 a.m. Para: Multiple recipients of list ORACLE-L Asunto: RE: Optimizer Mode..how to choose the right one? What type of transactions are running, update, insert, delete, or select? -Original Message- Sent: Tuesday, August 07, 2001 9:56 AM To: Multiple recipients of list ORACLE-L Take a look at index_caching parameters, they can make a big difference when using cost mode, Oracle's settings are very poor. I have a good article on my site www.vampired.net under Performance which is a great discussion about making the CBO work for you and not against you. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Tuesday, August 07, 2001 12:06 PM To: Multiple recipients of list ORACLE-L Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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: Wong, Bing 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: Veronica Levin 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:Help needed
There are two things you can do: 1) turn Oracle auditing on for ddl statements to see who's doing them. 2) if you know the username where things are being messed up, you could revoke the create session privilege find out who screams. I'd also look at that table and see who has index privileges on it or if anyone has create, delete, or alter any index privileges. You might check as to who has the dba role. Revoking it may bring the culprit out of hiding. Dick Goulet Reply Separator Author: Deewaker G.V. [EMAIL PROTECTED] Date: 8/7/2001 12:00 AM HI DBA Guru's It has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this.. The pc name who was connected. The time when he/she executed the process What was the command given to execute the same.. Pls... Guruji's help me... with warm regards, Deewaker G. V. Baazee.com India Pvt. Ltd. *: 4611323 Extn: 216 Fax : 4611324 Deewaker G.V..vcf !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 3.2//EN HTML HEAD META HTTP-EQUIV=Content-Type CONTENT=text/html; charset=us-ascii META NAME=Generator CONTENT=MS Exchange Server version 5.5.2653.12 TITLEHelp needed /TITLE /HEAD BODY PFONT COLOR=#FF FACE=Arial NarrowHI DBA Guru's/FONT /P PFONT COLOR=#FF FACE=Arial NarrowIt has been a painful process for me everytime when I change the password of the user in ORACLE.. The reason is simple Some one is trying to play with the tables and change the INDEXS... delete the synonyn... and so on... I just want to know how do I come to know either or all of this../FONT/P PFONT COLOR=#FF FACE=Arial NarrowThe pc name who was connected./FONT BRFONT COLOR=#FF FACE=Arial NarrowThe time when he/she executed the process/FONT BRFONT COLOR=#FF FACE=Arial NarrowWhat was the command given to execute the same../FONT /P PFONT COLOR=#FF FACE=Arial NarrowPls... Guruji's help me.../FONT /P PFONT COLOR=#FF FACE=Book Antiquawith warm regards,/FONT /P PFONT COLOR=#FF FACE=Book AntiquaDeewaker G. V./FONT /P PFONT COLOR=#FF FACE=Book AntiquaBaazee.com India Pvt. Ltd./FONT BRFONT COLOR=#FF FACE=Wingdings(/FONTFONT COLOR=#FF FACE=Book Antiqua: 4611323 Extn: 216/FONT BRFONT COLOR=#FF FACE=Book AntiquaFax : 4611324/FONT /P PFONT FACE=Arial SIZE=2 COLOR=#00 lt;lt;Deewaker G.V..vcfgt;gt; /FONT /P /BODY /HTML Deewaker G.V..vcf
RE: negative value for buffer cache hit ratio
Try this more accurate query:
select to_char(100 * misses / (hits + misses), '9990.00') || '%' miss_rate
from ( select total_waits misses
from sys.v_$system_event
where event = 'db file sequential read' ),
( select sum(dbbget + conget - pread) hits
from sys.x_$kcbwds
where inst_id = userenv('Instance') )
/
Also, send the actual values if this query still leads to similar results.
The difference here is it takes in account of direct writes.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-Original Message-
Sent: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.
SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
2 (SUM(DECODE(a.name,'consistent gets',value,0)) +
3 SUM(DECODE(a.name,'db block gets',value,0) * 100 buffer cache hit
ratio
4 FROM v$sysstat a;
buffer cache hit ratio
--
-52.99284
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
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: negative value for buffer cache hit ratio
Andrey, I am not into cache hit ratios, but got curious about your negative value. So I casually searched Metalink for 'negative value for hit ratio'. And got a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread. You may want to check it out, there seems to be a new formula for hit ratio computation in 8i/9i. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: negative value for buffer cache hit ratio Dear gurus ! I have a negative value for buffer cache hit ratio in my DB which is up for some 4 months . Any ideas why ? Thanks in advance. SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) / 2 (SUM(DECODE(a.name,'consistent gets',value,0)) + 3 SUM(DECODE(a.name,'db block gets',value,0) * 100 buffer cache hit ratio 4 FROM v$sysstat a; buffer cache hit ratio -- -52.99284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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).
No Subject
SET ORACLE-L MAIL -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ingrid Diefenbach 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).
free up datafile space problem ???
Hi all, I have a data file of 2G and the free bytes is 1,413,079, the used bytes is only 683,829. I like to resize it. When I issue: alter database datafile '/orafs02/oradata/PV_A0725/ld_data05.dbf' resize 1000M, I got: ERROR at line 1: ORA-03297: file contains used data beyond requested RESIZE value But apparently, the file does NOT contain data beyond 1000M. Am I missing something? Thank you. Janet __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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: negative value for buffer cache hit ratio
1.- Go to this link of Steve Adam's site: http://www.ixora.com.au/scripts/cache.htm You gonna find a script to estimate the miss rate of the buffer cache based on the assumptions that certain operations are not well compute by statistics as direct path operations. 2.- From 8.X you should rely on v$buffer_pool_statistics from the script $ORACLE_HOME/rdbms/admin/catperf.sql accounting on the several pools you could have. 3.- Remember that even on 8.X, when the database has been opened for a long time and have had a lot of transactions, the value of statistics gets so big that reaches the maximum value and then begins from 0 again. This usually happens with 7.X. Regards. --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Andrey, I am not into cache hit ratios, but got curious about your negative value. So I casually searched Metalink for 'negative value for hit ratio'. And got a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread. You may want to check it out, there seems to be a new formula for hit ratio computation in 8i/9i. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject:negative value for buffer cache hit ratio Dear gurus ! I have a negative value for buffer cache hit ratio in my DB which is up for some 4 months . Any ideas why ? Thanks in advance. SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) / 2 (SUM(DECODE(a.name,'consistent gets',value,0)) + 3 SUM(DECODE(a.name,'db block gets',value,0) * 100 buffer cache hit ratio 4 FROM v$sysstat a; buffer cache hit ratio -- -52.99284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: Installing Oracle 9i
100mb for redo log file is not that big? Not big if your environment is heavy in OLTP. -Original Message- Sent: Tuesday, August 07, 2001 10:58 AM To: Multiple recipients of list ORACLE-L Friends : I am installing the database Oracle 9i. And it have suggested a parameter value 100mb for redo log file. I am confused with this value, i think it is too big. The blocksize is 8192 Connections simultaneous is 100 Where am I doing any mistake ? Eriovaldo [EMAIL PROTECTED] _ Seja avisado de novas mensagens do Hotmail e use o comunique-se com seus amigos com o MSN Messenger em http://messenger.msn.com.br -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eca Eca 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: Wong, Bing 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: ORA-00600 on Production DB - Need advice/Still Searching
What about TWO_TASK env. variable? Is it set? Alex Hillman -Original Message- Sent: Tuesday, August 07, 2001 11:16 AM To: Multiple recipients of list ORACLE-L David, What is your setting for LARGE_POOL and have you tried decreasing it? Also, this is frequently caused by 3rd party software, such as AutoSecure, that does additional authorization. Also check to ensure that user oracle (or whatever user you're using to start the db) has not been removed from the dba group in the /etc/group file. HTH, -- Anita --- [EMAIL PROTECTED] wrote: Denny/Kirti, Thanks for the replies. The bug finder is kinda cool. I'd already been through about one third of the entries it found, but I looked through the rest. No real help. Can't log in to shut down the DB. Whether I try svrmgrl or sqlplus, I get asked for a password or told I have insufficient privileges. There aren't any additional trace files. Here's the output of the ulimit -a command: qe2n1: /u014/oradata/ifastrn/usr/bin/ulimit -a time(seconds)unlimited file(blocks) unlimited data(kbytes) 196608 stack(kbytes)196608 memory(kbytes) unlimited coredump(blocks) 4194303 nofiles(descriptors) 2048 kmtune shows me the following: maxssiz 0X0C00 maxssiz_64bit 0x4000 swapmem_on 0 dbc_max_pct 50 Total physical and swap meory (from top) is: Memory: 364536K (264244K) real, 423812K (340152K) virtual, 6453348K free David A. Barbour Oracle DBA, OCP AISD 512-414-1002 Denny Koovakattu [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: ORA-00600 on Production DB - Need advice .tenet.edu 08/06/2001 12:44 PM Hi David, To get the proper output for ulimit, use /usr/bin/ulimit -a or sh ulimit -a Also the following information should help in trying to debug the problem. 1. Total Physical Memory 2. Total Disk Swap Configured 3. The output of kmtune or the kernel parameters maxdsiz, maxdsiz_64bit, swapmem_on, dbc_max_pct 4. The output of ulimit (Use /usr/bin/ulimit -a ) Have you tried restarting the database ? Regards, Denny [EMAIL PROTECTED] wrote: Mondays, gotta love em, they make Fridays worth the wait. I've got Ta production database (8.1.7, HP-UX 11.0 - 64 bit) that started throwing an ora-600 when users try to log in. I've created a TAR (3 hours ago), but haven't gotten any response. Here's the error: ERROR: ORA-00600: internal error code, arguments: [kzckini: nzdsi_i], [28750], [], [], [], [], [], [ Metalink has a couple of messages stating that this is an OS problem related to the ulimit size, availability of virtual memory, and the ability to create a pga. Suggested remedy is to increase the ulimit. My SA has dismissed this as a cause. I've knocked all the users off, but still can't log in. When I run ulimit I get the following: qe2n1: /u001/app/oracle/product/8.1.7/dbsulimit 4194303 Any suggestions? David A. Barbour Oracle DBA, OCP AISD 512-414-1002 _ 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: 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
Re: Weird -904 Problem
Probably you need to run the catexp.sql again. This is 100% if you applied a patch. Even if you don't try running the catexp.sql again. Also the error during export depends on where you have had it. I mean whether it has been in one of your tables or in sys/system objects. Regards. --- Jyoti N [EMAIL PROTECTED] wrote: HR htmldiv style='background-color:'PBRBRHi,/P PI got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. /P PI get the following error:/P PEXP-8: ORACLE error 904 encounteredBRORA-00904: invalid column nameBREXP-0: Export terminated unsuccessfully./P PNo idea why this happened?I am not sure if this is connected to the 904 mentioned here./P PRgds,/P PJyoti/P PBRBRBRnbsp;/P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN DIV/DIV DIV/DIV DIV/DIV META content=MSHTML 5.50.4134.600 name=GENERATOR DIV/DIV DIV/DIV DIV/DIV DIVnbsp;/DIV DIV/DIV DIV/DIV DIV/DIV DIV/DIVgt;From: Christian Trassens [EMAIL PROTECTED] DIV/DIVgt;Reply-To: [EMAIL PROTECTED] DIV/DIVgt;To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: Weird -904 Problem DIV/DIVgt;Date: Tue, 07 Aug 2001 06:06:26 -0800 DIV/DIVgt; DIV/DIVgt;Do you create the table with any strange symbol or in DIV/DIVgt;lowercase or mixing lower and upper or within DIV/DIVgt;spaces..?, As f.e.: DIV/DIVgt; DIV/DIVgt;create table weird ( Weird Field NUMBER ); DIV/DIVgt; DIV/DIVgt;Regards. DIV/DIVgt; DIV/DIVgt;--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] DIV/DIVgt;wrote: DIV/DIVgt; gt; Howdy, DIV/DIVgt; gt; DIV/DIVgt; gt; I had an interesting situation today. The DIV/DIVgt; gt; application was trying to DIV/DIVgt; gt; insert rows into a table and was getting a -904 DIV/DIVgt; gt; error for invalid column. DIV/DIVgt; gt; The actual problem was that the tablespace DIV/DIVgt; gt; containing the indexes was full DIV/DIVgt; gt; and the index was unable to extend. That was in the DIV/DIVgt; gt; alert log. However, when DIV/DIVgt; gt; doing a tkprof on their sql statements, it showed DIV/DIVgt; gt; every sql statement DIV/DIVgt; gt; getting a -904. It doesn't seem like it should do DIV/DIVgt; gt; that. Has anyone seen this DIV/DIVgt; gt; before? DIV/DIVgt; gt; DIV/DIVgt; gt; DIV/DIVgt; gt; Bill Carle DIV/DIVgt; gt; ATamp;T DIV/DIVgt; gt; Database Administrator DIV/DIVgt; gt; 816-995-3922 DIV/DIVgt; gt; [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; -- DIV/DIVgt; gt; Please see the official ORACLE-L FAQ: DIV/DIVgt; gt; http://www.orafaq.com DIV/DIVgt; gt; -- DIV/DIVgt; gt; Author: Carle, William T (Bill), NLCIO DIV/DIVgt; gt; INET: [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; Fat City Network Services -- (858) 538-5051 FAX: DIV/DIVgt; gt; (858) 538-5051 DIV/DIVgt; gt; San Diego, California -- Public Internet DIV/DIVgt; gt; access / Mailing Lists DIV/DIVgt; gt; DIV/DIVgt; DIV/DIVgt; gt; To REMOVE yourself from this mailing list, send an DIV/DIVgt; gt; E-Mail message DIV/DIVgt; gt; to: [EMAIL PROTECTED] (note EXACT spelling of DIV/DIVgt; gt; 'ListGuru') and in DIV/DIVgt; gt; the message BODY, include a line containing: UNSUB DIV/DIVgt; gt; ORACLE-L DIV/DIVgt; gt; (or the name of mailing list you want to be removed DIV/DIVgt; gt; from). You may DIV/DIVgt; gt; also send the HELP command for other information DIV/DIVgt; gt; (like subscribing). DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;= DIV/DIVgt;Eng. Christian Trassens DIV/DIVgt;Senior DBA DIV/DIVgt;Systems Engineer DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;Phone : 541149816062 DIV/DIVgt; DIV/DIVgt;__ DIV/DIVgt;Do You Yahoo!? DIV/DIVgt;Make international calls for as low as $.04/minute with Yahoo! Messenger DIV/DIVgt;http://phonecard.yahoo.com/ DIV/DIVgt;-- DIV/DIVgt;Please see the official ORACLE-L FAQ: http://www.orafaq.com DIV/DIVgt;-- DIV/DIVgt;Author: Christian Trassens DIV/DIVgt; INET: [EMAIL PROTECTED] DIV/DIVgt; DIV/DIVgt;Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 DIV/DIVgt;San Diego, California -- Public Internet access / Mailing Lists DIV/DIVgt; DIV/DIVgt;To REMOVE yourself from this mailing list, send an E-Mail message DIV/DIVgt;to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in DIV/DIVgt;the message BODY, include a line containing: UNSUB ORACLE-L DIV/DIVgt;(or the name of mailing list you want to be removed from). You may DIV/DIVgt;also send the HELP command for other information (like subscribing). DIV/DIV/divbr clear=allhrGet your FREE download of MSN Explorer at a href='http://go.msn.com/bql/hmtag_itl_EN.asp'http://explorer.msn.com/abr/html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City
Re: Weird -904 Problem
Probably you need to run the catexp.sql again. This is 100% if you applied a patch. Even if you don't try running the catexp.sql again. Also the error during export depends on where you have had it. I mean whether it has been in one of your tables or in sys/system objects. Regards. --- Jyoti N [EMAIL PROTECTED] wrote: HR htmldiv style='background-color:'PBRBRHi,/P PI got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. /P PI get the following error:/P PEXP-8: ORACLE error 904 encounteredBRORA-00904: invalid column nameBREXP-0: Export terminated unsuccessfully./P PNo idea why this happened?I am not sure if this is connected to the 904 mentioned here./P PRgds,/P PJyoti/P PBRBRBRnbsp;/P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN DIV/DIV DIV/DIV DIV/DIV META content=MSHTML 5.50.4134.600 name=GENERATOR DIV/DIV DIV/DIV DIV/DIV DIVnbsp;/DIV DIV/DIV DIV/DIV DIV/DIV DIV/DIVgt;From: Christian Trassens [EMAIL PROTECTED] DIV/DIVgt;Reply-To: [EMAIL PROTECTED] DIV/DIVgt;To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: Weird -904 Problem DIV/DIVgt;Date: Tue, 07 Aug 2001 06:06:26 -0800 DIV/DIVgt; DIV/DIVgt;Do you create the table with any strange symbol or in DIV/DIVgt;lowercase or mixing lower and upper or within DIV/DIVgt;spaces..?, As f.e.: DIV/DIVgt; DIV/DIVgt;create table weird ( Weird Field NUMBER ); DIV/DIVgt; DIV/DIVgt;Regards. DIV/DIVgt; DIV/DIVgt;--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] DIV/DIVgt;wrote: DIV/DIVgt; gt; Howdy, DIV/DIVgt; gt; DIV/DIVgt; gt; I had an interesting situation today. The DIV/DIVgt; gt; application was trying to DIV/DIVgt; gt; insert rows into a table and was getting a -904 DIV/DIVgt; gt; error for invalid column. DIV/DIVgt; gt; The actual problem was that the tablespace DIV/DIVgt; gt; containing the indexes was full DIV/DIVgt; gt; and the index was unable to extend. That was in the DIV/DIVgt; gt; alert log. However, when DIV/DIVgt; gt; doing a tkprof on their sql statements, it showed DIV/DIVgt; gt; every sql statement DIV/DIVgt; gt; getting a -904. It doesn't seem like it should do DIV/DIVgt; gt; that. Has anyone seen this DIV/DIVgt; gt; before? DIV/DIVgt; gt; DIV/DIVgt; gt; DIV/DIVgt; gt; Bill Carle DIV/DIVgt; gt; ATamp;T DIV/DIVgt; gt; Database Administrator DIV/DIVgt; gt; 816-995-3922 DIV/DIVgt; gt; [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; -- DIV/DIVgt; gt; Please see the official ORACLE-L FAQ: DIV/DIVgt; gt; http://www.orafaq.com DIV/DIVgt; gt; -- DIV/DIVgt; gt; Author: Carle, William T (Bill), NLCIO DIV/DIVgt; gt; INET: [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; Fat City Network Services -- (858) 538-5051 FAX: DIV/DIVgt; gt; (858) 538-5051 DIV/DIVgt; gt; San Diego, California -- Public Internet DIV/DIVgt; gt; access / Mailing Lists DIV/DIVgt; gt; DIV/DIVgt; DIV/DIVgt; gt; To REMOVE yourself from this mailing list, send an DIV/DIVgt; gt; E-Mail message DIV/DIVgt; gt; to: [EMAIL PROTECTED] (note EXACT spelling of DIV/DIVgt; gt; 'ListGuru') and in DIV/DIVgt; gt; the message BODY, include a line containing: UNSUB DIV/DIVgt; gt; ORACLE-L DIV/DIVgt; gt; (or the name of mailing list you want to be removed DIV/DIVgt; gt; from). You may DIV/DIVgt; gt; also send the HELP command for other information DIV/DIVgt; gt; (like subscribing). DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;= DIV/DIVgt;Eng. Christian Trassens DIV/DIVgt;Senior DBA DIV/DIVgt;Systems Engineer DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;Phone : 541149816062 DIV/DIVgt; DIV/DIVgt;__ DIV/DIVgt;Do You Yahoo!? DIV/DIVgt;Make international calls for as low as $.04/minute with Yahoo! Messenger DIV/DIVgt;http://phonecard.yahoo.com/ DIV/DIVgt;-- DIV/DIVgt;Please see the official ORACLE-L FAQ: http://www.orafaq.com DIV/DIVgt;-- DIV/DIVgt;Author: Christian Trassens DIV/DIVgt; INET: [EMAIL PROTECTED] DIV/DIVgt; DIV/DIVgt;Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 DIV/DIVgt;San Diego, California -- Public Internet access / Mailing Lists DIV/DIVgt; DIV/DIVgt;To REMOVE yourself from this mailing list, send an E-Mail message DIV/DIVgt;to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in DIV/DIVgt;the message BODY, include a line containing: UNSUB ORACLE-L DIV/DIVgt;(or the name of mailing list you want to be removed from). You may DIV/DIVgt;also send the HELP command for other information (like subscribing). DIV/DIV/divbr clear=allhrGet your FREE download of MSN Explorer at a href='http://go.msn.com/bql/hmtag_itl_EN.asp'http://explorer.msn.com/abr/html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City
Re: free up datafile space problem ???
its like the high water mark in a table but its at the datafile side instead. if any block in the datafile has ever had data in it, you can't shrink it below that point. hth, joe [EMAIL PROTECTED] 08/07/01 02:40PM Hi all,I have a data file of 2G and the free bytes is 1,413,079, the used bytes is only 683,829. I like toresize it. When I issue:alter database datafile'/orafs02/oradata/PV_A0725/ld_data05.dbf' resize1000M, I got:ERROR at line 1:ORA-03297: file contains used data beyond requestedRESIZE valueBut apparently, the file does NOT contain data beyond1000M. Am I missing something?Thank you.Janet__Do You Yahoo!?Make international calls for as low as $.04/minute with Yahoo! Messengerhttp://phonecard.yahoo.com/-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Janet Linsy INET: [EMAIL PROTECTED]Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051San Diego, California -- Public Internet access / Mailing ListsTo REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Installing Oracle 9i
For us, on 8.1.7.1 with 90MB redologs and about 120-150 connections (100-150 avg TPM), we get log switches every two hours during the day and about every 10-15 minutes during the nightly processing. I guess ideal is to switch every 30 minutes or so, but we needed to compromise because of the nightly batches, so I went with a 90MB redo. Good luck! Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- Sent: Tuesday, August 07, 2001 13:49 To: Multiple recipients of list ORACLE-L 100mb for redo log file is not that big? Not big if your environment is heavy in OLTP. -Original Message- Sent: Tuesday, August 07, 2001 10:58 AM To: Multiple recipients of list ORACLE-L Friends : I am installing the database Oracle 9i. And it have suggested a parameter value 100mb for redo log file. I am confused with this value, i think it is too big. The blocksize is 8192 Connections simultaneous is 100 Where am I doing any mistake ? Eriovaldo [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich 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: Code Red
Update your virus checking software. Patch your software and your OS as far as you can. Re. NT use PatchWork as well ( http://grc.com/pw/patchwork.htm http://grc.com/pw/patchwork.htm ), it catches things the Microsoft Windows Update seems to overlook. You may want to get a trojan detector like tds-3 to catch trojans like CodeRed II. There are many trojan detectors posted on the 'net. Beware of free ones. Stay clear of anything on servers in countries that do not recognize copyright laws, or who might be actively financing hackers! Sounds obvious but sometimes people don't think about this when they are following links on the Web. Look at where a link leads (bottom status bar if using IE) before you click. You also need something that is current. Anything that hasn't been updated in the last year is probably useless. It seems to me that now we need: A virus / worm checker A trojan horse detector A firewall. Only one component missing, and you could be in trouble. The trouble with code red was that it went through port 80, which is left open by firewalls because that is the port used for HTTP pages (WWW). Closing that would mean no one could access Web pages. So firewalls won't help you re. things like that. You can now go through any ports that are left open, and there is software out there to detect ports that were left open. Life is getting complicated! For trojan detection I like TDS-3 because with some plug-ins, you can send a message right back to the people who are probing your system using a trojan. TDS-3 also scans all the processes running in memory, and it comes with interesting process descriptions for some of those obscure NT services. This is from first glance, I am running the shareware version at home. I have a month to make up my mind and pay up... For home, ZoneAlarm (firewall) is free. I like it because it tells you when programs are trying to access your machine via ports going in, or out. So if a program on your machine wants to access the 'net, you can see which program is trying to do that and you can decide whether to let it do that or not. Sometimes it's hard to decide, though, e.g. distributed COM - should I let that thing send info out of my computer to the 'net? It's a built-in component of Windows, but I don't know. (btw the author says he programs only in assembly language) Re. virus checking F-Prot has a shareware version, that's free as long as you don't mind re-installing it now and again. I am probably going to buy it eventually. I don't know how to compare the effectiveness of these, though. Some are more popular out there but to my mind it doesn't mean that they are ideal, esp. when marketing and mass advertising through the media is involved. I haven't seen any honest reviews of virus checking software, I don't know where to look. I set up ZoneAlarm and TDS-3 on my machine at home and was surprised to see what is going on. With ZoneAlarm you can get the owner for a particular IP range, so you can see who is trying to ping or intrude on your machine. A colleague here says he is on cable modem, and that is even worse than DSL in terms of hacking activity, he showed me a log where he was a target every ten minutes on average for a prolonged period of time. He uses BlackIce Defender. Korean and university servers are the most common that I see in use as launchpads. It doesn't mean that's where the probes and that attacks are coming from though. T1, Cable and DSL users are most at risk, but dial-up clients are vulnerable as well as long as they remain connected. I sent e-mails to some ISPs to complain, but they don't appear to care what people are doing with their net connections, it seems they just want to sell memberships. In many cases they want you to prove that damage was done, someone trying to invade your machine is not illegal. The irony is that if someone ever succeeded, I probably wouldn't have the information I would need to lodge a formal complaint. I gave up trying to get ISPs to clamp down, better to prevent these attempts from succeeding than to try to stop the behaviour. It's easy to become paranoid... 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: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 2:27 PM To: Multiple recipients of list ORACLE-L Subject:RE: Code Red Yeah, that's what I read. I had applied the patch and I don't have Code red or Code Red II, however it appears that I have something else. It doesn't seem to have worked but it looks like someone tried to deface our
Re: Weird -904 Problem
Probably you need to run the catexp.sql again. This is 100% if you applied a patch. Even if you don't try running the catexp.sql again. Also the error during export depends on where you have had it. I mean whether it has been in one of your tables or in sys/system objects. Regards. --- Jyoti N [EMAIL PROTECTED] wrote: HR htmldiv style='background-color:'PBRBRHi,/P PI got a similar problem in my test database while trying to do an export.Opened a tar with Oracle , but not much luck yet. /P PI get the following error:/P PEXP-8: ORACLE error 904 encounteredBRORA-00904: invalid column nameBREXP-0: Export terminated unsuccessfully./P PNo idea why this happened?I am not sure if this is connected to the 904 mentioned here./P PRgds,/P PJyoti/P PBRBRBRnbsp;/P!DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN DIV/DIV DIV/DIV DIV/DIV META content=MSHTML 5.50.4134.600 name=GENERATOR DIV/DIV DIV/DIV DIV/DIV DIVnbsp;/DIV DIV/DIV DIV/DIV DIV/DIV DIV/DIVgt;From: Christian Trassens [EMAIL PROTECTED] DIV/DIVgt;Reply-To: [EMAIL PROTECTED] DIV/DIVgt;To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] DIV/DIVgt;Subject: Re: Weird -904 Problem DIV/DIVgt;Date: Tue, 07 Aug 2001 06:06:26 -0800 DIV/DIVgt; DIV/DIVgt;Do you create the table with any strange symbol or in DIV/DIVgt;lowercase or mixing lower and upper or within DIV/DIVgt;spaces..?, As f.e.: DIV/DIVgt; DIV/DIVgt;create table weird ( Weird Field NUMBER ); DIV/DIVgt; DIV/DIVgt;Regards. DIV/DIVgt; DIV/DIVgt;--- Carle, William T (Bill), NLCIO [EMAIL PROTECTED] DIV/DIVgt;wrote: DIV/DIVgt; gt; Howdy, DIV/DIVgt; gt; DIV/DIVgt; gt; I had an interesting situation today. The DIV/DIVgt; gt; application was trying to DIV/DIVgt; gt; insert rows into a table and was getting a -904 DIV/DIVgt; gt; error for invalid column. DIV/DIVgt; gt; The actual problem was that the tablespace DIV/DIVgt; gt; containing the indexes was full DIV/DIVgt; gt; and the index was unable to extend. That was in the DIV/DIVgt; gt; alert log. However, when DIV/DIVgt; gt; doing a tkprof on their sql statements, it showed DIV/DIVgt; gt; every sql statement DIV/DIVgt; gt; getting a -904. It doesn't seem like it should do DIV/DIVgt; gt; that. Has anyone seen this DIV/DIVgt; gt; before? DIV/DIVgt; gt; DIV/DIVgt; gt; DIV/DIVgt; gt; Bill Carle DIV/DIVgt; gt; ATamp;T DIV/DIVgt; gt; Database Administrator DIV/DIVgt; gt; 816-995-3922 DIV/DIVgt; gt; [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; -- DIV/DIVgt; gt; Please see the official ORACLE-L FAQ: DIV/DIVgt; gt; http://www.orafaq.com DIV/DIVgt; gt; -- DIV/DIVgt; gt; Author: Carle, William T (Bill), NLCIO DIV/DIVgt; gt; INET: [EMAIL PROTECTED] DIV/DIVgt; gt; DIV/DIVgt; gt; Fat City Network Services -- (858) 538-5051 FAX: DIV/DIVgt; gt; (858) 538-5051 DIV/DIVgt; gt; San Diego, California -- Public Internet DIV/DIVgt; gt; access / Mailing Lists DIV/DIVgt; gt; DIV/DIVgt; DIV/DIVgt; gt; To REMOVE yourself from this mailing list, send an DIV/DIVgt; gt; E-Mail message DIV/DIVgt; gt; to: [EMAIL PROTECTED] (note EXACT spelling of DIV/DIVgt; gt; 'ListGuru') and in DIV/DIVgt; gt; the message BODY, include a line containing: UNSUB DIV/DIVgt; gt; ORACLE-L DIV/DIVgt; gt; (or the name of mailing list you want to be removed DIV/DIVgt; gt; from). You may DIV/DIVgt; gt; also send the HELP command for other information DIV/DIVgt; gt; (like subscribing). DIV/DIVgt; DIV/DIVgt; DIV/DIVgt;= DIV/DIVgt;Eng. Christian Trassens DIV/DIVgt;Senior DBA DIV/DIVgt;Systems Engineer DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;[EMAIL PROTECTED] DIV/DIVgt;Phone : 541149816062 DIV/DIVgt; DIV/DIVgt;__ DIV/DIVgt;Do You Yahoo!? DIV/DIVgt;Make international calls for as low as $.04/minute with Yahoo! Messenger DIV/DIVgt;http://phonecard.yahoo.com/ DIV/DIVgt;-- DIV/DIVgt;Please see the official ORACLE-L FAQ: http://www.orafaq.com DIV/DIVgt;-- DIV/DIVgt;Author: Christian Trassens DIV/DIVgt; INET: [EMAIL PROTECTED] DIV/DIVgt; DIV/DIVgt;Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 DIV/DIVgt;San Diego, California -- Public Internet access / Mailing Lists DIV/DIVgt; DIV/DIVgt;To REMOVE yourself from this mailing list, send an E-Mail message DIV/DIVgt;to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in DIV/DIVgt;the message BODY, include a line containing: UNSUB ORACLE-L DIV/DIVgt;(or the name of mailing list you want to be removed from). You may DIV/DIVgt;also send the HELP command for other information (like subscribing). DIV/DIV/divbr clear=allhrGet your FREE download of MSN Explorer at a href='http://go.msn.com/bql/hmtag_itl_EN.asp'http://explorer.msn.com/abr/html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jyoti N INET: [EMAIL PROTECTED] Fat City
RE: how to stop a killed session bothering me ?
MaybeHowever in my experience a shutdown abort and startup was most of the times quickier than shutdown immediate and wait for the unfinished rollback. Remember that one thing is recover because of the abort and another thing is to rollback managed by the parameter cleanup_rollback_entries and in the wakeup frecuency of PMON. Even though pay now or pay later sometimes is true. :) --- Rachel Carmichael [EMAIL PROTECTED] wrote: gee, I thought it was pay Oracle now AND pay Oracle later :) From: Page, Bruce [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: RE: how to stop a killed session bothering me ? Date: Tue, 07 Aug 2001 07:16:08 -0800 Pay Oracle now or pay Oracle later If you did a shutdown abort, wouldn't you still have to wait for the rollback to happen during instance recovery on the startup? I've never tried this - I usually just suffer through the rollback. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Page, Bruce 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/intl.asp -- 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: completely off-topic question... [Tintin rules!!!!!!!!]
[via digest] RE: completely off-topic question... On Saturday 04 August 2001 16:25, Rachel Carmichael wrote: putting on armor in preparation for being stoned as a heretic here I am NOT a fan of Tolkein. http://www.tintin.com ( http://www.tintin.be/fr/index.html ) Gloriously imperialistic. _Tintin in Tibet_ is considered by many to be the high point, when Herge was exploring transcendant themes: http://www.tintin.com/uk/alb_fr/tibet_fr.html --- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: Code Red
Patrice, I have a friend downstairs who said I should use Fprot to get rid of this rogue web page, I am going to download it now. I am interested in this TDS-3 program, can I get that at downloads.com or is it somewhere else? KK -Original Message- Patrice J Sent: Tuesday, August 07, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Update your virus checking software. Patch your software and your OS as far as you can. Re. NT use PatchWork as well ( http://grc.com/pw/patchwork.htm http://grc.com/pw/patchwork.htm ), it catches things the Microsoft Windows Update seems to overlook. You may want to get a trojan detector like tds-3 to catch trojans like CodeRed II. There are many trojan detectors posted on the 'net. Beware of free ones. Stay clear of anything on servers in countries that do not recognize copyright laws, or who might be actively financing hackers! Sounds obvious but sometimes people don't think about this when they are following links on the Web. Look at where a link leads (bottom status bar if using IE) before you click. You also need something that is current. Anything that hasn't been updated in the last year is probably useless. It seems to me that now we need: A virus / worm checker A trojan horse detector A firewall. Only one component missing, and you could be in trouble. The trouble with code red was that it went through port 80, which is left open by firewalls because that is the port used for HTTP pages (WWW). Closing that would mean no one could access Web pages. So firewalls won't help you re. things like that. You can now go through any ports that are left open, and there is software out there to detect ports that were left open. Life is getting complicated! For trojan detection I like TDS-3 because with some plug-ins, you can send a message right back to the people who are probing your system using a trojan. TDS-3 also scans all the processes running in memory, and it comes with interesting process descriptions for some of those obscure NT services. This is from first glance, I am running the shareware version at home. I have a month to make up my mind and pay up... For home, ZoneAlarm (firewall) is free. I like it because it tells you when programs are trying to access your machine via ports going in, or out. So if a program on your machine wants to access the 'net, you can see which program is trying to do that and you can decide whether to let it do that or not. Sometimes it's hard to decide, though, e.g. distributed COM - should I let that thing send info out of my computer to the 'net? It's a built-in component of Windows, but I don't know. (btw the author says he programs only in assembly language) Re. virus checking F-Prot has a shareware version, that's free as long as you don't mind re-installing it now and again. I am probably going to buy it eventually. I don't know how to compare the effectiveness of these, though. Some are more popular out there but to my mind it doesn't mean that they are ideal, esp. when marketing and mass advertising through the media is involved. I haven't seen any honest reviews of virus checking software, I don't know where to look. I set up ZoneAlarm and TDS-3 on my machine at home and was surprised to see what is going on. With ZoneAlarm you can get the owner for a particular IP range, so you can see who is trying to ping or intrude on your machine. A colleague here says he is on cable modem, and that is even worse than DSL in terms of hacking activity, he showed me a log where he was a target every ten minutes on average for a prolonged period of time. He uses BlackIce Defender. Korean and university servers are the most common that I see in use as launchpads. It doesn't mean that's where the probes and that attacks are coming from though. T1, Cable and DSL users are most at risk, but dial-up clients are vulnerable as well as long as they remain connected. I sent e-mails to some ISPs to complain, but they don't appear to care what people are doing with their net connections, it seems they just want to sell memberships. In many cases they want you to prove that damage was done, someone trying to invade your machine is not illegal. The irony is that if someone ever succeeded, I probably wouldn't have the information I would need to lodge a formal complaint. I gave up trying to get ISPs to clamp down, better to prevent these attempts from succeeding than to try to stop the behaviour. It's easy to become paranoid... 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: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07,
Re: Optimizer Mode......how to choose the right one?
NEVER change an optimizer since the application have some time working with it. I should leave it in CHOOSE and then analyze what are doing the transactions. Look up the worst events through v$system_Event or from time to time through v$session_wait. Issue an utlbstat/utlestat or statspack. Then when you know which is the worst wait. Maybe db file scattered read or most of the times enqueue or latch free and sometimes a huge amount of db file sequential read because of bad indexes. Look up the indexes. Doing that consider their clustering_factor, their blevel and the most important thing their selectivity. ETC. --- Veronica Levin [EMAIL PROTECTED] wrote: Morning listers! I am having performance problems with this database, transactions ar running very slow and I am not sure if I have choose the right optimizer mode... AIX 4.2.1, Oracle 7.3.4, 30 GB Database, 1 GB Real Memory, 500 MB SGA, 70 concurrent users, mostly OLTP transactions. I have tunned init parameters the best I can we the resources I have: db_files = 70 db_writers = 4 db_file_multiblock_read_count = 16 db_block_buffers = 57600 db_block_size = 8192 shared_pool_size = 157286400 processes = 200 dml_locks = 1500 log_buffer = 655360 sequence_cache_entries = 800 sequence_cache_hash_buckets = 89 log_checkpoint_interval = 8 optimizer_mode=CHOOSE session_cached_cursors = 300 sort_area_size=1048576 hash_area_size=262144 hash_multiblock_io_count=4 hash_join_enabled=TRUE always_anti_join=HASH job_queue_processes=8 35 rollback segments, inital 1MB, next 1MB, optimal 30 MB 8 multiplexed redologs, 30 MB each I tried FIRST_ROWS, analyzing the tables, but users claimed that performance was getting worse, so I chaged it to Choose. Always analyzing the tables but, everytime I analyze the tables, performance gets worse. Is this a normal behavior? Any advice will be welcome! thanks is advance, Saludos, Veronica Levin Enriquez Administrador AIX Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin 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). = Eng. Christian Trassens Senior DBA Systems Engineer [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : 541149816062 __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christian Trassens 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: negative value for buffer cache hit ratio
Ran this query under 8i(HP-UX 11)
SQL show user
USER is SYS
SQL select to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
2from ( select total_waits misses
3from sys.v_$system_event
4 where event = 'db file sequential read' ),
5 ( select sum(dbbget + conget - pread) hits
6 from sys.x_$kcbwds
7 where inst_id = userenv('Instance') )
8 /
from sys.x_$kcbwds
*
ERROR at line 6:
ORA-00942: table or view does not exist
Under 7.3.4.5 (HP-UX 10.20)
SQL show user
user is SYS
SQL select to_char(100 * misses / (hits + misses), '9990.00') || '%'
miss_rate
2from ( select total_waits misses
3from sys.v_$system_event
4 where event = 'db file sequential read' ),
5 ( select sum(dbbget + conget - pread) hits
6 from sys.x_$kcbwds
7 where inst_id = userenv('Instance') )
8 /
where inst_id = userenv('Instance') )
*
ERROR at line 7:
ORA-02003: invalid USERENV parameter
So what is wrong?
Regards
MOHAMMAD RAFIQ
Reply-To: [EMAIL PROTECTED]
To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]
Date: Tue, 07 Aug 2001 10:13:51 -0800
Try this more accurate query:
select to_char(100 * misses / (hits + misses), '9990.00') || '%' miss_rate
from ( select total_waits misses
from sys.v_$system_event
where event = 'db file sequential read' ),
( select sum(dbbget + conget - pread) hits
from sys.x_$kcbwds
where inst_id = userenv('Instance') )
/
Also, send the actual values if this query still leads to similar results.
The difference here is it takes in account of direct writes.
Do not criticize someone until you walked a mile in their shoes, that way
when you criticize them, you are a mile a way and have their shoes.
Christopher R. Spence OCP MCSE MCP A+ RAPTOR CNA
Oracle DBA
Phone: (978) 322-5744
Fax:(707) 885-2275
Fuelspot
73 Princeton Street
North, Chelmsford 01863
-Original Message-
Sent: Tuesday, August 07, 2001 1:51 PM
To: Multiple recipients of list ORACLE-L
Dear gurus !
I have a negative value for buffer cache hit ratio in my DB which is up for
some 4 months . Any ideas why ? Thanks in advance.
SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) /
2 (SUM(DECODE(a.name,'consistent gets',value,0)) +
3 SUM(DECODE(a.name,'db block gets',value,0) * 100 buffer cache
hit
ratio
4 FROM v$sysstat a;
buffer cache hit ratio
--
-52.99284
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Andrey Bronfin
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).
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mohammad Rafiq
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: computer history stories - Now: Age discrimination?
[via oracle-l digest] -- From: Farnsworth, Dave [EMAIL PROTECTED] Date: Mon, 6 Aug 2001 13:01:42 -0500 Subject: RE: computer history stories - Now: Age discrimination? Most people have a nerd stigma when thry think about physicists, but as a group, physicists are some of the more humble and nice group of people who tend to have a great love for their work. Just be careful with them, they all secretly, sometimes overtly, hate the humanities. regards, ep (former fertilizer salesman who got an honorary Ph.Dirt for being out standing in my field one day) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce 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: negative value for buffer cache hit ratio
Kirti, Audrey, I was under the impression that negative numbers are caused by the numbers wrapping around i.e., the database has been up for a while and the statistics pile up and eventually exceed the defined format (e.g. value of 1000+ for a format of 9(3) - to use old COBOL representation !). Makes sense ? I have seen his before. If you bounce the database, all will be well ! Srini Chavali Oracle DBA Cummins Inc Deshpande, Kirti [EMAIL PROTECTED]@fatcity.com on 08/07/2001 01:13:52 PM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Andrey, I am not into cache hit ratios, but got curious about your negative value. So I casually searched Metalink for 'negative value for hit ratio'. And got a hit on 'MROC: I am receiving a negative Buffer Cache hit ratio' thread. You may want to check it out, there seems to be a new formula for hit ratio computation in 8i/9i. HTH, Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Andrey Bronfin [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 12:51 PM To: Multiple recipients of list ORACLE-L Subject: negative value for buffer cache hit ratio Dear gurus ! I have a negative value for buffer cache hit ratio in my DB which is up for some 4 months . Any ideas why ? Thanks in advance. SQL SELECT (1 - (SUM(DECODE(a.name,'physical reads',value,0)) / 2 (SUM(DECODE(a.name,'consistent gets',value,0)) + 3 SUM(DECODE(a.name,'db block gets',value,0) * 100 buffer cache hit ratio 4 FROM v$sysstat a; buffer cache hit ratio -- -52.99284 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin 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). -- 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: free up datafile space problem ???
Janet, Possibly there were other tables in the tablespace using space in the datafile and then some tables were deleted leaving the tablespace fragmented. To completely clean the tablespace and free the space you have to export the contents of the tablespace( all tables), drop the tables, coalesce the tablespace, then recreate the tables, import the data and check the grants on the tables, Your tablespace should be contiguous and allow you to shrink the datafile to a smaller space. ROR mª¿ªm [EMAIL PROTECTED] 08/07/01 02:40PM Hi all, I have a data file of 2G and the free bytes is 1,413,079, the used bytes is only 683,829. I like to resize it. When I issue: alter database datafile '/orafs02/oradata/PV_A0725/ld_data05.dbf' resize 1000M, I got: ERROR at line 1: ORA-03297: file contains used data beyond requested RESIZE value But apparently, the file does NOT contain data beyond 1000M. Am I missing something? Thank you. Janet __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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: Ron Rogers 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: Code Red
http://tds.diamondcs.com.au/html/intro.htm http://tds.diamondcs.com.au/html/intro.htm Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- From: Kevin Kostyszyn [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, August 07, 2001 4:36 PM To: Multiple recipients of list ORACLE-L Subject:RE: Code Red Patrice, I have a friend downstairs who said I should use Fprot to get rid of this rogue web page, I am going to download it now. I am interested in this TDS-3 program, can I get that at downloads.com or is it somewhere else? KK -Original Message- Patrice J Sent: Tuesday, August 07, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Update your virus checking software. Patch your software and your OS as far as you can. Re. NT use PatchWork as well ( http://grc.com/pw/patchwork.htm http://grc.com/pw/patchwork.htm ), it catches things the Microsoft Windows Update seems to overlook. You may want to get a trojan detector like tds-3 to catch trojans like CodeRed II. There are many trojan detectors posted on the 'net. Beware of free ones. Stay clear of anything on servers in countries that do not recognize copyright laws, or who might be actively financing hackers! Sounds obvious but sometimes people don't think about this when they are following links on the Web. Look at where a link leads (bottom status bar if using IE) before you click. You also need something that is current. Anything that hasn't been updated in the last year is probably useless. It seems to me that now we need: A virus / worm checker A trojan horse detector A firewall. Only one component missing, and you could be in trouble. The trouble with code red was that it went through port 80, which is left open by firewalls because that is the port used for HTTP pages (WWW). Closing that would mean no one could access Web pages. So firewalls won't help you re. things like that. You can now go through any ports that are left open, and there is software out there to detect ports that were left open. Life is getting complicated! For trojan detection I like TDS-3 because with some plug-ins, you can send a message right back to the people who are probing your system using a trojan. TDS-3 also scans all the processes running in memory, and it comes with interesting process descriptions for some of those obscure NT services. This is from first glance, I am running the shareware version at home. I have a month to make up my mind and pay up... For home, ZoneAlarm (firewall) is free. I like it because it tells you when programs are trying to access your machine via ports going in, or out. So if a program on your machine wants to access the 'net, you can see which program is trying to do that and you can decide whether to let it do that or not. Sometimes it's hard to decide, though, e.g. distributed COM - should I let that thing send info out of my computer to the 'net? It's a built-in component of Windows, but I don't know. (btw the author says he programs only in assembly language) Re. virus checking F-Prot has a shareware version, that's free as long as you don't mind re-installing it now and again. I am probably going to buy it eventually. I don't know how to compare the effectiveness of these, though. Some are more popular out there but to my mind it doesn't mean that they are ideal, esp. when marketing and mass advertising through the media is involved. I haven't seen any honest reviews of virus checking software, I don't know where to look. I set up ZoneAlarm and TDS-3 on my machine at home and was surprised to see what is going on. With ZoneAlarm you can get the owner for a particular IP range, so you can see who is trying to ping or intrude on your machine. A colleague here says he is on cable modem, and that is even worse than DSL in terms of hacking activity, he showed me a log where he was a target every ten minutes on average for a prolonged period of time. He uses BlackIce Defender. Korean and university servers are the most common that I see in use as launchpads. It doesn't mean that's where the probes and that attacks are coming from though. T1, Cable and DSL users are most at risk, but dial-up clients are vulnerable as well as long as they remain connected. I sent e-mails to some ISPs to complain, but they don't appear to care what people are doing with their net connections, it
OT: Over seas online demo
Hi all, Was wondering if anyone knows of any software (bedsides pcanywhere or Citrix) that could be used to give a demo to a company across the ocean. I know I have seen it before, we went to a url to see a demo, I want to say it was ms netmeeting but I don't think that is right. any help would be greatly appreciated. Sincerely, Kevin Kostyszyn DBA Dulcian, Inc www.dulcian.com [EMAIL PROTECTED] -- 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).
