UNIX Performance Issues

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

OT - using winsock.dll from within forms 6i

list, sorry for this OT , but our development team is looking for resources/links on the web providing examples of sending/recieving data using winsock from oralce forms.. i tried searching google, but could not find any code samples...!! regards Rahul -- Please see the official ORACLE-L FAQ

RE: RECOMPILE INVALID OBJECTS

--- > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be remov

RE: Unix account from PL/SQL ??

AQ: http://www.orafaq.com -- Author: Herman Susantio 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 fro

RE: Unix account from PL/SQL ??

AQ: http://www.orafaq.com -- Author: Herman Susantio 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 fro

RE: Import/Export table

er information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Mehendale INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet ac

RE: How to Identify System Tables?

TED] > 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: Rahul

RE: Constraint Enable/Disable

> Subject: Constraint Enable/Disable > > Hi, > Is there a way to disable all constraints, and then enable them all again? > Thanx > Sujatha > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Service

RE: How can I tell if a procedure/package is running?

i guess KGLHDLMD is lock Mode ? and KGLHDPMD = mode pinned ? > -- > From: Steve Adams[SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, October 30, 2001 3:51 PM > To: Rahul; Multiple recipients of list ORACLE-L > Subject: RE: How can I tell if a proce

RE: How can I tell if a procedure/package is running?

gt; (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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858)

RE: Loss of Redo Log file monitoring.

namaskar ! Mark, not sure ..but, u could check for the STATUS in v$log... or if one of the mirror has failed it would appear in alert.log -Rahul > -- > From: Mark Leith[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Friday, October 05,

RE: disable table lock ...cannot revert it

9:50 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: disable table lock ...cannot revert it > > Rahul, > Right, you can't drop or modify table after > alter table t disable table lock; > but > alter table t enable table lock; > still should work.

RE: proper db_file_multiblock_read_count

david, take a look at ixora.com.au, steve adam has few scripts on how to do this... it sets event 10046 to trace the event . Regards Rahul > -- > From: David Jones[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Thursday, October 04,

comma_to_table cannot convert a list of numbers ??

'1,2' the OUT parameter is and array of varchar2 ResultTab dbms_utility.uncl_array; in_str := '1,2'; dbms_utility.comma_to_table(in_str, strLen, ResultTab); * does not work ORA-00931: missing identifier what is the workaround ?? TIA Rahul -- Please

disable table lock ...cannot revert it

cause i disabled it already ! same case for dropping the table... i cannot drop it either..??? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 53

free bufer waits - solved

problems... CONCLUSION i am not able to figure out why ??? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet

unable to tune free buffer waits

ount(*) on ANOTHER table (right after importing 4 million rows) and all was ok - this table is heayly inserted into and i did the count(*) AFTER the insertion was finished. - alter system checkpoint takes 40 min. !! what's going on ?? TIA Rahul -- Please see the official ORA

free buffer waits ? but SGA is full of FREE buffers !!

') STATE, count(*) fromsys.x$bh group by state / regards =Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

FTS not reaching multiblock count value

have tried to re-analyze the table, validate structure etc... but i cannot get the db to reach 32 block in an FTS, as before TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX:

RE: Rash of shared memory errors

ty 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

RE: Rash of shared memory errors

the message BODY, include a line containing: UNSUB ORACLE-L > (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: Rahul I

could anyone please call this number ?

i'm trying to get in touch with one of my friend working in DC, all my attempts to contact him on his cell phone have failed ... 703-331-45116 would greatly appreciate if anyone could try this number and mail me later .. his name is Ashish Mathur regards Rahul -- Please see the off

RE: INDEXLEME ONEMLI

> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: system tablespace?

;ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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.oraf

RE: Users & Schema's

L PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 t

RE: MOVE Tables from One Tablespace to Another Tablespace !!

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

RE: is C compiler a must for oracle UNIX installations ?

-L > > > some of my friends are telling me that they have succesfuly installed > oracle > 7.3.1 on AIX 4 WITHOUT the C compiler present.. !! > > and i was the one telling them how oralce requires to relink the > executables > after > the installation. > > Regar

is C compiler a must for oracle UNIX installations ?

://www.orafaq.com -- Author: Rahul 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

RE: Dropping of user(Urgent)

PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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 t

RE: BEQ used for remote connections !!

ing 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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (8

BEQ used for remote connections

L FAQ: http://www.orafaq.com -- Author: Rahul 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

Re: Oracle Beta

What is it? I mean the URL to 9i Beta for Windows. No Sun of Mine (no test sun machine available right now..) -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Thursday, August 02, 2001 12:16 PM > Yes I am reply

NOARCHIVELOG, ONLINE redolog corrupted - solved

> > ABLE TO OPEN THE DB (with errors in alert log) switched the log, dropped > the corrupted one.. > > the _allow_reset parameter was the last resort... was their anything else > i could have tried ? > > regards > Rahul > > > > > > > > &

RE: severe lib cache contention - how did i solve it

To: Multiple recipients of list ORACLE-L > Subject: Re: severe lib cache contention - how did i solve it > > u did not have to do that the timed_statistics and sql_trace if set to > false > will do the job > > > > >From: Rahul <[EMAIL PROTECTED]> > &

severe lib cache contention - how did i solve it

list, i increased the kgl latches to 11 (from 3) and switched OFF the timed statistics and all the waits for lib cache and shared pool latch are gone !! thanks for pointing me to the timed statistic bug.. (i dont know how much the kgl parameter helped though) regards Rahul -- Please

RE: how do i explain this ?

> my question is... how 7.3.2 was able to handle this ?? how i explain > this > to > > my management ? > > i was able to convince then on porting to 8i to get better perfornace !! > > > > note: i cannot change the app. all changes must be from the back end. > > > &

RE: how do i explain this ?

Re: how do i explain this ? > > > Hi, > > > If there are the same querries with different literals, try cursor_sharing > = force > > jack > > > > > Rahul > > list ORACLE-L <[EMAIL PROTECTED]>

how do i explain this ?

es must be from the back end. TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

severe lib cache contention !!

estingly, the same app was NOT showing any contention on these latches in 7.3.2 !! how can i solve this problem ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858)

4 drives, 2 controller ( 3 drives on the SAME controller !)

are sharing the same IO channel , right ? what kind of effort is required to ammend the above config ? ( TWO drives on ONE controller ) Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858

waits on sequential scans - how did i solve it

; From: Jack C. Applewhite[SMTP:[EMAIL PROTECTED]] > Reply To: [EMAIL PROTECTED] > Sent: Tuesday, July 17, 2001 8:25 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: how to improve sequential scans ? > > Rahul, > > Could this table be

RE: how to improve sequential scans ?

L > Subject: RE: how to improve sequential scans ? > > Rahul, > > Could this table be partitioned and the partitions spread across multiple > disks? Could the index be partitioned as well? The concept here is, of > course, "divide and conquer". > >

raw on AIX, illegal file type !!!!

ate a tablespace SQL> create tablespace temp_tbs datafile '/dev/oraraw' size 10m; ERROR at line 1: ORA-01119: error in creating database file '/dev/oraraw' ORA-07420: sfccf: Illegal file type. what am i doing wrong ? TIA Rahul -- Please see the official ORACLE-

raw on AIX - solved

list, AIX creates the same raw device with a "r" prefixed...and we have to use that name NOT the one we named..!!! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858

how to improve sequential scans ?

e sessiion is the TABLE from which all the sid's are reading the table is analyzed and the sql's issued use the index. how can i further tune this config. ? TIA Rahul PS: my next step is to put the files on raw disks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.c

8.1.6.1 on redhat, startup nomount hangs, alert.log shows NO ERRO

NSE_SESSIONS_WARNING = 0 LICENSE_MAX_USERS = 60 Starting up ORACLE RDBMS Version: 8.1.5.0.0. System parameters with non-default values: db_name=DEVP max_dump_file_size = 10240 .. that's it !! NO ERRORS !!! what to do ? TIA Rahul -- Please see the official ORACLE-L F

RE: can i place online redologs with oracle engine ?

. > -- > From: [EMAIL PROTECTED][SMTP:[EMAIL PROTECTED]] > Sent: Thursday, July 05, 2001 7:54 PM > To: Rahul; Multiple recipients of list ORACLE-L > Subject: Re:can i place online redologs with oracle engine ? > > Rahul, > > You can p

can i place online redologs with oracle engine ?

> list, > i cannot spare a separate drive for the redologs, > can i place the online logs with the same drive as > the solaris + oracle engine ? > (m,y solaris and oralce are also on the same drive) > > TIA > > Rahul > > > > -- Ple

RE: Standby database

BODY, include a line containing: UNSUB ORACLE-L > (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: Ra

11 disks to build a DB, suggestions

D5 -> RBS01 + USER_TEMP + INDEX01 D6 -> RBS-2 + INDEX02 + TEMP_TABLES D7 -> solaris system + oracle engine. would really appreciate if someone could review this config , and suggest improvements. Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com --

ok to alter SYS tables/cluster (obj$/C_OBJ#) for buffer_pool KEEP

List, any known restrictions in doing an "alter table obj$ storage(buffer_pool keep)" ? or, would it be better to keep the entire C_OBJ# cluster in KEEP pool ? Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED]

RE: Latchs

gt; To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send t

RE: How to size db_block_size?

nd an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information

RE:

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: Rahul INET: [EMAIL PROTECTED] Fat City Net

Flush shared poo;

Discussion > Subject: Re: Flush shared poo; > > Same here Salman ! > > Any ideas Rahul > > Ankur Shah > Oracle DBA > DHR-GA > - Original Message - > From: <[EMAIL PROTECTED]> > To: "LazyDBA.com Discussion" <[EMAIL PROTECTED]> &

Re: OT SPAM : Become an Oracle Certified DBA in 5 Weeks

I got it too. It was directly e-mailed to me. If all members got this then it means that our e-mail addersses are leaked out. -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, June 13, 2001 11:36 AM > On Wed

RE: rowcount and rowsize..

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

advance backup & recover (RMAN?)

> List, > one of our clients insists to isntall the "advance backup and recover > option" of > oralce... (8.1.6) (it's written on the back of the CD, "CD includes > advance backup and recovery") > > are they talking about the RMAN ? or something e

advance backup & recover (RMAN?)

List, one of our clients insists to isntall the "advance backup and recover option" of oralce... (8.1.6) (it's written on the back of the CD, "CD includes advance backup and recovery") are they talking about the RMAN ? or something else ? Regards rahul -- Please

solaris - no utmpx entry !

T log into any OTHER account also... * have tried switching off /on the server... did not work.. Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 S

Re: How to re-arrange the nullable columns

If its for application developers ease in INSERT etc. then how about creating a view which has columns in proper order? -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 8:45 AM > Hi DBA's,

Re: ORA-12545

One possibility caould be database going down while you are connected. We experienced similar thru perl couple of times coupled with ORA 3113 -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, June 12, 2001 5:35

RE: Quer

containing: UNSUB ORACLE-L > (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: Rahul

RE: Enforced Costraints ??

ecked for uniqueness, the constraint > will be "enforced" for the upcoming data only... > > Regards > Rahul > > > > > ------ > > > From: Anshumn[SMTP:[EMAIL PROTECTED]] > > > Sent: Tuesday, June 12, 2001 12:30 PM > > > To:

FW: Enforced Costraints ??

orced" for the upcoming data only... Regards Rahul > > -- > > From: Anshumn[SMTP:[EMAIL PROTECTED]] > > Sent: Tuesday, June 12, 2001 12:30 PM > > To: Rahul > > Subject: Re: Enforced Costraints ?? > > > > Hi Rahul, &g

RE: Enforced Costraints ??

but if the tables already contains dup records, how can u make a unique constraint ? (even with "enable novalidate") > -- > From: Anshumn[SMTP:[EMAIL PROTECTED]] > Sent: Tuesday, June 12, 2001 12:30 PM > To: Rahul > Subject: Re: Enfor

RE: Enforced Costraints ??

Anshuman, whenever u add a constraint to a table, oracle will make sure all the data (if any) confirms to the constraint added you can enable or disable a constraint (even defer)... dont confuse urself with the term "enforcing a constraint". Regards Rahul >

RE: Dr. Watson -sql*plus

move (upgrade) to unix :) a few things come to mind. make sure u have the latest patch set (SP6?) for ur server.. you could also try installing and connecting from plus33.exe .. HTH Rahul > -- > From: Suresh Verma[SMTP:[EMAIL PROTECTED]] > Sent: Tuesday

RE: set feedback off in procedure

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

RE: find allocated and used space for a table

g list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other inform

RE: find allocated and used space for a table

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: Rahul INET: [EMAIL PROTECTED] Fat City Network Servic

RE: How to drop a system event trigger - endless loop?

- > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of m

RE: Last Login

readmail.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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services

RE: How to add Composite Primary Key in a Table

//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: Rahul INET: [EMAIL PROTECTED] Fat City

RE: Need a Help

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

RE: ORA-01950: no privileges on tablespace 'DATA2_CPTF'

l 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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services--

RE: how much ram per oracle process?

e to these > terms:http://www.lazydba.com/legal.html > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mai

OEM Book Recommendation

DBAs, As a keyboard lover, hate to do this. But I need to study OEM. Any good Books / URLs / DOCs / PDFs Thanks in advance, -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538

RE: archive redo logs on NT

.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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services--

sqlplus cannot connect to PO 803 - more infp

t lever 16 !) and found errors reported how to interpret this trace... Regards Rahul ---+++++---+++++ nttcni: trying to connect to socket 5. ntt2err: entry -- ntt2err: soc 5 error - operation=1, ntresnt[0]=505, ntresnt[1]=60, ntresnt[2]=0 ntt2err: exit nt

RE: 16 bit sqlplus cannot connect to PO8i

SqlNet, you > > can't connect to an 8i database with it. > > > > Some version numbers here would help. > > > > platform: > > version of platform: > > version of Oracle: > > etc... > > > > Jraed > > > > On Monday 28 May 20

16 bit sqlplus cannot connect to PO8i

win95 and PO805 TIA Regards Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access

RE: Steve Adam's Removal

explanation/answer, this show the respect posters have for his knowledge or Oracle. please reconsider Regards Rahul > -- > From: Suhen Pather[SMTP:[EMAIL PROTECTED]] > Sent: Friday, May 25, 2001 6:36 AM > To: LazyDBA.com Discussion > Subject: RE: Steve

Re: What is the cost of replication?

to it and can administer it much better. Beware if you are novice... -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Wednesday, May 16, 2001 12:20 PM > We have a small but critical application running on NT.

Re: strange problem

Hey Kirti! Congrats on your accomplishment of Tuning book. Must have been a gratifying experience. Keep the good work up! -Rahul Dandekar -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Network Services-- (858

Re: Installing Multiple Oracle Clients

. Create home dir and get .profile etc and set environment 2. Remote mount CD 3. Install Client with .rsp 4. Scripted FTP : tnsnames.ora 5. Test connection All through a sequence of commands. No mouse clicking. Now going to machine. No taking out putting in CDs... -Rahul -- Please see the of

RE: looking job

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: Rahul INET: [EMAIL PROTECTED] Fat City

Re: RMAN doubts

What is your problem? I use 816. There is problem with sbttest in 816. But backups and recovery work fine. You need to relink the libobk.so file. I you provide details, I would try to answer. -Rahul - Original Message - To: "Multiple recipients of list ORACLE-L" <[EM

Re: RMAN doubts

-0' all; } 2. run { allocate channel ch1 type 'SBT_TAPE'; backup archivelog all; } I am not sure. Just want to make sure. -Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul Dandekar INET: [EMAIL PROTECTED] Fat City Ne

Re: RMAN doubts

aintain it internally 3. I understand that with RMAN, even if database is in NOARCHIVELOG mode still it would allow incremental backups which would mean saving of time. -Rahul - Original Message - To: "LazyDBA mailing list" <[EMAIL PROTECTED]> Sent: Wednesday, April 11, 2001

Re: RMAN doubts

allocate channel ch1 type 'SBT_TAPE'; backup archivelog all delete input; } Still more to come... TIA, -Rahul P.S. I have passed OCP 8 Backup and Recovery exam with score of 58/60. That's why probably I am having so many doubts. Was better ithout OCP

RMAN doubts

#x27;; backup archivelog all delete input; } Still more to come... TIA, -Rahul P.S. I have passed OCP 8 Backup and Recovery exam with score of 58/60. That's why probably I am having so many doubts. Was better ithout OCP ;-( -- Please see the of

RE: Recover from noarchive database ?

t 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: Rahul INET: [EMAIL PROTECTED] Fat City Network Services

space allocated vs occupied - procedure

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

RE: URGENT !!! ORA 604

om/odbareadmail.pl > Tell yer mates about http://www.farAwayJobs.com > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Inter

TZ in AIX

://www.orafaq.com -- Author: Rahul 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

v$sql.rows_processed

List, is rows_processed a good indicator is the number of rows actually processed by a statement ? i'm running an insert, and want to know how many rows the statement has inserted already Regards -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul

RE: identify which logs are need to start recovery

s the log sequence number to apply !! from where does it get the log sequence number ? is it sotred in each datafile ? or oralce queries it from v$log_history ? Rahul > -- > From: Koivu, Lisa[SMTP:[EMAIL PROTECTED]] > Sent: Thursday, March 29, 2001 12:02 PM &

identify which logs are need to start recovery

usually i keep 2-3 previous archived logs, after switching and starting the hotbackup... but is there a v$ view to show which logs are needed to start the recovery ? TIA Rahul -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rahul INET: [EMAIL PROTECTED] Fat City

RE: Re:RE: very urgent

AwayJobs.com > > > > > Think you know someone who can answer the above question? Forward it to > them! > 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.

<    1   2   3   >