RE: Outer join in SQL server - A very simple question
of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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 Server Q?
Title: OT: SQL Server Q? sp configure 'user connections' This is an advanced option (believe it or not), so you may have to do "sp configure 'show advanced options', 1" before you do "sp configure 'user connections'". Alternatively you can just run SELECT @@MAX CONNECTIONS Returns something like this name minimum maximum config value run value --- --- --- --- user connections 0 32767 0 0 Run value is what's configured at present. To change "sp configure 'user connections', 1000" (or whatever) You will need to stop/start the database to make the change take affect. Ade -Original Message-From: Jack van Zanen [mailto:[EMAIL PROTECTED]Sent: 20 June 2003 13:45To: Multiple recipients of list ORACLE-LSubject: OT: SQL Server Q? Hi All I'm mainly into Oracle but in a SQLserver database we encountered this error "maximum number of DBPROCESSes already exist" In oracle I would look at the processes parameter but what would I be looking at in SQL server??? TIA Jacob A. van Zanen -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: Upgrading from 8.1.7 32 bit to 9.2.0.3 64 bit
I know we had to run utlirp.sql when moving from 32 to 64. Not sure if this is covered by running catproc as part of the migration. -Original Message- Sent: 20 June 2003 15:50 To: Multiple recipients of list ORACLE-L Hi all, Has anyone done the upgrade from 8.1.7 32 bit to 9.2.0.3 64 bit? I'm trying to determine whether it's necessary to perform any other steps than the regular upgrade process. Note 62290.1 seems to imply that no other steps are required, but this is contradicted elsewhere and it's proving almost impossible to get a straight answer from Oracle. There's one hilarious Forum exchange on metalink (search on 32 bit Sahoo) where the tech manages to avoid saying anything other than read the documentation. So, any advice, experience, or pointers to other articles out there? Thanks, Jay Miller -- 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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 SQL Server 2000 databases and Oracle tablespaces
Title: Re: Amt of Training to be considered "up to date" A SQL7/SQL2K Filegroup is equivalent to an Oracle tablespace. -Original Message-From: Boivin, Patrice J [mailto:[EMAIL PROTECTED]Sent: 25 March 2003 20:04To: Multiple recipients of list ORACLE-LSubject: OT SQL Server 2000 "databases" and Oracle "tablespaces" It used to be for SQL Server 7 that a "database" was the equivalent of a "tablespace" in Oracle 7.3. Is that still the case? Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) Systems Admin Operations | Admin. et Exploit. des systèmes Technology Services | Services technologiques Informatics Branch | Direction de l'informatique Maritimes Region, DFO | Région des Maritimes, MPO E-Mail: [EMAIL PROTECTED] -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: MTS config
Looks fine. We only have the following entries on a 9i database.. dispatchers = (protocol = TCP)(dispatchers = 6) max_dispatchers = 12 shared_servers = 10 max_shared_servers = 40 Works fine, we ended up commenting out local_listener. How long have you waited for the dispatchers to register ? It does not happen instantly. Have you tried lsnrctl reload ? -Original Message- Sent: 25 February 2003 14:04 To: Multiple recipients of list ORACLE-L OK, Someone dope slap me! I added the following to my init.ora file (8.1.7.0 on HP-UX 11.0). The dispatchers start up just fine, but won't register with the listener (also 8.1.7.0). I've already done the RTFM and MetaLink RTFM but can't see the problem. mts_servers=5 mts_max_dispatchers=10 mts_max_servers=40 service_names=05 # mts_dispatchers=(PROTOCOL=ipc)(DISPATCHERS=2) mts_dispatchers=(PROTOCOL=TCP)(DISPATCHERS=4) local_listener=(address_list=(ADDRESS=(PROTOCOL=ipc)(KEY=05)) (ADDRESS=(PROTOCOL=tcp)(PORT=1521)(HOST=bart))) Thanks for the second set of eyes. BTW, the end result would be to have all outside TCP connections use MTS only. Dick Goulet -- 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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 Migration Workbench for Sybase
Do you have a Sybase Open Client CD ? The odbc drivers are usually on there. From my Sybase years I recall that the ODBC drivers were sourced from Merant, now DataDirect technologies, might be worth looking there. Personally I'd go for the bcp out/SQL*Loader in scenario. Ade -Original Message- Sent: 06 February 2003 03:59 To: Multiple recipients of list ORACLE-L Hello Listers, Anyone used this tool? What was your experience like? I am planning on using it to move about 20GB of data from a Sybase 11.x database to Oracle 8i (Rel 3). This is a one time activity. Flat file route (using Sybase 'bcp') is the alternate solution. I would like see if we could use OMWB for this. The doc says I need Sybase Adaptive Server ODBC driver Release 3.11.00.01. Searched Sybase web site for this driver, but failed to locate it. Any ideas about its source? Thanks. - Kirti -- 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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: Migration from SQL Server to ORACLE 9i
How about using SQL Server's DTS ? So long as you have Net8 plus an OLEDB driver for Oracle installed on your SQL Server box you can just shift the tables across. Point and click in true SQL Server fashion, you can't go wrong. Ade -Original Message- Sent: 04 February 2003 14:40 To: Multiple recipients of list ORACLE-L Babu - Congratulations on the project! Is this database especially large or are you facing severe restrictions in terms of the amount of time the data is unavailable to your users? Are there any unusual objects in SQL Server that will be difficult to create in Oracle? I think Oracle provides a migration tool, but I haven't used it. Usually I follow a procedure such as: 1. Create objects in Oracle. 2. Dump data from SQL Server to a flat file. 3. Load the data with SQL*Loader. 4. Verify the data, application. 5. Prepare for production cut-over. 6. Truncate Oracle tables. 7. Dump data from SQL Server to a flat file and load with SQL*Loader. 8. Shut down SQL*Server. 9. Verify application is ready to go live. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, February 04, 2003 3:19 AM To: Multiple recipients of list ORACLE-L Hi Listers, We are planning to migrate one of our SQL Server database to ORACLE 9i. Please point me to the checklist and required documents. Any help in this regard very much appreciated. regards Banarasi Babu T OCP, DBA -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: BanarasiBabu Tippa 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: 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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: migration from Sybase to Oracle
Best option is to use bcp to get the data out of Sybase ino a flat file, then use SQL*Loader to get the data into some Oracle staging tables. You can then use pl/sql procs to move the data to it's final destination. Ade -Original Message- Sent: 29 January 2003 12:49 To: Multiple recipients of list ORACLE-L Hi Everyone, We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models defer a lot. Is there any tool available for this kind of migration. Can we do this migration with out any tool. If yes please let me know like how should we go about this migration. If there are any websites/ checklist on effort estimation till implementation please share with me. Thanks in advance. Regards, Vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vijaya Chander V.S 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe 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: Middle Tier spawning sessions, possible performance issues
250 connections from the middle tier does sound a bit suspect, way over the top. I'm assuming 'spawns' relates to establishing connections as and when required and then disconnecting when done. I think you will find that there is quite an Oracle overhead in handling all of the connect/disconnect requests that Oracle is coping with in a non connection pooled environment. Ideally, you shouldn't be spawning connection from the middle tier. You should look at connection pooling ie. configure a fixed pool of connections per middle tier server, 20/40/whatever (and have more than one middle tier server, load balanced) and have these connect when the app/web server starts up. You then round robin the connections to the clients when required, and throw them back in the pool when finished. Ade -Original Message- Sent: 30 January 2003 14:35 To: Multiple recipients of list ORACLE-L R - I haven't yet been the victim of .net (thankfully), and I hope someone with direct experience will reply. But just in case, I'll mention a couple of ideas. Try to sample the SQL that is being inflicted on Oracle. Microsoft interfaces tend to have default settings for the lowest common denominator (like accessing a flat file). I've seen them do stuff like pull the entire table over just to verify that it hasn't changed. This sort of thing can usually be corrected by using other than default settings. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Thursday, January 30, 2003 7:15 AM To: Multiple recipients of list ORACLE-L I'm far more of a developer than a DBA, but when someone told me this it set off a big red light in my head. We are using an Oracle Backend with a .net front front. One of our .net guys told me that the middle tier they are using 'spawns' sessions. We have 2 pretty distinct skillsets here so fixing the middle tier is probably way beyond my pervue. However, they told me that in a recent demo, the performance degraded overtime. Its my understanding that generally this is caused by one of two things. 1. Failure to use Bind Variables... we are using them everywhere. 2. Too many sessions. Am I on the right track here? How much would shared server mode help? This may be an enormous issue since they are expecting 250 contiguous users. Another option I tossed around was moving as much logic from the client side to the database to avoid the session spawning. I know that generally this is a good idea, but its difficult when the database people are lousy in C# and the .net people our lousy in PL/SQL and SQL. Any opinions? -- 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: 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Win2k/8.1.7/SQL Question
Title: RE: Win2k/8.1.7/SQL Question Have a look at the SQL Referenceguide in the 8i docs. It says that 8i is broadly compatible with the ANSI SQL-99 Core specification, that explains why the SQL listed below works with 8i. Ade -Original Message-From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]]Sent: 15 January 2003 15:30To: Multiple recipients of list ORACLE-LSubject: RE: Win2k/8.1.7/SQL Question I looked at our copy of the 9i Docs, and did some hunting around on the web, and this code definitely looks like 9i SQL. However, the Siebel instance is 8.1.7.3 (or 4...I don't exactly remember). How can they be running this SQL? Thanks, Mike -Original Message-From: Orr, Steve [mailto:[EMAIL PROTECTED]]Sent: Tuesday, January 14, 2003 5:14 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Win2k/8.1.7/SQL Question Well that looks like ANSI compatible SQL that should run under Oracle9i. Take a look and the 9i docs to develop a strategy for the "retrofit." This is so weird for me... having to unlearn Oracle syntax in order to write ANSI SQL. Sigh... -Original Message- From: Vergara, Michael (TEM) [mailto:[EMAIL PROTECTED]] Sent: Tuesday, January 14, 2003 4:54 PM To: Multiple recipients of list ORACLE-L Subject: Win2k/8.1.7/SQL Question My European customers are trying to optimize some SQL that is used in their Siebel implementation. It uses a syntax that I am unfamiliar with. The SQL looks like: SELECT ... FROM SIEBEL.S_PARTY T1 INNER JOIN SIEBEL.S_ORG_EXT T2 ON T1.ROW_ID = T2.PAR_ROW_ID INNER JOIN SIEBEL.S_ORG_EXT T3 ON T2.MASTER_OU_ID = T3.PAR_ROW_ID INNER JOIN SIEBEL.S_ACCNT_POSTN T4 ON (T4.POSITION_ID = '1-6M10' 0.05) AND T2.ROW_ID = T4 INNER JOIN SIEBEL.S_PARTY T5 ON (T5.ROW_ID = T4.POSITION_ID, 0.05) LEFT OUTER JOIN SIEBEL.S_ORG_EXT T6 ON T2.PAR_OU_ID = T6.PAR_ROW_ID LEFT OUTER JOIN SIEBEL.S_ACCNT_POSTN T7 ON T1.ROW_ID = T7.OU_EXT_ID LEFT OUTER JOIN SIEBEL.S_ORG_PROMOPRFL T8 ON T2.ROW_ID = T8.ACCNT_ID AND T2.PR_PRFL_ID = ... WHERE ((T2.INT_ORG_FLG != 'Y' OR T2.PRTNR_FLG != 'N') AND T2.ACCNT_FLG != 'N') ORDER BY T2.PRTNR_SALES_RANK I did a cut-and-paste, so if there is missing punctuation I don't know that either. Can anyone tell me how this is supposed to work, or how I can translate into Oracle-compatible SQL? Thanks, Mike -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: Oracle 9i installation - Basic Qs
Go an X Server running on your PC ? Is the UNIX box behind a firewall, need to open up ports ? Need to add in any routes on the server ? -Original Message- Sent: 26 November 2002 14:39 To: Multiple recipients of list ORACLE-L Oracle 9i installation on Solaris being attempted # xhost + Message - unable to open display : export DISPLAY=PC Client IP address:0.0 # xhost + Xlib : connection to client refused PC Client IP Address Xlib : cannot set display to PC Client IP Address NOTE - Installation being initiated from a laptop using Exceed Hummingbird software to simulate Xwindows Console Any Solutions ? Thanks -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA 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). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe 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 and TSM
Ian,
You need TDP installed on all target nodes, however you don't need TDP
installed on the node where the catalog resided. Also, you need only one
tdpo.opt per node, but don't need one for the catalog ('cos TDP will not be
installed there).
We have always used the default of adsmorc for TDPO_FS.
You can run RMAN from the target servers, I guess this is the usual approach
for most folks. However, you can also run RMAN from a central server (so all
backups are scheduled centrally) and connect to all targets over the wire
via TNS.
Ade
-Original Message-
Sent: 09 October 2002 23:13
To: Multiple recipients of list ORACLE-L
I'm trying to use RMAN and TSM to backup multiple databases spread across
various nodes with some nodes hosting more than one database. The RMAN
catalog database will reside on a node different from any of the nodes
hosting the other databases. I have long used ADSM without the RMAN
clothing to backup the databases. I have convinced the SA's to move on to
TSM, and now I need to add the RMAN adornments.
I assume I need the SA's to install TDP for Oracle on all the nodes
requiring RMAN backup. Do I also need to install it on the machine which
will host the catalog database. That database will undergo cold backup
using naked TSM. The same question applies to the tdpo.opt file. Do I
need multiple TDPO_FS values and multiple tdpo.opt files to hold them.
I am also assuming I will start RMAN from one of the databases requiring
backup and connect also to the RMAN catalog. Is this typical.
Ian MacGregor
Stanford Linear Accelerator Center
[EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: MacGregor, Ian A.
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).
--
Live Life in Broadband
www.telewest.co.uk
The information transmitted is intended only for the person or entity to which it is
addressed and may contain confidential and/or privileged material.
Statements and opinions expressed in this e-mail may not represent those of the
company. Any review, retransmission, dissemination or other use of, or taking of any
action in reliance upon, this information by persons or entities other than the
intended recipient is prohibited. If you received this in error, please contact the
sender immediately and delete the material from any computer.
==
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Adrian Roe
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 question(allocating channels)
Joe, We only write out to tapes, so one channel equals one tape drive, each extra channel goes and gets another drive. Not too sure about disks, I guess it depends on I/O bandwith. Two channels will be faster than one, if the disk can cope with the input from two channels then maybe it makes sense. Best thing is to try it out and compare timings. Ade -Original Message-From: JOE TESTA [mailto:[EMAIL PROTECTED]]Sent: 28 August 2002 13:38To: Multiple recipients of list ORACLE-LSubject: rman question(allocating channels) I've tried to find this in the docs to no avail. If I'm writing out an RMAN backup to one disk(yes this is not ideal), then does it make sense to allocate multiple channels? Are multiple channels related to CPUs or to destinations? thanks, joe -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: Catalog target db on different version O/S
] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Catalog target db on different version O/S
-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tim Gorman INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pawan Dalmia INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
RE: Total Memory Usage in AIX System
Use 'svmon', have a look at the man pages. -Original Message- Sent: 29 July 2002 17:25 To: Multiple recipients of list ORACLE-L Hi, I have a few Oracle scripts to calculate Total Physical Memory usage by Oracle at any give time. But I would like to find out Total Memory Usage by ORACLE and NON-ORACLE processes. I used dmesg in HP system but I do not know for IBM AIX system. Please let me know if you happen to know the method to calculate the total memory usage on the system. Thank you! Muqthar Ahmed Database Administrator -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Muqthar Ahmed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle - 32bit/64bit??
Just log into the database using sqlplus and it will tell you /u01/app/oraclesqlplus / SQL*Plus: Release 9.0.1.0.0 - Production on Tue Jul 23 10:16:50 2002 (c) Copyright 2001 Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.0.1.2.0 - 64bit Production With the Partitioning option JServer Release 9.0.1.2.0 - Production SQL -Original Message- Sent: 23 July 2002 00:09 To: Multiple recipients of list ORACLE-L Hi, Does anyone know how I can verify if a database is 32 or 64 bit? Thanks. elain _ Chat with friends online, try MSN Messenger: http://messenger.msn.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: elain he INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Weird Windoze 'AT' Behavior
Have you fully qualified the path to the batch file ? Maybe the previous batch file been copied into another directory in the PATH and AT is finding this one before it finds your edited file. Ade -Original Message- Sent: 17 July 2002 14:43 To: Multiple recipients of list ORACLE-L I have Oracle 8.1.7 running on NT. I do cold backups nightly and have a batch file that is called by the NT 'AT' scheduler. I recently changed some lines of commands in the batch file and since then when the batch file is executed by 'AT' only the lines that I did not edit are executed. If I execute the batch file from the command prompt it works fine. I deleted the job from 'AT' and then entered it back in but still getting this odd behavior of only executing the commands that I did not edit. Our SA's know nothing about 'AT' so they are of no help. Has anyone else seen this odd behavior in the 'AT' function in Windoze? I know you find it hard to believe that something can be weird in Windoze. ;o) And yes, I am soon planning on learning RMAN and do hot backups. I have the 8i Backup and Recovery Handbook for my reading pleasure. I see the app that is being used going to a 24X7 schedule. Now it is only used during the day. Thanks, Dave -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: High %wio on AIX O.S. DB Server after Oracle 8i Migration
The fsync() blocks the process until all the dirty pages are written to the physical disks - maybe this is a problem with async i/o ? How many async i/o servers are configured on the AIX box (use smitty aio to check). As a start point set to the maximum to Number of CPU's * 10 and set the min to half the max. Just a thought... Ade -Original Message- Sent: Wednesday, July 10, 2002 8:49 PM To: LazyDBA.com Discussion After migration from Oracle ver 7.3.4 to 8.1.7.2 (32-bit) , %wio (%iowait) on Database Machine Exceedingly High i.e. about 60 % . NOTE - This is a Live Production Site . AIX 4.3.3 Storage Box = SSA Class Storage (7133-D40 Model) Machine S85 P-Series Application - Banking (Hybrid) SAMPLE Output Below %iowait = 60.5 % - (Detailed Output file Attached ) tty: tin tout avg-cpu: % user% sys % idle% iowait 1.2 10.0 8.9 21.88.9 60.5 Disks:% tm_act Kbps tpsKb_read Kb_wrtn hdisk0 0.7 4.0 0.8 0 240 hdisk1 1.1 5.8 1.0 12 336 hdisk3 0.0 0.0 0.0 0 0 hdisk9 0.0 0.0 0.0 0 0 hdisk6 0.0 0.0 0.0 0 0 hdisk2 1.0 4.0 0.8 0 240 hdisk4 0.0 0.0 0.0 0 0 hdisk5 0.0 0.0 0.0 0 0 hdisk11 80.4 449.1 66.6 22292 4656 hdisk7 91.0 964.4 145.9 37868 19996 hdisk10 65.5 491.5 78.4 22916 6576 hdisk13 95.5 914.3 127.2 25656 29200 hdisk14 93.5 869.1 129.5 22824 29320 hdisk15 97.9 960.8 152.6 35620 22028 hdisk16 98.4 1382.8 174.7 53112 29856 hdisk8 75.0 802.9 119.4 40816 7360 cd0 0.0 0.0 0.0 0 0 COMMENTS of Hardware Engineer :- === From the perfpmr data collected on July 5th and it has been analysed by our Labs. The performance degradation is caused by fsync() routines called by Oracle processes. In 5 secs trace, fsync was called 276 times and consumed 21.39% CPU system time. The fsync() blocks the process until all the dirty pages are written to the physical disks. We checked the old perfpmr data collected with Oracle 7.3.4.5, it doesn't have this issue. Oracle has a fix to address the fsync problem on 8.1.7.2 (64-Bit) 8.1.7.4 (32-Bit). - WE HAVE INITIATED WITH ORACLE CORP FOR A PATCH ON 8.1.7.2 32-BIT. Nevertheless Any Other Ideas just in case the Patch Does NOT bring Down the %wio Enough ? NOTE - High %wio has been Observed only on AIX O.S. (NOT Other O.S.) post migration to Oracle 8.1.7.2 Oracle documentation is here: http://tahiti.oracle.com/pls/tahiti/tahiti.homepage To unsubscribe: send a blank email to [EMAIL PROTECTED] To subscribe: send a blank email to [EMAIL PROTECTED] Visit the list archive: http://www.LAZYDBA.com/odbareadmail.pl Tell yer mates about http://www.farAwayJobs.com By using this list you agree to these terms:http://www.lazydba.com/legal.html -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: VIVEK_SHARMA INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL
RE: Re:MTS performance is too bad.
Bunyamin, You probably only need about 2 dispatchers. I think Oracle suggest 1 dispatcher for every 1000 users but that figure seems a little low to me, I'd work on the basis of 1 dispatcher for every 500. As for shared servers, work on the basis of 1 for every 10 users. Try this mts_servers = 5 mts_max_servers = 10 (increase if needed) dispatchers = 2 Ade -Original Message- Sent: 27 June 2002 09:18 To: Multiple recipients of list ORACLE-L mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-9 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. /FONT/DIV DIVFONT face=Arial size=2I have 800 MB of shared pool and not setted large_pool_size. /FONT/DIV DIVFONT face=Arial size=250 dispathers, 100 processes and 750 max processes. /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2What can I do ?nbsp; Have you got an idea. How can I check the mts performance?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Bunyamin /FONT/DIV/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Re:MTS performance is too bad.
Well yes it will as you will not have the overhead of managing all of those unnecessary processes. However, as Michael Sale has correctly pointed out, you don't need MTS for 50 connections. -Original Message- Sent: 27 June 2002 12:38 To: Multiple recipients of list ORACLE-L I agree with you but that will not help me in performance ... Bunyamin - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, June 27, 2002 12:28 PM Bunyamin, You probably only need about 2 dispatchers. I think Oracle suggest 1 dispatcher for every 1000 users but that figure seems a little low to me, I'd work on the basis of 1 dispatcher for every 500. As for shared servers, work on the basis of 1 for every 10 users. Try this mts_servers = 5 mts_max_servers = 10 (increase if needed) dispatchers = 2 Ade -Original Message- Sent: 27 June 2002 09:18 To: Multiple recipients of list ORACLE-L mts_max_servers=750 mts_min_servers=100 dispatchers=50 users total 750 users concurrent at most 50 - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, June 26, 2002 9:58 PM Bunyamin, What is MTS_MAX_SERVERS MTS_MIN_SERVERS set to? Also what is the total number of users connecting to the database? Dick Goulet Reply Separator Author: Bunyamin Karadeniz [EMAIL PROTECTED] Date: 6/26/2002 8:49 AM I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. I have 800 MB of shared pool and not setted large_pool_size. 50 dispathers, 100 processes and 750 max processes. What can I do ? Have you got an idea. How can I check the mts performance? Bunyamin !DOCTYPE HTML PUBLIC -//W3C//DTD HTML 4.0 Transitional//EN HTMLHEAD META http-equiv=Content-Type content=text/html; charset=iso-8859-9 META content=MSHTML 6.00.2600.0 name=GENERATOR STYLE/STYLE /HEAD BODY bgColor=#ff DIVFONT face=Arial size=2I have changed my 8.1.7.3.2 database to MTS on win2000. But performance is too bad. /FONT/DIV DIVFONT face=Arial size=2I have 800 MB of shared pool and not setted large_pool_size. /FONT/DIV DIVFONT face=Arial size=250 dispathers, 100 processes and 750 max processes. /FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2What can I do ?nbsp; Have you got an idea. How can I check the mts performance?/FONT/DIV DIVFONT face=Arial size=2/FONTnbsp;/DIV DIVFONT face=Arial size=2Bunyamin /FONT/DIV/BODY/HTML -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bunyamin Karadeniz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: export tables from sql Server to Oracle
Why don't you create a linked server in SQL Server that points at the Oracle OLEDB/ODBC driver. So long as you have Oracle client installed on the SQL Server box you should be able to reference the Oracle tables directly. -Original Message- Sent: 30 April 2002 22:17 To: Multiple recipients of list ORACLE-L Hi listers, Can someone tell me how import tables from SQLServer to Oracle. Thanks for your help, Ben __ Do You Yahoo!? Yahoo! Health - your guide to health and wellness http://health.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kader Ben INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN with Tivoli Data Protection for Oracle
Yep, we use it. You need to install TDP on every target server and then relink Oracle to use Tivoli's libobk.so (or libobk.a). This applies to version 2.1, version 2.2 does not require the relink stage. Ade -Original Message-From: Yahoo [mailto:[EMAIL PROTECTED]]Sent: 09 April 2002 19:56To: Multiple recipients of list ORACLE-LSubject: RMAN with Tivoli Data Protection for Oracle Hi: Anyone using RMAN with TDP backup to tape on AIX system? Do I need to install TDP on every target database or just on recovery catalog database? Thanks! -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: Deleting files on w2k
Title: RE: Deleting files on w2k Unlike UNIX, NT will not let you delete a file while another process (ie. Oracle)has got a hold on it. I assume Win2K is the same. -Original Message-From: Koivu, Lisa [mailto:[EMAIL PROTECTED]]Sent: 03 December 2001 14:20To: Multiple recipients of list ORACLE-LSubject: RE: Deleting files on w2k Believe me, I wish... if we could get a bunch of Solaris servers plus the Oracle licenses for $75,000 we'd be there... I'm stuck with this one. -Original Message- From: Kimberly Smith [SMTP:[EMAIL PROTECTED]] Sent: Friday, November 30, 2001 4:25 PM To: Multiple recipients of list ORACLE-L Subject: RE: Deleting files on w2k Um, port it to Unix -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Koivu, LisaSent: Friday, November 30, 2001 12:40 PMTo: Multiple recipients of list ORACLE-LSubject: Deleting files on w2k I'm trying to test out backup and recovery on w2k. However, I can't remove or rename a file while the database is running! It says "file in use". Am I missing something or is there a way to force this? Thanks Lisa KoivuOracle Database MonkeyFairfield Resorts, Inc.954-935-4117 -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: Oracle to Sql Server
Your best bet is to look at SQL Servers Data Transformation Services. So long as you have Net8 plus an Oracle OLEDB provider installed on the SQL2000 box you should be able to pull all of the Oracle tables across. Ade -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]Sent: 30 August 2001 17:07To: [EMAIL PROTECTED]Subject: Oracle to Sql Server Hello Folks, I am looking for some cool script to move all the database objects across from Oracle 8.1.7 to Latest Sql Server (ver ???) frequently. Is there any particular way we can do it to automate this ?? BTW: I want to pledge $20 or even willing to pay yearly subscription and it would be a good idea to Send out a Pledge form to everyone . to keep the greens coming.. Cheers RK -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. ==
RE: Converting Inner join in MS-SQL to Oracle SQL syntax
Yep, looks good (I'm a SQL7/2000 DBA). INNER JOIN etc.. is not SQL Server specific, It's just ANSI standard. If you have. select col1,col2,col3 from table1 inner join table2 on table1.id=table2.id you can then change this to the following to get it to work on Oracle select col1,col2,col3 from table1, table2 where table1.id=table2.id Ade -Original Message- Sent: 03 August 2001 23:28 To: [EMAIL PROTECTED] In short, a Micro$oft T-SQL inner join is a PL/SQL regular join. So (making a few assumptions about the structure of the tables), here is my crack at a rewrite: select KO.KS_KNOWLEDGEOBJECTID from KS_KNOWLEDGEOBJECT KO where KO.KS_AVAILABLE = 0 and not exists (select CS.KS_KNOWLEDGEOBJECTID from KS_CONCEPTSTRING CS , KS_CONCEPT C where CS.KS_CONCEPTID = C.KS_CONCEPTID and KO.KS_KNOWLEDGEOBJECTID = CS.KS_KNOWLEDGEOBJECTID and C.KS_CONCEPTTYPEID = '2'); Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, August 03, 2001 1:10 PM A developer has sent me a MS-SQL statement that he recieved from a vendor. He would like to convert this to run on Oracle. It's pretty close already but I'm having trouble with the inner join. Is there a kind soul familiar with MS-SQL that could convert this over to the right 8.0.4 Oracle syntax? select KS_KNOWLEDGEOBJECTID from KS_KNOWLEDGEOBJECT where KS_AVAILABLE = 0 and not exists (select KS_KNOWLEDGEOBJECTID from KS_CONCEPTSTRING inner join KS_CONCEPT on KS_CONCEPTSTRING.KS_CONCEPTID = KS_CONCEPT.KS_CONCEPTID where KS_KNOWLEDGEOBJECT.KS_KNOWLEDGEOBJECTID = KS_CONCEPTSTRING.KS_KNOWLEDGEOBJECTID and KS_CONCEPTTYPEID = '2') Thanks for any assistance, Cherie Machler Oracle DBA Gelco Information Network -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jon Walthour INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: moving tables to a different tablespace
Have you looked at ALTER TABLE...MOVE... ? Ade -Original Message- Sent: 26 July 2001 18:51 To: [EMAIL PROTECTED] Hi Group, Please explain what I am doing wrong. 1) exp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 2) Dropped the tables: 'OL$' and 'OL$HINTS' on webprod 3) Created tablespace outln_ts on webprod 4) Altered user outln default tablespace outln_ts 5) imp outln/outln@webprod mailto:outln/outln@webprod file=exp_file tables = 'OL$' 'OL$HINTS' 6) SQL select table_name, tablespace_name from dba_tables where owner = 'OUTLN'; TABLE_NAME TABLESPACE_NAME -- -- OL$SYSTEM OL$HINTS SYSTEM XX OUTLN_TS WHY are the tables being re-imported back into SYSTEM tablespace Oracle 8.1.7 on Sun Solaris 5.7 TIA Al Rusnak 804-734-8453 [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rusnak, George A. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Extent allocation
Thanks to all for your help, appreciated. Ade -Original Message- Sent: 21 July 2001 18:01 To: [EMAIL PROTECTED] I mean just that--that Oracle will look in its free extent cache for the first free extent the tablespace that is the same size as that which it needs. There is no particular ordering first. And that would make it appear to be distributing extents equally among the files, but not always. Sometimes it will also look, as another lister has pointed out, as if Oracle is always going to the biggest datafile in the tablespace. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, July 21, 2001 11:45 AM What do you mean by the first one on the list? The list ordered how? The order in which dynamic extent allocation is reading fet$ appears to favor distributing extents equally among files. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Sat, 21 Jul 2001, Jon Walthour wrote: Kirti and others: Actually, Oracle only uses a round-robin extent allocation method for direct loads and parallel CTAS operations. For dynamic extent allocation, Oracle doesn't fill up one file and then the next. Actually, Oracle doesn't distinguish between datafiles, but rather looks at the total free space extents for the tablespace as listed in SYS.FET$ (Oracle's free extent cache). Basically, Oracle will look for a free extent equal to the size of the one it needs to allocate(see Doc ID #69343.1 on MetaLink of details on Oracle's extent algorithm). The first one on the list, regardless of the datafile, gets picked first. If one of exact size doesn't exist, Oracle will then split an existing larger extent. This larger extent, again, will be the first one found in SYS.FET$ which can provide the necessary space. So, it can at times appear to be round-robin allocation or one-file-at-a-time when, in point of fact, it is much more complex. Jon Walthour - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Friday, July 20, 2001 6:30 PM Jeremiah is right. Depending on the version of the database this is an imaginary problem. I have been using this 'auto round robin' feature since 8.0.6 (HP-UX 32-bit). Just did quite a bit of re-organization involving partitioning a large table and used this auto round robin extent allocation feature to spread out I/O... Anyone seen this in any lower versions ?? Cheers! - Kirti Deshpande Verizon Information Services http://www.superpages.com -Original Message- From: Jeremiah Wilton [SMTP:[EMAIL PROTECTED]] Sent: Friday, July 20, 2001 4:57 PM To: Multiple recipients of list ORACLE-L Subject: Re: Extent allocation On Fri, 20 Jul 2001, Adrian Roe wrote: Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. It appears we may be discussing an imaginary problem. At least on the version I am using (8.1.6.2 HP-UX 64 bit), Oracle round robins among files with available space automatically. It does not just fill up one datafile and move on to the next. I did a little experiment: SQL create tablespace jeremiah_temp1 1 datafile '/tmp/jeremiah_temp-01.dbf' size 10m, 2 '/tmp/jeremiah_temp-02.dbf' size 10m, 3 '/tmp/jeremiah_temp-03.dbf' size 10m, 4 '/tmp/jeremiah_temp-04.dbf' size 10m; Tablespace created. SQL create table foobar 1 (baz varchar2(10)) 2 storage (initial 32k next 32k pctincrease 0 maxextents 4) 3 tablespace jeremiah_temp1; Table created. SQL insert into foobar (baz) 1 select substr(trash,1,10) from garbage where rownum = 6000; 6000 rows created. SQL commit; Commit complete. SQL select segment_name, e.bytes/1024 kb, file_name 1 from dba_extents e, dba_data_files d 2 where e.file_id = d.file_id 3 and e.segment_name = 'FOOBAR'; SEGMENT_NAME KB FILE_NAME -- -- -- FOOBAR 32 /tmp/jeremiah_temp-01.dbf FOOBAR 32 /tmp/jeremiah_temp-02.dbf FOOBAR 32 /tmp/jeremiah_temp-03.dbf FOOBAR 32 /tmp/jeremiah_temp-04.dbf So, it looks like it round robins automatically, and there is no need to do so manually. I don't know which version of Oracle was the first to do this. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton also
Extent allocation
Hi All, Is there any way to get Oracle (816) to do round robin extent allocation eg. if a tablespace has 4 data files and each file is on a different disk, can extents be allocated from each file in sequence ? As I understand, Oracle will fill one file and then go onto the next file. Cheers, Ade -- Live Life in Broadband www.telewest.co.uk The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer. == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
sort_area_size + temp tablespace extent sizing
Hi List, Quick question regarding temp tablespace extent sizing. I have always assumed that the extent size for a temporary tablespace needs to be equal to the size that sort_area_size is set to. A sort that can't fit into memory then goes and grabs temp tablespace extents of a size equal to sort_area_size. However, I have read somewhere that the extent size should be equal to sort_area_size + block size (the block being used for header infomation or something like that) eg. 8k block size and 64k sort area size results in 72K temp tablespace extent size. So, assume I have a sort area size of 128K and block size of 8k, do I need to set temp tablespace extent sizes to 128K or 136K, or doesn't it really matter. Thanks, Ade -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SQL Server basic sources of info?
Chris, Here's some stuff from a SQL Server DBA who is now learning the joys of Oracle. 1. Some useful links (swynk is probably the best) http:/www.microsoft.com/sql http://msdn.microsoft.com/sqlserver/ http://www.swynk.com/sysapps/sql.asp http://www.sqlmag.com http://www.mssqlserver.com Get a subscription to Microsoft TechNet - monthly CD's of info on all MS products, SQL7/2000 included. A lot of the stuff in here can be found online at http://www.microsoft.com/servers/sup/support.asp. Also use Books Online (ie. the manuals) 2. Copy of the software - got to buy it I'm afraid. Can download evaluation software from the Microsoft site or just go out and buy a SQL 7/2000 book, most give away an 120 day evaluation copy. 3. Mailing list - http://ls.swynk.com/scripts/lyris.pl 4. Must buy book - Inside SQL Server 7/2000 by Kalen Delaney. Have fun. Ade -Original Message- Sent: 30 March 2001 17:36 To: [EMAIL PROTECTED] I just found out that I will be the DBA on a SQL Server 7 project, and I have no SQL Server experience. I am just "overwhelmed" with excitement. At any rate, I was hoping someone could answer a few basic questions about sources of info... * What would be the equivalent "SQL Server" Metalink and Technet websites be? I am assuming that this would be somewhere on www.microsoft.com. * On Technet I can download various versions of Oracle and play at home. Where can I find a copy of SQL Server so that I can do the same. * Any equivalent Fatcity/LazyDBA list servers for SQL Server? * Any must-have, highly-recommended SQL Server books? Many thanks for the info!!! Chris "Going home this weekend to cry" P.S. Rachel, is there any chance you are finished with writing that SQL Server DBA 101 book? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Grabowy, Chris INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Solaris ODBC drivers
http://www.swynk.com/faq/sql/sqlfaq_connectivity.asp#NonMS Checkout the above link from the SQL Server FAQ which lists some options for talking to SQL6.5/7 from UNIX boxes. Best best probably is to get hold of some Sybase Open Client drivers as these should still work with MSSQL. Ade -Original Message- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]] Sent: 30 March 2001 09:46 To: [EMAIL PROTECTED] I'm currently testing the heterogeous services between Oracle 816/Solaris and SQL Server 6.5. We're using Merant ODBC driver which was bundled with Informatica Powermart. I'm able to read a table without problem in SQL Server from Oracle. My goal is to be able to execute a stored proc on SQL Server from Oracle. --- Vadim Gorbounov [EMAIL PROTECTED] wrote: Hi Bill, You may check www.merant.com. This will cost something, but as far as I know there is no free ODBC drivers on Solaris. rgds vadim gorbounov Oracle DBA -Original Message- Sent: Thursday, March 29, 2001 10:42 AM To: Multiple recipients of list ORACLE-L I am looking for ODBC drivers that will allow me to connect from an Oracle database (8.1.6) on Sun Solaris(Sparc) 2.6 to a SQLServer database on Windows NT 4.0. I plan to use Oracle's Heterogeneous Services using generic connectivity in conjunction with ODBC. Can anyone provide me with information on where to get these drivers? Thanks to any responders. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bill Becker INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vadim Gorbounov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Stphane Paquette DBA Oracle, consultant entrept de donnes Oracle DBA, datawarehouse consultant [EMAIL PROTECTED] __ Do You Yahoo!? Get email at your own domain with Yahoo! Mail. http://personal.mail.yahoo.com/?.refer=text -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?paquette=20stephane?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- The information transmitted is intended only for the person or entity to which it is addressed and may contain confidential and/or privileged material. Statements and opinions expressed in this e-mail may not represent those of the company. Any review, retransmission, dissemination or other use of, or taking of any action in reliance upon, this information by persons or entities other than the intended recipient is prohibited. If you received this in error, please contact the sender immediately and delete the material from any computer == -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Adrian Roe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you
