tnslistener brute force trigger?
all, i have been attempting to find a solution to set a trigger / alarm mechanism on the listener for brute-force attempts. we're trying to get something useful logged so we can forward it to an ISD system or what not. ideas? i have done a bit of research and found nothing useful so far. am i missing something? thanks in advance. dana mueller guardent, inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autostarting databases
Hi Bob I took a look at the database service one of our servers. service properties: startup program: d:\oracle\ora816\bin\oracle.exe abcd (the sid of the database). startup mode = automatic. logon as local system account. allow service to interact with desktop. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 9:52 PM Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. This is windows 2k server service pack 3 Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. That must be a personal custom script. Ive searched all my nt and win2k servers and only have a TRCFMT.cmd which looks like a file to format trace files Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Yes its on auto Then specify the parameters that are to be used for startup, like pfile=xx. Your talking about the properties window of the service? Where it says You can specify the parameters that apply when you start the service from here If so that will start the database but the setting pfile=x does not retain. So, it seems like you can only pass that parameter, the pfile=xxx once Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. So your asying I need a win2k account for the database user? Ive never heard of that nor have seen parameters in any other configurations. This method has been known to work. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
error code 3113
3113 end-of-file on communication channel This is a very common error and encounter many times, but generally down the databae and up again solve the problem, but this time i m not able to handle it by doing that... What is the remady and.. WHAT ARE THE CAUSE FOR THIS ERROR ?? Why it happened..?? Thanks and regard.. Satyendra .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satyendra K Khare INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Monitoring Database by Unix
Friends : Do you have scripts ready for : 1.) to see usage memory by database on unix ? 2.) to see usage memory by schema inside database? 3.) to see usage I/O by session inside database ? 4.) to find out how long a session is not being used, and treats it as a non used or lost session , that is using memory unnecessary 5) to see the load of the machine 6.) explanation about itens showed in the top comand ? what can i look at this comand ? what is the main item that dba needs to see ? In general , i would like to monitor the machine with database server . Regards Eriovaldo -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Move ALL Data from 1 Database into Another
Would there be any Performance Overhead in the Newly ATTACHED Oracle 8i Database after moving it to production ? NOTE - Database Size 100 GB with 800 Concurrent Users Currently Are there any Other Pre-requisites / TO DOs to Allow Detaching of Application Tablespaces from the Previously Migrated Oracle 8i Database to the NEWLY Created 8i Database ? Sorry for the Ignorance -Original Message- Sent: Thursday, November 14, 2002 12:54 PM To: VIVEK_SHARMA Vivek, This transportable TBS option come with 8i onwards, and once you have migrated to 8i you can detach application tbs and attached these to new 8i database. Thanks Regards, Vipin Jain -Original Message- From: VIVEK_SHARMA [SMTP:[EMAIL PROTECTED]] Sent: Thursday, November 14, 2002 12:41 PM To: LazyDBA.com Discussion Subject:RE: Move ALL Data from 1 Database into Another Forgive the previous incomplete post. Hi Ankur QS. After Migrating the Oracle 7 Database to 8i , Using Transportable Tablespaces Can one Simply use DETACH the Application Tablespaces (OTHER Than SYSTEM) Attach them to the Newly Created 8i Database ? Thanks Indeed Hi Jeremiah Some of the Data Dictionary Objects are Corrupted in the Live Production Oracle 7 Database Even after Migration to Oracle 8.1.7.4 the Corruption Still persists . Nevertheless I missed Some of your Points . MY QUESTIONS(QS.) TO SOME OF YOUR POINTS ARE IN CAPITALS BELOW :- Thanks indeed -Original Message- Sent: Thursday, November 14, 2002 5:14 AM To: Multiple recipients of list ORACLE-L I don't like any of the suggestions so far, because they take more time than necessary. DB links do ONE ROUND TRIP for every row fetched! That is not efficient. Export is a nightmare of potential failures. I think you can devise the best solution by just copying the database files. Try this idea on for size: 0. Make sure both versions of Oracle are installed on the host. 1. Make a hot backup or RMAN copy of the database, and start it under a different SID. QS. CHANGING SID WOULD WARRANT A RESETLOGS . IS THAT CORRECT ? 2. Upgrade the copy to 8.1.7, but keep COMPATIBLE at 7.3.4. 3. Roll the copy forward to the current time using the logs generated by the old 7.3.4 instance, which is still in use. QS. IS IT POSSIBLE TO APPLY REDO LOGS GENERATED FROM A DIFFERENT SID TO A NEW SID ? 4. Shut down the old instance, apply the last log to the new one, and restart the new one with COMPATIBLE = 8.1.7. 5. Replace the listener with an 8.1.7 listener pointing at the new instance. This method gives you near zero downtime between kicking the users off the old database and letting them into the new one. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move ALL Data from 1 Database into Another
Hi Jeremiah I don't like any of the suggestions so far, because they take more time than necessary. DB links do ONE ROUND TRIP for every row fetched! That is not efficient. Export is a nightmare of potential failures. I think you can devise the best solution by just copying the database files. Are you sure about the one round trip thing. I may be mistaken but I must admit that has not been my experience. Are you thinking of occasions when you use a remote table (accessible via a DBLink) in a local join? In such cases the optimizer might set up the plan to get the remote rows individually rather than doing unproductive remote full or range scans. One would anticipate that a query like INSERT into localtable (select * from remotetable@link) would pull things over in a stream. OCI certainly streams query results like that - I'm not saying that DBLinks are based on OCI - just that there is precedent for this in at least one Oracle networking layer. Kind regards Dale -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How-To or Good Practices on Code Releases
You do not have to reinvent the wheel. If you want to check the scripts just do the following: 1) Get the DBATool from DataBee www.databee.com 2) Do export no data from the target system. 3) Read the export into the DBATool 4) Create DDL for the schema 5) Run the DDL and create the schema in test db. 6) Run your script against the empty schema. All syntax error and logical error will show up. It will not check for data dependent error, like adding unique constrain to a column with data that have multiple occurrences of the same value but it will save you a lot of time and development. Yechiel Adar (who does not have any hidden/unhidden connections to DataBee) Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 9:23 PM one of the things I'm experimenting with right now, based on a request from clients, is a pre-run analysis script to report on likely errors that the actual script would generate. this gives me a chance to trap the silly errors and continue (e.g., modify column to NOT NULL that is already NOT NULL, drop a column that's not there, etc.) and provide feedback to the client on the more serious errors that will need their attention - e.g., changing a column datatype or reducing a column_size, where the existing data won't work; creating a FK, where there are missing parent records; etc.) This analysis script tests for the existance of new columns or data that are to be added, checks max(lengths) of fields that need to be shortened, etc. The client can then execute the analysis script, evaluate the output, and decide on a course of action. As others have said, though, this REALLY SHOULD first be run in a UAT, staging, or other test env first - if for no other reason than a sanity and syntax check. My objective with this is to PREVENT the need to roll back the script, save for unexpected errors (whereby something significant changed between the time the analysis script was run and the actual delta) and *critical* errors (crash, out of disk space, etc.) . . . in which case I would revert back to the backup they should have taken just before the script was executed HTH bill -Original Message- Sent: Wednesday, November 13, 2002 1:20 PM To: Multiple recipients of list ORACLE-L As an example, something that yours truly was involved with, and still have the scars to show for it. A migration from a lower version of Oracle, to a higher version, on a completely new server. The scripts ran fine, and the implementation plan worked fine. However, the application started reporting intermittent connection problems. This was a web application, and it took the developers a day to realize that the one of the components in the application was not fully certified with Oracle 8i. Also, there were memory leak issues with that version of Oracle 8i. Whereby we needed to fall back to the old server, with the new data. The rollback strategy in the implementation plan was a one liner, to fall back to the old server. This was good for an immediate fallback after the implementation. Had to go the export import way, which had some additional outage for hours. So, the next time this was implemented, we had a quick rollback strategy to rollback after n number of days. If memory serves me right, I think we had a standby database created on the old server with the new release, and a downgrade plan. This was tested and approved by the developers and the QA team, though I never had to use it. Since then, I tend to be paranoid about any changes to production databases. You live and learn. Regards Raj DENNIS WILLIAMS DWILLIAMS@LIFETo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] TOUCH.COM cc: Sent by: Subject: RE: How-To or Good Practices on Code Releases [EMAIL PROTECTED] m November 13, 2002 12:15 PM Please respond to ORACLE-L Raj - Can you provide more details? Is this an automated script, or just a line on the form that says that you have some idea of how to rollback the change in case anything goes wrong? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 13, 2002 10:54 AM To: Multiple recipients of list ORACLE-L And have a similarly tested and signed off rollback strategy in place. An immediate rollback, as well as a rollback strategy after n number of days. Raj One attachment (0k) Reginald W. Bailey/JPMCHATo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] SE@CHASE cc: Sent by:
Re: tnslistener brute force trigger?
[EMAIL PROTECTED] wrote: all, i have been attempting to find a solution to set a trigger / alarm mechanism on the listener for brute-force attempts. we're trying to get something useful logged so we can forward it to an ISD system or what not. ideas? i have done a bit of research and found nothing useful so far. am i missing something? thanks in advance. dana mueller guardent, inc. [EMAIL PROTECTED] -- I don't understand what you mean by 'brute force attempts'. But have you thought about checking the listener log file and, if this is not enough, putting it at some moderate kind of trace level and checking the .trc ? -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 10i features
9iAS R2 is a terrible install. A complicated process further confused by poor instructions. Mike -Original Message- Sent: Wednesday, November 13, 2002 7:33 PM To: Multiple recipients of list ORACLE-L No, installing 9iAS is a 250 mph breeze. One definition of a tornado is a very strong breeze. -Original Message- Sent: Wednesday, November 13, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Only if they make installing 9iAs a breeze ... I have heard stories that 9iAS installation is not a picnic ... Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris vs Windows 2000
This blind hate and resentment towards Windows products it getting a little tiresome, have you guys even TRIED using Win2K? How about some constructive criticism? Don't get me wrong - I sit on the fence, and will defend both Unix AND Windows when I feel it's warranted. Win2K WILL be able to do the job that Jared wants it to do (we've seen and worked with the largest SAP database on NT in Europe).. And, Lyndon, I think we've got the message now :) Mark (Running XP Pro, Win2K Pro, and RH 8 at home) Leith -Original Message- [EMAIL PROTECTED] Sent: 14 November 2002 05:34 To: Multiple recipients of list ORACLE-L Everything good comes at a price. And never trust any system, where to shut down, you got to click on start ;-) Regards Raj Steve Perry sperry@sprynTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] et.com cc: Sent by: Subject: Re: Solaris vs Windows 2000 root@fatcity. com November 13, 2002 09:08 PM Please respond to ORACLE-L Thanks, but that wouldn't convince him. He'd say it wasn't MS's fault. It was our for not securing it :( When you want to believe something, you don't let facts get in the way :) Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 11:54 AM Steve, Get your Boss to read the following. Jared - one more arrow in your quiver! --6 November 2002 Bermudan Bank Site Defaced Hackers may have exploited a Microsoft operating system vulnerability to deface two Bermudan websites, including that of the Bank of Butterfield. Bank officials say no customer data was compromised. The site hosts are recommending that their clients who work with data that needs to be protected switch to their Unix based hosting platform. http://www.bermudasun.bm/cgi-local/edpull.pl?cat=01Newsord=03ed=2002-11-06 [Editor's Note Schultz]: The recommendation in this news item should add a considerable amount of fuel to the whose operating system is most secure debate.] John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Steve Perry [mailto:sperry;sprynet.com] Sent: Wednesday, November 13, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: Solaris vs Windows 2000 Jared, Here's my recollection of a losing battle. I hope this helps. I used to work on Unix (AIX and Solaris) and can only think about the good ol' days... Now, I work on Comcrap Servers (i mean HP) running Microslop NT and 2000. We have tons of them :) I asked my boss why they are using Windows instead of Unix. I gave him all the arguments about scalability, secure... and not having to do the weekly reboots and he listened patiently. He finally said How much will a Sun server cost?. I said I'd have to check on it, but he said We are running a 500 gig SAP system on a $5K compaq with 6 other compaq app servers that cost less than that. He asked what the Unix would cost. I started to answer that the hardware isn't the only cost and we have an EMC disk array behind it, but he stopped me and said it doesn't matter. He walks into the CIO's office and asks for a $70K dollar Solaris box and he gets booted out of the office. He can nickle and dime him for $5K servers... I pointed out that we had to spend a million dollars on a EMC Symmetrix with Clarion and he said exactly. We spend the big money on the I/O subsystem for a bunch of servers and we can buy all the cheap up front hardware we want. Next, he pointed out that we'd have to hire a Unix admin and that would cost money. Everybody knows how to administer Windows he says. I said pressing control-alt-del isn't administration. He also said that with EMC behind the scenes we don't have to worry about distributing the I/O. EMC will take care of it for us. I said that look at all the wasted time because we have to come in weekends (at least once a month) and install Win patches that take our systems down. That doesn't cost us anything because you're not paid hourly and that only impacts a few people my boss says. What about all the time wasted finding tools/scripts so we can do the same type of monitoring/troubleshooting that you can on Unix, I ask. You only need that once in a while and we can reboot the system if can't determine the problem he laughs. His last argument was that all the developers want the MS platform so
Configuring disks on a Windows 2000 server?
Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database. - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Configuring disks on a Windows 2000 server?
Hello Paul ALL our oracle servers are windows NT/2000 with raid 5 arrays for all the files. 1) The point that Oracle does not support online redo logs on stripped partition seems wrong to me. 2) There was a discussion on the list a while ago about the write speed times between raid 5 and raid 0+1. Anyway, since raid 5 are usually implemented with a big controller cache (backed up by a battery) your database writes to the cache and you get reasonable response time. We have a heavy online application with about 50 users that runs OK on windows NT with 2 processor and 5 disks raid 5 array. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 12:03 PM Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database. - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RE: How-To or Good Practices on Code Releases
Rajesh.Rao, I have the same experience. Developers directly connected to production database and added a column with default table on a huge table. The whole table is locked for 1 hour and other transaction failed. Add a column with non default value and then later add default value for it can be done in 1 second. Developers do not Know how oracle do it and just go on. New application going online without volume testing, getting online and as a production dba,i search for the bad sql and trace it out and send it back to developer! That is why many project fail, the app is designed and developed without the attendence of a guy who really knows oracle. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-11-13 12:06:00 ,you wrote£º=== I also have been burnt by an simple alter table add column default string script. A pretty simple script. The developers tested it, the QA team too approved it. Was expected to run in a matter of minutes. The problem was the data in production was 100 times over. Missed out on volume testing. Took 2 cuppas and 3 smokes before it was done. Raj Magaliff, Bill Bill.Magaliff@lenTo: Multiple recipients of list ORACLE-L ORACLE-L@fatcitS = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Move ALL Data from 1 Database into Another
On Wed, 13 Nov 2002, [EMAIL PROTECTED] wrote: Are you sure about the one round trip thing. Turns out you are right about not doing a single round-trip per row. My information was either outdated or apocryphal: SQL select value from v$sesstat ss, v$statname sn where sid = 31 and ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips to/from dblink'; VALUE -- 0 SQL insert into foobar (select * from foobar@baz); 1660073 rows created. SQL select value from v$sesstat ss, v$statname sn where sid = 31 and ss.statistic# = sn.statistic# and sn.name = 'SQL*Net roundtrips to/from dblink'; VALUE -- 1925 (Oracle8i Enterprise Edition Release 8.1.7.3.0 - 64bit Production) However, using DB links can never be as efficient as a parallel datafile copy followed by a near-zero downtime switchover. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton Hi Jeremiah Are you sure about the one round trip thing. I may be mistaken but I must admit that has not been my experience. Are you thinking of occasions when you use a remote table (accessible via a DBLink) in a local join? In such cases the optimizer might set up the plan to get the remote rows individually rather than doing unproductive remote full or range scans. One would anticipate that a query like INSERT into localtable (select * from remotetable@link) would pull things over in a stream. OCI certainly streams query results like that - I'm not saying that DBLinks are based on OCI - just that there is precedent for this in at least one Oracle networking layer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Installing 8.1.7 on a machine with an existing 9.0.1 installation
Hi everybody I'm about to throw my laptop out of the window (I'm on Win2k). I have an existing 9.0.1 installation (server and developer tools like designer and jedevelop). That works. Now I need to install an additional 8.1.7. If I run the installer from 8.1.7, it tells me that the component oracle.swd.jre 1.1.8.10.0 is missing while checking the dependencies (after you decide the installation type, before the list of available products/options is displayed). Checking the components in the stage directory, it shows that it is really missing. Next try was to install 8.1.7 using the 9.0.1 installer. Installation works, but hangs at the end ... great. Next try was to take the oracle.swd.jre 1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7 stage and to create the property files. No success. Any ideas, or do I have to remove everything, then install 8.1.7 first, folowed by 9.0.1 and the developer tools. That would be very diappointing. Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
listener.log parsing utility
Is there such a utility on the 'net somewhere? I would like to parse the log automatically, and get summaries of connection attempts, rejected connections, errors (if any), who connects, for how long. I have auditing set up in our db and can get some of that info, but I would like to monitor the contents of listener.log as well. Just curious. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installing 8.1.7 on a machine with an existing 9.0.1 installation
Hi, There´s a bug about your problem reported on Metalink. According to the bug report , you cannot install any 8i product on NT/W2K after 9i been already installed. To solve the problem you can use Universal Installer 2.0.1 , found at the Oracle 9.0.1 bundle. If you have access to Metalink check notes 172096.1 , 183939.1 and bug report 2019978. HIH, Antonio Belloni Stefan Jahnke Stefan.Jahnke@boTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] v.decc: Sent by: Subject: Installing 8.1.7 on a machine with an existing 9.0.1 installation [EMAIL PROTECTED] 14/11/2002 08:13 Please respond to ORACLE-L Hi everybody I'm about to throw my laptop out of the window (I'm on Win2k). I have an existing 9.0.1 installation (server and developer tools like designer and jedevelop). That works. Now I need to install an additional 8.1.7. If I run the installer from 8.1.7, it tells me that the component oracle.swd.jre 1.1.8.10.0 is missing while checking the dependencies (after you decide the installation type, before the list of available products/options is displayed). Checking the components in the stage directory, it shows that it is really missing. Next try was to install 8.1.7 using the 9.0.1 installer. Installation works, but hangs at the end ... great. Next try was to take the oracle.swd.jre 1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7 stage and to create the property files. No success. Any ideas, or do I have to remove everything, then install 8.1.7 first, folowed by 9.0.1 and the developer tools. That would be very diappointing. Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing 8.1.7 on a machine with an existing 9.0.1 installa
Hi, I copied the entire CD to disk (so that I can always install additional features as needed) and installed using the 9.0.1 installer w/o problems on W2K off the top of my head: If you have a Pentium 4 there are issues to resolve with the java environment and one of them was to copy the entire cd to disk rename symcjit.dll to symcjit.old and start using the installation from the install win32 directory. I renamed the files and used the 9i installer instead and that worked also Jack -Original Message- Sent: donderdag 14 november 2002 12:14 To: Multiple recipients of list ORACLE-L installation Hi everybody I'm about to throw my laptop out of the window (I'm on Win2k). I have an existing 9.0.1 installation (server and developer tools like designer and jedevelop). That works. Now I need to install an additional 8.1.7. If I run the installer from 8.1.7, it tells me that the component oracle.swd.jre 1.1.8.10.0 is missing while checking the dependencies (after you decide the installation type, before the list of available products/options is displayed). Checking the components in the stage directory, it shows that it is really missing. Next try was to install 8.1.7 using the 9.0.1 installer. Installation works, but hangs at the end ... great. Next try was to take the oracle.swd.jre 1.1.8.10.0 component from 9.0.1 (where it exists) and copy it to the 8.1.7 stage and to create the property files. No success. Any ideas, or do I have to remove everything, then install 8.1.7 first, folowed by 9.0.1 and the developer tools. That would be very diappointing. Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Applicatiuon FAILlOVER Callback
Hi here i am reposting the problem Can someone pls help us with the following problem? Any help would be appreciated. Regards -Naren. Requirement: When ever there is a connecion lost with database server the client applicaion should know this so that it can re-esablish the connecion.. For this we are using Application Failover callback. I am succeded in registering the callback application. But even the connection lost the applicaion is not being called. Any configuration is needed at database side?..or any other reason -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Autostarting databases
strtSID.cmd is long gone, probably since version 8.1X Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 12:13 AM Read Metalink Note: 62006.1 strtSID.cmd is created when you create a service using ORADIMxx, atleast on NT and DB version till 8.0.x, not sure about Win2K and Oracle Server 8.1.x and later Regards Naveen -Original Message- Sent: Thursday, November 14, 2002 1:23 AM To: Multiple recipients of list ORACLE-L Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. This is windows 2k server service pack 3 Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. That must be a personal custom script. Ive searched all my nt and win2k servers and only have a TRCFMT.cmd which looks like a file to format trace files Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Yes its on auto Then specify the parameters that are to be used for startup, like pfile=xx. Your talking about the properties window of the service? Where it says You can specify the parameters that apply when you start the service from here If so that will start the database but the setting pfile=x does not retain. So, it seems like you can only pass that parameter, the pfile=xxx once Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. So your asying I need a win2k account for the database user? Ive never heard of that nor have seen parameters in any other configurations. This method has been known to work. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Naveen Nahata INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dbf Files, Mount Points and Oracle 7
Just wanted to write a follow up to my question that I posted a couple of weeks ago. I would like to thank all that replied. The feedback you gave was great. I finally got a chance during the holiday Monday to implement these changes in my production database and it was fairly straight-forward and everything seems to be working fine. There were not even too many surprises that were different from the newer test database. As far as Air Force people pulling Navy people's anchors, I would hope not since this database is being used more and more for non-Navy projects. Anyway, thanks again for all the great responses. Wayne [EMAIL PROTECTED] PS. I might even be able to add weather modification to my resume since during this change, we got 1/4-inch of rain. That is the first measurable rain we have had in this neck of the Mojave Desert since March of 2001. Funny, nobody mentioned this side effect of changing the database ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: McGill, Wayne L INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener.log parsing utility
Patrice, I wrote the enclosed awk script to check the listener log and count the number of connections from each target. I am sure it could be adapted to suit your needs The first few line of output looks like Service :Host :User :tcp:ip address :No of Connections === service1 :C :\Oracle\Ora901\b:xxx:dedicated24 service2 :xxx :SMITHL1 :tcp:xx.xx.xxx.xxx47 /u00/oracle/john 227$ cat a.sh Script starts here echo Service :Host :User :tcp:ip address echo === grep CONNECT listener.log |\ awk -F= '{print $3 :1: $6 :2: $7 :3: $9 :4: $10 :5: $11}' |\ sed 's/).*:1:/:/' | \ sed 's/).*:2:/:/' | \ sed 's/).*:3:/:/' | \ sed 's/).*:4:/:/' | \ sed 's/).*:5:/:/' | \ sed 's/).*$//' | \ awk -F: '{printf(%-8.8s:%-16.16s:%-16.16s:%-3.3s:%-10.15s\n, \ $1,$2,$3,$4,$5)}' | sort /tmp/j.lis grep -v PROGRAM /tmp/j.lis /tmp/j1.lis cat /tmp/j1.lis | awk '{if (data[$0]++ == 0)lines[++count] = $0}\ END{for (i = 1; i = count; i++)print lines[i],\tdata[lines[i]]}'\ |sort -n +4 rm /tmp/j.lis rm /tmp/j1.lis script ends here HTH John -Original Message- Sent: 14 November 2002 13:09 To: Multiple recipients of list ORACLE-L Is there such a utility on the 'net somewhere? I would like to parse the log automatically, and get summaries of connection attempts, rejected connections, errors (if any), who connects, for how long. I have auditing set up in our db and can get some of that info, but I would like to monitor the contents of listener.log as well. Just curious. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: OT ksh day of week yesterday
Ross: Actually, this solves the problem nicely. I can always find an oracle database up around here somewhere :) A couple of folks suggested this approach and I was going to work on it yesterday when chaos broke out. But you were kind enough to give me the code! It's very much appreciated. Thanks! Barb Ross Collado [EMAIL PROTECTED] wrote: I used to have this requirement too. I never got to solve it by just usingksh scripting so ended up getting Oracle to derive the value for me. I guessthis doesn't solve your problem if you don't have an Oracle db running.#!/bin/kshYESTERDAY=`sqlplus -s / -EOFset head off feed off pages 0select to_char(sysdate-1,'fmDy') from dual;exitEOF`TODAY=`date +\%a`echo "TODAY is $TODAY YESTERDAY is $YESTERDAY"Hth,Ross-Original Message-Sent: Thursday, 14 November 2002 5:25To: Multiple recipients of list ORACLE-LWill someone take pity on this poor VMS'er lost in a unix world??I'm trying to create a script (ksh) that reads a log file created yesterday.The log files are created with `date +%a` appended to the end of the logfile name. Last night a log file was created called arc_index! ! log.Tue It'seasy enough to get today TDAY="`date +%a`"grep -i "ora" /orasrv/ops/maint/logs/arc_indexlog.$TDAYgrep -i "ora" /orasrv/ops/maint/logs/adv_indexlog.$TDAYbut how do I get yesterday in the same format? (i.e., Tue instead of Wed)I man'd date, but it was no help.Thanks for any help.Barb_ Do you Yahoo!?U2 on LAUNCH - Exclusive medley videos from Greatest Hits CD-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Ross ColladoINET: [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 spell! ! ing 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).Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site
usage of new_time() function
Hey folks, Oracle 8.1.7, Solaris I have a possible requirement that all record timestamps must use GMT. Has anyone found an easy way to determine the sysdate timezone to use in the new_time() function. Thanks much... Steve -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Steven Haas INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: e: when is an error msg not an error msg ?
This could happen when the ORACLE_HOME is not set correctly. You may have the ORACLE_HOME in the .profile but your application might be running from a script which unsets the ORACLE_HOME or sets it incorrectly. Hemanat At 02:14 PM 13-11-02 -0800, you wrote: Hello, I've looked over hill and over dale at many web-sites (MetaLink, google, asktom, etc.), to no avail, so could someone on the list bail me out on this question - what causes the following error message: ORACLE ERROR=Error while trying to retrieve text for error ORA-03114 Now, I know what causes the 03114; I need to know why I am getting the 'error while trying to retrieve... I get this error on my test and production servers, but not the development server. All have the same # of files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing somewhere that I know not of ? Any help would be greatly appreciated. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Installing 8.1.7 on a machine with an existing 9.0.1 installa
Could you please say which window and when? -Original Message- I'm about to throw my laptop out of the window -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Auto restart of Database
How can I setup my server/database sothat after reboot of my Solaris server, database and listener start automatically? Thanks. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Configuring disks on a Windows 2000 server?
Oracle's recommendation (for what it's worth) is SAME (Stripe All, Mirror Everything). They're blowing smoke about the redo logs. I've never heard anyone, anywhere say that (of course, I'm willing to learn from my errors). RAID 5 is usually recommended against but our recent discussion here (if I followed it correctly) indicated that the write penalty for RAID 5 may go the way of the single extent myth. RAID 5 is cheaper, in terms of number of disks. Paul Vincent Paul.VincentTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] @uce.ac.uk cc: Sent by: rootSubject: Configuring disks on a Windows 2000 server? 11/14/2002 05:03 AM Please respond to ORACLE-L Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database. - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: Configuring disks on a Windows 2000 server?
I think I would be looking for a new vendor. We run applications that run quite well in a Raid5 environment under W2K Server and/or Advanced Server and have run with other configurations also. Oracle doesnt know or care what is underneath as long as the O/S recognizes it and it can read and write to it. -Original Message- Sent: Thursday, November 14, 2002 3:03 AM To: Multiple recipients of list ORACLE-L Hi all, A 3rd-party software vendor is coming in to install their application on a new Windows 2000 server. This application uses Oracle, so they'll also be installing Oracle 8.1.7 as part of their setup session. However, they've sent our server/hardware guys the following, specifying how they want the disks configuring on the server: - - - - - As to the RAID recommendations the issue is that Oracle do not support installations where the redo logs are on any sort of a stripped partition. My recommendation would be to create a mirror pair out of two of the disks. This can be partitioned for the system and the redo logs. The remainder of the disks can be RAID 5. Note that the RAID 5 array is where the actual database and archive logs are stored. In theory If you lose both disks on the mirror you would still have enough information on the RAID 5 partition to save the database. - - - - - Now, disk configuration's one of my weakest spots, but I have the following two questions about their instructions: 1. Is their point about Oracle not supporting redo logs on striped partitions true, or are they talking rubbish? All our UNIX servers with Oracle use RAID 0+1 (mirroring plus striping) on all their disks, but is it different for Windows servers? I must say I'd never heard of this restriction before, but I'm willing to be enlightened! Anybody? 2. They're recommending RAID 5 for a transaction-heavy application server, here. Surely that's wrong? I thought I understood that RAID 5 was great for file servers but lousy for servers running transactio-heavy business applications. What's the view of you guys on this? Please give me your views, I know we have some very experienced people on this list! Best regards, Paul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Vincent INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tony Johnson INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 10i features
In addition to 9iAS R2 being a terrible install, it is riddled with bugs and a total beast to get operational! I'll give folks another example. If/when you HOST out from a 9i Form your Unix process environment is populated with about 18 environmental variables. The problem is that NONE of the following are defined; HOME, LOGNAME, PATH! So the poor process doesn't know who he is, which way is home and has limited ability to even find any executable; which make scripting a REAL challenge. Hately, Mike (NESL-IT) To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Mike.Hately@npowernocc: rthern.com Subject: RE: Oracle 10i features Sent by: [EMAIL PROTECTED] 11/14/2002 01:24 AM Please respond to ORACLE-L 9iAS R2 is a terrible install. A complicated process further confused by poor instructions. Mike -Original Message- Sent: Wednesday, November 13, 2002 7:33 PM To: Multiple recipients of list ORACLE-L No, installing 9iAS is a 250 mph breeze. One definition of a tornado is a very strong breeze. -Original Message- Sent: Wednesday, November 13, 2002 8:03 AM To: Multiple recipients of list ORACLE-L Only if they make installing 9iAs a breeze ... I have heard stories that 9iAS installation is not a picnic ... Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Installing 8.1.7 on a machine with an existing 9.0.1 installa
Hi Thanks. I actually tried installing 8.1.7 using the installer as it comes with 9.0.1 (was already installed, since 9.0.1 is installed on the machine). It seemed to work, I selected the software to be installed, the install started, went up to 100% and then nothing happened. It just didn't finish the installation correctly (I did not choose to create a db or anything). I'm not on a Pentium 4 and I already copied the whole cd to disk. Is there anything else you took into consideration ? Regards, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stefan Jahnke INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved
Ray, right on target! After looking for disk errors in dmesg output, /var/log/messages to no avail, I finally uninstalled the whole 9.2 OH last night, re-downloaded/re-burned/re-... and this time installation of both 9.2.0.1 and a patch went with no glitches. Apparently Disk2 was corrupted/missing files/??? on downloading/burning/unpacking, but what surprised me the most is that I didn't get any errors at gunzip/cpio stage, which I always thought of as a good indication that software on CDs is valid. This assumption cost me week and a half of hopeless tries to make it work... On the bright side, some .o, .so etc. files I see in OUI during installation look painfully familiar... Thanks a lot for you help. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 01:50:52PM -0800 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris vs Windows 2000
W2K is fine, really. I use it at work and it's convenient since it comes with the computer you just bought. It runs Oracle fine as well since I've been using it for a while now. The issue here is the server side cost. W2K is expensive at $1,500 Cdn a pop for 5 licenses only. We need 500 per server at three servers on average per installation site, so imagine the cost of that. That's where Linux comes in. AND contrary to what people still think, Linux is ready for prime-time. -- Lyndon Tiu On Thursday 14 November 2002 01:30 am, Mark Leith wrote: This blind hate and resentment towards Windows products it getting a little tiresome, have you guys even TRIED using Win2K? How about some constructive criticism? Don't get me wrong - I sit on the fence, and will defend both Unix AND Windows when I feel it's warranted. Win2K WILL be able to do the job that Jared wants it to do (we've seen and worked with the largest SAP database on NT in Europe).. And, Lyndon, I think we've got the message now :) Mark (Running XP Pro, Win2K Pro, and RH 8 at home) Leith -Original Message- [EMAIL PROTECTED] Sent: 14 November 2002 05:34 To: Multiple recipients of list ORACLE-L Everything good comes at a price. And never trust any system, where to shut down, you got to click on start ;-) Regards Raj Steve Perry sperry@sprynTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] et.com cc: Sent by: Subject: Re: Solaris vs Windows 2000 root@fatcity. com November 13, 2002 09:08 PM Please respond to ORACLE-L Thanks, but that wouldn't convince him. He'd say it wasn't MS's fault. It was our for not securing it :( When you want to believe something, you don't let facts get in the way :) Steve - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 11:54 AM Steve, Get your Boss to read the following. Jared - one more arrow in your quiver! --6 November 2002 Bermudan Bank Site Defaced Hackers may have exploited a Microsoft operating system vulnerability to deface two Bermudan websites, including that of the Bank of Butterfield. Bank officials say no customer data was compromised. The site hosts are recommending that their clients who work with data that needs to be protected switch to their Unix based hosting platform. http://www.bermudasun.bm/cgi-local/edpull.pl?cat=01Newsord=03ed=2002-11-0 6 [Editor's Note Schultz]: The recommendation in this news item should add a considerable amount of fuel to the whose operating system is most secure debate.] John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 What would you see if you were allowed to look back at your life at the end of your journey in this earth? ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Steve Perry [mailto:sperry;sprynet.com] Sent: Wednesday, November 13, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: Solaris vs Windows 2000 Jared, Here's my recollection of a losing battle. I hope this helps. I used to work on Unix (AIX and Solaris) and can only think about the good ol' days... Now, I work on Comcrap Servers (i mean HP) running Microslop NT and 2000. We have tons of them :) I asked my boss why they are using Windows instead of Unix. I gave him all the arguments about scalability, secure... and not having to do the weekly reboots and he listened patiently. He finally said How much will a Sun server cost?. I said I'd have to check on it, but he said We are running a 500 gig SAP system on a $5K compaq with 6 other compaq app servers that cost less than that. He asked what the Unix would cost. I started to answer that the hardware isn't the only cost and we have an EMC disk array behind it, but he stopped me and said it doesn't matter. He walks into the CIO's office and asks for a $70K dollar Solaris box and he gets booted out of the office. He can nickle and dime him for $5K servers... I pointed out that we had to spend a million dollars on a EMC Symmetrix with Clarion and he said exactly. We spend the big money on the I/O subsystem for a bunch of servers and we can buy all the cheap up front hardware we want. Next, he pointed out that we'd have to hire a Unix admin and that would cost money. Everybody knows how to administer Windows he says. I said pressing control-alt-del isn't administration. He also said that with EMC behind the scenes we don't have to
Re: usage of new_time() function
Steven Haas wrote: Hey folks, Oracle 8.1.7, Solaris I have a possible requirement that all record timestamps must use GMT. Has anyone found an easy way to determine the sysdate timezone to use in the new_time() function. Thanks much... Steve Steve, I have very recently played a little bit with such things, and it seems to me pretty messy, especially when you happen to live in time zones whence you need not even think about sending your resume to OraStaff (seems better in 9.x). I have a few days ago discovered the command : ALTER DATABASE SET TIME_ZONE = 'blahblah'; where 'blahblah' can be specified either as a code (which doesn't really solve your problem) or as '+00:00' or '-00:00' to specify your offset to/from GMT, which I find easier to guess. Once your database knows where it stands, you can use function dbtimezone (which for a reason I have been too lazy to find out I had to specify as sys.standard.dbtimezone in a procedure) to get it. Then, you can compute the GMT date as follows : declare my_timezone varchar2(30); pos number; timeoffset number; begin select sys.standard.dbtimezone into my_timezone from dual; pos := instr(my_timezone, ':'); if (pos = 0) then -- -- Timezone was specified as an abbreviation -- dbms_session.set_nls('NLS_DATE_FORMAT', 'DD-MON- HH24:MI:SS'); timeoffset := SYSDATE - NEW_TIME(SYSDATE, my_timezone, 'GMT'); else -- -- Timezone was specified as a time offset -- timeoffset := to_number(substr(my_timezone, 2, pos-2))/24 + to_number(substr(my_timezone, pos+1,2))/1440; if (substr(my_timezone, 1, 1) = '-') then timeoffset := -1 * timeoffset; end if; end if; end; Create a packaged function GMTDATE, compute timeoffset as above in the initialization section of the package, and then simply make GMTDATE return SYSDATE + timeoffset and it should do. HTH, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NetBackup
Howdy Folks, Would appreciate feedback on experiences, positive :) or negative :(, folk have had using Veritas NetBackup product for DB recovery, especially in DR scenarios. There is an Oracle agent but so far all it appears to me to be is a glorious scheduler of your own RMAN scripted jobs!. Feedback on features I may have missed with agent would also be appreciated. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris vs Windows 2000
Fwd: linux does well in morgan stanley survey -- Forwarded Message -- Date: Thu, 14 Nov 2002 02:42:57 -0800 Hi all, A recent Morgan Stanley reports an excellent outlook for linux in IT. Not one CIO was prepared to reduce their usage of linux. http://h30046.www3.hp.com/news_article.php?topiccode=20021001_itereport0043 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: error code 3113
Satyendra - There are some good notes on Metalink. I just did a search and found: ORA-03113 AND ORA-03114 ON DESKTOP PLATFORMS Type: Note Doc ID: 1003596.6 Score: 100% Modified Date: 09-OCT-2002 Status: PUBLISHED Platform: MS Windows Product: Oracle Net Services 2. DIAGNOSING ORA-3113 ERRORS Type: Note Doc ID: 1020463.6 Score: 100% Modified Date: 05-OCT-2002 Status: PUBLISHED Platform: Generic issue Product: Oracle 3. OERR: ORA 3113 end-of-file on communication channel Type: Note Doc ID: 19790.1 Score: 100% Modified Date: 10-SEP-2002 Status: PUBLISHED Platform: Generic issue Product: Oracle Server - Enterprise Edition 4. ORA-03113 on Unix - What Information to Collect Type: Note Doc ID: 17613.1 Score: 100% Modified Date: 26-MAR-2000 Status: PUBLISHED Platform: Generic issue Product: Oracle Server - Enterprise Edition Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 1:59 AM To: Multiple recipients of list ORACLE-L 3113 end-of-file on communication channel This is a very common error and encounter many times, but generally down the databae and up again solve the problem, but this time i m not able to handle it by doing that... What is the remady and.. WHAT ARE THE CAUSE FOR THIS ERROR ?? Why it happened..?? Thanks and regard.. Satyendra .. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satyendra K Khare INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: listener.log parsing utility
Patrice - In case you don't get a reply, it sounds to me like an easy project for Perl. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 7:09 AM To: Multiple recipients of list ORACLE-L Is there such a utility on the 'net somewhere? I would like to parse the log automatically, and get summaries of connection attempts, rejected connections, errors (if any), who connects, for how long. I have auditing set up in our db and can get some of that info, but I would like to monitor the contents of listener.log as well. Just curious. Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Auto restart of Database
Assuming you are running Oracle 9i RDBMS(If not, After you click on the Database tab, choose the release you are running) Go to docs.oracle.com, click on the tab in the upper right corner that says Database, click on OK on the pop up disclaimer box, Under the 9i heading click on Sun SPARC Solaris and then click on the release that you are running. Then click on the link to the Installation Guide. Expand the Post-Installation section and click on Configuration Tasks to Perform as the Root User. Then go four bullet points down to Automating Database Startup and Shutdown for HP, Linux and Solaris... and click on that. There you have the complete instructions on how to implement Database Startup and Shutdown. If you want, you could just add a line in the given script to start the listener as well. -Scott Stefick At 07:28 AM 11/14/02 -0800, you wrote: How can I setup my server/database sothat after reboot of my Solaris server, database and listener start automatically? Thanks. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Auto restart of Database
Set last argument for appropriate SID in oratab = Y to restart DB at boot time. --- OraCop [EMAIL PROTECTED] wrote: How can I setup my server/database sothat after reboot of my Solaris server, database and listener start automatically? Thanks. __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraCop INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Check Point Interval Question
Thanks alot jared, I just want to know if I change my redo log size to 1 K, do I have to change checkpoint_interval to 2 or still 1 doesn't affect. Thanks alot -Original Message- Sent: Wednesday, November 13, 2002 8:28 PM To: Multiple recipients of list ORACLE-L Hamid, Is there perhaps a reason given for that setting? The setting determines how often a checkpoint will be performed based on the number of redo log blocks. From the FM: LOG_CHECKPOINT_INTERVAL specifies the frequency of checkpoints in terms of the number of redo log file blocks that can exist between an incremental checkpoint and the last block written to the redo log. This number refers to physical operating system blocks, not database blocks. On Solaris, that's 512 bytes per block. see: http://www.ixora.com.au/notes/log_block_size.htm With a value of 1, the setting had no effect on your log file of 4m, since a 4 meg file consists of 8192 512 byte blocks. Similarly, a setting of 999 will not cause any extra checkpoints to be written between log switches. A 20 meg log file has 40960 512 byte blocks. Setting LOG_CHECKPOINT_INTERVAL = 0 would have the same effect in both cases. Jared On Wednesday 13 November 2002 09:54, Hamid Alavi wrote: Dennis, Here it is in the oracle performance tuning (Tip's Techniques) page 735 suggested value for LOG_CHECKPOINT_INTERVAL = 999. My oracle version is 8.1.7.4 on sun solaris, 2.8, and I have some CPU problem, My thought is may be some checkpoint problem so, I have decided to increase the size of my Redo log from 4M to 20M and change the log_checkpoint_interval from 1 to 999 but I don't know what's the best setting for these numbers. -Original Message- Sent: Wednesday, November 13, 2002 9:16 AM To: Multiple recipients of list ORACLE-L Hamid - Which parameter to use depends on your Oracle version. If it is 9i, use FAST_START_MTTR_TARGET. In 8i, use LOG_CHECKPOINT_TIMEOUT. Did your tuning manual explain why you should set it to 999? That seems a little strange. Basically shorter checkpoint queue lengths will shorten your recovery times, but too short a queue length may hamper performance, so it is a tradeoff. What are your tradeoff criteria? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 13, 2002 10:39 AM To: Multiple recipients of list ORACLE-L Hi List, I have a question regarding check_point_interval. In my setting log_checkpoint_interval = 1 log_checkpoint_timeout = 1800 , I findout in the tuning manual which I have to change thelog_checkpoint_interval = 999 but nothing regarding the log_checkpoint_timeout, when I change the interval to 999 do I have to change the checkpoint_timeout too, or what's the best setting for these two numbers. I got confued, some where in the manual they are talking about to set timeout to zero some where else diffrent setting, I realy appreciate if some body give me a pratical Idea. Thanks for your help. Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from
Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved
out of curiosity : did you ever check the filesizes in bytes of yr first corrupt downloads with the bytes of the files on the download site? i'm running O9i too, now wondering if this test might suffice to tell whether the download was successful or not. i didn't experience any probs so far until recently when i changed/patched to 9.2.0.2.0 - the oem/console dosn't display the XML database. the flaw is, that it doesn't have some index ... created a totally new -userdefined,NOT preconfigured - database and could successfully display the XML-stuff. installation is on a rh 7.2 - was a rh 8.0 - but on rh8.0 the console didn't work - unproperly terminated connect string when attempting to connect even to a local database. dumped the whole rh 8.0, reinstalled the 7.2. lfw to a reply mr [EMAIL PROTECTED] 11/14/02 17:32 PM Ray, right on target! After looking for disk errors in dmesg output, /var/log/messages to no avail, I finally uninstalled the whole 9.2 OH last night, re-downloaded/re-burned/re-... and this time installation of both 9.2.0.1 and a patch went with no glitches. Apparently Disk2 was corrupted/missing files/??? on downloading/burning/unpacking, but what surprised me the most is that I didn't get any errors at gunzip/cpio stage, which I always thought of as a good indication that software on CDs is valid. This assumption cost me week and a half of hopeless tries to make it work... On the bright side, some .o, .so etc. files I see in OUI during installation look painfully familiar... Thanks a lot for you help. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 01:50:52PM -0800 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Linux?
Fwd: linux does well in morgan stanley survey -- Forwarded Message -- Date: Thu, 14 Nov 2002 02:42:57 -0800 Hi all, A recent Morgan Stanley reports an excellent outlook for linux in IT. Not one CIO was prepared to reduce their usage of linux. http://h30046.www3.hp.com/news_article.php?topiccode=20021001_itereport0043 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: How-To or Good Practices on Code Releases
what is the difference in the db between adding a column with a default value, and adding a column and then later modifying it to set a default value? in neither case is the value actually set in the column itself. thx -b -Original Message- Sent: Thursday, November 14, 2002 6:09 AM To: Multiple recipients of list ORACLE-L Rajesh.Rao, I have the same experience. Developers directly connected to production database and added a column with default table on a huge table. The whole table is locked for 1 hour and other transaction failed. Add a column with non default value and then later add default value for it can be done in 1 second. Developers do not Know how oracle do it and just go on. New application going online without volume testing, getting online and as a production dba,i search for the bad sql and trace it out and send it back to developer! That is why many project fail, the app is designed and developed without the attendence of a guy who really knows oracle. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-11-13 12:06:00 ,you wrote£º=== I also have been burnt by an simple alter table add column default string script. A pretty simple script. The developers tested it, the QA team too approved it. Was expected to run in a matter of minutes. The problem was the data in production was 100 times over. Missed out on volume testing. Took 2 cuppas and 3 smokes before it was done. Raj Magaliff, Bill Bill.Magaliff@lenTo: Multiple recipients of list ORACLE-L ORACLE-L@fatcitS = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Magaliff, Bill INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
CONSISTANT GETS
Dear List, I am monitoring a database, I findout there is a transaction which runing a long time and others are waiting for this transaction, this transaction have 8,000,000 consistant gets with only 1 Physical I/O. My question is, what I have to do except the SQL tuning to make this transaction faster, we have done all the necessary tuning on all the SQL query's. Here is a copy of ora.ini: Oracle 8.1.7.4 on sun solaris 2.8 background_dump_dest = /oracle/admin/cmstst/bdump compatible = 8.1.7.4 control_files = /cmsdb/cmstst/control02.ctl control_files = /oralogs1/cmstst/control03.ctl control_files = /oracle/oradata/cmstst/control01.ctl core_dump_dest = /oracle/admin/cmstst/cdump db_block_buffers = 1??? this need to increase? db_block_lru_latches = 4 db_block_size = 8192 db_file_multiblock_read_count = 16 db_name = cmstst hash_area_size = 2048000??? need tuning ??? instance_name = cmstst java_pool_size = 20971520 large_pool_size = 614400 log_archive_dest_1 = location=/archlogs/cmstst log_archive_format = arch%s.arc log_archive_start = TRUE log_buffer = 262144 ?? this log buffer is enough?? log_checkpoint_interval = 1 ?? log_checkpoint_timeout = 1800 max_enabled_roles = 30 open_cursors = 300 optimizer_index_caching = 90 optimizer_index_cost_adj = 35 os_authent_prefix = processes = 100 remote_login_passwordfile = EXCLUSIVE session_cached_cursors = 100 shared_pool_size = 134217728 sort_area_retained_size = 262144 sort_area_size = 262144 timed_statistics = TRUE I realy appreciate your help and assistant. I am getting confused, just want to know changing any of these parameter help the performance to reduce the number of CONSISTANT GETS or NOT??? Thanks in advance. Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved
Oracle Corp. finds the checksum concept to be alien. They actually posted these words to me in a tar at metalink, We don't support servers that are installed via download from otn. I guess network computing really is dead. ;) On Thu, Nov 14, 2002 at 07:54:27AM -0800, Boris Dali wrote: Ray, right on target! After looking for disk errors in dmesg output, /var/log/messages to no avail, I finally uninstalled the whole 9.2 OH last night, re-downloaded/re-burned/re-... and this time installation of both 9.2.0.1 and a patch went with no glitches. Apparently Disk2 was corrupted/missing files/??? on downloading/burning/unpacking, but what surprised me the most is that I didn't get any errors at gunzip/cpio stage, which I always thought of as a good indication that software on CDs is valid. This assumption cost me week and a half of hopeless tries to make it work... On the bright side, some .o, .so etc. files I see in OUI during installation look painfully familiar... Thanks a lot for you help. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 01:50:52PM -0800 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle SAN Experiences?
Title: The Sys Hi there What are the thoughts about the Xiotech - Magnitude. George George Leonard Oracle Database Administrator Dimension Data (Pty) Ltd (Reg. No. 1987/006597/07) Tel:(+27 11) 575 0573 Fax:(+27 11) 576 0573 E-mail:[EMAIL PROTECTED] Web: http://www.didata.co.za You Have The Obligation to Inform One Honestly of the risk, And As a Person You Are Committed to Educate Yourself to the Total Risk In Any Activity! Once Informed Totally Aware of the Risk, Every Fool Has the Right to Kill or Injure Themselves as They See Fit! -Original Message- From: Babette Turner-Underwood [mailto:[EMAIL PROTECTED]] Sent: 11 November 2002 15:29 PM To: Multiple recipients of list ORACLE-L Subject: RE: Oracle SAN Experiences? A client site that I was supporting a while ago had big problems with their NAS. While doing Oracle backups to tape, the application would drop connections. In a SAN environment, there might also be similar problems. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of David Wagoner Sent: Friday, November 08, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Subject: Oracle SAN Experiences? The Sys. Admin. team wants to consolidate storage (and probably get a new toy too) on all of our servers, so they are evaluating a SAN (LSI Logic E4600). The DBA team is doing some research to determine the pros and cons of doing this, and I'd like to hear any of your experiences (good and bad) using SAN with Oracle. My understanding is that all of our database servers would remain intact, but the attached disk storage would move into the SAN. So, we still have the Production, Test, and App. servers with their processors and memory, Oracle homes, etc. The SAN will hold database files from Production, Test, Apps., staging, ODS,data warehouse, etc. Their arguments: -the SAN is very scalable (500 GB - 40 TB) -easy to manage disks in one central location -fancy statistics collection on all SAN disks -much higher throughput on the fiber SAN connections than with locally attached disk arrays -capable of using mixed RAID levels (0, 1, 1+0, 5, etc.) -can partition sets of disks in the SAN for specific server access -Snapshot backup capability is very fast in the SAN (much faster than traditional Oracle backups) DBA arguments: -How will this affect database performance? -What are the drawbacks, if any, with the pre-fetch of data performed by the SAN (i.e., SAN cache) -How tunable is the SAN -Fast, small disks are better for performance and less wasted space than the typical huge disks in a SAN (it's possible to use smaller disks in the SAN) -Prove it! After reading the "Sane SAN" article and a case study about Volvo implementing a SAN, I believe it's possible to have a great Oracle/SAN implementation if it's setup correctly and tuned. Other resources that you can Google are "Using SVA SnapShot with Oracle", "Performance Benchmark LSI Logic E4600 (STK D178)", "SAN Storage for Open Systems Environments", and of course check the OraFaq. Thanks for sharing, David Wagoner Oracle DBA
Re: Oracle 9.2.0.1/2 on Mandrake 9 - solved
--- Markus Reger [EMAIL PROTECTED] wrote: out of curiosity : did you ever check the filesizes in bytes of yr first corrupt downloads with the bytes of the files on the download site? I did. They bear some resemblace, but figures are not exactly the same. I also compared sizes of files I got on disk (unpacked) after my first and second downloads and they are different for all 3 files, even though only Disk2 was... well, not good. Math doesn't seem to rule here. Go figure i'm running O9i too, now wondering if this test might suffice to tell whether the download was successful or not. i didn't experience any probs so far until recently when i changed/patched to 9.2.0.2.0 - the oem/console dosn't display the XML database. the flaw is, that it doesn't have some index ... created a totally new -userdefined,NOT preconfigured - database and could successfully display the XML-stuff. installation is on a rh 7.2 - was a rh 8.0 - but on rh8.0 the console didn't work - unproperly terminated connect string when attempting to connect even to a local database. dumped the whole rh 8.0, reinstalled the 7.2. lfw to a reply mr [EMAIL PROTECTED] 11/14/02 17:32 PM Ray, right on target! After looking for disk errors in dmesg output, /var/log/messages to no avail, I finally uninstalled the whole 9.2 OH last night, re-downloaded/re-burned/re-... and this time installation of both 9.2.0.1 and a patch went with no glitches. Apparently Disk2 was corrupted/missing files/??? on downloading/burning/unpacking, but what surprised me the most is that I didn't get any errors at gunzip/cpio stage, which I always thought of as a good indication that software on CDs is valid. This assumption cost me week and a half of hopeless tries to make it work... On the bright side, some .o, .so etc. files I see in OUI during installation look painfully familiar... Thanks a lot for you help. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 01:50:52PM -0800 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
ini file
Hi Again, Another question is, if i increase the following parameter is there any negative effective or not? 1) db_block_buffers = 1change to 2 2) hash_area_size = 2048000 change to 5120 5 M 3) log_buffer = 262144change to 5242880 5 M Thanks Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 9.2.0.1/2 on Mandrake 9 - solved
I've been told the same thing, but the reasoning was that they couldn't guarantee what was put out for download was actually the correct build. Not sure that's very reassuring, either. Jim -Original Message- Sent: Thursday, November 14, 2002 12:34 PM To: Multiple recipients of list ORACLE-L Oracle Corp. finds the checksum concept to be alien. They actually posted these words to me in a tar at metalink, We don't support servers that are installed via download from otn. I guess network computing really is dead. ;) On Thu, Nov 14, 2002 at 07:54:27AM -0800, Boris Dali wrote: Ray, right on target! After looking for disk errors in dmesg output, /var/log/messages to no avail, I finally uninstalled the whole 9.2 OH last night, re-downloaded/re-burned/re-... and this time installation of both 9.2.0.1 and a patch went with no glitches. Apparently Disk2 was corrupted/missing files/??? on downloading/burning/unpacking, but what surprised me the most is that I didn't get any errors at gunzip/cpio stage, which I always thought of as a good indication that software on CDs is valid. This assumption cost me week and a half of hopeless tries to make it work... On the bright side, some .o, .so etc. files I see in OUI during installation look painfully familiar... Thanks a lot for you help. --- Ray Stell [EMAIL PROTECTED] wrote: On Tue, Nov 12, 2002 at 01:50:52PM -0800 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How-To or Good Practices on Code Releases
Magaliff, Bill wrote: what is the difference in the db between adding a column with a default value, and adding a column and then later modifying it to set a default value? in neither case is the value actually set in the column itself. thx -b Give it a try, Bill. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: CONSISTANT GETS
forget about parameters ... look at fixing the SQL that is causing the problem hth connor --- Hamid Alavi [EMAIL PROTECTED] wrote: Dear List, I am monitoring a database, I findout there is a transaction which runing a long time and others are waiting for this transaction, this transaction have 8,000,000 consistant gets with only 1 Physical I/O. My question is, what I have to do except the SQL tuning to make this transaction faster, we have done all the necessary tuning on all the SQL query's. Here is a copy of ora.ini: Oracle 8.1.7.4 on sun solaris 2.8 background_dump_dest = /oracle/admin/cmstst/bdump compatible = 8.1.7.4 control_files = /cmsdb/cmstst/control02.ctl control_files = /oralogs1/cmstst/control03.ctl control_files = /oracle/oradata/cmstst/control01.ctl core_dump_dest = /oracle/admin/cmstst/cdump db_block_buffers = 1 ??? this need to increase? db_block_lru_latches = 4 db_block_size = 8192 db_file_multiblock_read_count = 16 db_name = cmstst hash_area_size = 2048000 ??? need tuning ??? instance_name = cmstst java_pool_size = 20971520 large_pool_size = 614400 log_archive_dest_1 = location=/archlogs/cmstst log_archive_format = arch%s.arc log_archive_start = TRUE log_buffer = 262144 ?? this log buffer is enough?? log_checkpoint_interval = 1 ?? log_checkpoint_timeout = 1800 max_enabled_roles = 30 open_cursors = 300 optimizer_index_caching = 90 optimizer_index_cost_adj = 35 os_authent_prefix = processes = 100 remote_login_passwordfile = EXCLUSIVE session_cached_cursors = 100 shared_pool_size = 134217728 sort_area_retained_size = 262144 sort_area_size = 262144 timed_statistics = TRUE I realy appreciate your help and assistant. I am getting confused, just want to know changing any of these parameter help the performance to reduce the number of CONSISTANT GETS or NOT??? Thanks in advance. Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ini file
Increasing db_block_buffers will almost certainly make no difference to the performance of the query you've shown us. Manipulation of hash_area_size might change your query's execution plan, but I can't tell you whether for better or for worse. But it is important to understand that changing hash_area_size might profoundly change a lot of other execution plans in your system as well. Some for better, and--I'm sure--some for worse. Your log buffer size is very likely an irrelevance with respect to your query performance. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Alavi Sent: Thursday, November 14, 2002 11:59 AM To: Multiple recipients of list ORACLE-L Hi Again, Another question is, if i increase the following parameter is there any negative effective or not? 1) db_block_buffers = 1change to 2 2) hash_area_size = 2048000 change to 5120 5 M 3) log_buffer = 262144change to 5242880 5 M Thanks Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Join Query Question
All... I'm not even sure how to ask this question, but given three tables: pocs poc_id number primary key sn varchar2(32) poc_hrid varchar2(16) poctype_id number references poctypes(poctype_id) poctypes poctype_id number primary key tiernumber(2,0) description varchar2(64) pocgroup_id number references pocgroups(pocgroup_id) pocgroups - pocgroup_id number primary key description varchar2(16) I'm attempting to construct a single query that will provide the poc_hrid *AND* the pocgroup description to which that poc belongs. This is part of a web-based application which allows for many points-of-contact (e.g. SysAdmin, Apps, Network, etc.), but allows only members of a particular group to modify certain sections of the record. Any help will be greatly appreciated! Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CONSISTANT GETS
Hamid, I'm sorry: Unless your SQL returns fewer than about 800,000 rows to the calling application (or an aggregation of 800,000 rows), then the statement we have done all the necessary tuning on all the SQL queries is not yet true. If your SQL does actually return about 800,000 rows, then it is time to begin thinking about the mismatch between business processing requirements and the logical structure of your data. The answer to your problem is not in your instance parameters. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Alavi Sent: Thursday, November 14, 2002 11:50 AM To: Multiple recipients of list ORACLE-L Dear List, I am monitoring a database, I findout there is a transaction which runing a long time and others are waiting for this transaction, this transaction have 8,000,000 consistant gets with only 1 Physical I/O. My question is, what I have to do except the SQL tuning to make this transaction faster, we have done all the necessary tuning on all the SQL query's. Here is a copy of ora.ini: Oracle 8.1.7.4 on sun solaris 2.8 background_dump_dest = /oracle/admin/cmstst/bdump compatible = 8.1.7.4 control_files = /cmsdb/cmstst/control02.ctl control_files = /oralogs1/cmstst/control03.ctl control_files = /oracle/oradata/cmstst/control01.ctl core_dump_dest = /oracle/admin/cmstst/cdump db_block_buffers = 1??? this need to increase? db_block_lru_latches = 4 db_block_size = 8192 db_file_multiblock_read_count = 16 db_name = cmstst hash_area_size = 2048000??? need tuning ??? instance_name = cmstst java_pool_size = 20971520 large_pool_size = 614400 log_archive_dest_1 = location=/archlogs/cmstst log_archive_format = arch%s.arc log_archive_start = TRUE log_buffer = 262144 ?? this log buffer is enough?? log_checkpoint_interval = 1 ?? log_checkpoint_timeout = 1800 max_enabled_roles = 30 open_cursors = 300 optimizer_index_caching = 90 optimizer_index_cost_adj = 35 os_authent_prefix = processes = 100 remote_login_passwordfile = EXCLUSIVE session_cached_cursors = 100 shared_pool_size = 134217728 sort_area_retained_size = 262144 sort_area_size = 262144 timed_statistics = TRUE I realy appreciate your help and assistant. I am getting confused, just want to know changing any of these parameter help the performance to reduce the number of CONSISTANT GETS or NOT??? Thanks in advance. Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: ini file
If you do not have enough memory, you will use swap memory, which will cause a lot of I/O, and you will not be able to see it on your database dictionary. later -Original Message- Sent: Thursday, November 14, 2002 12:59 PM To: Multiple recipients of list ORACLE-L Hi Again, Another question is, if i increase the following parameter is there any negative effective or not? 1) db_block_buffers = 1change to 2 2) hash_area_size = 2048000 change to 5120 5 M 3) log_buffer = 262144change to 5242880 5 M Thanks Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shao, Chunning INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Join Query Question
select a.poc_hrid,c.description from pocs a, poctypes b, pocgroups c where a.poctype_id = b.poctype_id and b.pocgroup_id = c.pocgroup_id; Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 12:30 PM To: Multiple recipients of list ORACLE-L Subject:Join Query Question All... I'm not even sure how to ask this question, but given three tables: pocs poc_id number primary key sn varchar2(32) poc_hrid varchar2(16) poctype_id number references poctypes(poctype_id) poctypes poctype_id number primary key tiernumber(2,0) description varchar2(64) pocgroup_id number references pocgroups(pocgroup_id) pocgroups - pocgroup_id number primary key description varchar2(16) I'm attempting to construct a single query that will provide the poc_hrid *AND* the pocgroup description to which that poc belongs. This is part of a web-based application which allows for many points-of-contact (e.g. SysAdmin, Apps, Network, etc.), but allows only members of a particular group to modify certain sections of the record. Any help will be greatly appreciated! Gary Chambers //-- // Lucent Technologies CIO/Servers/Unix // Senior Unix System Administrator // 4 Robbins Road, Westford, MA 01886 // 978-399-0481 / 888-480-6924 (Pager) // Nothing fancy and nothing Microsoft //-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gary Chambers INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: e: when is an error msg not an error msg ?
Hello, Thanks to all that replied. Yes, it was an environmental issue. The Pro*C program was being executed from cron without a wrapper, and cron being 'environmentally dumb' meant that, despite the environment being properly set for the user, the job was executed in a void. The developers will wrap the executable and all should be okay afterwards. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 9:49 AM To: Multiple recipients of list ORACLE-L This could happen when the ORACLE_HOME is not set correctly. You may have the ORACLE_HOME in the .profile but your application might be running from a script which unsets the ORACLE_HOME or sets it incorrectly. Hemanat At 02:14 PM 13-11-02 -0800, you wrote: Hello, I've looked over hill and over dale at many web-sites (MetaLink, google, asktom, etc.), to no avail, so could someone on the list bail me out on this question - what causes the following error message: ORACLE ERROR=Error while trying to retrieve text for error ORA-03114 Now, I know what causes the 03114; I need to know why I am getting the 'error while trying to retrieve... I get this error on my test and production servers, but not the development server. All have the same # of files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing somewhere that I know not of ? Any help would be greatly appreciated. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Monitoring Unix Question
Friends : How can i do for get what is running inside a PID that is using a lot of CPU ? How can I get the query that is running inside the database according PID of unix ? I would like to know commands of the unix and the query that i need to run in the database for find out the problem. Regards Eriovaldo --- UOL, o melhor da Internet http://www.uol.com.br/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ecandrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
renaming host
Is there any way to tell what connect string an application is using to connect to the database? I want to rename a host but I know some developers are going to forget to change their connect strings and I would like to catch them before we rename the box. My plan is to: o create a new cname for the host o create a new tnsalias based on the cname o Have developers reconnect using the new tnsalias o Monitor for any connections that still use the old connect string, and tell developers they still need to change their connect string. o Monitor again o Rename box o Have all applications connecting using the new name. Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: Metalink patch searches rant
All, I'm so frustrated that I had to rant to the list - my co-workers don't have much sympathy. I haven't been searching Metalink for patches in the last two weeks, but the new search functionality really sucks. When trying to search for Linux patches, I must put in Linux Operating System Family which promptly makes the ONLY release RedHat Advanced Server 2.0. Not right when I want to search certified SuSE SLES7 (or even if I had RedHat, 2.0 is only certified on 9i, not 8i!). Must mean there are only patches for RedHat 2.0 on 9i? Yeah, right. Urrgh! Plus, in the new Beta search, drop downs are a thing of the past - just about every field must be queried separately (those lovely pop-up windows), though supposedly the searches can be saved (haven't tried that yet, no reason to!). I'm sure there are tons of other limiting features to the new search, but I did get a huge laugh when I queried RDBMS 8.1.7 and got 500 patches returned (there are more but it only returned 500) - if you ever wanted an idea of how many patches are out there, there's a good indication. There's only 12 patchset/minipacks, though (lots of patches rolled into one, I guess). I did notice the new Beta search doesn't have an easily found feedback button (it's back on page one), but I did fill out a long gripe to them :) Enough ranting, back to trying to get around the search engines (both newly-fixed-old and new-Beta-2.0) to find the patches I need. Margaret -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Murray, Margaret INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
change global_name on 9i
Oracle 9.2.0 on Solaris 2.8 - I've got global_name = FALSE and db_domain = - however I mistakenly issued the command alter database rename global_name to instance.world, and now I cannot get rid of it. I've found the following on Metastink, but am wondering if there is any other method of getting the global_name back to instancename (without the .world) This problem doesn't happen in 9i because a value NULL for db_domain is allowed, therefore if you set in 9i db_domain=, then you have a GLOBAL_NAME with only db_name and you can rename global_name to include domain and after rename it back without including domain. Updating props$ manually is not a supported workaround. Any help would be appreciated. TIA, mb __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Michael Barger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Monitoring Unix Question
In V$PROCESS there is SPID (or something similar) which is the OS pid. Then, you can join to V$SESSION on ADDR / PADDR hth connor --- ecandrietta [EMAIL PROTECTED] wrote: Friends : How can i do for get what is running inside a PID that is using a lot of CPU ? How can I get the query that is running inside the database according PID of unix ? I would like to know commands of the unix and the query that i need to run in the database for find out the problem. Regards Eriovaldo --- UOL, o melhor da Internet http://www.uol.com.br/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ecandrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: e: when is an error msg not an error msg ?
You could just tell cron to execute your .profile before executing the pro*c program, thus you don't necessarily need a wrapper. -Original Message- Sent: Thursday, November 14, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Hello, Thanks to all that replied. Yes, it was an environmental issue. The Pro*C program was being executed from cron without a wrapper, and cron being 'environmentally dumb' meant that, despite the environment being properly set for the user, the job was executed in a void. The developers will wrap the executable and all should be okay afterwards. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 9:49 AM To: Multiple recipients of list ORACLE-L This could happen when the ORACLE_HOME is not set correctly. You may have the ORACLE_HOME in the .profile but your application might be running from a script which unsets the ORACLE_HOME or sets it incorrectly. Hemanat At 02:14 PM 13-11-02 -0800, you wrote: Hello, I've looked over hill and over dale at many web-sites (MetaLink, google, asktom, etc.), to no avail, so could someone on the list bail me out on this question - what causes the following error message: ORACLE ERROR=Error while trying to retrieve text for error ORA-03114 Now, I know what causes the 03114; I need to know why I am getting the 'error while trying to retrieve... I get this error on my test and production servers, but not the development server. All have the same # of files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing somewhere that I know not of ? Any help would be greatly appreciated. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: CONSISTANT GETS
Sorry for asking such a obvious question, but CONSISTANT GETS means calling rows from Database Thanks, -Original Message- Sent: Thursday, November 14, 2002 10:35 AM To: Multiple recipients of list ORACLE-L Hamid, I'm sorry: Unless your SQL returns fewer than about 800,000 rows to the calling application (or an aggregation of 800,000 rows), then the statement we have done all the necessary tuning on all the SQL queries is not yet true. If your SQL does actually return about 800,000 rows, then it is time to begin thinking about the mismatch between business processing requirements and the logical structure of your data. The answer to your problem is not in your instance parameters. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Alavi Sent: Thursday, November 14, 2002 11:50 AM To: Multiple recipients of list ORACLE-L Dear List, I am monitoring a database, I findout there is a transaction which runing a long time and others are waiting for this transaction, this transaction have 8,000,000 consistant gets with only 1 Physical I/O. My question is, what I have to do except the SQL tuning to make this transaction faster, we have done all the necessary tuning on all the SQL query's. Here is a copy of ora.ini: Oracle 8.1.7.4 on sun solaris 2.8 background_dump_dest = /oracle/admin/cmstst/bdump compatible = 8.1.7.4 control_files = /cmsdb/cmstst/control02.ctl control_files = /oralogs1/cmstst/control03.ctl control_files = /oracle/oradata/cmstst/control01.ctl core_dump_dest = /oracle/admin/cmstst/cdump db_block_buffers = 1??? this need to increase? db_block_lru_latches = 4 db_block_size = 8192 db_file_multiblock_read_count = 16 db_name = cmstst hash_area_size = 2048000??? need tuning ??? instance_name = cmstst java_pool_size = 20971520 large_pool_size = 614400 log_archive_dest_1 = location=/archlogs/cmstst log_archive_format = arch%s.arc log_archive_start = TRUE log_buffer = 262144 ?? this log buffer is enough?? log_checkpoint_interval = 1 ?? log_checkpoint_timeout = 1800 max_enabled_roles = 30 open_cursors = 300 optimizer_index_caching = 90 optimizer_index_cost_adj = 35 os_authent_prefix = processes = 100 remote_login_passwordfile = EXCLUSIVE session_cached_cursors = 100 shared_pool_size = 134217728 sort_area_retained_size = 262144 sort_area_size = 262144 timed_statistics = TRUE I realy appreciate your help and assistant. I am getting confused, just want to know changing any of these parameter help the performance to reduce the number of CONSISTANT GETS or NOT??? Thanks in advance. Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === Confidentiality Statement === The information
RE: dumping microsoft desktop?
Both answers a are expected to be No. The lawsuit is expected to be dropped. But who knows. They won antitrust case after all. Nick I know it *seems* like they won, but Microsoft actually lost the antitrust case. :-( Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: renaming host
David Turner wrote: Is there any way to tell what connect string an application is using to connect to the database? I want to rename a host but I know some developers are going to forget to change their connect strings and I would like to catch them before we rename the box. My plan is to: o create a new cname for the host o create a new tnsalias based on the cname o Have developers reconnect using the new tnsalias o Monitor for any connections that still use the old connect string, and tell developers they still need to change their connect string. o Monitor again o Rename box o Have all applications connecting using the new name. Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Turner INET: [EMAIL PROTECTED] If you do not change the alias, but keep the same alias pointing to the new host name, you do not have to worry ... -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:RE: CONSISTANT GETS
Hamid, This is one of those instances where I'll heartly agree with Cary in ALL respects. We run PeopleSoft and have found many a query that seems to spinn around and around creating a pile of consistent gets and little if any IO. The problem that most often exists is that a coorrelated subquery is the last item in the where clause or the first thing that Oracle does. Damned nasty. Check your code over again and trace it. Dick Goulet Reply Separator Author: Cary Millsap [EMAIL PROTECTED] Date: 11/14/2002 10:34 AM Hamid, I'm sorry: Unless your SQL returns fewer than about 800,000 rows to the calling application (or an aggregation of 800,000 rows), then the statement we have done all the necessary tuning on all the SQL queries is not yet true. If your SQL does actually return about 800,000 rows, then it is time to begin thinking about the mismatch between business processing requirements and the logical structure of your data. The answer to your problem is not in your instance parameters. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - 2003 Hotsos Symposium on OracleR System Performance, Feb 9-12 Dallas - Jonathan Lewis' Optimising Oracle, Nov 19-21 Dallas -Original Message- Alavi Sent: Thursday, November 14, 2002 11:50 AM To: Multiple recipients of list ORACLE-L Dear List, I am monitoring a database, I findout there is a transaction which runing a long time and others are waiting for this transaction, this transaction have 8,000,000 consistant gets with only 1 Physical I/O. My question is, what I have to do except the SQL tuning to make this transaction faster, we have done all the necessary tuning on all the SQL query's. Here is a copy of ora.ini: Oracle 8.1.7.4 on sun solaris 2.8 background_dump_dest = /oracle/admin/cmstst/bdump compatible = 8.1.7.4 control_files = /cmsdb/cmstst/control02.ctl control_files = /oralogs1/cmstst/control03.ctl control_files = /oracle/oradata/cmstst/control01.ctl core_dump_dest = /oracle/admin/cmstst/cdump db_block_buffers = 1??? this need to increase? db_block_lru_latches = 4 db_block_size = 8192 db_file_multiblock_read_count = 16 db_name = cmstst hash_area_size = 2048000??? need tuning ??? instance_name = cmstst java_pool_size = 20971520 large_pool_size = 614400 log_archive_dest_1 = location=/archlogs/cmstst log_archive_format = arch%s.arc log_archive_start = TRUE log_buffer = 262144 ?? this log buffer is enough?? log_checkpoint_interval = 1 ?? log_checkpoint_timeout = 1800 max_enabled_roles = 30 open_cursors = 300 optimizer_index_caching = 90 optimizer_index_cost_adj = 35 os_authent_prefix = processes = 100 remote_login_passwordfile = EXCLUSIVE session_cached_cursors = 100 shared_pool_size = 134217728 sort_area_retained_size = 262144 sort_area_size = 262144 timed_statistics = TRUE I realy appreciate your help and assistant. I am getting confused, just want to know changing any of these parameter help the performance to reduce the number of CONSISTANT GETS or NOT??? Thanks in advance. Hamid Alavi Office 818 737-0526 Cell818 416-5095 === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message
Urgent : Shell Script is needed !!!!!
Title: Blank Hello All, I have to do automation of manual process of the following things, being not good at the Shell scripting , I need your help or at least a sample script would be great Manual process: 1. get the oldest partition name from a partitioned table 2. create a non-partitioned table same as the oldest partition name from the partitioned table with the same structure 2. exchange the partition with the newly created table 3. then export the new table to a Unix directory. Later I have to drop the oldest partition .( For this we have a procedure to take care of ) Regards, Madhu Reddy Blank Bkgrd.gif
10046 Level 8 Trace file disappeared
After playing around with this in development for a while I just tried setting Event 10046, Level 8 trace on a production process that was taking too long to run. Everything went smoothly, the trace file was being written to, when suddenly the trace file disappeared. The last time I checked it was a little over 2 Meg but I had max file size set to 2 Gig. All the space was freed up according to df -k. I tried setting the event to level 0 and back to level 8 but there was still no trace file. The session was still running. Here's what I ran: exec sys.dbms_system.set_bool_param_in_session(265, 16097, 'timed_statistics', true); exec sys.dbms_system.set_int_param_in_session(265, 16097, 'max_dump_file_size', 2147483647); exec sys.dbms_system.set_ev(265,16097,10046, 8, ''); I'm on Oracle 8.1.7.2, Solaris 2.6. Does anyone have any ideas as to what might have happened to my file? Thanks, Jay Miller x48355 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Miller, Jay INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
WAIT EVENTS?
Hi, I have been noticing db file scattered read and db file sequential read with one of instance. Does increasing parameter DB_FILE_MULTIBLOCK_READ_COUNT would help or not? regarding db file sequential read what to do? without striping the files across the disk? A sequential read is a single-block read which read data into contiguous memory space. WIth another instance I am looking control file parallel write wait events. Does changing the location of control file would help? Thx -Seema _ Help STOP 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.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: dumping microsoft desktop?
Yes. They are, legally, a monopoly. Government has already apologized for all the nuisance that has created for Microsoft and promised to bring rebellious PC dealers to their senses by using special forces, if necessary. -Original Message- From: [EMAIL PROTECTED] [mailto:David.Schmoldt;gazettecommunications.com] Sent: Thursday, November 14, 2002 3:15 PM To: Multiple recipients of list ORACLE-L Subject: RE: dumping microsoft desktop? Both answers a are expected to be No. The lawsuit is expected to be dropped. But who knows. They won antitrust case after all. Nick I know it *seems* like they won, but Microsoft actually lost the antitrust case. :-( Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: dumping microsoft desktop?
Well, once upon a time there was an event called Boston Tea Party which dealt with too expensive product of low quality delivered by a monopoly. I wonder whether we can expect Seattle Windows Party? Would that be too cruel to the fish in Seattle harbor? -Original Message- From: [EMAIL PROTECTED] [mailto:dgoulet;vicr.com] Sent: Thursday, November 14, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: dumping microsoft desktop? David, Just like beauty, winning or loosing in a lawsuit is in the eye of the beholder. Actually in MicroSlop's case it was the justice department that bailed and more than likely King George who sat on the judge. You got to love those political action committees and their BIG donors!! In politics money talks louder than anything else. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 11/14/2002 12:15 PM Both answers a are expected to be No. The lawsuit is expected to be dropped. But who knows. They won antitrust case after all. Nick I know it *seems* like they won, but Microsoft actually lost the antitrust case. :-( Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Query to predict failure on second extent of segment
Hi all, Until a whole mass of astrological confluences happen, I'm stuck with dictionary-managed tablespaces on 8.1.7 on HP/UX 11.0. And we're having some space/growth issues right now that I want (need!) to be more proactive with. So, based on several factors -- most political -- I want to run a daily report that tells me when a segment will not be able to extend twice. (We're already running the single extent failure hourly.) After looking on the net, I found some queries to do this, but all I saw were severely flawed. So, I rolled my own. The only problem I can see with it for dictionary TSs is when the RANK() has multiple matches for first and second (e.g. TS MY_BIG_TS has it's largest contiguous free spaces of 40M, 10M, and 10M). Unfortunately, I'm stumped as to how to prevent this. Anyone care to comment on this load of SQueaL? Thx! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA SELECT ds.owner, ds.segment_name, ds.segment_type, ds.tablespace_name, ds.next_extent/1024 Next ext, fs2.max_free/1024 Max Free, fs2.min_free/1024 2nd Max Free, fs2.free_spaces FROM dba_segments ds, ( SELECT tablespace_name, MAX(bytes) max_free, MIN(bytes) min_free, count(*) free_spaces FROM ( SELECT tablespace_name, bytes, RANK() OVER (PARTITION BY tablespace_name ORDER BY tablespace_name, bytes DESC) byte_rank FROM dba_free_space ) WHERE byte_rank 3 GROUP BY tablespace_name ) fs2 WHERE ds.segment_type IN ('INDEX','TABLE') AND fs2.tablespace_name = ds.tablespace_name AND ( ((ds.next_extent fs2.min_free OR fs2.free_spaces 2) AND ds.next_extent*2 fs2.max_free) OR ds.next_extent fs2.max_free ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: dumping microsoft desktop?
David, Just like beauty, winning or loosing in a lawsuit is in the eye of the beholder. Actually in MicroSlop's case it was the justice department that bailed and more than likely King George who sat on the judge. You got to love those political action committees and their BIG donors!! In politics money talks louder than anything else. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 11/14/2002 12:15 PM Both answers a are expected to be No. The lawsuit is expected to be dropped. But who knows. They won antitrust case after all. Nick I know it *seems* like they won, but Microsoft actually lost the antitrust case. :-( Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Monitoring Unix Question
If you have the top utility installed on the Unix box, this makes an easy to use interface to identify CPU hogs. For non-root users to run it, your sys admin might have to change default permissions on certain files such as /dev/kmem; or possibly make top SUID root. If you don't have top, or you can't run it as non-root, you can try using the following ps command to sort things by %CPU, but I think there might be differences among OS's on some of the more exotic ps and sort options: ps -eo pid -o %cpu | sort -rk2 | head -20 After you have identified which PID is the hog, and can see that it is a dedicated server process, you can run something like the following to match SID SERIAL# to the correct OS process ID. If you must brutally kill the process, kill the session in the database, then kill the pid in the OS. set linesize whatever_you_like set pagesize whatever_you_like col username format a15 col osuser format a15 select s.username, s.osuser, s.sid, s.serial#, s.process USER PRCS, p.spid SVR PRCS from v$process p,v$session s where p.addr = s.paddr and s.username ' ' / -Original Message- From: ecandrietta [mailto:ecandrietta;uol.com.br] Sent: Thursday, November 14, 2002 1:20 PM To: Multiple recipients of list ORACLE-L Subject: Monitoring Unix Question Friends : How can i do for get what is running inside a PID that is using a lot of CPU ? How can I get the query that is running inside the database according PID of unix ? I would like to know commands of the unix and the query that i need to run in the database for find out the problem. Regards Eriovaldo --- UOL, o melhor da Internet http://www.uol.com.br/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ecandrietta INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent : Shell Script is needed !!!!!
Reddy, Madhusudana wrote: Hello All, I have to do automation of manual process of the following things, being not good at the Shell scripting , I need your help or at least a sample script would be great Manual process: 1. get the oldest partition name from a partitioned table 2. create a non-partitioned table same as the oldest partition name from the partitioned table with the same structure 2. exchange the partition with the newly created table 3. then export the new table to a Unix directory. Later I have to drop the oldest partition .( For this we have a procedure to take care of ) Regards, Madhu Reddy Hint : do most of it as a SQL script rather than a shell script. -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephane Faroult INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
NULL storage in CHAR fields
Hey all, In 8.1.7, does Oracle reserve (x) bytes for a CHAR(x) field if the field is NULL? A dev wants to NON NULL a key field, and I'd like to better be able to predict the effects on the table of inserting a space (indexes have already been considered). TIA! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
low buffer hit ratio
Hi. I found a query with a buffer hit ratio about 60%: SELECT b.Name, a.Racf, c.Manager, fileds from STATS table FROM BT.Stats a, BT.Employees b, BT.Employees c WHERE a.Stats_Date Between '13-Nov-02' and '13-Nov-02' and a.Manager = c.Manager and c.racf = 'RLEWI01' and b.Racf = a.Racf and ( Product='RTI' OR Product = 'RIM' ... or Product = 'WEB') Group by b.Name, a.Racf, c.Manager Order by b.Name Here is the plan under oracle 7.3.3 rbo: 1.0 SELECT STATEMENT (, , ) 2.1 SORT GROUP BY (, , ) 3.1 NESTED LOOPS (, , ) 4.1 NESTED LOOPS (, , ) 5.1 TABLE ACCESS BY ROWID EMPLOYEES (, , ) 6.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , ) 5.2 TABLE ACCESS BY ROWID STATS (, , ) 6.1 INDEX RANGE SCAN STATS_FK2 (, , ) 4.2 TABLE ACCESS BY ROWID EMPLOYEES (, , ) 5.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , ) The largest table is STATS - 1.6 mil rows. STATS_FK2 is an index on MANAGER field. We have only 115 different managers so the index is not very selective. The stats_date field is more selective. Does it make sence for me to force Oracle to use that index in order to reduce the number of disk reads? thanks Gene __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: combine or not combine into one database?
I send a e-mail to the address and get no respond so far. Any other solution? Thanks a lot. - Tao -Original Message- Sent: Tuesday, November 12, 2002 7:19 AM To: ORACLE-L Tao - I believe you send any mail to: mailto:lawson_sysadmin-subscribe;topica.com If that doesn't work, let me know. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Thanks a lot for you info. Do you know how I can subscribe the Lawson email list? Thanks again. -Original Message- Sent: Monday, November 11, 2002 2:59 PM To: ORACLE-L Tao - If I understand your situation, you currently have 3 separate databases, 2 separate Lawson databases and another OEM database? You can combine your two Lawson databases, but you'll need to develop a careful project plan. Right now your Lawson HR database probably sends data to your Lawson GL system, so that needs looked at before you do the combination. There is a Lawson email list that can answer that question in more detail. Is the OEM repository and historical database more of a data warehouse or OLTP system? Data warehouses tend to have spikey usage and don't play well with OLTP databases such as your Lawson system. I would tend to keep it separate just based on the limited information you've provided. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, November 11, 2002 11:04 AM To: Multiple recipients of list ORACLE-L Hi all, I would like to know any advantage and disadvantage to combine the following databases into one: Finance in Lawson HR in Lawson OEM repository and historical database Any comments are very appreciated. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for
RE: Urgent : Shell Script is needed !!!!!
Title: Blank Madhu Three years ago we wrote a system that would except files from an outside data system, take those files and , in a rotating 18 month cycle, load the data into a partitioned view dropping the oldest set of data and adding the next set in its place. Ifs complicated, but if you think you might be interested in looking thru it to make your own,I can find the SQL code and UNIX code that went with it. If you would be interested, contact me offline at [EMAIL PROTECTED] . I will need to take the time to find the code outside of work. Kevin -Original Message-From: Reddy, Madhusudana [mailto:[EMAIL PROTECTED]]Sent: Thursday, November 14, 2002 2:50 PMTo: Multiple recipients of list ORACLE-LSubject: Urgent : Shell Script is needed ! Hello All, I have to do automation of manual process of the following things, being not good at the Shell scripting , I need your help or at least a sample script would be great Manual process: 1. get the oldest partition name from a partitioned table 2. create a non-partitioned table same as the oldest partition name from the partitioned table with the same structure 2. exchange the partition with the newly created table 3. then export the new table to a Unix directory. Later I have to drop the oldest partition .( For this we have a procedure to take care of ) Regards, Madhu Reddy
RE: e: when is an error msg not an error msg ?
That's not always a good idea. Their may be settings in your .profile that don't play well with cron. Best to setup an account especially for cron jobs, and include only what is necessary in the .profile. Jared Richard Ji [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/14/2002 11:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: e: when is an error msg not an error msg ? You could just tell cron to execute your .profile before executing the pro*c program, thus you don't necessarily need a wrapper. -Original Message- Sent: Thursday, November 14, 2002 2:20 PM To: Multiple recipients of list ORACLE-L Hello, Thanks to all that replied. Yes, it was an environmental issue. The Pro*C program was being executed from cron without a wrapper, and cron being 'environmentally dumb' meant that, despite the environment being properly set for the user, the job was executed in a void. The developers will wrap the executable and all should be okay afterwards. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 9:49 AM To: Multiple recipients of list ORACLE-L This could happen when the ORACLE_HOME is not set correctly. You may have the ORACLE_HOME in the .profile but your application might be running from a script which unsets the ORACLE_HOME or sets it incorrectly. Hemanat At 02:14 PM 13-11-02 -0800, you wrote: Hello, I've looked over hill and over dale at many web-sites (MetaLink, google, asktom, etc.), to no avail, so could someone on the list bail me out on this question - what causes the following error message: ORACLE ERROR=Error while trying to retrieve text for error ORA-03114 Now, I know what causes the 03114; I need to know why I am getting the 'error while trying to retrieve... I get this error on my test and production servers, but not the development server. All have the same # of files in $ORACLE_HOME/rdbms/mesg. All are Oracle 8.1.7.4. Some file missing somewhere that I know not of ? Any help would be greatly appreciated. Thank you, Paul Sherman DBAElcom, Inc. voice - 781-501-4143 (direct #) fax- 781-278-8341 (secure) email - [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Hemant K Chitale My web site page is : http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hemant K Chitale INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed
Re: RE: How-To or Good Practices on Code Releases
You now have an excellent argument for disabling developer access to production databases. Jared chao_ping [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 11/14/2002 03:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: RE: How-To or Good Practices on Code Releases Rajesh.Rao, I have the same experience. Developers directly connected to production database and added a column with default table on a huge table. The whole table is locked for 1 hour and other transaction failed. Add a column with non default value and then later add default value for it can be done in 1 second. Developers do not Know how oracle do it and just go on. New application going online without volume testing, getting online and as a production dba,i search for the bad sql and trace it out and send it back to developer! That is why many project fail, the app is designed and developed without the attendence of a guy who really knows oracle. Regards zhu chao Eachnet DBA 86-21-32174588-667 [EMAIL PROTECTED] www.happyit.net www.cnoug.org(Chinese Oracle User Group) === 2002-11-13 12:06:00 ,you wrote£º=== I also have been burnt by an simple alter table add column default string script. A pretty simple script. The developers tested it, the QA team too approved it. Was expected to run in a matter of minutes. The problem was the data in production was 100 times over. Missed out on volume testing. Took 2 cuppas and 3 smokes before it was done. Raj Magaliff, Bill Bill.Magaliff@lenTo: Multiple recipients of list ORACLE-L ORACLE-L@fatcitS = = = = = = = = = = = = = = = = = = = = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: chao_ping INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RE: dumping microsoft desktop?
We just received a request from our CEO to do research on using Open Office or Star Office as an alternative to Microsoft Office for our non-power users. So maybe there is an ultimate justice that can't be bought out or voted in (like the anti-trust case). -Original Message- From: Gogala, Mladen [mailto:MGogala;oxhp.com] Sent: Thursday, November 14, 2002 3:39 PM To: Multiple recipients of list ORACLE-L Subject: RE: RE: dumping microsoft desktop? Well, once upon a time there was an event called Boston Tea Party which dealt with too expensive product of low quality delivered by a monopoly. I wonder whether we can expect Seattle Windows Party? Would that be too cruel to the fish in Seattle harbor? -Original Message- From: [EMAIL PROTECTED] [mailto:dgoulet;vicr.com] Sent: Thursday, November 14, 2002 3:44 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: dumping microsoft desktop? David, Just like beauty, winning or loosing in a lawsuit is in the eye of the beholder. Actually in MicroSlop's case it was the justice department that bailed and more than likely King George who sat on the judge. You got to love those political action committees and their BIG donors!! In politics money talks louder than anything else. Dick Goulet Reply Separator Author: [EMAIL PROTECTED] Date: 11/14/2002 12:15 PM Both answers a are expected to be No. The lawsuit is expected to be dropped. But who knows. They won antitrust case after all. Nick I know it *seems* like they won, but Microsoft actually lost the antitrust case. :-( Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: low buffer hit ratio
Gurelei - What do you mean by a low buffer hit ratio for a SQL statement? BHR is measured for the system, not for an individual query. Why have you singled this query out for attention? Are there complaints about its performance? Does it hit more blocks that other queries on your system? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, November 14, 2002 4:04 PM To: Multiple recipients of list ORACLE-L Hi. I found a query with a buffer hit ratio about 60%: SELECT b.Name, a.Racf, c.Manager, fileds from STATS table FROM BT.Stats a, BT.Employees b, BT.Employees c WHERE a.Stats_Date Between '13-Nov-02' and '13-Nov-02' and a.Manager = c.Manager and c.racf = 'RLEWI01' and b.Racf = a.Racf and ( Product='RTI' OR Product = 'RIM' ... or Product = 'WEB') Group by b.Name, a.Racf, c.Manager Order by b.Name Here is the plan under oracle 7.3.3 rbo: 1.0 SELECT STATEMENT (, , ) 2.1 SORT GROUP BY (, , ) 3.1 NESTED LOOPS (, , ) 4.1 NESTED LOOPS (, , ) 5.1 TABLE ACCESS BY ROWID EMPLOYEES (, , ) 6.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , ) 5.2 TABLE ACCESS BY ROWID STATS (, , ) 6.1 INDEX RANGE SCAN STATS_FK2 (, , ) 4.2 TABLE ACCESS BY ROWID EMPLOYEES (, , ) 5.1 INDEX UNIQUE SCAN EMPLOYEES_PK (, , ) The largest table is STATS - 1.6 mil rows. STATS_FK2 is an index on MANAGER field. We have only 115 different managers so the index is not very selective. The stats_date field is more selective. Does it make sence for me to force Oracle to use that index in order to reduce the number of disk reads? thanks Gene __ Do you Yahoo!? Yahoo! Web Hosting - Let the expert host your site http://webhosting.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gurelei INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Naming Conventions....
Hi all... What are the naming conventions u guys follow when designing a database ???.Can anybody send me a general document on this. I am trying to make the attribute name unique in my database but i dunno what naming convention i have to follow for this .. I have tried all kinda combinations but some how the names are not coming unique and because of this the developers may get confused know ... so please tell me what naming convention are followed by u DBA s Thanks Shibu