Re: OEM 9i - saving/copying reports between repositories
the files are stored in oem_webstage directory you will have to copy these files to the other location and give the path. As you must be knowing the oem reporting server should have the management server running on the same machine. when you remove default reporting from the console it doesnt remove from the operating system side. You can disable thatreport so that it doesnt show up on the webpage."Kaing, Leng" [EMAIL PROTECTED] wrote: G'day all,I've create a number of custom reports in one of our OMS and would copy them into another OMS. How does one go about doing this? Where are the reports stored? Is there a file that we can copy around? Or if we look at the problem in another way - OEM itself comes with a number of predefined reports. What if I accidentally removed it from my OMS? How do I get it back? Can we export and import OEM reports somehow? Or is there a file we can tell the OMS about? I don't really want to export and import the whole OEM schema. I just want certain reports to be copied from one OMS into another.TIA,Leng.--Leng KaingEmail: [EMAIL PROTECTED]Phone: +61-3-9203-7589Mobile: +61-417-371-348-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Kaing, LengINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). SMS using the Yahoo! Messenger; Download latest version.
Re: high cpu
why dont you check the v$transaction to see whether it is rolling back or i mean it is still active. Sometimes if a process is doing lots of reads on the database and causing lots of cpu spike it would be better you kill the process from the database first and then from the side unix also,we had these issues and had to kill those processes on the unix side also otherwise they keep taking resources. M Rafiq [EMAIL PROTECTED] wrote: Rebounce the database...After shutting down database , check for any oracle process is still alive by usingipcs -mbIf it is still their kill those process by yourself (using ipcem -m ) or by Unix admin. Sometime it does not go and then you have to reboot.If shutdown immediate takes longer then use shutdown abort. Recovery will not take longer at startup.RegardsRafiqReply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: Wed, 11 Jun 2003 14:04:21 -0800OS :hp-uxoracle rdbms 8.1.7.4there are certain processes taking lot of cpu ( some thing went wrong with stastics last nite). which is causing almost a halt in production database.these processes are killed from oracle but i can still see them on OS .Cpu is still high .I though! after killing them mpon might be doing some clean up work .cpu is still high .question : If I recycle this instance ,is it going to take long time to come back . ( smon will do the job now ?)or is "fast warm start" will help here to bring db up quickly?thanks,-Ak_STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: M RafiqINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing). Catch all the cricket action. Download Yahoo! Score tracker
Needed information on Data security
Hi, Is anybody using dbms_obfuscation_toolkit for encrypting the data for encrypting the data in the database. How is the performance after enabling this,Can you please let me know the Pros and cons of this package. Or is there any other way u people are encryting the data,Please let me know We are planning to encrypt some of the data in the database. So please let me know your thoughts how best i can secure the data on the database. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OEM
it is free which comes along with ur enterprise edition -Original Message- Sent: Monday, June 10, 2002 4:44 PM To: Multiple recipients of list ORACLE-L Hi Does somone tell me how to check price information about Oracle enterprise manager product? Is OEM available on Unix box also? How to setup email with OEM? Thx -Seema _ Send and receive Hotmail on your mobile device: http://mobile.msn.com -- 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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Veritas Quick io
we are using the quick I/O and as well as cached quik I/O also. I had configured this a quite long time ago I have forgotten about temp files issues which u people are talking about. But We did have issues by just using quick I/O cause it acts like a cooked raw file system and hence is write intensive but not read intensive this screws up ur database or u will see lot of sequential reads due to this which at one time brought our database to its knees, This caching can be done online also even when the database is running.Once we enabled cached we were able to breadth. u can cache each file itself or the whole file system. the monitoring io can been done thro qiostat which will tell u about the i/o being performed. I can say if u are implementing this on oltp better use cached i/o or one more way where i was reading some where was to increase ur sga to a good amount( which i would not recommend). i have seen the performance improvement to around 30 to 40%. But after this i started seeing file open event very heavily i even asked on this issue to steve adams once -Original Message- Sent: Friday, May 31, 2002 4:28 PM To: Multiple recipients of list ORACLE-L Kathy, We are using Veritas Quick IO on our Solaris Box 6500 with Oracle Apps 11.5.6 on 8.1.7.2 database. Right now we do not have the temp files converted to quick io and wonder if we should. The guy who installed Quick IO didn't seen to think we could but he was a pretty junior person. In addition to the many execllent and right answers that have been given, make sure that a DBBS (DataBase Baby Sitter) doesn't inadvertly extend a Database file via RESIZE or (horrors!) enable AUTOEXTEND on any QIO based datafile! You will have to use the qiomkfile with the -e (extend by the delta) or the -r (resize to this value) options to extend/resize a datafile prior to this RESIZE action. Effectively, AUTOEXTEND cannot be used :( A question to the others using QIO: * Has anyone measured the performance improvement brought about by using QIO for Oracle? (I have already read the Oracle report that compares QIO and Raw: The report concluded that they are both the same as far as perf goes. I am interested in plain vs qio, but don't want to start another raw vs plain war :) * I assume that DISK_ASYNC_IO was allowed to default to TRUE (on Solaris). In this case, I assume that you would track the wait times for the 'direct path read' and 'direct path write'? * I assume you have put in place procedures to make sure that a file is NOT resized via ALTER DATABASE without a qio resize. The question is: Do you have any way of checking that there has NOT been such a resize? The manual suggests that you pre-allocate the filesize and take it up (via DATABASE/RESIZE) as it grows, but thats as good (bad!) as actually resizing it right in the beginning! * Is anyone using 'Cached Quick I/O'? Any gotchas? One question leading to another here, but I hope we can all learn from this :) John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 The manuals for Oracle are here: http://tahiti.oracle.com The manual for Life is here: http://www.gospelcom.net ** The opinions and statements above are entirely my own and not those of my employer or clients ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Mid level Oracle DBA position Available in 1800flowers.com
Yep As Rachel said it is in Westbury,Long Island, NY. No Travelling involved.This is a Full time position no Contracts,No head hunters Fee also is being paid. About Working environment I do not want to say anything,It would be better I think If Rachel herself tells how this environment is. We are a team of 3 at present maintaining around 50 databases and in that around 12 to 15 are production.We also do have Sql servers on which our main website is running.We have Quest's Shareplex running as an one way replication We have financials and also Datawarehousing involved. The meaning of on CALL hmm... u cannot go out of Long Island u should be available on site if there is an emergency else u can login from the laptop provided to u and get the job done.Once in a month u will be asked to be on call during the weekend and during the peak time u are required to work during Saturday and sunday's too apart from that u are supposed to work extra one hour every day during the peak time.You can take a Comp off for this. This peak time means during the Valentine day,Cristmas and Mother's day. -Original Message- Sent: Wednesday, May 29, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Folks, this job is in Westbury, Long Island, NY, just in case you didn't get that I worked at 1-800-flowers for a year -- just after Mother's Day '98 through Mother's Day '99. Anyone who is interested in the job there and wants to know my experiences, please email me offlist. Rachel --- Arun Chakrapani [EMAIL PROTECTED] wrote: Hi, Sorry to be posting this mail here, There is a mid level Oracle dba Full Time position available here in 1800Flowers.com,If any one of u are interested please send me your resume,I can forward it to my Director or if you can mail it directly mail it to [EMAIL PROTECTED] We are pure OLTP and sun shop, stress is given more on performance tuning,24x7 and should be willing to carry pager all the time. Please do let us know ur expected salary as well when u are sending ur resume. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Limited SORT_AREA_SIZE
Whenever I create or rebuild indexes i have been having the sort_Area_size as 1 gig,I have never faced any issues,but one thing i want to know why did u have to bounce the instance for this,whenever i create i add the sort area size for the session only and not on the instance level. we were building indexes on large tables which has around 50 to 60 million rows with their avg row size of 300k.I open up 6 to seven sessions and have all their sort_Area_Size to 1 gig and create the indexes. But we have 23 gigs of ram and 60 gigs of swap space and it has 23 cpus. I am surprised about this error which u got. -Original Message- Sent: Tuesday, May 28, 2002 12:54 PM To: Multiple recipients of list ORACLE-L This weekend I was rebuilding a large table and when it came time to rebuild the indexes, I cranked the SORT_AREA_SIZE up to 1/2 gig. It bombed off with an ORA-04030. I kept reducing the SORT_AREA_SIZE (bouncing the instance to make the change) until I got it down to 150-meg. Then everything ran fine. I discussed this with my Unix system administrator and he felt everything was fine from his end. I ran Oracle's maxmem utility and received: oracle.fin7maxmem Memory starts at: 5369596416 (1400d8a00) Memory ends at: 6399795195 (17d751ffb) Memory available: 1030198779 (3d6795fb) So it seems like I could have SORT_AREA_SIZE much higher than 150-meg. The indexes built fine, but I am curious about the problem. Any ideas? Oracle 8.1.6 (until Oracle gets a good 8.1.7 version) Compaq Tru64 4.0E 4-cpu. 4-gig. of system memory. shared_pool_size = 400-meg This is the only instance on this server. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Limited SORT_AREA_SIZE
Are u getting that error quite frequently -Original Message- Sent: Tuesday, May 28, 2002 1:52 PM To: Multiple recipients of list ORACLE-L Arun - Thanks for the tip of using ALTER SESSION. I'll try that next time, and I hope next time isn't too soon. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, May 28, 2002 12:32 PM To: Multiple recipients of list ORACLE-L Whenever I create or rebuild indexes i have been having the sort_Area_size as 1 gig,I have never faced any issues,but one thing i want to know why did u have to bounce the instance for this,whenever i create i add the sort area size for the session only and not on the instance level. we were building indexes on large tables which has around 50 to 60 million rows with their avg row size of 300k.I open up 6 to seven sessions and have all their sort_Area_Size to 1 gig and create the indexes. But we have 23 gigs of ram and 60 gigs of swap space and it has 23 cpus. I am surprised about this error which u got. -Original Message- Sent: Tuesday, May 28, 2002 12:54 PM To: Multiple recipients of list ORACLE-L This weekend I was rebuilding a large table and when it came time to rebuild the indexes, I cranked the SORT_AREA_SIZE up to 1/2 gig. It bombed off with an ORA-04030. I kept reducing the SORT_AREA_SIZE (bouncing the instance to make the change) until I got it down to 150-meg. Then everything ran fine. I discussed this with my Unix system administrator and he felt everything was fine from his end. I ran Oracle's maxmem utility and received: oracle.fin7maxmem Memory starts at: 5369596416 (1400d8a00) Memory ends at: 6399795195 (17d751ffb) Memory available: 1030198779 (3d6795fb) So it seems like I could have SORT_AREA_SIZE much higher than 150-meg. The indexes built fine, but I am curious about the problem. Any ideas? Oracle 8.1.6 (until Oracle gets a good 8.1.7 version) Compaq Tru64 4.0E 4-cpu. 4-gig. of system memory. shared_pool_size = 400-meg This is the only instance on this server. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Limited SORT_AREA_SIZE
One more best way also is to create those indexes with nologging along with ur sort_area_size,this i think u must be knowing, if that database has a standby then copy this file which has the index data Cause as u know only the structure of the index goes to the dictionary and not the index data hence u will have to copy this file. -Original Message- Sent: Tuesday, May 28, 2002 12:54 PM To: Multiple recipients of list ORACLE-L This weekend I was rebuilding a large table and when it came time to rebuild the indexes, I cranked the SORT_AREA_SIZE up to 1/2 gig. It bombed off with an ORA-04030. I kept reducing the SORT_AREA_SIZE (bouncing the instance to make the change) until I got it down to 150-meg. Then everything ran fine. I discussed this with my Unix system administrator and he felt everything was fine from his end. I ran Oracle's maxmem utility and received: oracle.fin7maxmem Memory starts at: 5369596416 (1400d8a00) Memory ends at: 6399795195 (17d751ffb) Memory available: 1030198779 (3d6795fb) So it seems like I could have SORT_AREA_SIZE much higher than 150-meg. The indexes built fine, but I am curious about the problem. Any ideas? Oracle 8.1.6 (until Oracle gets a good 8.1.7 version) Compaq Tru64 4.0E 4-cpu. 4-gig. of system memory. shared_pool_size = 400-meg This is the only instance on this server. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Mid level Oracle DBA position Available in 1800flowers.com
Hi, Sorry to be posting this mail here, There is a mid level Oracle dba Full Time position available here in 1800Flowers.com,If any one of u are interested please send me your resume,I can forward it to my Director or if you can mail it directly mail it to [EMAIL PROTECTED] We are pure OLTP and sun shop, stress is given more on performance tuning,24x7 and should be willing to carry pager all the time. Please do let us know ur expected salary as well when u are sending ur resume. Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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.7.4
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Export multiple targets using OEM
Title: RE: Export multiple targets using OEM It is not possible to have to seperate export jobs running thro oem until and unless u do it thro node jobs where in u can call the export command and tell the export command to use a parfile which u keep it in the os in this parfileu can specify the parameters, This is the only possibility u can do to have 2 seperate exports running on two different machines. -Original Message-From: Baylis, John [mailto:[EMAIL PROTECTED]]Sent: Thursday, May 16, 2002 11:58 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Export multiple targets using OEM I am using OEM 9.0.1 with job scheduler I am trying to export full database for multiple targets using the job scheduler. How do you specify more than one .dmp name and location? I want a .dmp and .log file for each target. Even though I specified 2 targets, it appears as if only one .dmp file was created even though 'Job History' shows both exports completed successfully. Also How can I specify an environment variable such as %ORACLE_SID% in the path for the .dmp file? e.g. D:\ORACLE\ADMIN\%ORACLE_SID%\EXP\FILES\EXP.DMP John Baylis Database Administrator Canadian Forest Products Ltd. Vancouver B.C. Canada (604) 697-6476 (Office) (604) 313-6054 (Cell)
Script for deleting old archive logs from NT
Does anybody has script to delete old archive logs on NT when the disk reaches certain percentage. Please let me know Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Diagnostic and Tuning Packs
to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- 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: Mandar A. Ghosalkar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Prod problem, please help!!!
I am actually having the same probs now there is a database which is is getting froze for a few secs nobody can login but we did not know what time this was occuring. set a recording thro 9i for every sec later we came to know it was due to cache buffer chain. almost 90 to 100 people were waiting on latch free wait issue. Found that all the users are running the same sql with the same data requests. Looks like we have to tune the sql.Yet to analyze the sqls. -Original Message- Sent: Wednesday, May 01, 2002 5:42 PM To: Multiple recipients of list ORACLE-L As jared says keep querying the session_Wait u will defnetly bound to catch the guy who might be causing the database to kneel down. If the database is hung, the waits will likely show up immediately. I've had similar problems with waits on a latch that hung the database. If a session is hung, the waits should be there the first time you query. It may also be that you can't even query the v$ views, in which case you must resort to the state dumps. Jared Arun Chakrapani [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/30/2002 01:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Prod problem, please help!!! If nothing works and when u know the database has frozen u can run the following command to take dump of the database so that u can send it to oracle for analyzing or u can analyze it too. As jared says keep querying the session_Wait u will defnetly bound to catch the guy who might be causing the database to kneel down. Are u flushing shared pool quite frequently. check this out(this was one of the cause which was bringing the database down and was fixed in 7.2 or 7.3 i INET: [EMAIL PROTECTED] -- 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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Prod problem, please help!!!
If nothing works and when u know the database has frozen u can run the following command to take dump of the database so that u can send it to oracle for analyzing or u can analyze it too. As jared says keep querying the session_Wait u will defnetly bound to catch the guy who might be causing the database to kneel down. Are u flushing shared pool quite frequently. check this out(this was one of the cause which was bringing the database down and was fixed in 7.2 or 7.3 i think. Best bet is to keep querying the session_wait and catch the event which is causing the probs. IF YOU HAVE 9I OEM CLIENT INSTALLED USE THE RECORDING THRO PERFORMANCE MANAGER WHICH WILL LET U KNOW LATER ON WHAT HAPPENED. Please do check with the other DBA'S in this group before running of what i say Do systemstate dump 3 times in a row. $ svrmgrl connect internal oradebug setmypid(process_id) oradebug unlimit oradebug dump systemstate 10 or oradebug dump errorstack 3 -Original Message- Sent: Tuesday, April 30, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Tracy, You can start by using the query below to determine what the sessions are actually waiting on: select s.username username, e.event event, s.sid, e.p1text, e.p1, e.p2text, e.p2, e.wait_time, e.seconds_in_wait, e.state from v$session s, v$session_wait e where s.username is not null and s.sid = e.sid -- skip sqlnet idle session messages and e.event not like '%message%client' order by s.username, upper(e.event); Jared Tracy Rahmlow [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 04/30/2002 12:21 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Prod problem, please help!!! I have opened a TAR with Oracle and am waiting a resolution. In the meantime, I am wondering if anybody else has any ideas while I wait. Specifics: IBM AIX 4.3 Rdms 8.1.7.3 Database ~75g OLTP database with approximately 500 dedicated connections and 500 shared connections with Oracle's MTS. Problem: The database hangs, and no user is able to connect to the instance, except locally through srvmgrl. Even within svrmgrl, we are unable to select anything from the database without the query hanging. However, we can abort the instance (shutdown abort) and start it up again just fine. This has happened on 4-22, 4-29 4-30 in the early afternoon. Usually, this is also our peak busy rate for the week. We are executing MTS for 4 applications, all other applications connect through dedicated server. The alert log contains a message unable to start a shared server process. This week it was #41 and last week it was #25. Normally, we do not exceed 5 shared servers. Another thing I noticed is that there is no time allocated to any of the newly created shared servers. It is as if, it can not process any work through existing shared servers and decides to allocate another one, until finally it freezes. I am not sure if this is a MTS problem because I would suspect that I should be able to establish a dedicated server connection. And I can not. I think that this is just a symptom of the underlying problem. It would appear to me that we are running out of a resource, however our sysadms do not see any resource problems. Does anybody have any ideas how to debug this? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing
RE: {9i New Features: DataGuard}
I have been working on this dataguard on 8I in this u can switch over the production to standby as production and switch back to orignal production by making the switch over production to standby again. The 9i OEM dataguard does not support 8I it only supports 9i so the only option is to run from command line. It is working fine as such i have not faced any probs from that. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: {9i New Features: DataGuard} Next installment of 9i new features, like always send hate mail to /dev/null. Also if I've lied in something feel free to correct/flame me for it. The Saga continues: Oracle 9i New Features: 9i Data Guard So you have Oracle 8i standby database, what is new with 9i standby also known as Data Guard. Well in theory it can be totally automated. In 8i you had to put the database in managed recovery mode(or you manually did recovery) on the standby db. I hope no one was doing manual recovery every time a archive log was shipped across. :) Now with 9i dataguard, the standby database can be built either: 1. manually just like you did in 8i or2. automagically with OEM Dataguard Wizard(crazy wizards foreverything anymore). I personally couldnt get the wizard to work with 9.0.1.0. Does it work now?, I'm not sure as I've not tested it as of recent. The manual method works just fine. Ok so you need to create a standby database, we're not going to cover that here, why?, Mostly cause we're only going to cover the new aspects, you all can read the docs as well as I can to build the db. On to the new stuff: Your standby database in 8i was only in what we call "delayed" protection mode, which means there is a delay from the time the logs are completed on the primary database before they are appliedto the standby database. Now with 9i, you have 3 other modes: Guaranteed protection: indicates that primary database modifications are available to the standby database, up to the last committed transaction. The standby database cannot diverge from the primary database at all, and no data can be lost. If a standby database is unavailable, processing automatically halts on the primary database as well. Instant Protection: With instant protection, the standby database may temporarily diverge from the primary database, but upon failover to the standby database, the databases can be synchronized, and no data will be lost. Rapid Protection: With rapid protection, the log writer process transmits redo logs to the standby sites. Use this mode when availability and performance on the primary database are more important than the risk of losing a small amount of data. An important note is that in Guaranteed and Instant protection mode that the logs are written in SYNCHRONOUS mode to the standby site. Rapid and Delayed mode are ASYNC writes. So this begs to ask what is the difference between Guaranteed and Instant? Well in Guaranteed mode the logs are applied and there is no data divergence from the primary and standby db. Whereas Instant mode there can be data divergence but upon failover there will beNO data loss. So since we wont have data loss, there is a new way to "failover" to a standby database, called switchover. You can literally be able to switch to a standby database and switchback to the original primary WITHOUT having to reinstantiate(ie: rebuild) the primary. A very nice feature, this gives you the capability to do rolling upgrade of OS -NOTICE, NOT ORACLE BINARIES YET, ONLY THE OS. In 8i you could only do a failover(which required rebuilding the primary), you can still do a failover in 9i if you've lost the primary db in some disaster like the computer room caught on fire. Now for the automated part: There is the dataguard manager/broker, it can be run from command line($ORACLE_HOME/bin/dgmgrl) as well as from OEM. This gives you the luxury of oracle doing all the work to maintain consistency between the primary and standby database. Way too much to cover here but it handles automatically applying logs, notification of down standby, etc. Feel free to ask anything about Dataguard to me directly at [EMAIL PROTECTED] Joe
RE: {9i New Features: DataGuard}
It even adds the datafile on the standby database for u, only u have set it in the parameter file of the dataguard. -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: Thursday, April 25, 2002 1:14 PMTo: Multiple recipients of list ORACLE-LSubject: {9i New Features: DataGuard} Next installment of 9i new features, like always send hate mail to /dev/null. Also if I've lied in something feel free to correct/flame me for it. The Saga continues: Oracle 9i New Features: 9i Data Guard So you have Oracle 8i standby database, what is new with 9i standby also known as Data Guard. Well in theory it can be totally automated. In 8i you had to put the database in managed recovery mode(or you manually did recovery) on the standby db. I hope no one was doing manual recovery every time a archive log was shipped across. :) Now with 9i dataguard, the standby database can be built either: 1. manually just like you did in 8i or2. automagically with OEM Dataguard Wizard(crazy wizards foreverything anymore). I personally couldnt get the wizard to work with 9.0.1.0. Does it work now?, I'm not sure as I've not tested it as of recent. The manual method works just fine. Ok so you need to create a standby database, we're not going to cover that here, why?, Mostly cause we're only going to cover the new aspects, you all can read the docs as well as I can to build the db. On to the new stuff: Your standby database in 8i was only in what we call "delayed" protection mode, which means there is a delay from the time the logs are completed on the primary database before they are appliedto the standby database. Now with 9i, you have 3 other modes: Guaranteed protection: indicates that primary database modifications are available to the standby database, up to the last committed transaction. The standby database cannot diverge from the primary database at all, and no data can be lost. If a standby database is unavailable, processing automatically halts on the primary database as well. Instant Protection: With instant protection, the standby database may temporarily diverge from the primary database, but upon failover to the standby database, the databases can be synchronized, and no data will be lost. Rapid Protection: With rapid protection, the log writer process transmits redo logs to the standby sites. Use this mode when availability and performance on the primary database are more important than the risk of losing a small amount of data. An important note is that in Guaranteed and Instant protection mode that the logs are written in SYNCHRONOUS mode to the standby site. Rapid and Delayed mode are ASYNC writes. So this begs to ask what is the difference between Guaranteed and Instant? Well in Guaranteed mode the logs are applied and there is no data divergence from the primary and standby db. Whereas Instant mode there can be data divergence but upon failover there will beNO data loss. So since we wont have data loss, there is a new way to "failover" to a standby database, called switchover. You can literally be able to switch to a standby database and switchback to the original primary WITHOUT having to reinstantiate(ie: rebuild) the primary. A very nice feature, this gives you the capability to do rolling upgrade of OS -NOTICE, NOT ORACLE BINARIES YET, ONLY THE OS. In 8i you could only do a failover(which required rebuilding the primary), you can still do a failover in 9i if you've lost the primary db in some disaster like the computer room caught on fire. Now for the automated part: There is the dataguard manager/broker, it can be run from command line($ORACLE_HOME/bin/dgmgrl) as well as from OEM. This gives you the luxury of oracle doing all the work to maintain consistency between the primary and standby database. Way too much to cover here but it handles automatically applying logs, notification of down standby, etc. Feel free to ask anything about Dataguard to me directly at [EMAIL PROTECTED] Joe
Urgent need information on Buffer busy wait P3 value
Can somebody please let me know what the following number means in the p3 value of session wait when there is a bufferbusy wait, I am not able to get the docs on these values,The version is 8.1.7.3 SIDFNNAM BLOCK P3 -- --- -- -- 895 /db4b/oradata/800B/800P_atlas_index3.dbf 115301220 1183 /db4b/oradata/800B/800P_atlas_index5.dbf70790210 1137 /db8b/oradata/800B/800P_rbs6_2.dbf4896231 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB freezes ... no indications of any kind
When your database freezes can you log in as internal thro svrmgrl and see what is happening on v$session_Wait -Original Message- Sent: Tuesday, March 12, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Thanks john, The dbms_job has problems on 9012, so I am switching to good old cron ... basically I don't have the statpack info at all ... but I am starting it at 10am today. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB freezes ... no indications of any kind
If you are able to login and query the session_Wait try using the below said query select s.INDX SID,u.KSUUDNAM||','||u.KSUSEUNM||','||u.KSUSEMNM||'('||decode(KSUSSOPC,2,'LA TCH FREE',12,'ENQUEUE',94,'db file sequential read', 95,'db file scattered read',144,'LIBRARY CACHE PIN',75,'buffer busy waits', 145,'library cache lock',146,'library cache load lock',91,'log file sync',KSUSSOPC)||')' EVENT_WITH_OSUSER, KSUSSP1R P1RAW,KSUSSP1,KSUSSP2 P2,KSUSSP3 FROM X$KSUSECST s,x$ksuse u WHERE KSUSSOPC IN(2,12,94,95,144,75,145,146,91) and bitand(s.ksspaflg,1)!=0 and bitand(s.ksuseflg,1)!=0 and s.ksussseq!=0 and u.indx=s.indx -Original Message- Sent: Tuesday, March 12, 2002 9:19 AM To: Multiple recipients of list ORACLE-L Thanks Arun Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB freezes ... no indications of any kind
: Tuesday, March 12, 2002 10:14 AM To: Multiple recipients of list ORACLE-L If you are able to login and query the session_Wait try using the below said query select s.INDX SID,u.KSUUDNAM||','||u.KSUSEUNM||','||u.KSUSEMNM||'('||decode(KSUSSOPC,2,'LA TCH FREE',12,'ENQUEUE',94,'db file sequential read', 95,'db file scattered read',144,'LIBRARY CACHE PIN',75,'buffer busy waits', 145,'library cache lock',146,'library cache load lock',91,'log file sync',KSUSSOPC)||')' EVENT_WITH_OSUSER, KSUSSP1R P1RAW,KSUSSP1,KSUSSP2 P2,KSUSSP3 FROM X$KSUSECST s,x$ksuse u WHERE KSUSSOPC IN(2,12,94,95,144,75,145,146,91) and bitand(s.ksspaflg,1)!=0 and bitand(s.ksuseflg,1)!=0 and s.ksussseq!=0 and u.indx=s.indx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB freezes ... no indications of any kind
Why dont you sent an event which monitors the database and takes a system state dump during the freeze thro ORADEBUG From that I hope u can find out where it is bombing -Original Message- Sent: Monday, March 11, 2002 3:58 PM To: Multiple recipients of list ORACLE-L Thanks Waleed, Well, I'd say about 3 log switches during 15 minute period before and after the freeze, nothing crazy ... that's what is confusing ... Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, March 11, 2002 2:07 PM To: Multiple recipients of list ORACLE-L Check the frequency of Log Switches, specially that time the db froze Waleed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: DB freezes ... no indications of any kind
like put a cron job which keeps connecting to the database if there a probs by any chance a freeze see to that in the script it runs ORADEBUG COMMAND WHICH WILL TAKE A DATABASE SYSTEM DUMP I have a feeling u know the command for ora debug If not please use the following script I use the below said script to monitor whenever the database freezes it takes snapshot of the database using system state dump. There are other commands also but i am not able to remember them I will post u once i get those scripts #!/bin/ksh get_pmon=`ps -ef |grep pmon_800P|grep -v grep` . /opt/app/oracle/oracle_env svrmgrl EOF connect internal oradebug setospid $get_pmon oradebug unlimit oradebug dump systemstate 10 exit EOF -Original Message- Sent: Monday, March 11, 2002 5:34 PM To: Multiple recipients of list ORACLE-L Can you please elaborate on that? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -Original Message- Sent: Monday, March 11, 2002 5:13 PM To: Multiple recipients of list ORACLE-L Why dont you sent an event which monitors the database and takes a system state dump during the freeze thro ORADEBUG From that I hope u can find out where it is bombing -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Problem with Rollback segment getting locked
Title: Problem with Rollback segment getting locked I might not be right but why dont u try reducing the number of transaction per rollback segment and see -Original Message-From: Viral Amin [mailto:[EMAIL PROTECTED]]Sent: Friday, February 22, 2002 7:29 AMTo: Multiple recipients of list ORACLE-LSubject: Problem with Rollback segment getting locked Hi All, I have about 12 Rollback segmennts in my database 25 concurrent users logged in. I am continuously facing problems of oracle just keep locking couple of Rollback segments. other people have to wait till Oracle releses the locks on this rollback segments. My Query is..Why Oracle is just using the few rollback segments from the avilable 12 then others have to wait till the locks on the rollback segments are released. Pls help..This is URGENT!! Regards, Viral Amin
RE: Lost a redo disk
Nope u cannot switch when it is in mount mode have u lost all your redlogs -Original Message- Sent: Wednesday, February 20, 2002 8:28 AM To: Multiple recipients of list ORACLE-L Hi everybody, This all started with the halon firing in our data center last night around 10pm so you can imagine my condition. I lost a disk that contained only redo logs. When I try to open the database I get ORA-00313: open failed for members of log group 1 of thread 1 ORA-00312: online log 1 thread 1: 'F:\ORACLE\ORADATA\OWBREPOS\REDO01.LOG' ORA-27041: unable to open file OSD-04002: unable to open file I thought what I needed to do was switch the log files, drop the members that are on the bad disk, and then I'd be able to open the database. So I mounted the database and did alter system switch logfile; and its telling me ORA-01109: database not open I thought I could swicth logfile with the database mounted? Could someone suggest the right steps I should take to recover? Many TIA, Beth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seefelt, Beth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Rows Locked
Most of the time you can find out which row the user is waiting on the row_Wait_row# will tell you what row it is waiting on and row_wait_block# will tell you what block it is waiting and row_wait_file# will tell you which file it is waiting for all the above information u can get from v$session, The user who is waiting for a lock_wait in the v$session will be having this information. use the dbms_rowid package which will tell you which table and which rowid this is waiting on get the rowid and you will find out which row it is waiting on the following query will tell u which row a user is waiting on you will have to login as sys to run this query. you will get the table name along with the select statement and the table name this query can be run when the there is a lock issue select INDX SID,KSUSESER SERIAL,KSUUDLNA USERNAME,KSUSEUNM OSUSER, KSUSEMNM MACHINE,'select * from '||o.nametable_which_is_locked,' where rowid= '''||DBMS_ROWID.rowid_CREATE(1,to_number(o.DATAOBJ#),to_number(s.KSUSEFIL), to_number(s.KSUSEBLK),to_number(s.KSUSESLT))||''';' ROWID_LOCKED from x$ksuse s,obj$ o where bitand(ksspaflg,1)!=0 and bitand(ksuseflg,1)!=0 and decode(s.ksqpswat,hextoraw('00'),null,ksqpswat) is not null and o.obj#=s.ksuseobj -Original Message- Sent: Friday, February 15, 2002 1:24 PM To: Multiple recipients of list ORACLE-L Yes. Trial and error method. -Original Message- Sent: Thursday, February 14, 2002 10:18 PM To: Multiple recipients of list ORACLE-L Is there a way to find out what rows are being locked ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alroy Mascranghe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: parallel execution
Check the dba_tables there is a column name degree if it is not default ie 1 then parallel executions on that table is turned on -Original Message- Sent: Tuesday, February 12, 2002 9:14 AM To: Multiple recipients of list ORACLE-L Good morning all, It there a view which tell which tables are in parallel?I would like to see which table have parallel execution turned on. Thanks is advance, Ruth -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: What impacts index build times on partitioned tables?
EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- This e-mail was scanned by the eSafe Mail Gateway -=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). MOHAMMAD RAFIQ _ Join the world's largest e-mail service with MSN Hotmail. http://www.hotmail.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: 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). -- 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). MOHAMMAD RAFIQ _ 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 find out what caused job to fail?
Title: How to find out what caused job to fail? When ever it fails it will generate trace files from which u can find why it has failed. -Original Message-From: Daiminger, Helmut [mailto:[EMAIL PROTECTED]]Sent: Monday, February 04, 2002 3:40 AMTo: Multiple recipients of list ORACLE-LSubject: How to find out what caused job to fail? Hi! Is there a way to find out, why a database job failed? in dba_jobs (or user_jobs), I can only see that it failed, but no indication of the reason why it failed. Any ideas? This is 8.1.7 on Solaris. Thanks, Helmut
RE: LOCK!!!
Why dont u check it out from v$session_wait From what u have show below there is not locking issue Check the v$session_wait,you should defnetly see something out there It is better always to come from v$session_Wait If you see any issues there then u got a probs -Original Message- Sent: Thursday, January 31, 2002 3:13 PM To: Multiple recipients of list ORACLE-L Hi, guys, Trying to figure out what my best option is. Some users are unable to access the system. Previously I had a trace file with Deadlock detected , but that session was killed. SELECT * FROM V$LOCK WHERE block0 or lmode=6 / ADDR KADDR SID TYID1ID2 LMODE REQUEST CTIME BLOCK - -- - - - - - - 037DFE74 037DFE84 3 RT 1 0 6 01464073 0 Any quick advice is appreciated. Best, Sergey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babich , Sergey INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Arun Chakrapani INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).