Re: Changing Internal password
hi chinna.. use this -- alter user sys identified by urnewpasswd; was that not rocket science :) .. kidding .. late night humor Deepak --- Chinna Reddy Kunta [EMAIL PROTECTED] wrote: Dear Gurus... Please can u suggest detail procedure of how to change the internal password ..os : Windows NT i tried to do with ORADIM utility..but i could not do it successfullylooking forward for the answer as soon as possible... Regards Chinna - Yahoo! Autos - everything you wanted to know about cars and bikes __ Do You Yahoo!? LAUNCH - Your Yahoo! Music Experience http://launch.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Configuration Question
Hi Pat, to cut to the chase here is how we do it in our shop .. we have : 1. East Coast: we have bunch of DB's 1 tape server 2. West Coast: we have bunch of DB's 1 tape server Rman Strategy: We have two catalogs, one which caters to all db's on east coast and backs ups db's on east coast tape server. The other catalog caters to backups for all db's on west coast and backs up to west coast tape server Catalog backup (next step) -- East coast catalog db is registered in west coast catalog and is backed up daily. So in case the east coast catalog Database goes down, we can use the west coast catalog to restore it!! And viceversa for west coast which is registered to the east coast Note: keeping the catalog on differnt independent hardware prevents single point of failure of prod and catalog Dev Databases: We dont care and just use exp/imp hth Deepak --- Pat Howe [EMAIL PROTECTED] wrote: I have just completed Oracle Education's Enterprise DBA Part 1B: Backup and Recover course. Page 11-5 states : It is recommended that you have a separate catalog for each database. My question is : Why? Does this help you cleanup the RMAN catalog if you ever drop a database (you can drop the schema owner)? Is this how others have configured their RMAN database ? Thus I am seeing 2 Configuration Models ; Have one schema owner per database that you are backing up. If you had two databases PROD and DEV then setup a RMAN-PROD and an RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace to manage each database's recovery info. VERSES Have one schema owner (catalog) for all the databases that you are backing up. If you had two databases PROD and DEV then setup one schema owner RMAN (one RMAN Catalog) in the RMAN tablespace to manage all database recovery info. What are the pro's and con's? Thanks in Advance _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: O9i Predefined Roles
yes --- Orr, Steve [EMAIL PROTECTED] wrote: Are the CONNECT, RESOURCE, and DBA roles still predefined roles in O9i like they are in O8i? Steve Orr Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN question
message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Creating a missing datafile
Hi Ross, have u by any chance restored a backupcontrol file that was backedup before you added this datafile. Is this the case? If yes than what oracle is doing is putting a placeholder entry for this file and calling it missing file.. here is what u can do (assumes that you have all the archivelogs available since this file was created .. restore the db from backup and mount it .. SQL select name from v$datafile where file#=41; SQL ALTER DATABASE CREATE DATAFILE 'use the out of above sql' as '/u2/db/archive2_2.dbf'; SQL recover database using backup controlfile ; Use Auto till it asks for non-existent arch (supply ur online log) Media recovery complete after online log is applied technically u should be able to open the db in noresetlogs mode at this time .. however i have seen that it does not .. so here is the workaround .. SQL alter database backup controlfile to trace; SQL create controlf file .. from ur trace SQL recover database; -- takes one sec to complete SQL Alter database open; hth Deepak --- Ross Collado [EMAIL PROTECTED] wrote: Env. HP-UX 10.2 Oracle 7.1.6 Archivelog mode Found this in the alert.log Dictionary check beginning File #41 found in data dictionary but not in controlfile. Creating OFFLINE file 'MISSING0041' in the controlfile. Dictionary check complete I did a dump of the controlfile to trace and checked. It had MISSING0041 in it. However, I did a find on this file and couldn't find it. Does this mean MISSING0041 was just updated in the controlfile and was not actually created as a physical file? I know the complete path/filename of what this MISSING0041 datafile should be (it should be /u2/db/archive2_2.dbf). This is actually the 3rd datafile of ARCHIVE tablespace. If this file existed then it would have been an easy rename of datafile via ALTER TABLESPACE ... RENAME DATAFILE But there is no physical file to rename. I don't think I can do a create a file via ALTER DATABASE CREATE DATAFILE... in this case because the controlfile won't have the correct path/filename of this datafile (it's got 'MISSING0041' SIZE 500M). How do I go about recreating a physical file having the correct filename and size? TIA, Ross -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ross Collado INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE Valentine eCards with Yahoo! Greetings! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: compressing rman backups thru pipes
Hi ruth how about you restricting the size by either maxpiecesize channel spec or by playing with correct combo of filesperset and maxopenfiles. would that work for you so that you have larger # of fixed/small sized backupsets .. Deepak as for pipes , the only thing that comes to my mind is that peter pan fellow :) --- Ruth Gramolini [EMAIL PROTECTED] wrote: Hi all, Does anyone know if you can do rman backups throught pipes and compress them the way you can with an export? Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backup and Recovery
nope .. this should just work fine:) --- Randy Kirkpatrick [EMAIL PROTECTED] wrote: Listmembers, Are there any gotchas with restoring just one datafile from a hot backup and applying the archive logs? Will applying the archive logs only affect the restored datafile? For instance, if I have a hot backup from Monday and all the archive logs to the current date and a disk crashes which contains the datafile, can I restore just the datafile and apply all the archive logs from Monday forward? Are changes only applied to the restored datafile? Randy Kirkpatrick home: (303) 772-7467 cell:(303) 885-2102 __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hot Backup to Tape
whats imp is that you have the oracle binaries re-linked so that rman can communicate with the mml.. as for talking backups to tape use the sbt_tape in the allocate channel and u should fine Deepak --- Sinard Xing [EMAIL PROTECTED] wrote: What tape DDS3 or DLT -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Quamrul Polash Sent: 04 February 2002 00:30 To: Multiple recipients of list ORACLE-L Subject: Hot Backup to Tape Hi, I need a script for on-line backup to tape. My server is Oracle 8.1.7 on Unix (AIX). Thanks for any tips, /Quamrul -- Get your FREE download of MSN Explorer at http://explorer.msn.com. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Quamrul Polash INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Dumb question
hi sreeni, no diff between export imp uisng rac or normal non-rac configuration ... Deepak --- Shreeni [EMAIL PROTECTED] wrote: Hi List, To ask a dumb question, is there any special way to run exp/imp on Oracle Parallel server on Solaris ?? Is parallel server DBA different than a regular DBA ?? :) TIA Shreeni Shreenivasa Rao e-Zing Technologies, Inc.. 41-43 Beekman Street, 3rd Floor New York, NY 10038. Tel: (212)233-9861 xt.241 Fax: (212)233-9862 Cell:(917)861-4966 mailto:[EMAIL PROTECTED] [EMAIL PROTECTED] *** **Your IT Solutions Provider *** *** http://www.e-zingtech.com/ http://www.e-zingtech.com *** Under Bill s.1618 Title III passed by the 105th U.S. Congress this mail can not be considered spam as long as we include contact information and a remove link for removal from our mailing list. To be removed from our mailing list reply with remove in the subject heading and your email address in the body. Include complete address and/or domain to be removed. BEGIN:VCARD VERSION:2.1 N:Kodikal Bhaskar Rao;Shreenivasa;R FN:Shreenivasa Rao NICKNAME:Seena ORG:e-Zing Technologies Inc TITLE:Oracle DBA TEL;WORK;VOICE:(212) 233-9861 TEL;HOME;VOICE:(732) 326-1899 TEL;CELL;VOICE:732-670-7066 TEL;WORK;FAX:(212) 233-9862 ADR;WORK:;;41-43, Beekman Street;NY;NY;10010;United States of America LABEL;WORK;ENCODING=QUOTED-PRINTABLE:41-43, Beekman Street=0D=0ANY, NY 10010=0D=0AUnited States of America ADR;HOME:;;741, Cheryl Dr;Iselin;NJ;08830-3110;USA LABEL;HOME;ENCODING=QUOTED-PRINTABLE:741, Cheryl Dr=0D=0AIselin, NJ 08830-3110=0D=0AUSA X-WAB-GENDER:2 URL;HOME:http://www.sritri.com URL;WORK:http://www.e-zingtech.com BDAY:19630202 EMAIL;PREF;INTERNET:[EMAIL PROTECTED] EMAIL;INTERNET:[EMAIL PROTECTED] REV:20011230T034250Z END:VCARD __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sending email from Unix
unix2dos file1| uuencode file1 | mailx -s 'file1' [EMAIL PROTECTED] hth Deepak --- [EMAIL PROTECTED] wrote: Geesh... Your Q made me nostalgic. Reminded me of the days when I used to uuencode files and mail them over. Have a look a uuencode, and mailx. Raj Kempf, Reed rkempf@rightTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] now.com cc: Sent by: Subject: RE: Sending email from Unix root@fatcity. com February 01, 2002 02:26 PM Please respond to ORACLE-L use PINE, that is the best and easiest email program on UNIX (IMHO). Easy to send attachments :) HTH ReedK -Original Message- From: Sona [mailto:[EMAIL PROTECTED]] Sent: Friday, February 01, 2002 12:07 PM To: Multiple recipients of list ORACLE-L Subject: Sending email from Unix Hi I want to send an email from Unix with an attachment .does anyone know how to do this? TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle DBAs Needed in Boston
: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Great stuff seeking new owners in Yahoo! Auctions! http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Backup/Recovery questions ...
Fred, one of the easier ways is this: 1. on ur prod take a control file backup to trace 2. copy the trace to server b and edit the path/drives 3. copy init file from prod to server b 4. set the env vars in server b and startup nomount 5. create the control file using edited trace on B 6. restore database {rman} 7. recover database {rman} 8. open resetlogs alternate method: all steps are similar except 1,2,5 instead u can restore controlfile (rman backup) and then manualkly rename the file before u mount and restore your database. let me know if this still does not answer your q Thx Deepak --- Fred Smith [EMAIL PROTECTED] wrote: List, I am attempting to verify the validity/integrity of a full cold backup I did off of my production server. I backed up the datafiles,logfiles, controlfiles. The production server (server A) is much larger with dozens of drives. I now wish to apply this backup to another server (server B). Server B does not have the same drive configurations as server A. Based on this I'm assuming that my controlfiles from Server A are useless. How can I bring this database up on server B now? There are over 100 datafiles. OS: SunOS 5.6 Oracle8 Enterprise Edition Release 8.0.4.4.0 - Production Thank you, -Fred S. _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Fred Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: used segment space in bytes
Thanks for the response Diego. I will try running this on my system. Rgds Deepak --- Diego Cutrone [EMAIL PROTECTED] wrote: Deepak: As a matter of fact I think you can find how many blocks below HWM are unused (have no rows at all), by counting the number of blocks that are below the HWM and hold at least one row. (check my previous mail) SELECT COUNT(DISTINCT SUBSTR(rowid,15,4)||SUBSTR(rowid,1,8)) FROM TABLE; This query will count how many blocks have data (and of course) are below HWM. I know this is not a perfect calclulation, because it can report 10 blocks used and these blocks could only have 1 row each, but it's better than the HWM value or than the dbms_space.free_blocks, I think. Please correct me if I'm wrong... Greetings DC - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, January 17, 2002 9:05 PM Hi Do, Here is the breakup for a space usage for a segment: 1. Allocated size (use dba_segments) 2 Used Blocks in segments(use dba_tables.blocks) -- Truly Used ( ??) -- Free Blocks (??) 3. Unused Blocks (use dba_tables.empty_blocks) the caveat i guess is in step 2. The used block number is based on the high watermark. which means that the number you will get for point 2. above will also include space that contains no rows becuz its below the high water mark. Afaik, there is'nt a way to find these free blocks below the high water mark.. unless you re-build table and then get the value from dba_tables.blocks .. feel free to correct me .. Deepak -Original Message- Sent: Thursday, January 17, 2002 12:12 PM To: Multiple recipients of list ORACLE-L hi guys! what would be the easiest way to compute the space in bytes used by a segment? it is rather easy to determine the # of used blocks by a specific segment by looking at the dba_extents for example. but how many blocks have been really used in one of those extents. i guess i would be able to compute the free blocks by using the dbms_space package but it just seems to complicated. any hints ... ? thank you -do __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Diego Cutrone INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: used segment space in bytes
Hi Do, Here is the breakup for a space usage for a segment: 1. Allocated size (use dba_segments) 2 Used Blocks in segments(use dba_tables.blocks) -- Truly Used ( ??) -- Free Blocks (??) 3. Unused Blocks (use dba_tables.empty_blocks) the caveat i guess is in step 2. The used block number is based on the high watermark. which means that the number you will get for point 2. above will also include space that contains no rows becuz its below the high water mark. Afaik, there is'nt a way to find these free blocks below the high water mark.. unless you re-build table and then get the value from dba_tables.blocks .. feel free to correct me .. Deepak -Original Message- Sent: Thursday, January 17, 2002 12:12 PM To: Multiple recipients of list ORACLE-L hi guys! what would be the easiest way to compute the space in bytes used by a segment? it is rather easy to determine the # of used blocks by a specific segment by looking at the dba_extents for example. but how many blocks have been really used in one of those extents. i guess i would be able to compute the free blocks by using the dbms_space package but it just seems to complicated. any hints ... ? thank you -do __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: The OCP bar is being raised
to make money!) The problem is not that they are trying to make money, but that this is becoming something you HAVE to do/have to get a job working with Oracle. And they haven't convinced me of the value of that piece of paper. I know way too many certified DBAs who I wouldn't trust to even query my databases. Rachel --- orantdba [EMAIL PROTECTED] wrote: Hmmm, Imagine that, a publicly traded company that it trying to make money, I am shocked dismayed, I don't believe I will be able to sleep tonight. Chris, could you provide me with the list of companies that are not trying to make money? I want to make sure that I don't go to work for them, or learn their products. John :-) [EMAIL PROTECTED] wrote: I'd say the cost is being raised. Look at the requirements for each. You can't just take the OCM exam. No we would first have to get the OCA. Whether or not we need the entry level cert we have to have it. Then, and only then, can we take the OCP. Then and only then, can we take the OCM and that is after we take these REQUIRED classes from Oracle Ed. So someone the caliber of Steve Adams or Jared Still, has to spend money in a class that they could probably teach from memory before they can get certification and that is after getting 2 other certs that have no value to them. Call me a cynic, but to me, this is nothing but a money grab. From the website: --To become an Oracle Associate, you must pass the exams required -- for the Oracle Associate level of your selected job role. Typically, --two exams are required; the first one can be taken via the Internet, --while subsequent exams must be taken in a proctored environment. By --completing your Oracle Associate, you are half-way toward achieving the -- Oracle Certified Professional credential. --To become an Oracle Certified Professional, you must pass all required exams --in your selected job role, including those at the Associate level. --To become an Oracle Certified Master, you must first be an Oracle --Certified Professional. Additionally, achieving your OCM credential --requires attending two advanced level Oracle University courses from --the list shown on this page as well as passing the OCM Practicum exam. --Chris -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED] ] Sent: Thursday, January 10, 2002 9:16 AM To: Multiple recipients of list ORACLE-L Subject: The OCP bar is being raised Anyone care to comment on the following, IMHO it's about time: --- Introducing two new levels of Oracle Certified Professional (OCP) Achievement A recent *IDC report on IT Education and Training Services quoted === message truncated === __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Send FREE video emails in Yahoo! Mail! http://promo.yahoo.com/videomail/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: x$ksmpp table question
george, try using pmap pid hth deepak --- George Schlossnagle [EMAIL PROTECTED] wrote: I want access to the fll heap structure though. My process pga is huge, I want to see what the allocations are. George - Original Message - From: Khedr, Waleed To: Multiple recipients of list ORACLE-L Sent: Thursday, December 27, 2001 2:20 PM Subject: RE: x$ksmpp table question George, You can get the PGA information you're looking for from v$sesstat Query v$statname: select * from v$statname where name like '%pga%' get the statistic# and query v$sesstat for that session. Waleed -Original Message- From: George Schlossnagle [mailto:[EMAIL PROTECTED]] Sent: Thursday, December 27, 2001 2:00 PM To: Multiple recipients of list ORACLE-L Subject: x$ksmpp table question I have a question about the x$ksmpp table. Supposedly (according to Steve Adams' internals book) is the reference table for the heap allocation for a processes pga. I assume this means for a processes own pga. If so, is it possible (and if so how) to access the same data for an arbitrary shadow process (in particular, not the one associated with the ssession running the query). Thanks, George --- http://www.pythian.com -- [EMAIL PROTECTED] -- 877-PYTHIAN Smarter than adding another team member, Pythian has new services for supplementing DBAs: get our help with monitoring, 24x7 on-call, daily verifications, storage management, performance and more. __ Do You Yahoo!? Send your FREE holiday greetings online! http://greetings.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: unused blocks BELOW HWM
no there is not .. unless someone corrects me that is ;) Deepak --- Gene Gurevich [EMAIL PROTECTED] wrote: Hi all: Is there a way for me to see how many blocks under the HWM are unused? thanks Gene = __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unused blocks BELOW HWM
are u saying try it or are you saying that you can find this info using dbms_space;) Thx Deepak --- Sairlao, Chark [EMAIL PROTECTED] wrote: try dbms_space Thanks And Regards Chark Sairlao -Original Message- Sent: Tuesday, 18 December 2001 9:40 To: Multiple recipients of list ORACLE-L no there is not .. unless someone corrects me that is ;) Deepak --- Gene Gurevich [EMAIL PROTECTED] wrote: Hi all: Is there a way for me to see how many blocks under the HWM are unused? thanks Gene = __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sairlao, Chark INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: unused blocks BELOW HWM
i would agree with suhen 100% on this .. as it pretty much covers everything on this .. Deepak --- Suhen Pather [EMAIL PROTECTED] wrote: Gene, I do not think you can do this with dbms_space. The way I normally try to locate if the HWM of a table is too high is: - analyze each table - use avg_row_len and num_rows columns from user_tables to calculate the Used Space (you can also put pctfree and pctused into this equation). - compare the Used Space to the HWM (allocated space - empty blocks -1) - If the Used Space and HWM are considerably different then you should recreate the table to save *wasted space*. I am sure this is not the most efficient way of doing this but it works for me. Regards Suhen are u saying try it or are you saying that you can find this info using dbms_space;) Thx Deepak --- Sairlao, Chark [EMAIL PROTECTED] wrote: try dbms_space Thanks And Regards Chark Sairlao -Original Message- Sent: Tuesday, 18 December 2001 9:40 To: Multiple recipients of list ORACLE-L no there is not .. unless someone corrects me that is ;) Deepak --- Gene Gurevich [EMAIL PROTECTED] wrote: Hi all: Is there a way for me to see how many blocks under the HWM are unused? thanks Gene -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Suhen Pather INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SQL Lock consistency - a great answer
at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Serial# changes when rolling back
into the server thru telnet, I found that the session is active. By mistake, I killed the process at o/s level. For somereasons,I tried to drop the table. But I failed to do it, as it is locked by import process. I tried to kill the user SYSTEM. But the oracle is giving error that there is not user with such sid and serial number. The serial# number is often getting changed when I query from v$session. Is there a way to kill this user, without shutting down the database. And why different serial# number each time, I query v$SESSION.? Any clues? Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. = -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Serial# changes when rolling back
intresting ... --- [EMAIL PROTECTED] wrote: One explanation I had heard for the combination of Sid+Serial# goes something like this ... say you identify a particular session to monitor ... you then decide to kill it. However, it could so happen that that user logged out between the time you decided to kill the session and the time you actually killed the session (even if you have scripted the kill command). When a user logs out, the Sid is available to the next user who logs in. Since another user might be holding the same Sid at the time you come around to kill the Sid, you might actually kill the wrong user-session. To avoid this, the next user, getting the same Sid gets a different Serial# and your kill must be on Sid+Serial# together. That still does not explain why pmon increments the Serial#, though. Hemant Deepak Thapliyal [EMAIL PROTECTED] 12/12/2001 06:26 AM Sent by: [EMAIL PROTECTED] Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: (bcc: CHITALE Hemant Krishnarao/Prin DBA/CSM/ST Group) Subject: Re: Serial# changes when rolling back yeah i did read this thread but still wonder why oracle needs to use serial# column at all. Does the SID not gaurentee uniqueness for a session ... damn the name says so atleast (session identifier).. or maybe they just coded it like that and make some use of the serial # Deepak --- [EMAIL PROTECTED] wrote: Check this Oracle Note : Doc ID: Note:1020545.102 Subject: ORA-00026: CANNOT KILL SESSION; SERIAL# KEEPS CHANGING Type: PROBLEM Status: PUBLISHED Content Type: TEXT/PLAIN Creation Date: 23-NOV-1999 Last Revision Date: 24-AUG-2000 Problem Description --- You have killed a process at the operating system level that was running a long-running transaction. Now, you are trying to issue the command: alter system kill session 'sid, serial#'; To kill the associated Oracle session, but you can't kill it. You may receive the following error: ORA-00026: missing or invalid session id Cause: The session ID string specified in the ALTER SYSTEM KILL SESSION command was invalid, or no string was specified. Action: Retry the command with a valid session ID. In v$session, you notice that the serial# for the session keeps changing. Also, pmon may be creating a trace file that keeps growing. Solution Description It is best to let pmon roll back the changes. If you shutdown at this point, this work will still have to be done at the next startup. pmon is rolling back changes and will let the session die when it is finished. To verify that work is being done, select used_urec from v$transaction. If the value for this column keeps going down, then work is being done. When used_urec reaches zero, then the rollback will be done, and the session will die. With Oracle8, you can list dead transactions by issuing the following query: select * from x$ktuxe
Re: EXECUTE A PACKAGE
hamid, use a pl/sql table as an out parameter .. ping me if you need more details .. better still refer the pl/sql user's guide at otn.com Deepak --- Hamid Alavi [EMAIL PROTECTED] wrote: Question? How can I run a package which return more than one rows with an input parameter exec package.procedure(param1) some thing like this or what??param1 is a department name and I want to retreive the list of employee for this dept. Thanks for help. Hamid Alavi Office 818 737-0526 Cell818 402-1987 The information contained in this message and any attachments is intended only for the use of the individual or entity to which it is addressed, and may contain information that is PRIVILEGED, CONFIDENTIAL and exempt from disclosure under applicable law. If you have received this message in error, you are prohibited from copying, distributing, or using the information. Please contact the sender immediately by return e-mail and delete the original message from your system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hamid Alavi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Check out Yahoo! Shopping and Yahoo! Auctions for all of your unique holiday gifts! Buy at http://shopping.yahoo.com or bid at http://auctions.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollbacks - ORA-1555
Hi Christine, these results are slightly differnt from the earlier ones you .. as the latest ones had 8,48409 fewer data requests. I believe you are worried about the wraps.. if yes .. dont be , cuz at some point or the other the rbs will wrap. the definition of wrapping is controversial and lots of confusion still exists. That said, wraps are probably not the best metrics to help you identify rbs issues.. here are the metrics i use to for identifying if there are rbs issues from v$rollstat.. (excluding v$waitstat stats as you already seem to have figured that one it seems) 1. waits (ideally you want this to be 0) 2. shrink (if high means that there is dynamic allocation and reallocation.. tune optimal.. ideally you want your rbs to always stay at its optimal size with 0 shrinks..) 3. AVEACTIVE: you reached a maximum of about 200K. so maybe you should try changing initial and next to 250K with other parameters same and check if the numbers are looking better finally the reason i replied to the whole list and not only to you is that i am hoping someone can come forward and say that .. dude!! you have it figgured all wrong!! that way at least i get to learn somin new for sure... ;) Thx Deepak PS: might also help to check v$session_wait for buffer waits to see what type of blocks are being contended for.. --- Christine Turner [EMAIL PROTECTED] wrote: Hello All, I changed the rollback segments, and here are the results. I'm now at 20 segments, 1 meg each, minextents 20, optimal 20. Here are the results after running the process within the application with auto-commits turned off... data requests - 2969079 CLASS COUNT -- - system undo header 0 system undo block 0 undo header1 undo block 0 USN NAME AVEACTIVE OPTSIZE WAITS WRAPS EXTENDS SHRINKS AVESHRINK -- - - - - --- - - 0 SYSTEM 0 0 0 0 0 0 2 SV_ROLL0 106086 20971520 0 1 0 0 0 3 SV_ROLL1 106086 20971520 0 1 0 0 0 4 SV_ROLL2 106086 20971520 0 1 0 0 0 5 SV_ROLL3 106086 20971520 0 1 0 0 0 6 SV_ROLL4 0 20971520 0 0 0 0 0 7 SV_ROLL5 106086 20971520 0 1 0 0 0 8 SV_ROLL6 106086 20971520 0 1 0 0 0 9 SV_ROLL7 106086 20971520 0 1 0 0 0 10 SV_ROLL8 106086 20971520 0 1 0 0 0 11 SV_ROLL9 106086 20971520 0 1 0 0 0 12 SV_ROLL10 201973 20971520 1 2 0 0 0 13 SV_ROLL11 0 20971520 0 0 0 0 0 14 SV_ROLL12 106086 20971520 0 1 0 0 0 15 SV_ROLL13 106086 20971520 0 1 0 0 0 16 SV_ROLL14 106086 20971520 0 1 0 0 0 17 SV_ROLL15 106086 20971520 0 1 0 0 0 18 SV_ROLL16 201973 20971520 0 2 0 0 0 19 SV_ROLL17 106086 20971520 0 1 0 0 0 20 SV_ROLL18 106086 20971520 0 1 0 0 0 21 SV_ROLL19 106086 20971520 0 1 0 0 0 21 rows selected. TSPACE TOTAL USED FREE --- - - - SV_ROLL_TSP 800 407 394 This doesn't look real good to meam I correct??? I will try processing without the optimal being set to see what happens, while I await other response. thanks! Christine -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Deepak Thapliyal Sent: Tuesday, December 04, 2001 5:12 PM To: Multiple recipients of list ORACLE-L Subject: Re: Rollbacks - ORA-1555 Hi Christine, Your rollback segments look large to me based on the description you have given for your application. One way of eliminating header waits is to increase the number of rbs .. try this and post if this helps your stats.. 1. Create total of 20 rollback segments 2. Specification for each rbs is : initial 1M next 1M minextents 20 maxextents unlimited optimal 20M meaning that each rbs will have 20 extents initially and size of each rbs will be 20M initially. since you have 20 such rbs, total rbs used is 20 * 20M = 400M if you observe, the above structure uses smaller sized large number of rollback segments as from your description below, it looks like you have a oltp
Re: difference between temporary tablespaces
Hi Helmut, here is the breakdown Tablespaces 1 DMT (dictionary managed) a Normal b temporary(only temp objects) 2. LMT temporary tblspces (True temp tblspces) syntax: create temporary tablespace The behaviour of this is similar to the /tmp of unix as temp files gets flushed (gone) on db bounce. Also rman full backups ignore these which is a big plus. these are visible using v$tempfile or dba_temp_files or somin like that Deepak --- Daiminger, Helmut [EMAIL PROTECTED] wrote: Hi! I'm getting kinda confused concerning the two types of temporary tablespaces: create tablespace NAME temporary... is the old way of creating a temporary tablespace for sorting purposes. It only allows for sort segments to be stored there. And it can only be dictionary managed, right? create temporary tablespace NAME tempfile... is the new way for it. It can either be dictionary managed or locally managed. But the complete reference says that this tablespace will only be used for temporary tables. Does this tablespace also allow for sort segments? Or do I need both types of tablespaces? This is 8.1.7 on Sun Solaris. Thanks, Helmut __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Rollbacks - ORA-1555
Hi Christine, Your rollback segments look large to me based on the description you have given for your application. One way of eliminating header waits is to increase the number of rbs .. try this and post if this helps your stats.. 1. Create total of 20 rollback segments 2. Specification for each rbs is : initial 1M next 1M minextents 20 maxextents unlimited optimal 20M meaning that each rbs will have 20 extents initially and size of each rbs will be 20M initially. since you have 20 such rbs, total rbs used is 20 * 20M = 400M if you observe, the above structure uses smaller sized large number of rollback segments as from your description below, it looks like you have a oltp system with large number of transactions tell me if this helps .. Deepak --- Christine Turner [EMAIL PROTECTED] wrote: RE: BMC Patrol DBXray / CA UnicenterGreetings All I am some what new to the list, so forgive me if I don't have the proper etiquette in addressing my issue. I have a database, 8.1.6, running on Windows NT, that currently has 5 rollback segments. The specs are as follows for each segment: OPTIMAL 350M minextents 7 maxextents unlimited initial 50M next 50M These segments are currently in one tablespace, for rollbacks only, which is sized at 2.5 gig, and currently the segments are taking 1.7 gig, obviously aprox 750 meg free. I have an application, written by our developers here, which is doing a functionality called pricing. Within this process is alot of DML (updates and deletes) with some DDL inter-mixed. There is an auto-commit feature, which is currently commiting every 1000 records. There is also a locking feature, before the actual fetches the application is performing for it's cursors, and the developers are currently using select * from table for update nowait to lock the whole table for this process. The locking is in place because this particular process can use up to 5 different sessions. Currently the stats of the rollbacks look like this: data requests - 3817488 CLASS COUNT -- -- system undo header 0 system undo block 0 undo header 3 undo block 1 USN NAMEAVEACTIVEOPTSIZE WAITS WRAPS EXTENDSSHRINKS AVESHRINK -- -- -- - - --- -- --- --- 0 SYSTEM 00 0 0 0 0 2 SV_ROLL00 367001600 2 0 0 0 0 3 SV_ROLL10 367001600 0 0 0 0 0 4 SV_ROLL20 367001600 1 0 0 0 0 5 SV_ROLL30 367001600 0 0 0 0 0 6 SV_ROLL40 367001600 0 0 0 0 0 6 rows selected. TSPACE TOTAL USED FREE --- -- -- -- SV_ROLL_TSP 2500 1751750 At times I have seen the aveactive column have some numeric value in it, but when the database and services are shutdown and brought back up, this number clears out. My question is this: how much larger are these rollbacks supposed to be before I can eliminate the waits and wraps? More importantly, eliminate the undo headers and block. I have done alot of testing, with different sizing, and I feel like I'm chasing my tail. This is a major feature of our software, so it's not like it can be ran at night to differ to a timing issue. I have also noticed, that PMON doesn't really shrink appropriately, not back to a state like they are when they are first created. At this point, I guess I'm looking for some insight, advice as to what to specifically do to tune these segments a little more. Thanks So Much, in advance Christine __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: killing system user
Hi Jared why does the serial# have to change due to rollback? lots of us would be curious for a brief expln ... Thx Deepak --- Jared Still [EMAIL PROTECTED] wrote: The session is rolling back, you can't kill it. This is why the serial# is changing. The following query can be used to track its progress. select s.osuser ,s.username ,s.sid ,r.segment_name ,t.space ,t.recursive ,t.noundo ,t.used_ublk ,t.used_urec ,t.log_io ,t.phy_io ,substr(sa.sql_text,1,200) txt from v$session s, v$transaction t, dba_rollback_segs r, v$sqlarea sa where s.taddr=t.addr and t.xidusn=r.segment_id(+) and s.sql_address=sa.address(+); Jared On Sunday 02 December 2001 22:55, Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists, Solaris 2.7 oracle 8i I have a session SYSTEM doing import into a table. (logged into server thru telnet from win 98 PC) Suddenly the power outage occurred to my PC. When I logged into the server thru telnet, I found that the session is active. By mistake, I killed the process at o/s level. For somereasons,I tried to drop the table. But I failed to do it, as it is locked by import process. I tried to kill the user SYSTEM. But the oracle is giving error that there is not user with such sid and serial number. The serial# number is often getting changed when I query from v$session. Is there a way to kill this user, without shutting down the database. And why different serial# number each time, I query v$SESSION.? Any clues? Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
_delete_me=true
_delete_me=true __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: killing system user
yeah Jared, i will look at it. C i am wondering that if the SID is sufficient to gaurentee uniqueness .. why does oracle need the serial# as well?? or maybe there is a scheduled maintainance window at this time inside of my head ;) Thx anyhu ;) Deepak --- [EMAIL PROTECTED] wrote: Deepak, To be quite honest, I can't remember. I'm like that with details sometimes. I tend to forget them, though I remember the reason I learned them in the first place. :) This is on MetaLink somewhere if you care to look for it. I really can't do that now. It's back to the grindstone for me. The grindstone in this case being iFS 1.1.9. Ah the joy of troubleshooting. :) Jared Deepak Thapliyal deepakthapliyal@ To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] YAHOO.COM cc: Sent by:Subject: Re: killing system user [EMAIL PROTECTED] 12/03/01 09:55 AM Please respond to ORACLE-L Hi Jared why does the serial# have to change due to rollback? lots of us would be curious for a brief expln ... Thx Deepak --- Jared Still [EMAIL PROTECTED] wrote: The session is rolling back, you can't kill it. This is why the serial# is changing. The following query can be used to track its progress. select s.osuser ,s.username ,s.sid ,r.segment_name ,t.space ,t.recursive ,t.noundo ,t.used_ublk ,t.used_urec ,t.log_io ,t.phy_io ,substr(sa.sql_text,1,200) txt from v$session s, v$transaction t, dba_rollback_segs r, v$sqlarea sa where s.taddr=t.addr and t.xidusn=r.segment_id(+) and s.sql_address=sa.address(+); Jared On Sunday 02 December 2001 22:55, Tatireddy, Shrinivas (MED, Keane) wrote: Hi lists, Solaris 2.7 oracle 8i I have a session SYSTEM doing import into a table. (logged into server thru telnet from win 98 PC) Suddenly the power outage occurred to my PC. When I logged into the server thru telnet, I found that the session is active. By mistake, I killed the process at o/s level. For somereasons,I tried to drop the table. But I failed to do it, as it is locked by import process. I tried to kill the user SYSTEM. But the oracle is giving error that there is not user with such sid and serial number. The serial# number is often getting changed when I query from v$session. Is there a way to kill this user, without shutting down the database. And why different serial# number each time, I query v$SESSION.? Any clues? Thnx and Regards, Srinivas -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name
Re: HP-UX 11/8.1.7/Recovery
Michael i remember (long time back) they had released a new command called as alter database .. end backup or somethin in 7.3.. maybe this is the default behaviour in later releases including 817 Deepak --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Hi All! We had an interesting sequence of events last night, and I was hoping somebody could tell me if what we saw was what should've happened. Clear? As mud? Ok... System is up and running. The backup process starts, and puts the datafiles in backup mode. The system crashes. Hard. Memory fault. When the database comes back up, it successfully performs media recovery and pronounces itself OK. We check, and the datafiles are NOT in backup mode. So we're wondering...does media recovery take the datafiles out of backup mode automatically? Can you point me to a doco on this? Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: rman restore arclogs
We have a slightly differnt apprach for this .. 1. cp arch files to arch history location (stage 2 days worth achives on disk. there is a cron that fires everday and deletes all files from hostory arch location which are two or more days older) 2.there is a script that invokes rman to backup arch using delete input clause steps 1 and 2 are done every 4 hours for archives so that archives are backed up to tape and to ensure as per sla that we store atleast 2 days worth of archives on disk. at the end of the day take a db backup(full or inc as per sla. vaires from db to db) Deepak --- HAWKINS, JAMES W [IT/1000] [EMAIL PROTECTED] wrote: I just wanted to throw something else out there - it may have already come up though. We backup the archivelogs first without deleting them, and then immediately backup another set with the delete specified. Obviously, this is because anything can happen to that first set (corruptions, etc.), and if that's your only set, then you're screwed. The chances of the same archivelog being corrupt in both sets is very low (unless the source archivelog is corrupted), but at least you are protected against all the copy errors. Also, it's very probable (for us, anyway) that each copy of the archivelog will be on different physical tapes, which in itself is important to us since operations is outsourced ; ) Jim __ Jim Hawkins Oracle Database Administrator Data Management Center of Expertise Pharmacia Corporation 800 North Lindbergh Blvd. St. Louis, Missouri 63167 Work (314) 694-4417 Cellular (314) 724-9664 Pager (314) 294-9797 [EMAIL PROTECTED] -Original Message- Sent: Monday, December 03, 2001 12:56 PM To: Multiple recipients of list ORACLE-L Lisa, I guess I'm lazy (or cautious) in that I would allow the first backup to take this archive log files back to tape where they belong, rather than determine (by running reports) which log files I may delete (by hand). The cautious part of me says that if Rman decided to back these monkeys up within the first save set after the recovery, it may have decided that it needs them for a future recovery. If you did remove them by hand, Rman may complain that it was expecting them and did not find them. Did you try this - remove one that was restored by the recovery process and then tried a backup? Depending on the kind of restore you do - a full, or a point in time - the archivelog may be of no use anyway (a point in time makes them invalid because you had to perform an open db reset logs, while a full restore could still use these again). Glad you are at least experimenting with the tool before you put it in production - it actually is fun to do a restore as it happens so infrequently! Good Luck! Tom Mercadante Oracle Certified Professional -Original Message- Sent: Monday, December 03, 2001 10:30 AM To: Multiple recipients of list ORACLE-L Good morning all - I've been practicing rman restores. It's a lot easier than I originally thought. I've noticed that when you restore and the arclogs are needed, it restores them. Which is expected. However, when I take another backup, these arclogs are included in the backup set. This is unnecessary in my opinion and makes my backup files larger than they need to be. Is it standard practice to just delete the arclogs that were already in a backup set prior to taking the immediate backup after a recovery? I can verify what arclogs are where in the backup sets with a report. Any comments are appreciated. Thanks Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: _delete_me=true
gee what is ping? oh yeah maybe thomas needs to know that;) its been a long day .. dont mind !!! --- Mercadante, Thomas F [EMAIL PROTECTED] wrote: Gee, how do I unsubscribe? Oh-yeah! Its at the bottom of every piece of mail!!! Holy Cow BatMan! To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -Original Message- Sent: Monday, December 03, 2001 1:30 PM To: Multiple recipients of list ORACLE-L Does he think - UNSUBSCRIBE? :-)) On Mon 3. December 2001 18:55, you wrote: _delete_me=true __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Buy the perfect holiday gifts at Yahoo! Shopping. http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: backup unix script
Hi grace it basically means that log in to sql*plus and execute whatever is below this line till you hit bang(!) .. literally. Deepak --- grace [EMAIL PROTECTED] wrote: hi gurus, I found this unix script ... can any tell me what this means? sqlplus - sys/msd filename.dat ! does anyone have a unix script to perform a database backups? Best Regards, Grace Lim Suy Sing Comm'l Corp. (632)-2474134 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: rman disk channel destination
try this .. RUN { ALLOCATE CHANNEL disk1 DEVICE TYPE DISK FORMAT '/disk1/%d_backups/%U'; ALLOCATE CHANNEL disk2 DEVICE TYPE DISK FORMAT '/disk2/%d_backups/%U'; ALLOCATE CHANNEL disk3 DEVICE TYPE DISK FORMAT '/disk3/%d_backups/%U'; BACKUP DATABASE; } Deepak PS: straight from the manual (based on search criteria entered on google .. hehehe) --- Koivu, Lisa [EMAIL PROTECTED] wrote: This info isn't forthcoming on metalink or in the doco as far as I can tell. Can anyone tell me how to change the directory associated with the rman command 'allocate channel disk'? Or at least figure out where it is, rather than hunt and peck? Is it fixed? Boy that would really bite. Thanks Lisa Koivu Oracle Database Monkey Mama Fairfield Resorts, Inc. 954-935-4117 __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: doubts reg : Tablespace
sangeeta, this is explained in great depth in the 1st chapter of the Oracle concepts manual... Deepak --- sangeetha [EMAIL PROTECTED] wrote: hi, what is the exact use of making the 'status' online or offline at the time of creation of tablespace. can objects of two diff users be stored in the same tablespace and datafile. can two tablespaces contain the same datafile . thanx in advance sangeetha __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: sangeetha INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: LISTENER CONFIGURATION?
Seema, for this you basically define them in the listener.ora file and start each individually .. here is an e.g. LISTENER = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = yyy.zz.ea.com)(PORT = 1521)) ) LISTENER_REAL = (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = xxx.xx.ea.com)(PORT = 1522)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (ORACLE_HOME = /opt/oracle/product/816) (SID_NAME = gamesdev) ) ) SID_LIST_LISTENER_REAL = (SID_LIST = (SID_DESC = (ORACLE_HOME = /opt/oracle/product/816) (SID_NAME = realdb) ) ) hth Deepak --- Seema Singh [EMAIL PROTECTED] wrote: Hi How could configure multiple listener for diffrent database if we have single oracle home? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Multiple instances - Sun Solaris
Lisa, 1. Find the amt of shared mem you are using: ipcs -mb 2. see your os limit. for e.g. : sysdef |grep -i shm also ensure that ur /etc/system parameters match with the output from 2. If not, you need to bounce the unix box for those values to tale effect. Check specifically for kernal parameters shmmax and semmns and ensure that these are set correctly. hth Deepak --- YTTRI Lisa [EMAIL PROTECTED] wrote: Hi - We are running a solaris server (2.6) for our develoment environment. We currently have 5 instances on the server. When we create another instance and try to start it, we get a ORA-27101: shared memory realm does not exist. The text reads 'Unable to locate shared meory realm'. We have set the following kernal parameters to what we believe to be appropriate. SHMMAX=1207959552 SHMMIN=1 SHMSEG=10 SEMMNI=100 SEMMSL=350 SEMMNS =1000 SEMOPM =100 SEMVMX=32767 Does anyone know of any other kernal parameter settings that may be causing this error? THanks - Lisa -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: YTTRI Lisa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Urgent - error ORA-24327
what is your processes parameter set to? --- Rao, Maheswara [EMAIL PROTECTED] wrote: List The environment : Oracle 817 : Solaris 7 : Memory - 4 GB. WebLogic Vesrion: 6.1 In the WebLogic Connection pool, when we try to open the connections beyond 246, we are getting this error - ORA 24327. We are not getting this error when the connection pool in the WebLogic is below 245. Any help would be appreciated. Thanks, Rao __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Need Help Please - With Procedures
raja, I would recommend that you heed Kevin's advise .. in the meantime .. here is a quick start e.g. for what you are looking to do .. create procedure Blah ( para_owner in varchar2, para_table in varchar2) is cursor c1(v_owner varchar2, v_table varchar2) is select blah1 , blah1 , ... from bigBlah where blah= v_owner and bloh = v_table; begin for rec in c1(para_owner, para_table ) loop dbms_output.put_line(rec.blah1); dbms_output.put_line(rec.blah2); end loop; end; / hth Deepak --- Viraj Luthra [EMAIL PROTECTED] wrote: Yeah I am reading, but if I could get a framework for a procedure, referring to my sql's, then that would be a big help. Please help. rgds, raja -- On Wed, 28 Nov 2001 11:25:01 Kevin Lange wrote: Two books . Oracle PL/SQL Programming and Oracle Built-in Packages. Both from Steven Feuerstein on O'reilly press. Good books for this. -Original Message- Sent: Wednesday, November 28, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Hello all, I have attached an sql file containing a set of sql's (6) of them, which gives me information regarding table fragmentation. What I need to do is instead of writing seperate sql's, I need to write a procedure, where in I pass the owner and table name and then the result comes out, as you will see in the last sql. What I need is, if some one could please help in writing a procedure? How to put cursors and use all the information in different cursor variables etc. Please help. Thanks. Rgds, Raja -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Viraj Luthra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Connection question?
hey lisa Thats what i was temted to reply as well {lol} .. but if you look closely .. both her conn are bequeth .. i was under the impression that bequeth was used only for local and not remote .. thats why we chose beq over tcp for db's that resided in same box for performance reasons .. or so i thought until now ;) thoughts ..? Thx Deepak --- Koivu, Lisa [EMAIL PROTECTED] wrote: One is LOCAL=YES and one is LOCAL=NO One is Local, one isn't. Lisa Koivu Oracle Database Monkey Fairfield Resorts, Inc. 954-935-4117 -Original Message- From: Seema Singh [SMTP:[EMAIL PROTECTED]] Sent: Tuesday, November 27, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Subject:Connection question? Hi WHen I execute ps -ef |grep LOCAL on Solaris server the following output i see in 1)(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq))) 2)(DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ))) What is the diffrence between 1 and 2. Thanks Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Revoke Delete
i.e. unless u dont have a truncate trigger instead .. lol Create or Replace Trigger StopTruncatesAndDrops Before TRUNCATE or DROP on database WHEN (ora_dict_obj_name = 'MTRX_GAME_SESSION_FACTS' AND ora_dict_obj_type = 'TABLE') declare begin raise_application_error(-20211, 'Cannot Drop or Truncate Fact Table!!'); end; / intrestin stuff aint it .. especially when the fact table holds millions .. of records i mean ;) Deepak --- Ron Thomas [EMAIL PROTECTED] wrote: But of course a delete trigger is not called on a truncate... Ron Thomas Hypercom, Inc [EMAIL PROTECTED] MohanR@STARS- SMI.com To: [EMAIL PROTECTED] Sent by: cc: root@fatcity.Subject: RE: Revoke Delete com 11/27/01 02:40 PM Please respond to ORACLE-L set what, precisely, through a trigger? Geez, if you have a DBA and/or a schema owner that can't/shouldn't be deleting from a table, what you have is NOT a database problem, it's an HR problem. sheesh. yea, how about this? an BEFORE DELETE trigger on the table, saving and repopulating each row the Evil DBA deleted, and logging his Evil Actions in the Military Audit table, so that the Evildoer can be brought to justice? Yea, that's the ticket, that's printable in Dilbert. In peace, love, data, and triggers, - The Evil One -Original Message- Hi Listers, How can we revoke 'delete privilege' from the schema owner of the table and also from DBA ? If it is not possible, can we set through trigger ? Thanks. Aldi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mohan, Ross INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Thomas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message
Re: guess I'm presenting at OOW
uh u meant somin like tuning discussion is beyond the scope of this paper ;) --- Connor McDonald [EMAIL PROTECTED] wrote: You just open up with: This is statspack. You install it with spcreate, collect stats with a pl/sql call, and report with spreport.sql. Then you interpret the myriad the results - but of course, that is a tuning discussion not a statspack one...Questions anyone? :-) --- Rachel Carmichael [EMAIL PROTECTED] wrote: This is a cross post folks... so...unfortunately, Susan McClain will not be able to attend OOW, and it now seems I AM presenting (where the heck did I put that skirt?)... I will be giving her presentation for her Statspack on Monday (I think at 11) Be kind folks, I haven't even SEEN the paper or presentation yet, and I haven't really worked with statspack much. This means it will be a short presentation :) I think they call this a challenge. Rachel __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Upgrade 8.0.5 to 8.1.6
Ed, the whole point of compatable is to mimick behaviour of an older release .. like optimizer plans etc. upgrading the db would be the way to go for this.. like many have already pointed out Deepak --- Ed [EMAIL PROTECTED] wrote: A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 by using export/import. This will probably work, but wouldn't it be easier to just do a cold backup and open them using the COMPATIBLE parameter in the 8.1.6 environment? Is there any downside to using export/import? (ie. will it affect snapshots, db links, etc...). I thought the whole point of the compatible parameter was that it let you open up an older database with no questions asked. Then you could run any of the upgrade .sql scripts at your leisure, yes? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ftp tools
Terry, check out www.vandyke.com .. Deepak PS: more so check out google.com .. ;) --- Ball, Terry [EMAIL PROTECTED] wrote: Does anyone know a site where one can get a FREE gui ftp tool? Thanks, Terry Terry Ball, DBA Birch Telecom Work: 816-300-1335 FAX: 816-300-1801 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ball, Terry INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Upgrade 8.0.5 to 8.1.6
Yes it will save time as well ..all the upgrade does is mess the datafile headers so they are 816 format also the upgrade script will simply re-initialze the catalog to 816 is also quite fast and will complete in a few minutes .. if you have a 1TB db for e.g. upgrade would definitely be a far more faster option .. as for upgrade breaking your db .. more chances that your approach of only setting the compatable flag might in turn lead to software corruption in the long run if not immediately .. thing change with ever release .. and when its oracle .. this REALLY change a lot .. and hence they recommend the upgrade path .. however if your db is small .. then maybe creating an an 817 db and creating tablespaces and then exp-imp way will work as well .. Deepak --- Ed [EMAIL PROTECTED] wrote: Yes, I agree 100%, but people here are concerned that upgrading will break the database, and we have to QUICKLY move everything over to 8.1.6. (Long story). What I was really after in my original question was: why is the upgrade script a better solution than just recreating the tablespaces in 8.1.6 and importing from an export of the old database? Does it just save time? Is there a downside to using export/import this way? Best! Ed -Original Message- Thapliyal Sent: Wednesday, November 21, 2001 12:20 PM To: Multiple recipients of list ORACLE-L Ed, the whole point of compatable is to mimick behaviour of an older release .. like optimizer plans etc. upgrading the db would be the way to go for this.. like many have already pointed out Deepak --- Ed [EMAIL PROTECTED] wrote: A DBA here is trying to upgrade several 8.0.5 databases to 8.1.6 by using export/import. This will probably work, but wouldn't it be easier to just do a cold backup and open them using the COMPATIBLE parameter in the 8.1.6 environment? Is there any downside to using export/import? (ie. will it affect snapshots, db links, etc...). I thought the whole point of the compatible parameter was that it let you open up an older database with no questions asked. Then you could run any of the upgrade .sql scripts at your leisure, yes? Best, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! GeoCities - quick and easy web site hosting, just $8.95/month. http://geocities.yahoo.com/ps/info1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send
Re: Rollback Segment Too Old !!!!!!!
Hey Anita, this is really a cool workaround .. who thought these dummy transactions were so damn smart !!! this implementation of dummy Xns i am hearing about for the first time .. let me admit ;) Great mail!! Thx Deepak --- A. Bardeen [EMAIL PROTECTED] wrote: The ORA-1555 is a read consistency error. The information from the rollback segments needed to create a read-consistent view of the data is not available. Usually because the information has been overwritten or the extents containing this information have been deallocated (e.g. if optimal is set). Until 9i, where you can use automatic undo to avoid these errors, the best way is to create dummy transcations in each of the online RBS's before starting the export and leave them uncomitted until the export completes. This will prevent the rollback segments from wrapping around and overwriting the extents that contained uncomitted transactions when the export began. Of course this means you're likely to generate a lot more rollback than usual so you'll need to monitor the space in the RBS tablespaces to avoid getting extent allocation errors. Check Steve Adams' site for a set of scripts to assist you with this: http://www.ixora.com.au Scripts Rollback Segments HTH, -- Anita --- Jackson Dumas [EMAIL PROTECTED] wrote: Yeah I had a problem recently were I was exporting a 45Gigg database, the export will continue until at a end it will come up with a warning that export was completed successfully with warnings because rollback segment was too old. I increased the tablespace RBS where the rollback segments are residing and also created some more rollback segments. This did not work also, I had a problem similar to this but this was happening when the user was trying to delete some records with a where clause, it would come up with the error rollback segment too old. Can somebody give me an idea of how to go about this problem, I would appreciate you input dearly Thank you, Mtabaruka ! ___ http://www.webmail.co.za the South-African free email service -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jackson Dumas INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: A. Bardeen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Rollback Segment Too Old !!!!!!!
://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Solaris - db_file_multiblock_read_count
Jeff, as jared pointed out already .. p3 for scattered read is the number of blocks read .. so setting your DB_Multi... to 25 would be the best you can achieve for your platform .. Deepak --- Jeff Wiegard [EMAIL PROTECTED] wrote: Hi. I was hoping for some confirmation here. I'm running 8.0.5 on Solaris 2.7, with block size set to 8192. There is no 'maxphys' parameter in /etc/system. After some testing, I've decided to set the db_file_multiblock_read_count = 24, based on the following: 1. SQL alter session set db_file_multiblock_read_count = 1000; 2. select value from v$parameter where name = 'db_file_multiblock_read_count'; This gave me a value = 128 3. alter session set events '10046 trace name context forever, level 8'; 4. select /*+ FULL(t) */ count(*) from sys.source$ t; The trace file gave me the following: WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=660 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1167 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1207 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1272 p3=25 WAIT #1: nam='db file scattered read' ela= 0 p1=1 p2=1312 p3=25 So then setting db_file_multiblock_read_count to 24 would be about right ... right? Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Wiegard INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
9i RAC
Hi Fellow List Members, Anyone installed 9i RAC on solaris. Anyone want to share their experience in terms of hiccups or issues. Also would appreciate if you could include hardware requirements. Thx Deepak __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: sanity check
Hi Bill, You are missing a BIG thing as u are trying to open a older version of the database(815,816) using higher version oracle binaries(817). U need to upgrade your lower release databases first! its quite straight forward .. here is a brief high level for you .. install binaries in new home for 817 copy old init to dbs and remove obselete parameters set env vars for newly installed 817(including SID) start sql*plus and connect as internal and run -- @uold_release.sql { where uold_release.sql is the release from which you are upgrading} e.g for upgrading from 815 2 817 use: @u0801050.sql e.g for upgrading from 815 2 817 use: @u0801060.sql for detailed step by step instructions refer to enclosed link : http://otn.oracle.com/docs/products/oracle8i/doc_library/817_doc/server.817/a86632/migupgra.htm#24532 hth Deepak --- Thater, William [EMAIL PROTECTED] wrote: i have a development server with 815, 816, 817 installed [don't ask.]. we have suspended development at this point in time and shut down the server. AFAIK, if i move the correct initSID.ora files into the dbs directory for 817, it should read the control files for the other versions and open the databases. am i missing anything here? and yes i know i could just try it and i would if i was given the chance. [again don't ask.] -- -- Bill Shrek Thater ORACLE DBA Telergy,Inc. [EMAIL PROTECTED] You gotta program like you don't need the money, You gotta compile like you'll never get hurt, You gotta run like there's nobody watching, It's gotta come from the heart if you want it to work. This login session: $13.76, but for you: $11.88. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Thater, William INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Tracing a session - weird problem
Hi Kathy, Did you delete the trace on OS level. I have seen cases where the connected processes will not generate traces after u delete the file. If this is not production then you could bounce db or beter disconn and conn again Deepak --- Kathy Duret [EMAIL PROTECTED] wrote: 8.1.6 on HP-UNIX sqlplus sys/x alter session set timed_statistics=true; exec dbms_system.set_sql_trace_in_session(50,23265,true); exec dbms_system.set_sql_trace_in_session(50,23265,false); I ran these statements got a trace file but NO time stamps. Since the process was still running I tried to run it again, but this time no trace file... I know I have the correct location for the udump. The file system is NOT full. What could be going on. I have never seen this. Thanks Kathy Confidential This e-mail and any files transmitted with it are the property of Belkin Components and/or its affiliates, are confidential, and are intended solely for the use of the individual or entity to whom this e-mail is addressed. If you are not one of the named recipients or otherwise have reason to believe that you have received this e-mail in error, please notify the sender and delete this message immediately from your computer. Any other use, retention, dissemination, forwarding, printing or copying of this e-mail is strictly prohibited. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kathy Duret INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: hide password
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: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online index rebuilds
are you rebuilding BITMAP .. i think that aint supported Deepak --- Ramon Estevez [EMAIL PROTECTED] wrote: Steve, I get ORA-08108: may not build or rebuild this type of index online Ramon E. Estevez [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] 809-565-3121 -Mensaje original- De: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]En nombre de Orr, Steve Enviado el: Thursday, 15 November, 2001 2:49 PM Para: Multiple recipients of list ORACLE-L Asunto: RE: Online index rebuilds No Answers? Is the question hard or do you just not like me anymore? :-) Could someone just try the below 2 commands and let me know if they work on your system(s)? 1) alter index name rebuild online compute statistics; 2) alter index name rebuild online compress; AtDhVaAnNkCsE !!! -Original Message- Sent: Wednesday, November 14, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Compressed indexes: The docs don't say that compressed indexes cannot be rebuilt online but it doesn't work for me. I can rebuild normal indexes online, I can rebuild an index and compress it but I can't do both. Compute statistics: SQL alter index name rebuild online compute statistics nologging; Online rebuilds with compute statistics don't work either and the docs don't say there's a restriction on this. Are these documentation bugs or software bugs? (O8172/RedHat6.2) Steve Orr Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ramon Estevez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online index rebuilds
yeah we no longer like u .. lol jokes apart.. the online option gave me error both these worked for me without the online clause alter index tst rebuild compute statistics; alter index tst rebuild compress; Deepak --- Orr, Steve [EMAIL PROTECTED] wrote: No Answers? Is the question hard or do you just not like me anymore? :-) Could someone just try the below 2 commands and let me know if they work on your system(s)? 1) alter index name rebuild online compute statistics; 2) alter index name rebuild online compress; AtDhVaAnNkCsE !!! -Original Message- Sent: Wednesday, November 14, 2001 12:35 PM To: Multiple recipients of list ORACLE-L Compressed indexes: The docs don't say that compressed indexes cannot be rebuilt online but it doesn't work for me. I can rebuild normal indexes online, I can rebuild an index and compress it but I can't do both. Compute statistics: SQL alter index name rebuild online compute statistics nologging; Online rebuilds with compute statistics don't work either and the docs don't say there's a restriction on this. Are these documentation bugs or software bugs? (O8172/RedHat6.2) Steve Orr Bozeman, MT -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Orr, Steve INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Disk to Disk backups and RMAN
-- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Online index rebuilds
got this off of ML .. Key compressed indexes SQL8 create index I_COMP_T1 on T1 (C1) COMPRESS ONLINE; create index I_COMP_T1 on T1 (C1) COMPRESS ONLINE * ERROR at line 1: ORA-08108: may not build or rebuild this type of index online SQL9 create index I_COMP_T1 on T1 (C1) COMPRESS ONLINE; Index created. SQL9 alter index I_COMP_T1 REBUILD ONLINE; Index altered. details in : http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=159063.1 Deepak --- Charlie Mengler [EMAIL PROTECTED] wrote: FWIW - At least for Solaris patchset V9.0.1.2 is available. I'm actually in the process of completing an install on a test instance as I type this response. HAND! Larry Elkins wrote: Steve, The two commands don't work for me on 8.1.7.0.0 EE WIN2K FWIW, the two command *do* work for me on 9.0.1.1.1 EE WIN2K Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Charlie Mengler INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: EXPORT problem
Kevin, connect as internal and run @?/rdbms/admin/catproc and then try to export again .. Deepak PS: picked up off of ML --- Kevin Bass [EMAIL PROTECTED] wrote: UNIX help needed for sed multi-line pattern spaceI have just started working at a company and the database has never been backed up since it was created. I am now performing an EXPORT of the database and I am experiencing an EXPORT problem that I have never encountered. Has anyone encountered this problem? EXP-8: ORACLE error 1008 encountered ORA-01008: not all variables bound . . exporting table MP30_WTF EXP-8: ORACLE error 1008 encountered . . exporting table MP30_WUT EXP-8: ORACLE error 1008 encountered . . exporting table MP30_WUT EXP-8: ORACLE error 1008 encountered . . exporting table MP30_WUT EXP-8: ORACLE error 1008 encountered ORA-01008: not all variables bound . . exporting table MP30_WUX EXP-8: ORACLE error 1008 encountered ORA-01008: not all variables bound . . exporting table MP30_XAE . . . Kevin __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: hide password
PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tirumala, Surendra INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tatireddy, Shrinivas (MED, Keane) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: real newbie question (i think)
Hi Rich am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? This depends on what kind of queries hit this table. If most of your queries hit columns other than the lob then you are justified in creating new table for the lob so you have a 1-to-1 relationship between your original and lob table. obviously in order to tie your records of the lob table with the original table, include the pk of ur original table in the lob table and make it a FK pointing to the original table. having said that, note that clob/blob is inline storage for data less than 250K (or some thing). Beyond that # the data will get stored outside in the lob tablespace you specified. and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change Does the foreign key creation stuff i wrote above answer this question. If not, please elaborate by what you mean by the new column should reflect change Deepak --- Rich Davidson [EMAIL PROTECTED] wrote: hey all, i'm in your typical situation of we don't need a dba...oracle is an app so the bizapps guy can handle itright...now to reality. there is a column in our database (oracle is the back end of our crm package) that is defined as a long and they want to do keyword searches on it. i've found out that you can't use type long in a where clause. i guess i have a few questions and i'm going to assume the answers (if anyone answers...please oh please do) will be a matter of opinion. am i better off creating a new column in the existing table of the type clob or blob? should i create a new table to store this data? and what would be my best way to keep these columns in sync...every time someone updated the long column i would want my new column updated to reflect the change. right now we're on 8.0.6/win 2k...but could upgrade to 8.1.7 (means upgrading our crm package too) if it makes this process easier. thanks in advance for the help and not being a dba i hope what i wrote makes sense! *:-.,_,.-:*'``'*:-.,_,.-:*'``'*:-.,_,.-: rich davidson dynamicsoft Inc. east hanover, nj [EMAIL PROTECTED] t. +1-973-503-6169 f. +1-973-952-5050 __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
money for one; Deepak PS: enterprize has bunch of more features than standard including tspitr support and partitions.. for more check out technet.oracle.com --- grace [EMAIL PROTECTED] wrote: hi gurus, wat's the difference of 8i ias standard and enterprise? Best regards, Grace Lim Suy Sing Comm'l Corp. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: grace INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: lack of memory
Edward, how about checking your processes parameter and then multiplying that # with your sort area size .. thats would give you a good idea about the size of your PGA .. also i guess there is a 250 K overhead per connection so you need to add that as well. for more accurate information, yopu could run a pmap for all local connections (connection coming from app) and then grep for the value besides the stack label to get exact PGA on a per connection basis. This assumes you are on unix..how big is your SGA? Deepak --- Edward Shevtsov [EMAIL PROTECTED] wrote: Connor, thanks for the reply. I'd thought about it. Unfortunately, it's quite difficult to catch the difference as number of users is not constant and they do different job (oltp queries, big reports). Thanks, Ed (Of course depending on the app), its seems odd that 4G is insufficient for 400 users. Maybe start having a look at the uga/pga stats for connected sessions and seeing what this adds up to. hth connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: lack of memory
Edward, why you thinking of going MTS route to support just 400-500 users. On 4GB like you have, i can support 2000+ users (non-mts) with no problems .. most of the boxes are E-450's, 4500's Deepak --- Connor McDonald [EMAIL PROTECTED] wrote: (Of course depending on the app), its seems odd that 4G is insufficient for 400 users. Maybe start having a look at the uga/pga stats for connected sessions and seeing what this adds up to. hth connor --- Edward Shevtsov [EMAIL PROTECTED] wrote: Hi List, We use a server with 4Gb memory on Linux kernel 2.2.19, Oracle 8.1.7.0 dedicated mode. It's an OLTP system with about 450 users. About 2 months ago I initiated gradual migration of our sql code to use bind variables instead of literals because we had problems with shared pool's fragmentation and strong contention on shared pool and library cache latches. The 90% of sql is accumulated on the client side (BDE+Delphi). I cut 150M from shared pool and planned cut it down further as we get results from the migration. Despite that now we have lack of memory. It seems now user processes consume more memory. We can't increase memory because of limitations on kernel 2.2. In general Is there any significant difference in terms of memory consumtion between a user process that uses bind variables and another one that uses literals? Does anyone use 8.1.7, MTS mode on Linux for a system with similar loading (400-500 users). Is that stable enough?. I have doubts. Please help. Regards, Ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Edward Shevtsov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) Some days you're the pigeon, some days you're the statue __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
standard VS enterprize
someone earlier wanted this information .. check out http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOTp_id=112591.1 Deepak __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: create database scripts v8.0.6 8.1.7
lol .. john by no i meant no u dont need to modify db creation scripts .. my bad .. maybe i should have articulated a bit clearly .. i guess it was 2 late when i replied.. lol thx for your reply all the same. Deepak (counting .. just 3 more days for friday;) --- John Kanagaraj [EMAIL PROTECTED] wrote: Deepak/Sujatha, I see no reason why the same script should not work as long as it is limited to CREATE DATABASE/CREATE or ALTER TABLESPACE commands. (I believe that was the original question). However, dependencies such as parameters in init.ora (compatible, _system_trig_enabled, etc. come to mind) need to be compatible to the current version... Hth, John Kanagaraj Oracle Applications DBA DBSoft Inc (W): 408-970-7002 Listen to great commercial-free christian music 24x7 at www.klove.com ** The opinions and statements above are entirely my own and not those of my employer or clients ** -Original Message- From: Deepak Thapliyal [mailto:[EMAIL PROTECTED]] Sent: Monday, November 12, 2001 10:25 PM To: Multiple recipients of list ORACLE-L Subject: Re: create database scripts v8.0.6 8.1.7 no --- Sujatha Madan [EMAIL PROTECTED] wrote: Hi, If I have a create database script which I've used with v8.0.6, would I be able to use these same scripts in v8.1.7??? ... or are there any modifications to be made. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Kanagaraj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: We need the help from Oracle DBAs.
information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: How to identify processes that cause ORA-4030 errors
Rajendra The best advise for avoiding this would be to have thorough knowledge of your application SQL by performing detailed sql trace analysis and ensuring that statements are shared and use bind variables. The tkprof process is painfull but will help in long run .. its much better than a blind chase .. thats for sure! Also consider compartmentalizing ur shared pool by using the reserved pool feature, especially for large application packages and procedures. You also consider using ABORTED_REQUEST_THRESHOLD procedure from the dbms_shared_pool package to localize the effect of 4030 errors. (search ML more for details of this proc) Deepak PS: in case u are in the dark about what is causing 4030 errors and want to perform diagnostics .. consider setting the event 4030 at ur init level. This will basically generate a trace dump whenever you encounter this error. --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: How does one identify the processes that will (likely) cause these errors? I am running 9i, 16G RAM, 700M SGA. Due to a bunch of these errors we had a system crash last week. So I want to put in a monitoring process that will identify the process, sql it is executing at that time. Other than just selecting from v$sesstat is there anything else that I can monitor? Will statspack help in this issue? I haven't used it yet, but about to install on my database. Thanks in advance Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art ! *1 This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you. *1 __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Reset SID
are you talking about a case of registering sid with same names but diff dbid's .. there is a commandline rman command that makes a call to a rman proc and accepts sid before registering Deepak --- Ken Janusz [EMAIL PROTECTED] wrote: How do I go about resetting the SID for another DB? I can only find the command for RMAN which doesn't work at the SQLPLUS command line. Thanks, Ken Janusz, CPIM Database Conversion Lead Sufficient System, Inc. Minneapolis, MN -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ken Janusz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Next extent problem
check the value of pctincrease for your table from user_tables/dba_tables. note that the default pctincrease for tablespace is 50. my guess pctincrease value fo your table is non-zero alternatively, the size might be attributed to the fact that oracle rounds the number of blocks that make up the extent. i forget what that is .. my tired brain cells tell me that its something like 5 blocks or so . Deepak --- Gene Gurevich [EMAIL PROTECTED] wrote: Hi. I have two tables in my database. They both have the NEXT_EXTENT set to 512K for a long time. Yet all the extents for these tables are either 16 or 24K. I have checked the next extent sessing once and again and it has always shown 512K. The tables are not being truncated. Why would Oracle create the new extents with different size? Is there any other place I need to check? thanks for any input Gene = __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Gurevich INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: urgent help needed conversion
Jeroen it might indicate that your batch program is busy and doing stuff. the wait event you have mentioned is a idle wait event. In your next run, i would recommend that have breakpoints coded in the batch that writes into a error/log table about status and where the pgm has reached. also write a commit after u insert into the log table; are there any locking issues going on. take entire dump of wait/p1, p2, p3 from v$session_wait where wait=0(waiting) and post it Deepak --- Jeroen van Sluisdam [EMAIL PROTECTED] wrote: Hi, I'm in the middle of a conversion and something is holding the conversion program: v$session_wait: Enter value for sid: 285 SUBSTR(EVENT,1,20) SUBSTR(P1TEXT,1,30) SUBSTR(P2TEXT,1,20) -- SUBSTR(P3TEXT,1,30)STATE -- --- SQL*Net message from driver id #bytes WAITING This program is a batch program and not waiting for any user commands any ideas asap will be appreciated! Tia, Jeroen 7..3.4 hp ux 10.20 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeroen van Sluisdam INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: latch wait
Paul , try joining the v$session with v$sqlarea to find offending sql harassing the cache buffers chains.. here is a sample sql u could use .. select sql_text from v$sqlarea, v$session where v$sqlarea.address= v$session.sql_address and v$sqlarea.hash_value = v$session.sql_hash_value and sid='Your Sid From V$session wait for latch#66'; find the offending sql and tune it .. cache buffer chains latch means that your SQL is badly written and is performing a considerably higher # of LIO's .. explian plan the sql and see if you can use indexes .. also analyze your table and indexes .. post dump from v$session wait for wait=0 (waiting state) .. so other list members an give you more suggestions Deepak --- Gogala, Mladen [EMAIL PROTECTED] wrote: Try v$latch_children -Original Message- Sent: Monday, November 12, 2001 2:30 PM To: Multiple recipients of list ORACLE-L I have a puzzling problem: a session is apparently waiting on a cache buffers chains latch forever (well, for 40 minutes and counting, so far); seq# in v$session_wait is static. tries is 0. latch free address C4708BC0 number 66 tries 0 00 When examining the latch in question (using the address from v$session_wait.p1raw), I'm not seeing any change in the get, misses, etc. statistics. It's as though a process has the latch and won't let go. Any ideas from the list as to where I look next? TIA, Paul Baumgartel __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Paul Baumgartel INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Deadlocks ORA-60
Tony, the trace files generally have the SQL that were invloved in the deadlock. We had a situation a while ago and we traced the SQL to a stored procedure that was issuing commit at the very last step. Putting a commit solved the situation in our case without affecting the integrity of data manipulated by the proc. see if that helps you.. Deepak --- Tony Vecchiet [EMAIL PROTECTED] wrote: Occasionally we get ORA-60 in our alert log and it generates a trace file. Does anyone have a good method of interpreting the trace file and finding the root cause? RDBMS 8.1.6.2 thanks begin:vcard n:Vecchiet;Tony tel;fax:408.377.3153 tel;work:408.879.4771 x-mozilla-html:FALSE org:Xilinx, Inc adr:;;2100 Logic Drive;San Jose;CA;95124;USA version:2.1 email;internet:[EMAIL PROTECTED] title:Manager, Oracle Database Group x-mozilla-cpt:;14432 fn:Tony Vecchiet end:vcard __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: create database scripts v8.0.6 8.1.7
no --- Sujatha Madan [EMAIL PROTECTED] wrote: Hi, If I have a create database script which I've used with v8.0.6, would I be able to use these same scripts in v8.1.7??? ... or are there any modifications to be made. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find the one for you at Yahoo! Personals http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Another Oracle DBA gets The Bullet in the UK - Seeking an Oracle
a way cut more than the 5%. Did I mention it's brutal? That said, had my first interview in two, maybe three, months today. Actually sounds promising, like there's really a position to fill, and they're really hiring. Been out since July, and the kids would REALLY like to eat again. Will keep you informed. Yosi ). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Don Granaman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-04030 - Is it CLOB problem?
prasad go to ML and search for : Shared pool fragmentation and dbms_shared_pool package Deepak --- Prasad BAV [EMAIL PROTECTED] wrote: Hi List, We are using Oracle 8.1.7 on Windows 2000. System RAM is 3GB. We are using 1.5GB of SGA. System is 1GHz processor. We are getting sometimes problem with the error ORA-04030. Our DBA says this is the problem because of bug with Oracle 8.1.7 in Windows 2000 with CLOB datatype. We have developed our application with lot of CLOB usage. Is that true? Do we have an alternative to avoid that error? Or do we have to change the data type? Please suggest us. Thanks in advance, Regards, Prasad BAV. __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Prasad BAV INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HP-UX 11/8.1.6/Cache Buffers Chains
try steve adams ixora.com --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Where can I find definitive information about the 'cache buffers chains' latch? The 'statsrep' report from Statspack shows this... Get Spin Latch Name Requests Misses Sleeps Sleeps 1-4 --- -- - cache buffers chains1,861,232,551 14,888,739 28,424 14861067/26993/631/48/0 ...as the top latch sleeper and I'm wondering what to do about it. This is a data mart instance. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HP-UX 11/8.1.6/Cache Buffers Chains
try steve adams ixora.com --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Where can I find definitive information about the 'cache buffers chains' latch? The 'statsrep' report from Statspack shows this... Get Spin Latch Name Requests Misses Sleeps Sleeps 1-4 --- -- - cache buffers chains1,861,232,551 14,888,739 28,424 14861067/26993/631/48/0 ...as the top latch sleeper and I'm wondering what to do about it. This is a data mart instance. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: index size calculation
we generally go for 50% tablesize for indexes .. works for most of our medium sized game databases. for very large tables .. i go with 20% sise of table per index Deepak --- Ron Rogers [EMAIL PROTECTED] wrote: Greg, I usually insist on that information from the development group then I can charge it off to their budget when it expands beyond the original space. Seriously, I build a table and indexes with init and next the DBBLOCK size and load a controlled amount of data. That will give you a good starting point for quesstimating the space requirements over the provected life of the project. I used the dbblock size to eliminate Oracle rounding up to even blocks. ROR mª¿ªm [EMAIL PROTECTED] 11/09/01 02:56PM Hi All! I need to calculate/estimate index size for database. In 8.0.5 I used formula from Administrator Guide to calculate index size. Now this formula was removed because of it accuracy (see Metalink). Does some one has formula for 8i ? Thanks. Greg. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Faktor INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: blowing out rollbacks on select statements?
1000 Nick 500 Pete 400 Dave 2000 SQL SELECT t.xidusn, t.used_ublk, s.username, l.type 2 FROM v$transaction t, v$session s, v$lock l 3 WHERE t.ses_addr=s.saddr AND s.sid = l.sid ; no rows selected SQL SELECT * FROM scott.emp@suppaix1_v805; ENAME SALARY -- -- Mike 1000 Nick 500 Pete 400 Dave 2000 SQL SELECT t.xidusn, t.used_ublk, s.username, l.type 2 FROM v$transaction t, v$session s, v$lock l 3 WHERE t.ses_addr=s.saddr AND s.sid = l.sid 4 / XIDUSN USED_UBLK USERNAME TYPE -- -- - 3 1 SCOTT TX SQL COMMIT; Commit complete. SQL SELECT t.xidusn, t.used_ublk 2 FROM v$transaction t, v$session s 3 WHERE t.ses_addr=s.saddr AND s.username='SYSTEM' 4 / no rows selected --- Doug C [EMAIL PROTECTED] wrote: This is Oracle 8.1.7 - Unless I'm getting bad information, a developer has passed me some queries that use a database link in them. They are select queries, albeit complicated ones with lot of outer joins and such. Both db's are 8i but I think the remote db is 8.1.6.Getting snapshot too old : roolback segment number whatever is too small. To me that means, that the select query is going after tables that are in the middle of being udpdated and losing there ability to find a consistent image before they are done. So, either the quries are just plum taking too much information and time and another transaction that I have no control over is busy updating the tables at the same time.. Agree? - Doug -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = ENG. Christian Trassens Senior DBA [EMAIL PROTECTED] [EMAIL PROTECTED] Phone : +34-699240979 +34-649824704 __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Doug C INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: HP-UX 11/8.1.6/Cache Buffers Chains
try steve adams ixora.com --- Vergara, Michael (TEM) [EMAIL PROTECTED] wrote: Where can I find definitive information about the 'cache buffers chains' latch? The 'statsrep' report from Statspack shows this... Get Spin Latch Name Requests Misses Sleeps Sleeps 1-4 --- -- - cache buffers chains1,861,232,551 14,888,739 28,424 14861067/26993/631/48/0 ...as the top latch sleeper and I'm wondering what to do about it. This is a data mart instance. Thanks, Mike --- === Michael P. Vergara Oracle DBA Guidant Corporation (909) 914-2304 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vergara, Michael (TEM) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Startup error
for solaris the soln is to bum up semmns parameter. --- Sujatha Madan [EMAIL PROTECTED] wrote: Hi, I created a database (8.0.6 - HP-UX 11) and then I changed the processes parameter to 100 (initial value was 50). I then tried to start the database and I get the following error: SVRMGR startup ORA-07279: spcre: semget error, unable to get first semaphore set. HP-UX Error: 28: No space left on device Additional information: 1 SVRMGR Could someones please tell me what this means and how I should fix it. Thanks Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Find a job, post your resume. http://careers.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 7 documentation - Good One
no offense.. just a sincere question. are people still using o7 out there? talking to oracle support regarding ECS must a be real pain in the butt as i guess they might have stopped supplying patches for o7. in our shop people are jittery continuing on 816 as its de-supported from TODAY (officially with no ECS support .. just workarounds) and we are thinking of hopping on 817 until 9.2 or 9.3 is released and proves stable just some thoughts... as i was pleasently surprised looking the the hits the o7 doc thread has recieved Deepak PS: ok now no holy war here please; --- Eric D. Pierce [EMAIL PROTECTED] wrote: Are you sure? I wasted time trying to find some minor documentation (platform specific release notes?) there a while ago, and after complaining that I couldn't find it, others said everything *isn't* there. Frustrating considering that they have a huge number of CD packs etc that appear to be small incrementals. It does appear that all the major documentation is there. brgrds, ep ORACLE-L Digest -- Volume 2001, Number 304 -- From: [EMAIL PROTECTED] Date: Tue, 30 Oct 2001 09:21:35 -0800 Subject: RE: Oracle 7 documentation - Good One Thanks for sharing this! Finally, complete documentation for Oracle 7 on. ... ---original--- | Dear All, | I hit upon this site. I thought its worth sharing | http://docs.oracle.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eric D. Pierce INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: 11.5.4 Easy Question (?)
search ML on db hang states they recommend taking system and process state dumps in such situations. did not work in our case one time where we had a situation where even internal connection was refused. no freakin error in alert or bdump. finally ended up having to kill pmon and other oracle processes at unix level. the bad part is we never found what hit us, the good part is it has not happened again so far; Deepak PS: and this was the main customer database that allows access to our site; --- Bellows, Bambi [EMAIL PROTECTED] wrote: The error is that the database login failed. There is nothing in the bdump alert log of any interest and no entries whatsoever in the tns alert log or in $APPLLOG. No clue where to look for Apache stuff... Bambi. -Original Message- Sent: Wednesday, October 31, 2001 4:41 PM To: Multiple recipients of list ORACLE-L What exactly happens? What is the problem? Anything in the log files for Oracle, listener, OS, Apache? -Original Message- Sent: Wednesday, October 31, 2001 4:55 PM To: Multiple recipients of list ORACLE-L Friends -- Our pesky users are having problems logging on from the Web front end of Oracle Financials. This was working just fine 10/25 when the last pesky user successfully logged in. Since then, the box (Tru64 v5.1) has been bounced, and we have started the following scripts successfully... 1) addbctl.sh (database startup) 2) addlnctl.sh (listener startup... you'd think Oracle would use its own conventions, wouldn't you?) 3) adalnctl.sh (applications listener) 4) adcmctl.sh (concurrent manager startup) 5) adrepctl.sh (reports server) 6) adfrmctl.sh (forms server) 7) adtcfctl.start (tcf sockets) 8) adapcctl.sh (Apache web process) 9) adfmsctl.sh (forms metric server) 10) adfmcctl.sh (forms metric client) I figure if the database is up, the listeners are up and concurrent manager is up, everything should be fine. What am I missing? TIA! Bambi. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gogala, Mladen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bellows, Bambi INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ITL, DELAYED BLOCK CLEANOUT
is this page still available or has been moved. I got an error trying to access the link Thx Deepak --- K Gopalakrishnan [EMAIL PROTECTED] wrote: Hi, The document is a draft copy. There are few (not much tech) errors. So take that with a pinch of salt Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Gopalakrishnan Sent: Monday, October 29, 2001 9:40 AM To: Multiple recipients of list ORACLE-L Vladimir, Have a look at http://www.geocities.com/kgkrish/transactions.html This will solve most of your questions. If not Pls let me know. Thanks Best Regards, K Gopalakrishnan Bangalore, INDIA + (91) 98451 78868 -Original Message- Barac - posao Sent: Monday, October 29, 2001 6:25 AM To: Multiple recipients of list ORACLE-L Just curious... Could someone shed some light on INTERESTED TRANSACTIONS LIST and DELAYED BLOCK CLEANOUT? Thanks __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re:
can you be more specific. Is your question about data modelling or creating databases? --- Saravana Kumar [EMAIL PROTECTED] wrote: Hi friends, Can anyone help me in giving me a checklist to design a database. Thank U in advance regards Saravana. __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Location of PLAN_TABLE
how about -- set autot [trace] [traceonly] Deepak PS: as they say: works for me; --- Rao, Maheswara [EMAIL PROTECTED] wrote: We keep plan table in each of the developers schema and thus there is no problem of deletions and maintenance of this table. Also, this is not such an important table for DBA maintenance. Rao -Original Message- Sent: Monday, October 29, 2001 12:05 PM To: Multiple recipients of list ORACLE-L Rather a trivial question, but our DBA team is discussing how best to implement the location of the plan table. My preference is is simply create is as SYS, public synonym, and grant privs on it to our developers. I'm being outvoted by the others, who want to create it in each and every application schema, but still grant access to all developers with no synonyms, the thinking being, that it would help to minimize accidental deletions of execution plans and so forth. My belief is that's simply over-thinking this issue. What do you do at your sites? Thanks. Jeffery D Thomas DBA Thomson Information Services Thomson multimedia Inc. Email: [EMAIL PROTECTED] DBA Quickplace: http://gkmqp.tce.com/tis_dba http://gkmqp.tce.com/tis_dba __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Root to connect as system
Looks like your oracle sid is set incorrectly and you are trying to connect without using a tns service name Deepak PS: have you set the env variables .. type env at the unix prompt and check if PATH /ORACLE_HOME/ LD_LIBRARY_PATH are set correctly --- Sujatha Madan [EMAIL PROTECTED] wrote: Hi, How can I allow root to connect to the database as system. At the moment when I try this, I keep getting a ORA-01034: Oracle not available error, even though the database is up and running fine. Regards, Sujatha -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sujatha Madan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: v$sql and v$sqlarea
check out V$FIXED_VIEW_DEFINITION --- Greg Moore [EMAIL PROTECTED] wrote: I want to understand the difference between v$sql and v$sqlarea. Apparently they are both views of the same x$ table. Does anyone know where I can view the code that creates these two views? Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Java in the database
feels good to be re-assured .. even if its a friday. anyways with the .com bubble burst, java seems back in the coffe pot for now at least. hope pl/sql is around too; Deepak --- Christopher Spence [EMAIL PROTECTED] wrote: Actually I believe it will be, in 9i they clearly made some improvements (very notable ones) in PL/SQL. I would suspect it will be around for a while. Do not criticize someone until you walked a mile in their shoes, that way when you criticize them, you are a mile a way and have their shoes. Christopher R. Spence Oracle DBA Phone: (978) 322-5744 Fax:(707) 885-2275 Fuelspot 73 Princeton Street North, Chelmsford 01863 -Original Message- Sent: Thursday, October 25, 2001 2:23 PM To: Multiple recipients of list ORACLE-L Still PL/SQL. Hope, it will be supported long enough. (till my retirement? :) Igor Neyman, OCP DBA Perceptron, Inc. (734)414-4627 [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, October 25, 2001 1:16 PM Out of curiosity, is anyone using the java engine for procedural code, or are most people still using PL/SQL? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services| Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Christopher Spence INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: backup of large databases
We use rman with veritas netbackup. generally schedule backup everyday .. (incremental) and weekly full backups .. backups run in night time and pump data into tapes located on east for databases located in east coast data center and tape libraries on west for other set of db's located in west data center Deepak --- Richard Ji [EMAIL PROTECTED] wrote: We are using RMAN with EDM doing BCV copy of the database. [EMAIL PROTECTED] 10/26/01 02:51PM Hello, I'm curious how people handle the backups for large/very large databases; 200gb or greater. My questions are not targeted towards any specific hardware platform, but we are using Oracle 8.1.7. I'm assuming that archiving is enabled. Are backups done nightly, or because of time constraints are they done weekly ? If weekly, do you feel comfortable having to possibly apply a week of archives, in the case of a recovery ? Do you use disk or tape ? Do you use RMAN or other backup tools ? What are the customer's expections for recovery and how do they effect your backup strategy ? I appreciate your input. ed -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Richard Ji INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Execution time for export/import vs. alter table move tablespace command
you can tweak export import better i feel as move does not give you too many options. we recently did a export of ~60Gb that took us about 45 minutes to complete. This speed was mainly due to hacking of parameters like buffer etc. however this was on a high end sun box(not 10K) .. ymmv Deepak --- [EMAIL PROTECTED] wrote: I am doing a cost justification for upgrading a data warehouse from 8.0.4 to 8.1.7. I need to submit it today and don't have time to do a test on a very large table. Does anyone have anecdotal evidence or experience in the time difference required to reorg a tablespace using the export/import table method versus alter table move to a new tablespace method? Thanks for any time quotes you can provide. I'm especially interested in very large tables and tablespaces. Thanks, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: i need check fragmentation of index
hi @lex one of the good ways to check this is to do a analyze index .. validate structure and look at the statistics from index_stats Deepak --- Alexander Ordonez [EMAIL PROTECTED] wrote: hi gurus, how check the fragmentation on index...?? ahy idea??? please i need your help!! @lex Lic. Alexander Ordóñez Arroyo Caja Costarricense del Seguro Social Soporte Técnico - División de Informática Telefono: 295-2004, San José, Costa Rica [EMAIL PROTECTED]Icq# 30173325 The true is out there in WWW -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alexander Ordonez INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: v$sqlarea statistics
Binay, from what i understand, these type of block reads relate to read consistancy .. meaning that if oracle wants to read block x but it finds that it is dirty , it reads from the rollback segments to give you the point in time snapshot as it existed at the time when you had first started the query. e.g. u fire query at 12.00 and if at 12.05, someone changes a block and commits. Now at 12.10 your query is still executing and it requests the above block, oracle will attempt to read it from the rbs , therby resulting in a consistent read. a current mode read on the other is a direct read off of the buffer cache. correct me if i am wrong here guys? Thx Deepak --- [EMAIL PROTECTED] wrote: Hi Deepak, Can you elaborate what is consistent gets - Eric, here's a high level from my understanding on this issue: Buffer gets {also called Logical IO's} These happen as oracle scans blocks of data in the buffercache(in-mem scans). Many people believe that since these are memory reads, they are inexpensive. I have seen the contrary in many cases and have seen that these are the ones which take the most cpu clycles, therby making your system CPU Bound. Resolution of this is to tune your sql by having it use better access paths (indexes). Also consider de-norming in ordr to avoid too many joins I consider this the most important metrics in identifying bad SQL. i have seen cases where frequently executed queries were performing millions of LIO's and hosing up the CPU. A simple index / or Adding hint can reduce this number by a very high factor resulting in great gains. DiskReads {also called physical IO's) This obviously means that there are a lot of disk reads required to satisfy your query. Reasons: maybe you are using ineffcient access paths/bad sql or u just have insuffient (small) memory to support your app. High Diskreads is the reason that makes your system IO bound. Resolution is again the same as described above. In addition, one of the assumtions here is that you have spread your datafiles/logs/cf optimally. Also consider using the recycle buffer pool feature to avoid an innocent FTS from flushing everything from your cache. Obviously you cannot always prevent any of these and some disk read are inevitable. hth Deepak: --- Erik Williams [EMAIL PROTECTED] wrote: I am trying to identify the most harmful statements in an application. From the Oracle Performance and Tuning Tips and Techniques book, I found two statements. Both are looking at the statements contained in the v$sqlarea. The first looks at statements with a high number of buffer gets and the other looks at the statements with a high number of disk reads. Some of the statements appear in both lists, but some in only one. If all of the disk reads are moving blocks into the buffer cache, what is the difference between the two measures? Can anyone explain the difference between the two measures? Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). --- The contents of this e-mail are confidential to the ordinary user of the e-mail address to which it was addressed and may also be privileged. If you are not the addressee of this e-mail you should not copy, forward, disclose or otherwise use it or any part of it in any form whatsoever. If you have received this e-mail in error please notify us
Re: Please help! Recover a database on another server
why does he need a backup control file? this appears to be a straightforward case of moving databases(i mean restoring to a new host). does not look like they have done structural changes or things like that. ron do you use rman? if not then someone earlier suggested taking the datafiles off of the backup mode using the end backup command. see if that works for you. Deepak --- Rachel Carmichael [EMAIL PROTECTED] wrote: the key is when did you create the backup controlfile? Try using a backup controlfile as opposed to a copy of the controlfile. yes, there is a difference. --- Smith, Ron L. [EMAIL PROTECTED] wrote: We are trying to recover a database to another server. The backup was a hot backup. The files are all copied to the new server, along with the archive log that was created a few seconds after the hot backup was run. We bring the database up and apply the archive log and Oracle says recovery complete. We then do an alter database open resetlogs. At this point Oracle says the System file needs more recovery. Oracle said the recovery was complete! Why is it saying the system file needs more recovery? Any ideas? Thanks! Ron Smith Database Administrator [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: [Q] what difference between count(0), count(1) and count(*)
i think count(*) gives count of all columns .. where as count(col1) gives count for col1 ignoring nulls in col1 Deepak --- aaa aaa [EMAIL PROTECTED] wrote: Can anyone tell me what is difference between : select count(*) ... from .. select count(0) ... select coun (1) ... select count(2) ... Thanks. _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: aaa aaa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Please help! Recover a database on another server
, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Can I add redo log group diffrent from
Seema, so long as you dont drop the current log you are fine:) adding logs will have zero impact in terms of db impact or availabilty. One of the things you could do is immediately take a backup of your control file just in case; Deepak --- Seema Singh [EMAIL PROTECTED] wrote: Hi My redo log group# is 5,6,7.If I want to add more redo log group then Can I add group#9? As far I know there will be not impact on Database but let me know group view please. Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Statspack Question
i would probably first use v$sqlarea instead of v$sql to be able to identify the hash values for bad ones(high lio's) and then probe v$sql using the same. Deepak --- Greg Moore [EMAIL PROTECTED] wrote: so long as you look at the wait events, you will be looking at your database's bottlenecks, and in the world of Oracle Performance Tuning, that is all that counts. What about v$sql? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: v$sqlarea statistics
Eric, here's a high level from my understanding on this issue: Buffer gets {also called Logical IO's} These happen as oracle scans blocks of data in the buffercache(in-mem scans). Many people believe that since these are memory reads, they are inexpensive. I have seen the contrary in many cases and have seen that these are the ones which take the most cpu clycles, therby making your system CPU Bound. Resolution of this is to tune your sql by having it use better access paths (indexes). Also consider de-norming in ordr to avoid too many joins I consider this the most important metrics in identifying bad SQL. i have seen cases where frequently executed queries were performing millions of LIO's and hosing up the CPU. A simple index / or Adding hint can reduce this number by a very high factor resulting in great gains. DiskReads {also called physical IO's) This obviously means that there are a lot of disk reads required to satisfy your query. Reasons: maybe you are using ineffcient access paths/bad sql or u just have insuffient (small) memory to support your app. High Diskreads is the reason that makes your system IO bound. Resolution is again the same as described above. In addition, one of the assumtions here is that you have spread your datafiles/logs/cf optimally. Also consider using the recycle buffer pool feature to avoid an innocent FTS from flushing everything from your cache. Obviously you cannot always prevent any of these and some disk read are inevitable. hth Deepak: --- Erik Williams [EMAIL PROTECTED] wrote: I am trying to identify the most harmful statements in an application. From the Oracle Performance and Tuning Tips and Techniques book, I found two statements. Both are looking at the statements contained in the v$sqlarea. The first looks at statements with a high number of buffer gets and the other looks at the statements with a high number of disk reads. Some of the statements appear in both lists, but some in only one. If all of the disk reads are moving blocks into the buffer cache, what is the difference between the two measures? Can anyone explain the difference between the two measures? Thanks. Erik -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Erik Williams INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN HOTBACKUP AUTOMATED SCRIPT
* # * * # *** echo $EXECRMAN_LOG cat $WORKFILE_LOGFILE $EXECRMAN_LOG echo $EXECRMAN_LOG echo RMAN STATUS: $STATUS $EXECRMAN_LOG echo $EXECRMAN_LOG echo $EXECRMAN_LOG echo RMAN Restore Start Time:$START_DATE $EXECRMAN_LOG echo $EXECRMAN_LOG echo RMAN Restore End Time:\t`date` $EXECRMAN_LOG echo $EXECRMAN_LOG # *** # * * # * IF ORACLE ERRORS (ORA-X) OR CRITICAL RMAN ERRORS WERE ENCOUNTERED * # * DURING THE EXECUTION OF THE RESTORE. IN EITHER CASE, THE OUTPUT SHOULD * # * BE SENT TO THE RMAN LOG AND SENT TO THE NOTIFICATION GROUP. * # * * # *** sync;sync;sync; egrep -i ORA-|error message stack|RMAN-00569|error occurred $EXECRMAN_LOG /dev/null 21 if [ $? = 0 ]; then RMAN_SUBJECT=Error occurred on $HOSTID for $ORACLE_SID!! (see $EXECRMAN_LOG) cat $EXECRMAN_LOG | $SENDALERT -s $RMAN_SUBJECT -n $RMAN_NOTIFY exit -1 else RMAN_SUBJECT=$HOSTID RMAN RESTORE Summary FOR $ORACLE_SID cat $EXECRMAN_LOG | $SENDALERT -s $RMAN_SUBJECT -n $RMAN_NOTIFY exit 0 fi # # * * # * Log Files Used By Wrapper $LOG_BASE (/opt/oracle/product/admin/sql/rman/log) * # * * # * EXECRMAN_LOG : Main Log File for Wrapper {Not Deleted} * # * WORKFILE_LOGFILE : RMAN Batch Mode Log File {Not Deleted} * # * WORKFILE_MULTI_CALLS : Multiple Instance Detector {Deleted if success} * # * * # --- Seema Singh [EMAIL PROTECTED] wrote: Hi Can some one send me automated RMAN backup scripts please? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Seema Singh INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Droping System User
Hi, your error more resembles a media failure than anything else. Check the status column from v$datafile. since this is the system datafile u seem to have lost,you would need a closed full db recovery .. i.e. is you care to recover your test db :) Deepak PS: did you delete the system datafile instead of the system user? --- Nirmal Kumar Muthu Kumaran [EMAIL PROTECTED] wrote: hi I took risk in my test DB by dropping the user 'SYSTEM'. As you tested, the same steps i repeated in mine, all are fine, until before. Now i shutdown my database and startup again, here the problem arises. Oracle mount the database but while opening the database, the instance has been terminated by PMON. Sat Oct 20 10:57:45 2001 PMON: terminating instance due to error 470 Instance terminated by PMON, pid = 316 Oracle posted the following error continuosly in the alert log: SMON: following errors trapped and ignored: ORA-00376: file 1 cannot be read at this time ORA-01110: data file 1: 'D:\ORACLE\ORADATA\ORCLSVR\SYSTEM01.DBF' Am crusious, come to know what type of problem you have faced? Regards, Nirmal -Original Message- From: Jacques Kilchoer [SMTP:[EMAIL PROTECTED]] Sent: Friday, October 05, 2001 12:30 AM To: Multiple recipients of list ORACLE-L Subject:RE: Droping System User -Original Message- From: [EMAIL PROTECTED] [ mailto:[EMAIL PROTECTED]] Dropping the SYSTEM user is not really all that traumatic. In most cases it's just a DBA account that may own some pieces you'd rather not lose, but dropping SYSTEM will not be noticed by the users of the database. That's the impression I get. When I looked at the objects owned by SYSTEM in my test database before the drop, none of them seemed vital. On the other hand, dropping sys would probably be bad, but I wasn't able to do that (insufficient privileges.) Trying to drop sys tables like sys.user$ caused an ORA-00701. So since I'm on a quest to wound this database, I tried this: SQL delete from sys.user$ where name = 'SYS' ; 1 ligne supprimée. SQL commit ; Validation effectuée. So far no ill effects! __ Do You Yahoo!? Make a great connection at Yahoo! Personals. http://personals.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).