Re: UTL FILE PKG

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http

Re: smon Q?

tire clean up process. Though it it littel outdated most of the things still applicabel for the current versions,. You can safely ignore the message if you not bothered too much = Have a nice day !! Best Regards, K Gopa

Re: Excessive Archivals for NO Apparent Reason

not updated this afterwrds) But the concept is well explained. Best Regards, K Gopalakrishnan Bangalore, INDIA _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http

Re: session commits when PC crashes

@yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: Best Practice ?

free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

Re: Connect internal password ?

ss at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

Re: Trying to find a book...

the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL

Re: New born DBA.....

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http

Re: can I set a default index tablespace??

Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED

Re: tkprof for 10046 event

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET

Re: X$ tables

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET

RE: Standard vs Enterprise

the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: dictionary information

these tables. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Friday, April 20, 2001 11:01 PM To: Multiple recipients of list ORACLE-L Hi Which dictionary table is used to see all X$ tables. Thnaks -Seema

RE: Parallel Query Option

://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: x$ksppi table

is Steve Adams and he has plenty of insights to share. Check him on http://www.ixora.com.au or Oracle8i Internal Services from Oreilly. Have a nice day !!! Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Xing Sent: Friday, April 20, 2001 12:30 PM To: Multiple recipients

RE: SQLTrace

@yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing

RE: Rollback Segments

that rollback segments, and this the transactiions, transactions_per_rollback_segments parameters have no control over the pRIVATE Rollback segments Hope this helps Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kostyszyn Sent: Wednesday, May 09, 2001 8:51 PM To: Multiple

RE: Rollback Segments

Hi ! Not very much. In 9i you have an option to have AUTOMATIC_UNDO_MANAGEMENT where you specify a huge undo tablespace and the undo is managed by oracle. But you can still have the rollback segments. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- William Sent

RE: ORA-1554: Out of transaction slots

Regards, K Gopalakrishnan http://www.oradebug.com -Original Message- [EMAIL PROTECTED] Sent: Tuesday, October 08, 2002 11:34 AM To: Multiple recipients of list ORACLE-L Hello Folks, I carried out a test, whereby I had just one rollback segment online with a block size of 2K

RE: But I *want* to use RBO!

Title: RE: But I *want* to use RBO! Not sure about their Optimizer migration strategy. Would it be better if they allow us to define the constants for the Optimizer when there is no statistics? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of

RE: Table Scans

are read to the buffer cache via sequential scan. Best Regards, K Gopalakrishnan http://www.oradebug.com -Original Message- (DBA) Sent: Wednesday, October 09, 2002 9:34 AM To: Multiple recipients of list ORACLE-L I am looking for a query that will allow me to find the SQL statements

RE: is this block cleanout ?

Regards, K Gopalakrishnan -Original Message- Faroult Sent: Saturday, October 19, 2002 6:44 AM To: Multiple recipients of list ORACLE-L Deshpande, Kirti wrote: That's sounds about right... - Kirti -Original Message- Sent: Saturday, October 19, 2002 3:48 AM To: Multiple

RE: Tracking Temp Segment Usage and Event 10046

Title: Tracking Temp Segment Usage and Event 10046 Raj: You will be able to identify the processes (along with the SQLs and number of extents) using the 10046 level 8 trace. If you use the temp files you see the file# ( in the direct path read/write events) as db_files+1 or MAXDBFILES+1

RE: How to find out those parameters set in session level.

on? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: UFS logging

