Re: Statspack Will Not Install Oracle 9.2.0.4

. But I was told this is fixed in 10g ;) KG = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED

Re: Suggestions Needed: Latch free - library cache

: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

Re: Suggestions Needed: Latch free - library cache

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: DB_WRITER_PROCESSES vs DBWR_IO_SLAVES

://gkmqp.tce.com/tis_dba = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET

Re: Books on rac

to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http

Re: recreable/freeable chunks

for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat

Re: Hit Ratio

is , Hit ratios are beautiful numbers but, you can not relate the pattern to the performance. May be you can compare the hit ratio when the system is good/bad and figure out there is a change in IO pattern between those interval.. IMHO and YMMV. Regards, K Gopalakrishnan - Original

Re: rebuilding indexes - sure to cause a ruckus

://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from

Re: ** can two processes use the same rollback extent

segment header. THis is called 'free extent pool' and the structure and the blocks are clearly visible in the undo header dumps. Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 03, 2003 1:59 PM

Re: RAC and Forms6i

, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan

RE: 'internal' role and 9i

. Best Regards, K Gopalakrishnan -Original Message- Barry Deevey Sent: Tuesday, November 18, 2003 7:09 AM To: Multiple recipients of list ORACLE-L As of yet I'm unsure how the application would be affected if I rename the role - I need to do some investigation. I tried this in Oracle 8

RE: col_usage$ question

Raj: Wolfgang is right. It is populated by SMON (I think every 15mins SMON flushes the data to COL_USAGE) and the predicate columns are updated (or collected) from the hard parse of the SQLs. Best Regards, K Gopalakrishnan -Original Message- Wolfgang Breitling Sent: Tuesday, November

RE: alter database character set (Was: RE: 'internal' role and 9i)

? Yong Huang --- K Gopalakrishnan [EMAIL PROTECTED] wrote: INTERNAL_USE is an keyword (to enable an undocumented feature) in ALTER DATABASE command. THis can be used to convert the database character set if the existing char set (national charset) is the superset of the db charset. You can

Re: RBO to CBO migration books/ material

Suhen: John K has a nice paper (IOUG-A?) at his website. Google for his name or 'RBM CBO Migration minefields' Regards, Gopal -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051

Re: 10g new features

* ERROR at line 1: ORA-01904: DATAFILE keyword expected SQL So, what did you mean? On 2003.11.03 21:59, K Gopalakrishnan wrote: Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG

Re: What is a local write wait?

: 516 5746065 E-mail: [EMAIL PROTECTED] K Gopalakrishnan To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: [EMAIL PROTECTED] Subject: Re: What is a local write

Re: 10g new features

Jared: 'alter tablespace rename' is not the REAL 10g feature. It is available from 9.2 onwards... :) Hope you know what I mean,, KG - Original Message - From: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L Sent: Tuesday, November 04, 2003 12:54 AM

Re: What is a local write wait?

of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: Alter tablespace begin backup

Jeremiah Wilton has a nice note on his site.. Check it at http://www.speakeasy.org/~jwilton/oracle/hot-backup.html = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ

Re: 10046 level 8 trace - help required with 'direct path

you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San

Re: using temp tables for staging databases?

Hi, The walking in the freelist is just 5 blocks (or the value of _walk_insert_threshold number of blocks) and I belive tanel is talking about (_release_insert_threshold) unlinking from freelist, which also default to 5 blocks. KG - Original Message - From: Binley Lim

Re: state objects

as global and PGA components are local to that process (in crude terms.) KG - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Sunday, October 26, 2003 10:59 AM Hi K Gopalakrishnan , Wishing you the same Thanks I understood what is state objects

Re: state objects

is in the freelist or initialized or dead. For better understanding of the various state objects I would recommend to take a systemstate/process state dump and have a look at the trace files. Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list

Seven Deadly Sins in Oracle?

List, Anyone has the copy of Steve Adams' 'Seven deadly sins in Oralce' paper. I guess Steve presented this in OOW '01 and I am looking for that paper.. If anyone has a copy of that note, please mail me privately. Thanks ! Regards, K Gopalakrishnan Bangalore, INDIA -- Please see the official

Re: 10046 trace question

Title: 10046 trace question Raj: THe simple option is to run the ALTER SESSION command to set some session level parameter like 1=1 and get the timings. Giving the EXECUTE on DBMS_SYSTEM is not a good idea. KG - Original Message - From: Jamadagni, Rajendra To: Multiple

