Instructions for transparent gateway..

Title: RE: Question related to security could someone please help me find instructions for installing and configuring 9.2 oracle transparent gateway on win2k for sql server?? appreciate it.Sunil Nookala Dell Corp.

RE: Number of joins in the query

If you are joining 'n' number of tables, you should have a minimum of 'n-1' joining conditions, otherwise it might result in cartesian product. Sunil Nookala Dell Corp. -Original Message- Sent: Thursday, February 27, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Two! PK on

Oracle version??

List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the

RE: Snapshot Too Old Error on Export !!!

Stephen, My understanding is having consistent=y uses no rollback, since the changes occurring during the export are not being captured in the export dump. on few occasions i've still got the spurious ora-1555(snap shot too old)error on exporting a 80GB highly transactional database which

RE: Count(*) last 30 seconds

Interestingly enough, I haven't seen an official statement on count(*) being slower than count(column name). Sunil Nookala DBA Dell Corp. -Original Message- Sent: Tuesday, February 11, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Hi, 1. create unique index or

RE: Slow SQL*Plus connect.

How big is the listener log file?? do you truncate/rename it on regular basis?? just a thought. Sunil Nookala Dell Corp. -Original Message- Sent: Wednesday, January 22, 2003 4:09 AM To: Multiple recipients of list ORACLE-L Hi All, We have experienced a *very* slow connect time to a

RE: When will Oracle 10i be out?

The day we all finish upgrading our databases to 9i. Sunil Nookala DBA Dell Corp. -Original Message- Sent: Thursday, November 07, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Has anyone heard when Oracle will be releasing version 10i? -- Please see the official ORACLE-L

RE: off topic: OCP exam registration

Try promotion code OPP to get 30% off. Sunil Nookala Dell Computer corp. Austin, TX -Original Message- Sent: Thursday, September 05, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Hi ALL! I just spoke with Prometric and they told me if I give them my OTN number they will give

RE: Nologging and redo generation

SQL loader(direct load),direct inserts, and create table as select...will not generate redo/undo by using NOLOGGING. Your Transaction is logged while deleting rows, can't be blocked. correct me if I am wrong. Sunil Nookala Database Analyst Dell Corp Austin, TX -Original Message-

RE: When was a tablespace created?

try this: select a.file_name, a.tablespace_name, b.creation_time from dba_data_files a, v$datafile b where a.file_name = b.name should give the time for the first file added to the tablespace, translates to the tablespace creation time. someone might have a better idea, I guess. Sunil Nookala

RE: RE: RE: Rant

what about self destruction?? Sunil -Original Message- From: ltiu [mailto:[EMAIL PROTECTED]] Sent: Monday, July 22, 2002 6:02 PM To: Multiple recipients of list ORACLE-L Subject: Re:RE: RE: Rant IBM's latest DB2 claims to do this. Self monitoring, self healing. ltiu

OTN discount code.

List, someone pl.. tell me the new OTN discount code for OCP exam?? she is such a pig_headed, insists on the code...damn.. Thanks, Sunil Nookala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051

RE: SHARED POOL SIZE

No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL / NAME

RE: SHARED POOL SIZE

Title: RE: SHARED POOL SIZE sorry I goofed...I meant.. yes, it could be changed. -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SHARED POOL SIZE

RE: SPACE FREE HOW?

ALTER TABLE table DEALLOCATE UNUSED KEEP integer; the keep clause is optional. -sunil -Original Message- Sent: Thursday, January 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database

RE: sniped sessions

appreciate you help guys.. -Original Message- Sent: Tuesday, January 15, 2002 9:06 AM To: Multiple recipients of list ORACLE-L Attached are the scripts we use to kill sniped sessions. This is part of a series of monitoring scripts we developed for our Oracle databases. The scripts

sniped sessions

Dear List, I have init.ora resource_limit = true, and idle_time set in profile. When idle_time exceeds, the session status becomes 'sniped' in v$session and never gets cleaned up. I manually kill these threads using orakill utility. I appreciate, if someone can help me with a script to clean

RE: Message at the start of svrmgrl

Hello all, could someone please tell me why the procedure below(Author:Nick Butcher) takes less than a minuteona table with 50,000 rows and about 21 mins on a table with 235,000 rows?? Ihave created a bigger rollback segment to take care of this, but no improvement.where should i be

Recall: Message at the start of svrmgrl

Nookala, Sunil would like to recall the message, Message at the start of svrmgrl. -- 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

deleting duplicate records

Hello all, could someone please tell me why the procedure below(Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 21 mins on a table with 235,000 rows?? i have created a bigger rollback segment to take care of this, but no improvement.where should i be

oem job fails..

Hi Guys, While running a job(with lot of updates)in oem i get this error: ORA-00054: resource busy and acquire with NOWAIT specified. data base is 8.1.7 on NT. please help me how to fix it. Sunil Nookala Dell Corp. Austin, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

RE: oem job fails..solved

I found out the session which kept the table locked. killed it, jobs run fine now. thanks for help. Sunil Nookala -Original Message- Sent: Tuesday, October 02, 2001 12:37 PM To: Multiple recipients of list ORACLE-L that's not an oem problem per se... but is related to the fact that you

RE: Tricky Hierarchical Query

Hi, I've been through with that lately, modify this to see how it helps. SELECT LPAD(' ',5*(LEVEL-1)) ||name||' empno:'||emp_no ||' '||'works for:'||functional_mgr_name FROM HRTABLE where functional_mgr_badge =emp_no START WITH emp_no= emp_no CONNECT BY PRIOR emp_no =

RE: Locally managed tablespaces

The size of extents that are managed locally are determined by the system. The LOCAL clause of the extent management specifies this menthod in create statement. Sunil Nookala Dell Computer Corp. Austin, TX -Original Message- Sent: Thursday, July 19, 2001 11:43 AM To: Multiple recipients

RE: How do I corrupt a block

talk to your lead duhveloper..they are usally good at that ;-) Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Thursday, May 31, 2001 5:06 PM To: Multiple recipients of list ORACLE-L unfortunately i am on NT I can not use BBED because i don't know the password is there any

RE: how to find out internal's password???

try this(on your dev box first): 1.select instance_name from v$instance; @command line, 2.oradim80 -delete -sid instance name 3.oradim80 -new -sid (instance name -intpwd newpassword now you have a new password for internal. Sunil Nookala Dell Corporation, Austin, TX -Original Message-

RE: job offer from SAUDI ARABIA

Ican answer your question# 2 It would be very wise for your wife to cover her head and you.. your butt!! think twice before you make a move. Sunil Nookala -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 16, 2001

RE: How can I cut off a query after 3 lines?

where rownum 4 Sunil Nookala Dell corp Austin, TX -Original Message- Sent: Friday, May 04, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Q: how can you specify with a select statement how many rows are given as a result? I would only like to get the first three lines.

RE: Column name

the only concern is column ambiguity. Precede the field with the table name when you're joining tables. Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Friday, April 27, 2001 5:00 AM To: Multiple recipients of list ORACLE-L Can I use the same column name in the same

RE: Temorary tablespace problem

could be concurrent multiple sort operations... -Original Message- Sent: Wednesday, April 25, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Hi Today I have seen thats the Temporary tablespace growth in my database is high.What could be reasons? Thanks -Seema