(like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Lost ofall redo logs

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: Re-creating control files with larger maxdatafile setting

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: K Gopalakrishnan INET: [EMAIL

RE: Re-creating control files with larger maxdatafile setting

(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: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http

RE: Re-creating control files with larger maxdatafile setting

the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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: Re-creating control files with larger maxdatafile setting

') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: K Gopalakrishnan INET: [EMAIL

RE: Lost ofall redo logs

also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing

RE: copying all schemas except sys

a line containing: UNSUB ORACLE-L (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: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City

RE: DB Freeze

Raj: You can dump the SYSTEMSTATE/PROCESSSTATE using ORADEBUG dump and analyze the trace files. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Rajendra Sent: Tuesday, May 21, 2002 1:00 PM To: Multiple recipients of list ORACLE-L Last Friday, our 9012 database

RE: ITL Deadlock Example?

SET PCTFREE=0 and fill the rows in that data block. Then update two DIFFERENT rows in that block from DIFFERENT sessions. You will get the required deadlock !! Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Tuesday, May 21, 2002 1:14 PM To: Multiple

RE: ORA-600 [3708] During Database SHUTDOWN

Vivek: Oracle Support is right. THis is a typical LGWR problem. The first thing you should do is.. You need to reduce the size of Log Buffer (it should be in KBs.. NEVER configure log buffer in MBs) Try setting log buffer in KBs. Best Regards, K Gopalakrishnan Bangalore, INDIA

Re: Adding processor to Oracle server

Dave: This is automatically taken care by the RDBMS kernel and sometimes relfected in the CPU_COUNT in the V$parameter. Otherwise you can query the X$view X$KVII select kviidsc,kviival from X$kvii where kviitag='ksbcpu'; Best Regards, K Gopalakrishnan Bangalore, INDIA - Original

Re: Bind Variable values

Raj: Level 15 (or level 100 or 200!!) is level 12 only. Anything above level 12 is considered as level 12/ Best Regards, K Gopalakrishnan - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 30, 2002 10:13 PM Dennis (or anyone else

RE: Value Set by ALTER SYSTEM Command ?

for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

RE: system event waits

. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Yahoo! - Official partner of 2002 FIFA World Cup http://fifaworldcup.yahoo.com -- Please

RE: negative value for buffer cache hit ratio

Nothing is wrong in your database. You don't have the required X_$ views created. Change X_$ to X$ or create X_$ views as select * from X$ views. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

Re: negative value for buffer cache hit ratio

platform. Check the actual values from v$sysstat to see if some of them have gone negative or appear to be 'counting backwards'. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

RE: negative value for buffer cache hit ratio

- 0.68% Is that good or bad, Oracle 8.0.5 Standard Edition, Windows 2000. Is there a 8.1.7 Standard Edition Version ? Ramon Estevez [EMAIL PROTECTED] = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore

Re: ora-600/ora07445

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http

Datafile Migration Tool

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K

RE: Datafile Migration Tool

do we call if there is a problem in the converted datafile later down the road and the database is down? The Tool Supplier or Oracle Support? Thanks. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

Re: Datafile Migration Tool

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http

RE: Datafile Migration Tool

sandbox area. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http

RE: Datafile Migration Tool

!! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo! Messenger http://phonecard.yahoo.com/ -- Please see the official ORACLE-L FAQ: http

Re: Datafile Migration Tool

with export -- ftp -- import. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute with Yahoo

Re: ENQUEUE RESOURCES and DML LOCKS

http://www.geocities.com/epost1 = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Make international calls for as low as $.04/minute

Re: ksqsttyp in x$ksqst CF

some waits associated with the value CF, but I don't know what that means. If anyone can help, I'd greatly appreciate it. Lisa = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

RE: What's up with http://www.unal-bilisim.com/

Raj, The site is shutdowned for maintenence. Danisment is working on that and will be up soon.. Thanks for your interest.. Best Regards, K Gopalakrishnan, Bangalore, INDIA -Original Message- Rajendra Sent: Thursday, September 06, 2001 7:21 AM To: Multiple recipients of list

RE: Re[2]: How to change error messages?

Hi All, THis message file is used only by OERR utility and kernel has its own error messages built-ins. SO the changes in the oraus.msg will not be actually used by the kernel. Best Regards, K Gopalakrishnan -Original Message- [EMAIL PROTECTED] Sent: Friday, September 07, 2001 5:52

RE: Creatin TBS in Raw Devices

Specify the size as 99M. You will not get an error. (why??? I will leave that reason to you ;) Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- [EMAIL PROTECTED] Sent: Tuesday, March 26, 2002 3:43 AM To: Multiple recipients of list ORACLE-L Hi List, First time

RE: TKPROF?

Anjo: I always thought it Trace Kernel PROFile? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, April 10, 2002 8:23 PM To: Multiple recipients of list ORACLE-L Tool Kernel PROFiler Anjo. David Nemeth wrote: What does it stand for? Tool Kit

RE: Number of CPUs vs. Speed of CPUs

supports more slower CPUs. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Bruce (CALBBAY) Sent: Thursday, April 18, 2002 4:33 PM To: Multiple recipients of list ORACLE-L Lisa, These aren't my points or ideas but below are some emails from Steve Adams that I have

RE: Steps in db opening from mount stage to open stage????

THere are some numeric events (for example event 10015) to trace the SMON and Instance recovery. None of them are documented. Other than that I have not seen any external references/. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Kurliye Sent: Sunday, May 05

Re: list of events

Dave: You will not see this file in Windoze. In MS world the message file is a binary file and you will not be able to read with any text editors/viewers. Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED

Re: Order rows

is your method (additional column SYSDATE) Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, May 15, 2002 7:33 PM Do you want to physically order them or do you just want to know by time

Re: Order rows

the PCTUSED to absolutely low value so that the used blocks never linked to freelist chain. So everytime you look for a space you go for a virgin block. THe space reclaimed by any DELETEs never returns to freelists . Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message

Re: Deadlock ORA-60

Seema: Post the deadlock graph. We will be able to help you. THe deadlock graph will be in the trace file under udump Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 12:48 AM

Re: Dba_tab_modifications question

John: Not being so choosy, MONITORING is subject to latching. There is a latch called 'hash table allocation/modification latch' which keeps the modification in the shared pool and SMON periodically flushes to the disk. Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message

Re: SMON reports Dead Transactions - Not seen this before

$transaction for a known transaction id. There are also few events , like 10013/10015 to trace the instance recovery/rollback segment recovery. I would suggest you set this events to identify the DEAD transactions. Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message

Re: Waits 8i vs. 9i??

Internal code changes= additional features=fine grained (event) reporting? Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, May 16, 2002 9:13 PM Has anyone noticed that the number of event

Re: Waits 8i vs. 9i??

Raj: Oracle9i gives timing information in Micro Seconds. Not Nano Seconds though modern CPUs clocks ticks in nano seconds. The older versions (8i and below) give timing info in Centi Seconds (1/100th of a second) . Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message

Re: Wait Event PX Deq: Execution Msg

Nancy: From your message the average wait time is less than 1 micro second (if I my undertstanding is correct) and I would not worry much about that if that is the case. Best Regards, K Gopalakrishnan Bangalore, INDIA - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL

Re: wait event trace file formatter?

all wait events to a file). Has anyone written such a formatter, or have information on one? Thanks. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

RE: wait event trace file formatter?

on Metalink makes reference to a formatting utility but, of course, neither includes nor specifies where to find said utility. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

RE: Is CKPT process is Mandatory in 8i

Hi, It is mandatory starting from Oracle 8. In Oracle 7 it was optional. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Thursday, November 22, 2001 6:55 AM To: Multiple recipients of list ORACLE-L Hi List, Today we had a big argument at our work place

RE: Re: Re: ACM SIGMOD-papers of interest #1

http://www.amazon.com/exec/obidos/ASIN/0201325748/qid=1006942220/sr=8-1/ref= sr_8_7_1/107-0449271-4062165 Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Thankappan Sent: Wednesday, November 28, 2001 1:35 AM To: Multiple recipients of list ORACLE-L Hi! can you

RE: Standby Database

in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Wednesday, November 28, 2001 4:16 PM To: Multiple recipients of list ORACLE-L I am also facing the same problem. All these disadvantages in 8i standby DB have been taken

RE: Determinants of control file

Title: Determinants of control file Other than dumping/ tracing the control file, you can find the required details in the dynamic view V$controlfile_record_section. This view has all the information you want Best Regards, K Gopalakrishnan -Original Message- From

RE: Standby Database

and you can open the standby database with the new control file created with NORESETLOGs . In this way you have a graceful fail over in the standby database and no committed Transaction is lost in the standby database Does this sound good? Best Regards, K Gopalakrishnan Bangalore, INDIA

RE: Standby Database

Richard, You are right. It is close to Zero data loss. Not exactly Zero Data loss. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Friday, November 30, 2001 6:45 AM To: Multiple recipients of list ORACLE-L Kay, thanks for the explanation. Sorry for being

RE: space used by pinned objects

Hi, You can select the information from V$DB_OBJECT_CACHE. Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Sent: Tuesday, December 04, 2001 8:55 PM To: Multiple recipients of list ORACLE-L I've pinned some procs that were being loaded very frequently. How can I

RE: rollback for temp tablespace

Definitely. Unless you say NOLOGGING or UNRECOVERABLE (depending on the versions). But data dictionary changes are always logged irrespective of logging mode. Best Regards, K Gopalakrishnan -Original Message- Shrinivas (MED, Keane) Sent: Wednesday, December 05, 2001 2:30 AM

RE: OT : Listers met at OOW

John, Here is the update from Jonathan Gennick ... http://oracle.oreilly.com/news/openworld_day3_1201.html Best Regards, K Gopalakrishnan -Original Message- Sent: Wednesday, December 05, 2001 1:45 PM To: Multiple recipients of list ORACLE-L Dear all, I had promised a few people

RE: Import/Export table

Hi, You can do a USER Level export and import them to another schema. If the names are different you may have to use FROMUSER TOUSER during the import. Oracle Utilities Manual will have more information. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL

RE: export database from AIX to Sun

the database using CTAS. (Create table as select over a dblink). This will be much faster than export and import (oracle Metalink has some statistics). This can be used if you have very few, huge tables. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Carmichael Sent

RE: which view used ?

Samir, No. X$objects are not tables. They are C structures and the values in X$tables are the current value of those structure. Few of the X$tables (or structures) query from control file/SGA when you select from them. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message

RE: Ora-1555

www.evdbt.com Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Sent: Monday, December 17, 2001 2:40 AM To: Multiple recipients of list ORACLE-L Hi list, Could anybody tell me on which site shall I find Tim Gorman's paper Cats, Dogs and ORA-1555 ?? Thanks, Samir

RE: Redo logs lost, old backups

? Which version of Oracle and OS? Do you have the trace of the control file ? Do you know the locations of ALL datafiles? Do you have the alert log in place? Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- (SEA) Sent: Monday, December 17, 2001 8:10 PM To: Multiple

RE: backup/recovery scenarios/data unloader question

will be superior to DUL (not sure about Oracle's ***official ** support status of the databases created using this converter) and will try to address the current limitations of DUL. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Sent: Monday, December 24, 2001 5:10 AM

RE: What's Oracle Trying to Hide ???

,ERRORSTACK. Triggering event 65535 is IMMEDIATE . Hope this helps. Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Sent: Wednesday, December 26, 2001 3:10 PM To: Multiple recipients of list ORACLE-L I generally share your speculation but in the case of dbms_system

RE: What's Oracle Trying to Hide ???

Not quite true. Wrapped packages take same space (in fact more in dictionary cache and same space in library cache). Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Sent: Friday, December 28, 2001 6:30 AM To: Multiple recipients of list ORACLE-L Earlier versions

RE: How to stop access to prod instance ...

This will only work for SQLPlus. Will not work for other programs. The ideal thing will be setting a default role none to all users and enabling roles thru the application . Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- Carmichael Sent: Friday, January 04, 2002 7:55

RE: Binding a process to a CPU .

://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists

Re: OEM Book Recommendation

Rahul ! I have not seen any **books** on OEM. But you can check in to OLN (!!) Oracle Learning Network and there are some classes on OEM. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

Re: How do I corrupt a block

, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http://personal.mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan

Re: arguments in ora-600

reserved for KGP; 17270 - 17299 reserved for KGI; 17300 - 17399 reserved for KGHX; 17500 - 17989 reserved for other KG*; 17990 - 17999 reserved for PL/SQL; = Have a nice day !! Best Regards, K Gopalakrishnan

Re: Question about many Oracle Data Files

not confuse you !! = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail - only $35 a year! http

Re: What is the logging column of the DBA_TABLES view used for?

and value not set by us Regards Rafiq = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo

Re: Current Osuser

SELECT USERNAME,OSUSER FROM V$SESSION = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail

Re: freelists Value Limitation - ORA-1590 on ver 7.3.4.5

101 16k 204 = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA. __ Do You Yahoo!? Get personalized email addresses from Yahoo! Mail http

RE: What the difference between qio and direct I/O option in VxFS

--- Hillman, Alex [EMAIL PROTECTED] wrote: How do you specify direct I/O option in /etc/vfstab? Use the forcedirectio mount option in the vfstab. = Have a nice day !! Best Regards, K Gopalakrishnan, Bangalore, INDIA

RE: Performance Tuning

Best Regards, K Gopalakrishnan (408) 934 9310 -Original Message- [EMAIL PROTECTED] Sent: Wednesday, January 30, 2002 2:25 AM To: Multiple recipients of list ORACLE-L Hi Everyone I am interested in purchasing some exceptionally good book on Oracle Performance Tuning. Can anyone

Anyone used 10810 to trace ORA-01555?

Have any one used the event 10810 to trace 'snapshot too old' errors. I would be interested in knowing the dumps/traces.. Best Regards, K Gopalakrishnan Bangalore, INDIA _ Do You Yahoo!? Get your free @yahoo.com address at http

RE: Anyone used 10810 to trace ORA-01555?

Please ignore the mail. I have got the trace files. Best Regards, K Gopalakrishnan -Original Message- Gopalakrishnan Sent: Friday, February 01, 2002 12:40 AM To: Multiple recipients of list ORACLE-L Have any one used the event 10810 to trace 'snapshot too old' errors. I would

RE: Oracle Tunning

. We have discussed this in a big way in this list (Me, Yong Huang, and few others). If you have time you can search those mails in the archives of the lists Let me see whether those mails are still with me. If I find them I will forward that to you. Best Regards, K Gopalakrishnan

RE: Oracle Tunning

have checked, and we have no free buffers within a minute of startup, but my buffer cache hit ratio is already better than 99%. A: The advice that free buffers should be available after a certain period is wrong prior to 8.1, and dubious for 8.1. Best Regards, K Gopalakrishnan

  1   2   3   >