RE: Cache a table

Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: Find CPU clock speed on HP-UX 11

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: Find CPU clock speed on HP-UX 11

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

Re: LONG data type in 10g

YES. --- Nancy Hu [EMAIL PROTECTED] wrote: Does any one know if 10g still supports LONG data type? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http

Re: LONG data type in 10g

--- Mladen Gogala [EMAIL PROTECTED] wrote: Much more menacing question: Are the columns DBA_VIEWS.TEXT and DBA_TRIGGERS.TRIGGER_BODY still of the type long? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

Re: bitmap conversion on a index that is not bitmapped ???

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: bitmap conversion on a index that is not bitmapped ???

behavior. KG = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City

Re: More info about _db_writer_max_writes

the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: x$ constructs and memory

information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: Steps to convert a RAC to a single instance.

-- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing

Re: x$ constructs and memory

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

Re: x$ constructs and memory

://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself

Re: any else try trace analyzer?

Dan: Have you tried the itfprof at www.ubtools.com , which also gives lots of meaningful info from the 10046 trace. It is free, online, web based and what else you need ? = Have a nice day !! Best Regards, K Gopalakrishnan

Re: Oracle Standby database.

versions of OS and database. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City

RE: How to extract data directly from a datafile ?

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

Re: latch free wait event

(or spinning) latch you can get an easy fix based on the latch. Regards, K Gopalakrishnan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, September 05, 2003 5:14 AM The number of waits is irrelevant. What matters is the time waited which

Re: RAC - lms process

] wrote: Running RAC on 9.2.0.3 the lms processes seem to be very busy. Anyone have any thoughts on that? Robert -- = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE

RE: Collaboration Suite

for administrators (at least the current versions) Best Regards, K Gopalakrishnan -Original Message- Brian Haas Sent: Wednesday, August 20, 2003 2:50 PM To: Multiple recipients of list ORACLE-L Hello all, We're looking at Oracle collaboration suite and I'm wondering if anyone here is using

RE: RAC interconnects

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: RAC interconnects

.*1 = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services

Re: Oracle SCN Question

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

RE: RAC

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego

Re: RAC

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com

RE: RAC

Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting

RE: RAC system Calls

Title: RE: RAC system Calls Raj: I am discussing this issue with Ravi offline. From the initial IPC dumps, It looks like the private interconnect is not properly configured/used for cache fusion. I am waiting for more details from him.. Best Regards,K Gopalakrishnan -Original

RE: RAC system Calls

Ravi: Do you have a statspack report? I would like to see that. But in any case, 45% kernel is just too much? BTW have you verified the private interconnect is used for cache fusion transfer.. Make sure the cache fusion is not going thru the public network. Best Regards, K Gopalakrishnan

Re: Oracle 9.2 RAC on Win2K?

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Migrating 8i OPS to RAC 9.2

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: Migrating 8i OPS to RAC 9.2

