Re: truss/trace/strace equivalent on Windows
Hi Peter, You are right. Combination of strace.exe and grep.exe(at http://unxutils.sourceforge.net/) will help me. I'll be able to extract system calls of specific threads from strace output. thanks again... Peter Gram wrote: Hi Danisment What do you mean by debuging threads ? On NT/W2K everything is threads. If you give som more information on the problem/what you whant. I migth be able to give to help you with the correct tool. Danisment Gazi Unal (ubTools) wrote: Thanks Peter, I've been using this utility. But, It's reporting system calls in process level. regards... Peter Gram wrote: Hi Danisment Long time no see There is free version of truss for nt called strace (http://razor.bindview.com/tools/desc/strace_readme.html) this migth help you Have fun ;-) Danisment Gazi Unal (ubTools) wrote: Hi to all, I need a utility to debug Oracle's thread on Windows2000. do you know a utility which can trace windows system calls in thread level ? thanks in advance... -- Danisment Gazi Unal http://www.ubTools.com Web-based Oracle Database Products -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Mlv http://miracleas.dk -- Danisment Gazi Unal http://www.ubTools.com Web based Oracle database products -- /regards Peter Gram Mobil : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Mlv http://miracleas.dk -- Danisment Gazi Unal http://www.ubTools.com Web based Oracle database products
truss/trace/strace equivalent on Windows
Hi to all, I need a utility to debug Oracle's thread on Windows2000. do you know a utility which can trace windows system calls in thread level ? thanks in advance... -- Danisment Gazi Unal http://www.ubTools.com Web-based Oracle Database Products
Re: SQLNet and NET8
Hi, I had encountered this question 3 years ago. But, unfortunately I don't remember the answer very well. The answer for same ORACLE_HOME depends on the names of SQL*Net and NET8 files. If they are different, no problem. If same, use different ORACLE_HOME. As I said before, I'm not sure. But, This is documented in Oracle support. Call them, they have the answer. For different ORACLE_HOMEs, I don't see a problem. regards... [EMAIL PROTECTED] wrote: Yes, as long as they are in different Oracle_Homes. Dick Goulet Reply Separator Author: Satish Iyer [EMAIL PROTECTED] Date: 8/19/2002 1:38 PM Is it possible to have SqlNet and Net8 installed on the same client machine ? The reson behind this is that on the same machine we have an 3rd party application which can connect only through sqlnet and for the rest of the apps we want to use net8. Any ideas on this configuration should be done. Many thanks Satish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Satish Iyer INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 Corp. move to India
Yes, India deserves that. Ray Stell wrote: Heard on the BBC radio at lunch that Oracle Corp. is moving alot of operations to India, 1800 new jobs. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: finding pasword emails. Virus ???
Hello list, I'm getting many finding pasword emails from non-registered users. have you got this type of email ? is it a spam or virus ? regards... -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: UNDO
Hello Fink, I guess you meant recursive transaction. Because, user SQLs in stored codes run as recursive SQLs, but they are not recursive transactions. Recursive transactions don't have to be use SYSTEM rollback segment. If the RBS of parent statement can not be binded to its recursive transaction, Oracle assigns SYSTEM rbs to recursive transaction. Otherwise, recursive transaction use same RBS with its parent. In other words, SYSTEM rbs is the last resort. regards... Fink, Dan wrote: John, The system rollback segment must be kept online for use by the kernel calls (recursive sql). I admit that I have never tried taking it offline in automatic undo mode, so I'm not sure exactly what would happen. However, my educated guess is that it would not be pretty! Dan Fink -Original Message- Sent: Wednesday, July 17, 2002 2:14 PM To: Multiple recipients of list ORACLE-L All, When using automated UNDO in 9iR1, should the system rollback segment normally be left offline? TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fink, Dan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Error on creating index
Hello, What does "Oracle stops" mean ? If Oracle crashes without an error, check alert.log. If not, debug your session with event 1006 level 8 to see Oracle kernel events. regards... Ali TOYGAR wrote: Hi , I have a problem with creating an index ot table AAA with 40 records.After I write following sql and run it ORACLE stops.CREATE INDEX index_1 ON USER1.AAA ( field1, field2 )I copied same table to user2 and when I write above sql it runs CREATE INDEX index_1 ON USER2.AAA ( field1, field2 )Both users ( user1 and user2 ) have same priviliges.(unlimited tables space,connect,resource,...)what is the problem.please help me -- Danisment Gazi Unal http://www.ubTools.com
Re: how to tell if OPS
Hi, I'm not an OPS expert, but X$KCCCP.CPHBT is updated in each CKPT timeout, which is typically 3 seconds. If it's being incremented, the thread is mounted. This will be explained in iOraDumpReader at http://www.ubtools.com/products/ioradumpreader/ioradumpreader.html If I can turn back to this tool again. regards... John Dunn wrote: Is there any easy way to tell whether an instance is running under OPS or not? John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Dunn INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Questionable V$SQLAREA Statistics
Hi, You should not compare tkprof outputs with V$SQL,V$SQLAREA. Because, recursive/child statistics are included in their parent statements in these views. But, tkprof substructs recursive statistics. I mean tkprof reports real values for statements, but dictionary doesn't. regards... Orr, Steve wrote: Here's the scene: 1) I have a 400,000 row table table which is cached. 2) I have a query against that table and no other with one column referenced in the WHERE clause. (This column is indexed and of course I don't really need the index since the table is cached but it's there so ho hum...) 3) When I run tkprof on the query it shows a full table scan ignoring the index... that's what I want 'cause it's cached. 4) But when I look at V$SQLAREA the DISK_READS column is incremented. 5) This query is executed very often so my StatsPack report lists it as one of the most expensive queries in terms of physical reads. It appears that Oracle is counting full table scans of cached tables as DISK_READS in V$SQLAREA. Seems like this is a bug to me 'cause it's not really a physical disk read but is getting data from the buffers. Don't you think this is a bug? Has anyone seen this before? Steve Orr Looking for cache in Bozeman, Montana -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-600 during replication
Hi, Upload your trace file to iOraBugFinder at http://www.ubtools.com/products/iorabugfinder/iorabugfinder.html . regards... Vladimir Barac - posao wrote: Good morning / afternoon/ evening (depending on your position)... Alert log has following lines... Tue Jun 25 10:07:30 2002 Errors in file E:\Oracle\admin\vurs\bdump\vursSNP2.TRC: ORA-12012: error on auto execute of job 123 ORA-12008: error in snapshot refresh path ORA-00600: internal error code, arguments: [ktbdchk1: bad dscn], [], [], [], [], [], [], [] ORA-06512: at SYS.DBMS_SNAPSHOT, line 617 ORA-06512: at SYS.DBMS_SNAPSHOT, line 674 ORA-06512: at SYS.DBMS_IREFRESH, line 577 ORA-06512: at SYS.DBMS_REFRESH, line 211 ORA-06512: at line 1 What the hell is going on? I tried to do some search on metalink, but to no avail. Hate to say this, but it is kind of urgernt! Regards, Vladimir Barac -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vladimir Barac - posao INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: some questions regarding jobs in EU/US
Hello, I'm new to this topic. I don't know any procedures in detail. As I know, to work in EU/US, I need to get work permission. What is the procedure of getting work permission ? How long does it take to get work permission ? You can email me directly not to bother others... regards... -- Danisment Gazi Unal Adana, Turkey -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: rbs oracle data block corrupted
Hi, Normally, you should not have seen an rbs corruption message in startup since Oracle7.3+ doesn't rollback in startup. It's postponed. But, there are some cases that Oracle touches rbs in startup: - Active transactions in the SYSTEM rbs are immediately rolled back. They are not postponed. - Rbs headers are always touched. In other words, your SYSTEM rbs, or an rbs header is corrupted. Identify which object corrupted. Let's know which object is corrupted. If you can recover, do it. If not, As Tim Gorman said in his excellent answer, dump rbs. Then email it to the list and let's interpret it. regards Atul Kumar Srivastav wrote: version : 8.1.6 -Original Message- From: Danisment Gazi Unal (ubTools) [mailto:[EMAIL PROTECTED]] Sent: Sunday, June 30, 2002 12:13 AM To: Multiple recipients of list ORACLE-L Subject: Re: rbs oracle data block corrupted Hi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com -- Danisment Gazi Unal http://www.ubTools.com
Re: rbs oracle data block corrupted
Hi, which version of Oracle are you using ? what are the all error messages ? regards... Atul Kumar Srivastav wrote: Hi All ! We have one problem. We can mount the database but not able to open it. It gives following error while opening: One Oracle Data Block Corrupted. RBS01.dbf (datafile for rollback segment) How can i repair this corruption? Atul -- Danisment Gazi Unal http://www.ubTools.com
Re: production database on aix won't be open, help
Hello Rajesh, I don't know Oracle Corp. has published Deferred Transaction Rollback term externally. But, I know this term is available. Deferred Transaction Rollback was introduced in 7.3. It enables database to be opened after roll forward is completed. The rollback of any uncomitted tx will be done by SMON/user process after database is opened. In other words, there is no rollback operation in Deferred Transaction Rollback. It's just a roll forward operation. In Oracle8i, Oracle corp. has renamed Parallel Transaction Recovery term to Fast Start Parallel Rollback term. If SMON determines that tx has 100+ rollback blocks, SMON uses parallel query slaves to complete rollback. I think we are saying same thing. regards... [EMAIL PROTECTED] wrote: >> I had meant Deferred Transaction Rollback which enables a database to be opened as soon as the roll forward using the redo log file is completed. I thought deferred transaction rollback had only to do with storing rollback information for offline tablespaces. What am I missing? Or is the terminology confusing me? Raj "Danisment Gazi Unal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> (ubTools)" cc: dunal@ubTool Subject: Re: production database on aix won't be open, help s.com> Sent by: root@fatcity. com June 19, 2002 05:37 PM Please respond to ORACLE-L Yes, These are right too. But, I think, these are related to fast start parallel rollback. I had meant Deferred Transaction Rollback which enables a database to be opened as soon as the roll forward using the redo log file is completed. I think we are saying same thing on different topics. regards... [EMAIL PROTECTED] wrote: > Yup. FYI, this is what Metalink says: > > A final new feature for > specifying bounded recovery time > is the use of fast-start > parallel rollback. In prior > versions of Oracle, although > database recovery time was > reduced because Oracle could > open the database after the > instance roll-forward process > completed, the transaction > rollback could still take a long > time, particularly for parallel > DML operations, because rollback > had to happen serially. In > Oracle8i, you can specify the > FAST_START_PARALLEL_ROLLBACK > parameter to low or high to > allow SMON to use parallel-query > slaves for parallel rollback, > thus speeding up the rollback > process. Monitoring parallel > rollback can be accomplished > using the V$FAST_START_SERVERS > and V$FAST_START_TRANSACTIONS > views. > > > And on Technet: > > Fast-start parallel rollback is mainly useful when a system has > transactions that run a long time before committing, especially parallel > INSERT, UPDATE, and DELETE operations. When SMON discovers that the amount > of recovery work is above a certain threshold, it automatically begins > parallel rollback by dispersing the work among several parallel processes: > process 1 rolls back one transaction, process 2 rolls back a second > transaction, and so on. The threshold is the point at which parallel > recovery becomes cost-effective, in other words, when parallel recovery > takes less time than serial recovery. > > One special form of fast-start parallel rollback is intra-transaction > recovery. In intra-transaction recovery, a single transaction is divided > among several processes. For example, assume 8 transactions require > recovery with one parallel process assigned to each transaction. The > transactions are all similar in size except for transaction 5, which is > quite large. This means it takes longer for one process to roll this > transaction back than for the other processes to roll back their > transactions. > > In this situation, Oracle automatically begins intra-transaction recovery > by dispersing transaction 5 among the processes: process 1 takes one part, > process 2 takes another part, and so on. > > You control the number of processes involved in transaction recovery by > setting the parameter FAST_START_PARALLEL_ROLLBACK to one of three values: > > FALSE Turns off fast-start parallel rollback. > > LOW Specifies that the number of recovery servers may not exceed twice > the value of the CPU_COUNT parameter. > > HIGH Specifies that the number of recovery servers may not exceed four > times the value of the CPU_COUNT parameter. > > > Regards > Raj > > > "Danisment > Gazi Unal To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> > (ubTools)" cc: > dunal@ubTool Subject: Re: production database on aix won't be open, help > s.com> > Sent by: > root@fatcity. > com > > > June 19, 2002 > 04:27 PM > Please > respond to > ORACLE-L > > > > Hello Rajesh, > > You are definitly right. But, as I know Deffered Transaction Rollba
Re: SMON Using Lots of Memory in 9i
Hello, how utility/tool said that SMON was using 50M+ ? regards... Carle, William T (Bill), ALCAS wrote: Hi, We recently converted to 9i and the SMON process seems to be using lots of memory. (more than 50 mb) Has anyone else seen this or can explain it? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SMON Using Lots of Memory in 9i
Hello, I mean how did you find that SMON is using 50M+ ? regards... Danisment Gazi Unal (ubTools) wrote: Hello, how utility/tool said that SMON was using 50M+ ? regards... Carle, William T (Bill), ALCAS wrote: Hi, We recently converted to 9i and the SMON process seems to be using lots of memory. (more than 50 mb) Has anyone else seen this or can explain it? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: SMON Using Lots of Memory in 9i
Hi Carle, I'm not sure if shared memory/library segments are not included in SMON's address space in your case? If you are using Sun, please see Note:163763.1 regards... Carle, William T (Bill), ALCAS wrote: Our application uses Glance. Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -Original Message- Sent: Thursday, June 20, 2002 1:51 PM To: Multiple recipients of list ORACLE-L Subject:Re: SMON Using Lots of Memory in 9i Hello, how utility/tool said that SMON was using 50M+ ? regards... Carle, William T (Bill), ALCAS wrote: Hi, We recently converted to 9i and the SMON process seems to be using lots of memory. (more than 50 mb) Has anyone else seen this or can explain it? Bill Carle ATT Database Administrator 816-995-3922 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Carle, William T (Bill), ALCAS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wait event problems
Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-00604 and ORA-01578
Hi, First of all, find the corrupted object by the following SQL: Select segment_name, segment_type from dba_extents where file_id=your_file# and your_block# between block_id and block_id + blocks -1; Most probably, it's an rbs. If you have time to import, do it. If not, add following parameters to init.ora and restart db: event = 10015 trace name context forever, level 10 Then, email the trace file. regards... [EMAIL PROTECTED] wrote: I have a system when I issued a select statement, I get the following error. ORA-00604 Error Occur at recursive level 1 ORA-01578 Oracle Datablock corrupted. File 6 Block 2853 ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS We have an export that we may be able to restore. The database is running in non-archive mode. Any idea on how to resolve this problem? Thank you in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: AW: off topic: anyone form Amsterdam, Holland / other major e
What a nice behaviors. But, there are bad cases too. When I was in a european country, two nice girls had taken me to a restaurant/bar. do you know the fee: 1000$. Of course I did not pay. Also, one of my friend had paid 250$ ,instead of 25$, for a taxi. regards Lyuda Hoska wrote: It could have happened in America, too. All depends on the area. -Original Message- Sent: Tuesday, June 11, 2002 1:13 PM To: Multiple recipients of list ORACLE-L I had a friend who mistakenly left her purse on a bus stop bench somewhere in Switzerland (I'm not sure of the city). By the time she'd realized it and gotten back to the bus stop, 4 hours had passed. Her purse was still there, with everything and all the money still in it. Cheers!, JoJo -Original Message- Sent: Tuesday, June 11, 2002 10:39 AM To: Multiple recipients of list ORACLE-L e You're in for a surprise Rachel, The Swiss are well known jokers. Switzerland is often called the prank capital of Europe. Ladies toilets are labelled Gentlemen. Gentlemen's toilets are labelled Kodak moment photo opportunity. Cars drive on the left side of the road except for blue cars wich must drive on the left. Dogs and cats are, by convention, dyed red during the summer. BTW I lost my sunglasses in Switzerland in 1994 so if anyone found them can they get in touch. Mike PS You can probably tell that I'm between coffees right now. -Original Message- Sent: 11 June 2002 17:29 To: Multiple recipients of list ORACLE-L europ If you don't know local conventions ANYWHERE, you will be surprised however, now I'm curious. just what happens? --- Jan Pruner [EMAIL PROTECTED] wrote: Nicht nur in Zurich. No, they aren't. But if you don't know conventions in Switzerland you will be surprised. :-) JP This email and any attached to it are confidential and intended only for the individual or entity to which it is addressed. If you are not the intended recipient, please let us know by telephoning or emailing the sender. You should also delete the email and any attachment from your systems and should not copy the email or any attachment or disclose their content to any other person or entity. The views expressed here are not necessarily those of Churchill Insurance Group plc or its affiliates or subsidiaries. Thank you. Churchill Insurance Group plc. Company Registration Number - 2280426. England. Registered Office: Churchill Court, Westmoreland Road, Bromley, Kent BR1 1DP. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately Mike INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: JoJo Al-Zawawi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyuda Hoska INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: ORA-00604 and ORA-01578
Hi, I think he will not be able to drop rbs since there is an active transaction in this rbs. But, if he can recreate his table, there will be no need this corrupted rbs. Then, he can recreate this rbs. regards... DENNIS WILLIAMS wrote: Peter - Kevin Kennedy on the list (hope you don't mind me giving you credit, Kevin) noticed that your tablespace was named RBS1. Maybe you can simply drop and recreate the rollback segment? But also turn on the parameters to make sure you aren't propagating corruption. Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, June 11, 2002 12:45 PM To: '[EMAIL PROTECTED]' Cc: '[EMAIL PROTECTED]' Peter - You can use the DBMS_REPAIR package included with Oracle to locate the corrupt blocks. If the data in the corrupted blocks is extremely important, you can use this to dump the block contents. Then you can change the blocks so Oracle will skip the corrupted blocks. Then you can export the table or copy the contents to another table. Dropping the tables and recreating it from your export is also an option. Don't forget to rebuild indexes afterward. Run ANALYZE TABLE VALIDATE CASCADE to find any other corrupt blocks in other tables. And turn on the init.ora parameter DB_BLOCK_CHECKING to detect any further corruptions before they occur. Good luck. -Original Message- Sent: Tuesday, June 11, 2002 12:29 PM To: Multiple recipients of list ORACLE-L I have a system when I issued a select statement, I get the following error. ORA-00604 Error Occur at recursive level 1 ORA-01578 Oracle Datablock corrupted. File 6 Block 2853 ORA-01110 Datafile 6 E:\ORANT\DATABASE\RBS1.DBS We have an export that we may be able to restore. The database is running in non-archive mode. Any idea on how to resolve this problem? Thank you in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 connection
Hi, It's another bad error to diagnose. But, there should be a good note for ora-3113 at metalink. Also, If Oracle can not know that a process is being terminated, there will be no trace for this error. Because Oracle will not have a chance to dump trace file. regards... Alexandre Gorbatchev wrote: End of communication channel is common message when server process is terminated. You may take a look at alert.log on server-side to see what could cause it to terminate. It's often there. Also trace file for that session on the server. -- Alexandre - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, June 04, 2002 2:08 PM hai all. my database connection has a problem. when user start to establish connection... an error returns End of communication channel. So no user can log in. I've already checked the status of listener , reinstall net8 component, trace file. Seems those are oke. what should i do ? thanks rgds fico -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Softhome - Fico INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexandre Gorbatchev INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Production Database Open Fails after Mount
Hi, As I remember Error Num 23 is OS error code. Contact your system admin. There should be a text file which defines OS error codes. VIVEK_SHARMA wrote: Solved Database OPENed Successfully on another HP-UX Box Without any ORA-1092 The Same Oracle OS Versions Existed on Both HP-UX Boxes . NOTE Though ORA-1092 was often succeeded by the message :- Error Num 23 NO Idea what Error Num 23 Stands for ? Thus This seems to be Some OS /Hardware Issue with the Previous Production Database on which the Database would NOT Open after OS RE_Installation . For Problem Details Go Below . For Complete Details Either E-mail me Or See Tar Nums - 2263888.995 , 9505435.7 (If accessible) Thanks to All List Vivek -Original Message- Sent: Monday, June 03, 2002 11:57 PM To: LazyDBA.com Discussion Hi Gopal,List What are those UNdocumented Events ? Thanks again Vivek -Original Message- Sent: Monday, June 03, 2002 4:51 PM To: LazyDBA.com Discussion Vivek: I guess SMON runs the command to get the details for regular cleanup. You can use few undocumented events to get the things done depending on the seriousness of the database. These events just asks the SMON to skip few things during recovery and pretty harmless. Best Regards, K Gopalakrishnan - Original Message - From: VIVEK_SHARMA [EMAIL PROTECTED] To: LazyDBA.com Discussion [EMAIL PROTECTED] Sent: Monday, June 03, 2002 4:29 PM Subject: RE: Production Database Open Fails after Mount Problem Still Existing . ora_3263.trc file :- ORA-01092: ORACLE instance terminated. Disconnection forced Current SQL statement for this session: select line#, sql_text from bootstrap$ where obj# != :1 bootstrap$ seems to tbe the CAUSE . Any Advice ? 1) STATUS in V$LOG shows 2 Groups as INACTIVE the 3rd as CURRENT NOTE - Log Switches are Happening even in Mount State due to some internal Database Activity at the rate of about 5 Switched in 12 Hours . Size of Redo Logfile = 5M 2) RECOVER DATABASE UNTIL CANCEL Succeeds , But ALTER DATABASE OPEN RESETLOGS Also Fails with ORA-1092 like ALTER DATABASE OPEN 3) We Created a SMALL Dummy Database on the Same machine using the Same ORACLE_HOME which we were able to open eith the Same SGA as the Production Database . Thus Prima-facie the O.S. Oracle S/w seem OK . We relinked the network rdbms Components of Oracle 7.3.4.0 too though 4) Due to Root Disk Crash OS was RE-Installed , But Oracle Software Existed Existed on another Hard Disk was Simply Mounted back without any Change after the OS RE-Installation Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-600
Hi, Add event=10015 trace name context forever, level 10 to init.ora and restart db. A trace will be dumped which shows some rbs headers before and after recovery. can you email it ? Nalla Ravi wrote: Dear All, I am gettying the follwoing error on our alert_log file,though no porblem in the activity of database. Has any one faced this problem, It is AIX, Oracle 8.1.7 Database and non archived mode. We never gave like recover any thing, why it is trying to recover from error message as follows? ORA-00600: internal error code, arguments: [2023], [5], [1], [], [], [], [], [] Mon May 13 16:10:59 2002 ORACLE Instance PAR_D1 (pid = 6) - Error 600 encountered while recovering transaction (7, 43) on object 1. Mon May 13 16:10:59 2002 Thanks for your help. Ravi __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Nalla=20Ravi?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Wait time for SQL*Net message
Hi, I always see "SQL*Net message from client" as a problem if I see "SQL*Net message to client" is a problem. Of course, this can not be a rule, but may be useful in practice to start a performance analysis. In your case "SQL*Net message to client" is 5.30 seconds. It's too low for your case. But your "SQL*Net more data to client" is 323.88 seconds = 5.398 minutes. Although it looks like a problem, I think it's a consequence. Of course you can tune your array operations to client. But, important thing here is that if you need to send many SQL*Net packets to client ??? I mean do you need to process many Oracle blocks. If you can reduce number of Oracle blocks processed by you, this will reduce both "SQL*Net more data to client" and "CPU used by this session". Important thing in your statistics is that your "CPU used by this session" is 2293.27 seconds= 38 minutes. What was the interval of your observation ? how many CPU have you got ? is there a bottleneck in CPU ? Bottlenecks in CPU causes distorted Oracle wait measurements. Some of time are missed, some of time are assigned to Oracle wait events. As a result Oracle waits may become overvalued. There is a sample in my paper MRRP (not published yet). In this sample, "buffer busy waits" is measured 260.54 seconds by Oracle, but it was 112.03 seconds in practice. That means 57% of "buffer busy waits" is measured wrong by Oracle because of a bottleneck in CPU. regards... danisment http://www.ubtools.com S B wrote: The following statistics is for a server-side application ( pro*c ). The connection is established between proc*c to server as "LOCAl=yes and PROTOCOL=BEQ(sqlplus usr/pass) i.e bypassing the tnsnames.ora and listener.ora Event Wait(cs) %wait --- SQL*Net message from client 463790 61.85186173 CPU used by this session 229327 30.5834578 SQL*Net more data to client 32388 4.319321455 db file sequential read 21698 2.893683986 log file sync 1788 0.23845087 SQL*Net message to client 530 0.070681745 log file switch completion 188 0.025072015 Can anyone tell me about how to reduce the wait time for "SQL*Net message" TIA Bhulu __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: S B INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com
Re: Datafile Corruption ........... or Not
Hi, very interesting. what is the URL for these utilities ? Johnson, Michael wrote: There is also a Pro*C and PL/SQL routine to fix corrupted block problems if you do not have backups. Peace ! Mike -Original Message- Sent: Tuesday, May 28, 2002 1:14 PM To: Multiple recipients of list ORACLE-L Hi, Find the corrupted object by the following statement: Select segment_name, segment_type from dba_extents where file_id=your_file# and your_block# between block_id and block_id + blocks -1 - If it's index, recreate it. - If not, recover the datafile - if no backup, tell us regards... Kevin Lange wrote: Hey gang; I have an 8.0.5.0 database running on a Solaris platform. The developer is running a simple query which returns the error ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 7, block # 191659) ORA-01110: data file 7: '/u08/oradata/TTCT/dynamici01.dbf' So I run dbverify (dbv) against the file and it says all is OK. $ dbv file=dynamici01.dbf DBVERIFY: Release 8.0.5.0.0 - Production on Tue May 28 13:2:7 2002 (c) Copyright 1998 Oracle Corporation. All rights reserved. DBVERIFY - Verification starting : FILE = dynamici01.dbf DBVERIFY - Verification complete Total Pages Examined : 409600 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 158376 Total Pages Failing (Index): 0 Total Pages Empty: 0 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Does anyone have any suggestions about this other than rebuilding the database (it is a clone of our production ... it will just set the developer back if we have to clone it) ? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson, Michael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: sqlplus Connect Slow on
Hi, --- When issued DIRECTLY from the DB Server takes about 1 minute to Reach the SQL prompt That means you had narrowed down the problem. It's not realted to your network. Debug your sqlplus command by truss,trace,strace etc. with its child process. If problem occurs after creating Oracle process, debug Oracle process by adb, dbx etc. to see in which function Oracle is sleeping. If truss etc. returns you are waiting for otrace files(*.dat as I remember), remove them. regards... Ray Stell wrote: what does uptime or top tell you when connections are slow? On Wed, May 29, 2002 at 02:23:30AM -0800, VIVEK_SHARMA wrote: NO MTS used Dedicated Oracle Database Connect processes exist Thanks -Original Message- Sent: Tuesday, May 28, 2002 2:53 PM To: Multiple recipients of list ORACLE-L Hello VIVEK_SHARMA, Do you use MTS? Look at dispatchers load. Tuesday, May 28, 2002, 3:33:18 PM, you wrote: V OS. Tru64 Unix ver 5.1 V Oracle 8.1.7.2 V m/c GS320 Alpha Server V After 900 User processes are Connected to a Database , sqlplus system/manager@Connect String V When issued DIRECTLY from the DB Server takes about 1 minute to Reach the SQL prompt V Any parameters , pointers , Docs ? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to changes the sequence no for the redologs
Hi, I could not understand very well. can you explain the steps you did ? and what is the error you got ? regards... sarath kumar wrote: dear list, i have log sequence no like log%t_1_%s ie logTTM_1_001158967 logTTM_1_001158968 logTTM_1_001158969 logTTM_1_001158970 logTTM_1_001158971 logTTM_1_001158972. i can i reset the logs to logTTM_1_1 logTTM_1_2 and so on. i am on 7.3.4 when i give alter database open resetlogs it is not working. Sarath __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sarath kumar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Datafile Corruption ........... or Not
Hi, Find the corrupted object by the following statement: Select segment_name, segment_type from dba_extents where file_id=your_file# and your_block# between block_id and block_id + blocks -1 - If it's index, recreate it. - If not, recover the datafile - if no backup, tell us regards... Kevin Lange wrote: Hey gang; I have an 8.0.5.0 database running on a Solaris platform. The developer is running a simple query which returns the error ERROR at line 1: ORA-01578: ORACLE data block corrupted (file # 7, block # 191659) ORA-01110: data file 7: '/u08/oradata/TTCT/dynamici01.dbf' So I run dbverify (dbv) against the file and it says all is OK. $ dbv file=dynamici01.dbf DBVERIFY: Release 8.0.5.0.0 - Production on Tue May 28 13:2:7 2002 (c) Copyright 1998 Oracle Corporation. All rights reserved. DBVERIFY - Verification starting : FILE = dynamici01.dbf DBVERIFY - Verification complete Total Pages Examined : 409600 Total Pages Processed (Data) : 0 Total Pages Failing (Data) : 0 Total Pages Processed (Index): 158376 Total Pages Failing (Index): 0 Total Pages Empty: 0 Total Pages Marked Corrupt : 0 Total Pages Influx : 0 Does anyone have any suggestions about this other than rebuilding the database (it is a clone of our production ... it will just set the developer back if we have to clone it) ? Thanks Kevin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (ubTools) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DB Freeze
Hello, Please be careful while reading system state dumps. Because, Oracle's system state dumping function doesn't make consistent read. I mean you can see a process which waiting for a lock while there is no holding process. regards... Gogala, Mladen wrote: Next time do sqlplus / as sysdba, then oradebug setmypid, then oradebug dump systemstate 10 and then oradebug tracefile_name to find out the name of the generated trace file. That is good enough for oracle. If your platform is 64 bit HP-UX 11.0, then you need an OS patch. Included is the note about it from the mighty and all-knowing oracle: Article-ID: Note:73835.1 Circulation:PUBLISHED (EXTERNAL) Folder: server.DBA.Admin Topic: Alerts Title: ALERT:HP-UX: ORA-7445 and Core Dump Generating Oracle Stack Trace Document-Type: ALERT Impact: MEDIUM Skill-Level:NOVICE Updated-Date: 03-MAY-2001 06:19:51 ORA-7445 and Core Dump Generating Oracle Stack Trace Versions Affected ~ Oracle 8.X (64 bit only) Platforms Affected ~~ HP-UX 11.00 (64 bit only) Description ~~~ Whenever an Oracle stack trace is required, the shadow process will core dump. The stack trace in the corresponding trace file will be incomplete. Likelihood of Occurrence Every time an Oracle stack trace is required. Some examples are: 1. an event has been set, and a stack trace is required in the trace file 2. some Oracle error requires a stack trace to be generated Possible Symptoms ~ The alert.log will show something like: ORA-07445: exception encountered: core dump [11] [4286564440] [240] [0] [] [] The corresponding trace file will include the following in the stack: _doprnt _fprintf U_get_previous_frame skdstgframe Error from U_get_previous_frame_x is 1 Stack is not Windable Stack has no Unwind_descriptor Workaround ~~ No workarounds available. Patches ~~~ This problem is fixed by a HP patch. The first patch to include the fix is: PHSS_16849: s700_800 11.0 LIBCL patch This patch will be superceeded; please contact HP Support for detailed patch information. Oracle must be relinked after applying this patch, as follows: %cd $ORACLE_HOME/rdbms/lib %make -f ins_rdbms.mk ioracle The instance needs to be shutdown when relinking. References ~~ bug 939745 : ERRORSTACK EVENT CRASHES FOR 64 BIT ORACLE ON HPUX 11.0 Note 43507.1 : ALERT: HP-UX Patch Levels Advised __ Oracle WorldWide Customer Support -Original Message- From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]] Sent: Tuesday, May 21, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Subject: DB Freeze Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't come up because it reported that some resource it needed was locked. So we had to shot the pmon process. When analyzing the situation later, we found that Oracle didn't dump a single useful trace file, so contacting OWS was pretty much useless. OS logs were clean, no alarms raised there. Has anyone encountered this situation that Oracle freezes and crashes without any trace files? How does one collect useful information in such cases? Are there any tools that we could use to gather at-lease some information before the DB crashes? Thanks in advance for any ideas and tips. Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http
Re: DB Freeze
Hi, Take HANGANALYZE dump, and upload it to iOraHangAnalyzer at http://www.ubTools.com/products/iorahanganalyzer/iorahanganalyzer.html. regards... Rodrigues, Bryan wrote: One way is to do a system state dump level 10. It is done either as svrmgrl or as sqlplus with sysdba privileges. You would use the command alter sesssion set events 'immediate trace name systemstate level 10'; (if you do not have a large user dump file capacity you can alter your session to increase it). This needs to be done on all nodes of the cluster while the cluster is hanging. The dump may take up to 10 minutes to complete, but Oracle will require this for their investigation of the issue. The dump files will be found in the udump directory. We are on 8.1.7.2.1 on HP-UX and we had a similar type of problem and Oracle had me do this when it happened. They were able to use the files in their investigation. Good luck with the issue, Bryan -Original Message- Sent: Tuesday, May 21, 2002 4:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database froze, I mean the only way we could get in was through sqlplus, no other tool would connect. We needed to bring the other side up as soon as possible so didn't spend any time running any queries to see what was the problem. The other side (of the cluster) wouldn't come up because it reported that some resource it needed was locked. So we had to shot the pmon process. When analyzing the situation later, we found that Oracle didn't dump a single useful trace file, so contacting OWS was pretty much useless. OS logs were clean, no alarms raised there. Has anyone encountered this situation that Oracle freezes and crashes without any trace files? How does one collect useful information in such cases? Are there any tools that we could use to gather at-lease some information before the DB crashes? Thanks in advance for any ideas and tips. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodrigues, Bryan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: formating 10046 (level 12) trace file
message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 wants your job
Hello List, Maybe, some of you will not be agree with me, But, I think centralization will occur. Let's imagine that There is no banking system in the world and everyone keeps their money at home. And, someone claims that there will be banks and people will give money to banks. In this case, we would say 'Why'. We would say Why do I give my money to a bank ?. This is same thing for IT sector. Some of us say Why do I give my data ?. I'm saying if we give our money to a bank, why don't we give our data to data centers ? Which one is important for commercial companies, money or data ? Money is centralized, why not data ? Also, Centralized information makes societies more democratic, more clearer. Danisment [EMAIL PROTECTED] wrote: Jared, The other problem with outsourcing, which we've run head on into, is that an ASP wants you to run the application plain vanilla. Customization of an application to fit your business/needs is one area they really do not like to handle. Makes upgrading a pain in the *^, which means some of your clients are running PeopleSoft 7 while the remainder are on Peoplesoft 8. Also your patch levels will vary, due to the customization. Hence, if you need to customize you can't outsource. Dick Goulet Reply Separator Author: Jared Still [EMAIL PROTECTED] Date: 4/30/2002 7:08 AM RANT This has all been tried before, and the predictions are the same: financial nirvana, big savings in technology costs, no pesky holier-than-thou DBA's baffling poor damagers with stuff they can't possibly understand. /RANT Very few executive, managers or DBA's are going to want to place their corporate data on Oracle's site, or even provide access to it from outside for non-employees. There's also the whipping boy factor. Who's butt you going to kick when the database is screwed up? ;) Heard a good quote on a documentary the other night: A corporation has no soul to save nor an ass to kick. Someone local must be accountable for the data. The whole outsourcing thing is kind of baffling to me at times. Why not carry it out its fullest measure? Outsource mfg, sales, IT, design and executives. No need for any employees. Guess I turned of the rant too soon. Jared On Tuesday 30 April 2002 06:44, Farnsworth, Dave wrote: http://www.infoworld.com/articles/se/xml/02/04/29/020429seoracle.xml Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Prod problem, please help!!!
Hi, Please take system states dumps every 5 seconds withing 20-30 seconds. Let's read what's happening or not happening ? Also, You can upload your HANGANALYZE trace files to iOraHangAnalyzer. It's free. regards... Tracy Rahmlow wrote: I have opened a TAR with Oracle and am waiting a resolution. In the meantime, I am wondering if anybody else has any ideas while I wait. Specifics: IBM AIX 4.3 Rdms 8.1.7.3 Database ~75g OLTP database with approximately 500 dedicated connections and 500 shared connections with Oracle's MTS. Problem: The database hangs, and no user is able to connect to the instance, except locally through srvmgrl. Even within svrmgrl, we are unable to select anything from the database without the query hanging. However, we can abort the instance (shutdown abort) and start it up again just fine. This has happened on 4-22, 4-29 4-30 in the early afternoon. Usually, this is also our peak busy rate for the week. We are executing MTS for 4 applications, all other applications connect through dedicated server. The alert log contains a message unable to start a shared server process. This week it was #41 and last week it was #25. Normally, we do not exceed 5 shared servers. Another thing I noticed is that there is no time allocated to any of the newly created shared servers. It is as if, it can not process any work through existing shared servers and decides to allocate another one, until finally it freezes. I am not sure if this is a MTS problem because I would suspect that I should be able to establish a dedicated server connection. And I can not. I think that this is just a symptom of the underlying problem. It would appear to me that we are running out of a resource, however our sysadms do not see any resource problems. Does anybody have any ideas how to debug this? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com
Re: What block size are you using for your new 9i data
r more details? Does the OS return > one OS block if exactly > one is requested, but if 2 are requested it thinks > "aha! sequential scan" > and goes and gets 4 or 8 or something? > > The follow on is, does this mean you should use a > (minimal) 2k block size > on UFS, 512 bytes blocks, or is this read-ahead > overhead a smaller > performance hit than that of using a database block > size which is too small > for the application? > > Thanks > - Bill. > > > At 08:48 26/04/02 -0800, you wrote: > >All, > > > >You always want to ensure that your DB_BLOCK_SIZE = > >File System Block Size. This is to avoid wasted I/O > >and also the case where the "read ahead algorithm" > is > >triggered accidentally, when 1 Database Block > results > >in multiple file system blocks being read from > disk. > > > >If your application performs range scans, there is > a > >high possibility that multiple "single database > block" > >read requests to a set of contiguous blocks, may > >result in the "read ahead algorithm" performing > 128K > >or 256K pre-fetches, even though your application > may > >have not required all 128K or 256K. > > > >This problem is rampant on ufs file systems where > the > >default block size is 512 bytes, and with a 8K > >DB_BLOCK_SIZE, it takes 16 file system blocks to > store > >1 DB block on disk. However, even if you have > advanced > >file systems and have a 1-is-to-2 ratio of DB block > >is-to FS blocks, you are still in danger of > >overloading your I/O sub-system, "under the right > >conditions". > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Bill Buchan > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California -- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com
Re: Currval and buffer gets
Hello Gaja, Here is the line to talk about: FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=5656332 As we see, cu+cr=0 and returned raw is r=1. Normally, it's not possible to return a raw without touching a block. But there are some cases such as X$ tables that these statistics are zero. I had tested V$SESSION, V$PROCESS and I had seen logical IO is 0 since they are based on X$ tables. I did not document it, but I think, Oracle doesn't account logical IO for X$ tables. Also, How can Oracle account it in blocks ? X$ tables are not organized in DB_BLOCK_SIZE. I may be wrong, I've not done detailed tests on this issue. I'm looking forward to hearing a confirmation on that. regards... Gaja Krishna Vaidyanatha wrote: Hi Dan and list, Here is the output from a test after setting 10046 at level 12. Please tell me whether this is really 0 or not accounted for. If it is not accounted for, then I stand corrected. Thanks, Gaja Trace file output starts here *** 2002-04-22 16:04:14.090 *** SESSION ID:(11.752) 2002-04-22 16:04:14.060 = PARSING IN CURSOR #1 len=70 dep=0 uid=0 oct=42 lid=0 tim=5655178 hv=347037164 ad='51d70a0' alter session set events '10046 trace name context forever, level 12' END OF STMT EXEC #1:c=2,e=4,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=5655179 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=838976 p2=1 p3=0 *** 2002-04-22 16:04:25.617 WAIT #1: nam='SQL*Net message from client' ela= 1152 p1=838976 p2=1 p3=0 = PARSING IN CURSOR #1 len=21 dep=0 uid=0 oct=3 lid=0 tim=5656331 hv=2119980703 ad='51d5564' select * from x$dual END OF STMT PARSE #1:c=0,e=0,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=5656331 BINDS #1: EXEC #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=5656332 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=838976 p2=1 p3=0 FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=1,dep=0,og=4,tim=5656332 WAIT #1: nam='SQL*Net message from client' ela= 2 p1=838976 p2=1 p3=0 FETCH #1:c=0,e=0,p=0,cr=0,cu=0,mis=0,r=0,dep=0,og=4,tim=5656334 WAIT #1: nam='SQL*Net message to client' ela= 0 p1=838976 p2=1 p3=0 WAIT #1: nam='SQL*Net message from client' ela= 815 p1=838976 p2=1 p3=0 STAT #1 id=1 cnt=1 pid=0 pos=0 obj=0 op='FIXED TABLE FULL X$DUAL ' = Trace file output ends here --- Danisment Gazi Unal [EMAIL PROTECTED]> wrote: > Hello Gaja, > > am I missing something ? > > is it 0 logical IO indeed ? or it's not accounted > for X$ tables ? > > regards... > > > > Gaja Krishna Vaidyanatha wrote: > > > Hi Yechiel, > > > > Any full-table-scan in Oracle 8i (or below) > consumes 4 > > LIOs to the segment header. This number has > reduced to > > 2 in 9i. Given that the 1 row that you are going > after > > is in 1 data block, there is 1 LIO for the data > block > > itself, given you a total of 5 LIOs. You can > verify > > this by setting 10046 for the session and looking > at > > the trace output. > > > > The workaround is to reference x$dual in your > > application. Alternatively, you can create a view > on > > x$dual, create a synonym for it and then go from > > there. You will incur some I/O for the first > access of > > the query (with the synonym), but subsequent > accesses > > will incur 0 LIOs against x$dual. > > > > Cheers, > > > > Gaja > > --- Yechiel Adar [EMAIL PROTECTED]> wrote: > > > I did two statspack snapshots, one hour and > forty > > > minutes apart. > > > Then I generated a report and loaded it into > > > oraperf.com. > > > In the report I saw that the two SQL statements > that > > > where executed the most > > > times where: > > > > > > Select .currval from dual; > > > > > > Select .nextval from dual;. > > > > > > Each one was executed about 90,000 times with 5 > > > buffer gets per execution. > > > The net result was about 950,000 buffer get for > > > nextval and currval. > > > > > > My question is: > > > Why should there be about 5 buffer gets per > > > execution? > > > > > > Yechiel Adar > > > Mehish > > > -- > > > Please see the official ORACLE-L FAQ: > > > http://www.orafaq.com > > > -- > > > Author: Yechiel Adar > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 > FAX: > > > (858) 538-5051 > > > San Diego, California -- Public Internet > > > access / Mailing Lists > > > > > > > > > To REMOVE yourself from this mailing list, send > an > > &
Re: Oracle invents time machine - optimizer now faster than light.
Hello Jonathan, isn't it soft parse (mis=0) ? regards... Jonathan Lewis wrote: Look carefully at the following (genuine) extract from a 9.0.1.3 trace file, and examine the TIM= entries: PARSING IN CURSOR #2 len=210 dep=1 uid=0 oct=3 lid=0 tim=1019495629365212 hv=787810128 ad='6e0a278' select /*+ rule */ bucket_cnt, row_cnt, cache_cnt, null_cnt, timestamp#, sample_size, minimum, maximum, distcnt, lowval, hival, density, col#, spare1, spare2, avgcln from hist_head$ where obj#=:1 and intcol#=:2 END OF STMT PARSE #2:c=0,e=492,p=0,cr=0,cu=0,mis=0,r=0,dep=1,og=3,tim=1019495629365100 Note how Oracle has managed to finish parsing the statement 112 microseconds before it started. Now that's how to pass a benchmark ! Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com
Re: Oracle invents time machine - optimizer now faster than light.
Hello Jonathan, I always think twice while talking to a guru. Here is my comment for your test case: 'tim' columns in these examples are not accurate. PARSING IN CURSOR #1 len=40 dep=0 uid=54 oct=1 lid=54 tim=1019495629370923 hv=1851325355 ad='6cb3450' alter table TESTLONG modify ( text clob) END OF STMT PARSE #1:c=1,e=11122,p=1,cr=1,cu=0,mis=1,r=0,dep=0,og=4,tim=101949562937 0823 Time difference : 1019495629370823 - 1019495629370923 = -100 microseconds But your elapsed time for PARSE call is 11122 microseconds. I think your second 'tim' should not be less than (1019495629370923 + 11122). Because, 'tim' column is obtained from V$TIMER when a line is written to dump. Most probably, this is a bug. I think "PARSING IN CURSOR"/"PARSE" statement doesn't always indicate when the statement is handled by Oracle. Because, there may be some recursive statements handled before the parent statements are actually handled. Statistics of these statements are not included in the parent statements. Also, as you stated in your last case, "alter session set events '10046.." or "alter session set sql_trace=true" don't include PARSE calls. If it's the first statement in raw trace file, no problem, but If not, or if a statement doesn't iclude a PARSE call, tkprof reports wrong results. Because, we know SOME statistics in raw trace files include SOME statistics of SOME recursive statements' statistics. tkprof substructs them by starting from PARSE call to current line. If tkprof can not find a PARSE call for a statement, it assumes substruction from the beginning of file to current line. This makes wrong reports. itrprof(Sorry Jared) reports an error code for this problem. I recommend the followings the tkprof users: - Enabling SQL and Event 10046 trace files from the other sessions may cause missing statistics in the trace files. - If this is not possible, enable the traces when the traced session is IDLE. regards... regards... Jonathan Lewis wrote: Don't lose any sleep on it, but here's another: PARSING IN CURSOR #1 len=40 dep=0 uid=54 oct=1 lid=54 tim=1019495629370923 hv=1851325355 ad='6cb3450' alter table TESTLONG modify ( text clob) END OF STMT PARSE #1:c=1,e=11122,p=1,cr=1,cu=0,mis=1,r=0,dep=0,og=4,tim=101949562937 0823 NB - not recursive, not SYS, and a hard parse to boot. But this one is much more interesting: PARSING IN CURSOR #1 len=68 dep=0 uid=54 oct=42 lid=54 tim=1019495629353714 hv=287842151 ad='6cba5e8' alter session set events '10046 trace name context forever, level 8' END OF STMT EXEC #1:c=0,e=13,p=0,cr=0,cu=0,mis=1,r=0,dep=0,og=4,tim=1019495629321662 Note the complete absence of PARSE #1, and the 'massive' 32,000 microsecond back-step. In general, however, the PARSE seems to be a fairly persistent 110 micro seconds out of step. Jonathan Lewis http://www.jlcomp.demon.co.uk Author of: Practical Oracle 8i: Building Efficient Databases Next Seminar - Australia - July/August http://www.jlcomp.demon.co.uk/seminar.html Host to 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]> Date: 23 April 2002 14:18 light. |Do you have any more examples? and if so, is the |second time always suffixed with '00'. I'm wondering |if the concluding time is still centiseconds (or |whatever precision is appropriate to cause the |'problem') | |Cheers |Connor | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com
Re: Currval and buffer gets
Hello Gaja, am I missing something ? is it 0 logical IO indeed ? or it's not accounted for X$ tables ? regards... Gaja Krishna Vaidyanatha wrote: Hi Yechiel, Any full-table-scan in Oracle 8i (or below) consumes 4 LIOs to the segment header. This number has reduced to 2 in 9i. Given that the 1 row that you are going after is in 1 data block, there is 1 LIO for the data block itself, given you a total of 5 LIOs. You can verify this by setting 10046 for the session and looking at the trace output. The workaround is to reference x$dual in your application. Alternatively, you can create a view on x$dual, create a synonym for it and then go from there. You will incur some I/O for the first access of the query (with the synonym), but subsequent accesses will incur 0 LIOs against x$dual. Cheers, Gaja --- Yechiel Adar [EMAIL PROTECTED] wrote: I did two statspack snapshots, one hour and forty minutes apart. Then I generated a report and loaded it into oraperf.com. In the report I saw that the two SQL statements that where executed the most times where: Select .currval from dual; Select .nextval from dual;. Each one was executed about 90,000 times with 5 buffer gets per execution. The net result was about 950,000 buffer get for nextval and currval. My question is: Why should there be about 5 buffer gets per execution? Yechiel Adar Mehish -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Gaja Krishna Vaidyanatha Director, Storage Management Products, Quest Software, Inc. Co-author - Oracle Performance Tuning 101 http://www.osborne.com/database_erp/0072131454/0072131454.shtml __ Do You Yahoo!? Yahoo! Games - play chess, backgammon, pool and more http://games.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gaja Krishna Vaidyanatha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.ubTools.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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-12500 Error
Hi, This is a consequence. We should see the cause. can you email other related errors in your sqlnet.log file ? regards... GL2Z/ INF DBA BENLATRECHE wrote: Hi All, I am trying to install an Oracle V8.1.7 on a Netware 5.O server. When loading SVRMGR, I get : ORA-12500: TNS: Listener failed to start a dedicared server process I checked all my configuration files (LISTENER, TNSNAMES), it seems to be OK. Any help will be welcome. Best Regards. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: GL2Z/ INF DBA BENLATRECHE INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Database shutdown
Hi, Set event 10400 to turn on system state dumps for shutdown debugging to see what is happening. I guess, SMON is cleaning up your temporary segments. regards... [EMAIL PROTECTED] wrote: Try shutdown abort, takes about 2 seconds...works for me (ROFLOL) If you are doing a shutdown or shutdown normal (same things) then Oracle waits for all sessions to disconnect, flushes everything, and checkpoints the database, could be a long wait. If you are doing a shutdown immediate then all sessions will be terminated, uncommitted transactions rolled back, the buffer cache needs to be flushed, and the database will be checkpointed. Can take awhile if your checkpoints are spaced far apart. If you do a shutdown abort be aware that cache recovery must be done on instance startup so startup may take a few minutes, again depending how long your checkpoints are spaced. (Trying to remember all of the above from memory, and I'm getting old. So if any of it is incorrect, remember, the consulting fee cost $0.00) Brian P. MacLean Oracle DBA, OCP8i Nguyen, David M To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] david.m.nguye cc: [EMAIL PROTECTED]Subject: Database shutdown Sent by: [EMAIL PROTECTED] om 04/16/02 09:03 AM Please respond to ORACLE-L Does any know why it takes too long (about 40 minutes) to shutdown oracle database? I am running oracle8.0.5 on solari5.6. It usually just takes me few minutes to shutdown. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: looking for 9i on solaris for test
Hello all, I'm looking for Oracle9i on Solaris for some tests. do you know a site offers these types of services. As I know Compaq offers, bu I need Solaris ? thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: CSSCAN Failed
Hi, WE8ISO8859P9 is Turkish character set. I don't see a problem. Also, You've a chance to move db to new character sets evenf if it's not in subset/superset relations. Character conversions occur as below: desktop/terminal --- Oracle client --- Oracle server Oracle uses CONVERT() function internally to change character sets between client and server if these character sets are different. If client and server character sets are same, CONVERT() function is not used. In this case, your terminals or your desktop character sets are stored in db. Now, If you export your db when your db character set and your export session's character set are same, CONVERT() function will not be used. But, there will be still old character set in export file header. There should be a note in metalink which explains this header. If you modify export file header to new character set, and import session's character set and new db character set are the new db character set, no CONVERT() function will be used in import and your data will be imported to new db with new character set without corruption. Note that no data conversion is done. Data is still same. This is the way how to move db to different character sets. regards... -- Danisment Gazi Unal http://www.unal-bilisim.com You can modify export file dump. By this method, you can Reddy, Madhusudana wrote: Hello All, I am getting the following error , when I was trying to run the CSSCAN utility /usr/lib/dld.sl: Can't open shared library: /opt/java/jre.1.1.8/lib/PA_RISC/native_threads/libjava.sl /usr/lib/dld.sl: No such file or directory Abort And another Question I do have I have my database running on WE8ISO8859P9 character set , I am trying to upgrade a 3rd party application running on the DB and the application document suggests that it expects WE8ISO8859P1 character set on the database. As we know WE8ISO8859P9 is superset of WE8ISO8859P1 , by leaving the database in the same WE8ISO8859P9 , will it be a problem in future ??? Your suggestions are very much needed . Thanks, Madhu V Reddy Database Support Services (952) 324-0392 ( work ) -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reddy, Madhusudana INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-00600 Error
aansprakelijkheid is opgenomen. De algemene voorwaarden worden u op verzoek kosteloos toegezonden. = The information contained in this communication is confidential and is intended solely for the use of the individual or entity to whom it is addressed. You should not copy, disclose or distribute this communication without the authority of Ernst Young. Ernst Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. Ernst Young does not guarantee that the integrity of this communication has been maintained nor that the communication is free of viruses, interceptions or interference. If you are not the intended recipient of this communication please return the communication to the sender and delete and destroy all copies. In carrying out its engagements, Ernst Young applies general terms and conditions, which contain a clause that limits its liability. A copy of these terms and conditions is available on request free of charge. === -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jack van Zanen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Decyphering LMT space bitmap
Jeremiah, Let me explain before guru X$GOPAL woke up. I guess time is midnight in India. Here are the some lines before your dump: Start dump data blocks tsn: 1 file#: 2 minblk 3 maxblk 3 frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap File Space Bitmap Block: BitMap Control: RelFno: 2, BeginBlock: 5, Flag: 0, First: 30, Free: 128994 FF3F ... all zeros Let's convert your HEX bitmap vectors to binary. It's 0xFF3F in your case. In other words, it consists of 4 bytes. They are 0xFF, 0xFF, 0xFF, 0x3F. The binary equivalents: , , , 0011 . To read this bitmap, we should take the least significant bit the first for each byte pair: The new bitmap will become: , , , 1100 Now, Each '1' represents used extent, each '0' represents free extent. If We look at the position of first '0', you will see that it's 31th position. Note that this is one more than the First value in the dump given above. Because Oracle starts looking for free space from the First value in the dump. You had found 30 extents in dba_extents. Now, we saw it in the block dump too. There is no problem. btw, I had a free product named iOraDumpReader at http://www.unal-bilisim.com/products/ioradumpreader/ioradumpreader.html . It interepretes almost all block dumps. But, since there is no enough hit to this page, I'm not currently working on it. regards... Jeremiah Wilton wrote: Out of curiosity I decided I wanted to look at what composed the extent map in locally-managed tablespaces. I dumped the first 5 blocks of the tablespace's first datafile with 'alter system dump datafile ...' The results surprised me, as they appeared to consist of almost no data. The LMT in question contains a variety of segments and extents. How is the LMT bitmap organized? Start dump data blocks tsn: 1 file#: 2 minblk 1 maxblk 1 Block 1 (file header) not dumped: use dump file header command Start dump data blocks tsn: 1 file#: 2 minblk 2 maxblk 2 frmt: 0x02 chkval: 0x type: 0x1d=KTFB Bitmapped File Space Header File Space Header Block: Header Control: RelFno: 2, Unit: 8192, Size: 524352, Flag: 1 Initial Area: 3, Tail: 524292, First: 30, Free: 34 Start dump data blocks tsn: 1 file#: 2 minblk 3 maxblk 3 frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap File Space Bitmap Block: BitMap Control: RelFno: 2, BeginBlock: 5, Flag: 0, First: 30, Free: 128994 FF3F ... all zeros Start dump data blocks tsn: 1 file#: 2 minblk 4 maxblk 4 frmt: 0x02 chkval: 0x type: 0x1e=KTFB Bitmapped File Space Bitmap File Space Bitmap Block: BitMap Control: RelFno: 2, BeginBlock: 1056964613, Flag: 0, First: 0, Free: 129024 ... all zeros FWIW: SQL> select count (*) from dba_extents where file_id = 2; COUNT(*) -- 30 SQL> select extent_management from dba_data_files df, dba_tablespaces ts where df.tablespace_name = ts.tablespace_name and file_id = 2; EXTENT_MAN -- LOCAL -- Jeremiah Wilton http://www.speakeasy.net/~jwilton -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: Still Problem with ORA-12514
are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). === Confidentiality Statement === The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. = End Confidentiality Statement = The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suzy Vordos INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
[Fwd: ORA-00600 error]
Bünyamin, The trace you sent is not enough. But before determining if your memory is enough or not, we should understand if the requested memory size is normal or if UGA shrinks normally . For quick answer: Check session uga memory and session uga memory max statistics. can you attache the trace file ? regards... -- Danisment Gazi Unal http://www.unal-bilisim.com ---BeginMessage--- Dear Gurus , I am lack of UGA memory. How can I see how much uga memory is setup for users and will it be enough increasing sort_area_size ? The error is below. I recieve error in alert log. Wed Apr 03 18:19:20 2002Errors in file C:\oracle\admin\UYBS\udump\ORA02864.TRC:ORA-00600: internal error code, arguments: [729], [324], [space leak], [], [], [], [], [] The ORA02864.TRC file is 900 KB. I have selected some lines in trace file. The things I wonder in the ORA02864.TRC file is : *** 2002-04-03 18:19:17.187 *** SESSION ID:(17.792) 2002-04-03 18:19:16.875 ERROR: UGA memory leak detected 324 ** O/S info: user: Administrator, term: DALI, ospid: 992:1224, machine: ADALET\DALI program: last wait for 'SQL*Net message from client' blocking sess=0x0 seq=1484 wait_time=-2 driver id=28444553, #bytes=1, =0 Bunyamin K. Karadeniz Oracle DBA / DeveloperCivilian IT DepartmentHavelsan A.S. Eskisehir yolu 7.km Ankara TurkeyPhone: +90 312 2873565 / 1217Mobile : +90 535 3357729 The degree of normality in a database is inversely proportional to that of its DBA. dbainblk.gif Description: GIF image The previous attachment was filtered out by the ListGuru mailing software at fatcity.com because binary attachments are not appropriate for mailing lists. If you want a copy of the attachment which was removed, contact the sender directly and ask for it to be sent to you by private E-mail. This warning is inserted into all messages containing binary attachments which have been removed by ListGuru. If you have questions about this message, contact [EMAIL PROTECTED] for clarification. tech.gif Description: GIF image ---End Message---
Re: OracleService is down on regular basis
Hi, can you paste ora-600 trace files to list ? Jamadagni, Rajendra wrote: Check the code in the trigger it seems that one of the variables is getting assigned a value that is longer than it can hold. The ora-2 error is user generated. Check on metalink you could be running into a bug, one of the posters got it resolved by pinning all the packages in SGA. Anyways, the mantra is 'If you see ora-600 error, first contact OWS and then the list.' HTH Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! Name: ESPN_Disclaimer.txt ESPN_Disclaimer.txtType: Plain Text (text/plain) Encoding: 7bit -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: DRPP Paper
Hello Rajesh and the list, Since some others asked some questions, I'm CCing the list. Sorry for that. I've renamed DRPP to MRPP(Microstate Response-time Performance Porfiling). I'll add some further tests to MRPP to make it more practical. Most probably it'll be availabe in 2-3 months. Sorry list for that. regards... RAJESH DAYAL wrote: Hi !! I have been waiting patiently for the DRPP Paper, which you said would be available on your site after Feb 12. But still I go to your site and return disappointed . Please if you can send me the Paper, It would be great Many Thanks in Advance and Best Regards, Rajesh Rajesh Dayal Senior Oracle DBA OHI Telecommunications. -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf OfDanisment Gazi Unal Sent: Friday, March 29, 2002 12:09 AM To: Multiple recipients of list ORACLE-L Subject: Re: urgent Hello, Check alert.log. If there is a related error or if a trace is generated, forward them to list. Big Planet wrote: Hi Guys ,I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theres are dynamic query ) multiple times the proc executes well ...but after someexeccution ( using same connection ) the connection drops saying end-of-file on communication channel .This is happening after I executes the proc may be 10-12 times . One more thing ..one of parameter to the proc which is getting used to build the dynamic sql is changed in between these execution. This happens only if I change that parameter . If I dont change that parameter its runs ok.Can you help pls ..Thanks ,-ak -- Danisment Gazi Unal http://www.unal-bilisim.com -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: urgent
Hello, Check alert.log. If there is a related error or if a trace is generated, forward them to list. Big Planet wrote: Hi Guys ,I am getting this weired result after executing stored proc . When I run a particuler stored proc which returns two refcursors ( inside proc theres are dynamic query ) multiple times the proc executes well ...but after someexeccution ( using same connection ) the connection drops saying end-of-file on communication channel .This is happening after I executes the proc may be 10-12 times . One more thing ..one of parameter to the proc which is getting used to build the dynamic sql is changed in between these execution. This happens only if I change that parameter . If I dont change that parameter its runs ok.Can you help pls ..Thanks ,-ak -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: strange tkprof output for SQLs - II
Hello all, Thanks to Bjorn Engsig of MiracleAS.dk Also, Here is the answer from Oracle support. I wanted to share with you: # Begin tkprof substracts the child statistics from parent ones. . the trace file is missing the line for PARSE call of the blsql block - as it's missing it's impossible to to determine the start and therefore the times are reported to be zero - could be the result of how the tracing was enabled. . As it seems enabling trace from different session can produce incomplete trace file I suggest you enable it in current session to get most accurate results. # End I had seen this wrong behavior for current statements before. But as seen in the thread, while closing the parent PL/SQL block, we are missing the PARSE line of parent statement in the trace since it's parsed before enabling trace. So, tkprof is unable to determine the starting time and sets cpu,elapsed times to ZERO. as a result: Be careful if you enable sql trace from other session. You can see wrong tkprof outputs not only for the current running statement, but also for statements which are parsed before enabling trace. regards... Danisment Gazi Unal wrote: Hello Mogens, I saw this problem whether or not shared pool was flushed for PL/SQLs. Here are my observations for SQLs!!! and PL/SQLs: - Enabling sql trace from current session: When a cursor is closed after their child recursive statements, their recursive statistics parsed after the statement are included in parent's statistics. Recursive statements parsed before the statement are not included. - Enabling sql trace from other session after a while(after the parenet statement is parsed): Recursive statistics are not included in parent statement. But tkprof doesn't use exac values in raw trace file. If they are not included, why doesn't tkprof return exac values in raw trace files ? I'll debug tkprof if it calls Oracle's kernel function to see if tkprof is just a simple formatter or calculates something that I'm missing. I did not understand this is expected behavior or not. I would like to know statistics in raw trace files are inclusive or exclusive. I'm facing diffierent behaviors for this problem. I've opened an iTAR. thanks in advance... Mogens Nrgaard wrote: Danisment - isn't it always "alter system flush shard_pool"? I thought so... Danisment Gazi Unal (Unal Bilisim) wrote: >Hello, > >I did 2 tests for PL/SQL and SQL statements. This is the test for >SQL. > >Here are the steps: > >SQL > alter session flush shared_pool; >SQL > alter session set sql_trace=true; >SQL > insert into test select * from test; >SQL > alter session set sql_trace=false; > > >FROM DICTIONARY: > >SVRMGR> select >SQL_TEXT,DISK_READS,BUFFER_GETS,ROWS_PROCESSED,COMMAND_TYPE from v$sql >where sql_text like 'insert into test select * from test%'; > >SQL_TEXT DISK_READS BUFFER_GET ROWS_PROCE >COMMAND_TY >- -- -- -- >-- >insert into test select * from test 345 1014 >8192 2 >1 row selected. > > >FROM RAW TRACE FILE: > >PARSING IN CURSOR #1 len=36 dep=0 uid=5 oct=2 lid=5 tim=2795932206 >hv=895761708 ad='5083d50c' >insert into test select * from test >END OF STMT >PARSE #1:c=7,e=28,p=17,cr=42,cu=2,mis=1,r=0,dep=0,og=4,tim=2795932206 >. >other recursive statements. >. >. near end of file >EXEC >#1:c=28,e=258,p=328,cr=597,cu=373,mis=0,r=8192,dep=0,og=4,tim=2795932464 > > > >BUFFER GETS IN RAW TRACE FILE: >cr: 597 + 42 = 639 >cu: 373 + 2 = 375 > >Buffer gets = 639 + 375 = 1014, which is same as v$sql.BUFFER_GETS > > >DISK_READS IN RAW TRACE FILE: > >p: 17 + 328 = 345, which is same as v$sql.DISK_READS. > >According to these test, results in dictionary and raw trace files are >same. But tkprof formats as below: > > >insert into test select * from test > > >call count cpu elapsed disk query >current rows >--- -- -- -- -- -- >-- >Parse 1 0.00 0.02 17 42 >1 0 >Execute 1 0.12 1.86 91 126 >356 8192 >Fetch 0 0.00 0.00 0 0 >0 0 >--- -- -- -- -- -- >-- >total 2 0.12 1.88 108 168 >357 8192 > > >DISK_READS = 108 >BUFFER GETS = 168 + 357 = 525 > >Question: > >Which one is correct ? Dictionary/raw trace file or tkprof results ? > >My comment: > >I guess, tkprof substructs child recursive statements from parent user >statement ? Why ? This is not a PL/SQL statement ? So, statistics are >already not included in parent statement ? I guess statistics in raw >trace files are inclusive statistics which include statistics of their >child statements according to call orders of kernel calls. But is this >expected behavior. > >
Re: strange tkprof output for SQLs - II
Hello Mogens, I saw this problem whether or not shared pool was flushed for PL/SQLs. Here are my observations for SQLs!!! and PL/SQLs: - Enabling sql trace from current session: When a cursor is closed after their child recursive statements, their recursive statistics parsed after the statement are included in parent's statistics. Recursive statements parsed before the statement are not included. - Enabling sql trace from other session after a while(after the parenet statement is parsed): Recursive statistics are not included in parent statement. But tkprof doesn't use exac values in raw trace file. If they are not included, why doesn't tkprof return exac values in raw trace files ? I'll debug tkprof if it calls Oracle's kernel function to see if tkprof is just a simple formatter or calculates something that I'm missing. I did not understand this is expected behavior or not. I would like to know statistics in raw trace files are inclusive or exclusive. I'm facing diffierent behaviors for this problem. I've opened an iTAR. thanks in advance... Mogens Nrgaard wrote: Danisment - isn't it always "alter system flush shard_pool"? I thought so... Danisment Gazi Unal (Unal Bilisim) wrote: >Hello, > >I did 2 tests for PL/SQL and SQL statements. This is the test for >SQL. > >Here are the steps: > >SQL > alter session flush shared_pool; >SQL > alter session set sql_trace=true; >SQL > insert into test select * from test; >SQL > alter session set sql_trace=false; > > >FROM DICTIONARY: > >SVRMGR> select >SQL_TEXT,DISK_READS,BUFFER_GETS,ROWS_PROCESSED,COMMAND_TYPE from v$sql >where sql_text like 'insert into test select * from test%'; > >SQL_TEXT DISK_READS BUFFER_GET ROWS_PROCE >COMMAND_TY >- -- -- -- >-- >insert into test select * from test 345 1014 >8192 2 >1 row selected. > > >FROM RAW TRACE FILE: > >PARSING IN CURSOR #1 len=36 dep=0 uid=5 oct=2 lid=5 tim=2795932206 >hv=895761708 ad='5083d50c' >insert into test select * from test >END OF STMT >PARSE #1:c=7,e=28,p=17,cr=42,cu=2,mis=1,r=0,dep=0,og=4,tim=2795932206 >. >other recursive statements. >. >. near end of file >EXEC >#1:c=28,e=258,p=328,cr=597,cu=373,mis=0,r=8192,dep=0,og=4,tim=2795932464 > > > >BUFFER GETS IN RAW TRACE FILE: >cr: 597 + 42 = 639 >cu: 373 + 2 = 375 > >Buffer gets = 639 + 375 = 1014, which is same as v$sql.BUFFER_GETS > > >DISK_READS IN RAW TRACE FILE: > >p: 17 + 328 = 345, which is same as v$sql.DISK_READS. > >According to these test, results in dictionary and raw trace files are >same. But tkprof formats as below: > > >insert into test select * from test > > >call count cpu elapsed disk query >current rows >--- -- -- -- -- -- >-- >Parse 1 0.00 0.02 17 42 >1 0 >Execute 1 0.12 1.86 91 126 >356 8192 >Fetch 0 0.00 0.00 0 0 >0 0 >--- -- -- -- -- -- >-- >total 2 0.12 1.88 108 168 >357 8192 > > >DISK_READS = 108 >BUFFER GETS = 168 + 357 = 525 > >Question: > >Which one is correct ? Dictionary/raw trace file or tkprof results ? > >My comment: > >I guess, tkprof substructs child recursive statements from parent user >statement ? Why ? This is not a PL/SQL statement ? So, statistics are >already not included in parent statement ? I guess statistics in raw >trace files are inclusive statistics which include statistics of their >child statements according to call orders of kernel calls. But is this >expected behavior. > >Thanks in advance... > >-- >Danisment Gazi Unal >http://www.unal-bilisim.com > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?ISO-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: Oracle hangs...Oracle 8.1.7.3 and Solaris 2.7
files. No messages in the alert log. Killing the Oracle processes is the only way to recover from the problem. This problem has been reported to Oracle Support, they are now escalating it up. I just wanted to PING the list to see if anyone else has encountered this. TIA!!! Chris -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Mohammed Shakir CompuSoft, Inc. 11 Heather Way East Brunswick, NJ 08816-2825 (732) 672-0464 (Cell) (732) 257-6001 (Home) __ Do You Yahoo!? Yahoo! Movies - coverage of the 74th Academy Awards® http://movies.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohammed Shakir INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sutton, Reed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
strange tkprof output for SQLs - II
Hello, I did 2 tests for PL/SQL and SQL statements. This is the test for SQL. Here are the steps: SQL alter session flush shared_pool; SQL alter session set sql_trace=true; SQL insert into test select * from test; SQL alter session set sql_trace=false; FROM DICTIONARY: SVRMGR select SQL_TEXT,DISK_READS,BUFFER_GETS,ROWS_PROCESSED,COMMAND_TYPE from v$sql where sql_text like 'insert into test select * from test%'; SQL_TEXT DISK_READS BUFFER_GET ROWS_PROCE COMMAND_TY - -- -- -- -- insert into test select * from test 345 1014 8192 2 1 row selected. FROM RAW TRACE FILE: PARSING IN CURSOR #1 len=36 dep=0 uid=5 oct=2 lid=5 tim=2795932206 hv=895761708 ad='5083d50c' insert into test select * from test END OF STMT PARSE #1:c=7,e=28,p=17,cr=42,cu=2,mis=1,r=0,dep=0,og=4,tim=2795932206 . other recursive statements. . . near end of file EXEC #1:c=28,e=258,p=328,cr=597,cu=373,mis=0,r=8192,dep=0,og=4,tim=2795932464 BUFFER GETS IN RAW TRACE FILE: cr: 597 + 42 = 639 cu: 373 + 2 = 375 Buffer gets = 639 + 375 = 1014, which is same as v$sql.BUFFER_GETS DISK_READS IN RAW TRACE FILE: p: 17 + 328 = 345, which is same as v$sql.DISK_READS. According to these test, results in dictionary and raw trace files are same. But tkprof formats as below: insert into test select * from test call count cpuelapsed disk query currentrows --- -- -- -- -- -- -- Parse1 0.00 0.02 17 42 1 0 Execute 1 0.12 1.86 91126 3568192 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total2 0.12 1.88108168 3578192 DISK_READS = 108 BUFFER GETS = 168 + 357 = 525 Question: Which one is correct ? Dictionary/raw trace file or tkprof results ? My comment: I guess, tkprof substructs child recursive statements from parent user statement ? Why ? This is not a PL/SQL statement ? So, statistics are already not included in parent statement ? I guess statistics in raw trace files are inclusive statistics which include statistics of their child statements according to call orders of kernel calls. But is this expected behavior. Thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
strange tkprof output for PL/SQLs
Hello, I did 2 tests for PL/SQL and SQL statements. This is the test for PL/SQL. I've enabled sql_trace from another session by DBMS_SYSTEM.SET_EV(). Here are my observations and questions: - The caller PL/SQL package are seen at the end of the raw file as below: PARSING IN CURSOR #1 len=19 dep=0 uid=5 oct=47 lid=5 tim=2882392980 hv=3659692972 ad='507cbd68' BEGIN pdoug; END; END OF STMT EXEC #1:c=0,e=0,p=3533,cr=5229,cu=132854,mis=1,r=1,dep=0,og=4,tim=2882392980 *** 2002-03-20 15:20:33.571 Here are the v$SQL results: select SQL_TEXT,DISK_READS,BUFFER_GETS,ROWS_PROCESSED from v$sql where upper(SQL_TEXT) like '%DOUG%'; SQL_TEXT DISK_READS BUFFER_GET ROWS_PROCE -- -- -- -- INSERT INTO DOUG VALUES ( :b1,:b2 ) 3533 138083 12 BEGIN pdoug; END; 3533 138083 1 Comparision of PL/SQL package with the raw trace file: Physical reads: --- Raw trace file: 3533 V$SQL : 3533 Logical IO: --- Raw trace file: 5229 + 132854 = 138083 V$SQL : 138083 As you see raw trace file and V$SQL are consistent for this parent PL/SQL statement. This is true for both enabling sql_trace from current session or other session. Here are the tkprof output for parent PL/SQL and its child SQL statement. Child recursive statement called from parent PL/SQL statement: INSERT INTO DOUG VALUES ( :b1,:b2 ) call count cpuelapsed disk query currentrows --- -- -- -- -- -- -- Parse0 0.00 0.00 0 0 0 0 Execute 83646 41.52 110.37218565 92483 83646 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total83646 41.52 110.37218565 92483 83646 Parent statement calls its recursive SQL statement given above: BEGIN pdoug; END; call count cpuelapsed disk query currentrows --- -- -- -- -- -- -- Parse0 0.00 0.00 0 0 0 0 Execute 1 0.00 0.00844 1279 40206 1 Fetch0 0.00 0.00 0 0 0 0 --- -- -- -- -- -- -- total1 0.00 0.00844 1279 40206 1 Here are the questions: 1- if recursive statements are included in the parent statement, why are the child statement's some statistics(cpu,elapsed,current) greater than the parent statement's statistics. Also, please have a look at parent statistics. is it possible for 1279+40206=41485 blocks to be processed in ZERO time and total elapsed time is ZERO too. 2- if recursive statements are not included in the parent statement, why tkprof output shows different values for disk and logical IO. Here are the comparisions between tkprof output and V$SQL for parent PL/SQL: Physical reads: --- Raw trace file: 3533 tkprof output : 844 Logical IO: --- Raw trace file: 5229 + 132854 = 138083 tkprof output : 1279 + 40206 = 41485 As a result, raw trace file is consistent with V$SQL for the parent statement. But tkprof reports different values. What is your comment ? Thanks in advance... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
testtttttttttststststst
-- Daniþment Gazi Ünal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Ora-00600 running 64 bit and 32 bit databases error stack ...
Hello, Your problem is raised in Oracle's internal kzckini() function. This function is a function of Oracle's SECURITY LAYER. But, your trace doesn't include PROCESS STATE, CURSOR DUMP etc. Without them it's not possible to see what is happing. But you can search metalink by ORA-600 kzckini kscnfy hope this helps ... -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle Tunning (DRPP)
Hello Mogens and others, Yes, You are right. But the current time based performance techniques still include errors. Prior to 80's(when I was a child), yes, ratio based measurements were the method. Then, wait-event based profiling appeared. In fact, this was an adaptation of Response Time Performance Profiling to Oracle. Unfortunately, there are significant errors in current response time based performance profilings. I've been working on a new performance profiling for 1 year. and now, I've almost completed my paper. The name is Deductive Response-time Performance Profiling (DRPP). It'll be available on my site after my seminar in Turkey. You can see the contents at http://www.unal-bilisim.com/resources/drpp_seminar.html . Also, Thanks to Jonathan Lewis, K Gopalakrishnan, and Tim Gorman for reviewing this paper for 1 year. regards... Mogens Nrgaard wrote: Commit; :-) In my opinion, you shouldn't spend your money on buying the Niemich book. It's full of errors (increase the buffer cache hit ratio, for instance) and the wrong approach (no time-based measurement method, just checklist after checklist). Buy 101 by Gaja. Then buy Tom Kyte's One-On-One book for general fantastic advise on anything. Then go to oraperf.com (Anjo), hotsos.com (Millsap), ixora.com.au (Steve Adams) and Jonathan Lewis' website (can never remember the adresse). Or go to MiracleAS.dk and find all these links, including the book links. Mogens Miracle A/S Denmark Farnsworth, Dave wrote: Binay, I totally agree with this recommendation from Jared for a tuning book. Read the first three chapters, stop and re-read them. And if you play your cards right you can even get a question answered by an author on this list. Cool, eh. Dave -Original Message- Sent: Tuesday, January 29, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Start with 'Oracle Performance Tuning 101', available at an amazon.com near you. Jared On Tuesday 29 January 2002 09:10, [EMAIL PROTECTED] wrote: Hi Everyone Can anyone suggest me some very good book on Oracle Tunning. Please only mention those books which you think is really worth purchasing Binay Kumar Oracle Cerified DBA London --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us by telephone or e-mail the sender by replying to this message, and then delete this e-mail and other copies of it from your computer system. Thank you. We reserve the right to monitor all e-mail communications through our network. -- Danisment Gazi Unal http://www.unal-bilisim.com
Re: Trace/Event Info (iOraDumpReader)
Hello, you can use itrprof (web based, and free) to analyze event10046 raw trace files. The product is at http://www.unal-bilisim.com/products/itrprof/itrprof.html. I'm currently developing a new web based product named iOraDumpReader. This tool will intreprete many Oracle trace files such as: - control file dump - file header dump - redo header dump - redo block dump - data block dump - rbs dump - etc. I'll lunch beta version next week. regards... Walter K wrote: Howdy! Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc... Thanks again! -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trace/Event Info (iOraDumpReader)
Hi, I head meant 'launch'. Mohan, Ross wrote: I'll lunch beta version next week. || eating your own dog food,eh? Admirable! -Original Message- Sent: Thursday, January 24, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Hello, you can use itrprof (web based, and free) to analyze event10046 raw trace files. The product is at http://www.unal-bilisim.com/products/itrprof/itrprof.html. I'm currently developing a new web based product named iOraDumpReader. This tool will intreprete many Oracle trace files such as: - control file dump - file header dump - redo header dump - redo block dump - data block dump - rbs dump - etc. I'll lunch beta version next week. regards... Walter K wrote: Howdy! Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc... Thanks again! -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Trace/Event Info (iOraDumpReader)
Hi Mohan and others, Thank you for your compliment. If a compiler has an option to compile or not to compile my products, I know I could never develop a product with my typo errors. Compilers would quit after the first attempt(joke...). I'm developing my products Mohan, Ross wrote: I know. It was a joke. Don't bite my head off! ;-) eating your own dog food is a compliment...meaning a company that uses its own products in doing its business. I will you and the business good luck! - Ross -Original Message- From: Danisment Gazi Unal (Unal Bilisim) [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 24, 2002 2:13 PM To: Multiple recipients of list ORACLE-L Subject: Re: Trace/Event Info (iOraDumpReader) Hi, I head meant 'launch'. Mohan, Ross wrote: I'll lunch beta version next week. || eating your own dog food,eh? Admirable! -Original Message- Sent: Thursday, January 24, 2002 1:39 PM To: Multiple recipients of list ORACLE-L Hello, you can use itrprof (web based, and free) to analyze event10046 raw trace files. The product is at http://www.unal-bilisim.com/products/itrprof/itrprof.html. I'm currently developing a new web based product named iOraDumpReader. This tool will intreprete many Oracle trace files such as: - control file dump - file header dump - redo header dump - redo block dump - data block dump - rbs dump - etc. I'll lunch beta version next week. regards... Walter K wrote: Howdy! Is a document available somewhere that explains the different trace levels and also the commonly used events for tracing? For instance, I know to use event 10046 with level 4 to get the bind variable values in a trace, but why this particular combination of event and trace level? What are the different levels and how are they used? How are process state and system state dumps performed? I'm also interested in some info that explains how to interpret the various trace files that are produced, other than just looking for SQL in them. Etc... Thanks again! -w __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Danisment Gazi Unal http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: Performance analysis (enqueue and buffer busy waits)
Hello, It's Unal Bilisim. Ethan mentioned about itrprof SQL Analyzer, which is superior to tkprof. web: http://www.unal-bilisim.com/products/itrprof/itrprof.html Thank Ethan. regards... Babette Turner-Underwood wrote: What is unil-bialism ?? - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, August 20, 2001 2:12 PM FYI, in a previous message I detailed some of the tuning efforts we have been working on in regards to getting a EDI sales order processing job to process 150,000 lines per hour. Well the major point of contention was freelists. We went from 250 lines per minute to over 1500 lines per minute simply by increasing freelists on some tables and indexes. We saw an unbelievable 20,000 commits per minute on a 12 CPU AIX box. Looked like we could actually achieve the client's goal until we turned on advanced pricing. It added 60% more overhead and increased user calls 3 fold which pegged all 12 CPU's at 100%. I have a detail trace file event 10046 level 8 to look at and see if I can improve any. Think I will give unil-bialism a try. Thanks, Ethan http://www.geocities.com/epost1 -Original Message- From: Jonathan Lewis [mailto:[EMAIL PROTECTED]] Sent: Monday, August 20, 2001 7:56 AM To: Multiple recipients of list ORACLE-L Subject: Re: Performance analysis (enqueue and buffer busy waits) Small rollback segments can be recycled without being written to disc. This can reduce the total write-load on the system and enhance your general use of the db_block_buffer. Jonathan Lewis Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases See http://www.jlcomp.demon.co.uk/book_rev.html For latest news of public appearances See http://www.jlcomp.demon.co.uk Screen saver or Life saver: http://www.ud.com Use spare CPU to assist in cancer research. [snipped] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Babette Turner-Underwood INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: URGENT PLEASE ! tns service deletion and recreation
Selam Bunyamin, If you don't want to remove them by installer, you can remove by manually. to remove( as I remember ), go to registry: - HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet001\Services - HKEY_LOCAL_MACHINE\SYSTEM\ControlSet002\Services to create: - it's simple. just run "lsnrctl start" or "lsnrctlxx start". it will be automacticly create your listener services. "Bunyamin K. Karadeniz" wrote: OS: NT 4.0 I need to delete the TNS Listener service . and create a new one .How can I do that ? TIABunyamin
itrprof is now chart enabled
Hello List, itrprof, superior to tkprof, is now chart enabled. You can see the online demo at http://www.unal-bilisim.com/products/itrprof/itrprof_demo.html itrprof: http://www.unal-bilisim.com/products/itrprof/itrprof.html regards.. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Second RBS in system tablespace
Hello, SYSTEM rbs is reserved actions against the SYSTEM tablespace. There are some mis-conceptions against this issue. Actions against the SYSTEM tablespace can use non-SYSTEM rbs, too. For example, Recursive transactions,in other words: Oracle kernel transactions by SYS users, do not always have to use SYSTEM rbs. SYSTEM rbs is the last statation if there is no available slot in rbs in which current user transaction is assigned. So, Oracle kernel does not have to compete with user transactions. hope this helps... Kevin Lange wrote: As a guess I would think it was because the system tablespace is so active with all the queries against the catalog. -Original Message- Sent: Wednesday, July 11, 2001 12:03 PM To: Multiple recipients of list ORACLE-L Hi Everybody I'm running 8.1.7 and i just read that i should have a second rollback segment in the system tablespace. Can someone tell me why this is and how big should i create it? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: hp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Number of returned row(s) is greater than 0 while number of logical read
Hello, When "Number of returned row(s) is greater than 0 while number of logical read is 0", itrprof prompts error. Some of itrprof users encounter this error. here is a line from raw file: FETCH #3:c=1,e=0,p=0,cr=0,cu=0,mis=0,r=10,dep=0,og=3,tim=443263450 As you see, number of logical reads are 0, but number of returned rows are 10. how is that possible ? I guess this is bug. have you encountered some problem. have you ever seen same problem in tkprof output ? thanks in advance...
Re: large SORT_AREA_SIZE usefullness
Hello Johnson, There are great papers at http://www.fortunecity.com/skyscraper/oracle/699/orahtml/ But, I still disagree with you. Becasue, tuning SORT will not make benefit in your case. yes, you are right, it's not easy to generate good SQL if SQL is generated by end-users. I don't know your design, perhaps, you can add hidden indexed-columns to generated SQLs to make end-users to use indexes. regards... Johnson Poovathummoottil wrote: Hi Danisment Gazi Unal, Itprof's suggestion is valid that I should be able to use an index to speed up this query. But my objective here is to help sorting. Many users write adhoc queries to into my warehouse and all are not going to be tuned queries. Many go for full tablescans on some big fact tables and sort like hell. We do have some good indexes for often used queries. But it is the adhoc one which people cook up that hurt us bad. So my intention is to tune sorts. In that light could you give me an explanation for the query running slow because the sort_area_size was increased? __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Johnson Poovathummoottil INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: large SORT_AREA_SIZE usefullness
Thank you Greg, We can discuss itrprof results in this great list. Greg Moore wrote: all the quries which used the larger sort_area_size actually ran slower Why don't you simply run a trace for the small sort_area_size, do the same with the larger sort_area_size, and then submit the trace files to that web site http://www.unal-bilisim.com/products/itrprof/itrprof.html to see what analysis and advice you get. I'm sure many of the people on this list are curious about this itrprof tool and would be interested in hearing if it helps you answer this question. You could probably put the output up to the list and get advice, especially since the guy who runs the site is on this list. I'd love to see a real-life example of this tool in action. - Greg -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
cursor 0 in sql_trace and event10046 raw trace files
Hello list, some of itrprof users encounter cursor 0. Since there is no parsed SQL statement which has a cursor number 0, itrprof prompts "itp-05 [x] : File corrupted." message. I examined raw trace files and could not see an SQL statement which has a cursor number 0. I think this is a bug. because, it's not possible for a kernel call to make a kernal call with non-existing cursor number. Since tkprof doesn't report this error, Oracle may have not fixed it. have you encountered same problem ? thanks in advance... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ynt: how to find CPU utilisation at Oracle level
Hello, itrprof calculates CPU utilization for SQLs, total non-SYS SQLs and total sys SQLs. I guess I'll be a marketing employee. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 20, 2001 8:49 PM Hi Is there any way to find which oracle process is taking much CPU except at OS level.Is there any view available from which we can see the cpu utilisation of particular user query. Thanks in advance -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: how to find CPU utilisation at Oracle level
Hi Lisa, itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE and Event 10046 trace files of Oracle; finds bottlenecks and offers information on how to tune them. It's at http://www.unal-bilisim.com/products/itrprof/itrprof.html ---sorry list--- "Koivu, Lisa" wrote: Please excuse my ignorance... but what's itrprof? Not tkprof? Lisa Koivu Goddess of Inept Ninja-ettes -Original Message----- From: Danisment Gazi Unal [SMTP:[EMAIL PROTECTED]] Sent: Wednesday, June 20, 2001 3:06 PM To: Multiple recipients of list ORACLE-L Subject: Ynt: how to find CPU utilisation at Oracle level Hello, itrprof calculates CPU utilization for SQLs, total non-SYS SQLs and total sys SQLs. I guess I'll be a marketing employee. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED]> Sent: Wednesday, June 20, 2001 8:49 PM > Hi > Is there any way to find which oracle process is taking much CPU except at > OS level.Is there any view available from which we can see the cpu > utilisation of particular user query. > Thanks in advance > -Seema > _ > Get your FREE download of MSN Explorer at http://explorer.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California -- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Redo latch contention
Mogens, You are right. nothing is a performance problem unless there is a time contention. In general, it's very hard to see time spent in each latch. itrprof SQL Analyzer with waitgroup=(name,P1,P2) can report time spent in each latch. So, you can see time spent in A latch, time spent in B latch, etc. I'm not a very old dba, but I don't think many latches can be tuned by init.ora parameters. with waitgroup=(name,P1), you can see time spent in each enqueue such as 5 sec in (TX), 3 sec in (TM) etc. 'latch free' and 'enqueue' waits do not make sense themselves. You can drill-down these each waits by itrprof. a little marketing... Mogens Nrgaard wrote: First of all, if you don't see cumulated waits for the 'latch free' event in either v$system_event or v$session_event (for a specific session/job) there is absolutely no need to do anything about these ratios. It's about the only two latches mentioned in the reference books and it's about the only two latches that never really have a problem :). My guess is that this effort (increasing log_simultaneous_copies and log_small_entry_max_size) hasn't increased performance on your system whatsoever. If - only if - you have latch contention/waits in the system (high percentage of time_waited in the above-mentioned v$system_event/v$session_event, you should ignore all those calculations with gets and misses and insted just look in v$latch like this: select name, sleeps from v$latch order by 2; to find the latches with highest contention. But again: If your system or session is not really waiting for latches, why bother? Rajesh Dayal wrote: Hi All, I had some situation of Redo Allocation and copy latch contention as stated in following output. SQL SELECT substr(NAME,1,18) NAME, GETS,MISSES, IMMEDIATE_GETS, IMMEDIATE_MISSES FROM V$LATCH WHERE NAME LIKE '%redo%' / NAME GETS MISSES IMMEDIATE_GETS IMMEDIATE_MISSES -- -- -- -- redo allocation 74878 16 00 redo copy 114100 53756 232 redo writing30219 1 00 3 rows selected. Realizing small contention on redo allocation latch, I increased the value of "log_small_entry_max_size" from 80 to 90. But this would definitely overload (already suffering) redo copy latches, so I increased the value of log_simultaneous_copies from 2 to 6. This sorted out redo latch contention, but somewhere in FM it's mentioned that value of log_simultaneous_copies shouldn't be more than (2 * #_of_CPUs). Again I know that the CPU is "not" heavily used so far. So... 1. Is it OK to set log_simultaneous_copies higher than 2*CPU. What are the golden rules. I have seen some authers not mentioning this. 2. Why this parameter is missing from Oracle 8i?? Has Oracle changed the algorithm?? What is the new strategy to handle redo latch contention?? Interestingly, in Oracle 8i (Oracle 8.1.6) Tuning Manuals they still talk of these parameters(which are made obsolete)... Appreciate your inputs ;-) Cheers, Rajesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rajesh Dayal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Venlig hilsen Mogens Nrgaard Technical Director Miracle A/S, Denmark Web: http://MiracleAS.dk Mobile: +45 2527 7100 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mogens =?iso-8859-1?Q?N=F8rgaard?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051
Re: Searching hard parses
Hello, First of all, let's notice that: - number of means AMOUNT - ratio means SPEED - time means TIME If you don't encounter time related events such as waits, CPU usages, It doesn't make sense What the values of AMOUNT and SPEED are. In you case, startting from parse count is not correct way. You should focus on parsing if parse time is high. use itrprof SQL Analyzer to see parse time, parse amount with their relavent SQLs. regards... Fernando Papa wrote: Hi everybody! I have this numbers for "parses": 1402684 parse count (hard) 9766294 parse count (total) 14,36 % of my parses are hard My database it's up since more than two days, with 943249 cumulative logons (oltp). The problem is two months ago the percentage of hard parses was about 12%... I try to find which sql sentences are forcing "hard" parses, but I don't know I can do it querying some v$ views or I need to examine directly all the sessions... Thanks in advance! -- Fernando O. Papa DBA El Sitio - Infraestructura (54-11) 4339-3854 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fernando Papa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ora-600 : Internal error code.. Help!!!
Unal is my surname, Bilisim is a Turkish word which means Information relevant things. "Koivu, Lisa" wrote: OK. What is unal-bilisim, it sounds like it's kinda disgusting. But what do I know. -Original Message- From: Kevin Lange [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, June 12, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Ora-600 : Internal error code.. Help!!! There is a web site, http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html, that lets you upload your trace file and it will give you links to any relavant info it can find on the subject. You might want to try it. -Original Message- Sent: Tuesday, June 12, 2001 1:07 PM To: Multiple recipients of list ORACLE-L DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: Export sizing
Hello, Yes you can. see http://www.unal-bilisim.com/qa/discus/messages/20/42.html?9923410 for Unix. I don't know NT. But, pipe mechanism is generic mechanism for Operating Systems Theory. There should be a way for NT to create pipes. By pipes, you can calculate. regards... "O'Neill, Sean" wrote: Is there some way to calculate or make a realistic guestimate as to what size an Export dump file will be for a given schema or indeed a whole database. I've not come across anything on this topic before. If result is dependant on O.S. I'm particularily interested in NT/W2K O.S. Sean :) Rookie Data Base Administrator [0%] OCP Oracle8i DBA [0%] OCP Oracle9i DBA Organon (Ireland) Ltd. E-mail: [EMAIL PROTECTED] [subscribed: Digest Mode] Visit: http://groups.yahoo.com/group/Oracle-OCP-DBA "Nobody loves me but my mother... and she could be jivin' too." - BB King -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-12545
These types errors are the errors which are casued by other errors. are there any other errors including alert.log ? [EMAIL PROTECTED] wrote: Hi Gurus! What can be wrong when I receive the following error message? ORA-12545: Connect failed because target host or object does not exist We use WinNT, Oracle 8.1.7 and Oracle Application Server. Any Idea? Thanks in advance Gyula -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: OT: Pin a CPU in Solaris
Hi, You can write a loop... Erik Williams wrote: Does anyone know how to pin a Solaris CPU at a high utilization? I am doing some testing and want to evaluate a system under a high CPU load. Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Ora-600 : Internal error code.. Help!!!
Hello, did you run iOraBugFinder ? Raj Gopalan wrote: DBA's I am getting following error in alert.log once in two days. on Jun 11 09:26:11 2001 Errors in file /export/home/u01/app/oracle/admin/orcl/udump/orcl_ora_6342.trc: ORA-00600: internal error code, arguments: [12333], [111], [108], [44], [], [], [], [] Mon Jun 11 09:49:04 2001 LGWR: prodding the archiver The DB is 8.1.5 on Solaris 7. When I referered to metalink, it says there could be some problem with the network in OS level. I am not sure how to track the error or where to look for this in the OS. Could some one help me in finding the cause of this problem? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raj Gopalan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Crash Recovery
Hi, In fact, in your case, adding larger TEMP is not the solution. Solution is the adding TEMP with larger extent size. Because, Oracle cleans up segments extent-by-extent. If you have more extents, cleaning-up them will make more dictionary look-up and this will eat CPU. regards... Charlie Mengler wrote: I've had something like this happen to me. My solution was to make TEMP larger; after enduring the LONG wait for recovery to complete. "Naik, Kevin K" wrote: Hi All, I have an interesting problem, on one of my databases, a data warehouse, a killed session was taking too long to rollback. It was time for the backup, and I had to do a shutdown abort. No its time to open the database, instance parallel recovery is taking place as normal, but the problem is, its being running for more than 20 hours and the database is still not open. Does any body have any clues, thoughts, ideas ?? Is there anyway I can see what exactly the dbms is up to ? The instance processes running are completely idle Thanx K Naik __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation(Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way. Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. ___ -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: ORA-01555 error
Hello, There are about 4 cases for ora-1555. Add following event to init.ora: event = "1555 trace name errorstack, level 3" After that, whenever Oracle encounteres ora-1555, a trace file will be generated. Send trace file, let's look at what is happenning. regards... "Farnsworth, Dave" wrote: I got this error last night; SCT51 - FETCH FROM DRP DRIVER CURSOR FOR DRP PROCESSING FAILED. MSG = SCT SCP_DRP_DRIVERPRODDB ORA-01555: snapshot too old: rol lback segment number 15 with name "RB1 Do I just need to increase the size of the rollback segment to fix this or is there something else I need to be looking at? Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Crash Recovery
Hi, Oracle was doing full recovery in older version during crash recovery ( I guess pre 7.3, but I'm not sure). But now, Oracle does not do full database recovery during crash recovery. Some un-recovered blocks are recovered when a user tries to use them later. So, if your online log files are not to huge, recovery is not a problem in your case. I guess ( I dont't like estimation), SMON may be cleaning up TEMP segments. Add following event to init.ora to see what is happing during recovery: event="10013 trace name context forever, level 10" This will show stages of recovery in alert log. If, SMON is trying to clean-up TMP segments, add following event to init.ora to disable SMON Temp cleanup: event="10061 trace name context forever, level 10" You can remove Event 10061 from init.ora later. There should be an event that makes SMON clean-up TEMP segments part-by-part. By this event, SMON doesn't clean up all TEMP segments immediately. SMON cleans up some parts of TEMP segments. after a while, SMON cleans up remainder parts. But, I dont't remember this event now. NOT: Be sure these events are active. Run "show parameters event" in svrmgrl after STARTUP NOMOUNT. "Naik, Kevin K" wrote: Hi All, I have an interesting problem, on one of my databases, a data warehouse, a killed session was taking too long to rollback. It was time for the backup, and I had to do a shutdown abort. No its time to open the database, instance parallel recovery is taking place as normal, but the problem is, its being running for more than 20 hours and the database is still not open. Does any body have any clues, thoughts, ideas ?? Is there anyway I can see what exactly the dbms is up to ? The instance processes running are completely idle Thanx K Naik __ Disclaimer and confidentiality note Everything in this e-mail and any attachments relating to the official business of Standard Bank Investment Corporation (Stanbic) is proprietary to the company. It is confidential, legally privileged and protected by law. Stanbic does not own and endorse any other content. Views and opinions are those of the sender unless clearly stated as being that of Stanbic. The person addressed in the e-mail is the sole authorised recipient. Please notify the sender immediately if it has unintentionally reached you and do not read, disclose or use the content in any way. Stanbic can not assure that the integrity of this communication has been maintained nor that it is free of errors, virus, interception or interference. ___ -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: urgent !!
Thank you Bunyamin, This is the one of the solution of generic ORA-12571 error. Keep in mind that there are a lot of solutions for that. "Bunyamin K. Karadeniz" wrote: Thank you All , for the answersI have corrected the fault with your helps.By the way ,Let me give you a fix of a bug on NT .If you take a packet write failure errorr.ORA-12571. This mean you will enter a dword value in registry in HKEY_LOCAL_MACHINE/system/currentcontrolset/services/tcpip/parametersdword will be.maxdatatransmissions = 15 in decimal.I faced it and tested. - Original Message - From: Robertson Lee - lerobe To: Multiple recipients of list ORACLE-L Sent: Thursday, June 07, 2001 12:24 PM Subject: RE: urgent !! I would suggest that your init.ora file is not where it should beie. check thatD:\oracle\ora816\admin\uybs\inituybs.orais exactly where the parameter file is and that it is named correctly.CheersLee -Original Message- From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]] Sent: 07 June 2001 09:15 To: Multiple recipients of list ORACLE-L Subject: urgent !! Hi all gurus..I want to create my database on NT but svrmgrl gives error ofSVRMGR> startup nomount pfile=D:\oracle\ora816\admin\uybs\inituybs.ora LRM-00109: could not open parameter file 'D:\oracle\ora816\admin\uybs\inituybs.ora' ORA-01078: failure in processing system parametersHow can I know which parameter causes the error?Here are my parameters Which one?db_name = UYBSinstance_name = UYBSservice_names = UYBSdb_files = 1024control_files = (D:\uyap_database\cf\control01.ctl, C:\uyap_database\cf\control02.ctl )open_cursors = 200 max_enabled_roles = 145db_file_multiblock_read_count = 16 db_block_buffers = 8192 db_block_size = 4096shared_pool_size = 22775808 large_pool_size = 734003200 java_pool_size = 0log_checkpoint_interval = 1 log_checkpoint_timeout = 1800processes = 715parallel_max_servers = 5log_buffer = 32768max_dump_file_size = 10240 # limit trace file size to 5M each log_archive_start = true log_archive_dest_1 = "location=D:\uyap_database\arc" log_archive_format = %%ORACLE_SID%%T%TS%S.ARC max_rollback_segments = 80 rollback_segments = ( RBS0, RBS1, RBS2, RBS3, RBS4, RBS5, RBS6, RBS7, RBS8, RBS9, RBS10, RBS11, RBS12, RBS13, RBS14, RBS15, RBS16, RBS17, RBS18, RBS19, RBS20, RBS21, RBS22, RBS23, RBS24, RBS25, RBS26, RBS27, RBS28, RBS29, RBS30, RBS31, RBS32, RBS33, RBS34, RBS35, RBS36, RBS37, RBS38, RBS39, RBS40 ) global_names = true oracle_trace_collection_name = "" background_dump_dest = D:\uyap_database\trace\bdump user_dump_dest = D:\uyap_database\trace\udump remote_login_passwordfile = exclusiveos_authent_prefix = ""distributed_transactions = 10 mts_dispatchers = "(protocol=TCP)"compatible = 8.1.0 sort_area_size = 65536 sort_area_retained_size = 65536 optimizer_mode=CHOOSE timed_statistics = true The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: dbsnmp package
Bunyamin, select * from dba_objects where object_name like '%DBSNMP%'; "Bunyamin K. Karadeniz" wrote: Hi all gurus,My question is how can I query the database for which packages are installed?I wonder if dbsnmp is installed?Thank you.Bunyamin -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: How to remove corrupted blocks from datafile.
Hi Uday, I don't know in which version dbv is stable; but, I know dbv was very buggy product. I recommend: - add event="10231 trace name context forever, level 10" to init.ora. This will eliminate corrupted blocks during full table scan. Note that this event is used while reading from disk. It does not effect cached blocks. - rebounce db. - create new table as select * from corrupted_table New table will not contain corrupted block. Following event should be used if blocks are accessed through index: event="10233 trace name context forever, level 10" udaycb wrote: Hi, I found some corrupted blocks in one of the datafile. I have created the temp table by select all the records (excluding the records in corrupted blocks) from corrupted table, and dropped the table, renamed the temp table back to original. After this when i run DBV on that file, it still shows there are some corrupted blocks in the file. i have two questions, 1 How do i calculate how many records i have lost? 2 How do i remove corrupted blocks from the blocks? Can anyone tell me ... Thanks in advance Uday Name: winmail.dat winmail.datType: DAT Dosyas (application/x-unknown-content-type-dat_auto_file) Encoding: 7bit -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: problems when running dbstart
Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SV: problems when running dbstart
You should rename it to max_transaction_branches . It's a typo error. I do typo errors very frequently, too. Mikael Granhed wrote: Thanks for your help, now it doesn't complain about "open_links" when i rename it. Now it's problem with the "max_transaktion_bransches". Should I rename that variable too? /Mikael -Ursprungligt meddelande----- Frn: Danisment Gazi Unal (Unal Bilisim) [SMTP:[EMAIL PROTECTED]] Skickat: den 6 juni 2001 15:01 Till: Multiple recipients of list ORACLE-L mne: Re: problems when running dbstart Hello Mikael, Rename open_link parameter in paremeter file initsid.ora or init.ora to open_links. Mikael Granhed wrote: Hi, I have oracle 8.06 installed on Sun Solaris. I have problems starting the database after a system crash and I had to reboot the system. When i run dbstart I got the following error message: SVRMGR connected SVRMGR oracle instance shut down SVRMGR Server manager complete ... ... ... SVRMGR connected SVRMGR LRM-00101: unknown parameter name 'open_link' ORA-01078: failure in processing system parameters SVRMGR server manager complete It's probably a very simple error but I'm a newbie in this area. regards /Mikael -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mikael Granhed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S
Re: export causes segmentation fault
r/local/ bin:/usr/java/bin:/usr/bin:/usr/ucb:/etc:/usr/sbin:/usr/bin:/usr/ucb:/et c:/usr/dt /bin:/usr/sbin:/usr/ccs/bin:/usr/openwin/bin:/usr/local/bin:. $ uname -a SunOS aleg 5.8 Generic_111459-01 sun4u sparc SUNW,Sun-Blade-1000 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, Long (ITS, Limestone Ave) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ora-600
Thank you Deshpande, It's nice to hear good results. I genarally recommend search depth=1. Search depth=0 may return a lot of bugs and it may take time to find which one is yours. And, You may not see all bugs. It depends on your license and bug status. Many bugs are un-published(not only bugs, but also everythingl. This list has more internals than Metalink). If iOraBugFinder returns no hit, email Oracle support with HTML or URL returned by iOraBugFinder. Since Oracle support can see all bugs, That will reduce your support response time from Oracle support. I added new features on 1.0.1 version. It's now better to find bugs. If you have any recommendations, please feel free to contact me. "Deshpande, Kirti" wrote: Hi, It generally means Contat Oracle Support. You may try to have your alert log file scanned at http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html. Set Search Depth to 0. Very nice little tool from Unal Bilisim. I used it a few times with good results. HTH Regards, - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Raghu Kota [SMTP:[EMAIL PROTECTED]] Sent: Monday, June 04, 2001 3:11 PM To: Multiple recipients of list ORACLE-L Subject: ora-600 Hi Friends What does it mean?? ORA-00600: internal error code, arguments: [17112], [33054472] Thanks Raghu. _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Raghu Kota INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: DBA_OBJECTS
Bunyamin, Why don't you use v$locked_object ? "Bunyamin K. Karadeniz" wrote: I want to select locked_objects in a view.I runCREATE OR REPLACE VIEW V_BUN_LOCKED_OBJECTS ASSELECT sn.username, m.sid, m.type, DECODE(m.lmode, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , lmode, ltrim(to_char(lmode,'990'))) lmode, DECODE(m.request, 0, 'None' , 1, 'Null' , 2, 'Row Share' , 3, 'Row Excl.' , 4, 'Share' , 5, 'S/Row Excl.' , 6, 'Exclusive' , request, ltrim(to_char(request,'990'))) request, obj1.object_name objname, obj2.object_name objname FROM v$session sn, V$lock m, dba_objects obj1, dba_objects obj2 WHERE sn.sid = m.sid AND m.id1 = obj1.object_id (+) AND m.id2 = obj2.object_id (+) AND lmode != 4 ;and gives error or ora-942. Can not find dba_objects .But with the same user I can query dba_objects table since my user has dba privilege.The inside of view runs perfectly.Why can it be?? -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. *
Re: Tkprof/explain plan errors
Note that tkprof's execution plan shows execution plan against current database connection to which tkprof is connected. So, execution plan in trace file and execution plan in tkprof output may be different. And, I guess, tkprof shows first execution plan. If your statement parsed more than once, Execution plans may be different. have you run itrprof at http://www.unal-bilisim.com/products/itrprof/itrprof.html . It reports execution plans in trace files(so, correct execution plans) and you can see all execution plan(s). regards... [EMAIL PROTECTED] wrote: I am trying to do some performance tuning on a users query by using tkprof. After running tkprof on the trace file (which was generated after using alter sessions set sql_trace true), I look at the results and they say error connecting to database using: / ORA-01017: invalid username/password; logon denied EXPLAIN PLAN option disabled. However, the correct username/password is being used. Not sure what is going on with Explain plan. Any suggestions - Sent using MailStart.com ( http://MailStart.Com/welcome.html ) The FREE way to access your mailbox via any web browser, anywhere! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: dbms_job query?
Hi Seema, - v$session.status="KILLED" is not enough to say that session is really killed. Check v$session.server column, too. If it's something other than pseudo i.e. dedicated,shared, it means that there are activities such as network I/O or rolling back a transaction, etc. - As I remember If an snp is killed, it wakes up after a while(but, I'm not sure) - If PMON has a lot of activities, it may take time to clean all resources allocated by killed session. - PMON can not remove session object. It is removed when a killed session tries to make kernel call (gets ora-28). - If a transaction is killed, current working statement is not killed immediately. for example: - insert - select ... - update 1000-- KILL here - update 5 If you kill during updating 1000 rows, Oracle will update 1000 rows, then session will be killed before updating 5 rows. what about SELECT (???) -- Web: http://www.unal-bilisim.com * Questions and Answers: http://www.unal-bilisim.com/qa/discus/ * itrprof SQL Analyzer: http://www.unal-bilisim.com/products/itrprof/itrprof.html itrprof SQL Analyzer is a web based tool which analyzes SQL_TRACE/Event10046 trace files of Oracle, finds bottlenecks and offersinformation on how to tune them. * iOraBugFinder: http://www.unal-bilisim.com/products/iorabugfinder/iorabugfinder.html iOraBugFinder is a web based tool which scans Oracle's alert log files, ORA-600 and ORA-7445 trace files; extracts relevant information from them and generates URL links to relevant bugs, notes, forums at Metalink. * ARUN K C wrote: we had these situations for this we had to break the job first and then kill the snp process after some time u will see the sid out of v$session. Even if you kill the snp it will be kicked back later on from pid or spid i think i am not sure but it works Try this out it should work Well there must be some better answers from the experts out here check it out From: "Seema Singh" [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: dbms_job query? Date: Fri, 01 Jun 2001 14:11:10 -0800 Hi If status=KILLED in v$session and the process is SNP oracle background process corresponding to that sid and dba_jobs_running has the same sid,no entry corresponding in dba_jobs then how to kill that process. Thx -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ARUN K C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Export character set
hello Libal, Yes you can. But, it doesn't always work. Visit http://www.unal-bilisim.com/qa/discus/messages/33/34.html?991400274 to see internals of Oracle character conversions. "Libal, Ivo" wrote: Hello I would like to ask you if you know about possibility to change an export file made by exp to change reported character set. I heard that it was used as a trick when database character set was needed to be changed. I would like to use it to avoid character set conversion during import to avoid loosing of special characters. Could you give me some more informations about it? Thank you in advance Ivo Libal -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Libal, Ivo INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: web page counter needed
Hello, sorry for this OFF-OFF-OFF... topic question. I'm looking for a counter which counts all visited pages, not just current page visited. thanks... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL TRACE
Merhaba, If aggeragate=false, which is not default, SQL statement length does not make sense since each SQL are same lenght in raw file and output. in addition to Ed, check your output. If there ara a lot of kernel calls such as parse,fetch, etc. row file will be larger than output. regards... Hi Arslan, it's a common situation. In general, the size of tkprof's output depends on number of identical sql statements. If my memory services me right tkprof groups identical sikvels by default. Regards, Ed -Original Message- From: Arslan Bahar [mailto:[EMAIL PROTECTED]] Sent: 31 ìàÿ 2001 ã. 13:06 To: Multiple recipients of list ORACLE-L Subject: SQL TRACE i have take trace file with SYS.DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION(sid,serial,TRUE). and trace file size is the 5MB but outpu of tkproff 31KB . is it normal.? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Arslan Bahar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shevtsov, Eduard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: deadlock error in oracle8.1.7 on sun solaris
Hi, It's most likely that you should change your code. If you need furher help, please attach trace file. -- Web: htpp://www.unal-bilisim.com Questions and Answers: http://www.unal-bilisim.com/qa/discus/index.html Seema Singh wrote: Hi Some time I am receiving the following information in alert logs. "ORA-60: Deadlock detected." and .trc file generated.Let me know what to do to prevent such error. Thanks -seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Database slowdown after 100 days uptime
Hi, There is an alert (Note:118228.1) ALERT: Hang During Startup/Shutdown on Unix When System Uptime 248 Days. But, you are using NT. do you have other errors in alert.log before crash or is there core.log ? "Reardon, Bruce (CALBBAY)" wrote: Hi, We're running Oracle 8.1.5.1.1 on NT 4. On Saturday our database started getting much slower - to me, there didn't seem to be any major events showing up in v$session_wait, v$session_event Restarting the database instance and service solved the performance problems. Today, when reviewing logs of the queries I noticed that the database had been up for 100 days when it started slowing. The 100 days uptime may be unrelated, but has anyone seen this behaviour on any platform? For information, the server itself has been up for 242 days (240 days when the problem started occurring). Thanks, Bruce Reardon mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Error Message - Database is Already Up
Hello Vivek, Check followings: - If I'm not wrong there should be lk* file 7.3.3 and onwards. remove it. - check shared memory/semaphores by ipcs. if They still exist, remove them by ipcrm if problem still exist, you are most probably hitting a bug. - debug your process by truss/trace in OS system call level. check last lines of truss/trace output. I'm not sure last system call is flushed to file. check it. - set event="error code trace name errorstack forever, level 10" in init.ora. re-produce error. then send us trace file created under udump. regards... VIVEK_SHARMA wrote: After Installing Additionally Only the PQO Component of ORA 7.3.4.5 , When Finally Attempting to RE-Link the Oracle Exe , Following Error Message ( of sorts ) is Displayed :- Database is Already Up . Shut it Down First . Hence Re-Link of Oracle Exe Failing NOTE - 1) NO Database whatsoever is UP 2) ORACLE_SID is NOT Set to Any Value 3) NO sgadef$ORACLE_SID File Exists in $ORACLE_HOME/dbs Dir 4) NO $ORACLE_SID_struct File Exists in $ORACLE_HOME/dbs Dir -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: hosting forums
Hello, do you know an organization supplies web-forums hosting. I'll launch my FQA page, but I don't want to deal with setup/backup etc. thanks... *** Unal Bilisim http://www.unal-bilisim.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OT: my site is available
Hello list, I don't know this is the correct way. my site http://www.unal-bilisim.com is ready to launch. you can use my web based database products, post questions and answers about my products and Oracle products. regards... -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: cpu utilization on solaris
Hi, As I remember, there was a bug on Sun-A1000 with CPU utilizitation. There should be an article of Erhan Odok on metalink which gives Sun's bug number. regards... Jared Still wrote: Run 'top' and see what the CPU hogs are. If they are Oracle shadow processes, check with the user that owns the session. It may belong to someone whose PC crashed or the just shut it off, and you have a disconnected session consuming resources. If you discover a shadow process is consuming 100% of a CPU, it probably needs to be killed. Just be sure to find out if it's OK to do so first. Jared On Wednesday 23 May 2001 13:56, Nihar wrote: Hi gurus I am running oracle 8.1.6 on solaris 2.7. All of a sudden my cpu utilization reached 85-90%. I am also having Sun A1000 hardware RAId attached to the box. Can any body help me out in this. i am sending my report.txt file here after running utlbstat and utlestat. thanks -Nihar Content-Type: text/plain; charset="iso-8859-1"; name="report.txt" Content-Transfer-Encoding: quoted-printable Content-Description: -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Danisment Gazi Unal (Unal Bilisim) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).