Instructions for transparent gateway..
Title: RE: Question related to security could someone please help me find instructions for installing and configuring 9.2 oracle transparent gateway on win2k for sql server?? appreciate it.Sunil Nookala Dell Corp.
RE: Number of joins in the query
If you are joining 'n' number of tables, you should have a minimum of 'n-1' joining conditions, otherwise it might result in cartesian product. Sunil Nookala Dell Corp. -Original Message- Sent: Thursday, February 27, 2003 10:29 AM To: Multiple recipients of list ORACLE-L Two! PK on stn_rstcn_to_frm? T'would be clearer if you presented your problem as tables a, b, c, rather than getting us to struggle through all these stns... peter -Original Message- [mailto:[EMAIL PROTECTED] Sent: 27 February 2003 14:59 To: Multiple recipients of list ORACLE-L Dear List, I have a basic doubt about the number of joins I should have. Say, I have three tables by name station, station_restriction and stn_rstcn_to_frm with the following structure: StationStation_restriction stn_rstcn_to_frm -- - stn_key(PK) stn_rstcn_key(PK)stn_rstcn_key(FK) station_code stn_key(FK) stn_key(FK) station_namerestricted_position country If I have to select data from all the three tables should I have two joins or three joins? If I have two joins, I would have Station.stn_key=Station_restriction.stn_key and Station_restriction.stn_rstcn_key = stn_rstcn_to_frm.stn_rstcn_key. If I have three joins I would have Station.stn_key=Station_restriction.stn_key and Station_restriction.stn_rstcn_key = stn_rstcn_to_frm.stn_rstcn_key and Station.stn_key = stn_rstcn_to_frm.stn_key Can anybody let me know as to how many joins should I have so that I don't get any cartesian product in the result set? I am sorry if the question sounds trivial to someone but I got this basic doubt while writing a complex query for a multi-table join. Any help in this regard is very much appreciated. Thanks and Regards, Ranganath WARNING: The information in this message is confidential and may be legally privileged. It is intended solely for the addressee. Access to this message by anyone else is unauthorised. If you are not the intended recipient, any disclosure, copying, or distribution of the message, or any action or omission taken by you in reliance on it, is prohibited and may be unlawful. Please immediately contact the sender if you have received this message in error. Thank you. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Krishnaswamy, Ranganath INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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 e-mail message, and any files transmitted with it, are confidential and intended solely for the use of the addressee. If this message was not addressed to you, you have received it in error and any copying, distribution or other use of any part of it is strictly prohibited. Any views or opinions presented are solely those of the sender and do not necessarily represent those of the British Geological Survey. The security of e-mail communication cannot be guaranteed and the BGS accepts no liability for claims arising as a result of the use of this medium to transmit messages from or to the BGS. The BGS cannot accept any responsibility for viruses, so please scan all attachments.http://www.bgs.ac.uk * -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Robson, Peter INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -
Oracle version??
List, Can Oracle version be determined based on size of Oracle.EXE file on Windows? I am looking for a valid way of determining the patch level without having to log onto the database and check v$instance. appreciate any feedback. Sunil Nookala Dell Corp. Austin, TX. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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: Snapshot Too Old Error on Export !!!
Stephen, My understanding is having consistent=y uses no rollback, since the changes occurring during the export are not being captured in the export dump. on few occasions i've still got the spurious ora-1555(snap shot too old)error on exporting a 80GB highly transactional database which terminates the export. am i thinking wrong?? help!! Sunil Nookala DBA 3-4502 907-9255(pager) -Original Message- Sent: Friday, February 21, 2003 10:35 AM To: Multiple recipients of list ORACLE-L I would echo a previous post that you can't backup a database with the export utility. I suspect you get your error because you are using consistent=y in the export. The database is trying to give you data as of the time you started the export. The fact that you are getting the snapshot too old message is evidence that the data is changing while you are exporting -- to the extent that the database is eventually unable to keep doing it -- but these data changes will not be in the export file. A genuine backup using rman or the old alter tablespace begin backup method is the only "proper backup". If you are trying to get production data to move into a test/development database schema, then export is certainly the most convenient way of doing it. If you are, in fact, trying to backup the database, here is something to get you started. If the filesystem to which your export file is going is big enough, consider using that filesystem to store a database backup instead of an export. Assuming it is /where/it/goes, try the following: Make sure sys (or system, if you prefer) has been granted sysdba in the database. Create two files with text similar to the following: for file named backup_database.rcv: -- snip - run { allocate channel ch1 type disk format '/where/it/goes/%U_DATA'; set command id to 'rman'; backup tag backup_db_full (database include current controlfile); release channel ch1; } - snip -- This will backup the database. for file named backup_arch.rcv - snip run { allocate channel ch1 type disk format '/where/it/goes/%U_ARCH'; set command id to 'rman'; change archivelog all crosscheck; backup (archivelog all delete input); backup ***This line and the next if you are duplexing archived logs*** (archivelog like '/directory/where/duplexed/archivelogs/are/%' delete input); release channel ch1; allocate channel ch1 type disk format '/where/it/goes/%U_CONTROL'; backup current controlfile tag='backup'; release channel ch1; sql "ALTER DATABASE BACKUP CONTROLFILE TO ''/where/it/goes/CONTROL_FILE.BAK'' REUSE"; } snip This will backup the archived logs and the control file. Note that the last command tells the database to make a physical copy of the control file. The reason for this is that rman has been writing backup info to the control while the backup is running. So you make a copy of it after the backup has completed in case you lose all copies of your control files. If your database and all control files got completely blown away, you can copy the control file copy back to where it was and start restoring. You might note that I backup the control file ... and back it up ... and back it up. That's just paranoia. You can put the whole thing into one file. The reason for having them separate is in case you need to free up space in the archive_log_dest by backing up just the archived logs. To run a backup, type in the following commands: rman nocatalog connect target sys/[EMAIL PROTECTED] @backup_database.rcv @backup_arch.rcv exit Now, make sure you backup /where/it/goes directory to tape with whatever operating system backup utility you are using. One thing that can be added, if you want to be extra thorough, is to put in a log switch followed by an archive log current, after you run the archivelog backup. Then you run ANOTHER archivelog backup. In the world of Murphy's Law, you do it this way because your archive_log_dest will, some day, at the worst possible time, be unable to accommodate a log switch and archive log current. So you clean it out first prior to the log switch. It might be useful to know how to restore the database ... that's just something I saw written on a toilet stall wall. It seems reasonable. ("... He who reads these words of wit, eats those little balls of ... ") I think the subject is probably more extensive than can be covered in a simple e-mail; so I won't try to cover it all. But, in it's simplest form, a recovery looks like: If the last rman backup has been deleted from /where/it/goes, restore those files from tape. startup mount the database (assuming the control file is NOT the thing you are restoring) rman nocatalog connect target sys/[EMAIL PROTECTED] allocate channel ch1 type disk; restore database; restore archivelog all; recover database; release channel ch1; open the database. See, rman isn't so bad. It's biggest problem is that, i
RE: Count(*) last 30 seconds
Interestingly enough, I haven't seen an official statement on count(*) being slower than count(). Sunil Nookala DBA Dell Corp. -Original Message- Sent: Tuesday, February 11, 2003 11:09 AM To: Multiple recipients of list ORACLE-L Hi, 1. create unique index or primary key AND update statistics of the table 2. use count(1) instead of count(*) JP On Tuesday 11 February 2003 17:19, you wrote: > Hi list, > > I issue a select count(*) from mytable and last 30 seconds. > > The table has 1,466,196 records and were loaded with a batch process, so > they are in a countinous space. > > I consider that time exagerated. > > The TBS is LMT with a Uniform size of 128 MB. > > The block size is 8MB, version 9.2.0.1.0 in Windows 2000. > > Where should I start looking ??? > > TIA > > Ramon E. Estevez > [EMAIL PROTECTED] > 809-565-3121 -- Pruner Jan [EMAIL PROTECTED] http://jan.pruner.cz/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jan Pruner INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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: Slow SQL*Plus connect.
How big is the listener log file?? do you truncate/rename it on regular basis?? just a thought. Sunil Nookala Dell Corp. -Original Message- Sent: Wednesday, January 22, 2003 4:09 AM To: Multiple recipients of list ORACLE-L Hi All, We have experienced a *very* slow connect time to a 9.0.1 database via SQL*Plus (and other apps as well) on a Win2K machine, and I was wondering if anybody else had experienced these slow connection times as well? We have also been asked lately by a number of customers about slow connection times, and to this point haven't found a solution for either ourselves or our contacts.. It's not a network issue as connection times take just as long "locally". Connections can take up to around a minute (and the odd occasion a couple of minutes). No MTS is in use. OS's that I've heard about this on are Win2K, XP and NT so I'm also wondering if it may be a Win32 issue. Help! Cheers :) Mark === Mark Leith | T: +44 (0)1905 330 281 Sales & Marketing | F: +44 (0)870 127 5283 Cool Tools UK Ltd | E: [EMAIL PROTECTED] === http://www.cool-tools.co.uk Maximising throughput & performance -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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: When will Oracle 10i be out?
The day we all finish upgrading our databases to 9i. Sunil Nookala DBA Dell Corp. -Original Message- Sent: Thursday, November 07, 2002 12:09 PM To: Multiple recipients of list ORACLE-L Has anyone heard when Oracle will be releasing version 10i? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pall, Tom [Contractor] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - 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: off topic: OCP exam registration
Try promotion code OPP to get 30% off. Sunil Nookala Dell Computer corp. Austin, TX -Original Message- Sent: Thursday, September 05, 2002 3:05 PM To: Multiple recipients of list ORACLE-L Hi ALL! I just spoke with Prometric and they told me if I give them my OTN number they will give me discount for OCP exam. I'm the member of OTN , but I don't have any number. Someone know where I can get this number? 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: 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: Nologging and redo generation
SQL loader(direct load),direct inserts, and create table as select...will not generate redo/undo by using NOLOGGING. Your Transaction is logged while deleting rows, can't be blocked. correct me if I am wrong. Sunil Nookala Database Analyst Dell Corp Austin, TX -Original Message- Sent: Wednesday, August 14, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Can I use the nologging option on simple inert and deletes to eliminate rollback problems and redo generation? Ron S. -- 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). -- 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).
RE: When was a tablespace created?
try this: select a.file_name, a.tablespace_name, b.creation_time from dba_data_files a, v$datafile b where a.file_name = b.name should give the time for the first file added to the tablespace, translates to the tablespace creation time. someone might have a better idea, I guess. Sunil Nookala Dell Corp. Austin, TX -Original Message- Sent: Friday, July 26, 2002 11:30 AM To: Multiple recipients of list ORACLE-L Is the creation date/time for a tablespace stored within the DB? If so, where? -- Charlie Mengler Maintenance Warehouse [EMAIL PROTECTED] 10641 Scripps Summit Ct. 858-831-2229 San Diego, CA 92131 Lack of planning on your part doesn't constitute an emergency on my part! -- 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). -- 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).
RE: RE: RE: Rant
what about self destruction?? Sunil > -Original Message- > From: ltiu [mailto:[EMAIL PROTECTED]] > Sent: Monday, July 22, 2002 6:02 PM > To: Multiple recipients of list ORACLE-L > Subject: Re:RE: RE: Rant > > > IBM's latest DB2 claims to do this. Self monitoring, self healing. > > ltiu > > Quoting [EMAIL PROTECTED]: > > > Right and the database will tell the end user where to park > his/her stupid > > cartesian product sql statement!! > > > > Sometime after I'm dead and buried I'm sure. > > > > Dick Goulet > > > > Reply Separator > > Author: "Gogala; Mladen" <[EMAIL PROTECTED]> > > Date: 7/22/2002 12:14 PM > > > > What happened to the dream about the database that doesn't need > > a DBA? Something like that was announced for the version 27i. > > You know, everything will tune itself, database engine will > > tap directly into the user's mind and, based on that, define the > > best possible access path. Of course, the instance would spread > > iself ideally accross the available disks, allocate the optimum > > amount of memory, tune its parameters and deinstall any MS Office > > products from the machine. Sort of Larry Ellison's version of > > "I have a dream" speach. > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: ltiu > 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: 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).
OTN discount code.
List, someone pl.. tell me the new OTN discount code for OCP exam?? she is such a pig_headed, insists on the code...damn.. Thanks, Sunil Nookala. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 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: SHARED POOL SIZE
Title: RE: SHARED POOL SIZE sorry I goofed...I meant.. yes, it could be changed. -Original Message-From: Adams, Matthew (GEA, MABG, 088130) [mailto:[EMAIL PROTECTED]]Sent: Monday, May 20, 2002 3:35 PMTo: Multiple recipients of list ORACLE-LSubject: RE: SHARED POOL SIZE The value of IMMEDIATE in the ISSYS_MODIFIABLE column means that it IS modifiable and takes effect immediately. Matt Adams - GE Appliances - [EMAIL PROTECTED] Chaos! Panic! Disaster! (My work here is done) -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: Monday, May 20, 2002 4:14 PM To: Multiple recipients of list ORACLE-L Subject: RE: SHARED POOL SIZE No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL> / NAME ISSES ISSYS_MOD - - shared_pool_size FALSE IMMEDIATE Sunil Nookala Dell Corp. -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell 818 402-1987 === Confidentiality Statement === 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. = End Confidentiality Statement = -- 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja 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 --
RE: SHARED POOL SIZE
No, it is NOT. Connected to: Oracle9i Enterprise Edition Release 9.0.1.1.1 - Production With the Partitioning option JServer Release 9.0.1.1.1 - Production 1 select name, ISSES_MODIFIABLE, ISSYS_MODIFIABLE from v$parameter 2* where name like'shared_pool_size%' SQL> / NAME ISSES ISSYS_MOD - - shared_pool_size FALSE IMMEDIATE Sunil Nookala Dell Corp. -Original Message- Sent: Monday, May 20, 2002 2:55 PM To: Multiple recipients of list ORACLE-L Only on 9.0.1 and above -Original Message- [EMAIL PROTECTED] Sent: Monday, May 20, 2002 9:24 PM To: Multiple recipients of list ORACLE-L No. Jared Hamid Alavi <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 05/20/2002 12:05 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:SHARED POOL SIZE HI, IS THERE ANY WAY TO INCREASE THE SHARED_POOL_SIZE WITHOUT SHUT DOWN THE DATABASE(8.1.6.2 ON SUN SOLARIS) Hamid Alavi Office 818 737-0526 Cell818 402-1987 === Confidentiality Statement === 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. = End Confidentiality Statement = -- 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). -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: raja 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).
RE: SPACE FREE HOW?
Seema, with alter table deallocate, you can reclaim only the space above the high water mark in a segment. The only way the high water mark can be moved downward is to truncate the segment or drop and recreate the segment. Sunil Nookala Dell Computer Corp. Austin, TX -Original Message- Sent: Thursday, January 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database size.What I have to do to get that free space? Is it necessary to shutdown the database? Thx -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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). -- 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).
RE: SPACE FREE HOW?
ALTER TABLE table DEALLOCATE UNUSED KEEP integer; the keep clause is optional. -sunil -Original Message- Sent: Thursday, January 17, 2002 2:58 PM To: Multiple recipients of list ORACLE-L Hi I deleted millions of rows from diffrent tables and I have not seen any impact on database size.What I have to do to get that free space? Is it necessary to shutdown the database? Thx -Seema _ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- 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). -- 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).
RE: sniped sessions
appreciate you help guys.. -Original Message- Sent: Tuesday, January 15, 2002 9:06 AM To: Multiple recipients of list ORACLE-L Attached are the scripts we use to kill sniped sessions. This is part of a series of monitoring scripts we developed for our Oracle databases. The scripts are scheduled through Cron and run every 15 minutes. A logonid or an email address is passed to the scripts for either paging or email. In this case an accum of sniped sessions is maintained on a 'flat' file just so we can go back and check to see how many sniped sessions are being killed. I will attach a zip file. If that doesn't get through I will also list the scripts below. Ron Smith Kerr-McGee Corp SNIPED.SH #! /bin/sh # DBA MONITORING SCRIPTS # ** # # Author: Ron Smith # Date: 06/18/98 # Funtion:Checks for sessions that have been "Sniped". # # ** # # CHANGE HISTORY # # DATEWHO Reason for Change # 03/03/00Ron Smith New Prog # # ** # # FUNCTION # # This script calls sniped.sql. # The function of this script is to report sessions that have # been "sniped" by Oracle through the use of resource limits. # # If the id of the DBA is a Zid, a page will be sent. If the # id of the DBA is an email address (determined by looking for # an "@" ) , an EMAIL will be sent. # # ** # # PREREQUISITES # # The OPS$ORACLE user must exist in the instance. This can be # created by running the opsuer.sql script in SQLPLUS while # logged on as SYSTEM. # # The cdmonitoring script must exist in the home/oracle # directory. # # ** # # RUN SYNTAX # # sniped.sh (sid) (oncall dba) # # # ** # cd to the monitoring script directory . $HOME/cdmonitoring.sh ORACLE_SID=$1 export ORACLE_SID DBA=$2 export DBA echo $DBA ATCNT=`echo $DBA | grep @ | wc -l` export ATCNT ORACLE_HOME=`grep "^$ORACLE_SID:" /etc/oratab | head -1 | cut -d: -f2` export ORACLE_HOME PATH=$ORACLE_HOME/bin:/usr/local/bin:$PATH:. export PATH # Delete the old list file if it exists if [ -e sniped_$ORACLE_SID.lst ] then rm sniped_$ORACLE_SID.lst fi # Delete the old error file if it exists if [ -e sniped_$ORACLE_SID.err ] then rm sniped_$ORACLE_SID.err fi # Delete the old kill file if it exists if [ -e sniped_kill_$ORACLE_SID.sh ] then rm sniped_kill_$ORACLE_SID.sh fi # If sending to EMAIL address, run sql with headings on else run with headings off if [ "$ATCNT" -gt "0" ] then sqlplus / @sniped.sql on else sqlplus / @sniped.sql off fi # If there is anything in the lst file then kill the user processes and send a message if [ -s sniped_$ORACLE_SID.lst ] then cat sniped_$ORACLE_SID.lst >> sniped_accum.lst sqlplus / @sniped2.sql if [ -s sniped_kill_$ORACLE_SID.sh ] then chmod +x sniped_kill_$ORACLE_SID.sh; cat sniped_kill_$ORACLE_SID.sh >> sniped_kill_accum.lst ./sniped_kill_$ORACLE_SID.sh; fi echo "-DBA- Sniped sessions killed " > sniped_$ORACLE_SID.err echo "SID=" $ORACLE_SID " " >> sniped_$ORACLE_SID.err cat sniped_$ORACLE_SID.lst >> sniped_$ORACLE_SID.err if [ "$ATCNT" -gt "0" ] then echo "email sent" elm -s "-DBA- $ORACLE_SID Sniped sessions exist" $DBA < sniped_$ORACLE_SID.err else LC=`cat sniped_$ORACLE_SID.lst | sed -e 's/ */ /g' | wc -c` echo $LC if [ "$LC" -gt "160" ] then echo "Sniped sessions killed. Check sniped_$ORACLE_SID.lst" >> sniped_$ORACLE_SID.err else cat sniped_$ORACLE_SID.lst >> sniped_$ORACLE_SID.err fi echo "page sent" pager $DBA "`cat sniped_$ORACLE_SID.err`" fi fi SNIPED.SQL set pause off SET ECHO off set verify off set feedback off set linesize 132 set heading &1 col "User Name" format a10; alter session set nls_date_format = 'dd-MON- hh24:mi:ss'; spool sniped_$ORACLE_SID.lst select s.username "User Name", s.osuser "OS User", s.status "Status", s.logon_time "Connect Time", p.spid, p.pid, si.sid from sys.v_$sess_io si, sys.v_$session s, sys.v_$process p where s.username is not null and si.sid(+)=s.sid and p.addr(+)=s.paddr and status = 'SNIPED'; spool off; e
sniped sessions
Dear List, I have "init.ora" resource_limit = true, and idle_time set in profile. When idle_time exceeds, the session status becomes 'sniped' in v$session and never gets cleaned up. I manually kill these threads using orakill utility. I appreciate, if someone can help me with a script to clean up these sessions automatically(8.1.7 on NT)?? Sunil Nookala DBA Dell Computer Corp. Austin, TX 78738 -- 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).
deleting duplicate records
Hello all, could someone please tell me why the procedure below(Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 21 mins on a table with 235,000 rows?? i have created a bigger rollback segment to take care of this, but no improvement.where should i be looking for bottlenecks?? CREATE PROCUDURE DUPES_DEL ASBEGIN LOOP DELETE from fms_test where row_id in(select min(rowid) from fms_test group by sku_num having count (*) >1); EXIT WHEN SQL%NOTFOUND END LOOP;COMMIT;END; appreciate it.Sunil NookalaDellCorp.Austin, TX
Recall: Message at the start of svrmgrl
Nookala, Sunil would like to recall the message, "Message at the start of svrmgrl". -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public 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: Message at the start of svrmgrl
Hello all, could someone please tell me why the procedure below (Author:Nick Butcher) takes less than a minute ona table with 50,000 rows and about 21 mins on a table with 235,000 rows?? I have created a bigger rollback segment to take care of this, but no improvement.where should i be looking for bottlenecks?? CREATE PROCUDURE DUPES_DEL ASBEGIN LOOP DELETE from fms_test where row_id in(select min(rowid) from fms_test group by sku_num having count (*) >1); EXIT WHEN SQL%NOTFOUND END LOOP;COMMIT;END; appreciate it.Sunil NookalaDellCorp.Austin, TX
RE: oem job fails..
I found out the session which kept the table locked. killed it, jobs run fine now. thanks for help. Sunil Nookala -Original Message- Sent: Tuesday, October 02, 2001 12:37 PM To: Multiple recipients of list ORACLE-L that's not an oem problem per se... but is related to the fact that you are trying to update a row or table that is already in use review the updates and order of updates you are making. Is anything else running at that time? --- [EMAIL PROTECTED] wrote: > Hi Guys, > While running a job(with lot of updates)in oem i get this error: > > ORA-00054: resource busy and acquire with NOWAIT specified. > > data base is 8.1.7 on NT. > please help me how to fix it. > > Sunil Nookala > Dell Corp. > Austin, TX > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > 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!? Listen to your Yahoo! Mail messages from any phone. http://phone.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). -- 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).
oem job fails..
Hi Guys, While running a job(with lot of updates)in oem i get this error: ORA-00054: resource busy and acquire with NOWAIT specified. data base is 8.1.7 on NT. please help me how to fix it. Sunil Nookala Dell Corp. Austin, TX -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- 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).
RE: Tricky Hierarchical Query
Hi, I've been through with that lately, modify this to see how it helps. SELECT LPAD(' ',5*(LEVEL-1)) ||name||' empno:'||emp_no ||' '||'works for:'||functional_mgr_name FROM HRTABLE where functional_mgr_badge =&emp_no START WITH emp_no= &emp_no CONNECT BY PRIOR emp_no = functional_mgr_badge Sunil Nookala Oracle DBA Dell Corporation Austin, TX -Original Message- Sent: Friday, August 31, 2001 3:20 PM To: Multiple recipients of list ORACLE-L Oracle has a very good section on "prior" and "connect by". These combined "level" let you walk a tree - so to speak. I use them all the time. Look up the key words. You'll find it. -Original Message- Sent: Friday, August 31, 2001 12:07 PM To: Multiple recipients of list ORACLE-L Hi, I am stumped on how to do a particular hierarchical query. The query needs to be written entirely in SQL. I have a table (ACCOUNT) with 3 columns of interest in it, ACCOUNT_ID, ROOT_ID, PARENT_ID. Every row represents an account. If an account is the "root" (top-most), then the ROOT_ID and PARENT_ID columns are null. If an account is a "parent", then the ROOT_ID is populated but the PARENT_ID is null. Accounts can be nested multiple levels deep. I need to find all of the accounts that belong to the root of the given account but not include any accounts that are children of the given account. Does this make sense? I.e. 5 6 7 8 9 10 11 1213 14 I'm not sure if my tree diagram will be dispalyed properly after I email this but in essence if "8" is the given account number, I want everything returned except for 8, 11 and 12. Thanks in advance! -w __ Do You Yahoo!? Get email alerts & NEW webcam video instant messaging with Yahoo! Messenger http://im.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Walter K 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 Lewis 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).
RE: Locally managed tablespaces
The size of extents that are managed locally are determined by the system. The LOCAL clause of the extent management specifies this menthod in create statement. Sunil Nookala Dell Computer Corp. Austin, TX -Original Message- Sent: Thursday, July 19, 2001 11:43 AM To: Multiple recipients of list ORACLE-L HPUX 11i 64 bit Oracle 8.1.7.1 32 bit I am creating a new database and decided to go with locally managed tablespaces. I was going to go with autoallocate because the best I can tell the only possible drawback with this is a little wasted space. However, I was under the impression that you could not specify a next in the storage clause of a table creation. Yet you can. So what happens if I have a next defined? Do they pretty much just throw that away or should I really not define it? Kimberly Smith Database Administrator IT Dept. - Fujitsu/GMD Phone: (503) 669-6050 Fax: (503) 669-5705 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly 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). -- 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).
RE: OT RE: What stands for i in Oracle 8i
never too late, watch Read Between the Lions!! -Original Message- Sent: Wednesday, June 06, 2001 4:07 PM To: Multiple recipients of list ORACLE-L A E I O U and sometimes Y Never learned that hymn in school? "Walking on water and developing software from a specification are easy if both are frozen." Christopher R. Spence Oracle DBA Fuelspot -Original Message- Sent: Wednesday, June 06, 2001 4:16 PM To: Multiple recipients of list ORACLE-L Not being funny, but when did y become a vowel? -Original Message- [EMAIL PROTECTED] Sent: Wednesday, June 06, 2001 07:47 To: Multiple recipients of list ORACLE-L Actually, I think they are following a logical progression of english vowels, i.e., "A" would indicate a pre-beta release - not suitable for marketing or Micro$oft quality, "E" is overused already with all the E-this.com and E-that.com's crashing and burning, "I" is the current flavor in IT marketing. See HPUX 11i, Oracle 9i, etc, "O" will be for "Oh my gods! How will I ever manage this monster!" in the next generation of systems, "U" and "Y" are yet to be determined... Or maybe combined into "YU" (why you)... Its just a theory, I could be wrong. Scott Shafer San Antonio, TX 210-581-6217 "And no amount of training or preparedness can eliminate the almost certainty that in the middle of your Angry Crane stance, as you transition to your Combative Monkey to administer the Coup de Grâce via your Ninja Death Touch, you step on a beer bottle and fall backwards into the juke box and get your head stove in by a drunk with a pool cue." --Jay Trigg > -Original Message- > From: Yexley Robert D SSgt AFIT/SCA [SMTP:[EMAIL PROTECTED]] > Sent: Wednesday, June 06, 2001 12:48 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: What stands for i in Oracle 8i > > I believe it stands for "internet", as in, the "internet" database. > > -Original Message- > From: Muthaiah [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, 06 June, 2001 12:56 PM > To: Multiple recipients of list ORACLE-L > Subject: What stands for i in Oracle 8i > > > Hi, > > I am just curious about to know for what that i stands for in Oracle > 8i. > > Can any one shed some light? > -- 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith 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). -- 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).
RE: How do I corrupt a block
talk to your lead duhveloper..they are usally good at that ;-) Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Thursday, May 31, 2001 5:06 PM To: Multiple recipients of list ORACLE-L unfortunately i am on NT I can not use BBED because i don't know the password is there any other way - Original Message - To: "'novicedba'" <[EMAIL PROTECTED]> Sent: Thursday, May 31, 2001 11:40 PM > I do not recommend this, but since you are bent on doing this: > (Hope you are on Unix) > > From an earlier post: > > Ferenc, try the following: > dd if=/dev/zero of=myfile bs=4096 oseek=9876 count=100. > If that doesn't corrupt it, nothing will. > Happy hunting! > > === > Mladen Gogala > > > > > > -Original Message- > From: novicedba [mailto:[EMAIL PROTECTED]] > Sent: Thursday, May 31, 2001 2:16 PM > To: Multiple recipients of list ORACLE-L > Subject: How do I corrupt a block > > > hi, > This may sound funny. I want to know how to corrupt a block. I want to > test the different methods of identifying block corruption, but I don't have > sample data blocks. > Please help me > > novice > > > From another posting: > > > > Thanks to everyone who responded - this was the solution that worked for me: > SVRMGR> select count(*) from ccpinp; > COUNT(*) > -- > ORA-01578: ORACLE data block corrupted (file # 4, block # 5204) > ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' > SVRMGR> select segment_name, segment_type from dba_extents > 2> where file_id = 4 and 5204 between block_id and block_id + blocks - 1; > SEGMENT_NAME SEGMENT_TYPE > -- -- > - > CCPINP TABLE > 1 row selected. > SVRMGR> select index_name from dba_indexes where table_name = 'CCPINP'; > INDEX_NAME > -- > PK_CCPINP > CCPINP_2 > CCPINP_3 > 3 rows selected. > SVRMGR> create table temp as select * from ccpinp where 1 = 2; > Statement processed. > SVRMGR> insert into temp select /*+ ROWID(CCPINP) */* > 2> from ccpinp > 3> where rowid between '..' and > 4> '1453..0004'; > 59 rows processed. > SVRMGR> insert into temp select /*+ ROWID(CCPINP) */* > 2> from ccpinp > 3> where rowid between '1455..0004' and > 4> '..'; > ORA-01578: ORACLE data block corrupted (file # 4, block # 5205) > ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' > SVRMGR> insert into temp select /*+ ROWID(CCPINP) */* > 2> from ccpinp > 3> where rowid between '1456..0004' and > 4> '..'; > ORA-01578: ORACLE data block corrupted (file # 4, block # 5206) > ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' > SVRMGR> insert into temp select /*+ ROWID(CCPINP) */* > 2> from ccpinp > 3> where rowid between '1457..0004' and > 4> '..'; > ORA-01578: ORACLE data block corrupted (file # 4, block # 5207) > ORA-01110: data file 4: '\SV\ALM\ADM\ALMDS1.TSP' > SVRMGR> insert into temp select /*+ ROWID(CCPINP) */* > 2> from ccpinp > 3> where rowid between '1458..0004' and > 4> '..'; > 869 rows processed. > > And to look at the rows with the corruption, I did the following: > > SVRMGR> select inst_id, chart_id, acct_id, attrib_id, rowid > 2> from ccpinp > 3> where inst_id >=0 and chart_id >=0 and acct_id >=0 and attrib_id >=0 > 4> and rowid like '1455.%.0004'; > INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID > -- -- -- -- -- > 1 3 585 20 1455..0004 > 1 3 585 30 1455.0002.0004 > 1 3 585 50 1455.0004.0004 > 3 rows selected. > SVRMGR> select inst_id, chart_id, acct_id, attrib_id, rowid > 2> from ccpinp > 3> where inst_id >=0 and chart_id >=0 and acct_id >=0 and attrib_id >=0 > 4> and rowid like '1456.%.0004'; > INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID > -- -- -- -- -- > 1 3 721 140 1456..0004 > 1 3 721 150 1456.0002.0004 > 1 3 721 160 1456.0005.0004 > 3 rows selected. > SVRMGR> select inst_id, chart_id, acct_id, attrib_id, rowid > 2> from ccpinp > 3> where inst_id >=0 and chart_id >=0 and acct_id >=0 and attrib_id >=0 > 4> and rowid like '1457.%.0004'; > INST_ID CHART_ID ACCT_ID ATTRIB_ID ROWID > -- -- -- -- -- > 1 3 591 20 1457..0004 > 1 3 591 30 1457.0002.0004 > 1 3 591 40 1457.0004.0004 > 3 rows selected. > > > Have a great weekend!! > Jeff > > > > > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: novicedba 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 O
RE: how to find out internal's password???
try this(on your dev box first): 1.select instance_name from v$instance; @command line, 2.oradim80 -delete -sid 3.oradim80 -new -sid (instance name> -intpwd now you have a new password for internal. Sunil Nookala Dell Corporation, Austin, TX -Original Message- Sent: Friday, May 25, 2001 1:07 PM To: Multiple recipients of list ORACLE-L This is in additional to my previous question about how to turn off passowrd for internal: To try to turn off pwd for internal, I commented out remote_login_passwordfile = exclusive in the init file, now I need to shutdown and restart the database. I tried to login as internal to shutdown the db, when it askes for password, I tried a bunch things including sys, manager, and they all failed. So I used sqlplus system/pwd to login and do shutdown, the database is down, but now I cannot login to svrmgrl to startup the database, since I don't know internal's password. So my question is how to find out internal's password? Thanks a lot. Janet __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Janet Linsy 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).
RE: job offer from SAUDI ARABIA
I can answer your question# 2 It would be very wise for your wife to cover her head and you.. your butt!! think twice before you make a move. Sunil Nookala -Original Message-From: Bunyamin K. Karadeniz [mailto:[EMAIL PROTECTED]]Sent: Wednesday, May 16, 2001 8:50 AMTo: Multiple recipients of list ORACLE-LSubject: job offer from SAUDI ARABIA Hi all , I have taken an offer from a company in Europe to work in Saudi Arabia for 2 years. But I must learn the living conditions there. Ýf there is an Arabian here , can you answer these.. 1) How are the living conditions?Expensive? 2) Will my wife have to cover her hair? Is it mandatory there? 3) How are the social activities like cinema? Thanks.
RE: How can I cut off a query after 3 lines?
where rownum <4 Sunil Nookala Dell corp Austin, TX -Original Message- Sent: Friday, May 04, 2001 12:26 PM To: Multiple recipients of list ORACLE-L Q: how can you specify with a select statement how many rows are given as a result? I would only like to get the first three lines. here is what I have 1 SELECT machine_name, login, Count(login) AS CountOfLogin FROM login_history 2 group by machine_name, login 3* order by count(login) desc 4 ; MACHINE_NAME LOGIN COUNTOFLOGIN -- mochaJeff 3 reeses Paul 3 spiceTamara3 mochaRudy 2 reeses Jeff 1 reeses Ravie 1 reeses Tonya 1 spiceRudy 1 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MKirk 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).
RE: wrong setting of sort_area_size
Advantage:increasing sort area size decreases the I/O, hence quicker sorting process. Disadvantage: increasing sort area causes sort process to allocate more memory, which effects the OS memory allocation resulting in paging and swapping. large sort area sizes can used if you are using with a minimal sort_area_retained_size parameter. Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Thursday, May 03, 2001 3:06 PM To: Multiple recipients of list ORACLE-L we had a customer of the sort_area_size=1000 in their database, the temp table space is 256MB, the db_block_size is 8k. They have some performance problem, I think it's probably related to the setting of sort_area_size(we have only one user). So what's the benefits/disadvantage of too big sort_area_size? Thanks, Chris __ Do You Yahoo!? Yahoo! Auctions - buy the things you want at great prices http://auctions.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: CC Harvest 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).
RE: Column name
the only concern is column ambiguity. Precede the field with the table name when you're joining tables. Sunil Nookala Dell Corp Austin, TX -Original Message- Sent: Friday, April 27, 2001 5:00 AM To: Multiple recipients of list ORACLE-L Can I use the same column name in the same database and in the same schema? Could this cause me lots of trouble? Roland Sköldblom -- 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). -- 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).
RE: Temorary tablespace problem
could be concurrent multiple sort operations... -Original Message- Sent: Wednesday, April 25, 2001 12:30 PM To: Multiple recipients of list ORACLE-L Hi Today I have seen thats the Temporary tablespace growth in my database is high.What could be reasons? Thanks -Seema _ Get your FREE download of MSN Explorer at http://explorer.msn.com -- 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). -- 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).
RE: Set transaction does not work
make sure the transaction is set. try doing a commit before that. if it is on a test/play box bring the rest of the rbs offline leaving the one you created online, forcing oracle to use it. Sunil Nookala Dell corp Austin, TX -Original Message- Sent: Thursday, March 29, 2001 11:51 AM To: Multiple recipients of list ORACLE-L RDBMS 7.3.2.3 I am running this under SQLPLUS set transaction use rollback segment BIG_ROLLBACK select c1, c2 from giant_poorly_indexed_table where unindexed_colum=''; exit; I end up with "snapshot too old" rollback segment RB_07. Why won't it use the giant rollback segment I created for this transaction? The segment is public and it is online. > -Original Message- > From: Brian Wisniewski [SMTP:[EMAIL PROTECTED]] > Sent: Thursday, March 29, 2001 7:45 AM > To: Multiple recipients of list ORACLE-L > Subject: Re: Is terminal release of 8.0.x still supported? > > I checked yesterday and 8.0.6 which is the terminal 8.0.X release is > still supported on Solaris. Freakin' vendor won't certify their > product for anything above 8.0.5 which hasn't been supported for nearly > a year now. mumble, mumble... > > - Brian > > --- [EMAIL PROTECTED] wrote: > > > > We have some 8.0.4 databases running on Sun Solaris. > > I believe that 8.0.4 has been desupported as of December 31, 2000. > > We are unable to upgrade one of our apps at this time that is > > running on an 8.0.4 database. > > > > Is the terminal release of 8.0.x still supported? If yes, what is > > that terminal release? Is it 8.0.7? How long before that terminal > > release will be desupported (if it is currently supported)? > > > > Thanks, > > > > Cherie Machler > > 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!? > Get email at your own domain with Yahoo! Mail. > http://personal.mail.yahoo.com/?.refer=text > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Brian Wisniewski > 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). -- 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).