(or 5th) CR request will most of the times results in a PING and I have seen good performance improvements in most of the RAC databases by changing this parameter. Best Regards, K Gopalakrishnan (Currently I am in a country (for a week) where I have very limited access to the internet , So I may

RE: AQ, RAC and delay

Hemant: You are right. 7 seconds is the MAX difference, but the control files are synced every 3 seconds during the 'split brain' check. So most of the cases, it is 3 seconds with the maximum of 7 seconds subject to the MCPD settings. KG Best Regards,K Gopalakrishnan -Original

RE: Single Block Read

Naveen: Table Access by INDEX ROWID Best Regards, K Gopalakrishnan -Original Message- Naveen Nahata Sent: Friday, June 13, 2003 3:21 AM To: Multiple recipients of list ORACLE-L -Original Message- From: K Gopalakrishnan [mailto:[EMAIL PROTECTED] Starting from 8i the db

RE: db file sequential read [WAS:wait event puzzler]

happens during index scans.. Are you convinced? Best Regards, K Gopalakrishnan --- Gogala, Mladen [EMAIL PROTECTED] wrote: A SINGLE block? I was convinced that it was = DB_FILE_MULTIBLOCK_READ_COUNT blocks. Are you sure? Mladen Gogala Oracle DBA Phone:(203) 459-6855 Email:[EMAIL

RE: RAC, fail over and timeout .. Big Question

overcome this by enabling pre-connect. Pls let me know if you got any nice ideas ;) Best Regards,K Gopalakrishnan -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: Thursday, June 12, 2003 7:50 AMTo: Multiple recipients of list ORACLE

RE: Some rollback doubts

in the segment header dumps. You can dump the rollback segment header by using the alter system dump undo header 'undo_segment_name' command. However this free extent pool just keep 5 undo blocks with free space. I hope this answers both of your questions.. Best Regards, K Gopalakrishnan -Original

RE: selectivity of predicates with LIKE - diff between 8i and 9i

parameter _like_with_bind_as_equality to get the index costing. KG Best Regards, K Gopalakrishnan -Original Message- Boris Dali Sent: Wednesday, June 11, 2003 10:21 AM To: Multiple recipients of list ORACLE-L Dear List, Is there any difference between 8i and 9i in how selectivity

RE: wait event puzzler

Dennis: THe event 'db file sequential read' is NOT always an INDEX Scan. It is just a single block read which TYPICALLY happens during an INDEX scan. The word 'TYPICALLY' is the key here. Best Regards, K Gopalakrishnan -Original Message- Meng, Dennis Sent: Wednesday, June 11, 2003

RE: Rule Based Optimizer

RULE optimizer will not be supported in next version. But you can still use the RULE optimizer and it is just a matter of official support from Oracle. Best Regards, K Gopalakrishnan -Original Message- Goulet, Dick Sent: Tuesday, June 10, 2003 10:16 AM To: Multiple recipients of list

RE: Rule Based Optimizer

Hi RWB: Check the Note 189702.1 in Metalink. Its official from Oracle. ;) Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Tuesday, June 10, 2003 2:25 PM To: Multiple recipients of list ORACLE-L Mr. Gopalakrishnan: How do you know this? Can anyone confirm

Re: HP-Sun Cross Platform Migration - Exp/Imp, CTAS over dblink or ..

, I remember seeing some comparitive numbers in Metalink.. Have you checked that? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K

RE: RMAN Catalog: 1 vs. many - Opinions

in the backup process. It happened at one of our client place where they backup 200+ databases with a single RMAN catalog at 2-3 hrs interval. The workaround suggested was a) Have more RMAN Catalogs b) Run the backup in different times. So again it 'all depends ' Best Regards, K Gopalakrishnan

RE: Which process is taking up so much CPU???

ALTER SYSTEM SET TIMED_STATISTICS=TRUE; You don't need to bounce the database ;) Best Regards, K Gopalakrishnan -Original Message- WILLIAMS Sent: Friday, March 28, 2003 6:49 AM To: Multiple recipients of list ORACLE-L Fermin Add this line to your init.ora file. timed_statistics

RE: log buffer space

Jonathan: I have just sent a mail which has the test statistics. I would appreciate your comments on that.. Alternatively, people who are curious may want to test the log writer writing habits using the event 10046^8. KG Best Regards, K Gopalakrishnan -Original Message- Lewis

RE: db file scattered read

). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services

RE: log buffer space

notes. Best Regards, K Gopalakrishnan -Original Message- Sent: Friday, March 14, 2003 11:04 AM To: Multiple recipients of list ORACLE-L Dennis, The 1MB condition was in 8i as well, at least in 8.1.7, as I mentioned in my original post. I was always under impresssion that the flush

Re: log buffer space

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

Re: fgac tracing

Murali: It is event 10730. You can set that at session level. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan

Re: Oracle Tools

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

Re: 9iR2 Oracle SGA Memory

can find on Amazon.com! = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network

Re: File Table Overflow on Oracle DB Server

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: RE: Top 10 DBA Do's and Don'ts anyone - Here is my list, comments

want to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http

Re: corrupted block

statement to put those rows in to the new table. KG = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL

Re: Oh Where Oh Where Is My Redo Coming From

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Automatic Segment Space Management

by scanning the L2 bitmaps the process can find the unused blocks and skip that during sequential scanning, though I have not tested it thoroughly. Best Regards, K Gopalakrishnan Bangalore, INDIA (Now in Austria) --- Deshpande, Kirti [EMAIL PROTECTED] wrote: In a very limited tests that I

RE: Automatic Segment Space Management

! ** The opinions and statements above are entirely my own and not those === message truncated === = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author

RE: Automatic Segment Space Management

Gopalakrishnan --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Kirti: I have not complely following this thread. But I am sure it is worth mentioning even if someone already mentioned also. In ASSM there would be two highwatermarks called low high water mark and high high water mark. The high

