Incremental Checkpoint
Dear Guru's Have a question. Does a incremental checkpoint update the datafile header with the SCN?. My understanding is that it doesn't update the datafile header but only updates the controlfile with the SCN and the datafile header is updated only during a full checkpoint Is my understanding correct? Best Regards Sriram Kumar DISCLAIMER: This message contains privileged and confidential information and is intended only for the individual named.If you are not the intended recipient you should not disseminate,distribute,store,print, copy or deliver this message.Please notify the sender immediately by e-mail if you have received this e-mail by mistake and delete this e-mail from your system.E-mail transmission cannot be guaranteed to be secure or error-free as information could be intercepted,corrupted,lost,destroyed,arrive late or incomplete or contain viruses.The sender therefore does not accept liability for any errors or omissions in the contents of this message which arise as a result of e-mail transmission. If verification is required please request a hard-copy version. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 8.1.7 can only use the first 15th indexes?
drop table t1; create table t1 nologging pctfree 50 pctused 50 as select 1 n01, 1 n02, 1 n03, 1 n04, 1 n05, 1 n06, 1 n07, 1 n08, 1 n09, 1 n10, 1 n11, 1 n12, 1 n13, 1 n14, 1 n15, rownum n16, lpad(rownum,10) v1 from all_objects ; create index i01 on t1(n01); create index i02 on t1(n02); create index i03 on t1(n03); create index i04 on t1(n04); create index i05 on t1(n05); create index i06 on t1(n06); create index i07 on t1(n07); create index i08 on t1(n08); create index i09 on t1(n09); create index i10 on t1(n10); create index i11 on t1(n11); create index i12 on t1(n12); create index i13 on t1(n13); create index i14 on t1(n14); create index i15 on t1(n15); create index i16 on t1(n16); analyze table t1 estimate statistics; set autotrace traceonly explain; select v1 from t1 where n16 = 99; set autotrace off The execution path uses I16 on my system. It would be possible to produced test cases that failed to use the 16th index, of course, and some of them could look quite convincingly as if the 16th index should be used. But it only takes one counter-example ... (I assume the report intended to say the first 15 indexes on a specific table, 'cos the data dictionary alone has rather more than 15 indexes). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 6:19 AM Hello again, I've just been reading a report for one of our systems and it says that Oracle 8.1.7 will only use the first 15 indexes created. Any index created after the 15th will be ignored unless specified via a hint. Is this correct? I haven't heard of this before. TIA, Leng. -- Leng Kaing Email: [EMAIL PROTECTED] Phone: +61-3-9203-7589 Mobile: +61-417-371-348 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kaing, Leng 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.net -- Author: Jonathan Lewis 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).
Defragmenting a RAID 5 volume?
Hello people, We recently experienced a hang in our database server, WIN2k Advanced server with raid 5 for Oracle 817 database files. Examining the perf logs showed that Event 2022 caused the hang: Event ID: 2022 Source: Srv Description: Server was unable to find a free connection 144 times in the last 60 seconds. After I examined the alert log, I saw an object trying to extend but fails because the DBF ran out of space. This happened on the time/instance that the server started to stop responding. The DBF is supposed to extend because it is configured to AUTOEXTEND. The available disk space isn't also supposed to constrain the DBF's extension of 64MB, free space of 9+ GB could still accomodate this, obviously. More importantly, this can happen without crashing the server. According to Microsoft's website (http://support.microsoft.com/default.aspx?scid=kb;en-us;245077), possible resolutions are to defragment the disk or allocate more disk space. Disk space is not much of an issue because the volume still has 9+ GB. My question is, can a RAID 5 volume be defragmented? Is it sane, technically? The volume is 130GB in size... Best regards, Rhojel
Re: Unusable partition index -- working funny
It's probably the case that the trigger fires the first time - but at parse/optimise time Oracle had already determined the sequence of actions needed to execute the statement based on the then session state, so that sequence is played out, irrespective of the fact that you changed the session state in the middle of the sequence. By analogy, consider an update to an updatable join view which defaults to using a hash join. If you create a before row update trigger to disable hash joins, would you expect Oracle to not do a hash join the first time the statement executes ? Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 12:19 AM Hello All, I have a strange problem... I have a table on which i am doing an update. Its a partition table and the local index on the column which is being updated is in an unusable state. I have a database trigger at statement level (before update of col_a for ) where i do an execute immediate ' alter session set skip_unusable_indexes = true'; i log into sqlplus as the owner of the table and do the following SQL connect [EMAIL PROTECTED] Enter password: ** Connected. SQL UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY = 1 where 2 mortgage_loan_key = 1 and period_key = '30-JUN-03'; UPDATE nevadmin.DM_MORTGAGE_LOAN_HIST SET ORIGINATION_SOURCE_KEY = 1166444 where * ERROR at line 1: ORA-01502: index 'NEVADMIN.DM_MORTGAGE_LOAN_HIST_BK13' or partition of such index is in unusable state SQL / 1 row updated. -- - My question is why does the trigger not fire for the first time... When i do the / i am able to update the table which means the trigger is firing the 2nd time. Any help would be greatly appriciated.. thanks, sathish. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Defragmenting a RAID 5 volume?
Hi Rhojel Tjeck out: http://www.baarf.com/ Rgds, Frank - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 21, 2004 9:04 AM Subject: Defragmenting a RAID 5 volume? Hello people, We recently experienced a hang in our database server, WIN2k Advanced server with raid 5 for Oracle 817 database files. Examining the perf logs showed that Event 2022 caused the hang: Event ID: 2022Source: Srv Description: Server was unable to find a free connection 144 times in the last 60 seconds. After I examined the alert log, I saw an object trying to extend but fails because the DBF ran out of space. This happened on the time/instance that the server started to stop responding. The DBF is supposed to extend because it is configured to AUTOEXTEND. The available disk space isn't also supposed to constrain the DBF's extension of 64MB, free space of 9+ GB could still accomodate this, obviously. More importantly, this can happen without crashing the server. According to Microsoft's website (http://support.microsoft.com/default.aspx?scid=kb;en-us;245077), possible resolutions are to defragment the disk or allocate more disk space. Disk space is not much of an issue because the volume still has 9+ GB. My question is, can a RAID 5 volume be defragmented? Is it sane, technically? The volume is 130GB in size... Best regards, Rhojel
Re: FW: Disk capacity planning
Mladen, I agree you can measure how many IOs are being done and how many a disk sub- system, such as those provided by EMC, can perform and still give good performance. What I meant is that it is hard and some would say impossible to estimate how many IOs per sec a new application will do. A combination of paper calculations, testing, experience and looking at comparable systems will help to provide a good estimate. Cheers, Chris Quoting Mladen Gogala [EMAIL PROTECTED]: Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os per second can they perform and they even have tools to measure it. Speaking of monitoring I/O, there used to be an old OS, which is mostly dead today and it used to have command monitor io/item=queue which would show length of the I/O queues per device, which was extremely useful, because you could quickly find out which devices are hot and which are not. On 2004.01.20 04:19, [EMAIL PROTECTED] wrote: Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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
Re: Oracle 8.1.7 can only use the first 15th indexes?
Let's be realistic: any table with 15 indexes PROBABLY needs a little bit of a re-design exercise? ;) Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - snip (I assume the report intended to say the first 15 indexes on a specific table, 'cos the data dictionary alone has rather more than 15 indexes). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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 8.1.7 can only use the first 15th indexes?
The first 15 indexes CREATED? Joking, are they? Cheers Nuno Souto [EMAIL PROTECTED] - Original Message - I've just been reading a report for one of our systems and it says that Oracle 8.1.7 will only use the first 15 indexes created. Any index created after the 15th will be ignored unless specified via a hint. Is this correct? I haven't heard of this before. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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 8.1.7 can only use the first 15th indexes?
Data warehouse with bitmap indexes ? But in OLTP I would assume guilty until proven innocent. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 9:44 AM Let's be realistic: any table with 15 indexes PROBABLY needs a little bit of a re-design exercise? ;) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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).
bind variables in VB using OO4O
Does anyone have examples of how to use bind variables in VB when using OO4O? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Dunn 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 : Happy Spring Festival
... to whomever is concerned ... Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: ORA-904 after table rename
When required I did it through a logon trigger ... wait I still do it. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Tuesday, January 20, 2004 4:25 PM To: Multiple recipients of list ORACLE-L One thing I've been looking for is a way to set a string parameter in another session, The two you mention handle INTEGER and BOOLEAN. I want a way to set TRACEFILE_IDENTIFIER to a string in another session to make it easier to identify trace files. Any ideas? Stephen -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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).
9iAS Calender Servlet
Does anybody by chance have any examples for creating a calender servlet for 9iAS? I have to admit to being a servlet virgin! ;) Any pointers much apreciated! Many thanks Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: tnsnames.ora not working ?
I've seen this sort of thing happen when you have more than one Oracle_Home and client tools get confused about which tnsnames.ora file to use. Fastest solution is to find every tnsnames.ora file on the client computer and make sure that they are all identical. Correct solution is usually to make sure that there is only one set of network control files and set the TNS_ADMIN environment variable to point at the one and only directory that contains them. I've sometimes had to deinstall all copies of Oracle Net tools and reinstall just one. -Original Message- Sent: Tuesday, January 20, 2004 10:49 AM To: Multiple recipients of list ORACLE-L Hello, I'm trying to add description in my $ORACLE_HOME/network/admin/tnsnames.ora, but it seems that the client (ie. sqlplus) wont use it. Whenever I try to connect to the service using sqlplus, I got : $ sqlplus Enter user-name: [EMAIL PROTECTED] Enter password: * ORA-12154: TNS:could not resolve service name I tried to add the description to my ~/.tnsnames.ora too with no luck. The entry in the tnsnames.ora is: DEV_DB = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = hostname)(PORT = 1521)) ) (CONNECT_DATA = (SERVICE_NAME = dev_db) ) ) (note: I removed the real hostname for privacy/security reason of course) However, when I use sqlplus using the following way: $ sqlplus Enter user-name: developer@(description=(address=(protocol=tcp)(host=hostname)(PORT = 1521))(CONNECT_DATA =(SERVICE_NAME = dev_db))) Enter password: * It would work, where all the information from the description is just a copy-paste from the tnsnames.ora file. Is there anything I overlook? Sorry if this is kinda a newbie question. I'm still learning my way around this. I'm using Oracle9i on Redhat Linux. Thanks for any help. Reuben D. Budiardja -- Reuben D. Budiardja Department of Physics and Astronomy The University of Tennessee, Knoxville, TN - To be a nemesis, you have to actively try to destroy something, don't you? Really, I'm not out to destroy Microsoft. That will just be a completely unintentional side effect. - Linus Torvalds - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Reuben D. Budiardja 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.net -- Author: John Flack 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).
Has anyone done any scalability work on dbms_lock?
As in: does it present an inherent or hidden performance problem when a lot of sessions try to lock/release the same lock? Or how many lock/release per second. Or some other idea of how efficient it is? Need to use it in a design, but not sure of any potential performance hits or scalability issues. Any ideas? TIA. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: bind variables in VB using OO4O
Hi John , i have mailed a doc . have a look at it . Regards, Prem. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Does anyone have examples of how to use bind variables in VB when using OO4O? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna 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: how do I interpret this in bstat/estat
Gene, I strongly recommend implementing Statspack. It is very straight-forward. Just do it when you have exclusive use of the database, or comment out the following two lines in ora_rdbms_admin:SPCUSR.SQL if you have these packages already installed. (We're running 8.1.7 on VMS. The filenames might be different on your platform, but the documentation gives lots of detail.) --@@dbmspool --@@dbmsjob The docs neglected to mention that it was going to recreate DBMSPOOL and DBMSJOB, even thought they were already installed. This invalidated everything that depends on those two packages! Yet another way to hang your production instance! Nelson -Original Message- Sent: Tuesday, January 20, 2004 5:04 PM To: Multiple recipients of list ORACLE-L Hi. I am looking at the bstat/estat report and see a high number of enqueue timeouts in the statistics section of the report. How do I tackle that? In the Niemec's book he receoomends increasing the enqueue_resources parameter. Metalink says that these may be related to DISTRIBUTED_LOCK_TIMEOUT being exceeded in a distributed transaction. Comments about changing ENQUEUE_RESOURCES are ill-founded. But it doesn't make any recommendations. So my question is whether anyone has any practical suggestions what I can do to address this issue. I am running Oracle 9203 (yes, I should be usuns the statspack, but I haven't switched to it yet). TIA Gene __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- 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: Has anyone done any scalability work on dbms_lock?
As in: does it present an inherent or hidden performance problem when a lot of sessions try to lock/release the same lock? Will serialize perfectly! Or how many lock/release per second. Or some other idea of how efficient it is? Depends on the work done between acquiring the lock and releasing it. Need to use it in a design, but not sure of any potential performance hits or scalability issues. Any ideas? When sessions acquire the same lock (as asked), only one session can do the work in a given moment. So, it doesn't scale. There will be overhead, but that also is relative to the duration of the work done while the lock is held. Maybe AQ can help, by doing the work asynchronously in the background and so lift the serialization from the primary proces(ses)? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === TIA. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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.net -- Author: Carel-Jan Engel 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: Has anyone done any scalability work on dbms_lock?
On a light-weight test on 8.1.7.4 at 700MHz on W2000 - About 15,000 request/release per second if you are using an ID About 8,000 request/release per second if you are using a pre-allocated lock handle About 800 request/release per second if you have to allocate_unique on every request. Bear in mind that each request or release will hit the enqueue latch a couple of times, so you could get contention for the latch in the two high-speed options. (Forget the low-speed option, allocate_unique does a commit in mid-stream, which you might be able to hide with a recursive transaction - but the overheads are extreme). Bottom line - for high-speed OLTP type of work, I don't think you will get away with more than a dozen request/release cycles per transaction. Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 12:49 PM As in: does it present an inherent or hidden performance problem when a lot of sessions try to lock/release the same lock? Or how many lock/release per second. Or some other idea of how efficient it is? Need to use it in a design, but not sure of any potential performance hits or scalability issues. Any ideas? TIA. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: Does SQL Server have a wait interface?
anyone know? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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: Has anyone done any scalability work on dbms_lock?
i think expert one on one has some comments on it. Its in a section referring to building your own insert locks. So if a table is locked, the user gets notified. I read the book last year. From: Nuno Souto [EMAIL PROTECTED] Date: 2004/01/21 Wed AM 07:49:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Has anyone done any scalability work on dbms_lock? As in: does it present an inherent or hidden performance problem when a lot of sessions try to lock/release the same lock? Or how many lock/release per second. Or some other idea of how efficient it is? Need to use it in a design, but not sure of any potential performance hits or scalability issues. Any ideas? TIA. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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.net -- Author: [EMAIL PROTECTED] 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: Has anyone done any scalability work on dbms_lock?
nuno-- what level are you trying to scale it to? how long will you hold the locks? I used it last year because only one process could run at a time. seemed to have similiar over head to 'select for update'. If you look at the PL/SQL Packages book by Fuerstein et al(not a real popular book, but I like it)... there is a nifty wrapper for DBMS_LOCK. I based my code off of that. From: Carel-Jan Engel [EMAIL PROTECTED] Date: 2004/01/21 Wed AM 08:24:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: Has anyone done any scalability work on dbms_lock? As in: does it present an inherent or hidden performance problem when a lot of sessions try to lock/release the same lock? Will serialize perfectly! Or how many lock/release per second. Or some other idea of how efficient it is? Depends on the work done between acquiring the lock and releasing it. Need to use it in a design, but not sure of any potential performance hits or scalability issues. Any ideas? When sessions acquire the same lock (as asked), only one session can do the work in a given moment. So, it doesn't scale. There will be overhead, but that also is relative to the duration of the work done while the lock is held. Maybe AQ can help, by doing the work asynchronously in the background and so lift the serialization from the primary proces(ses)? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) === TIA. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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.net -- Author: Carel-Jan Engel 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.net -- Author: [EMAIL PROTECTED] 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: All packages under sys is invalid
Either re-run catproc or try with utlirp. On 01/20/2004 12:44:34 PM, Hamid Alavi wrote: so what's the solution? -Original Message- Sent: Tuesday, January 20, 2004 4:10 AM To: Multiple recipients of list ORACLE-L Someone is messing with standard package ... so it would seem. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, January 19, 2004 5:01 PM To: Multiple recipients of list ORACLE-L All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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.net -- 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.net -- Author: Mladen Gogala 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: Has anyone done any scalability work on dbms_lock?
- Original Message - Or how many lock/release per second. Or some other idea of how efficient it is? Depends on the work done between acquiring the lock and releasing it. Not really. I'm asking how many lock/releases can be done before the thing starts putting a serious load on the system. And if the load it imposes is linear. When sessions acquire the same lock (as asked), only one session can do the work in a given moment. So, it doesn't scale. There will be overhead, but that also is relative to the duration of the work done while the lock is held. So, the overhead is MOL linear? Ie, if the amount of work is very small and the number of requests is very high, nothing is gonna suddenly go South? Maybe AQ can help, by doing the work asynchronously in the background and so lift the serialization from the primary proces(ses)? The work is very small indeed. No need to background anything. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: All packages under sys is invalid
Is sombebody playing with Statspack (spcreate.sql)? One piece of the install runs dbmspool.sql Nelson -Original Message- Sent: Tuesday, January 20, 2004 3:59 PM To: Multiple recipients of list ORACLE-L So what's the recommendation, how can I recompile all the SYS packages? -Original Message- Sent: Tuesday, January 20, 2004 10:10 AM To: Multiple recipients of list ORACLE-L Either that or someone ran dbmspool.sql out of ORACLE_HOME/rdbms/admin. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Tuesday, January 20, 2004 12:45 PM To: Multiple recipients of list ORACLE-L so what's the solution? -Original Message- Sent: Tuesday, January 20, 2004 4:10 AM To: Multiple recipients of list ORACLE-L Someone is messing with standard package ... so it would seem. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Monday, January 19, 2004 5:01 PM To: Multiple recipients of list ORACLE-L All, I have an strange problem, most of the packages under SYS user are invalid when I compile it it's compile without error but when I back again the package still is invalid, anybody have any idea? Thanks in advance Hamid Alavi Office : 818-737-0526 Cell phone : 818-416-5095 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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.net -- 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.net -- Author: Goulet, Dick 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.net -- 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
RE: Re[2]: Oracle vs Mysql
I was using Lattice-C on x286. Igor Neyman, OCP DBA [EMAIL PROTECTED] -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Carel-Jan Engel Sent: Tuesday, January 20, 2004 5:29 PM To: Multiple recipients of list ORACLE-L Subject: Re: Re[2]: Oracle vs Mysql At 03:29 PM 1/20/2004, you wrote: I do indeed. Rumor was that rpt/rpf was written by Larry himself. Now I understand! I once applied for a job at Oracle, and got asked: What do you think about RPT/RPF. My answer: Probably som hobby-project of one or another developer, which, after demonstration to his boss, was turned into a product. That was a disloyal remark, even in Holland, and I wasn't hired. Anyone used HLI, with Lattice-C? Regards, Carel-Jan === If you think education is expensive, try ignorance. (Derek Bok) ===
Re: AQ
Thanks, Tanel. Sorry, if I caused any confusion. May be I should have used 'pipe get' event instead of 'SQL*Net message from client' as an example, which of course, should not be ignored in a multi-tier, networked environment. In fact, I remove it, among a few others, from PERFSTAT.STAT$IDLE_EVENT table, when if, I use Statspack.. Cheers! - Kirti --- Tanel Poder [EMAIL PROTECTED] wrote: Hi! I think what Kirti meant here, is that from only database's point of view (scope), the SQL*Net message from client waits do not indicate any database bottlenecks. Anyway, when you have network bottleneck, from my experience you usually see other SQL*Net message waits, like more data to/from client etc as well. Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 6:39 PM However... do not blindly treat SQL*Net messages as Idle waits. They can be important indicators of networking issues. Stephen [EMAIL PROTECTED] 01/20/04 08:24AM It is defined as below in the Reference Guide: The session is waiting on an empty OLTP queue (Advanced Queuing) for a message to arrive so that the session can dequeue that message. I would treat it as an Idle Wait, similar to, SQL*Net message from client. - Kirti --- Ehresmann, David [EMAIL PROTECTED] wrote: Is queue message an idle or an non-idle wait event? I have looked through the docs at tahti and metalink and can't find much info on AQ. Does anybody know where there are resources on this topic? thanks, David Ehresmann -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: pga_aggregate_target and a memory leak
Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO' workarea_size_policy... seems to run okay... - Kirti --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful with pga_aggregate_target. I have very recently seen a case (Solaris + 9.2 but I cant't tell you exactly which patch level - probably the most recent) where two (by the way atrocious) queries generated by a DSS tool were responding very differently - and in a way that differences in the queries couldn't explain. From an Oracle standpoint, stats were roughly the same. Tracing proved that we were waiting for CPU, and truss that a call to mmap() was the culprit. Why, no idea. We first switched it (pga_thing) off, no more slow call to mmap(). However, it was still slow because we hadn't checked sort_area_size which was ridiculously small. We set sort_area_size to 10M, still with pga_aggregate_target unset, and once again the same very slow calls to mmap(). Memory misalignment? Anything else? Not much time to enquire but it looks like a mine field. -- Regards, Stephane Faroult Oriole Software -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: Has anyone done any scalability work on dbms_lock?
- Original Message - On a light-weight test on 8.1.7.4 at 700MHz on W2000 - About 15,000 request/release per second if you are using an ID sounds plenty good to me. Thanks a lot. Bear in mind that each request or release will hit the enqueue latch a couple of times, so you could get contention for the latch in the two high-speed options. OK. Will look out for these just in case. Bottom line - for high-speed OLTP type of work, I don't think you will get away with more than a dozen request/release cycles per transaction. Not a worry, it's a workflow app. A few users but not much load, a little volume. I just need to make sure a given sequence of operations is not undertaken by more than one user per group (one lock/group) and a table lock is way too heavy to do this. Forms 9i, so it's not easy to fudge it with a C exit and I don't like servlets. Much better if I can do the lot in PL/SQL. Thanks again. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Has anyone done any scalability work on dbms_lock?
- Original Message - nuno-- what level are you trying to scale it to? Not much. A few hundred users, maybe 20 or so may need the lock. However, this app may explode in # users, so I want to make sure I'm not creating a monster. how long will you hold the locks? only long enough to pass a key to a servlet. I used it last year because only one process could run at a time. That's what I want, one process per lock. seemed to have similiar over head to 'select for update'. That's weird? I thought it didn't involve table access? If you look at the PL/SQL Packages book by Fuerstein et al(not a real popular book, but I like it)... there is a nifty wrapper for DBMS_LOCK. I based my code off of that. Ah yes, I know the book. May not be popular, but I used it a lot a while ago and it's solid. Thanks, will look that up. Cheers Nuno Souto [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nuno Souto 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: Has anyone done any scalability work on dbms_lock?
if it is single instance you could also use global application contexts ... (alas they don't work in RAC across node) ... Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- Sent: Wednesday, January 21, 2004 9:10 AM To: Multiple recipients of list ORACLE-L - Original Message - On a light-weight test on 8.1.7.4 at 700MHz on W2000 - About 15,000 request/release per second if you are using an ID sounds plenty good to me. Thanks a lot. Bear in mind that each request or release will hit the enqueue latch a couple of times, so you could get contention for the latch in the two high-speed options. OK. Will look out for these just in case. Bottom line - for high-speed OLTP type of work, I don't think you will get away with more than a dozen request/release cycles per transaction. Not a worry, it's a workflow app. A few users but not much load, a little volume. I just need to make sure a given sequence of operations is not undertaken by more than one user per group (one lock/group) and a table lock is way too heavy to do this. Forms 9i, so it's not easy to fudge it with a C exit and I don't like servlets. Much better if I can do the lot in PL/SQL. Thanks again. Cheers Nuno Souto [EMAIL PROTECTED] ** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. **4 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jamadagni, Rajendra 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).
[no subject]
HELP
Re: Defragmenting a RAID 5 volume?
On 01/21/2004 03:04:26 AM, [EMAIL PROTECTED] wrote: GB. My question is, can a RAID 5 volume be defragmented? Is it sane, technically? The volume is 130GB in size... You are defragmenting a file system, not a volume. Block based file systems cannot be defragmented, only extent-based file systems can. Block based file systems like UFS or SYSV-1K FS do not have extents, which means that the word fragmentation doesn't make sense. You have superblock, inodes and data blocks. You don't have extents. AFAIK NTS is an extent-based file system and it can be defragmented. It is questionable, however, what will you gain by defragmenting. If your files have n extents, their extent maps are cached in memory and need not to be re-read each time you access files. Hopefully, you're not using an NT system for DW, which means that your I/O pattern consists of random reads/writes, few blocks at a time. Fragmentation hurts you when you are doing frequent multiblock reads which are split into several I/O requests instead of being satisfied by a single large one. As defragmenter moves file extents around, database cannot be accessed, which essentially means that you must shut down the instance or it will hang. I don't know how much will you gain, but yes, you can defragment 130GB file system, even if it's on a Rabid Array of Inefficient Disks. As they say, size doesn't matter, it's the magic in the disk. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Parallel Query determined by?
I could not find an Oracle wait event named 'Parellel Sync Wait' (in v$event_name view in 7.3.4, 8.1.7.4, 9.2.0.4). Precise may be calling something else a 'Parallel Sync Wait', or is smart enough to figure this out when it seems Oracle isn't instrumented for this particular wait(?). Just pondering... Does Presice on-line help have any mention of this wait? Have you contacted Precise Tech Support? - Kirti --- [EMAIL PROTECTED] wrote: No other replies yet, so here goes. First of all, what does it really mean when you say: users are complaining that Precise is showing a whole lot of time in Parallel Sync Wait. Are these end users, or developers? Seems rather curious that users would be mentioning this. Second, what % of wait time do the Sync Waits contribute to? If a small % of total, then there's not much point in spending time on it. Third, is this actually causing a performance problem, or is it just appearing as a 'trouble' item on some monitor? Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/20/2004 11:29 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Parallel Query determined by? I've inherited a system that has a whole lot of indexes set to degree 10 and many tables set to 2 4. The users are complaining that Precise is showing a whole lot of time in Parallel Sync Wait. It is an HP box running 8.1.7.4 with 16 processors. The box is normally not very busy. Are there various init.ora settings that help the Parallel servers sync up, or is this just too high a setting? I'm suggesting we back of a good many of these things to simply 2 or 4 and then work our way up from there. Some of those indexes set to 10 are only 20 meg and 4 extents. There's no way they are getting 10 on that I would think. Can't find a whole lot on Metalink either. Or a good book on 800 gig warehouses using parallel? -- 13308 Thornridge Ct Midlothian, VA 23112 804-744-1545 __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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:
Title: Message must.resist..temptation. For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. Live long and prosper. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ashish SahasrabudheSent: 21 January 2004 14:34To: Multiple recipients of list ORACLE-LSubject: HELP
ORA-28575: RPC connection with external procedure cannot opened
Hi DBAs, Here is my situation, I'm running Oracle8174 on Solaris. We are using an external procedure called in my pl/sql. I'll give you my example: I will use the Oracle example DEBUG_EXTPROC I'm on the Unix server and I connect with SQLPLUS, without the listener SQL connect c$mdlimol2 Enter password: Connected. SQL execute debug_extproc.startup_extproc_agent; PL/SQL procedure successfully completed. SQL Everything goes fine But when I connect with the listener SQL connect [EMAIL PROTECTED] Enter password: Connected. SQL execute debug_extproc.startup_extproc_agent; ERROR at line 1: ORA-28575: unable to open RPC connection to external procedure agent ... So the problem could be the listener ... But if a try TNSPING extproc_connection_data, I got OK Here is the copy of my listener file SID_LIST_EXTPROCLISTENER = (SID_LIST = (SID_DESC = (SID_NAME = PLSExtProc) (ORACLE_HOME = /disk1/app/oracle/product/8.1.7) (PROGRAM = /disk1/app/oracle/product/8.1.7/bin/extproc) ) ) EXTPROCLISTENER = (DESCRIPTION_LIST = (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) ) ) And tnsnames EXTPROC_CONNECTION_DATA.CAMRD.ASTRAZENECA.NET= (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC0)) ) (CONNECT_DATA = (SID = PLSExtProc) (PRESENTATION = RO) (SRVR = DEDICATED) ) ) I'm not using MTS Thank you for you help Luc - Luc Demanche AstraZeneca RD Montreal Oracle Database Administrator 514.832.3200 x2356 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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[2]: Oracle vs Mysql
yup Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Carel-Jan Engel [mailto:[EMAIL PROTECTED]Sent: Tuesday, January 20, 2004 5:29 PMTo: Multiple recipients of list ORACLE-LSubject: Re: Re[2]: Oracle vs MysqlAt 03:29 PM 1/20/2004, you wrote: I do indeed. Rumor was that rpt/rpf was written by Larry himself.Now I understand! I once applied for a job at Oracle, and got asked: What do you think about RPT/RPF. My answer: Probably som hobby-project of one or another developer, which, after demonstration to his boss, was turned into a product. That was a disloyal remark, even in Holland, and I wasn't hired. Anyone used HLI, with Lattice-C? Regards, Carel-Jan===If you think education is expensive, try ignorance. (Derek Bok)===
Re: OT : Happy Spring Festival
On 01/21/2004 07:20:00 AM, Stephane Faroult wrote: ... to whomever is concerned ... Regards, Stephane Faroult Oriole Spring??? What is spring? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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:
Title: Message Funny ...Ashish is from "Weight Watchers" and asking for HELP my advise ... stop starving yourself ... go eat something. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 9:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: must.resist..temptation. For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. Live long and prosper. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ashish SahasrabudheSent: 21 January 2004 14:34To: Multiple recipients of list ORACLE-LSubject: HELP
Re: Has anyone done any scalability work on dbms_lock?
Note in-line Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - Not a worry, it's a workflow app. A few users but not much load, a little volume. I just need to make sure a given sequence of operations is not undertaken by more than one user per group (one lock/group) and a table lock is way too heavy to do this. Sounds like you just need each user to call allocate_unique on startup to get a group-specific handle, then do a request in exclusive mode before doing the job and a release on completion. Users will then naturally queue and resume with minimum lost time. You could probably do the thing just as easily by issuing a select for update against a group-id row in a table - but dbms_lock makes it easier because it can bypass the normal commit activity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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: 9iAS Calender Servlet
I did a quick and dirty one in pl/sql. No security, or checks on content yet though. I'd be more than happy to send it to you. It might be kind of ugly...i've not done a ton of coding. (something I am actively working on. Let me know, Chris -Original Message- Sent: Wednesday, January 21, 2004 6:45 AM To: Multiple recipients of list ORACLE-L Does anybody by chance have any examples for creating a calender servlet for 9iAS? I have to admit to being a servlet virgin! ;) Any pointers much apreciated! Many thanks Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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 : Happy Spring Festival
Title: RE: OT : Happy Spring Festival At least you probably have a warm fuzzy feeling about your Patriots going to the supberbowl. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 21, 2004 8:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT : Happy Spring Festival On 01/21/2004 07:20:00 AM, Stephane Faroult wrote: ... to whomever is concerned ... Regards, Stephane Faroult Oriole Spring??? What is spring? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Renumber a set of grupped rows?
Just out of curiocity, and while I am trying to learn about Row_NUMBER(), how would you code the following to do an update on the 2nd column? select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x from emp thx maa the analytical functions are available in 8i (..) wrap then in execute immediate within PL/SQL An update is possible in PL/SQL but it's easier to create a new table and swap them around - unless that creates some major headaches for you. At 08:04 PM 1/20/2004, you wrote: Maryann SQL select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x from emp 2 ; DEPTNO X -- -- 10 1 10 2 10 3 20 1 20 2 20 3 20 4 20 5 30 1 30 2 30 3 30 4 30 5 30 6 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Maryann Atkinson 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).
Host concurrent program whom call ar60runb
Hi Listers, I'have registered host concurrent program on Oracle 11.5.9 as TEST.prog which include one line to execute the ar60runb on command line. Unfortunately this is does not work for me. The problem is the TEST.prog can execute any other command or script (shell, Perl,...) but not ar60runb which I can execute independently. Could you please help to resolve this problem? Thanks, Ben __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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).
cman and oracle names
I sent this last night. Im not sure if it went through. If it did, I apologize for the spam. Does anyone use CMAN? Its in the certification books(yes I know certification isnt very good, but I might as well learn something if Im going to do it), but I dont know anyone using it. It strikes me as a poor mans application serve? Or am I missing something? Does anyone use names server? It strikes me as only being useful for client server applications or for a large development team where lots of people need Toad and/or SQLPlus access to many instances. Or have I underestimated its value? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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 : Happy Spring Festival
I know what you are talking about. I lived in New Hampshire when I was in the US Navy and attended grad. school at the U. of New Hampshire. February seemed to be the big snow month. Not uncommon to get two feet of snow in a nor-easter and have 5-6 feet on the ground - in southern NH. The roads looked like you were driving through snow tunnels. Ken Janusz, CPIM Now in Minnesota - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 8:44 AM On 01/21/2004 07:20:00 AM, Stephane Faroult wrote: ... to whomever is concerned ... Regards, Stephane Faroult Oriole Spring??? What is spring? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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.net -- Author: KENNETH JANUSZ 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: Does SQL Server have a wait interface?
Ryan, Check out DBCC SQLPERF(WAITSTATS), and also take a look at the sysprocesses table - with columns waittype, waittime, lastwaittype and SPID. Something like: SELECT spid AS SPID, waittype AS WaitType, waittime AS WaitTime, lastwaittype AS LastWaitType FROM sysprocesses WHERE (spid 50) AND (waittime 0) A good comprehensive overview of the wait types is here: http://sqldev.net/misc/WaitTypes.htm HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- [EMAIL PROTECTED] Sent: 21 January 2004 13:35 To: Multiple recipients of list ORACLE-L anyone know? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ADMIN: Status of list server systems (and update about
Bruce, You are doing a GREAT job keeping the lists running. And you seem to have put in some effort in developing/implementing the load balancers and then again in retrieving the squirreled-away emails. Thanks. We appreciate your work. Regards Hemant At 05:39 PM 19-01-04 -0800, you wrote: Folks -- I have good news and bad news. ;-) First the good news: Several people had mentioned that they've sent messages to some lists but have not seen the posts arrive back to them. These messages DID appear in the archives though. This started roughly 12-Jan-2004. I had previously researched this issue but could find no reason for it happening, nor a solution. Up until today, that is. The cuplrit was one of my load balancers for mailing list traffic. It was handling traffic correctly on some of the machines, but squirreling away messages sent to one specific server. I'd estimate about 1/8th of the messages sent to mailing lists since 12-Jan-2004 were not redistributed properly. I have since found and fixed the problem, so this shouldn't happen in the future. I suspect I was only able to re-send a portion of the missing messages, so my apologies for anyone who posted a message that didn't make it to a list. Also, my apologies to everyone who has to deal with the increased traffic of the old messages, plus current messages, plus the inevitable onslaught of re-posts that will occur in the next few days. Please be patient with each other. So the good news was: problem found, problem fixed, some catch up done, shouldn't happen again. The bad news is that this morning (roughly 7am PST), a construction crew near Fat City cut through a section of telecom cable that was critical for our connection to the net. They've been working feverishly on it all day, but Fat City was off the net most of the day. Until about 3pm PST. I believe things are about back to normal right now, but there's always a ramp-up time to truly get back to normal. My apologies to anyone who was affected by our downtime. If you have any questions or concerns about anything, please let me know. Thanks, Bruce Bergman ListMaster, Fat City Hosting -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Bruce A. Bergman 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 Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Healty ratio of index segment size vs table segment size?
Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? If it can, what could be considered as average healthy ratio above which would be prudent to have a closer look and investigate? Related to the above dilemma, how expensive is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few most suspected indexes at a time? Thoughts, pointers, opinions - appreciated. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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:
Title: Message Ashish realizing his time is short he crawls to the terminal and with his last remaining strength double clicks the outlook icon, clicks thenew button selects "New Mail Message" button,using the shift key he types H - E - L - P in the message body window and hits send and then CANCEL to stop the spell checker, and then "YES" to send his message anyway. His message careens through the internet as he slumps to the floor as the world goes dark. The world will be safe now if they can break the code are his final thoughts before oblivion takes him. Minutes later hundreds of Information Systems professionals are reading his message wondering whathorror occurred that drove a man to do this. They pause to reflect and then selecting the message in their inbox they press the delete key and go get a fresh cup of coffee. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 8:59 AMTo: Multiple recipients of list ORACLE-LSubject: RE: Funny ...Ashish is from "Weight Watchers" and asking for HELP my advise ... stop starving yourself ... go eat something. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Mark Leith [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 9:45 AMTo: Multiple recipients of list ORACLE-LSubject: RE: must.resist..temptation. For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. Live long and prosper. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ashish SahasrabudheSent: 21 January 2004 14:34To: Multiple recipients of list ORACLE-LSubject: HELP
RE: cman and oracle names
I've used it to allow DB connections through a non-sqlnet-aware firewall, and also to enable SSH tunneling of DB sessions. In the former case the firewall was blocking the redirect, although port 1521 itself was open. In the latter, a redirect would have taken us outside the encrypted tunnel. CMAN doesn't seem particularly featurefull, but it's more than adequate for these type of situations. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 8:45 AM To: Multiple recipients of list ORACLE-L I sent this last night. Im not sure if it went through. If it did, I apologize for the spam. Does anyone use CMAN? Its in the certification books(yes I know certification isnt very good, but I might as well learn something if Im going to do it), but I dont know anyone using it. It strikes me as a poor mans application serve? Or am I missing something? Does anyone use names server? It strikes me as only being useful for client server applications or for a large development team where lots of people need Toad and/or SQLPlus access to many instances. Or have I underestimated its value? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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.net -- Author: Norris, Gregory T [ITS] 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:
Raj, bwahahaha, now thats funny :) joe Jamadagni, Rajendra wrote: Funny ... Ashish is from Weight Watchers and asking for HELP my advise ... stop starving yourself ... go eat something. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- *From:* Mark Leith [mailto:[EMAIL PROTECTED] *Sent:* Wednesday, January 21, 2004 9:45 AM *To:* Multiple recipients of list ORACLE-L *Subject:* RE: must.resist..temptation. For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. Live long and prosper. -Original Message- *From:* [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] *On Behalf Of *Ashish Sahasrabudhe *Sent:* 21 January 2004 14:34 *To:* Multiple recipients of list ORACLE-L *Subject:* HELP -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Joe Testa 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).
SQL Code release
Title: SQL Code release Is there a tool available to release same set of DDLs, DMLs, PL/SQL code in different database environments like QA, Unit Testing, Production Support etc. I guess this can done by writing shell or batch scripts. But I am looking for a GUI tools to do this. Thanks
Re[2]: OT : Happy Spring Festival
Wednesday, January 21, 2004, 9:44:48 AM, Mladen Gogala ([EMAIL PROTECTED]) wrote: MG Spring??? What is spring? I live in New England, we have record colds MG and I dunno what the heck is spring? Is that something like 70 degrees? MG I've heard about that mythical event but at present I'm shoveling snow MG on -20 degrees. Where I live, I'll be cross-country skiing into April. My first year here I was able to find ice in the woods as late as May 23: http://gennick.com/may_ice.html Actually, some ice lived longer than that, just not the particular berg I was photographing. Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: Renumber a set of grupped rows?
Although you've had a row-at-a-time version from someone, you might try something like the following if you can't do a create as select to rebuild the original data. Create table temp pctfree 0 nologging as select rowide_rowid, row_number() over (PARTITION BY DEPTNO order by deptno) x from emp; create unique index t_i on temp(e_rowid); alter table temp modify e_rowid not null; update emp e set req_id = ( select x from temp t where t.e_rowid = e.rowid ); (Just making it up as I go along, so I won't guarantee that it works). Regards Jonathan Lewis http://www.jlcomp.demon.co.uk The educated person is not the person who can answer the questions, but the person who can question the answers -- T. Schick Jr Next public appearance2: March 2004 Hotsos Symposium - Keynote March 2004 Charlotte NC - OUG Tutorial April 2004 Iceland One-day tutorials: http://www.jlcomp.demon.co.uk/tutorial.html Three-day seminar: see http://www.jlcomp.demon.co.uk/seminar.html UK___February The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 3:04 PM Just out of curiocity, and while I am trying to learn about Row_NUMBER(), how would you code the following to do an update on the 2nd column? select deptno, row_number() over (PARTITION BY DEPTNO order by deptno) x from emp thx maa -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Lewis 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).
Any comments on Open Source Projects for Oracle ?
OTN has published a list of Oracle Open Source Projects at http://otn.oracle.com/tech/opensource/projects.html Hemant K Chitale Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: OT : Happy Spring Festival
Stephane probably meant Chinese New Year, which is tomorrow (1/22/04). This will be the Year of Monkey. I live in Boston, the weather has been brutal this winter so far. I cann't wait for spring to come so I can start to play soccer again. Guang -Original Message- Mladen Gogala Sent: Wednesday, January 21, 2004 9:45 AM To: Multiple recipients of list ORACLE-L On 01/21/2004 07:20:00 AM, Stephane Faroult wrote: ... to whomever is concerned ... Regards, Stephane Faroult Oriole Spring??? What is spring? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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.net -- Author: Guang Mei 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: SQL Code release
Sure. You can try the Change Management Pack for Oracle Enterprise Manager from Oracle. Then there is the bevy of tools from Quest software. DB Artisan is another. RWB Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) [EMAIL PROTECTED] [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
Oracle 817 client on Windows 2003?
The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.) on Windows 2003. Do you know if it is certified to, or will it do it? Thanks This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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).
V$system_event
These results don't seem possible. I run the following query: select ((vse.time_waited/100)/60) time_waited, ((vse.time_waited/vse1.total_time)*100) p_time_waited, vse.event fromv$system_event vse, (select sum(time_waited) total_time from v$system_event) vse1 where ((vse.time_waited/100)/60) = .1 and vse.event not in ('SQL*Net message from client','rdbms ipc message','pmon timer','smon timer') order by 2 desc / The system is 8.1.7.4 running Oracle Applications 11.5.7 on HPUX 11.11. The database has been up since Sunday night after the cold backup. These results seem too large. Any thoughts? Time Waited % Time (min) Waited Wait Event --- 50,771.542.30 db file sequential read 19,129.29 .86 db file scattered read 15,735.79 .71 latch free 15,321.68 .69 io done 15,248.34 .69 log file sync 14,866.87 .67 buffer busy waits 14,718.91 .67 log file parallel write Thanks for your help, Jolene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene 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: Host concurrent program whom call ar60runb
Hi Hemant, Many thanks. You are right. It's all about the variable environments. Now it works fine. Have nice day. Ben --- Hemant K Chitale [EMAIL PROTECTED] wrote: Does your TEST.prog include the environment for ar60runb ? If it runs as a shell script, does it have $ORACLE_HOME, and $PATH setup correctly ? Hemant At 07:09 AM 21-01-04 -0800, you wrote: Hi Listers, I'have registered host concurrent program on Oracle 11.5.9 as TEST.prog which include one line to execute the ar60runb on command line. Unfortunately this is does not work for me. The problem is the TEST.prog can execute any other command or script (shell, Perl,...) but not ar60runb which I can execute independently. Could you please help to resolve this problem? Thanks, Ben __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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 Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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). __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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: SQL Code release
Title: SQL Code release OEM has such a tool built into it ... we went through a research, ended up writing our own because each environment is different. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Ashish Sahasrabudhe [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 11:10 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Code release Is there a tool available to release same set of DDLs, DMLs, PL/SQL code in different database environments like QA, Unit Testing, Production Support etc. I guess this can done by writing shell or batch scripts. But I am looking for a GUI tools to do this. Thanks **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
RE: Oracle 817 client on Windows 2003?
Hi Michael, 1) You need to ensure that the listener is configured properly. 2) Your tnsnames.ora or namesserver is configured properly. 3) There are no problems in installation of Oracle client,server and database . If the above conditions are satisfied , you should have no problems in connecting from client to server (database) . I am not sure whether it is certified . Thanks and regards Shreepad -Original Message- Michael Milligan Sent: Wednesday, January 21, 2004 9:35 AM To: Multiple recipients of list ORACLE-L The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.) on Windows 2003. Do you know if it is certified to, or will it do it? Thanks This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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.net -- Author: Vaidya, ShreepadX M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Old thread - trace file location
Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Host concurrent program whom call ar60runb
Does your TEST.prog include the environment for ar60runb ? If it runs as a shell script, does it have $ORACLE_HOME, and $PATH setup correctly ? Hemant At 07:09 AM 21-01-04 -0800, you wrote: Hi Listers, I'have registered host concurrent program on Oracle 11.5.9 as TEST.prog which include one line to execute the ar60runb on command line. Unfortunately this is does not work for me. The problem is the TEST.prog can execute any other command or script (shell, Perl,...) but not ar60runb which I can execute independently. Could you please help to resolve this problem? Thanks, Ben __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kader Ben 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 Oracle 9i Database Administrator Certified Professional http://hkchital.tripod.com {last updated 05-Jan-04} -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: Oracle 817 client on Windows 2003?
Do you mean Windows 2003 Advanced Server? Check the compatibility matrix on Metalink. RWB Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] ngenix.com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Oracle 817 client on Windows 2003? com 01/21/2004 10:34 AM Please respond to ORACLE-L The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.) on Windows 2003. Do you know if it is certified to, or will it do it? Thanks This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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.net -- 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: Healty ratio of index segment size vs table segment size?
www.ixora.com.au there is a script in there that will identify unnecessary redundant indexes. for the record, that is one of the best oracle websites out there. Lots of great stuff on it. From: Branimir Petrovic [EMAIL PROTECTED] Date: 2004/01/21 Wed AM 10:39:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Healty ratio of index segment size vs table segment size? Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? If it can, what could be considered as average healthy ratio above which would be prudent to have a closer look and investigate? Related to the above dilemma, how expensive is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few most suspected indexes at a time? Thoughts, pointers, opinions - appreciated. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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.net -- Author: [EMAIL PROTECTED] 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 817 client on Windows 2003?
From metlink, it looks like the 8.1.7 client is not certified for Windows 2003 server. You should probably install the 9.2 client on the workstations. It should ahve no problems connecting to the 8.1.7 database on unix. Ron Thomas Hypercom, Inc [EMAIL PROTECTED] The box said I needed to have windows 98 or better...So I installed linux. shreepadx.m.vaidy [EMAIL PROTECTED] To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED]Subject: RE: Oracle 817 client on Windows 2003? .com 01/21/2004 09:59 AM Please respond to ORACLE-L Hi Michael, 1) You need to ensure that the listener is configured properly. 2) Your tnsnames.ora or namesserver is configured properly. 3) There are no problems in installation of Oracle client,server and database . If the above conditions are satisfied , you should have no problems in connecting from client to server (database) . I am not sure whether it is certified . Thanks and regards Shreepad -Original Message- Michael Milligan Sent: Wednesday, January 21, 2004 9:35 AM To: Multiple recipients of list ORACLE-L The database is on Unix, but we want to run client (OEM, SQL*Plus, etc.) on Windows 2003. Do you know if it is certified to, or will it do it? Thanks This e-mail, including attachments, may include confidential and/or proprietary information, and may be used only by the person or entity to which it is addressed. If the reader of this e-mail is not the intended recipient or his or her authorized agent, the reader is hereby notified that any dissemination, distribution or copying of this e-mail is prohibited. If you have received this e-mail in error, please notify the sender by replying to this message and delete this e-mail immediately. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Michael Milligan 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.net -- Author: Vaidya, ShreepadX M INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
RE: 9iAS Calender Servlet
Calendar servlet sounds pretty generic. What more specifically do you want your servlet to do? If you are writing a PL/SQL Web app with mod_plsql, you might want to look into the OWA_UTIL procedure that takes a query and writes a calendar page in HTML. The query includes columns for the dates to be shown on the calendar, text to be shown in the cell for each date, and optionally an URL to which the text will be a link. -Original Message- Sent: Wednesday, January 21, 2004 7:45 AM To: Multiple recipients of list ORACLE-L Does anybody by chance have any examples for creating a calender servlet for 9iAS? I have to admit to being a servlet virgin! ;) Any pointers much apreciated! Many thanks Mark -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: John Flack 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: SQL Code release
Title: SQL Code release checkout tools for www.agileinfosoftware.com, we use DataAnalyst to do similiar jobs like yours. Eric - Original Message - From: Ashish Sahasrabudhe To: Multiple recipients of list ORACLE-L Sent: Wednesday, January 21, 2004 11:09 AM Subject: SQL Code release Is there a tool available to release same set of DDLs, DMLs, PL/SQL code in different database environments like QA, Unit Testing, Production Support etc. I guess this can done by writing shell or batch scripts. But I am looking for a GUI tools to do this. Thanks
RE: OT : Happy Spring Festival
Title: RE: OT : Happy Spring Festival 60 above zero. Floridians turn the heat on. People in New England plant gardens. 50 above zero. Californians shiver uncontrollably. People in New England sunbathe. 40 above zero. Italian and English cars won't start. People in New England drive with the windows down. 32 above zero. Distilled water freezes. Moosehead Lake's water gets thicker. 20 above zero. Floridians don coats, thermal underwear, gloves and hats. People in New England throw on a flannel shirt. 15 above zero. New York landlords finally turn on the heat. People in New England have the last cookout before it turns cold. Zero. People in Miami die - or return to Cuba. New Englanders close the windows. 10 below zero. Californians go to Mexico. People in New England get out their Winter coats. 25 below zero. Hollywood disintegrates. Girl Scouts in New England are selling cookies door to door. 40 below zero. Washington DC runs out of hot air. People in New England let the dogs sleep inside. 100 below zero. Santa Claus abandons the North Pole. People in New England get frustrated because "the caah won't staaht". 275 below zero. All atomic motion stops. (Absolute zero on the Kelvin scale).People in New England start saying, "cold nuff for ya?" 500 below zero. Hell freezes over. Red Sox win the World Series. Dick GouletSenior Oracle DBAOracle Certified 8i DBA -Original Message-From: Stefick Ronald S Contr ESC/HRIDA [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 10:15 AMTo: Multiple recipients of list ORACLE-LSubject: RE: OT : Happy Spring Festival At least you probably have a warm fuzzy feeling about your Patriots going to the supberbowl. -Original Message- From: Mladen Gogala [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 21, 2004 8:45 AM To: Multiple recipients of list ORACLE-L Subject: Re: OT : Happy Spring Festival On 01/21/2004 07:20:00 AM, Stephane Faroult wrote: ... to whomever is concerned ... Regards, Stephane Faroult Oriole Spring??? What is "spring"? I live in New England, we have record colds and I dunno what the heck is spring? Is that something like 70 degrees? I've heard about that mythical event but at present I'm shoveling snow on -20 degrees. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Healty ratio of index segment size vs table segment size?
They appear to be Tango Uniform today!! Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 21, 2004 12:25 PM To: Multiple recipients of list ORACLE-L www.ixora.com.au there is a script in there that will identify unnecessary redundant indexes. for the record, that is one of the best oracle websites out there. Lots of great stuff on it. From: Branimir Petrovic [EMAIL PROTECTED] Date: 2004/01/21 Wed AM 10:39:25 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Healty ratio of index segment size vs table segment size? Wondering if there is a rule of thumb, quick'n fast but good enough to be used as an indicator, litmus paper so to speak, of overly indexed table(s)... Can, better yet - should, sheer size comparison of index versus table segments be used as a reliable pointer to problematic table indexing? If it can, what could be considered as average healthy ratio above which would be prudent to have a closer look and investigate? Related to the above dilemma, how expensive is to monitor index usage, say if script is run against all few hundred indexes on app tables, would the additional load noticeably affect application performance or is it better/safer or may be required to monitor not more than just a few most suspected indexes at a time? Thoughts, pointers, opinions - appreciated. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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.net -- Author: [EMAIL PROTECTED] 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.net -- Author: Goulet, Dick 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).
ORA-12540: TNS: internal limit restriction exceeded
Hi All, We are running 9.2.0.4 on windoze 2000 server and this morning we were forced to restart the database server. Users complained about not able to connect to database... TNS could not start dedicated server process...So I tried to connect to db using OS authentication...(sqlplus / as sysdba) and ran into ORA-12540: TNS: internal limit restriction exceeded. Where is this limit set? Is it possible to change the setting? Here is some additional information The application that connects to this db is java based...In the past when we were seeing lot of 4030 errors in the alert log, we opened a case with oracle (this was when we were @ 9.2.03) [[ORA-04030: out of process memory when trying to allocate 2097184 bytes (joxcx callheap,ioc_allocate ufree) ]] Oracle response to the TAR was that there were some memory leaks with executing java stored procedures and recommended applying the 9.2.0.4 patch...which we did ...It did not fix the issue. We have noticed that whenever there are many occurances of 4030 in the alert log users run into TNS could not start dedicated server process and we are forced to restart. Your help in this matter is greatly appreciated. Thanks for your time Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[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: FW: Disk capacity planning
See the Ratio Modeling paper at Orapub.com It is a quick and dirty method for capacity planning. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 01:34 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: FW: Disk capacity planning Mladen, I agree you can measure how many IOs are being done and how many a disk sub- system, such as those provided by EMC, can perform and still give good performance. What I meant is that it is hard and some would say impossible to estimate how many IOs per sec a new application will do. A combination of paper calculations, testing, experience and looking at comparable systems will help to provide a good estimate. Cheers, Chris Quoting Mladen Gogala [EMAIL PROTECTED]: Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os per second can they perform and they even have tools to measure it. Speaking of monitoring I/O, there used to be an old OS, which is mostly dead today and it used to have command monitor io/item=queue which would show length of the I/O queues per device, which was extremely useful, because you could quickly find out which devices are hot and which are not. On 2004.01.20 04:19, [EMAIL PROTECTED] wrote: Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle server. Thanks in advance. Best Regards, Rhojel Chris Dunscombe [EMAIL PROTECTED] - Everyone should have http://www.freedom2surf.net/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
Re: V$system_event
The result depends on the number of sessions. If you have session A waiting for a 'enqueue lock' for 10 minutes and session B waiting for the same lock as session A for another 10 minutes, then the recorded time is 20 minutes, despite the fact that sessions are waiting concurrently. If you have, say, 500 concurrent sessions, the numbers will be exorbitant. V$SYSTEM_EVENT is a summary table and not very useful at that. Your query gives you the most important thing:the percentages. The percentages tell you that I/O related events ('scattered read' for table scans and 'sequential read' for index scans) are not taking too much time, relative to the other events. In other words, you found another way of calculating BHCR and have significantly advanced something that one of the recent books calls method C. On 01/21/2004 11:44:25 AM, Shrake, Jolene wrote: These results don't seem possible. I run the following query: select ((vse.time_waited/100)/60) time_waited, ((vse.time_waited/vse1.total_time)*100) p_time_waited, vse.event fromv$system_event vse, (select sum(time_waited) total_time from v$system_event) vse1 where ((vse.time_waited/100)/60) = .1 and vse.event not in ('SQL*Net message from client','rdbms ipc message','pmon timer','smon timer') order by 2 desc / The system is 8.1.7.4 running Oracle Applications 11.5.7 on HPUX 11.11. The database has been up since Sunday night after the cold backup. These results seem too large. Any thoughts? Time Waited % Time (min) Waited Wait Event --- 50,771.542.30 db file sequential read 19,129.29 .86 db file scattered read 15,735.79 .71 latch free 15,321.68 .69 io done 15,248.34 .69 log file sync 14,866.87 .67 buffer busy waits 14,718.91 .67 log file parallel write Thanks for your help, Jolene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene 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.net -- Author: Mladen Gogala 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).
How to set appropriate arraysize for an OLTP application?
Dear All, We are trying to tune SQL*Net using SDU,TDU and Arraysize parameters. Could some one enlighten me how to calculate an optimal arraysize value for an application? I did search metalink. In our java applications few queries are returning 1 or 2 records and few of them returning 10s of 100s of records. Normally how does array size (in java prefetch) set in this kind of scenario? Any help would be appreciated. Thanks Jay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: FW: Disk capacity planning
When I worked for Oxford, there was a way to force the application to either perform or die. The OLTP database was enforcing profiles and there was limit of 1500 logical reads per call, because it was estimated that our typical OLTP application never performs more then that. If application was unable to achieve that performance, it wasn't allowed to the production OLTP system. That way, the performance could be guaranteed. On 01/21/2004 01:19:26 PM, [EMAIL PROTECTED] wrote: See the Ratio Modeling paper at Orapub.com It is a quick and dirty method for capacity planning. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: FW: Disk capacity planning Mladen, I agree you can measure how many IOs are being done and how many a disk sub- system, such as those provided by EMC, can perform and still give good performance. What I meant is that it is hard and some would say impossible to estimate how many IOs per sec a new application will do. A combination of paper calculations, testing, experience and looking at comparable systems will help to provide a good estimate. Cheers, Chris Quoting Mladen Gogala [EMAIL PROTECTED]: Oh, but it is done, you only need to ask. EMC routinely measures how many I/Os per second can they perform and they even have tools to measure it. Speaking of monitoring I/O, there used to be an old OS, which is mostly dead today and it used to have command monitor io/item=queue which would show length of the I/O queues per device, which was extremely useful, because you could quickly find out which devices are hot and which are not. On 2004.01.20 04:19, [EMAIL PROTECTED] wrote: Cary, Good answer. The problem is most people concentrate on bytes because it's relatively easy and everyone understands it. IOs per sec is much harder to calculate for a new system and hence it's not normally done. Cheers, Chris Dunscombe Quoting Cary Millsap [EMAIL PROTECTED]: I don't think this one made it through on my first attempt. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Sent: Tuesday, January 13, 2004 5:54 PM To: '[EMAIL PROTECTED]' Counting bytes is far, far, FAR less important than counting I/O-per-second (IOps) requirements and making sure that you have enough total capacity to handle your system's peak I/O loads. Counting bytes is important too, but what many people find is that the byte-counting exercise will result in the sub-verdict of needing far fewer disk drives than you'll really, truly need. The way I'd recommend structuring your project is to evaluate the following: - How many bytes will you need to store your data? How many disks is that? Call the answer B. - How many disks will you need to meet your IOps requirements? Call the answer P. - How many disks will you need to meet your availability requirements? Call the answer A. - (Consider other attributes as necessary, like perhaps I/O throughput requirements.) Roughly speaking, the number of disks you'll need to buy is max(B, P, A, .). It's more complicated than that because you'll need to segment your total drive set into sensibly-sized arrays, you'll be able to buy some disks now then some later, and so on, but this is the general gist. The important thing is to have enough hardware to meet *all* of the constraints your business will place upon your system. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Nullius in verba Upcoming events: - Performance http://www.hotsos.com/training/PD101.html Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004 http://www.hotsos.com/events/symposium/2004 : March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 13, 2004 12:29 AM To: Multiple recipients of list ORACLE-L Hi everyone! Can anybody point me to any good documentation regarding disk capacity planning? Sharing your experience or approach will also give me so much help. I'd like to know other people's approach on forecasting the growth of their databases particularly on determining the (growth) rate of disk space usage and on deciding when to add and how many disk to add on an Oracle
Re[2]: OT : Happy Spring Festival
Wednesday, January 21, 2004, 1:14:25 PM, Goulet, Dick ([EMAIL PROTECTED]) wrote: GD 500 below zero. Hell freezes over. Red Sox win the World Series. LOL! Hey, that's funny. But you know, Hell freezes every year here in Michigan (zoom in one notch to see it): http://www.mapquest.com/maps/map.adp?formtype=searchcountryid=250addtohistory=country=USaddress=city=hellstate=mizipcode=historyid=submit=Get+Map And, oddly enough, Paradise is not only colder, but it gets far more snow, and more snowmobiles: http://www.mapquest.com/maps/map.adp?formtype=searchcountryid=250addtohistory=country=USaddress=city=paradisestate=mizipcode=historyid=submit=Get+Map And I won't even get into Christmas, which is only about four miles from my home: http://www.mapquest.com/maps/map.adp?formtype=searchcountryid=250addtohistory=country=USaddress=city=Christmasstate=mizipcode=historyid=submit=Get+Map Best regards, Jonathan Gennick --- Brighten the corner where you are http://Gennick.com * 906.387.1698 * mailto:[EMAIL PROTECTED] Join the Oracle-article list and receive one article on Oracle technologies per month by email. To join, visit http://four.pairlist.net/mailman/listinfo/oracle-article, or send email to [EMAIL PROTECTED] and include the word subscribe in either the subject or body. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jonathan Gennick 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: full recovery
Sorry it took so long to get back to you; I've been caching the list for awhile and am just starting to catch up. :-) Page 43, in the grey box with title 'Re-Creating the Controlfile: RMAN Users Beware!' Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of DENNIS WILLIAMS Sent: Friday, November 07, 2003 3:55 PM To: Multiple recipients of list ORACLE-L Subject: RE: full recovery Rich - Could you point to the place where Robert states that bit about controlfiles to trace? Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Friday, November 07, 2003 1:59 PM To: Multiple recipients of list ORACLE-L I believe that an 'alter database backup controlfile to trace' loses the RMAN data stored in the control files if you're not using a repository (if I remember right from RF's book). Since we're not using a repository, we've got controlfile autobackup on (in 9i use 'configure controlfile autobackup on'). We dump these disk copies via filesystem backups as a safety measure. We also do a backup database, archivelogs, and then control (but all in one step; I'm not sure I'm clear on the reason for separating them into three backup sets) Rich -- Rich Holland(913) 645-1950SAP Technical Consultant print unpack(u,92G5S\=\!A;F]T:5R(\'!EFP\@:%C:V5R\[EMAIL PROTECTED]); -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mercadante, Thomas F Sent: Friday, October 24, 2003 2:35 PM To: Multiple recipients of list ORACLE-L Subject: RE: full recovery AK, First, your normal backup should backup your database in the following order: Database, archivelogs and then control file. I actually do this in three separate Rman steps. This is so that the most recent control file is backups up after all of the data. This allows your to perform an incoimplete-recovery-restore to as late a time as possible. Also, consider adding a database trigger that, upon startup, perform an alter database backup controlfile to trace; Keep a copy of this trace file someplace safe as a sanity check. You could use it to recreate your controlfiles if all else fails. Your recovery steps are as follows: 1. restore oracle software from tape. 2. restore config files ( init.ora , listener. ora ). 3. startup instance with nomount. 4. run Rman to restore the control file from tape. 5. Alter database mount 6. run Rman to restore database files 7. alter database open resetlogs. 8. perform a brand-new Rman backup (database, logs controlfile) turn the system back to the users (with many back-pats from management). You should be testing this on a regular basis. Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, October 24, 2003 2:15 PM To: Multiple recipients of list ORACLE-L Here is a scenerio : I am taking full database backup everynight using rman to tape . which includes archive logs and control file. Not using catalog.Also have a backup of complete file system including oracle software and configuration files ( init.ora , listener.ora etc.. ) I lost the host on a particular day at 12 am afternoon. Now I want to restore this db to latest possible time to another host ( with same name ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rich Holland 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.net -- 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.net -- Author:
after the discussion yesterday on db2/mysql/postgresql....
I thought this might be relevant and interesting... http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr ack=NL-93 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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: pga_aggregate_target and a memory leak
Kirti, you're back! Must have finished the book. :) Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Did you try increasing P_A_T to a larger number? Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting. Also, did your system go in to excessive paging or swapping? I've been curious as to what the effects would be of having P_A_T too low. Oracle is supposed to grab whatever memory it needs. I'm assuming at this point that doing so involves a different code path as it needs to alloc the memory. Don't know what the cost of that is, haven't tried to test it. It seems likely that the OS was out of memory, regardless of the P_A_T value. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO' workarea_size_policy... seems to run okay... - Kirti --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful with pga_aggregate_target. I have very recently seen a case (Solaris + 9.2 but I cant't tell you exactly which patch level - probably the most recent) where two (by the way atrocious) queries generated by a DSS tool were responding very differently - and in a way that differences in the queries couldn't explain. From an Oracle standpoint, stats were roughly the same. Tracing proved that we were waiting for CPU, and truss that a call to mmap() was the culprit. Why, no idea. We first switched it (pga_thing) off, no more slow call to mmap(). However, it was still slow because we hadn't checked sort_area_size which was ridiculously small. We set sort_area_size to 10M, still with pga_aggregate_target unset, and once again the same very slow calls to mmap(). Memory misalignment? Anything else? Not much time to enquire but it looks like a mine field. -- Regards, Stephane Faroult Oriole Software -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: V$system_event
Jolene, Mladen's answer is a good one. There is also an in-depth discussion on this subject on pp210-217 of the book Optimizing Oracle Performance. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com * Nullius in verba * Upcoming events: - Performance Diagnosis 101: 1/27 Atlanta - SQL Optimization 101: 2/16 Dallas - Hotsos Symposium 2004: March 7-10 Dallas - Visit www.hotsos.com for schedule details... -Original Message- Shrake, Jolene Sent: Wednesday, January 21, 2004 10:44 AM To: Multiple recipients of list ORACLE-L These results don't seem possible. I run the following query: select ((vse.time_waited/100)/60) time_waited, ((vse.time_waited/vse1.total_time)*100) p_time_waited, vse.event fromv$system_event vse, (select sum(time_waited) total_time from v$system_event) vse1 where ((vse.time_waited/100)/60) = .1 and vse.event not in ('SQL*Net message from client','rdbms ipc message','pmon timer','smon timer') order by 2 desc / The system is 8.1.7.4 running Oracle Applications 11.5.7 on HPUX 11.11. The database has been up since Sunday night after the cold backup. These results seem too large. Any thoughts? Time Waited % Time (min) Waited Wait Event --- 50,771.542.30 db file sequential read 19,129.29 .86 db file scattered read 15,735.79 .71 latch free 15,321.68 .69 io done 15,248.34 .69 log file sync 14,866.87 .67 buffer busy waits 14,718.91 .67 log file parallel write Thanks for your help, Jolene -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Shrake, Jolene 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.net -- 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).
What gives??
LG, I know there is a simple solution to this .. but I can't think of it right now. Any help will be appreciated ... Thanks, Nikhil = [ny-nikhil1:/export/home/nkhimani/bin]$ export AWK=awk '{print \$4}' [ny-nikhil1:/export/home/nkhimani/bin]$ echo ${AWK} awk '{print $4}' [ny-nikhil1:/export/home/nkhimani/bin]$ cal | awk '{print $4}' W 7 14 21 28 [ny-nikhil1:/export/home/nkhimani/bin]$ cal | ${AWK} awk: syntax error near line 1 awk: bailing out near line 1 [ny-nikhil1:/export/home/nkhimani/bin]$ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikhil Khimani 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: after the discussion yesterday on db2/mysql/postgresql....
Thought PostGreSql smelled a lot like DB2. And although I agree with their definitions on the surface they miss a lot of the underlying capability in Oracle. Sure, one database per instance, but you can them map multiple applications/schema's into that instance. Makes for a lot less fun when one application needs data from another that's in the same instance. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Wednesday, January 21, 2004 2:14 PM To: Multiple recipients of list ORACLE-L I thought this might be relevant and interesting... http://searchdatabase.techtarget.com/tip/0,289483,sid13_gci945589,00.html?tr ack=NL-93 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Chris Stephens 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.net -- Author: Goulet, Dick 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: pga_aggregate_target and a memory leak
Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. Did you try increasing P_A_T to a larger number? Yes... Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting. Also, did your system go in to excessive paging or swapping? Yes, it did with a large P_A_T. I've been curious as to what the effects would be of having P_A_T too low. I saw more disk sorts.. As time permits, I will play with event 10032, 10033 trace for sorts to see what's going on.. Oracle is supposed to grab whatever memory it needs. I'm assuming at this point that doing so involves a different code path as it needs to alloc the memory. Don't know what the cost of that is, haven't tried to test it. It seems likely that the OS was out of memory, regardless of the P_A_T value. No. The system has 4 GB of physical memory. Over 2GB was free. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO' workarea_size_policy... seems to run okay... - Kirti --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful with pga_aggregate_target. I have very recently seen a case (Solaris + 9.2 but I cant't tell you exactly which patch level - probably the most recent) where two (by the way atrocious) queries generated by a DSS tool were responding very differently - and in a way that differences in the queries couldn't explain. From an Oracle standpoint, stats were roughly the same. Tracing proved that we were waiting for CPU, and truss that a call to mmap() was the culprit. Why, no idea. We first switched it (pga_thing) off, no more slow call to mmap(). However, it was still slow because we hadn't checked sort_area_size which was ridiculously small. We set sort_area_size to 10M, still with pga_aggregate_target unset, and once again the same very slow calls to mmap(). Memory misalignment? Anything else? Not much time to enquire but it looks like a mine field. -- Regards, Stephane Faroult Oriole Software -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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: SQL Code release
Title: SQL Code release It seems we also need to write our own tool. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 11:20 AMTo: Multiple recipients of list ORACLE-LSubject: RE: SQL Code release OEM has such a tool built into it ... we went through a research, ended up writing our own because each environment is different. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: Ashish Sahasrabudhe [mailto:[EMAIL PROTECTED]Sent: Wednesday, January 21, 2004 11:10 AMTo: Multiple recipients of list ORACLE-LSubject: SQL Code release Is there a tool available to release same set of DDLs, DMLs, PL/SQL code in different database environments like QA, Unit Testing, Production Support etc. I guess this can done by writing shell or batch scripts. But I am looking for a GUI tools to do this. Thanks **This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.**4
RE: Password management using profiles
Yup..we just added the functionalty to the verify_password functionwala. Brian S. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 5:59 PM To: Multiple recipients of list ORACLE-L You have to check for errors in the ORA-28000 range, for this is the range that password problems will use. Add a check in your connection section that will propagate any exception encountered. You can also trap the Oracle errors for password expiration or locked account and display a more understandable message instead. This is the way I did it. Also, create a function or procedure that checks the EXPIRY_DATE and ACCOUNT_STATUS in the all_users or dba_users table to determine when the password will expire or if it has already. The function/procedure then can raise an exception if the account is within the grace period or locked. RWB Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] n.eduTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Password management using profiles ity.com 01/20/2004 02:49 PM Please respond to ORACLE-L We're using pl/sql gateway and the Apache server. We've set up a default DAD on the gateway configuration screen, the connect string is our server name. Basic authentication, Package/Session Management Type: Stateless(Reset Package State). I've tried the profile by setting up a test user and expiring the account. If I go to sqlplus and log in with the expired user account sqlplus prompts me for a new password. I don't have a problem with that, but you know how users are, they wouldn't figure out why. And management wants users to receive a message telling them why they have to change their passwords without going through the Help Desk. My guess is that a pl/sql package has to be written so users get their password check at login time and receive messages such as the number of days they have before the password expires, or that the password is actually expired. Thanks Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 Mladen Gogala [EMAIL PROTECTED] ng.com To Sent by: Multiple recipients of list [EMAIL PROTECTED] ORACLE-L [EMAIL PROTECTED] .com cc Subject 01/20/2004 03:24 Re: Password management using PMprofiles Please respond to [EMAIL PROTECTED] com On 01/20/2004 02:34:45 PM, Ana Choto wrote: I have set up a profile where the passwords expire in 30 days, 6 characters minimum, grace period before the account locks to 6 days. It works as expected when the user logs in to our web site and tries to change the password. Users receive error messages whenever their password doesn't comply with the rules we have set up in the profile. We use the verify_function. The only problem I have is that when the users go to our web site they are presented with a login screen. If their account is locked or expired, or it is within the grace period before the account expires they don't receive a message to that account. If the account is expired the login screen resets and prompts for user id and password over and over. I have opened a TAR wit Oracle support, but they don't have an answer to that effect. They say it is an application issue. I've researched everywhere I could think of and everything I have found is the same, use profiles and the verify_function function. I've also read the documentation regarding password management, but I couldn't find anything of help. Our database is 8.1.7.2, and we're in Unix 5.8. We're using 9iAS release 1. We have created a DAD to connect to the database. When users click on our link then they see the login screen, just the same way as Metalink's. Only if they sign on successfully and try to change the password the profile works as a charm. I guess we need something that checks for the password status once the user enters id and password in the login screen. I'd appreciate any help in finding documents or web sites I can visit to find a solution to this problem. We'd like to enforce our password
Re: Re: pga_aggregate_target and a memory leak
kirti-- would you recommend avoiding pga_aggregate_target for now? From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. Did you try increasing P_A_T to a larger number? Yes... Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting. Also, did your system go in to excessive paging or swapping? Yes, it did with a large P_A_T. I've been curious as to what the effects would be of having P_A_T too low. I saw more disk sorts.. As time permits, I will play with event 10032, 10033 trace for sorts to see what's going on.. Oracle is supposed to grab whatever memory it needs. I'm assuming at this point that doing so involves a different code path as it needs to alloc the memory. Don't know what the cost of that is, haven't tried to test it. It seems likely that the OS was out of memory, regardless of the P_A_T value. No. The system has 4 GB of physical memory. Over 2GB was free. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO' workarea_size_policy... seems to run okay... - Kirti --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful with pga_aggregate_target. I have very recently seen a case (Solaris + 9.2 but I cant't tell you exactly which patch level - probably the most recent) where two (by the way atrocious) queries generated by a DSS tool were responding very differently - and in a way that differences in the queries couldn't explain. From an Oracle standpoint, stats were roughly the same. Tracing proved that we were waiting for CPU, and truss that a call to mmap() was the culprit. Why, no idea. We first switched it (pga_thing) off, no more slow call to mmap(). However, it was still slow because we hadn't checked sort_area_size which was ridiculously small. We set sort_area_size to 10M, still with pga_aggregate_target unset, and once again the same very slow calls to mmap(). Memory misalignment? Anything else? Not much time to enquire but it looks like a mine field. -- Regards, Stephane Faroult Oriole Software -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande 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.net -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web
Re: ORA-12540: TNS: internal limit restriction exceeded
Murali, Have you checked the OS event logs like the system log? Sounds like you have hit an OS limit. Please post the rest of the error stack that followed the ORA-12450 as this gives more information on what is the root cause of this failure? You can find this in the listener.log at the time of the failure. -f - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:19 AM Hi All, We are running 9.2.0.4 on windoze 2000 server and this morning we were forced to restart the database server. Users complained about not able to connect to database... TNS could not start dedicated server process...So I tried to connect to db using OS authentication...(sqlplus / as sysdba) and ran into ORA-12540: TNS: internal limit restriction exceeded. Where is this limit set? Is it possible to change the setting? Here is some additional information The application that connects to this db is java based...In the past when we were seeing lot of 4030 errors in the alert log, we opened a case with oracle (this was when we were @ 9.2.03) [[ORA-04030: out of process memory when trying to allocate 2097184 bytes (joxcx callheap,ioc_allocate ufree) ]] Oracle response to the TAR was that there were some memory leaks with executing java stored procedures and recommended applying the 9.2.0.4 patch...which we did ...It did not fix the issue. We have noticed that whenever there are many occurances of 4030 in the alert log users run into TNS could not start dedicated server process and we are forced to restart. Your help in this matter is greatly appreciated. Thanks for your time Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[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.net -- Author: Faan DeSwardt 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: Old thread - trace file location
Okay, I was hallucinating -- and it is only Wednesday! I had been looking through some old emails yesterday. The thread was on September 17 18, 2002. If you are interested, go to Google and enter Oracle-l backup controlfile to trace. Elegant solutions were posted by Waleed Khedr, Richard Markham, and Ron Thomas. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- 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).
10046 traces hit the mainstream
I'm happy to see in the Jan/Feb '04 issue of OraMag that the use of Oracle's extended trace was being explained. I know I've heard that Traffic analogy somewhere beforeHey! Cary's the article's author! I also appreciated the reference to 10g as being in the future, since it's promise date has come and gone... ;) Jonathan, your article looks very interesting and useful too, but I'm still struggling with the simple analytics yet. :) Rich Rich JesseSystem/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: What gives??
[EMAIL PROTECTED] oriole]$ export AWK=awk '{print \$4}' [EMAIL PROTECTED] oriole]$ echo ${AWK} awk '{print $4}' [EMAIL PROTECTED] oriole]$ cal | awk '{print $4}' We 7 14 21 28 [EMAIL PROTECTED] oriole]$ cal | ${AWK} awk: cmd. line:1: '{print awk: cmd. line:1: ^ Invalid char ''' in expression [EMAIL PROTECTED] oriole]$ cal | ${AWK} bash: awk '{print $4}': command not found [EMAIL PROTECTED] oriole]$ cal | eval ${AWK} We 7 14 21 28 [EMAIL PROTECTED] oriole]$ Nikhil Khimani wrote: LG, I know there is a simple solution to this .. but I can't think of it right now. Any help will be appreciated ... Thanks, Nikhil = [ny-nikhil1:/export/home/nkhimani/bin]$ export AWK=awk '{print \$4}' [ny-nikhil1:/export/home/nkhimani/bin]$ echo ${AWK} awk '{print $4}' [ny-nikhil1:/export/home/nkhimani/bin]$ cal | awk '{print $4}' W 7 14 21 28 [ny-nikhil1:/export/home/nkhimani/bin]$ cal | ${AWK} awk: syntax error near line 1 awk: bailing out near line 1 [ny-nikhil1:/export/home/nkhimani/bin]$ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Nikhil Khimani 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). -- Regards, Stephane Faroult Oriole Software -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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: ORA-12540: TNS: internal limit restriction exceeded
I apologise for the wrong error #...it was a typo on my partthe error # is 12540 Here is the error stack === TNS-12500: TNS:listener failed to start a dedicated server process TNS-12540: TNS:internal limit restriction exceeded TNS-12560: TNS:protocol adapter error TNS-00510: Internal limit restriction exceeded 32-bit Windows Error: 8: Exec format error === Murali. |-+ | | Faan DeSwardt | | | [EMAIL PROTECTED]| | | et | | | Sent by: | | | [EMAIL PROTECTED]| | | .com | | || | || | | 01/21/2004 03:09 | | | PM | | | Please respond to| | | ORACLE-L | | || |-+ --| | | | To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] | | cc: | | Subject: Re: ORA-12540: TNS: internal limit restriction exceeded | --| Murali, Have you checked the OS event logs like the system log? Sounds like you have hit an OS limit. Please post the rest of the error stack that followed the ORA-12450 as this gives more information on what is the root cause of this failure? You can find this in the listener.log at the time of the failure. -f - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 10:19 AM Hi All, We are running 9.2.0.4 on windoze 2000 server and this morning we were forced to restart the database server. Users complained about not able to connect to database... TNS could not start dedicated server process...So I tried to connect to db using OS authentication...(sqlplus / as sysdba) and ran into ORA-12540: TNS: internal limit restriction exceeded. Where is this limit set? Is it possible to change the setting? Here is some additional information The application that connects to this db is java based...In the past when we were seeing lot of 4030 errors in the alert log, we opened a case with oracle (this was when we were @ 9.2.03) [[ORA-04030: out of process memory when trying to allocate 2097184 bytes (joxcx callheap,ioc_allocate ufree) ]] Oracle response to the TAR was that there were some memory leaks with executing java stored procedures and recommended applying the 9.2.0.4 patch...which we did ...It did not fix the issue. We have noticed that whenever there are many occurances of 4030 in the alert log users run into TNS could not start dedicated server process and we are forced to restart. Your help in this matter is greatly appreciated. Thanks for your time Murali. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: Murali_Pavuloori/[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.net -- Author: Faan DeSwardt 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.net -- Author: INET: Murali_Pavuloori/[EMAIL PROTECTED] Fat City Network Services-- 858-538-5051
Re: V$system_event
On 01/21/2004 02:29:26 PM, Cary Millsap wrote: Jolene, Mladen's answer is a good one. There is also an in-depth discussion on this subject on pp210-217 of the book Optimizing Oracle Performance. I knew that you will immediately recognize method C! -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Password management using profiles
On 01/21/2004 02:54:25 PM, Spears, Brian wrote: Yup..we just added the functionalty to the verify_password functionwala. Brian S. Brian, are you related to the young lady named Britney and whose marriage was shorter then the average transaction on my database? She happens to have the same last name as you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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: Password management using profiles
Thanks for your reponses. We're working on make these changes now. Ana E. Choto American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 Spears, Brian [EMAIL PROTECTED] rands.com To Sent by: Multiple recipients of list [EMAIL PROTECTED] ORACLE-L [EMAIL PROTECTED] .com cc Subject 01/21/2004 02:54 RE: Password management using PMprofiles Please respond to [EMAIL PROTECTED] com Yup..we just added the functionalty to the verify_password functionwala. Brian S. -Original Message- [EMAIL PROTECTED] Sent: Tuesday, January 20, 2004 5:59 PM To: Multiple recipients of list ORACLE-L You have to check for errors in the ORA-28000 range, for this is the range that password problems will use. Add a check in your connection section that will propagate any exception encountered. You can also trap the Oracle errors for password expiration or locked account and display a more understandable message instead. This is the way I did it. Also, create a function or procedure that checks the EXPIRY_DATE and ACCOUNT_STATUS in the all_users or dba_users table to determine when the password will expire or if it has already. The function/procedure then can raise an exception if the account is within the grace period or locked. RWB Reginald W. Bailey IBM Global Services JPMC Account - DCI ETS Database Management Your Friendly Neighborhood DBA 713-216-7703 (Office) 281-798-5474 (Mobile) [EMAIL PROTECTED] [EMAIL PROTECTED] [EMAIL PROTECTED] n.eduTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: Password management using profiles ity.com 01/20/2004 02:49 PM Please respond to ORACLE-L We're using pl/sql gateway and the Apache server. We've set up a default DAD on the gateway configuration screen, the connect string is our server name. Basic authentication, Package/Session Management Type: Stateless(Reset Package State). I've tried the profile by setting up a test user and expiring the account. If I go to sqlplus and log in with the expired user account sqlplus prompts me for a new password. I don't have a problem with that, but you know how users are, they wouldn't figure out why. And management wants users to receive a message telling them why they have to change their passwords without going through the Help Desk. My guess is that a pl/sql package has to be written so users get their password check at login time and receive messages such as the number of days they have before the password expires, or that the password is actually expired. Thanks Ana E. Choto Systems Programmer American University e-Operations - Information Technology Phone (202) 885-2275 Fax (202) 885-2224 Mladen Gogala [EMAIL PROTECTED] ng.com To Sent by: Multiple recipients of list [EMAIL PROTECTED] ORACLE-L [EMAIL PROTECTED] .com cc Subject 01/20/2004 03:24 Re: Password management using PMprofiles Please respond to [EMAIL PROTECTED] com On 01/20/2004 02:34:45 PM, Ana Choto wrote: I have set up a profile where the passwords expire in 30 days, 6 characters minimum, grace period before the account locks to 6 days. It works as expected when the user logs in to our web site and
Re: Re: pga_aggregate_target and a memory leak
I think it depends on your applications. In DSS type environments we are still stuggling to figure out if P_A_T is helping or not. Initial tests are not in P_A_T's favor. But in another Application, that is 80% OLTP, P_A_T was the only choice to avoid swapping. This 9.2.0.3 database had the S_A_S set to 2MB (S_A_R_S = 1MB)at the instance level. It has over 600 persistent users. No MTS in use. - Kirti --- [EMAIL PROTECTED] wrote: kirti-- would you recommend avoiding pga_aggregate_target for now? From: Kirtikumar Deshpande [EMAIL PROTECTED] Date: 2004/01/21 Wed PM 02:44:31 EST To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: pga_aggregate_target and a memory leak Replies in line... - Kirti --- [EMAIL PROTECTED] wrote: Kirti, you're back! Thanks. Found some slack time from routine DBA work! Must have finished the book. :) Not yet.. Its tough.. Re the PGA problems, what was the value for 'over allocation count' in v$pgastat? Actually, I never bothered to look at v$pgastat. Should have.. and will, when we do some more testing next week.. Did you try increasing P_A_T to a larger number? Yes... Oracle is supposed to grab the memory it needs, if available, regardless of the P_A_T setting. Also, did your system go in to excessive paging or swapping? Yes, it did with a large P_A_T. I've been curious as to what the effects would be of having P_A_T too low. I saw more disk sorts.. As time permits, I will play with event 10032, 10033 trace for sorts to see what's going on.. Oracle is supposed to grab whatever memory it needs. I'm assuming at this point that doing so involves a different code path as it needs to alloc the memory. Don't know what the cost of that is, haven't tried to test it. It seems likely that the OS was out of memory, regardless of the P_A_T value. No. The system has 4 GB of physical memory. Over 2GB was free. Jared Kirtikumar Deshpande [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 06:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: pga_aggregate_target and a memory leak Setting P_A_T to a 1GB limit with over 2GB of *available memory* on AIX 4.3.3 and 9.2.0.4 caused ORA-4030, till we turned off hash joins. OS level resources (ulimit -a) were all set to 'unlimited'. In a very limited testing, setting P_A_T to less than S_A_S (and S_A_R_S) worked, however, the disk sorts increased. Finally, Developers chose no hash joins, 1GB P_A_T and 'AUTO' workarea_size_policy... seems to run okay... - Kirti --- Stephane Faroult [EMAIL PROTECTED] wrote: [EMAIL PROTECTED] wrote: One of our production DBAs does not want to use pga_aggregate_target on a 9.2.0.3 instance due to a possible memory leak. The only note on memory leaks and pga_aggregate_target I can find on metalink is: 334427.995 doesnt seem to apply to pga_aggregate_target. We are on sun solaris. Dont know version offhand. he is under the impression that if we patch to 9.2.0.4 this goes away. not sure about that either... Be careful with pga_aggregate_target. I have very recently seen a case (Solaris + 9.2 but I cant't tell you exactly which patch level - probably the most recent) where two (by the way atrocious) queries generated by a DSS tool were responding very differently - and in a way that differences in the queries couldn't explain. From an Oracle standpoint, stats were roughly the same. Tracing proved that we were waiting for CPU, and truss that a call to mmap() was the culprit. Why, no idea. We first switched it (pga_thing) off, no more slow call to mmap(). However, it was still slow because we hadn't checked sort_area_size which was ridiculously small. We set sort_area_size to 10M, still with pga_aggregate_target unset, and once again the same very slow calls to mmap(). Memory misalignment? Anything else? Not much time to enquire but it looks like a mine field. -- Regards, Stephane Faroult Oriole Software -- __ Do you Yahoo!? Yahoo! Hotjobs: Enter the Signing Bonus Sweepstakes http://hotjobs.sweepstakes.yahoo.com/signingbonus -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Kirtikumar Deshpande INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: help
LOL!! Ok, Ashish, the problem is you sent 'help' to the list address. Send HELP to [EMAIL PROTECTED] and all will be well. Ok, now back to work everyone. Jared Odland, Brad [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/21/2004 07:59 AM Please respond to ORACLE-L To:Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Ashish realizing his time is short he crawls to the terminal and with his last remaining strength double clicks the outlook icon, clicks the new button selects New Mail Message button, using the shift key he types H - E - L - P in the message body window and hits send and then CANCEL to stop the spell checker, and then YES to send his message anyway. His message careens through the internet as he slumps to the floor as the world goes dark. The world will be safe now if they can break the code are his final thoughts before oblivion takes him. Minutes later hundreds of Information Systems professionals are reading his message wondering what horror occurred that drove a man to do this. They pause to reflect and then selecting the message in their inbox they press the delete key and go get a fresh cup of coffee. -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 8:59 AM To: Multiple recipients of list ORACLE-L Subject: RE: Funny ... Ashish is from Weight Watchers and asking for HELP my advise ... stop starving yourself ... go eat something. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Mark Leith [mailto:[EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 9:45 AM To: Multiple recipients of list ORACLE-L Subject: RE: must.resist..temptation. For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. Live long and prosper. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ashish Sahasrabudhe Sent: 21 January 2004 14:34 To: Multiple recipients of list ORACLE-L Subject: HELP
RE: Old thread - trace file location
Title: RE: Old thread - trace file location For 9.2 users: Alter database backup controlfile to trase as '/disk1/backup/ccf.sql' reuse noresetlogs; Alex. -Original Message- From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 21, 2004 12:24 PM To: Multiple recipients of list ORACLE-L Subject: RE: Old thread - trace file location Okay, I was hallucinating -- and it is only Wednesday! I had been looking through some old emails yesterday. The thread was on September 17 18, 2002. If you are interested, go to Google and enter Oracle-l backup controlfile to trace. Elegant solutions were posted by Waleed Khedr, Richard Markham, and Ron Thomas. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, January 21, 2004 11:19 AM To: Multiple recipients of list ORACLE-L Unless I am hallucinating (always a distinct possibility), there was a recent discussion on this list about the trace file location when you perform an ALTER DATABASE BACKUP CONTROLFILE TO TRACE, with some ingenious solutions. I didn't think I'd need this, so deleted the postings. Well, guess what I need that. Could someone who saved some of these forward me the date and subject? Do it privately to avoid clogging the bandwidth. Thanks. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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.net -- 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: Does SQL Server have a wait interface?
I believe the Jan edition of SQL Server magazine has an article on this very subject. -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 21, 2004 8:35 AM To: Multiple recipients of list ORACLE-L anyone know? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: [EMAIL PROTECTED] 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.net -- Author: Grabowy, Chris 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).