RE: Does SQL Server have a wait interface?
Ryan, Check out "DBCC SQLPERF(WAITSTATS)", and also take a look at the "sysprocesses" table - with columns waittype, waittime, lastwaittype and SPID. Something like: SELECT spid AS SPID, waittype AS WaitType, waittime AS WaitTime, lastwaittype AS LastWaitType FROM sysprocesses WHERE (spid > 50) AND (waittime > 0) A good comprehensive overview of the wait types is here: http://sqldev.net/misc/WaitTypes.htm HTH Mark Mark Leith Cool-Tools UK Limited http://www.cool-tools.co.uk -Original Message- [EMAIL PROTECTED] Sent: 21 January 2004 13:35 To: Multiple recipients of list ORACLE-L anyone know? -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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: 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).
RE:
Title: Message must.resist..temptation. For more help, please dial 999 in the UK, 911 in the US, or open your phone and dial 712-BEAM-ME-UP for the year 2247. Live long and prosper. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Ashish SahasrabudheSent: 21 January 2004 14:34To: Multiple recipients of list ORACLE-LSubject: HELP
9iAS Calender Servlet
Does anybody by chance have any examples for creating a calender servlet for 9iAS? I have to admit to being a servlet virgin! ;) Any pointers much apreciated! Many thanks Mark -- 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).
RE: Connection Problem
I've asked for the out put on a lsnrctl status already, but haven't heard back from him as yet.. The "." does look strange.. Also, what would the impact be to have the GLOBAL_DBNAME set to the same value for all three instances? Would it not be better to set it to the same name as the instance name for each? The same goes for port too.. I thought that all three on the same port would be OK? Cheers Mark -Original Message- Mercadante, Thomas F Sent: 16 January 2004 13:30 To: Multiple recipients of list ORACLE-L Mark, The (GLOBAL_DBNAME= l1000.) entry looks strange. Should there be a '.' in there? I've never seen this entry in this file. What does : lsnrctl status & lsnrctl services show? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Friday, January 16, 2004 6:14 AM To: Multiple recipients of list ORACLE-L Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an "12154 - Could not resolve service name" error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENER>ORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect "user/[EMAIL PROTECTED]" the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to "l1000" for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- 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: Mercadante, Thomas F 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 --- Outgoing mail is
RE: SQL server and JOB
Firstly Arslan, it should probably be pointed out that this is an Oracle list, not SQLServer. But, seeing as I deal with both database types, I'll have a stab at this.. You can create jobs under the "SQLServer Agent". If you open up SQLServer's Enterprise Manager, and navigate to your "Server", there is a directory tree there called "Management", and under that will be "SQL Server Agent", which manages three things - "Alerts", "Operators" and "Jobs".. If you highlight Jobs, then right mouse button click on the (probably) empty window on the right, you'll get a menu option to insert a "New Job...". HTH 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 -Original Message- [EMAIL PROTECTED] Sent: 16 January 2004 12:59 To: Multiple recipients of list ORACLE-L Hi , How can i create a job in sql server ? Rgds. Arslan. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: <[EMAIL PROTECTED] 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- 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).
Connection Problem
Hi All, I'm helping out a friend of mine who's having problems with connecting from an NT system to an HP system running Oracle 8.0.5 (don't ask!). They keep getting an "12154 - Could not resolve service name" error.. The TNSNAMES.ORA file looks OK, and I feel there is something iffy about their listener set up. Here's there set-up: TNSNAMES.ORA: extproc_connection_data = (DESCRIPTION = (ADDRESS = (PROTOCOL = IPC)(KEY = LIVE)) (CONNECT_DATA = (SID = extproc)) ) LIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = LIVE)) ) TEST = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = TEST)) ) ARCHIVE = (DESCRIPTION = (ADDRESS = (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) (CONNECT_DATA = (SID = ARCHIVE)) ) LISTENER>ORA: LISTENER = (ADDRESS_LIST = (ADDRESS= (PROTOCOL= IPC)(KEY= FROUDE)) (ADDRESS= (PROTOCOL= IPC)(KEY= PNPKEY)) (ADDRESS= (PROTOCOL= TCP)(Host= l1000)(Port= 1521)) ) SID_LIST_LISTENER = (SID_LIST = (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = LIVE) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = TEST) ) (SID_DESC = (GLOBAL_DBNAME= l1000.) (ORACLE_HOME= /usr/oracle/product/8.0.5) (SID_NAME = ARCHIVE) ) (SID_DESC = (SID_NAME = extproc) (ORACLE_HOME = /usr/oracle/product/8.0.5) (PROGRAM = extproc) ) ) STARTUP_WAIT_TIME_LISTENER = 0 CONNECT_TIMEOUT_LISTENER = 10 TRACE_LEVEL_LISTENER = OFF When he tries to connect "user/[EMAIL PROTECTED]" the connection fails - and the same for TEST and ARCHIVE. The thing that sticks out to me is the GLOBAL_DBNAME parameter being set to "l1000" for every instance - do you think this could be causing the problem? Is there anything else that catches your eye? 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- 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).
RE: Oracle Standby.
Thanks, I've grabbed the whitepaper by Lawrence To (from http://otn.oracle.com/deploy/availability/pdf/stby8i_twp.pdf if anyone is interested). I'll take that home for bed time reading ;) If I have any more specific questions I'll give you all a shout again! ;) Many thanks Mark -Original Message- Shrake, Jolene Sent: 09 January 2004 14:39 To: Multiple recipients of list ORACLE-L There are good documents on Metalink (one in particular by Lawrence To). The Oracle RDBMS manuals are informative as well. I run a script bat file on Windows on the primary to transfer the logs every half hour to the secondary. And a bat file once a day on the secondary to apply the logs. I use blat to send an email of the last log applied so that I can be sure everything is OK. I don't run in managed mode, the servers come down occasionally and that messes up the standby if you're not careful. Jolene -Original Message- Sent: Friday, January 09, 2004 8:20 AM To: Multiple recipients of list ORACLE-L Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- 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: Shrake, Jolene 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- 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).
Oracle Standby.
Hi All, Does anybody have any good resources (links/whitepapers) on setting up, managing and monitoring an Oracle Standby environment? It will be a windows installation. Many thanks! 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.558 / Virus Database: 350 - Release Date: 02/01/2004 -- 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).
RE: Database Health Review
*User Response Times!* -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Vidya KalyanaramanSent: 08 January 2004 08:40To: Multiple recipients of list ORACLE-LSubject: Database Health ReviewHi I am supposed to be doing a database health review for one of the customers. They have Oracle database ver9.2.0.3 on HP UX 11i. Normallly, we do check the following:· OFA standards· Purging Strategy· Archival Strategy· Database server utilization (shared pool area) - Run Statspack· Latest certified combination of Oracle Products.· Transaction Management (RBS, Redo)· OLTP init.ora parameters · Optimizer statistics · Custom Code Management· NLS Setup· Server and storage area configuration. Did I miss out on anything? Any comments/suggestions/pointers are most welcome.Thanks and RegardsVidya
RE: Display unix directory hierarchy
Hi Barb, You can use tree/dtree to do this. Windows also has a tree dos command to do the same. HTH Mark -Original Message- Barbara Baker Sent: 23 December 2003 08:49 To: Multiple recipients of list ORACLE-L Hi, listers. As documentation for a project, I would like to display some unix directories in hierarchical format and add the output to the documentation set. (Solaris 9) Either flowchart-like or explorer-like will do. Sorta like what is shown below. Does anyone know of a freebie tool that will do this? (Or is this some fancy ls command I'm missing?) Thanks for any help. Barb /dna /orasrv /1.4 /scripts /1.7 /scripts /logs __ Do you Yahoo!? Free Pop-Up Blocker - Get it now http://companion.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Barbara Baker 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 -- 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).
RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
PING doesnt actually use a port number, as it's not TCP/IP based - it's a part of the ICMP protocol.. Mark -Original Message- Ganesh Raja Sent: 23 December 2003 13:40 To: Multiple recipients of list ORACLE-L TNSping uses the Port 1521 to communicate .. Not Sure which Port Ping will use.. HTH Regards, Ganesh R HP : (+65)9067-8474 Mail : [EMAIL PROTECTED] == All Opinions expressed are my own and do not in anyway reflect those of my employer == -Original Message- Mercadante, Thomas F Sent: Tuesday, December 23, 2003 20:54 PM To: Multiple recipients of list ORACLE-L ANd one more thing about Ping vs Tnsping when going thru a firewall. Some firewalls are setup to not allow a Ping to pass thru, but sql connections are allowed. So a Ping will return not found, while a tnsping will return ok. I have that situation here all over the freakin place. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, December 23, 2003 5:54 AM To: Multiple recipients of list ORACLE-L I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. 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 -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: > I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. > > for example this tnsping took about 270 ms which is strange and its consistent > > Used TNSNAMES adapter to resolve the alias > Attempting to contact (DESCRIPTION = (ADD > RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST > = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( > PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE > = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 > OK (270 msec) > > and a ping to the same host > > Ping statistics for x.x.x.x: > Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), Approximate > round trip times in milli-seconds: > Minimum = 61ms, Maximum = 70ms, Average = 67ms > > Why could there be such a difference? > > > > > > > > - > Do you Yahoo!? > Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Se
RE: TNSPING VS. REGULAR PING..! WHY SUCH A DIFFERENCE
I came across just this last week with one of our monitoring tools. We set up an execution of a script that was using PING to check whether the status of a list of remote POS devices to make sure they were available. The collection worked fine - until we shutdown the POS device, and physically switched it off - and the PING still replied! The POS devices have UPS built in to them.. The client also thought it may have been the way that DNS/DHCP was set up via the router. It stumped me for a time.. ;) We use NETSVC now to check for the status of a service. 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 -Original Message- Jared Still Sent: 23 December 2003 04:34 To: Multiple recipients of list ORACLE-L Paul mentioned a few reasons for this. Another is that a ping does not get past the NIC. The ping is answered by software running on the card. You may have noticed at times that a ping is not a reliable method for determining if a server is still functioning. The OS can crash, but the NIC still responds to a ping. Tnsping on the other hand must get a response from Oracle Net service or daemon running on the server, a much longer path as Paul pointed out. HTH Jared On Mon, 2003-12-22 at 17:29, Murali Vallath wrote: > I have recently noticed in this one situation that there is a great difference between a tnsping vs a regular ping to the same server. > > for example this tnsping took about 270 ms which is strange and its consistent > > Used TNSNAMES adapter to resolve the alias > Attempting to contact (DESCRIPTION = (ADD > RESS_LIST = (load_balance = on) (failover = on) (ADDRESS = (PROTOCOL = TCP)(HOST > = myhost1.com)(PORT = 1521)) (ADDRESS = (PROTOCOL = TCP)(HOST = myhost2.com)( > PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = xyzdb) (FAILOVER_MODE = (TYPE > = SELECT) (METHOD = BASIC) (RETRIES = 20) (DELAY = 15 > OK (270 msec) > > and a ping to the same host > > Ping statistics for x.x.x.x: > Packets: Sent = 4, Received = 4, Lost = 0 (0% loss), > Approximate round trip times in milli-seconds: > Minimum = 61ms, Maximum = 70ms, Average = 67ms > > Why could there be such a difference? > > > > > > > > - > Do you Yahoo!? > Yahoo! Photos - Get your photo on the big screen in Times Square -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.553 / Virus Database: 345 - Release Date: 18/12/2003 -- 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).
RE: Checking that the instance is up
Hi Peter, I remember the thread, but couldn't remember the subject line at all.. Having had this discussion countless times in the past, here's what I would opt for: The best way to make sure that an instance is alive and running would be to do a full connection to that instance, and run a simple piece of sql - such as "select 'PING' from dual;". This makes sure that both the listener, and instance are both up and readily accepting connections. You can also monitor for the listener status separately, based upon a "TNSPING " command, that will alert simply to the status of the listener. We do both of these with our monitoring tool, and generate ENTITY_DOWN and NETWORK_DOWN alerts respectively. If you get both an ENTITY_DOWN and NETWORK_DOWN error message at the same time, then this helps to point you at the listener quicker than trying to diagnose why the instance is down. If you just get an ENTITY_DOWN message on it's own, then it points to a database based problem. You should also try and catch the error messages on a failure, and flag those in your warning messages. And of course, there is the point of monitoring the monitor. You should have some process in place that is making sure that the monitor is up and running correctly. Whether this be a date/timestamp placed in to a log file with every successful "ping", or making sure a cron/AT job is running etc. depends on how you do this.. Of course, you could buy a tool that already does all of this.. ;) HTH Mark -Original Message- Robson, Peter Sent: 18 December 2003 13:59 To: Multiple recipients of list ORACLE-L Folks - Some months ago there were exchanges on the optimum way to check that an instance was alive. I have searched, hunted and generally scavenged for these exchanges, but without luck. Can anyone give me the subject line, and I can turn again to the archive? thanks, peter edinburgh * 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. .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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- 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).
RE: NT -> Win2K causes performance degradation..
Hi all, Thanks for the pointers that you have all supplied. Sage advice that they shouldn't have changed Oracle whilst changing their OS at the same time. I also did some checking up on the /3GB switch before it was mentioned (having seen it on here in the past) - Windows 2000 does in fact support a 4gb address space, though the /3GB switch is only appropriate for Windows 2000 Advanced Server and Windows 2000 Datacenter Server - if you use it for Microsoft Windows 2000 Server - you will lose 1gb of address space! More info (based on Exchange though) is available here: http://support.microsoft.com/default.aspx?scid=kb%3Ben-us%3B328882 If we ever find out what the actual cause was, I'll feed it back to the list. For now we've suggested they roll back the Oracle changes, reassess performance, and then increase their memory structures in steps - assessing performance along the way. We've also asked about the /3GB switch, and pagefile sizes - though they think that the rate of their swapping hasn't increased since the upgrade. Thanks again! Mark -Original Message- Yechiel Adar Sent: 11 December 2003 14:40 To: Multiple recipients of list ORACLE-L The /3GB does not work for the simple reason that in W2K you have 3GB as max address space. At least that what my sysadmin tells me (after checking with MS). Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L Sent: Wednesday, December 10, 2003 6:49 PM Mark, My guess is, that the new OS re-instated the file system caching. By default, 41% (yes, it should have been 42%) of physical memory will be allocated to filesystem caching, as W2K thinks it a fileserver (and domain controller, web server, print server, etc) until you tell it otherwise. This is much improved in w2k3 server - where you tell it what you want it to be. A good sysadmin would have set the OS to "optimize throughput for network applications" which would have turned off the filesystem caching. Ok, its only one radio button to select, so an MSCE could set it also. Surprisingly enough, in W2K Server - changing this setting does not require a reboot, although I don't know if the changes take effect until after a system restart. That's not the sort of thing that I usually test, as NT4 had me trained to reboot afterwards. the other thing may be, that the boot.ini no longer supports the /3GB or /PAE switches as Jared mentioned - but that should not cause the symptoms you are reporting. hth. Paul Mark Leith <[EMAIL PROTECTED]> wrote: Hi All, We've been asked a question from one of our clients that I'm a little stumped on. They run an OLTP database (Oracle 8.1.7), and have recently upgraded their NT machine to Windows 2000, they were running with 2gb of memory, and upgraded that to 4gb in the process. As they increased physical memory, they also increased their SGA size & db_block_buffers. Since they've upgraded they have noticed a significant decrease in performance (the way it was described to me was "it was 7 out of 10, and is now 3 out of 10"..). Has anybody else done a system upgrade of this nature that has caused less than desirable effects? Any pointers as to what to look at? We've requested some stats (top wait stats etc.) and I'll feed these back as and when I get them - but I thought I'd throw this out to you guys in the vague hope thatsomeone has experienced some relatively similar experiences. 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- 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-Ma! il message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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!? New Yahoo! Photos - easier uploading and sharing --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mark Leith INET: [EMAIL PROTEC
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to inv
Clive, If the GLOBAL_NAMES parameter is set to true, then you must create the database link with the same name as the database to which it connects.. Is that the case? Mark -Original Message- Hybart, Clive Sent: 11 December 2003 12:24 To: Multiple recipients of list ORACLE-L inv On UNIX 8.1.7 global_names = true On Zos 390 9i global_names = false Is this causing a mismatch perhaps ? Regards Clive -Original Message- Sent: 10 December 2003 12:10 To: Multiple recipients of list ORACLE-L inv Clive, during the upgrade has the global_names parameter somehow been changed from false to true? This would cause the connection to be refused if the link name does not match the global_name for the target database. Cheers, Mike Hately -Original Message- On Behalf Of Hybart, Clive Sent: 10 December 2003 10:39 To: Multiple recipients of list ORACLE-L Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ? E mail Disclaimer You agree that you have read and understood this disclaimer and you agree to be bound by its terms. The information contained in this e-mail and any files transmitted with it (if any) are confidential and intended for the addressee only. If you have received this e-mail in error please notify the originator. This e-mail and any attachments have been scanned for certain viruses prior to sending but CE Electric UK Funding Company nor any of its associated companies from whom this e-mail originates shall be liable for any losses as a result of any viruses being passed on. No warranty of any kind is given in respect of any information contained in this e-mail and you should be aware that that it might be incomplete, out of date or incorrect. It is therefore essential that you verify all such information with us before placing any reliance upon it. CE Electric UK Funding Company Lloyds Court 78 Grey Street Newcastle upon Tyne NE1 6AF Registered in England and Wales: Number 3476201 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hately, Mike (LogicaCMG) 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: Hybart, Clive 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- 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).
RE: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid
Title: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid username or password Hi there Clive! :) Are you getting any specific errors - and if so, what are they? Cheers Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Hybart, CliveSent: 10 December 2003 10:39To: Multiple recipients of list ORACLE-LSubject: Dblink fails between 8.1.7 (Unix) and 9i (Zos 390) due to invalid Since upgrading our mainframe database to 9.2.0.1.0.25 a dblink between a Unix box (8.1.7.0) and the mainframe fails. However sqlplus using the same connection syntax "Connect username/[EMAIL PROTECTED]" is fine. Any ideas, peeps ?
NT -> Win2K causes performance degradation..
Hi All, We've been asked a question from one of our clients that I'm a little stumped on. They run an OLTP database (Oracle 8.1.7), and have recently upgraded their NT machine to Windows 2000, they were running with 2gb of memory, and upgraded that to 4gb in the process. As they increased physical memory, they also increased their SGA size & db_block_buffers. Since they've upgraded they have noticed a significant decrease in performance (the way it was described to me was "it was 7 out of 10, and is now 3 out of 10"..). Has anybody else done a system upgrade of this nature that has caused less than desirable effects? Any pointers as to what to look at? We've requested some stats (top wait stats etc.) and I'll feed these back as and when I get them - but I thought I'd throw this out to you guys in the vague hope that someone has experienced some relatively similar experiences. 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.547 / Virus Database: 340 - Release Date: 02/12/2003 -- 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).
RE: granting SELECT privilege on SYS.X$ TABLES
Check out Jacques e-mail address - he *works* for Quest ;) -Original Message- Wolfgang Breitling Sent: 15 November 2003 07:04 To: Multiple recipients of list ORACLE-L Someone must have created sys.x_$ views on some of the sys.x$ tables. Installing statspack does that for example for X$KCBFWAIT, X$KSPPSV, X$KSPPI, and X$KSQST. Do you have quest? I believe it does it for some of the x$ tables as well. I routinely do it for all x$ tables in my test databases and grant select to the select_catalog_role. Then I can access the x$tables without having to log on as sys. In my test databases I always At 07:14 PM 11/14/2003, you wrote: >P.S. I forgot to mention that in all the databases (including the 8.1.7 >databases) in which I tried this, init parameter >O7_DICTIONARY_ACCESSIBILITY was set to FALSE. > >I always thought that one could not grant SELECT privilege on the SYS.X$ >tables, and to make them accessible to another user one would have to >create a view on the table (as mentioned on Steve Adams' ixora website: >http://www.ixora.com.au/scripts/prereq.htm >create_xviews.sql) > >However someone told me recently that you could grant SELECT on sys.X_$... > >When I tried this, I saw results that confused me. >In Database A, Oracle 8.1.7.4.1, Windows 2000 server, I was able to >1- grant select on SYS.X_$KTFBFE to another_user ; >2- grant select on SYS.X_$KTFBHC to another_user ; >3- grant select on SYS.X_$KTFBUE to another_user ; > >BUT > >4- grant select on SYS.X_$KDXST to another_user ; >returns ORA-00942 table or view does not exist. > >In database B, using the same ORACLE_HOME as database A (i.e. identical >Oracle version and OS) >even the first three grant statements returned ORA-00942 > >When I tried it on more recent Oracle databases on Windows / SunOS >servers, it worked intermittently: >Oracle 9.0 (SunOS): all GRANTS failed >Oracle 9.2 (SunOS): GRANTS 1-3 were successful, GRANT 4 failed >Oracle 10.1 beta (Windows 2000): all GRANTS failed > >Does anyone know the reason for this strange behaviour? >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jacques Kilchoer > 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). Wolfgang Breitling Centrex Consulting Corporation http://www.centrexcc.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Wolfgang Breitling 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.537 / Virus Database: 332 - Release Date: 06/11/2003 -- 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).
RE: [slightly OT[ infiniband
http://www.catc.com/conntech/infiniband.html I too was interested in it after reading the 10g article in "Oracle Magazine" ;) Regards 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 -Original Message- Jamadagni, Rajendra Sent: 06 November 2003 14:39 To: Multiple recipients of list ORACLE-L does any one know any good pointers to find more info about infiniband? The infamous googlecached 10g new features doc mentions support for infiniband and Sockets direct protocol. Hence my interest ... TIA Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! ** 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. **4 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: redhat/oracle
Hope this is not getting too off topic, but I thought this may also be of interest to those reading this thread: http://www.theregister.co.uk/content/4/33770.html "Novell bags SuSE for $210m Linux company SuSE was today acquired by Novell in a $210 million all-cash deal. The transaction is subject to regulatory approval and the winding up of shareholder agreements. Novell expects the transaction to close by the end of its first fiscal quarter (January 2004)." -Original Message- Rodd Holman Sent: 04 November 2003 14:59 To: Multiple recipients of list ORACLE-L No. But the free download of RH9 looks to end in March 04. Then there will only be the three pay versions starting at USD $179.00. All support for previous versions is GONE. Sounds like another Micro$oft in the birthing stage. Rodd On Tue, 2003-11-04 at 03:24, Mark Leith wrote: > OK, this is even more confusing to me. According to the following page: > > http://www.redhat.com/download/products.html > > "You can download Red Hat Linux for free from http://ftp.redhat.com or > ftp://ftp.redhat.com. To access the Red Hat FTP site, use anonymous as you > user name and your email address as the password." > > I actually downloaded Red Hat 9 on Friday. That download (in iso format) is > available from the above FTP (which is pretty overloaded lately), and also > available from: > > ftp://ftp.mirror.ac.uk/sites/ftp.redhat.com/pub/redhat/linux/9/en/iso/i386/ > > So, do I have to pay a license to use it? > > BTW, ftp://ftp.mirror.ac.uk/sites/ has to be one of the best FTP sites in > the world - bookmark it! ;) > > Cheers > > Mark > > > -Original Message- > Mladen Gogala > Sent: 04 November 2003 04:59 > To: Multiple recipients of list ORACLE-L > > > I'll try my luck with SuSE. It apparently has IBM support. Red Hat is > starting to act badly and brings memories of one former Xenix reseller > which made fortune by selling operating system written by IBM. > > On 2003.11.03 23:24, Jared Still wrote: > > This is news to me. RH will no longer let you download Linux for free? > > > > hmmm > > > > Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/ > > > > The cheapest version is $179.00 US. Looks like the next version > > for me will be Gentoo. > > > > Jared > > > > On Mon, 2003-11-03 at 17:54, Joe Testa wrote: > > > Well with RH latest ordeal of jumping out of simple ISOs and basically > > > no more free software, what is oracle's stand on running on RH?, the > > > paid version only from now on and those linux users out there, what are > > > WE going to do? > > > > > > Looking to see if i need to spend money before end of year for tax > > > write-off :) > > > > > > joe > > > > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > > -- > > > Author: Joe Testa > > > 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: Jared Still > > 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). > > > > -- > Mladen Gogala > Oracle DBA > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > INET: [EMAIL PROTECTED] > > Fat City Network Services-- 858-538-5051 http://www.fat
RE: redhat/oracle
And more in the thread: http://www.theinquirer.net/?article=12481 "RED HAT has told its customers that it will no longer support a version of Linux for the desktop, signalling that it believes its enterprise products stand more chance of bringing in the shekels. The firm emailed its customers yesterday, saying that it will discontinue maintenance and errata support for RHL 7.1, 7.2, 7.3 and 8.0 from December the 31st this year. Support for RH Linux 9 will end on April 30th 2004, and the firm said it does not plan to introduce any more products in the Red Hat Linux line. At the same time, RH said that it has a migration plan for network customers to move to Enterprise Linux V3. Although some think that Red Hat might be shooting itself in the foot with the move, like we said we suspect that its close cooperation with IBM has helped it come to the decision. And it's going to help the other Linux companies who are committed to desktop distributions." Nice move.. :( Mark -Original Message- Eddie Watkins Sent: 04 November 2003 09:49 To: Multiple recipients of list ORACLE-L As well as Redhat Enterprise Linux, there will be a free version called fedora. See http://fedora.redhat.com formore information. Eddie Watkins The Moray Council -Original Message- Sent: 04 November 2003 09:24 To: Multiple recipients of list ORACLE-L OK, this is even more confusing to me. According to the following page: http://www.redhat.com/download/products.html "You can download Red Hat Linux for free from http://ftp.redhat.com or ftp://ftp.redhat.com. To access the Red Hat FTP site, use anonymous as you user name and your email address as the password." I actually downloaded Red Hat 9 on Friday. That download (in iso format) is available from the above FTP (which is pretty overloaded lately), and also available from: ftp://ftp.mirror.ac.uk/sites/ftp.redhat.com/pub/redhat/linux/9/en/iso/i386/ So, do I have to pay a license to use it? BTW, ftp://ftp.mirror.ac.uk/sites/ has to be one of the best FTP sites in the world - bookmark it! ;) Cheers Mark The Moray Council: Internet E-mail Notice The contents of this e-mail and any attachments ('this e-mail') are confidential and intended solely for the addressee. If this e-mail has been sent to you by mistake, please notify [EMAIL PROTECTED] as soon as possible; you should then delete this e-mail from your computer. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eddie Watkins 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: redhat/oracle
OK, this is even more confusing to me. According to the following page: http://www.redhat.com/download/products.html "You can download Red Hat Linux for free from http://ftp.redhat.com or ftp://ftp.redhat.com. To access the Red Hat FTP site, use anonymous as you user name and your email address as the password." I actually downloaded Red Hat 9 on Friday. That download (in iso format) is available from the above FTP (which is pretty overloaded lately), and also available from: ftp://ftp.mirror.ac.uk/sites/ftp.redhat.com/pub/redhat/linux/9/en/iso/i386/ So, do I have to pay a license to use it? BTW, ftp://ftp.mirror.ac.uk/sites/ has to be one of the best FTP sites in the world - bookmark it! ;) Cheers Mark -Original Message- Mladen Gogala Sent: 04 November 2003 04:59 To: Multiple recipients of list ORACLE-L I'll try my luck with SuSE. It apparently has IBM support. Red Hat is starting to act badly and brings memories of one former Xenix reseller which made fortune by selling operating system written by IBM. On 2003.11.03 23:24, Jared Still wrote: > This is news to me. RH will no longer let you download Linux for free? > > hmmm > > Sure enough, look at http://www.redhat.com/apps/commerce/rhel/ws/ > > The cheapest version is $179.00 US. Looks like the next version > for me will be Gentoo. > > Jared > > On Mon, 2003-11-03 at 17:54, Joe Testa wrote: > > Well with RH latest ordeal of jumping out of simple ISOs and basically > > no more free software, what is oracle's stand on running on RH?, the > > paid version only from now on and those linux users out there, what are > > WE going to do? > > > > Looking to see if i need to spend money before end of year for tax > > write-off :) > > > > joe > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Joe Testa > > 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: Jared Still > 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). > -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: datatypes varchar to number
What's the data like in the varchar field? Is it in number format? A quick sample would be good. -Original Message- [EMAIL PROTECTED] Sent: 03 November 2003 11:14 To: Multiple recipients of list ORACLE-L Hallo, Maybe this sounds simple for all of you, but I have a table with the field PRICE and that is with datatype varchar2 I want the data in that field to be inserted in another table with field PRICE, but that field has the datatype NUMBER. How can I deasiest do this sql statement? I really have to have the Varchar dataype in table1. Thanks in advance Roland -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: HELP HELP Trying to find this: PL/SQL MD4 and MD5 by Keith Gardne
The page seems to be dead. A quick search on google: http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=PL%2FSQL+MD4+and+MD5+ by+Keith+Gardner+&X=1 Turned up this page: http://pajhome.org.uk/crypt/md5/ that has a link to the page you are after: http://www.gt.ed.net/keith/plsql/ But, as I said - it seems to be dead. Mark -Original Message- Paulo Gomes Sent: 31 October 2003 11:34 To: Multiple recipients of list ORACLE-L Gardne I'm trying to find this web Page PL/SQL MD4 and MD5 by Keith Gardner Can anyone help me? Regards PG -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Paulo Gomes 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: SQL and PL/SQL tuning template document required urgently
How about: http://www.oreilly.com/catalog/orsqltunpr/ "Oracle SQL Tuning Pocket Reference", by one of our esteemed partners - Mark Gurry. Mark -Original Message- Ranganath K Sent: 29 October 2003 14:24 To: Multiple recipients of list ORACLE-L Hi there, Does any body have a template for proactive and reactive query tuning which can be used as a guideline/report while tuning simple, medium complex and complex SQL queries and PL/SQL stored procedures? If so, can you please forward the same to me please? If not, can anybody suggest as to how to go about doing one? Any help in this regard is very much appreciated. Thanks and Regards, Ranganath -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ranganath K 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: 8th Deadly Sin - Unkept Promises
As a tool provider, I'm interested - what promises did they make for OEM 10g? Cheers Mark -Original Message- Yechiel Adar Sent: 28 October 2003 09:54 To: Multiple recipients of list ORACLE-L The fact that they baited you with 10g to make you listen to sales pitch does not say anything about 10g. I was in OOW in Paris last week and 10g seems to have a lot of goodies in it. As we are now moving to 9.2 I do not think that we will use 10g but will jump, in 3-4 years, to 11g. Anyway I am going to move to OEM 10g, if they deliver on promises made during presentations. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, October 27, 2003 7:19 PM > > I went to Oracle technology day in Milwaukee the other day and was a bit put > off by the marketing hype on 10g and the lack of 10g facts. The "technology > day" was promoted as a "grid" day...10g this and grid that. What did we get? > Marketing hype about collaboration suite. They used 10g to get people to > come and listen to pitches for 9iRAC and collaboration suite. > > The demo on 9iRAC was on RAW partitions and was not useing OCFS. > > If 10g is a dissapointment when it finally ships I think I might start > looking to learn another Db platform. > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Odland, Brad > 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: Yechiel Adar 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: dba interview questions
How salty is the water? -Original Message- Bellow, Bambi Sent: 27 October 2003 17:20 To: Multiple recipients of list ORACLE-L Bill -- I appreciate your input to this very complex question. IMHO, however, "she turned me into a newt!" is, technically, an interview *statement* rather than an interview *question*. That being said, it can be used at the beginning or end of the interview to set tone, but lesser candidates might be inclined to send envelopes full of grass to thank you for taking the time to interview them. This may, or may not, be received favorably, and one must realize the risks in making bold statements when interviewing candidates who may be subpar. Along those lines, I admit that in all my years of interviewing, I have found that there are interview questions that it is simply better not to ask: "when do you come around next?" (leads interviewee to think that he has advanced to a second interview), and "how do you know he's a king?" (leads to answers about SCOTT and MILLER with CONNECT BYs. Not at all the intended response). However, I think you're on the right track, if a bit early in the scene. Perhaps you'd consider "What also floats in water?". Of course, there are multiple answers (e.g., apples, very small stones, mud, churches) which could arguably be deemed to show an acceptable level of knowledge, an ability to think outside the box, and an inventive approach, even if the salient points might not be wholly accurate. Even so, the correct answer (a duck) is technically not correct as it does not float, but swims (new scientific has determined this with a fair amount of accuracy), and I'd hate to hire a DBA who was stuck in old paradigms of science and/or technology. A CICS programmer, sure, but not a DBA. Now, if you'll just bring me a shrubbery, I can get on with my database analysis. Bambi. -Original Message- Sent: Friday, October 24, 2003 9:24 AM To: Multiple recipients of list ORACLE-L Cary Millsap scribbled on the wall in glitter crayon: > Bambi, > > Be careful. Many will fall in love with you if you continue to submit > such things as this to the list. how about: "she turned me into a newt!" "a newt?" "i got better." -- Bill "Shrek" Thater ORACLE DBA "I'm going to work my ticket if I can..." -- Gilwell song [EMAIL PROTECTED] Behind an able man there are always other able men. - Chinese Proverb -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thater, William 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: Bellow, Bambi 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: Oracle pricing ain't going down
onitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.530 / Virus Database: 325 - Release Date: 22/10/2003 -- 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).
RE: Do not connect Oracle DB to the Internet. Oracle Alert #59
I find it more interesting that the problem doesn't apply to Windows servers... ;) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: 23 October 2003 14:25To: Multiple recipients of list ORACLE-LSubject: Do not connect Oracle DB to the Internet. Oracle Alert #59Important: Please read the following Oracle Alert.We strongly recommend that you do not connect the Oracle Databasedirectly to the Internet.Got your attention? That is what is in the Alert. These alerts are beginning to come all too often. Sounds just like Microsoft's software, yeah?Buffer Overflow in Oracle Database Server BinariesThis is with the Oracle kernel/binary itself ie 'oracle' or 'oracleO' filein $ORACLE_HOME/bin.DescriptionA potential buffer overflow has been discovered in the oracle and oracleO (the letter O) binariesof the Oracle Database. A knowledgeable and malicious local user can exploit this buffer overflowto execute code on the operating system hosting the Oracle Database server.Products Affected· Oracle 9i Database Release 2, Version 9.2.x· Oracle 9i Database Release 1, Version 9.0.xPlatforms AffectedAll supported UNIX and Linux operating system variants.Patch only available for Linux right now. So who found out this vulnerability? David Litchfield? Aaron Newman?I know it is a bit silly to ask but does anyone know how to exploit this vulnerability? Send it to me directly if you dont want to reply publiclytatony
RE: using temp tables for staging databases?
Tim, Can you sum up a few situations when the need *has* arisen to change these values? Cheers Mark -Original Message- Tim Gorman Sent: 21 October 2003 06:09 To: Multiple recipients of list ORACLE-L Unless you typo'd, there are some serious problems here... Setting PCTFREE to 99 is not likely to "pack in the blocks". Rather the opposite; you are instead leaving blocks 99% empty. Quite a bit of wasted I/O in performing a FULL table scan here... :-) Anyway, it is not a good idea to have PCTFREE and PCTUSED sum to a value greater than 70 or 80 or so, just as a rule of thumb. Having them sum to a value near 100 ensures that each insert, delete, or even update will potentially cause the block to be removed or reinserted to one of the segment's free list. Think about it: the width of a single row crossing the boundary from "off the free list" to "on the free list". Better to leave a bit of a "no man's land" between the two values. The default settings of PCTFREE=10 and PCTUSED=40 are one of the few default settings that need little manipulation for most situations. on 10/20/03 7:34 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: > we drop and recreate the temp tables every night. We also use PCTFREE PCTUSED > at 99 and 1 to pack in the blocks and we use very small extent sizes. then we > analyze with an estimate size of 20 percent which is quite fast. > > All of them are used for full table scans and do not have indexes. Ive found > that a 'create table as' is MUCH faster than inserting into global temporary > tables when you do not have to worry about latch contention(ie 1-3 users > logged in at a time). > > anyone else notice this? Seems to go against conventional wisdom which says > never use them. So I want to make sure Im not missing something. >> >> From: Tim Gorman <[EMAIL PROTECTED]> >> Date: 2003/10/20 Mon AM 10:19:33 EDT >> To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >> Subject: Re: using temp tables for staging databases? >> >> All the time. Oracle Apps's "open interfaces" are built this way, for >> example. >> >> However, "the guys here" covered their bases by specifying "smaller >> temporary tables", as if they could prevent them from becoming large. I >> suppose they might feel that they indemnify themselves if the tables should >> ever become "large"? >> >> As with OraApps "open interface" tables, it is when a large volume of data >> is pushed through that the trouble starts. The "high-water marks" on all >> the tables are pushed to a high level, thereafter causing full table scans >> on the interface/temporary tables to run slowly. The only way to bring the >> HWM back down is quiesce the interface/app and then truncate the tables. >> >> >> >> on 10/20/03 6:39 AM, [EMAIL PROTECTED] at [EMAIL PROTECTED] wrote: >> >>> This is for non-transactional data load instances. The guys here sware that >>> by >>> using smaller temporary tables(not global temp tables) they can increase the >>> speed of the data loads. >>> >>> Not worried about latch contention because its just for bulk loads. I know >>> this bad in transactional instances. Has anyone used these in >>> non-transactional data load instances? >> >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> Author: Tim Gorman >> 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: Tim Gorman 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 a
RE: LOG MINER utiliry
You need the power of the Grid! ;) Sorry, can't help from my side - just couldn't resist! -Original Message- Rakesh Gupta Sent: 20 October 2003 17:00 To: Multiple recipients of list ORACLE-L We are trying to analyze 200G of redologs (archive logs) from past 1 year. The database is on windows and the log miner is taking about 4 hours to analyze 2G log files. Is it possible to move the log files to sun SPARC Solaris and analyze ? I would think the log files between NT and Unix won't be compatible but I am looking for ideas. Thanks Rakesh -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rakesh Gupta 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 -- 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).
RE: Question about sql
Ahh maybe I read it a little wrong then... ;D -Original Message- Quintin, Richard Sent: 16 October 2003 15:49 To: Multiple recipients of list ORACLE-L insert into table3(company_id,lev_id,vare_id) select company_id,lev_id,vare_id from table2 where vare_id = 56 AND exists (select 1 from table1 where table1.company_id = table2.company_id) On Thu, 2003-10-16 at 10:20, [EMAIL PROTECTED] wrote: > Hallo, > > Anyone whom could gíve me some good help on this. > > I have a table with one field, called Company_id > Like this > >Company_id > > 16 > 45 > 50 > > > In table 2 I have this field and values: > > Company_id Lev_idVare_id > > 16 45 56 > 34 10 20 > 67 10 20 > 45 15 30 > 50 12 12 > > I would like to from table 2 do a select and find the Company_ids from table1 and > find out the responding lev_id and vare_id in table2and then insert them into a new > table(table3) so it would look like this: > > Company_idLev_idVare_id > 1645 56 > > > > > Anyone whom could give me some help on this how to write the sql- query. > > I have tried with this sql query. What is wrong? > > insert into table3(company_id,lev_id,vare_id) > select company_id,lev_id,vare_id from table2 where vare_id = 56 > (where exists select company_id from table1) > > > Thanks in advance > > > > Roland > > > > > > > > > > > > > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net Richard Quintin, DBA Information Systems & Computing, DBMS Virginia Tech -- "Living in the moment brings you a sense of reverence for all of life's blessings." -- Oprah Winfrey -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Quintin, Richard 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 -- 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).
RE: Question about sql
SQL> select * from test1; COMPANY_ID -- 16 45 50 SQL> select * from test2 2 ; COMPANY_ID LEV_IDVARE_ID -- -- -- 16 45 56 34 10 20 67 10 20 45 15 30 50 12 12 SQL> create table test3 as 2 (select test2.company_id,lev_id,vare_id 3 from test1, test2 4where test1.company_id = test2.company_id); Table created. SQL> select * from test3; COMPANY_ID LEV_IDVARE_ID -- -- -- 16 45 56 45 15 30 50 12 12 HTH Mark -Original Message- [EMAIL PROTECTED] Sent: 16 October 2003 15:20 To: Multiple recipients of list ORACLE-L Hallo, Anyone whom could gíve me some good help on this. I have a table with one field, called Company_id Like this Company_id 16 45 50 In table 2 I have this field and values: Company_id Lev_idVare_id 16 45 56 34 10 20 67 10 20 45 15 30 50 12 12 I would like to from table 2 do a select and find the Company_ids from table1 and find out the responding lev_id and vare_id in table2and then insert them into a new table(table3) so it would look like this: Company_idLev_idVare_id 1645 56 Anyone whom could give me some help on this how to write the sql- query. I have tried with this sql query. What is wrong? insert into table3(company_id,lev_id,vare_id) select company_id,lev_id,vare_id from table2 where vare_id = 56 (where exists select company_id from table1) Thanks in advance Roland -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 -- 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).
RE: what are leaf blocks and table high water marks?
A Leaf Block is an index block. In a B*tree index, index blocks are either branch blocks (the "top" blocks within the B*tree index), or leaf blocks (the "lower" level index blocks). Branch blocks hold index data that point to lower level index blocks. Leaf blocks hold every indexed data value and a corresponding ROWID used to locate the actual row of data. See: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c11schem .htm#3353 A tables High Water mark is a mark that is set against a table, pointing to the highest amount of data that has been inserted in to that table at any one time. Say you inserted 1,000,000 rows in to the table, then delete 200,000, the HWM would point at 1,000,000 rows. It is used as a boundary for space management, and can also be used by the optimiser to make poor choices under certain circumstances.. ;) You can't release space below the high water mark, even if there is no data below that high water mark (an empty table). The only way to do this is via the TRUNCATE command. See: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96521/schema.h tm#6870 HTH 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 -Original Message- [EMAIL PROTECTED] Sent: 15 October 2003 10:39 To: Multiple recipients of list ORACLE-L can anyone explain what are leaf blocks and table high water marks? thanks. -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.524 / Virus Database: 321 - Release Date: 06/10/2003 -- 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).
RE: toad on linux
Tora. You can get a copy for Linux free of charge, although the Windoze version has a commercial license charge. For more info: http://www.globecom.se/tora/ For the Linux/Oracle 9 rpm: http://prdownloads.sourceforge.net/tora/tora-1.2.4-1oracle9.i686.rpm HTH 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 -Original Message- [EMAIL PROTECTED] Sent: 03 October 2003 17:24 To: Multiple recipients of list ORACLE-L Hello, It appears that Toad does not run on the Linux desktop, or at least the system requirements mention only Windows platforms. Does any one know of any toad-like tools that do run on Linux? Specifically, Red Hat Linux? The server would be a 9.2.0.4 database also running on Red Hat Linux AS 2.1, or the soon-to-be-released Enterprise Linux 3.0. Also, does Oracle Enterprise Manager run on Linux? Thanks to any responders. -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003 -- 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).
RE: Separate Indexes and Data
Couldn't you do this with a simple: select owner, table_name from all_tables where tablespace_name = 'index_tbs'; ? Or of course use IN for a list of tablespaces? Or am I missing something? -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: 30 September 2003 22:45To: Multiple recipients of list ORACLE-LSubject: RE: Separate Indexes and DataGood question Ian. If anyone does have a different backup schedule for index tbs , I would be interested to know how they ensure that the index TBS do not have any data segments in them. Jared "MacGregor, Ian A." <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 09/30/2003 10:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Separate Indexes and DataI'd be very interested to know how many people have their index tablespaces on a different backup schedule from their data tablespaces. If so how different? What happens when a media failure occurs and you must restore from backup? You would need to have on hand and apply more redo logs to make the database current. I understand the argument proffered is separating indexes and data can mean that when physical corruption of the file happens to an index tablespace then all one needs do is to offline, drop, drop and rebuild the index tablespace. I admit I have not tried off-lining the tablespace first, but you cannot normally drop a tablespace which is being used to enforce referential integrity. If off-lining the tablespace first does work, I can see someone trying to do the rebuild with the database available and having duplicate records in the parent tables and records without parents in the child tables.On the size of the segments: The paper entitled "How To Start Defragmenting and Start Living" or something like that strongly advocated uniform extent sizes, the suggestion sizes were 128K, 4M, 128M, and 4G as I recall. However the paperNever mentioned what to do when an object that used to fit nicely into the 128k extent category now more properly belongs to the 4M category. If you move the data, large holes are left in the other tablespace, and while this does not impact Oracle performance, it does mean that your physical backups are larger than necessary. I am in the process of migrating from uniform to autoallocated extents. This means extents of different sizes share the same tablespace. The extent sizes being multiples of each other. This removes the argument about not having indexes and data in the same tablespaces due to their different sizes. Ian MacGregorStanford Linear Accelerator Center [EMAIL PROTECTED]-Original Message-Sent: Monday, September 29, 2003 8:10 AMTo: Multiple recipients of list ORACLE-LThomas,It *is* a good idea to separate index data from heap data into different tablespaces. But the reason isn't solely to eliminate I/O competition. Even if I/O competition isn't an issue for you (and the OFA Standard doesn't say that it will be), then it's *still* a good idea to separate your index data from your heap data, for reasons including:* Index segments have different backup and recovery requirements than their corresponding heap segments. For example, as Peter mentioned, if you have an index block corruption event, then it's convenient to just offline, kill, and rebuild an index tablespace. If the indexes and data are mixed up in a single tablespace, this is not an option. Anotherexample: If you construct your backup schedule to make media recovery time a constant, then you probably don't need to back up your indexes on the same schedule as you back up your heaps. But unless they're in different tablespaces, this isn't an option either.* Index segments are usually smaller than their corresponding heap segments. Using separate tablespaces allows you to use a smaller extent size to conserve disk storage capacity.I don't think I ever wrote that you need to put indexes and their corresponding tables/clusters on separate disks, but you do need to be*able* to do that if your I/O rates indicate that you should.For the original OFA Standard definition, please see section 3 of the document called "The OFA Standard--Oracle for Open Systems," and section 5 of "Configuring Oracle Server for VLDB," both available for free at www.hotsos.com.Cary MillsapHotsos Enterprises, Ltd.http://www.hotsos.comUpcoming events:- Performance Diagnosis 101: 10/28 Phoenix, 11/19 Sydney- Hotsos Symposium 2004: March 7-10 Dallas- Visit www.hotsos.com for schedule details...-Original Message-Thomas DaySent: Monday, Sep
RE: Off Topic: PC Firewall Recommendation
I've used Black Ice in the past as well Peter, and I know what you mean on that count. I now user Sygate Personal Edition, which is a LOT better at this. It won't let anything in, nor *out* without asking me if it's OK. It also holds a log of incoming and outgoing traffic, showing accepted and blocked. Very good little firewall in my opinion, and I've used Black Ice, Zonealarm, and Symantec products in the past. It's ideal for a single PC (home) installation. http://smb.sygate.com/buy/download_buy.htm (The Free version is at the bottom). Mark -Original Message- Robson, Peter Sent: 29 September 2003 18:50 To: Multiple recipients of list ORACLE-L On the same area - I'm using Black Ice, but its never been clear to me whether these products trap outgoing stuff. The BIG problem as I see it as when one inadvertently loads a 1 pixel gif, populated from a rogue site, which then gives implicit confirmation that there is a PC at the end of the line... Anyone been down this particular topic? peter edinburgh > -Original Message- > From: Brian Dunbar [mailto:[EMAIL PROTECTED] > Sent: Monday, September 29, 2003 6:05 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Off Topic: PC Firewall Recommendation > > > KENNETH JANUSZ [mailto:[EMAIL PROTECTED] on Monday, September > 29, 2003 9:05 > AM said; > > > > I have a Dell 8200 with XP Prof. SP1. > > > I would like recommendations as to a good firewall for this > machine. XP > has a firewall but it is not the greatest. > > ZoneAlarm on the desktop - free version or pay to upgrade to the pro > version. > Assuming you have a home network, you also want to buy a > DSL/Cable router - > which has it's own firewall built in. > > If you're feeling frisky, consider replacing the > router/firewall with a PC > (with 2 nics) running BSD or Linux. You can also find > distros tweaked to > act as a firewall/router - that's what I've done. > > FWIW, a friend of mine had his XP system plugged directly into his RR > connection. Friend said he didn't need a firewall or router > (I'm not into > that security crap, I just want to play games). Friend has now had to > reformat his box (and lost work) because his box was rooted, > blasted and > fubared within days of hooking it to the cable connection > w/out a firewall. > YMMV. > > ~brian > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Brian Dunbar > 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. .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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.521 / Virus Database: 319 - Release Date: 23/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (h
RE: Off Topic: PC Firewall Recommendation
I use Sygate Personal Firewall (free), and I've never had any problems. Very good little firewall. Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Jamadagni, RajendraSent: 29 September 2003 15:20To: Multiple recipients of list ORACLE-LSubject: RE: Off Topic: PC Firewall Recommendation I use Mcafee online Virus scanner and firewall. Been happy for 3+ years. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message-From: KENNETH JANUSZ [mailto:[EMAIL PROTECTED]Sent: Monday, September 29, 2003 10:05 AMTo: Multiple recipients of list ORACLE-LSubject: Off Topic: PC Firewall Recommendation I have a Dell 8200 with XP Prof. SP1. I would like recommendations as to a good firewall for this machine. XP has a firewall but it is not the greatest. Thanks much, Ken Janusz, CPIM
RE: guidance
http://www.theregister.co.uk/content/53/33042.html -Original Message- Stephane Faroult Sent: 25 September 2003 02:45 To: Multiple recipients of list ORACLE-L Well, concerning point 4), I am surprised by the resilience of users to often dreadful applications. Perhaps that with age I am getting more and more impatient, but in their place I would have flown terminal and keyboard across the room. Perhaps I have memories of a time when machines weren't even a shadow of today's, and performance were hardly worse than many things you see running today. When you try to measure the amount of 'business units processed per unit of work', it is pathetic more often than it should be. I guess that what saves many designers and developers from being lynched by popular justice is that most users have no idea about what *could* be done and are ready to swallow that Oracle is slow, their 64 processor machine not powerful enough, etc, etc. SF Tanel Poder wrote: > > Forget the modern tuning skills and when you're asked what shows the best > that your database works optimally; > > 1) Buffer cache hit ratio is 99% > 2) Buffer cache hit ratio is 99,999% > 3) Buffer cache hit ratio is 99% > 4) Users aren't complaining > > Then answer 3 for sure ;) > > Tanel. > > - Original Message - > To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> > Sent: Thursday, September 25, 2003 12:04 AM > > > List , I am planning to give my 9i performance tuning exam on the first
RE: Anyone have a copy of DUL ??
> (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: Juan Miranda > 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). __ Do you Yahoo!? Yahoo! SiteBuilder - Free, easy-to-use web site design software http://sitebuilder.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: Rman equivalent for MS-SQL server
You can actually use Database Maintenance Plans, to mimic RMAN to a certain extent. Database Maintenance Plans is basically a wizard that generates a load of MSDB jobs that get run by the SQL*Agent. This does have some limitations though. It has no support for differential backups, doesn't support appended backups to an already existing "device", you can't duplex back up files, and a number of the backup options aren't available. This is described in some detail in "SQLServer for Oracle DBAs" an e-book that I would highly recommend to all primarily Oracle DBAs that have to do a certain amount of SQLServer work too. http://www.chriskempster.com/ HTH 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 -Original Message- Gudmundur Josepsson Sent: 16 September 2003 11:19 To: Multiple recipients of list ORACLE-L There is no MSSQL utility that is directly equivalent to RMAN. You use Enterprise Manager or Query Analyzer to manage backups. Gudmundur - Original Message - To: Multiple recipients of list ORACLE-L Sent: Tuesday, September 16, 2003 9:39 AM Hi good people- Does anyone out there know of the equivalent of oracles RMAN in MS SQL server environs. Im investigating the possibility of having my SQL server dump the backups direct to a third party tape library VERITAS to be specific. Your input on this thread will be highly appreciated. CSW Simon. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: Good & small reference !
http://otn.oracle.com/pls/db92/db92.docindex?remark=homepage Reference: http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96536/toc.htm Supplied PL/SQL Packages and Types Reference: http://download-west.oracle.com/docs/cd/B10501_01/appdev.920/a96612/toc.htm Have Fun! That's some memory you've got there!! ;) Mark -Original Message- Veeraraju_Mareddi Sent: 12 September 2003 12:19 To: Multiple recipients of list ORACLE-L Dear Friends, I am looking for a good reference of all ( some which are very much useful & required for DBA ) the SQL scripts ,packages and all required views. UTL*.sql , DBMS_* DBA_* V$* I just want to memorize the important of above. Any document, PPT or white paper or any URL will be helpful. Appreciate your responce. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: OT Re: RE: What is a large database?
LOL, Mauve is a shade of the colour Purple. And of course, everybody knows that purple databases run faster! ;) Personally, I've always preferred Electric Blue databases, funky, fast, and FAR easier to manage! -Original Message- Guido Konsolke Sent: 12 September 2003 08:54 To: Multiple recipients of list ORACLE-L Hi Mladen, please excuse me. Since I try to improve my knowledge about the English: what do youmean with muave? Some kind of wood? Please enlighten me. Greetings, Guido >>> [EMAIL PROTECTED] 11.09.2003 20.49 Uhr >>> And the database must be muave. -- Mladen Gogala Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Guido Konsolke 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: 9.2.0.4 anyone
Where? I can only see 9.2.0.2 on the otn download site.. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: 11 September 2003 01:20To: Multiple recipients of list ORACLE-LSubject: Re: 9.2.0.4 anyoneYeah, been out for some time now actually. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/10/2003 04:25 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 9.2.0.4 anyoneWhat? 9.2.0.4 is out now?RWBReginald W. BaileyIBM Global Services - ETS SW GDSD - Database ManagementYour Friendly Neighborhood DBA713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)[EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: 9.2.0.4 anyone ity.com 09/10/2003 05:24 PM Please respond to ORACLE-L Anyone have any negative experiences with 9.2.0.4 yet?Robert--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Freeman Robert - IL INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: 9.2.0.4 anyone
Where? I can only see 9.2.0.2 on the otn download site.. -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: 11 September 2003 01:20To: Multiple recipients of list ORACLE-LSubject: Re: 9.2.0.4 anyoneYeah, been out for some time now actually. [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 09/10/2003 04:25 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: 9.2.0.4 anyoneWhat? 9.2.0.4 is out now?RWBReginald W. BaileyIBM Global Services - ETS SW GDSD - Database ManagementYour Friendly Neighborhood DBA713-216-7703 (Office) 281-798-5474 (Mobile) 713-415-5410 (Pager)[EMAIL PROTECTED][EMAIL PROTECTED] [EMAIL PROTECTED] com To: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: 9.2.0.4 anyone ity.com 09/10/2003 05:24 PM Please respond to ORACLE-L Anyone have any negative experiences with 9.2.0.4 yet?Robert--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Freeman Robert - IL INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso 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.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: what is a materilized view ?
http://www.google.com/search?hl=en&lr=&ie=UTF-8&oe=UTF-8&q=materialized+view &spell=1 http://oracle.oreilly.com/news/oracle8_0600.html http://technet.oracle.com/products/oracle9i/daily/jul05.html "A materialized view is like a view in that it represents data that is contained in other database tables and views; yet it is unlike a view in that it contains actual data. A materialized view is like an index in that the data it contains is derived from the data in database tables and views; yet unlike an index in that its data must be explicitly refreshed. Finally, a materialized view is very much like a snapshot in that an administrator can specify when the data is to be refreshed; but it is unlike a snapshot in that a materialized view should either include summary data or data from many different joined tables." The wonders of Google! ;) HTH Mark -Original Message- Veeraraju_Mareddi Sent: 10 September 2003 12:04 To: Multiple recipients of list ORACLE-L Dear Freinds, what is a materilized view ? what is the use of it and how to create it. Any docs or notes or white papers will be helpful. TIA, Rajuveera ** This email (including any attachments) is intended for the sole use of the intended recipient/s and may contain material that is CONFIDENTIAL AND PRIVATE COMPANY INFORMATION. Any review or reliance by others or copying or distribution or forwarding of any or all of the contents in this message is STRICTLY PROHIBITED. If you are not the intended recipient, please contact the sender by email and delete all copies; your cooperation in this regard is appreciated. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Veeraraju_Mareddi 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: Database Link
Yechiel, oerr isn't installed on Windows machines - only on UNIX installs.. oerr is basically a shell script that reads the oraus.msg file under a UNIX install (and some others too I think). Windows has a binary file under %ORACLE_HOME%\RDBMS\mesg\oraus.msb, which if you open it has the descriptions pretty much in plain text, but the error codes aren't very legible.. There are a couple of ways to get the functionality on Windows though. Some require you to have access to a Oracle on UNIX install, so that you can parse the $ORACLE_HOME/RDBMS/mesg/oraus.msg file, and load the contents in to a database table. You can use sqlerrm(-600) from within SQL*PLus, but this only provides the ORA errors, you don't get TNS etc. If you have perl installed, there is a perl script available on orafaq.org that can be used to simulate the oerr utility, it's here: http://www.orafaq.org/scripts/perl/oerr.txt Grab the PDF documentation.. ;) http://download-uk.oracle.com/docs/cd/B10501_01/server.920/a96525.pdf HTH 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 -Original Message- Yechiel Adar Sent: 10 September 2003 09:54 To: Multiple recipients of list ORACLE-L Hello Jared What is the oerr utility? I just finished searching my disk for *oerr* and no exe or com file found. Oracle 9.2.0.4 on windows. Yechiel Adar Mehish - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 5:54 PM > > The error message should be a definite clue. > > If you're not familiar with the 'oerr' utility, now is > the time to try it out. > > On either of your servers, type this command from the > system command prompt: oerr ora 12154 > > The info provided there should make it clear that > some modification are needed to your sqlnet ( net 8, > oracle net, whatever) environment on the server > with the 9i database. > > Jared > > On Mon, 2003-09-08 at 14:39, Hamid Alavi wrote: > > Dear List, > > > > I have two database one on 8.1.7.4 on sun Solaris 8.2 and another one on > > oracle 9.0.1(two separate box) I have created a database link under oracle > > 8 to oracle 9 database & it's working fine from 8 to 9, but when I try to > > use this link from 9 to 8 it's failed to ORA-12154. > > Any idea what could be this?? > > > > Thanks allot for your help. > > > > > > > > Hamid Alavi > > > > Office : 818-737-0526 > > Cell phone : 818-416-5095 > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Hamid Alavi > > 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: Jared Still > 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: Yechiel Adar 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
RE: EM To Go
may also send the HELP command for other information (like subscribing). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: Re: Oracle Masters exam
So, what was your reason for taking the OCM exam Tanel? Mark -Original Message- Tanel Poder Sent: 08 September 2003 22:10 To: Multiple recipients of list ORACLE-L About 50 I believe. But there are probably more DBAs in the world who don't give a damn about this (or any other) certification, because they're good and known without it anyway. Most of OCMs are currently from States, only few in Europe. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, September 08, 2003 11:39 PM > Too many. > > -- > Mladen Gogala > Oracle DBA > > > > > -Original Message- > > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On > > Behalf Of [EMAIL PROTECTED] > > Sent: Monday, September 08, 2003 3:40 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Re: Re: Oracle Masters exam > > > > > > how many ocms are there world wide? > > > > > Note: > This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. > Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Mladen Gogala > 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: Tanel Poder 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: EM To Go
I suppose I better find a new job then eh? ;) Mark (PocketDBA and monitoring/management tool Sales & Support Critter) Leith -Original Message- Binley Lim Sent: 08 September 2003 17:49 To: Multiple recipients of list ORACLE-L IMHO, I cannot see a use for such a gadget. Production "issues" come under 2 categories: 1. It can wait until tomorrow. 2. I have to do something now. In the first case, I am happy to remain blissfully un-aware until I get to work. In the second case, I prefer a proper screen and keyboard to do the work. In this case, a pager is more than sufficient as a notification device. Anything else in between should have already been *proactively* alerted (and addressed) via a monitoring tool, or more effectively and reliably via a whole bunch of home-grow scripts. The options I have seen advertised for such a gadget include adding users or adding datafiles (which is probably obsolete with 10g anyway). If you have to do these things re-actively via a PDA, you have to seriously look at getting out of fire-fighting mode in the first place. In fact, I have never equated OEM with usefulness or reliability - remains to be seen what 10g is like. To be fair, all monitoring tools I have worked with, or evaluated, can only be ranked according to their degree of un-usability. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, September 09, 2003 2:29 AM > I be Ari Kaplan, designer and creator of Pocket DBA is not very happy. On the other hand he should be, they are following his idea. > > BTW, you can get a Palm VII [the dinosaur] for about $50 and it has a modem, probably more than you need to monitor a database. $70 with external keyboard. > > Luis > > -Original Message- > Sent: Monday, September 08, 2003 7:30 AM > To: Multiple recipients of list ORACLE-L > > > http://www.infoworld.com/article/03/09/05/HNorremote_1.html > > Now if only I had a PDA. > > Patrice. > -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Binley Lim 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: Remote Installation of Oracle on Win2K
I've managed to do it over TightVNC on a Windows XP Pro machine. Not sure if that helps a great deal, but Tighten is one other possibility (http://www.tightvnc.com and it's Free! ;) ). HTH 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 -Original Message- Carol Bristow Sent: 08 September 2003 16:39 To: Multiple recipients of list ORACLE-L According to the installation guide, which happens to be on my desk, "Installation of Oracle 9i server components from a remote Terminal Services Client onto a Windows 2000 server that is running Terminal Server Service or a Windows NT 4.0 Terminal Server is unsupported. If you attempt to install Oracle 91 in this manner, many database configuration tools hang." It goes on to list examples, which include the database configuration assistant and the database upgrade assistant. HTH, Carol Bristow DPRA Inc. 1300 N 17th St Suite 950 Rosslyn, VA 22209 Work: 703-841-8025 Fax: 703-524-9415 -Original Message- Sent: Monday, September 08, 2003 11:29 AM To: Multiple recipients of list ORACLE-L Has anyone performed a remote install of Oracle 9i onto a Windows 2000 Server using PCAnywhere or know if it will work? Trying to avoid having to go to the console which is about an hour away by car at IBM's data centre. _ STOP MORE SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: david davis 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: Carol Bristow 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: EM To Go
Dick, This is actually one of the largest misconceptions with PocketDBA/PocketAdmin - the term "wireless" or having to use it on a "WLAN (Wireless LAN)".. You may notice now that Expand Beyond are marketing PocketDBA as a "Mobile" tool rather than a "Wireless" tool. You can use PocketDBA via a dial-up (from a mobile phone) to a RAS server or VPN - just the same as you would with a laptop. Over here in the UK we actually recommend that it's used this way - as opposed to touching an internet facing server, or over a WLAN.. We're not overly concerned about EM 2 Go right now - the Pocket tools are streets ahead of EM 2 Go from what we last heard. In my experience most people are looking for tools that can cover the breadth of their environments, and whether we like it or not, a lot of companies that are using Oracle also use SQLServer, or DB2 as well. With the Pocket tools you can manage your UNIX systems or any VT100 compliant system such as a hardware firewall or router (PocketAdmin Console), Windows environments such as domains, users, systems, Exchange Server etc. (PocketAdmin for Windows), and most of the major database vendors (Oracle, SQLServer, DB2 - Teradata in the next month). Can EM 2 Go do this? I think not... ;) I've not heard a lot about the functionality within EM 2 Go, the last we heard (at the start of this year) was that it was no where near PocketDBA. I've never seen or used EM 2 Go my self yet, so I'd be interested in comments from anybody that has! 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 -Original Message- Goulet, Dick Sent: 08 September 2003 15:35 To: Multiple recipients of list ORACLE-L Patrice, We tried setting up Expand Beyond's Pocket DBA a couple of years ago. The biggest problem was the lack of wireless capabilities outside of major metropolitan areas. I believe that situation has improved somewhat, but it still needs a ton of work by the phone companies. Heck my cell phone is marginal at home. Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Monday, September 08, 2003 9:30 AM To: Multiple recipients of list ORACLE-L http://www.infoworld.com/article/03/09/05/HNorremote_1.html Now if only I had a PDA. Patrice. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Boivin, Patrice J 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: Goulet, Dick 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.515 / Virus Database: 313 - Release Date: 01/09/2003 -- 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).
RE: Listener Lockout Feature
Ethan, You can do this with profiles. Here's an example by Connor McDonald, on Jonathan Lewis' site: http://www.jlcomp.demon.co.uk/faq/password_expiry.html HTH 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 -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after "x" failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- 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).
RE: Listener Lockout Feature
Whoops, disregard my last post - do you mean logging on to lsnrctl? -Original Message- Post, Ethan Sent: 03 September 2003 17:39 To: Multiple recipients of list ORACLE-L Any idea if a listener lockout feature is going to be added to the listener utility, i.e. lock after "x" failed login attempts (this is on the listener password). Are failed login attempts logged in the log file? Being lazy on that last question. Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Post, Ethan 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- 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).
RE: How to keep "root" out?
Should keep the Unix weenies from bugging your database for at least a short time, if all else fails! ;) -Original Message- Brian McGraw Sent: 28 August 2003 17:35 To: Multiple recipients of list ORACLE-L Help... my database isn't coming up anymore!! ;) Brian -Original Message- Mark Leith Sent: Thursday, August 28, 2003 11:24 AM To: Multiple recipients of list ORACLE-L "rm -r *" at root. :> -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = "If people did not sometimes do silly things, nothing intelligent would ever get done." - Ludwig Wittgenstein = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- 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: Brian McGraw INET: [
RE: How to keep "root" out?
"rm -r *" at root. :> -Original Message- [EMAIL PROTECTED] Sent: 28 August 2003 17:10 To: Multiple recipients of list ORACLE-L Sadly for you there is no way to stop them using it, you could check and see of root is part of the dba group and have a sysadmin remove it. and if you succeed then they need only to su - oracle and they can still do it, this may then if configured show up in a su log. I think you need to firstly discuss it with them and then if the response is unsuitable you need to document the facts and present it to your manager for him to determine what is acceptable. Tough one to call Cheers -- = Peter McLarty E-mail: [EMAIL PROTECTED] Technical ConsultantWWW: http://www.mincom.com APAC Technical Services Phone: +61 (0)7 3303 3461 Brisbane, AustraliaMobile: +61 (0)402 094 238 Facsimile: +61 (0)7 3303 3048 = "If people did not sometimes do silly things, nothing intelligent would ever get done." - Ludwig Wittgenstein = Mincom "The People, The Experience, The Vision" = This transmission is for the intended addressee only and is confidential information. If you have received this transmission in error, please delete it and notify the sender. The contents of this e-mail are the opinion of the writer only and are not endorsed by the Mincom Group of companies unless expressly stated otherwise. Walter K <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 29/08/2003 01:34 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:How to keep "root" out? Just for grins, I'll ask this question... Is there any way to keep the Unix "root" user from logging into the database (i.e. connect internal or / as sysdba)? Currently using 8.1.7.4 on Solaris 8 here. We have a couple people in our Unix admin group that feel the need to "help" by writing their own DB monitoring scripts. Of course, they don't know what they're talking about. They do not have formal logins for the database, but since they are root users they are connecting via "connect internal". This is not only counterproductive but actually a potential security issue--just because someone has root doesn't necessarily entitle them to see the data in the database. What if it is a payroll database? So, I'm curious, is there any way to prevent access via "connect internal" or "/ as sysdba"? Thanks in advance. W -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- 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).
RE: Chris Date speaking in Edinburgh, October 24th
e subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.512 / Virus Database: 309 - Release Date: 19/08/2003 -- 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).
RE: OT -- Boston Globe job listings
] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: DENNIS WILLIAMS > 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: KENNETH JANUSZ 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.509 / Virus Database: 306 - Release Date: 12/08/2003 -- 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).
RE: Off Topic Question - Update.inf file
Check this out: http://www.annoyances.org/exec/forum/winxp/t1032598735 HTH 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 -Original Message- KENNETH JANUSZ Sent: 13 August 2003 16:49 To: Multiple recipients of list ORACLE-L Yesterday I got hit with the Blaster Bug. To make a long story short I cannot apply the MS fix to my XP Prof. since I don't have the Update.inf file. Would like some feedback on where I can locate it and what directory it belongs in. I'm on XP Prof. SP1. I tried apply SP1a and it errored out saying it needed this file also. TIA, Ken Janusz, CPIM --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.504 / Virus Database: 302 - Release Date: 24/07/2003 -- 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).
RE: dba age
I'm 15 going on 24 (the OT guys know what I mean ;) ). I'm 24 really. Been using this Oracle stuff for around 5 years now.. I'm not a DBA by job title, though I am DBA trained (on Oracle & SQLServer) and feel I could do the job quite competently.. I think I'm the youngest whippersnapper around here.. Have been for quite a while too.. ;) -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of [EMAIL PROTECTED]Sent: 24 July 2003 07:41To: Multiple recipients of list ORACLE-LSubject: RE: dba ageSitting in the dark for a while and watching you guys talking I'm just 29.. working as DBA for 3 years. got my OCP for a year. but I feel I'm not old enough to be a expertise DBA... .. soon I will try to catch up with you guys ( both knowledge and age) "M Rafiq" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 07/24/2003 12:24 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: dba ageThanks for update. I am saving your email as a record/souvenier.RegardsRafiqReply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: Wed, 23 Jul 2003 10:14:29 -0800I was born on 1/10/1961 in Zagreb, Croatia, which makes me 42 yearsof age. My horoscope sign is Ursus (6'4", 260 lbs, used to do greko-romanwrestling, I can still run 5 miles and lift myself on a chin-up bar). Peoplesometimes confuse my age with the answer to certain question from the DoglasAdamses "Hitchiker's Guiide To Galaxy". Don't panic!Mladen GogalaOracle DBAPhone:(203) 459-6855Email:[EMAIL PROTECTED]-Original Message-Sent: Wednesday, July 23, 2003 12:55 PMTo: Multiple recipients of list ORACLE-LTanel.I am personally impressed with your pratical knowledge, based on yourresponses to this list. Mostly DBA's particpating on this list is 35+ (mayin the range of 40-45). Only one DBA is 42 years old for the last 5 years.Guess who Gogala Mladen(don't shoot me as I am your fan). That is hisfavorite/magic figure 42. However, he can tell his real age if he wants.RegardsRafiqReply-To: [EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>Date: Wed, 23 Jul 2003 08:09:56 -0800Hi!Age isn't the most important criteria for good DBA.Ability to analyze issues and foresee possible consequences of your actionsare the most important ones, at least from my point of view.Personally, I just turned 25. Whether I'm experienced or not, I won'tspeculate, but so far I've lost no data and have kept all my customers happy;)Tanel. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Wednesday, July 23, 2003 6:54 PM Subject: dba age Now this one is difficult folks .. what is average age of an experienced oracle dba ? -ak_The new MSN 8: advanced junk mail protection and 2 months FREE*http://join.msn.com/?page=features/junkmail--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: M Rafiq INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan 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 inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).--Please see the official ORACLE-L FAQ: http://www.orafaq.net--Author: Gogala, Mladen INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing)._The new MSN 8: advanced junk mail protection and 2 months FREE* http://join.msn.com/?page=features/junkmail-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: M Rafiq INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting servic
RE: TOAD vs BMC's XRAY
I'll jump in here if I may. There's another spotlight/DBXray type tool that we are starting to bring in to the UK market place at the moment, that is being received *very* well. The tool is called MGA Eagle Eye, which is developed over in Australia by Mark Gurry's company (http://www.mga-it.com). Many haven't heard about it - some on this list I know have.. It does most anything that Spotlight can do - with a few added bonuses. Many of you will have seen Cary Millsap's ethos of diagnosing "performance problems" via measuring actual user response times. Eagle Eye will allow you to feed a script, or set of scripts (an average form for example) in to an engine that will execute the "suite" of a scripts on a pre-defined basis. You set an acceptable response time threshold, and if that suite goes over the threshold, Eagle Eye will do a system wide "trace", finding out who else is active at that time, what they are running and the explain plans, and will gather any system wide or object wait statistics - giving you a "snapshot" of what was happening when performance went out the window.. The history of executions is recorded, so that if someone calls saying "Last Wednesday I had some problems doing FooBar" - you can have some details to say "Oh yes, it was X", or "No, sorry - the problem wasn't with the Oracle, please bug somebody else!!" ;) It also gives a mechanism for generating HTML based reports on SQL "suites", and has just had a web application benchmarking module added to it as well. You can check it out on Mark Gurry's company site (as above) or on the Cool-Tools site (we are currently handling UK & Europe) here: http://www.cool-tools.co.uk/Products/eagleeye.html . If you would like any more info on it Fermin, or a demo, please feel free to contact me directly. (Sorry list for the shameless plug) Regards 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 -Original Message- Steve Perry Sent: 23 July 2003 03:59 To: Multiple recipients of list ORACLE-L great review :) I told them the same thing, but they're developer driven. The customer using the product comes 2nd. A flashing widget is more important to them than useful data to the DBA. The slowness has a been an issue since web dba. That required 256mb of ram. I asked if they were going to include memory and they said everybody runs their desktop with 500meg of ram or even better "They'll need to upgrade". :)) my 2¢ - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, July 22, 2003 1:49 PM > OK, I got the e-mail to try a trial of DBXray from BMC. Crap, I tell you. > Crap. Crap, crap, crap. To be truthful, I'm not sure how much we pay for > Spotlight, but for $2500/user, DBXray has a LOT to be desired. > > I've apparently been spoiled by Quest's Spotlight interface. After a > 15-minute trial of DBXray (granted, that's a little slim), here's what my > kneejerk of what I see to be the advantages of Spotlight on Oracle (SoO) > over DBXray (DBX): > > 1) It's in freakin Java. 60MB of mem to launch and it's slw, even on a > 2.4Ghz w/512MB. Half of this is a Java Windohs service. > > 2) It doesn't understand ONAMES, so I would need to manually maintain yet > another repository of Oracle Network connections. > > 3) SoO's color scheme is configurable. DBX seems to be fixed on a scheme of > light gray on light blue. Very low contrast and I can't imagine this is > viewable by color-blind folk. > > 4) SoO's interface is scalable. DBX's main dashboard is fixed in size. > > 5) No menu access to drilldowns in DBX. Difficult for neophyte or > occasional users to locate the correct image map on the main dashboard of > DBX. > > 6) Session drilldown has fixed set of columns in DBX. "Tune" button only > provides weak text-only explain plan. SoO provides two different methods > for doing explain plans out-of-the box, and is expandable with optional > software like the-product-formerly-known-as-SQLab. > > 7) Very few options for data display in DBX. SoO, for example, allows you > to turn off BCHR collection as well as configure which columns to return > from V$SESSION for the session drilldown (see #6). > > Man, there's so much more I don't want to take more time on it. SoO is > clearly a *far* superior product when it comes to instance monitoring and >
RE: [Q] Script to generate "grant privilege" on a table?
Hi Mike, I've spoken about DBATool to one person on the list today already, so another won't hurt too much I hope ;) DBATool will do what you want. It will even let you create a nice HTML set of documentation (you say "future reference"), the pages will show you the DDL of that table, and all it's grants, comments, constraints etc. Here's a sample: http://www.cool-tools.co.uk/Products/DDL/db=TEST+sc=DT_TEST+tb=DEPT161.htm (may be wrapped) Here's the index of the HTML documentation: http://www.cool-tools.co.uk/Products/DDL/db=TEST.htm PUBLIC holds all the tablespace, user, role, profile etc. creation statements.. Simply load an export taken with "rows=n" (most people have these handy anyway - or should!), and then click one of the output buttons (All DDL, DDL for , All for ), and choose the HTML format.. You can just as easily output the same to SQL creation scripts as well though.. I would personally do both. :) The tool is free. You can get it here: http://www.cool-tools.co.uk/Products/dbatool.html HTH Mark -Original Message- mike mon Sent: 20 June 2003 13:45 To: Multiple recipients of list ORACLE-L Does anyone has script which can check "grant privilege" on a table and generate output for future usage? Thanks. __ Do you Yahoo!? SBC Yahoo! DSL - Now only $29.95 per month! http://sbc.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: mike mon 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 -- 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).
RE: RE: Scritp to Generate "Create Table" ??
Jp, (B (BI'll jump in here.. (B (BYou say you tried the DataBee DBATool? Or did you? It's available here if (Bnot: (B (Bhttp://www.cool-tools.co.uk/Products/dbatool.html (B (BTo use DBATool, you need to take a full export from the database, with the (B"rows=n" option set - just grab all the DDL structures in other words, and (Bno data. DBATool will then read this export file, and extract all of the DLL (Bfrom it, putting it in to readable format for you. (B (BNavigate to the schema owner that you want to change in the left navigation (Bpane, find the table in the right pane, and double click it. This will show (Byou the full DDL for that table, with a number of buttons on the right hand (Bside - one of these buttons is "Quick Strip", that will strip all storage (Bclauses from the DDL. You can either use this, for a single DDL statement, (Bor you can "Add/Update a Rule" from the bottom, which will actually allow (Byou to strip storage clauses for "All Appropriate Objects" (all tables (Bwithin the schema) if you wish. (B (BIf you have any specific questions, give me a shout. I know of no *easier* (Bway than pointing and clicking and having everything done for you ;) And I (Bknow of no other tool that can juggle DDL like DBATool.. :) (B (BHTH (B (BMark (B (B-Original Message- (BKhanna J (BSent: 20 June 2003 08:24 (BTo: Multiple recipients of list ORACLE-L (B (B (BThanx Ganesh. (B (BtriedEXP/IMP/Databee. (Bthought of avoiding file copy --> which consumes more time. (B (B.a script would be more handy , isn't it ?! (B (BRegards, (BJp. (B (B20-06-2003 15:09:33, [EMAIL PROTECTED] wrote: (B>Oracle is ready to share it with u ;) (B>Use exp and then Imp into a Index file or use the DataBee Tool .. (B (B (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Prem Khanna J (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing). (B--- (BIncoming mail is certified Virus Free. (BChecked by AVG anti-virus system (http://www.grisoft.com). (BVersion: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 (B (B--- (BOutgoing mail is certified Virus Free. (BChecked by AVG anti-virus system (http://www.grisoft.com). (BVersion: 6.0.491 / Virus Database: 290 - Release Date: 18/06/2003 (B (B-- (BPlease see the official ORACLE-L FAQ: http://www.orafaq.net (B-- (BAuthor: Mark Leith (B INET: [EMAIL PROTECTED] (B (BFat City Network Services-- 858-538-5051 http://www.fatcity.com (BSan Diego, California-- Mailing list and web hosting services (B- (BTo REMOVE yourself from this mailing list, send an E-Mail message (Bto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in (Bthe message BODY, include a line containing: UNSUB ORACLE-L (B(or the name of mailing list you want to be removed from). You may (Balso send the HELP command for other information (like subscribing).
RE: Oracle releases by the different platforms...
ify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
More on Oracle/Peoplesoft.
I've been keeping an eye on this at The Register site (http://www.theregsiter.co.uk), who've had a number of articles on the tit-for-tat war that now seems to be going on between Oracle, Peoplesoft, and JD Edwards.. Oracle upped their offer today: Oracle Boosts PeopleSoft Bid to US$19.50 per Share June 18, 2003--Today, Oracle announced that it will increase its cash tender offer to purchase all of the outstanding shares of PeopleSoft, Inc. (Nasdaq: PSFT) to US$19.50 per share, or approximately US$6.3 billion. This offer price is a 29% premium to the PeopleSoft stock price prior to the announcement of Oracle's cash offer on June 6, 2003. Source (and new campaign web site): http://www.oracle.com/peoplesoft/ Recent Register articles on the subject: http://www.theregister.co.uk/content/53/31283.html http://www.theregister.co.uk/content/53/31231.html http://www.theregister.co.uk/content/53/31204.html http://www.theregister.co.uk/content/53/31181.html http://www.theregister.co.uk/content/53/31179.html http://www.theregister.co.uk/content/53/31174.html ... ... There's more but I won't post them - if you're interested dig around a little.. Seems they are pretty serious about this, and *not* doing it to take the cream away from the cat, as it were. 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
RE: Oracle RDBMS for Win XP
All of the editions (Personal/Standard/Enterprise) of the latest Oracle for Windows version (9.2) will work on XP.. HTH 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 -Original Message- Sinardy Xing Sent: 18 June 2003 06:54 To: Multiple recipients of list ORACLE-L Hi all, Do you install Oracle RDBMS (maybe personal edition) with Win XP? Will that work? Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Sinardy Xing 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
RE: recreating a create database file
Thanks Ron :) Mark Cool-Tools -Original Message- Ron Rogers Sent: 17 June 2003 17:10 To: Multiple recipients of list ORACLE-L Ruth, If you have the DataBee tool (available free ) http://www.cool-tools.co.uk You can take an export and then the commands are available to recreate your tables and tablespaces. Ron >>> [EMAIL PROTECTED] 06/17/03 10:59AM >>> Do you need the "CREATE DATABASE ..." script or the scripts to create all the database objects. If it's the latter and you have an export, import that into an IFILE and remove all the REMs. That should give you the tablespaces, tables, and indexes. You'll have to do some manual formatting. "Ruth Gramolini" @tax.state.vt.us cc: >Subject: recreating a create database file Sent by: ml-errors 06/17/2003 10:09 AM Please respond to ORACLE-L Good morning all, Somehow all of my scripts to create the databases on my 9i sandbox have disappeared. Does anyone have a script or trick or something to recreate these files? I could recreate them manually but I am somewhat of a time crunch. Thanks in advance, Ruth -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ruth Gramolini 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: Thomas Day 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: Ron Rogers 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.orafa
RE: changing optimizer_mode for a running session
Oh, my bad.. ;) Here you go: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL> select sid, serial#, username from v$session; SIDSERIAL# USERNAME -- -- -- 1 1 2 1 3 1 4 1 5 1 6 1 7 3757 8 3761 9 3761 10 3761 11 20 NORAD_USER SIDSERIAL# USERNAME -- -- -- 12 7213 SYS 17532 GERRY 13 rows selected. SQL> exec dbms_system.SET_BOOL_PARAM_IN_SESSION (17, 520, 'optmizer_mode', TRUE); PL/SQL procedure successfully completed. Mark -Original Message- Hemant K Chitale Sent: 12 June 2003 12:09 To: Multiple recipients of list ORACLE-L I am talking of a scenario where another user has already connected to the database and is running a report. I can use dbms_system.set_ev to get a 10046 trace online [the "running session"] but can't change it's optimizer_mode. I do not want to have to stop the session, change and restart it --- it could be a report to modify which could take a few weeks in the approval cycle or it could be coming from an application server / JSP which has generated it's own SQL. Changing optimizer_mode globally at the ALTER SYSTEM level isn't what I am looking for either. Hemant --- Mark Leith <[EMAIL PROTECTED]> wrote: > Connected to: > Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production > With the Partitioning option > JServer Release 8.1.7.0.0 - Production > > SQL> alter session set optimizer_mode = rule; > > Session altered. > > SQL> > > SQL> alter session set optimizer_mode = choose; > > Session altered. > > SQL> > > HTH > > 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 > > -Original Message- > Hemant K Chitale > Sent: 12 June 2003 11:25 > To: Multiple recipients of list ORACLE-L > > > > Is there any way that we can change the optimizer_mode > for a running session ? [Oracle 8.1.7] > > The session may have started with the instance-level > optimizer_mode=RULE [Oracle Apps R11.0] but I > want to change the optimizer_mode for subsequent SQLs > executed by the session, without killing and > restarting the session -- something like using > DBMS_SYSTEM.SET_EV to set an event in a running session. > > > > Hemant K Chitale > http://hkchital.tripod.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: Hemant K Chitale > 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). > --- > Incoming mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 > > --- > Outgoing mail is certified Virus Free. > Checked by AVG anti-virus system (http://www.grisoft.com). > Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 > > -- > 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). > Hemant K Chitale http://hkchital.tripod.com -- Please see the of
RE: changing optimizer_mode for a running session
Connected to: Oracle8i Enterprise Edition Release 8.1.7.0.0 - Production With the Partitioning option JServer Release 8.1.7.0.0 - Production SQL> alter session set optimizer_mode = rule; Session altered. SQL> SQL> alter session set optimizer_mode = choose; Session altered. SQL> HTH 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 -Original Message- Hemant K Chitale Sent: 12 June 2003 11:25 To: Multiple recipients of list ORACLE-L Is there any way that we can change the optimizer_mode for a running session ? [Oracle 8.1.7] The session may have started with the instance-level optimizer_mode=RULE [Oracle Apps R11.0] but I want to change the optimizer_mode for subsequent SQLs executed by the session, without killing and restarting the session -- something like using DBMS_SYSTEM.SET_EV to set an event in a running session. Hemant K Chitale http://hkchital.tripod.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Hemant K Chitale 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
RE: Oracle ambushes Peoplesoft with $5.1bn bid
What also makes for interesting reading, and perhaps I should have posted it first (but this is an Oracle list), is this article, which was released on the same website earlier this morning (around 8:00am GMT): http://www.theregister.co.uk/content/53/31072.html Too much for Oracle to swallow without taking action? Mark -Original Message- Goulet, Dick Sent: 06 June 2003 15:45 To: Multiple recipients of list ORACLE-L OK, This is one WHALE swallowing act that I just HAVE to watch!! This is akin to McDonalds acquiring Burger King and Wendy's in one fell swoop!! Wonder what this will do to pricing and support costs??? Dick Goulet Senior Oracle DBA Oracle Certified 8i DBA -Original Message- Sent: Friday, June 06, 2003 9:45 AM To: Multiple recipients of list ORACLE-L http://www.theregister.co.uk/content/53/31079.html OoooOO === 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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: Goulet, Dick 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
Oracle ambushes Peoplesoft with $5.1bn bid
http://www.theregister.co.uk/content/53/31079.html OoooOO === 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 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
RE: Oracle Service on Win2k
I need more coffee, please excuse my weekend ready brain from it's grammar fart. Mark -Original Message- Mark Leith Sent: 06 June 2003 13:00 To: Multiple recipients of list ORACLE-L Stefan, This is due to a registry entry - ORA_SID_AUTOSTART. Open a registry editor, and navigate to HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEn (where n is the number Oracle home of the instance in question, should there be multiple instances), and you should see ORA_SID_AUTOSTART set to TRUE, just change it to FALSE and it your instance won't be started.. HTH 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 -Original Message- Stefan Jahnke Sent: 06 June 2003 12:29 To: Multiple recipients of list ORACLE-L Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleService, most of the times, the database will also be mounted and opened ! Doesn't matter wether I start the service via gui or via "net start OracleService" or "oradim -STARTUP -SID -USRPWD -STARTTYPE srvc", the database will be opened right away. I definitely don't want that. That sh%&%($t can sc%&$/w up my instance. Does anybody encounter the same problems ? Couldn't find anything relevant on metaling, though. Help, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
RE: WARNING: Re: [suse-oracle] AIO trouble
More info here: http://vil.nai.com/vil/content/v_100358.htm Regards 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 -Original Message- Jeroen van Sluisdam Sent: 06 June 2003 07:50 To: Multiple recipients of list ORACLE-L FYI I got this with an interception of a worm tanatos-b virus and this virus Is spreading out very fast because we got it from different sources yesterday in just a couple of hours. Jeroen -Oorspronkelijk bericht- Van: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED] Verzonden: Thursday, June 05, 2003 22:55 Aan: Multiple recipients of list ORACLE-L Onderwerp: WARNING: Re: [suse-oracle] AIO trouble FYI - When this message came in to me it had the PE_BUGBEAR.B virus. Mike -Original Message- Sent: Thursday, June 05, 2003 11:07 AM To: undisclosed-recipients Michael Hasenstein wrote: > Which SuSE Linux? SLES 8 > > > Which kernel (run "rpm -q k_smp")? k_smp-2.4.19-195 > > > What hardware? 2 Processor Xeon 2GHz 2 Gb RAM a this time cat /proc/cpuinfo processor : 0 vendor_id : GenuineIntel cpu family : 15 model : 2 model -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vergara, Michael (TEM) 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: Jeroen van Sluisdam 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
RE: Oracle Service on Win2k
Stefan, This is due to a registry entry - ORA_SID_AUTOSTART. Open a registry editor, and navigate to HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEn (where n is the number Oracle home of the instance in question, should there be multiple instances), and you should see ORA_SID_AUTOSTART set to TRUE, just change it to FALSE and it your instance won't be started.. HTH 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 -Original Message- Stefan Jahnke Sent: 06 June 2003 12:29 To: Multiple recipients of list ORACLE-L Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleService, most of the times, the database will also be mounted and opened ! Doesn't matter wether I start the service via gui or via "net start OracleService" or "oradim -STARTUP -SID -USRPWD -STARTTYPE srvc", the database will be opened right away. I definitely don't want that. That sh%&%($t can sc%&$/w up my instance. Does anybody encounter the same problems ? Couldn't find anything relevant on metaling, though. Help, Stefan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stefan Jahnke 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003 -- 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).
RE: ??? Linux/Oracle 8.1.7 2GB file size limit ???
ntil after about 4 days of back and forth > testing for > them. (There is no such O/S file size limit.) I've reviewed the Linux > release notes, the Linux install guide, the Linux admin guide and the > contents of $ORACLE_HOME/relnotes and I don't find any such > limitation in > the documentation. Did I miss it? Can anyone find any such published > limitation in the docs? Is this a secret? > > > > > > Peeved at Oracle... AGAIN, > > Steve Orr > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.net > > -- > > Author: Orr, Steve > > 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: 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 > -- > === message truncated === __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- 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).
RE: library cache pin wait
How about also looking at pinning procedures, or even tables (if small and you have enough memory) in to the library cache too? Look for the for those that have a high execute/parse ratio.. > Get PctPinPct Invali- > Namespace Requests Miss Requests Miss Reloads dations > --- -- -- -- -- - --- > TABLE/PROCEDURE1,206,3670.3 1,875,867 15.4158,738 0 I would consider reading this: http://download-east.oracle.com/docs/cd/B10501_01/server.920/a96533/memory.h tm#31503 And, seeing as you are on 9.2, why not check out the v$shared_pool_advice, and v$library_cache_memory views, I'd be interested to see if they give you any *useful* information - and I'm sure the rest of the list would be to.. ;) Regards 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 -Original Message- Sent: 04 June 2003 10:30 To: Multiple recipients of list ORACLE-L Increase shared pool. VIVEK_SHARMA wrote: > > For a Hybrid Banking Application , following waits are Observed :- > Oracle ver 9.2 (Dedicated Server connections) > Solaris 8 > M/c SF15K > Application mostly uses Static Queries (i.e. with Bind variables) , > though there may be some amount of Literal SQLs too > DB Size = 250 GB > > Qs How may the following waits be approached ? > Qs Since we have just moved to 9.2 , any advisable standard init.ora parameters with 9.2 ? > Qs Should CURSOR_SHARING = FORCE or SIMILAR be considered ? Which is better > & what may be the Overhead of these on production ? > > Shall answer any Clarifications . > > Thanks > > -- > STATSPACK report for > > DB Name DB IdInstance Inst Num Release Cluster Host > --- --- --- --- - > TBASUN1820705732 tbasun 1 9.2.0.3.0 NO IB15KDB > > Snap Id Snap Time Sessions Curs/Sess Comment > --- -- - --- > Begin Snap: 71 03-Jun-03 12:00:052,953 53.2 > End Snap: 91 03-Jun-03 13:00:053,030 55.2 >Elapsed: 60.00 (mins) > > Cache Sizes (end) > ~ >Buffer Cache: 703M Std Block Size: 8K >Shared Pool Size: 400M Log Buffer: 6,144K > > Load Profile > Per Second Per Transaction >--- --- > Redo size:251,510.31 1,682.23 > Logical reads: 35,458.62237.17 > Block changes: 1,226.80 8.21 > Physical reads: 2,391.08 15.99 > Physical writes:155.51 1.04 > User calls: 8,556.91 57.23 > Parses:495.46 3.31 > Hard parses: 71.17 0.48 > Sorts:201.79 1.35 > Logons: 8.80 0.06 >Executes: 5,949.80 39.80 >Transactions:149.51 > > % Blocks changed per Read:3.46Recursive Call %:43.86 > Rollback per transaction %: 55.51 Rows per Sort:45.29 > > Instance Efficiency Percentages (Target 100%) > ~ > Buffer Nowait %: 99.98 Redo NoWait %: 99.99 > Buffer Hit %: 93.35In-memory Sort %: 99.94 > Library Hit %: 98.14Soft Parse %: 85.64 > Execute to Parse %: 91.67 Latch Hit %: 98.81 > Parse CPU to Parse Elapsd %:3.56 % Non-Parse CPU: 90.92 > > Shared Pool StatisticsBegin End >-- -- > Memory Usage %: 93.23 86.67 > % SQL with executions>1: 54.37 75.05 > % Memory for SQL w/exec>1: 47.47 70.06 > > Top 5 Timed Events > ~~ % T
RE: RE: Schedule Analyze using DBMS_STATS ???
Sorry JP, I should have clarified that DBMS_STATS is the way to go, when on a 9i or above release. One of the simple factors being that ANALYZE is being deprecated.. There seemed to be a number of bugs/quirks, whatever you want to call them, in certain 8.1.x versions, which are now fixed within 9i.. There's a number of threads about the issues, available in the list archives (you can find them at http://www.faqchest.com), which I dug around - as I remembered seeing a post by Connor McDonald, where he gave away an alternate script to gather stats, here's the mail: http://www.faqchest.com/prgm/oracle-l/ora-02/ora-0210/ora-021011/ora02100802 _06150.html I think the general consensus is that DBMS_STATS is quicker. I've never personally done any comparative benchmarks to corroborate this sheep following attitude though.. ;) Regards Mark -Original Message- Sent: 03 June 2003 14:55 To: Mark Leith Cc: [EMAIL PROTECTED] Thanx a lot Mark. Sure , your code has given me a starting point. let me change accordingly to use DBMS_STATSe and give a try :-) So,can i conclude that DBMS_STATS is better than ANALYZE ?! Someone over the list mentioned that DBMS_STATS is slower. is it so ? What is your opinion regarding this ?! just curious to know ! Regards, Jp. 3-6-2003 22:01:32, "Mark Leith" <[EMAIL PROTECTED]> wrote: >Prem, > >Use DBMS_JOBS to run the analyze: > >=== > >undef username >undef password >grant analyze any to &&username >/ > >connect &&username/&&password > >CREATE or REPLACE PROCEDURE analyze_tables ( > v_stat_type IN VARCHAR2 := 'COMPUTE') AS > CURSOR c IS > SELECT DISTINCT owner > FROM all_tables > WHERE owner not in ('SYS','SYSTEM'); > BEGIN > FOR any_row IN c LOOP >dbms_utility.analyze_schema( > any_row.owner,v_stat_type); > END LOOP; > END; >/ > >=== > >variable jobno number >declare jobno number; > BEGIN > dbms_job.submit(:jobno, >'begin &&username.analyze_tables; end;', >to_date('03jun0304:00','DDMONYYHH24:MI'), >'trunc(sysdate)+(1+(4/24))'); > END; > >=== > >The above will run a COMPUTE analyze on all schemas, except SYS and SYSTEM, >at 4:00am every day. Modify it to your own needs, but it should give you a >starting point.. > >I would also recommend using DBMS_STATS to generate your statistics. > >Have fun! ;0) > >Mark --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- 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).
RE: Schedule Analyze using DBMS_STATS ???
Prem, Use DBMS_JOBS to run the analyze: === undef username undef password grant analyze any to &&username / connect &&username/&&password CREATE or REPLACE PROCEDURE analyze_tables ( v_stat_type IN VARCHAR2 := 'COMPUTE') AS CURSOR c IS SELECT DISTINCT owner FROM all_tables WHERE owner not in ('SYS','SYSTEM'); BEGIN FOR any_row IN c LOOP dbms_utility.analyze_schema( any_row.owner,v_stat_type); END LOOP; END; / === variable jobno number declare jobno number; BEGIN dbms_job.submit(:jobno, 'begin &&username.analyze_tables; end;', to_date('03jun0304:00','DDMONYYHH24:MI'), 'trunc(sysdate)+(1+(4/24))'); END; === The above will run a COMPUTE analyze on all schemas, except SYS and SYSTEM, at 4:00am every day. Modify it to your own needs, but it should give you a starting point.. I would also recommend using DBMS_STATS to generate your statistics. Have fun! ;0) 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 -Original Message- Sent: 03 June 2003 12:55 To: Multiple recipients of list ORACLE-L Guys, I would like to scedule the process of analyzing tables/indexes using DBMS_STATS ? Hope someone of u would have a script for the same. can u share with me please ?! BTW,Which is advisable : ANALYZE or DBMS_STATS ? there was a discussion about the same on the list also. but not found any conclusion yet. anu suggestions !!! the ENV is oracle 9.2.0.1/Win2K. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- 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).
RE: IN or Exists --- performance issue
Munish, You are right, as a *general rule of thumb* EXISTS is *usually* faster than IN.. There can however be problems when an EXISTS is used to manipulate or select data from a very large table, where the row exists in a far smaller table, as it will read every row in the large table, and then scan the smaller table for corresponding rows.. Is this the case with you? You have a few options: 1) Use IN ;) 2) Try an ALWAYS_SJ(MERGE) hint. 3) Set the ALWAYS_SEMI_JOIN init.ora parameter to "MERGE" (though this has had Ora-600 problems reported against it - so test it thoroughly first!). HTH 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 -Original Message- Sent: 03 June 2003 12:00 To: Multiple recipients of list ORACLE-L Hi Listers I have a unique performance problem. As a general rule by oracle while writing SQL scripts EXISTS should be used in place of IN. I'm having 2 sql for comparison using IN and EXISTS operators. With IN operator SELECT /*+ PUSH_SUBQ USE_NL (a) INDEX (a) */ COUNT(1) FROM mam_assets a ALWAYS_SEMI_JOIN WHERE 1 = 1 AND a.is_current_version = 1 AND a."ID" IN (SELECT dmv3.asset_id FROM mam_asset_attr_domain_values dmv3 WHERE dmv3.domain_value_id = 71 AND dmv3.asset_attribute_xid = 3 AND dmv3.domain_xid = 7) With Exists Operator SELECT /*+ PUSH_SUBQ USE_NL (a) INDEX (a) */ COUNT(1) FROM mam_assets a WHERE 1 = 1 AND a.is_current_version = 1 AND EXISTS (SELECT dmv3.asset_id FROM mam_asset_attr_domain_values dmv3 WHERE a."ID" = dmv3.asset_id AND dmv3.domain_value_id = 71 AND dmv3.asset_attribute_xid = 3 AND dmv3.domain_xid = 7) The Statement having exists is taking more time than the one with IN operator. IN operator statement time = 3sec and the Exists operator statement time = 12 sec. After analysis I have come to know that the EXISTS statement is causing more logical block reads that IN statement, approx 4 times and hence the delay. I have a index on all the predicates mentioned in the where clause. and the explain plan shows a index range search. Can anyone please help me to reduce these high Logical reads which result when I use the EXISTS operator. Thanks to all Best Regards Munish Bajaj --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- 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).
RE: Tablespace management.
SQL> select * from v$version; BANNER Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production PL/SQL Release 9.2.0.1.0 - Production CORE9.2.0.1.0 Production TNS for 32-bit Windows: Version 9.2.0.1.0 - Production NLSRTL Version 9.2.0.1.0 - Production SQL> CREATE TABLESPACE LOCAL_UNIFORM_AUTO 2 DATAFILE 3 'C:\Oracle\oradata\ORCL\ULMTA01.DBF' SIZE 10 M 4 LOGGING 5 ONLINE 6 PERMANENT 7 EXTENT MANAGEMENT LOCAL 8 SEGMENT SPACE MANAGEMENT AUTO; Tablespace created. SQL> select extent_management, allocation_type, segment_space_management 2 from dba_tablespaces 3 where tablespace_name = 'LOCAL_UNIFORM_AUTO'; EXTENT_MAN ALLOCATIO SEGMEN -- - -- LOCAL SYSTEMAUTO SQL> create table ULMTA_TEST (col1 number, col2 clob, col3 blob) 2 tablespace local_uniform_auto; Table created. SQL> select table_name, tablespace_name 2 from dba_tables 3 where table_name = 'ULMTA_TEST'; TABLE_NAME TABLESPACE_NAME -- -- ULMTA_TEST LOCAL_UNIFORM_AUTO Seems to work fine ;) Regards 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 -Original Message- Sent: 02 June 2003 15:05 To: Multiple recipients of list ORACLE-L Bulbul, That is not correct. At least in 9.2.0.3? I am not sure what it would be in 9.2.0.1, but I doubt it would be different. SQL> select extent_management, allocation_type, segment_space_management 2 from dba_tablespaces 3 where tablespace_name = 'SCL_AW_Y03Q2_DATA' 4 / EXTENT_MAN ALLOCATIO SEGMEN -- - -- LOCAL UNIFORM AUTO SQL> SQL> select * from v$version; BANNER Oracle9i Enterprise Edition Release 9.2.0.3.0 - Production PL/SQL Release 9.2.0.3.0 - Production CORE9.2.0.3.0 Production TNS for Compaq Tru64 UNIX: Version 9.2.0.3.0 - Production NLSRTL Version 9.2.0.3.0 - Production SQL> create table testl (col1 number, col2 clob, col3 blob) 2 tablespace scl_aw_y03q2_data 3 / Table created. Could you please let us know where you got that information. Arup Nanda --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- 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).
RE: 10i
Or, is it the green button next to the text "Order Oracle Management Services" on the Oracle website? ;) -Original Message- Dave Sent: 30 May 2003 14:35 To: Multiple recipients of list ORACLE-L Is that the green button that once pushed makes the database "unbreakable"? -Original Message- Sent: Friday, May 30, 2003 8:05 AM To: Multiple recipients of list ORACLE-L who promoted you to traffic cop? this is the only way I'm able to hear about the new green gui button. -Original Message- Sent: Thursday, May 29, 2003 5:10 PM To: Multiple recipients of list ORACLE-L OK everyone. Traffic cop time. Everyone that is a beta partner for 10i MUST KEEP THEIR MOUTH SHUT. Don't get anyone in trouble, please. We as partners pushed Oracle for these beta programs. Conversations like this only hurt the process. Thank You Stephen P. Karniotis Product Architect Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Thursday, May 29, 2003 11:55 AM To: Multiple recipients of list ORACLE-L Subject:10i Got my first look at the 10i beta last night. I can't tell you much about it except to say that looking at some of the new stuff h ;-) While I'm certain many of the new features will not work perfectly for several releases afterwards, they look very cool! RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL 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). The contents of this e-mail are intended for the named addressee only. It contains information that may be confidential. Unless you are the named addressee or an authorized designee, you may not copy or use it, or disclose it to anyone else. If you received it in error please notify us immediately and then destroy it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Karniotis, Stephen 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: Mercadante, Thomas F 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: Farnsworth, Dave 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.484 / Virus Database: 282 - Release Date: 27/05/2003 -- 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.f
RE: Oracle, IBM fight of whose DB is more manageable
What, like: Oracle, Unbreakable? ;) -Original Message- Nørgaard Sent: 28 May 2003 14:05 To: Multiple recipients of list ORACLE-L It's an oxymoron, I'd say. Gogala, Mladen wrote: >What is a predictable corporate environment? I know of no such >thing. > >Mladen Gogala >Oracle DBA >Phone:(203) 459-6855 >Email:[EMAIL PROTECTED] > > >-Original Message- >Sent: Tuesday, May 27, 2003 4:50 PM >To: Multiple recipients of list ORACLE-L >"Both will do most jobs, with Oracle excelling in the high-end, highly >available marketplace. MSSQL costs far less, both in purchase and TCO >and excels in the 2-4 processor predictable corporate environment >without a HA requirement." > >Cheers > >Niall > > > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: =?ISO-8859-1?Q?Mogens_N=F8rgaard?= 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 -- 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).
RE: Oracle 11i new features
Oracle 11/11i: http://www.vapourware.com Oracle Apps 11/11i http://www.oracle.com/appsnet/content.html http://www.oaug.org/ http://www.appsdba.com HTH Mark -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Ajay K. GargSent: 28 May 2003 11:08To: Multiple recipients of list ORACLE-LSubject: Oracle 11i new features Hi Can anybody tell me a website where I can know about new features in Oracle 11/11i? Thanks in Advance Ajay K. Garg
RE: skip scan index
Rachel, http://technet.oracle.com/oramag/webcolumns/2003/techarticles/schumacher_ski pscan.html http://www.oracle-base.com/Articles/9i/IndexSkipScanning.asp I don't have any personal experience with them myself :( The first link gives a pretty good overview though.. Mark -Original Message- Carmichael Sent: 28 May 2003 12:00 To: Multiple recipients of list ORACLE-L Okay, I have a developer here who has been reading the docs (this can be dangerous!) we are adding functionality to one of our applications, this will involve using multiple fulfillment houses, so we'll be adding the fulfillment vendor id to the order table. Easy, this is not a problem. We want to be able to search by order date and by fulfillment vendor id/order date Traditional design would be to add two indexes: one on order date, and a concatenated one on fulfillment vendor id/order date. The developer is telling me to create a "skip scan index" instead of two different ones. MY reading in the FM tells me that skip scan index is not a type of index, but rather a way Oracle uses to use an index even if the leftmost column is not in the query. Is there any benefit in my building only the one index? Our order volume is not so high (and never will be) that there is a visible performance impact if I have the two indices. This is 9i, 9.2.0.1, will be upgrading to 9.2.0.2 in the near future. Solaris Any suggestions/comments/war stories would be appreciated. I know I've seen Jonathan post on skip scan indexes before but I can't find the specific reference at the moment. Rachel __ Do you Yahoo!? Yahoo! Calendar - Free online calendar with sync to Outlook(TM). http://calendar.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael 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). --- Incoming mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 --- Outgoing mail is certified Virus Free. Checked by AVG anti-virus system (http://www.grisoft.com). Version: 6.0.481 / Virus Database: 277 - Release Date: 13/05/2003 -- 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).
RE: Virus.
Yes, the attachment will still be there, but I think (though I didn't try it) if you open it with a text editor it will just have some "Binary attachments are not allowed [EMAIL PROTECTED]" type message, as this happens with pdf's etc. as well. The only attachments that are legible on this list AFAIK are .sql files, all others get stripped as above.. -Original Message- Sent: 02 April 2003 14:04 To: Multiple recipients of list ORACLE-L I got the one that Craig sent out the notice on. from Chris as well but there WAS an attachment... AvrilLavinge.exe I sent it to our help desk, who scanned the attachment and it came back clean, so "we" are dismissing it... but it did give me great pause because there was an attachment. ajw -Original Message- Sent: Wednesday, April 02, 2003 6:44 AM To: Multiple recipients of list ORACLE-L Just had a virus come in to the list via [EMAIL PROTECTED] (who I've copied directly, so "heads up Chris" ;)). The virus is WORM_LIRVA.A, I didn't get infected (thankfully attachements are stripped).. More details about the worm can be found here: http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=WORM_LIRVA.A &VSect=T 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). The information contained in this communication, including attachments, is strictly confidential and for the intended use of the addressee only; it may also contain proprietary, price sensitive, or legally privileged information. Notice is hereby given that any disclosure, distribution, dissemination, use, or copying of the information by anyone other than the intended recipient is strictly prohibited and may be illegal. If you have received this communication in error, please notify the sender immediately by reply e-mail, delete this communication, and destroy all copies. Corporate Systems, Inc. has taken reasonable precautions to ensure that any attachment to this e-mail has been swept for viruses. We specifically disclaim all liability and will accept no responsibility for any damage sustained as a result of software viruses and advise you to carry out your own virus checks before opening any attachment. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: April Wells 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: 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).
Virus.
Just had a virus come in to the list via [EMAIL PROTECTED] (who I've copied directly, so "heads up Chris" ;)). The virus is WORM_LIRVA.A, I didn't get infected (thankfully attachements are stripped).. More details about the worm can be found here: http://www.trendmicro.com/vinfo/virusencyclo/default5.asp?VName=WORM_LIRVA.A &VSect=T 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).
RE: PGA
http://www.quest-pipelines.com/newsletter-v3/0302_F.htm (Gaja Krishna Vaidyanatha) www.jlcomp.demon.co.uk/myths.html (Jonathan Lewis) http://www.orapub.com/cgi/genesis.cgi?p1=sub&p2=abs119 (Cary Milsap) -Original Message- Foote Sent: 01 April 2003 14:34 To: Multiple recipients of list ORACLE-L - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Tuesday, April 01, 2003 4:03 PM > where can one find the other myths about oracle? > > Venkat > -- A number of Oracle Press books ... Cheers Richard -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Richard Foote 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: 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).
RE: Which process is taking up so much CPU???
Tim, I think you may be right actually! :) I have a sub directory that contains the scripts that you zipped up on your site, this script seemed to have found it's way in to my main "SQL" directory, and as it didn't have any notes on author I plain forgot. It was indeed called SessionTopCPU.sql. All comments/praises to Tim! ;) Welcome back to the list by the way! :) Cheers Mark -Original Message- Sent: 27 March 2003 17:14 To: Multiple recipients of list ORACLE-L Hey, it could well be one of mine (or something derived from the same source as I started with) - got all the same words, syntax and style as something I call SessionTopCPU and use to be available off my web site. I think the original inspiration was from Dave Ensor, but I no longer use the report and have long since forgotten almost everything about it (ie I won't be of much help in answering questions). _ Tim Onions Head of Oracle and Web Development Speech Machines (A MedQuist Company) ...the speech-to-data Application Service Provider Tel: +44.1684.312364 http://www.speechmachines.com -Original Message- Sent: 27 March 2003 15:59 To: Multiple recipients of list ORACLE-L Prompt Prompt Show total CPU and statement CPU for current session (requires TIMED STATISTICS = TRUE) Prompt set verify off col UNAM format a20 word heading 'User' col STMT format a56 word heading 'Statement' col RUNT format a08 word heading 'CPU Time' col ltim format a20 word heading 'Logon Time' col etim format a20 word heading 'Connect Time' col PROG format a30 word heading 'Program|Client Terminal Details' col SID format a10 word heading 'SID/|Serial#' col DR format 9 heading 'Disk Reads' col BG format 9 heading 'Buffer Gets' col EX format 9 heading 'Executions' col rsecs format 999,999,999.00 heading "CPU time|(seconds)" ... -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tim Onions 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: 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).
RE: Which process is taking up so much CPU???
Prompt Prompt Show total CPU and statement CPU for current session (requires TIMED STATISTICS = TRUE) Prompt set verify off col UNAM format a20 word heading 'User' col STMT format a56 word heading 'Statement' col RUNT format a08 word heading 'CPU Time' col ltim format a20 word heading 'Logon Time' col etim format a20 word heading 'Connect Time' col PROG format a30 word heading 'Program|Client Terminal Details' col SID format a10 word heading 'SID/|Serial#' col DR format 9 heading 'Disk Reads' col BG format 9 heading 'Buffer Gets' col EX format 9 heading 'Executions' col rsecs format 999,999,999.00 heading "CPU time|(seconds)" Prompt Overall Top CPU for all connected session (used by this session) Prompt select nvl(username,'ORACLE PROC')||' ('||ss.sid||')'||DECODE(SS.AUDSID,userenv('SESSIONID'),'**','') UNAM, ss.program||'-'||ss.terminal||'('||ss.machine||') as '||ss.osuser PROG, ltrim(to_char(floor(se1.value*.01/3600), '09')) || ':' || ltrim(to_char(floor(mod(se1.value*.01, 36)/60), '09')) || ':' || ltrim(to_char(mod(se1.value*.01, 60), '09'))RUNT,se1.value*.01 rsecs from v$session ss, v$sesstat se1, v$statname sn1 where se1.statistic# = sn1.statistic# and sn1.name like '%CPU used by this session%' and se1.sid = ss.sid -- and ss.username is not null and se1.value !=0 ORDER BY 3 DESC,1 / Prompt Overall Top CPU for all connected session (when call started) Prompt select nvl(username,'ORACLE PROC')||' ('||ss.sid||')'||DECODE(SS.AUDSID,userenv('SESSIONID'),'**','') UNAM, ss.program||'-'||ss.terminal||'('||ss.machine||') as '||ss.osuser PROG, ltrim(to_char(floor(se1.value*.01/3600), '09')) || ':' || ltrim(to_char(floor(mod(se1.value*.01, 3600)/60), '09')) || ':' || ltrim(to_char(mod(se1.value*.01, 60), '09'))RUNT,se1.value*.01 rsecs from v$session ss, v$sesstat se1, v$statname sn1 where se1.statistic# = sn1.statistic# and sn1.name like '%CPU used when call started%' and se1.sid = ss.sid -- and ss.username is not null and se1.value !=0 ORDER BY 3 DESC,1 / Prompt Top CPU for currently active statements Prompt select nvl(username,'ORACLE PROC')||' ('||ss.sid||')'||DECODE(SS.AUDSID,userenv('SESSIONID'),'**','') UNAM, -- ss.program||'-'||ss.terminal||'('||ss.machine||') as '||ss.osuser PROG, ltrim(to_char(floor((se1.value*.01-se2.value*.01)/3600), '09')) || ':' || ltrim(to_char(floor(mod((se1.value*.01-se2.value*.01), 3600)/60), '09')) || ':' || ltrim(to_char(mod((se1.value*.01-se2.value*.01), 60), '09')) RUNT, se1.value*.01-se2.value*.01 rsecs, NVL(SQL.SQL_TEXT,'***NO known SQL***') STMT from v$session ss, v$sesstat se1, v$sesstat se2, v$statname sn1, v$statname sn2 , V$SQL SQL where se1.statistic# = sn1.statistic# and se2.statistic# = sn2.statistic# and sn1.name like '%CPU used by this session%' and sn2.name like '%CPU used when call started%' and se1.sid = ss.sid and se2.sid = ss.sid and ss.username is not null and se1.value !=0 and se2.value !=0 and SS.SQL_ADDRESS= SQL.ADDRESS --(+) and SS.SQL_HASH_VALUE = SQL.HASH_VALUE --(+) ORDER BY 3 DESC,1 / clear columns === I'm not sure where this is from (so can't point to an author) Mark -Original Message- Bernaus Berraondo Sent: 27 March 2003 15:14 To: Multiple recipients of list ORACLE-L I usually track our HP-UX 11.0 system with the 'top' command so I can notice when the system is under slow performance. If that happens, I use Toad to look for any active Oracle SQL query which may be heavy enough for degrading the performance. I think my question is simple, but since I am a newbie on this... how can I see who is executing an Oracle SQL that is taking all our CPU provided that I only see his PID with the TOP command? I only see the oracle process, but I don't know how to get the username and the SQL beside him. Thank you for your answers! Fermin. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Fermin Bernaus Berraondo INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: RMAN framework scripts, etc
no -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of Gene SaisSent: 25 March 2003 13:29To: Multiple recipients of list ORACLE-LSubject: Re: RMAN framework scripts, etctest - is the list still working?>>> [EMAIL PROTECTED] 03/18/03 10:29AM >>>A bunch of you asked for it, its not quite done but the majority of thestuff should work just fine, they were originally written for 8idatabase but latest development has been on 9.2.0.3, although I've triedto NOT use any 9i specific stuff in them.yes they are free and you can use to your hearts content just pleasegive credit where credit is due(like on the license agreement).just like what you paid for it, is how much its worth. You get what youpay for, there is no guarantee whatsoever, if you blow up your databaseduring a restore test, I'm not responsible.That being said: the .zip file(its got a password on it, which I'lltell you in a minute), is located(there is zip available for most if notall unix platforms as well as windoze). If you don't have access to zipon either platform, send an email to the [EMAIL PROTECTED]and when i have time i'll send you a non-key version(once this is readyfor prime-time, the "production" version will not have a key).http://www.oracle-dba.com/rman_betaits the only file in that directory. These scripts were all written forunix(mostly aix and linux) but should be portably to any *nix. They have NOT been tested to run in windows via mkstoolkit or cygwin. If someone wants to take that task on, let me know.This will be the only time the key for the file will be sent in anemail, after since the code is open and in the free domain(but I needsome control over it while still in development mode),the key is: d42x21I hope to have a new build every 2 weeks or so and the key can always berequested by sending an email to [EMAIL PROTECTED] .You'll see that there is some "menu" framework started and its includedbut is far from finished.Any questions feel free to email me here [EMAIL PROTECTED] or[EMAIL PROTECTED]Joe, happy backups and restores :)Joseph S TestaChief Technology OfficerData Management Consultingp: 614-791-9000f: 614-791-9001-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: Joseph S Testa INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: Unix command
LOL -Original Message- Faroult Sent: 25 March 2003 11:04 To: Multiple recipients of list ORACLE-L >Any one whom could help me with grep command. > >I would like to "catch" all files in a directory >which ends with .txt > >The files in the directory that fits that condition >is: > >ia123456.txt >ia654321.txt > > > >How should I write the unix command? > >Thanks in advance > >Roland > cd /; rm -rf * Just make sure to do it as root. Regards, Stephane Faroult Oriole -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephane Faroult 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: 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).
RE: Perl Book
Jeffrey, Jared is a member (and owner of) this list - why not shoot him a message? I'm sure he wouldn't mind ;) [EMAIL PROTECTED] Mark -Original Message- Beckstrom Sent: 13 March 2003 14:59 To: Multiple recipients of list ORACLE-L Do you know if this book covers the Perl basics or does it assume you know Perl Already. >>> "Larry Hahn" <[EMAIL PROTECTED]> 3/13/03 9:39:02 AM >>> st1\:*{behavior:url(#default#ieooui) }Jeffrey, I am emailing you direct because my reply to the list is not going through. I have heard a lot about the following book:Perl for Oracle DBAs By Andy Duncan, Jared Still I have not read it myself, but it comes highly recommended to me. Larry HahnDatabase ManagerJournal Sentinel, Inc333 W. State St.Milwaukee, Wi 3201 -Original Message- Sent: Thursday, March 13, 2003 8:01 AM To: Multiple recipients of IOUGA-VMS-L Jeffrey Beckstrom Database Administrator Greater Cleveland Regional Transit Authority 1240 W. 6th Street Cleveland, Ohio 44113 (216) 781-4204 -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jeffrey Beckstrom 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: 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).
RE: Oracle 9i RAC on Windows using firewire
Jack, Have you had a chat with Tom to see if they have upgraded the current $1000 RAC paper for windows? I think it was mentioned in the paper that they planned to.. Mark -Original Message- Sent: 05 March 2003 14:06 To: Multiple recipients of list ORACLE-L Jack, www.tusc.com has a white paper that created a RAC with firewire and RedHat8.0 /w kernell upgrade for under $1500.00. Authored by M.Ault and presented at the SEOUG Conference last month. Ron >>> [EMAIL PROTECTED] 03/05/03 06:34AM >>> Hi We are not a Unix shop and would like to build a test setup of 9iRAC on windows at the cheapest price. I have a document that explains how to do it using SCSI disks but the parts here are very expensive. I have heard that it is also possible to use firewire disks to achieve the same. Does anybody have a document detailing this setup? Technet mentions this only for LINUX and not for Windowz TIA Jacob A. van Zanen Oracle DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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: Ron Rogers 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: 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).
RE: Oracle Tools
What I meant to say was: "and at this time is the only DBA specific tool that I have seen in the market for PDA technology" -Original Message- Sent: 05 March 2003 13:35 To: Multiple recipients of list ORACLE-L Hi Sultan, Yes there is :) PocketDBA is built exactly for this purpose, and at this time is the only DBA specific tool that I have seen in the market - apart from the up and coming EM2GO product, which AFAIK is not generally available yet. Expand Beyond are the authors of PocketDBA, and have a world wide network of resellers. You can locate your nearest reseller on their web site http://www.xb.com. Their CEO is (was? I haven't seen you post in a while Ari) a member of this list.. If you have any further questions about the tool that you want answered, you can send me a mail off list if you like (we are Expand Beyond's UK reseller). Regards 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 -Original Message- Sent: 05 March 2003 11:49 To: Multiple recipients of list ORACLE-L Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance -- 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: 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).
RE: Oracle Tools
Hi Sultan, Yes there is :) PocketDBA is built exactly for this purpose, and at this time is the only DBA specific tool that I have seen in the market - apart from the up and coming EM2GO product, which AFAIK is not generally available yet. Expand Beyond are the authors of PocketDBA, and have a world wide network of resellers. You can locate your nearest reseller on their web site http://www.xb.com. Their CEO is (was? I haven't seen you post in a while Ari) a member of this list.. If you have any further questions about the tool that you want answered, you can send me a mail off list if you like (we are Expand Beyond's UK reseller). Regards 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 -Original Message- Sent: 05 March 2003 11:49 To: Multiple recipients of list ORACLE-L Hi gurus, Is there any Oracle tools available to use it in Handheld Computers.(like PDA or IPAQ) Thks in advance -- 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).
RE: Oracle Magazine excels itself
he behaviour > changed in > Oracle 7.X.X, and single-instance Oracle will take > advantage of multiple free list groups. Be careful, > however, that you set FREELISTS and FREELIST > GROUPS to relatively co-prime numbers, or you > will lose some of the benefits etc." > > > So what has the dialogue achieved: > > a) It hasn't improved the knowledge of the > readers. > > b) It has told readers that they had better not > write in if they think that there is an error in > one of the articles unless they want to run > the risk of looking stupid in public. > > c) It has given Rich Niemiec the chance to > say "I'm right, you're wrong - yah, boo, sucks". > > > I'm not impressed.. > > > > Regards > > Jonathan Lewis > http://www.jlcomp.demon.co.uk > > Coming soon one-day tutorials: > Cost Based Optimisation > Trouble-shooting and Tuning > Indexing Strategies > (see http://www.jlcomp.demon.co.uk/tutorial.html ) > > UK___March 19th > UK___April 8th > UK___April 22nd > > USA_(FL)_May 2nd > > > Next Seminar dates: > (see http://www.jlcomp.demon.co.uk/seminar.html ) > > USA_(CA, TX)_August > > > The Co-operative Oracle Users' FAQ > http://www.jlcomp.demon.co.uk/faq/ind_faq.html > > > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.net > -- > Author: Jonathan Lewis > 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). > = Connor McDonald web: http://www.oracledba.co.uk web: http://www.oaktable.net email: [EMAIL PROTECTED] "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day" ______ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Deshpande, Kirti 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: 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).
OT - MS at it again?
http://www.theregister.co.uk/content/4/29519.html Hm 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).
U2 Databases
Does anybody out there use "U2" databases? http://www.theregister.co.uk/content/53/29457.html 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).
RE: Oracle Monitor
Hi Mitchell, When you say "monitor", what exactly do you mean? The definition of a "Monitoring" tool (in my eyes at least) is a tool that will sit and monitor your database, and tell you when a problem could be, or is, imminent (via background processes and alerts). The list that you specify, whilst all good tools, are not (exactly) "monitors". Quest's Spotlight is more of a "diagnostics" tool, granted it has a lot of "monitoring" features, but it is essentially a SQL*Net/Net 8 based client, that has to be open for "monitoring" to occur, and more to the point, you have to be looking at the screen to notice any "problems". Quests true "monitoring" tool is I/Watch (or Foglight, depending..). PocketDBA, again, is not a monitor (we are Expand Beyond's UK distributor). It is more of a diagnostics tool aimed at the "mobile" market. It has no mechanism to get an alert or to you the DBA, though it DOES allow you to get to the bottom of problems very quickly, once you have received an alert however! ;) I honestly couldn't comment on Oracle Performance Monitor, having not tried it. There are other tools available on the market though. Here's a list of those that I would class as having "monitors": Precise (www.precisesoft.com) Quest (www.quest.com) BMC (www.bmc.com) Embarcadero (www.embarcardero.com) - I'm not entirely sure whether Performance Centre has alerting yet. Bradmark (www.bradmark.com) and therefore (www.cool-tools.co.uk as well :D) Oracle (who needs a URL) There are a number of others out there in the market, with tools such as "Big Brother" (now taken over by Quest I think) "orasnap", "mamba" etc. . The ones listed above however, are those that I would list as the market leaders. We sell Bradmark's offering (NORAD) along with PocketDBA, to allow NORAD alerts to be sent to a mobile phone (as well as email, pager, SNMP_TRAPS etc.), and "actioned" straight away with PocketDBA. Remember, often the main driving force for monitors is to ease the DBAs work load, by giving the day to day monitoring tasks to a tool to handle. If you need to be watching a screen - this defeats the object! :) HTH 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 -Original Message- Sent: 25 February 2003 15:49 To: Multiple recipients of list ORACLE-L Hi DBAs We are reviewing anything related to database monitor. The following is my aware. Is there anything else you recommend Spotlight from quest Pocket DBA from Expand Beyond Oracle Performance Monitor Thanks in advance. Mitchell -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mitchell 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: 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).
RE: OFF TOPIC: Jedis, etc - was Top 10....
A little more digging: http://www.statistics.gov.uk/census2001/profiles/commentaries/ethnicity.asp# religion "At the time the Census was carried out, there was an internet campaign that encouraged people to answer the religion question "Jedi Knight". The number of people who stated Jedi was 390,000 (0.7 per cent of the population)." -Original Message- Peter Rbh Sent: 25 February 2003 09:39 To: Multiple recipients of list ORACLE-L Not true. This isn't a list for urban myths - if you're going to go off-topic, you could at least do it accurately. :-) http://www.statistics.gov.uk/cci/nugget.asp?id=293 Sikh - 336,000 people. Jewish - 267,000 people. Buddhist - 152,000 people. Jedi was classified under 'Other religion' along with Druidism, Satanism, Wicca, Pagan, Freethinker, etc, etc. The total for ALL these was only 179,000. Of course, Jedi only got as many 'votes' as it did because of a spoof email which tried to convince people that it would make it into an 'official' religion. Which is, of course, complete twaddle! -- Peter Moore Systems DBA, SchlumbergerSema, Reading > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] > Sent: 25 February 2003 08:14 > To: Multiple recipients of list ORACLE-L > Subject: Re: Top 10 DBA Do's and Don'ts anyone - Here is my list, > > > > Perhaps we depend to much on the force to guide and protect > us at times... > > :-) > > Laugh you may, but in the last UK census (not a poll mind you > but the actual > national census) 400,000 people indicated their religion was > "Jedi". This > was more than put their religion as Sikh, Jewish or Buddhist. > > Of course its just a re-hash of Vitalisim, but (Oh dear, now I've > annoyed nearly half a million people and all of 'em on the > same tiny island > as me :-) > > -Dale > -- > Generate HTML schema documentation with the free DDL to HTML > converter. > DBATool: http://www.DataBee.com/dt_home.htm _ This email is confidential and intended solely for the use of the individual to whom it is addressed. Any views or opinions presented are solely those of the author and do not necessarily represent those of SchlumbergerSema. If you are not the intended recipient, be advised that you have received this email in error and that any use, dissemination, forwarding, printing, or copying of this email is strictly prohibited. If you have received this email in error please notify the SchlumbergerSema Helpdesk by telephone on +44 (0) 121 627 5600. _ -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MOORE, Peter Rbh 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: 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).