Re: RAC recomended books

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California

RE: 10046 trace - weird library misses

Hi, It is just telling that you are doing HARD PARSE. Hard Parse is indicated in the trace file as 'misses in library cache'; Best Regards, K Gopalakrishnan -Original Message- Gorbounov,Vadim Sent: Thursday, February 13, 2003 6:49 AM To: Multiple recipients of list ORACLE-L Dear

RE: Deep OPS tuning info

from the V$resource_limit to the lm_% parameters to get an idea about the resource utilization. BTW Do you see Dynamic resources/locks allocated message in the alert logs? Best Regards, K Gopalakrishnan -Original Message- MARREIROS,RUI (HP-Portugal,ex1) Sent: Thursday, February 13

RE: How to dump UGA ??

Jonathan: How about calling the DBMS_SYSTEM.READ_EV procedure? I think this is simpler than going to the UGA dumps.. THe restriction with DBMS_SYSTEM is, you can not get the event settings of the other sessions. But Dumps can. Best Regards, K Gopalakrishnan -Original Message

RE: index hint ignored?

Title: Message Hi, THe syntax is incorrect. Incorrect HINTs are treated as comments. replace the comma with blank space and your hint will work as expected. Best Regards,K Gopalakrishnan -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf

RE: Global Stats

Kirti: I think the interval is changed to 5 minutes from 3 hours starting from 9i (rel2?). Best Regards, K Gopalakrishnan -Original Message- Kirti Sent: Wednesday, January 29, 2003 8:19 PM To: Multiple recipients of list ORACLE-L Lisa, Monitoring, by itself, does not fire any

RE: Global Stats

Kirti: Sorry for the typo. It is 15 minutes. --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Kirti: I think the interval is changed to 5 minutes from 3 hours starting from 9i (rel2?). Best Regards, K Gopalakrishnan -Original Message- Kirti Sent: Wednesday, January

RE: Global Stats

are written to dictionary from SGA once in 15 minutes and then the tables are examined to get the stale stats. Metalink note 102334.1 has some details.. Best Regards, K Gopalakrishnan Bangalore, INDIA --- Deshpande, Kirti [EMAIL PROTECTED] wrote: Gopal, I should have waited a bit longer

Re: v$Views and d$Tables

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list

RE: Caught YAPPing

Rajesh: You can schedule statspack snaps at 30 minutes interval and then compare the response times at each interval.. But the question is 'what do you mean by average response time?' KG Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Thursday, January

RE: Minimum required init.ora parameters

The only one parameter.. control_files. Rest are optional. Best Regards, K Gopalakrishnan -Original Message- WILLIAMS Sent: Monday, January 13, 2003 7:44 AM To: Multiple recipients of list ORACLE-L Hemant - I was just going from my hastily written class notes. Sorry about

RE: Some of you may find this useful

Read Only Dependencies in the KGL. Best Regards, K Gopalakrishnan -Original Message- Mike (NESL-IT) Sent: Friday, January 10, 2003 8:39 AM To: Multiple recipients of list ORACLE-L Ron, that's a bit of a puzzle because it should have been available since 7.3.2. Which user are you

RE: ORA-00600: [2662]

Mogens: Yes. You are right. You have to bump the SCNs globally (i.e. across all data files to higher number, say 1 Billion) using the event 10015 and ADJUST_SCN. Then we can safely open the database and rebuild that. KG Best Regards, K Gopalakrishnan -Original Message- Norgaard

Re: ORA-00600: [2662]

you want to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http

Re: ORA-00600: [2662]

containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

Re: Physical reads

of physical I/Os to the disk happened? = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat

RE: Cache on sysdate? --From 9i performance planning manual

... but I can take an explanation Raj = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat

RE: Cache on sysdate? --From 9i performance planning manual

immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*2 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: K Gopalakrishnan INET: [EMAIL

RE: help me find out why rac instance died

. THere are some kernel events to trace the reconfigurations, and an underscore parameter (I think it is _imr_active !) to disable the 29740 usually not recommended. For investigation , review the check point, LMON trace files and check the OS log files. Best Regards, K Gopalakrishnan -Original

RE: Single-task message waits

Rick: ANjo Kolk classifies this wait event under one of the IDLE wait events.i.e nothing to worry if you see them in excessive. Best Regards, K Gopalakrishnan -Original Message- Sent: Tuesday, December 03, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Hey all, Does anyone

  1   2   3   >