Which Book should I use for SQL/PLSQL OCP
Hi All Can anyone recommend me the book for SQL/PLSQL OCP exam paper. I would like to know the book which will be guiding me thoroughly Amol -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
MsAccess group
Hallo, anyone know knows any webpage where I can ask MsAccess questions about error messages? Thanks in advance Roland -- 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).
Connect sys as sydba ?
Hello, How do I disbale "connect sys as sysdba" with a null password. Thanks. ltiu -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: ltiu INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Korn Shell Q
Forgot something the call from inside the check_all_exfail.sh script looks like this... exfail.sh $EXFAIL_OPTIONS $ORACLE_SID -Original Message- Sent: Tuesday, March 05, 2002 10:23 PM To: Multiple recipients of list ORACLE-L I have a shell script called exfail.sh which checks for potential extent failures on a database. The script accepts a couple of command line switches. exfail.sh -p -g "dba apps" TEST Basically this says run the exfail.sh script against the "TEST" instance, (-p) page people if there are problems, (-g) send the page/email to everyone in the "dba" and "apps" group. This works just fine. I have another script which rolls through the oratab file and calls exfail.sh against every database on the host. check_all_exfail.sh The scripts sources in some environment files which set up the command line parameters for the host or database. EXFAIL_OPTIONS="-p -g \"dba apps\"" When I run "set -x" in the script I can see the call from check_all_exfail.sh to exfail.sh is correct just like the first example. exfail.sh -p -g "dba apps" TEST exfail.sh -p -g "dba apps" DEV exfail.sh -p -g "dba apps" FOO ... However the exfail.sh script parses the command line in an entirely different manner. The -g switch picks up "dba as the $OPTARG and not dba apps thus apps" becomes the $1 argument instead of the correct TEST I know I need to tell the check_all_exfail.sh file to parse the line twice (I think) bit I can't remember the command off had to do this. Anyone have some ideas for me to try? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Listener.log Errors
Anyone know what patterns are typically recognized as errors in the listener.log file? ORA-, "error" etc...? Thanks, Ethan Post -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: # of datafiles per tablespace
Fair Point, but isn't Async I/O limited to Raw Devices only: If not using raw, many companies don't, you can still face contention issues. Also enabling more dbwr processes gives the overhead of more background processes: I feel that multiple files per tablespace is a workable compromise. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: # of datafiles per tablespace
On Tue, 5 Mar 2002, Kimberly Smith wrote: > Kevin, let me introduce you to the world of stripping. Course, if > you are on old hardware that really isn't like it is today. I was unaware of the concurrent data access benefits of stipping. I did know about certain things being spread out, but usually I just notice that it is kind of cold, standing there without any clothes. -- Jeremiah Wilton http://www.speakeasy.net/~jwilton > -Original Message- > I am sure its been said in the notes I have not read yet but, my > biggest reason for having the multiple files is to have multiple drives. > Each file on a different drive means that the access to the file can be > spread out. Therefore you can have multiple processes accessing the files > at the same time with reduced io contention. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeremiah Wilton INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 with Parsing and TKPROF output
Ian, I'll start with some easy questions: What version of Oracle and what OS? Can you show the SQL being run or some of it? What does v$session_event and v$session_wait show? Can you reproduce it when you run the SQL called by the program from SQLPlus? I had a problem ion 815 / NT with really really long SQL statements (produced by Forms) that would parse forever and never complete - is your statement (or any of them) really long? Regards, Bruce Reardon -Original Message- Sent: Wednesday, 6 March 2002 14:53 Hi All, I have an online program that is timing out and when I trace it I get the following at the bottom of my tkprof output. It's easy to see why the transaction is running slow, because of all the parsing. But the program and all called modules are compiled with max_opencursors = 75 to stop the parsing problem, though it doesn't seem to be helping here. There are only 64 unique sql statements that all use host variables, so why does it also say there 786 sql statements in the session, what could be causing the 64 to turn into 786 and be getting reparsed all the time :-(( Any help on this would be greatly appreciated as the transaction dies after awhile and it's in production doh! Thanks Ian OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse 667 1.50 22.38 0 0 0 0 Execute 5071 0.30 0.32 0460 315514 Fetch 7439 1.17 6.60 1 66144 47257 --- -- -- -- -- -- -- total13177 2.97 29.30 1 66604 35 12771 Misses in library cache during parse: 0 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpuelapsed disk querycurrentrows --- -- -- -- -- -- -- Parse 118 0.19 3.89 0 0 0 0 Execute533 0.32 4.56 0 0 0 532 Fetch 267 0.00 0.02 0271532 267 --- -- -- -- -- -- -- total 918 0.51 8.47 0271532 799 Misses in library cache during parse: 0 784 user SQL statements in session. 2 internal SQL statements in session. 786 SQL statements in session. 64 statements EXPLAINed in this session. Trace file: ora00503.trc Trace file compatibility: 7.03.02 Sort options: default 1 session in tracefile. 784 user SQL statements in trace file. 2 internal SQL statements in trace file. 786 SQL statements in trace file. 68 unique SQL statements in trace file. 64 SQL statements EXPLAINed using schema: CSISDBA.prof$plan_table Default table was used. Table was created. Table was dropped. 19969 lines in trace file. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Korn Shell Q
I have a shell script called exfail.sh which checks for potential extent failures on a database. The script accepts a couple of command line switches. exfail.sh -p -g "dba apps" TEST Basically this says run the exfail.sh script against the "TEST" instance, (-p) page people if there are problems, (-g) send the page/email to everyone in the "dba" and "apps" group. This works just fine. I have another script which rolls through the oratab file and calls exfail.sh against every database on the host. check_all_exfail.sh The scripts sources in some environment files which set up the command line parameters for the host or database. EXFAIL_OPTIONS="-p -g \"dba apps\"" When I run "set -x" in the script I can see the call from check_all_exfail.sh to exfail.sh is correct just like the first example. exfail.sh -p -g "dba apps" TEST exfail.sh -p -g "dba apps" DEV exfail.sh -p -g "dba apps" FOO ... However the exfail.sh script parses the command line in an entirely different manner. The -g switch picks up "dba as the $OPTARG and not dba apps thus apps" becomes the $1 argument instead of the correct TEST I know I need to tell the check_all_exfail.sh file to parse the line twice (I think) bit I can't remember the command off had to do this. Anyone have some ideas for me to try? Thanks, Ethan -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on windows Advance Server is not starting Automatic
The services are set to start automatically and version for the Oracle is (Oracle Standard Edition 9.0.1) on windows and we open a tar with oracle india suppport but no help as of now. we have reinstalled Operating system (Windows Advance Server with service pack II) and Oracle Standard Edition 9.0.1 but same error. Oracle SID autostart is set TRUE in Windows Registry. I've forgot to mention one more thing. whenever we restart the system oradim.log shows ORA-01078. Then if we tried to login using system/manager, it gives ORA-01034 and ORA-27101 Oracle is being installed on the cluster environment having two nodes with same configuaration. Windows Advanced server is installed on both systems. we have installed Oracle software (Oracle Standard Edition 9.0.1) on both the systems and created database from an active cluster Node. I switched off the second node whenever I am restarting the system so that only node will be active always. I have reinstalled oracle and created the database through dbca. I am getting the same error messages this time also. I have searched for the similar postings in metalink and tried the following 1.Increase/decreasing the size of SGA 2.commented the dispatchers= (MTS option) in init.ora 3.commented SQLNET.AUTHENTICATION_SERVICES in sqlnet.ora oracle_sid and oracle_home are set properly. Registry entry for Oracle SID PFILE was pointing to e:\oracle\ora91\DATABASE\init.ora when I created database using dbca. When this doesn't worked out, I changed it to d:\oracle\admin\\pfile\init.ora where the init.ora is actually present. Apart from ORA-01078 I am not getting any other errors/logs. Oracle service is starting automatically but the database is not starting. If I manually restart the service/ startup using SQL*PLUS database comes up normally and works fine. Are there any previleges required from OS? (ORA_DBA account is present with Administrator as its member) I am loging in as Administrator. How to check whether the user has required previleges/not? We have created a small DB on the Node (not involving cluster) and its work fine. Please let me know where the problem can be. Thanks in advance Praveen -Original Message- Sent: Wednesday, March 06, 2002 3:13 AM To: Multiple recipients of list ORACLE-L Automatically How was the service created? Is it set to automatically start? Jared.Still @radisys.com To: Multiple recipients of list ORACLE-L Sent by: root<[EMAIL PROTECTED]> cc: Subject: Re: Oracle 9i on windows Advance 03/05/2002 Server is not starting Automatically 01:08 PM Please respond to ORACLE-L It might be possible for someone to help you if you include the relevent OS info ( version and service packs ) and the oracle version. Praveen Sahni <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle 9i on windows Advance Server is not starting Automatically We have a small problem. Oracle has been installed on Windows Advanced Server. Other software on the system include Microsoft Cluster Server. Oracle software has been installed on the local drive (E:) using silent installation. Database has been installed on Shared Disk (RAID) (D:) using scripts. I have created SID, password (using ORADIM and ORAPWD utility) and SPFILE. My problem is, whenever I restart the system Oracle is not connecting until I restart the Oracle service in Windows Service window. connect System/manager gives the following error ORA-01034 ORACLE not available ORA-27101 SHARED MEMORY REALM DOES NOT EXISTS. Database on cluster is not start automatically. Only service shows started but DB is not mounted.On restarting from services panel it mounts and Opens. Please let me know if any of us has faced this problem. Please let me know if we need some more information. Thanks in advance Praveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Sahni INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 --
Help with Parsing and TKPROF output
Hi All, I have an online program that is timing out and when I trace it I get the following at the bottom of my tkprof output. It’s easy to see why the transaction is running slow, because of all the parsing. But the program and all called modules are compiled with max_opencursors = 75 to stop the parsing problem, though it doesn’t seem to be helping here. There are only 64 unique sql statements that all use host variables, so why does it also say there 786 sql statements in the session, what could be causing the 64 to turn into 786 and be getting reparsed all the time :-(( Any help on this would be greatly appreciated as the transaction dies after awhile and it’s in production doh! Thanks Ian OVERALL TOTALS FOR ALL NON-RECURSIVE STATEMENTS call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 667 1.50 22.38 0 0 0 0 Execute 5071 0.30 0.32 0 460 31 5514 Fetch 7439 1.17 6.60 1 66144 4 7257 --- -- -- -- -- -- -- total 13177 2.97 29.30 1 66604 35 12771 Misses in library cache during parse: 0 OVERALL TOTALS FOR ALL RECURSIVE STATEMENTS call count cpu elapsed disk query current rows --- -- -- -- -- -- -- Parse 118 0.19 3.89 0 0 0 0 Execute 533 0.32 4.56 0 0 0 532 Fetch 267 0.00 0.02 0 271 532 267 --- -- -- -- -- -- -- total 918 0.51 8.47 0 271 532 799 Misses in library cache during parse: 0 784 user SQL statements in session. 2 internal SQL statements in session. 786 SQL statements in session. 64 statements EXPLAINed in this session. Trace file: ora00503.trc Trace file compatibility: 7.03.02 Sort options: default 1 session in tracefile. 784 user SQL statements in trace file. 2 internal SQL statements in trace file. 786 SQL statements in trace file. 68 unique SQL statements in trace file. 64 SQL statements EXPLAINed using schema: CSISDBA.prof$plan_table Default table was used. Table was created. Table was dropped. 19969 lines in trace file.
Re: Automated Standby Database tool for Unix & Linux
And how is this different from OEM data guard manager/broker? joe James Forgy wrote: > March 5, 2002: > Relational Database Consultants, Inc. (RDC) - Proudly > announces the release of the Standby Wizard For Unix & > Linux. The Standby Wizard is a GUI interface that > automates the creation, maintenance, and fail-over > functions of Oracle's standby database paradigm. With > the Standby Wizard you can create an unlimited number > of exact duplicate databases from your production > database. The Standby Wizard also makes a great QA > and testing tool with its ability to duplicate even > the most complex of databases in only a few minutes. > 30-Day evaluations are available for download at: > > http://www.relationalwizards.com/html/standby_database_download.html > > > __ > Do You Yahoo!? > Try FREE Yahoo! Mail - the world's greatest free email! > http://mail.yahoo.com/ > -- Joe Testa, Oracle DBA Nothing new to put here, hmm -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Joe Testa INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: # of datafiles per tablespace
Sweet. Sounds like a solid setup to me. -Original Message- Robert Sent: Tuesday, March 05, 2002 10:43 AM To: Multiple recipients of list ORACLE-L Well, I have a slightly different way of approaching file sizing. Here we have Hatachi storage array's on a FIDI setup. We stripe several drives, RAID, and get quite good performance. I do NOT limit datafiles to any particular size (in production). Why? Because I want to eliminate, as much as possible, any risk of a load, or user action failing because of insufficient tablespace space. While we monitor for potential space problems, sometimes things happen in bunches and very fast. We have, rather than standardize on a datafile size (early bugs with datafiles over 2gb and autoextend aside), standardized on file system sizes, 25gb in our case coupled with use of autoextend. We generally create the initial datafiles at between 5 and 10GB max, with autoextend on. We generally leave a minimum of 20% space in the file system for growth (or more). How did we come by this 25gb file system size number? I wrote some C programs that simulated random and sequential reads, blasted the heck out of the system, and 25gb FS sizes came out quite well. Smaller file system sizes can slow down bringing up the system because this usually equates to more file systems that all have to fsck'd during a boot. Larger file system sizes have recovery time impact. All in all, 25gb was a good size for us. Thus, between autoextend, monitoring and (hopefully) proactive DBA's, I eliminate outages. Restricting datafile sizes requires much more manual intervention on the part of the DBA, calls at 2am to restart loads and resize tablesaces and makes outages more likely. We also deal with the issue of moving between machines with the requirement that file systems are all 25GB. Now, if stuff is already in those file systems, then we might well have to either move stuff around or create new file systems but hey, thats my job! Just how I do things, YMMV... Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, March 05, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Having 500mb, and then 4 50mb data files is over killed. Have multiple files per tablespace is generally good pratice and should make them same size. We have limited the database files to 2G for just one reason. That reason is that if you have to recover a database or move to another box, it is easier to manage them in terms of the disk size of file system on that target box--just in case the target box file system size could not fit the large file. -Original Message- Sent: Tuesday, March 05, 2002 5:59 AM To: Multiple recipients of list ORACLE-L Ah, but we use partitioning. However, the design you described is slightly flawed me thinks. I had to do something similar at the last job and what we did is have a separate tablespace for each month, which in turn produces a separate data file of course. Not that there was anything wrong in what you said per say its just that it really does not simulate partitioning if they are all in the same tablespace. It would be purely a load balancing thing. That being said, I am not really anticipating a load balance problem on this server. Not saying its not possible, I am just not anticipating it. But with 9i it would be fairly easy to reorganize after the fact if I do experience it. -Original Message- Sent: Tuesday, March 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Not using the RBS tablespace as the tablespace of discussion because it has special requirements and can create a lot of discussion. I can fore see a reason for using multiple datafiles in a tablespace. Lets say that you have a large table than contains information based on dates. you load the table with data each year and at the years end you resize the datafile to eliminate the unused space. Then you create another datafile for the tablespace to use for the next years data and load the data for the new year. The new data is still part of the same table and tablespace but in a separate datafile. It could be a method of creating partitions when you can't afford the option or it is not available to you (pre 8). Then you would eliminate some of the bottlenecks with the IO to the drives if the datafiles are on different drives. The users would see an improvement in response time if the were querying different date based data. Also the multiple datafile concept could be used during the backup/restore process. The user could have limits to the max tape size available but still want to backup the database. I know that it could take a lot of tapes to backup a 70GIG database when your tape machine has a 2GIG limit on the tape capacity. They do still exist. ROR mª¿ªm >>> [EMAIL PROTECTED
RE: # of datafiles per tablespace
Kevin, let me introduce you to the world of stripping. Course, if you are on old hardware that really isn't like it is today. -Original Message- Sent: Tuesday, March 05, 2002 7:09 AM To: Multiple recipients of list ORACLE-L I am sure its been said in the notes I have not read yet but, my biggest reason for having the multiple files is to have multiple drives. Each file on a different drive means that the access to the file can be spread out. Therefore you can have multiple processes accessing the files at the same time with reduced io contention. -Original Message- Sent: Monday, March 04, 2002 7:23 PM To: Multiple recipients of list ORACLE-L OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M files for this puppy as opposed to just one file. I just cannot see the reasoning for this at all. None. Natta. Zilch. So educate me please if someone out there knows a legit reason they would do this. Lets assume for the sake of argument that disk size and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Changing the SID of a database
Please, try ORADIM command utility. Ferry Situmorang: Using Oracle 8.1.7 Designer 6i R4 PT Perkebunan Nusantara XIII (Persero) Pontianak-Indonesia http://www.ptpn13.com - Original Message - To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 10:23 PM > I'm going to take the datafiles from a cold backup and use them for a new > database. However, to do this, I need to change the SID of the new db. I've read > that it's possible, but not how to do it. Is this an easy thing to do, or would > it be better to extract the tables and create the new db that way? > > Thanks for any help. > Rick > -- > 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: Ferry Situmorang INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Number / 0
Hi Rajendra, The reason of this test is that I want make sure Oracle able handle division by 0 properly without giving me nice blue screen. Sinardy -Original Message- Rajendra Sent: 05 March 2002 21:18 To: Multiple recipients of list ORACLE-L Pardon my expression, but Why in the world are you dividing by zero? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Hash Anti Join Requirements
Greg, I recognize that Guy ;-) Someone else said back-channel that they thought Harrison's book mentioned the requirements. And since I had the book handy, I looked it up. Should have thought of looking there. Nonetheless, thanks for taking the time to type up the comments from the book. I appreciate it. Item 1, CBO is a given for them. Item 2 I mentioned. Item 3, surely they don't correlate a NOT IN ;-) Item 4 about OR in the main query, I don't know that I had run into that, good thing to know. Item 5, always_anti_join (and always_semi_join) are set to HASH. By the way, I mentioned in the original email that I though if you were joining tables in the sub-query, the HASH AJ couldn't be done. I proved myself wrong not long after with a few simple examples which I should have done prior to posting. I wonder if the case I ran into also had an OR in the main query that accounted for the inability to use the HASH_AJ? I'll have to go dig up that code up and see. Now to convince more developers that a NOT IN isn't necessarily the kiss of death, hasn't been for quite some time, and there are times when it is preferred. But I also need to take care to point out the minor difference between NOT EXISTS and NOT IN and how nulls are handled and can cause different results -- had to help someone with that yesterday, why does NOT EXIST return results and the NOT IN doesn't! And for what it's worth, always_anti_join and always_semi_join are undocumented parameters in 9i. And with a NOT IN, for example, the CBO will use stats and other criteria (if supplied) to decide whether to use an NL approach or a HASH AJ approach. Getting pretty interesting. Regards, Larry G. Elkins [EMAIL PROTECTED] 214.954.1781 > -Original Message- > From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Greg Moore > Sent: Tuesday, March 05, 2002 2:43 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: Hash Anti Join Requirements > > > > working with some folks who are frightened by anti-joins > > Last Halloween I went as an anti-join. It was pretty scary. > > Harrison: > > "Performance from the hash antijoin was dramatically better than for any > other [anti-join optimization] method we tried. > > ... > > To take advantage of Oracle's antijoin optimizations, the > following must be > true: > > - CBO optimization must be enabled > - Antijoin columns must not be NULL, because of the table definition or a > not null clause in the SQL > - The subquery is not correlated > - The parent query does not contain an OR clause > - The db parm ALWAYS_ANTI_JOIN is set to MERGE or HASH, or a MERGE_AJ or > HASH_AJ hint is in the subquery" > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Greg Moore -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Larry Elkins INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Planning Test Backup/Recovery
ok. Thanks for answers. Regards Eriovaldo - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 11:18 AM > Eriovaldo, > > If I were you, I would create a small test database on the production > machine, and perform backup/restore of that test database to be sure that > everything is working before I would try it on a production database. > > Once you are convinced that everything works, schedule a down time where you > can test backup/restore of the production database. > > I would also keep the test db on the production box, and as a regular > monthly schedule, test backup and restore of that database - just to make > sure that it continues to work. > > Hope this helps. > > Tom Mercadante > Oracle Certified Professional > > > -Original Message- > Sent: Monday, March 04, 2002 7:48 AM > To: Multiple recipients of list ORACLE-L > > > There should not be any problem to test the backup. > However we are testing the restores to another machine, > not on the production machine. > > Yechiel Adar, Mehish Computer Services > [EMAIL PROTECTED] > > > -Original Message- > > From: Eca Eca [SMTP:[EMAIL PROTECTED]] > > Sent: Mon, March 04, 2002 1:18 PM > > To: Multiple recipients of list ORACLE-L > > Subject: Planning Test Backup/Recovery > > > > > > Hi all : > > > > Does anyone have a planning for test backup and recovery ? > > > > I have the scripts and i am doing the backup and now we need to test it > > in production environment. > > > > I have tested it at another environment and got sucess. > > > > but at production ... it need to be very very careful ... > > > > Any sugestion ? > > > > Regards > > > > Eriovaldo > > > > > > > > > > _ > > O MSN Photos é o jeito mais fácil de compartilhar, editar e imprimir suas > > fotos preferidas: http://photos.msn.com.br/support/worldwide.aspx > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Eca Eca > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (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: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC? INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Mercadante, Thomas F > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Eriovaldo Andrietta INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Automated Standby Database tool for Unix & Linux
March 5, 2002: Relational Database Consultants, Inc. (RDC) - Proudly announces the release of the Standby Wizard For Unix & Linux. The Standby Wizard is a GUI interface that automates the creation, maintenance, and fail-over functions of Oracle's standby database paradigm. With the Standby Wizard you can create an unlimited number of exact duplicate databases from your production database. The Standby Wizard also makes a great QA and testing tool with its ability to duplicate even the most complex of databases in only a few minutes. 30-Day evaluations are available for download at: http://www.relationalwizards.com/html/standby_database_download.html __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: James Forgy INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Names server
Bruce, You can load Oracle Names from a tnsnames.ora file, the repository is not required. Setting it up this way is fairly easy. Jared "Reardon, Bruce (CALBBAY)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/05/02 03:18 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Names server Stephen or others, If I understood correctly, the email below said it is possible to have a Names Server that doesn't require its own database. I have just briefly read the manual on Names and it mentions that Names8 doesn't require a database to store topology but it is recommended. It also mentions service replication where information is stored in Names cache rather than a database. Is this what is being referred to? Stephen - can you provide a bit more information on a Names server that doesn't require a separate database. Thanks, Bruce Reardon -Original Message- Sent: Wednesday, 6 March 2002 1:29 I agree with everyone. Oracle Names saved many days/months of maintenance time in migrating new TNSNAMES to over 3 desktops. The only gotchas with ON was the creation of a separate Administrative database and 24x7 maintenance of it. With the new extensibility features not requiring a database, that job was made much easier. However, the move to LDAP will benefit you even more because all you need to do is put an entry in the directory server for the instances and "magic" occurs. I personally hate the concept of the TNSNAMES file because if violates the "knowledge" security standard of knowing what databases are within the environment. Any savvy user can figure out how to hack in once they have that kind of information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web: www.compuware.com -Original Message- Sent:Monday, March 04, 2002 6:08 PM I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared - "Freeman, Robert " <[EMAIL PROTECTED]> 03/04/02 01:38 PM Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -Original Message- Sent: Monday, March 04, 2002 3:53 PM Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Author: Freeman, Robert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Names server
Stephen or others, If I understood correctly, the email below said it is possible to have a Names Server that doesn't require its own database. I have just briefly read the manual on Names and it mentions that Names8 doesn't require a database to store topology but it is recommended. It also mentions service replication where information is stored in Names cache rather than a database. Is this what is being referred to? Stephen - can you provide a bit more information on a Names server that doesn't require a separate database. Thanks, Bruce Reardon -Original Message- Sent: Wednesday, 6 March 2002 1:29 I agree with everyone. Oracle Names saved many days/months of maintenance time in migrating new TNSNAMES to over 3 desktops. The only gotchas with ON was the creation of a separate Administrative database and 24x7 maintenance of it. With the new extensibility features not requiring a database, that job was made much easier. However, the move to LDAP will benefit you even more because all you need to do is put an entry in the directory server for the instances and "magic" occurs. I personally hate the concept of the TNSNAMES file because if violates the "knowledge" security standard of knowing what databases are within the environment. Any savvy user can figure out how to hack in once they have that kind of information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, March 04, 2002 6:08 PM I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared - "Freeman, Robert " <[EMAIL PROTECTED]> 03/04/02 01:38 PM Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration -Original Message- Sent: Monday, March 04, 2002 3:53 PM Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Author: Freeman, Robert INET: [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Riddle me this Oracle riddle...
So the answer is none of the above. -Original Message- Sent: Tuesday, March 05, 2002 5:48 PM To: Multiple recipients of list ORACLE-L You did not specify in, out or in out, so the default is: IN. Parameters that are defined as IN don't get copied but are referenced (passed by reference). Regards, Waleed (I hope I'm right!) -Original Message- Sent: Tuesday, March 05, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Riddle me this Batman. Assume Oracle9i... assume you have a table thusly defined: Table Name: TEST col_1 number col_2 varchar2(200) And now a procedure defined thusly: create or replace procedure blah_blah ( p_in_one test.col_2%type ) Now, here is the question, how much memory will p_in_one have allocated to it within PL/SQL?? Is the answer: a. 200 bytes b. 2000 bytes c. 4000 bytes d. It will be defined based on the size of the data actually being passed into the parameter of the PL/SQL procedure e. None of the above. I'm currious what your answers will be... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Riddle me this Oracle riddle...
Clearly the best guess is (e) - none of the above. It is unlikely to be based on incoming data for reasons of bounds checking. Which means that you have given us 3 static values from a range of 32767 which may be possible. ;) I haven't checked it - but if I had to guess, I would guess, based on a vague memory of something I read somewhere, that the answer is 500 bytes. Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 05 March 2002 22:47 |Riddle me this Batman. | |Assume Oracle9i... | |assume you have a table thusly defined: | |Table Name: TEST |col_1 number |col_2 varchar2(200) | |And now a procedure defined thusly: | |create or replace procedure blah_blah |( p_in_one test.col_2%type ) | |Now, here is the question, how much memory will p_in_one have allocated to |it within PL/SQL?? Is the answer: | |a. 200 bytes |b. 2000 bytes |c. 4000 bytes |d. It will be defined based on the size of the data actually being passed |into the parameter of the PL/SQL procedure |e. None of the above. | |I'm currious what your answers will be... ;-) | | |Robert G. Freeman - Oracle8i OCP |Oracle DBA Technical Lead |CSX Midtier Database Administration | |The Cigarette Smoking Man: Anyone who can appease a man's conscience can |take his freedom away from him. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Online Boot Camp
I believe that the President of OraKnowledge (Ed Haskins) is a member of this list.. (?) Mark -Original Message- Nemeth Sent: 05 March 2002 20:36 To: Multiple recipients of list ORACLE-L Has anyone gone through OraKnowledge's eboot camp? If so, what are you thoughts? http://www.oraknowledge.com tia, David __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Nemeth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Riddle me this Oracle riddle...
You did not specify in, out or in out, so the default is: IN. Parameters that are defined as IN don't get copied but are referenced (passed by reference). Regards, Waleed (I hope I'm right!) -Original Message- Sent: Tuesday, March 05, 2002 4:48 PM To: Multiple recipients of list ORACLE-L Riddle me this Batman. Assume Oracle9i... assume you have a table thusly defined: Table Name: TEST col_1 number col_2 varchar2(200) And now a procedure defined thusly: create or replace procedure blah_blah ( p_in_one test.col_2%type ) Now, here is the question, how much memory will p_in_one have allocated to it within PL/SQL?? Is the answer: a. 200 bytes b. 2000 bytes c. 4000 bytes d. It will be defined based on the size of the data actually being passed into the parameter of the PL/SQL procedure e. None of the above. I'm currious what your answers will be... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Khedr, Waleed INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Unix shell Question
Hi , This is from one post in other shell group .. I forgot who is the poster. #! /bin/sh year=`date +%Y` month=`date +%m` day=`date +%d` # figure out what yesterday was. day=`expr "$day" - 1` case "$day" in 0) month=`expr "$month" - 1` case "$month" in 0) month=12 year=`expr "$year" - 1` ;; esac # figure out the last day of the month # day=`cal $month $year | grep . | fmt -1 | tail -1` :$(cal $month $year) day = $_ ;; esac echo "$year$month$day" __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sakthi , Raj INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Dedicated process memory - NT
Sean, I'm also interested in this and whilst I can't provide a definitive answer I can provide some numbers and a script that I'm using - if anyone can point out problems or issues with the script I'll learn and correct them. Anyway, script is below (originally written to try to help find a memory leak). When I run this on our Production instance (all dedicated connections), the values it returns are: pga_curr 119.1 pga_max 119.2 uga_curr 12.5 uga_max 76.8 sum of v$sga = 386.2 Sum v$sga + pga curr + uga_curr = 517.8Mb Using Task Manager on the server shows oracle.exe memory usage at 549980 = 537.1 Mb and VM usage = 566936 = 553.6 Mb I can't explain the difference between the Task Manager output and the script output - maybe memory structures not in v$sga but I wouldn't have thought they added to 20 Mb. Our v$session count was 26 which was the number of pga rows returned by the script (& yes it includes the background processes). -- @pga_usage.sql -- 24-Dec-2001 , Bruce Reardon -- 6-Mar-2002 , B Reardon - added uga_current values. COLUMN pga_curr format 99,999,999.9 COLUMN pga_max format 99,999,999.9 COLUMN uga_curr format 99,999,999.9 COLUMN uga_max format 99,999,999.9 COLUMN name FORMAT A25 COLUMN program FORMAT A30 BREAK ON report COMPUTE SUM LABEL "Total mem" OF pga_curr , pga_max , uga_curr , uga_max ON report select s.sid , s.username , s.program , pga_curr.value AS pga_curr, pga_max.value AS pga_max , uga_curr.value AS uga_curr , uga_max.value AS uga_max FROM v$session s , ( select st.sid , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session pga memory' ) pga_curr , ( select st.sid , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session pga memory max' ) pga_max , ( select st.sid , name , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session uga memory' ) uga_curr , ( select st.sid , name , st.value/1024/1024 AS value from v$sesstat st , v$statname sn where st.statistic#=sn.statistic# and sn.name = 'session uga memory max' ) uga_max WHERE pga_curr.sid = s.sid AND pga_max.sid = s.sid AND uga_curr.sid = s.sid AND uga_max.sid = s.sid ORDER BY pga_max , sid ; COLUMN value FORMAT 999.99 COMPUTE SUM LABEL "Total mem" OF value ON report select name , value /1024/1024 AS value from v$sga; HTH & hoping to learn more myself, Bruce Reardon -Original Message- Sent: Wednesday, 6 March 2002 3:31 I'm trying to get a handle on the amount of memory allocated to a dedicated server process using NT. From having examined manuals to to begin with the terminology seems to be inconsistent. There appear to be interchangeable references to PGA and UGA and also to Dedicated Server Process memory and Shadow Process Memory. Are these pairs one in the same?. Anyway apart from my personal confusion re previous I'd like to find out what memory is allocated on a server confgured to use dedicated server process. From Appendix B in the 8i Rel 2 Win NT Admin manual I though it would be 335K. However I have "heard" that in reality this is actually 2Mb. Can anyone give me the fact's please and reference sources for same too pleez!. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Reardon, Bruce (CALBBAY) INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Riddle me this Oracle riddle...
Riddle me this Batman. Assume Oracle9i... assume you have a table thusly defined: Table Name: TEST col_1 number col_2 varchar2(200) And now a procedure defined thusly: create or replace procedure blah_blah ( p_in_one test.col_2%type ) Now, here is the question, how much memory will p_in_one have allocated to it within PL/SQL?? Is the answer: a. 200 bytes b. 2000 bytes c. 4000 bytes d. It will be defined based on the size of the data actually being passed into the parameter of the PL/SQL procedure e. None of the above. I'm currious what your answers will be... ;-) Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 on windows Advance Server is not starting Automatically
How was the service created? Is it set to automatically start? Jared.Still @radisys.com To: Multiple recipients of list ORACLE-L Sent by: root<[EMAIL PROTECTED]> cc: Subject: Re: Oracle 9i on windows Advance 03/05/2002 Server is not starting Automatically 01:08 PM Please respond to ORACLE-L It might be possible for someone to help you if you include the relevent OS info ( version and service packs ) and the oracle version. Praveen Sahni <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle 9i on windows Advance Server is not starting Automatically We have a small problem. Oracle has been installed on Windows Advanced Server. Other software on the system include Microsoft Cluster Server. Oracle software has been installed on the local drive (E:) using silent installation. Database has been installed on Shared Disk (RAID) (D:) using scripts. I have created SID, password (using ORADIM and ORAPWD utility) and SPFILE. My problem is, whenever I restart the system Oracle is not connecting until I restart the Oracle service in Windows Service window. connect System/manager gives the following error ORA-01034 ORACLE not available ORA-27101 SHARED MEMORY REALM DOES NOT EXISTS. Database on cluster is not start automatically. Only service shows started but DB is not mounted.On restarting from services panel it mounts and Opens. Please let me know if any of us has faced this problem. Please let me know if we need some more information. Thanks in advance Praveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Sahni INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Linux command to display total disk capacity
Alex, Can you elaborate this with an example (meaning exact syntex). thanks Santi -Original Message- Sent: Tuesday, March 05, 2002 12:30 PM To: Multiple recipients of list ORACLE-L pipe df -k to awk and sum the column you want On Tue, 5 Mar 2002, Nguyen, David M wrote: > Does someone know what command can be used to display total capacity of disk > drive? I can use command "df -k" but it breaks partitions apart so I have > to add them up. I need command just display a total. > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Prakriteswar Santikary INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Online Boot Camp
Has anyone gone through OraKnowledge's eboot camp? If so, what are you thoughts? http://www.oraknowledge.com tia, David __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: David Nemeth INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hash Anti Join Requirements
> working with some folks who are frightened by anti-joins Last Halloween I went as an anti-join. It was pretty scary. Harrison: "Performance from the hash antijoin was dramatically better than for any other [anti-join optimization] method we tried. ... To take advantage of Oracle's antijoin optimizations, the following must be true: - CBO optimization must be enabled - Antijoin columns must not be NULL, because of the table definition or a not null clause in the SQL - The subquery is not correlated - The parent query does not contain an OR clause - The db parm ALWAYS_ANTI_JOIN is set to MERGE or HASH, or a MERGE_AJ or HASH_AJ hint is in the subquery" -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Greg Moore INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
OCP Exam 1Z0-007
Has anyone taken the initial 9i OCP exam (1Z0-007)? I'd like your feedback. Thanks, Ken Janusz, CPIM
Re: Forms6i (6.0.8 ?) on Motif Mode
Hi Hemant, I did a conversion of 4.5 forms to 6i in Windows, Motif and Web environments simultaneously 2 years ago. I must tell you that the biggest challenge was the Motif environment (well, I did have some challenges with the web stuff too). Of course, we were also trying to keep everything with the same look-and-feel. But the Oracle support I got on the Motif side was very lukewarm. And there was a number of bugs encountered. I would encourage you to consider running them in a web environment instead, using a browser on your Unix workstations. I can't remember it right now, but I think there is a licensing issue too. You may need to license iAS to get 6i Motif on Unix. If you still want or need to proceed, let me know and I'll see if I can dig up my notes from that project and send them to you. Regards, Marc Perkowitz Senior Consultant TWJ Consulting, LLP 847-256-8866 x15 www.twjconsulting.com - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, March 04, 2002 7:08 PM > > We have a number of Forms 4.5 environments (against 7.3.4/8.1.6/8.1.7) > where the clients are Unix workstations. Therefore, the Forms they are are > Motif-mode. > > We are looking at upgrading to 6i. Has anyone upgraded to 6i Motif > (ie convert, develop and run in Motif) ? > > Hemant K Chitale > Principal DBA > Chartered Semiconductor Manufacturing Ltd > > [This e-mail is confidential and may also be privileged. If you are not the > intended recipient, please delete it and notify us immediately; you should > not copy or use it for any purpose, nor disclose its contents to any other > person. Thank you.] > > -- > 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: Marc Perkowitz INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 command to display total disk capacity
pipe df -k to awk and sum the column you want On Tue, 5 Mar 2002, Nguyen, David M wrote: > Does someone know what command can be used to display total capacity of disk > drive? I can use command "df -k" but it breaks partitions apart so I have > to add them up. I need command just display a total. > > Thanks, > David > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Nguyen, David M > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: RMAN Configuration Question
I have two repositories in test and will have 2 in production. One to
backup the databases (an instance unto itself) and one to backup the RMAN
instance (schema within one of the lesser instances). In a perfect world
where you have acres of dasd and unlimited everything, I guess it might be
cleaner. But reality sets in.
April Wells
Corporate Systems
Amarillo Texas
-Original Message-
Sent: Tuesday, March 05, 2002 12:43 PM
To: Multiple recipients of list ORACLE-L
Pat,
This makes no sense to me. I have one Rman catalog for all our databases
that are at the same release level.
I can see separate Rman catalogs for different release levels, but even this
is not necessary. Lower levels of Rman work with higher levels of the Rman
repository.
Hope this helps.
Tom Mercadante
Oracle Certified Professional
-Original Message-
Sent: Tuesday, March 05, 2002 12:53 PM
To: Multiple recipients of list ORACLE-L
I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and
Recover" course.
Page 11-5 states : It is recommended that you have a separate catalog for
each database.
My question is :
Why? Does this help you cleanup the RMAN catalog if you ever drop a
database (you can drop the schema owner)?
Is this how others have configured their RMAN database ?
Thus I am seeing 2 Configuration Models ;
Have one schema owner per database that you are backing up.
If you had two databases "PROD and DEV" then setup a RMAN-PROD and an
RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace
to manage each database's recovery info.
VERSES
Have one schema owner (catalog) for all the databases that you are backing
up.
If you had two databases "PROD and DEV" then setup one schema owner RMAN
(one RMAN Catalog) in the RMAN tablespace to manage all database recovery
info.
What are the pro's and con's?
Thanks in Advance
_
Patrick J. Howe
Oracle DBA
Illuminet Inc. (Carrier Division of Verisign)
4501 Intelco Loop SE
Email : [EMAIL PROTECTED]
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Pat Howe
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Mercadante, Thomas F
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
begin 666 InterScan_Disclaimer.txt
M5&AE(&EN9F]R;6%T:6]N(&-O;G1A:6YE9"!I;B!T:&ES(&4M;6%I;"!I3L@:70@;6%Y(&%L2!P2!A;GEO;F4@;W1H97(@=&AA
M;B!T:&4@:6YT96YD960@2!B92!I;&QE9V%L+B @268@>6]U(&AA=F4@7-T96US+"!)
M;F,N(&AA2!R96%S;VYA8FQE('!R96-A=71I;VX@=&\@
M96YS=7)E('1H870@86YY(&%T=&%C:&UE;G0@=&\@=&AI6]U(&-Ahttp://www.orafaq.com
--
Author: April Wells
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Re: RMAN Configuration Question
I am fairly new to RMAN, but here is my $.02. Use a separate RMAN db for each version of db's to be backed up (e.g. rman817, rman901, ...). In each RMAN db, I would create a separate schema, same name as Oracle_SID for each db. This model makes scripting, maintenance, and upgrades simple. Now if I were running 10+ versions of Oracle, I might have 1 RMAN db of the latest version (rman901) with a sep. schema for each db. *RMAN Newbie* Gene >>> [EMAIL PROTECTED] 03/05/02 12:53PM >>> I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and Recover" course. Page 11-5 states : It is recommended that you have a separate catalog for each database. My question is : Why? Does this help you cleanup the RMAN catalog if you ever drop a database (you can drop the schema owner)? Is this how others have configured their RMAN database ? Thus I am seeing 2 Configuration Models ; Have one schema owner per database that you are backing up. If you had two databases "PROD and DEV" then setup a RMAN-PROD and an RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace to manage each database's recovery info. VERSES Have one schema owner (catalog) for all the databases that you are backing up. If you had two databases "PROD and DEV" then setup one schema owner RMAN (one RMAN Catalog) in the RMAN tablespace to manage all database recovery info. What are the pro's and con's? Thanks in Advance _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Gene Sais INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RMAN Catalog Database : optimizer mode
I have a dedicated RMAN database (8.1.7.2) to support the RMAN catalog. Should I run this RMAN database in "cost-based" or "rule-base" optimizer mode ? _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Olympia, WA 98507 Phone : 360.493.6284 Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Names server
We switched to names server last year. We had our NT administrator net use to each client in the company (effectively assigning a drive to the administrators machine) and copy the sqlnet.ora over to the remote machine. Fired up about 10 machines and updated > 1000 systems in three different waves. Worked pretty smooth. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, March 05, 2002 1:28 PM To: Multiple recipients of list ORACLE-L Yechiel, That's all well and good if you get to set it up from the beginning. I inherited it. Tnsname.ora everywhere. Different desktops with different names for the same databases. It's a nightmare. I plan to setup Onames when I get a chance to do so. Putting tnsnames.ora on network file servers wouldn't work so well. We have offices ( and users ) in Asia, North America, Europe and the Middle East. At least I only have hundreds of desktops to deal with rather than thousands. Jared àãø éçéàì <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/05/02 07:48 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Names server Hello All I saw some remarks about updating tnsnames on many desktops. Why would you have tnsnames in every machine? I put our client software on a central server, with the tnsnames. One update to the tnsnames in the server apply to all. Installing for a new PC is importing the registry entries and add two paths to the search list, done in two minutes. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Tue, March 05, 2002 4:29 PM > To:Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with everyone. Oracle Names saved many days/months of maintenance > time in migrating new TNSNAMES to over 3 desktops. The only gotchas > with ON was the creation of a separate Administrative database and 24x7 > maintenance of it. With the new extensibility features not requiring a > database, that job was made much easier. > > However, the move to LDAP will benefit you even more because all you need > to > do is put an entry in the directory server for the instances and "magic" > occurs. I personally hate the concept of the TNSNAMES file because if > violates the "knowledge" security standard of knowing what databases are > within the environment. Any savvy user can figure out how to hack in once > they have that kind of information. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct:(248) 865-4350 > Mobile:(248) 408-2918 > Email: [EMAIL PROTECTED] > Web: www.compuware.com > > -Original Message- > Sent: Monday, March 04, 2002 6:08 PM > To:Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with you Jared. On the last job we had TNSNAMES files out to > everyones work station . got to be a pain. Installed Names, created > the right files . bingo, all worked . Very easy. > > -Original Message- > Sent: Monday, March 04, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Completely removing names from Oracle would be a mistake IMO. > > Reason: Name is fairly easy to implement, LDAP is anything but. > > Jared > > > > > > "Freeman, Robert " <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/04/02 01:38 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Names server > > > Names server is depreciated in 9i, but still there. > They were going to remove it, but I think there was a bit of a backlash, > so > they have delayed > the removal. > OID (LDAP) is the replacement. > > We use names server here, have found it to be pretty stable and reduced > tnsnames.ora > administration nicely. > > RF > > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > > > -Original Message- > Sent: Monday, March 04, 2002 3:53 PM > To: Multiple recipients of list ORACLE-L > > > Names server will be obsolete in 9i, I think. > > -Original Message- > Sent: Monday, March 04, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > > > Hi ALL: > Is any one using names server out there? How the it works? Any infor > are wellcome. > > -- >W±ë zØ^¡÷âr&¥9,BÅm¶ÿà (§Ú©Ê&ëa¢² 2ZçR¶)e§b
RE: Read Consistency & ITL's
Jared, I think he is talking about direct grants. Not granting through a view. SQL> grant select on X$BH to system; grant select on X$BH to system * ERROR at line 1: ORA-02030: can only select from fixed tables/views Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- [EMAIL PROTECTED] Sent: Tuesday, March 05, 2002 10:13 AM To: Multiple recipients of list ORACLE-L I'll take the easy question. There's nothing preventing you from granting privs on the x$ tables. See: http://www.ixora.com.au/scripts/sql/create_xviews.sql Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/02 04:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Read Consistency & ITL's Hello Gurus, As I understand it. In order to provide a read consistent view of the data while reading a data block, Oracle looks at the SCN in the block header, and compares it to the snapshot of the SCN taken when the read commenced. If the Snapshot SCN is less than the SCN in the block header, the query is directed to read from the rollback segments. For any transaction that modifies a block, the ITL among other things, also stores the commit SCN and the address to the transaction table in the rollback segment. Assume that the block has just one ITL. This ITL can be reused once the transaction is completed. Assume it is. That is, two transactions have performed updates on the block since our read commenced. If so is the case, how does Oracle know which rollback segment to look at? I am assuming it still looks at the ITL, rolls it back, sees that it needs to rollback further, looks at the ITL in the rolled back block, and rollsback further, and so on, until it can reconstruct the data block at an SCN lower than the snapshot SCN. Is that right? My second question is, what happens if the data block has two ITL's, both marked with SCN's greater than when the read commenced. Which ITL does Oracle look at to get the address of the rollback segment? Is it the one with the least SCN?? And also, my previous question, remains unanswered so far? Why does Oracle not allow one to grant select privileges on the fixed tables to any other user? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: # of datafiles per tablespace
Well, I have a slightly different way of approaching file sizing. Here we have Hatachi storage array's on a FIDI setup. We stripe several drives, RAID, and get quite good performance. I do NOT limit datafiles to any particular size (in production). Why? Because I want to eliminate, as much as possible, any risk of a load, or user action failing because of insufficient tablespace space. While we monitor for potential space problems, sometimes things happen in bunches and very fast. We have, rather than standardize on a datafile size (early bugs with datafiles over 2gb and autoextend aside), standardized on file system sizes, 25gb in our case coupled with use of autoextend. We generally create the initial datafiles at between 5 and 10GB max, with autoextend on. We generally leave a minimum of 20% space in the file system for growth (or more). How did we come by this 25gb file system size number? I wrote some C programs that simulated random and sequential reads, blasted the heck out of the system, and 25gb FS sizes came out quite well. Smaller file system sizes can slow down bringing up the system because this usually equates to more file systems that all have to fsck'd during a boot. Larger file system sizes have recovery time impact. All in all, 25gb was a good size for us. Thus, between autoextend, monitoring and (hopefully) proactive DBA's, I eliminate outages. Restricting datafile sizes requires much more manual intervention on the part of the DBA, calls at 2am to restart loads and resize tablesaces and makes outages more likely. We also deal with the issue of moving between machines with the requirement that file systems are all 25GB. Now, if stuff is already in those file systems, then we might well have to either move stuff around or create new file systems but hey, thats my job! Just how I do things, YMMV... Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Tuesday, March 05, 2002 12:33 PM To: Multiple recipients of list ORACLE-L Having 500mb, and then 4 50mb data files is over killed. Have multiple files per tablespace is generally good pratice and should make them same size. We have limited the database files to 2G for just one reason. That reason is that if you have to recover a database or move to another box, it is easier to manage them in terms of the disk size of file system on that target box--just in case the target box file system size could not fit the large file. -Original Message- Sent: Tuesday, March 05, 2002 5:59 AM To: Multiple recipients of list ORACLE-L Ah, but we use partitioning. However, the design you described is slightly flawed me thinks. I had to do something similar at the last job and what we did is have a separate tablespace for each month, which in turn produces a separate data file of course. Not that there was anything wrong in what you said per say its just that it really does not simulate partitioning if they are all in the same tablespace. It would be purely a load balancing thing. That being said, I am not really anticipating a load balance problem on this server. Not saying its not possible, I am just not anticipating it. But with 9i it would be fairly easy to reorganize after the fact if I do experience it. -Original Message- Sent: Tuesday, March 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Not using the RBS tablespace as the tablespace of discussion because it has special requirements and can create a lot of discussion. I can fore see a reason for using multiple datafiles in a tablespace. Lets say that you have a large table than contains information based on dates. you load the table with data each year and at the years end you resize the datafile to eliminate the unused space. Then you create another datafile for the tablespace to use for the next years data and load the data for the new year. The new data is still part of the same table and tablespace but in a separate datafile. It could be a method of creating partitions when you can't afford the option or it is not available to you (pre 8). Then you would eliminate some of the bottlenecks with the IO to the drives if the datafiles are on different drives. The users would see an improvement in response time if the were querying different date based data. Also the multiple datafile concept could be used during the backup/restore process. The user could have limits to the max tape size available but still want to backup the database. I know that it could take a lot of tapes to backup a 70GIG database when your tape machine has a 2GIG limit on the tape capacity. They do still exist. ROR mª¿ªm >>> [EMAIL PROTECTED] 03/04/02 09:28PM >>> no reason. I can see creating multiple files under those conditions only because you want to keep files to a specific size. Now, I di
RE: RMAN Configuration Question
Pat, This makes no sense to me. I have one Rman catalog for all our databases that are at the same release level. I can see separate Rman catalogs for different release levels, but even this is not necessary. Lower levels of Rman work with higher levels of the Rman repository. Hope this helps. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Tuesday, March 05, 2002 12:53 PM To: Multiple recipients of list ORACLE-L I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and Recover" course. Page 11-5 states : It is recommended that you have a separate catalog for each database. My question is : Why? Does this help you cleanup the RMAN catalog if you ever drop a database (you can drop the schema owner)? Is this how others have configured their RMAN database ? Thus I am seeing 2 Configuration Models ; Have one schema owner per database that you are backing up. If you had two databases "PROD and DEV" then setup a RMAN-PROD and an RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace to manage each database's recovery info. VERSES Have one schema owner (catalog) for all the databases that you are backing up. If you had two databases "PROD and DEV" then setup one schema owner RMAN (one RMAN Catalog) in the RMAN tablespace to manage all database recovery info. What are the pro's and con's? Thanks in Advance _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Names server
Yechiel,
That's all well and good if you get to set it up from the beginning.
I inherited it. Tnsname.ora everywhere. Different desktops with
different names for the
same databases. It's a nightmare. I plan to setup Onames when I get a
chance to do so.
Putting tnsnames.ora on network file servers wouldn't work so well. We
have offices
( and users ) in Asia, North America, Europe and the Middle East.
At least I only have hundreds of desktops to deal with rather than
thousands.
Jared
àãø éçéàì <[EMAIL PROTECTED]>
Sent by: [EMAIL PROTECTED]
03/05/02 07:48 AM
Please respond to ORACLE-L
To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
cc:
Subject:RE: Names server
Hello All
I saw some remarks about updating tnsnames on many desktops.
Why would you have tnsnames in every machine?
I put our client software on a central server, with the tnsnames.
One update to the tnsnames in the server apply to all.
Installing for a new PC is importing the registry entries
and add two paths to the search list, done in two minutes.
Yechiel Adar, Mehish Computer Services
[EMAIL PROTECTED]
> -Original Message-
> From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]]
> Sent: Tue, March 05, 2002 4:29 PM
> To:Multiple recipients of list ORACLE-L
> Subject: RE: Names server
>
> I agree with everyone. Oracle Names saved many days/months of
maintenance
> time in migrating new TNSNAMES to over 3 desktops. The only gotchas
> with ON was the creation of a separate Administrative database and 24x7
> maintenance of it. With the new extensibility features not requiring a
> database, that job was made much easier.
>
> However, the move to LDAP will benefit you even more because all you
need
> to
> do is put an entry in the directory server for the instances and "magic"
> occurs. I personally hate the concept of the TNSNAMES file because if
> violates the "knowledge" security standard of knowing what databases are
> within the environment. Any savvy user can figure out how to hack in
once
> they have that kind of information.
>
> Thank You
>
> Stephen P. Karniotis
> Technical Alliance Manager
> Compuware Corporation
> Direct:(248) 865-4350
> Mobile:(248) 408-2918
> Email: [EMAIL PROTECTED]
> Web: www.compuware.com
>
> -Original Message-
> Sent: Monday, March 04, 2002 6:08 PM
> To:Multiple recipients of list ORACLE-L
> Subject: RE: Names server
>
> I agree with you Jared. On the last job we had TNSNAMES files out to
> everyones work station . got to be a pain. Installed Names,
created
> the right files . bingo, all worked . Very easy.
>
> -Original Message-
> Sent: Monday, March 04, 2002 4:29 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Completely removing names from Oracle would be a mistake IMO.
>
> Reason: Name is fairly easy to implement, LDAP is anything but.
>
> Jared
>
>
>
>
>
> "Freeman, Robert " <[EMAIL PROTECTED]>
> Sent by: [EMAIL PROTECTED]
> 03/04/02 01:38 PM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
> <[EMAIL PROTECTED]>
> cc:
> Subject:RE: Names server
>
>
> Names server is depreciated in 9i, but still there.
> They were going to remove it, but I think there was a bit of a backlash,
> so
> they have delayed
> the removal.
> OID (LDAP) is the replacement.
>
> We use names server here, have found it to be pretty stable and reduced
> tnsnames.ora
> administration nicely.
>
> RF
>
>
> Robert G. Freeman - Oracle8i OCP
> Oracle DBA Technical Lead
> CSX Midtier Database Administration
>
> The Cigarette Smoking Man: Anyone who can appease a man's conscience can
> take his freedom away from him.
>
>
>
> -Original Message-
> Sent: Monday, March 04, 2002 3:53 PM
> To: Multiple recipients of list ORACLE-L
>
>
> Names server will be obsolete in 9i, I think.
>
> -Original Message-
> Sent: Monday, March 04, 2002 11:33 AM
> To: Multiple recipients of list ORACLE-L
>
>
> Hi ALL:
> Is any one using names server out there? How the it works? Any
infor
> are wellcome.
>
> --
åy« ±ç
ê ~'"jS "Ä,PÛiÿü0ÂÚ}ª¢`.¶+
Ñ%ªÞu+bZÚv+2±Ê&«BÜzÜ(®D®øzÏ9óüçNuüçÎwó9Õ&§' &¥ú+&¹¹bpíz¹Þµ§ zË?1¨¥x ËlND0åDÊ«±é_~º&¶¬¨¥x%ËlzwZCY²Æ zÚ ËFº»j×"·'(z-xEÀ
;)zYb
.+-êîjwbØ^ë,j86"Énuæ¥w¢{Zx§CRP "Ä.í
éÚê ¨¥x%Ër¢ìÛhmêÞÞuúè.¬Ê,zwm
áÄ,÷(f§uú+¢Ø^®)ߢ¹¶*') ²æìr¸x
Re: RMAN Configuration Question
Pat There are several reasons to have multiple catalog, but the most importen one is that gives the possibility to upgrade the catalog without interfering with other database backup's. There is as well the benefit if you at some time is going to query the catalog using Sql you will not have to join all the time with the db key Pat Howe wrote: >I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and >Recover" course. >Page 11-5 states : It is recommended that you have a separate catalog for >each database. > >My question is : >Why? Does this help you cleanup the RMAN catalog if you ever drop a >database (you can drop the schema owner)? >Is this how others have configured their RMAN database ? > >Thus I am seeing 2 Configuration Models ; >Have one schema owner per database that you are backing up. >If you had two databases "PROD and DEV" then setup a RMAN-PROD and an >RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace >to manage each database's recovery info. >VERSES >Have one schema owner (catalog) for all the databases that you are backing >up. >If you had two databases "PROD and DEV" then setup one schema owner RMAN >(one RMAN Catalog) in the RMAN tablespace to manage all database recovery >info. > >What are the pro's and con's? > >Thanks in Advance >_ > Patrick J. Howe > Oracle DBA > Illuminet Inc. (Carrier Division of Verisign) > 4501 Intelco Loop SE > Email : [EMAIL PROTECTED] > > -- /regards Peter Gram Phone : +45 2527 7107 Fax : +45 4466 8856 Miracle A/S Kratvej 2 2760 Målev http://miracleas.dk -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Gram INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: RMAN Configuration Question
Hi Pat, to cut to the chase here is how we do it in our shop .. we have : 1. East Coast: we have bunch of DB's & 1 tape server 2. West Coast: we have bunch of DB's & 1 tape server Rman Strategy: We have two catalogs, one which caters to all db's on east coast and backs ups db's on east coast tape server. The other catalog caters to backups for all db's on west coast and backs up to west coast tape server Catalog backup (next step) --> East coast catalog db is registered in west coast catalog and is backed up daily. So in case the east coast catalog Database goes down, we can use the west coast catalog to restore it!! And viceversa for west coast which is registered to the east coast Note: keeping the catalog on differnt independent hardware prevents single point of failure of prod and catalog Dev Databases: We dont care and just use exp/imp hth Deepak --- Pat Howe <[EMAIL PROTECTED]> wrote: > I have just completed Oracle Education's "Enterprise > DBA Part 1B: Backup and > Recover" course. > Page 11-5 states : It is recommended that you have a > separate catalog for > each database. > > My question is : > Why? Does this help you cleanup the RMAN catalog > if you ever drop a > database (you can drop the schema owner)? > Is this how others have configured their RMAN > database ? > > Thus I am seeing 2 Configuration Models ; > Have one schema owner per database that you are > backing up. > If you had two databases "PROD and DEV" then setup a > RMAN-PROD and an > RMAN-DEV schema owner (different RMAN Catalogs) in > the same RMAN tablespace > to manage each database's recovery info. > VERSES > Have one schema owner (catalog) for all the > databases that you are backing > up. > If you had two databases "PROD and DEV" then setup > one schema owner RMAN > (one RMAN Catalog) in the RMAN tablespace to manage > all database recovery > info. > > What are the pro's and con's? > > Thanks in Advance > _ > Patrick J. Howe > Oracle DBA > Illuminet Inc. (Carrier Division of Verisign) > 4501 Intelco Loop SE > Email : [EMAIL PROTECTED] > > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Pat Howe > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). __ Do You Yahoo!? Try FREE Yahoo! Mail - the world's greatest free email! http://mail.yahoo.com/ -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deepak Thapliyal INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Any Oracle Tool
Maybe I'm an anachronism, but I've tried IDE's for programming, and just can't seem to give up vi and sqlplus. If you get into some real heavy duty unit testing, throw 'make' into the mix. Jared "Mark Leith" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/05/02 02:43 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Any Oracle Tool SQLExpert - Leccotech / Cool-Tools (;p) http://www.cool-tools.co.uk TOAD - Toadsoft / Quest http://www.toadsoft.com SQL Navigator (?) - Quest http://www.quest.com PL/SQL Developer - All Round Automations http://www.allroundautomations.com Rapid SQL - Embarcadero http://www.embarcadero.com ... ... To name a few.. Personally I'd recommend SQLExpert (but I may be a little bias ;P) It gives you a variable/parameter lookup function whilst debugging - no typos! 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: 05 March 2002 10:04 To: Multiple recipients of list ORACLE-L Hi All I am facing a lot of problems in testing Stored Procedures and Functions. I have many functions which requires a lot of parameters to be passed. Even a small mistake make me lot of retype. Again testing everything against requires a lot of testing data. If any good UI is available it makes easier even to taste functions and Enter Data. I ll be very much glad if any information is passed . Thanks in Advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Read Consistency & ITL's
I'll take the easy question. There's nothing preventing you from granting privs on the x$ tables. See: http://www.ixora.com.au/scripts/sql/create_xviews.sql Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 03/04/02 04:53 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Read Consistency & ITL's Hello Gurus, As I understand it. In order to provide a read consistent view of the data while reading a data block, Oracle looks at the SCN in the block header, and compares it to the snapshot of the SCN taken when the read commenced. If the Snapshot SCN is less than the SCN in the block header, the query is directed to read from the rollback segments. For any transaction that modifies a block, the ITL among other things, also stores the commit SCN and the address to the transaction table in the rollback segment. Assume that the block has just one ITL. This ITL can be reused once the transaction is completed. Assume it is. That is, two transactions have performed updates on the block since our read commenced. If so is the case, how does Oracle know which rollback segment to look at? I am assuming it still looks at the ITL, rolls it back, sees that it needs to rollback further, looks at the ITL in the rolled back block, and rollsback further, and so on, until it can reconstruct the data block at an SCN lower than the snapshot SCN. Is that right? My second question is, what happens if the data block has two ITL's, both marked with SCN's greater than when the read commenced. Which ITL does Oracle look at to get the address of the rollback segment? Is it the one with the least SCN?? And also, my previous question, remains unanswered so far? Why does Oracle not allow one to grant select privileges on the fixed tables to any other user? Thanks Raj -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 9i on windows Advance Server is not starting Automatically
It might be possible for someone to help you if you include the relevent OS info ( version and service packs ) and the oracle version. Praveen Sahni <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 11:13 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:Oracle 9i on windows Advance Server is not starting Automatically We have a small problem. Oracle has been installed on Windows Advanced Server. Other software on the system include Microsoft Cluster Server. Oracle software has been installed on the local drive (E:) using silent installation. Database has been installed on Shared Disk (RAID) (D:) using scripts. I have created SID, password (using ORADIM and ORAPWD utility) and SPFILE. My problem is, whenever I restart the system Oracle is not connecting until I restart the Oracle service in Windows Service window. connect System/manager gives the following error ORA-01034 ORACLE not available ORA-27101 SHARED MEMORY REALM DOES NOT EXISTS. Database on cluster is not start automatically. Only service shows started but DB is not mounted.On restarting from services panel it mounts and Opens. Please let me know if any of us has faced this problem. Please let me know if we need some more information. Thanks in advance Praveen -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Praveen Sahni INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
RMAN Configuration Question
I have just completed Oracle Education's "Enterprise DBA Part 1B: Backup and Recover" course. Page 11-5 states : It is recommended that you have a separate catalog for each database. My question is : Why? Does this help you cleanup the RMAN catalog if you ever drop a database (you can drop the schema owner)? Is this how others have configured their RMAN database ? Thus I am seeing 2 Configuration Models ; Have one schema owner per database that you are backing up. If you had two databases "PROD and DEV" then setup a RMAN-PROD and an RMAN-DEV schema owner (different RMAN Catalogs) in the same RMAN tablespace to manage each database's recovery info. VERSES Have one schema owner (catalog) for all the databases that you are backing up. If you had two databases "PROD and DEV" then setup one schema owner RMAN (one RMAN Catalog) in the RMAN tablespace to manage all database recovery info. What are the pro's and con's? Thanks in Advance _ Patrick J. Howe Oracle DBA Illuminet Inc. (Carrier Division of Verisign) 4501 Intelco Loop SE Email : [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Pat Howe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: alter index rebuild online
Hello, I have used this dynamic script (on 8.1.6.x and 8.1.7.x) successfully with no corruption, for the past two years. The script actually moves the indexes from where they are originally built on a data tblsp to its index tblsp. However, dropping the "and tablespace_name = 'TBLSPD'", will result in a in-situ rebuild, which is probably what you want. Perhaps your environment is not conducive to index rebuilds ? I have 64-bit HP-UNIX, 32-bit oracle. set pagesize 0 set lines 120 set verify off set echo off set feedback off set head off spool move_indexes.sql select 'alter index '||index_name||' rebuild tablespace TBLSPX; ' from all_indexes where owner = 'MYSCHEMA' and tablespace_name = 'TBLSPD' order by index_name; spool off start move_indexes Thank you, Paul Sherman DBA voice - 781-501-4143 (office) fax- 781-278-8341 (office) email - [EMAIL PROTECTED] -Original Message- Sent: Tuesday, March 05, 2002 11:43 AM To: Multiple recipients of list ORACLE-L I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online' I got corrupted indexes. I saw on metalink that it's supposed to be fixed by 8.1.7.1 - anybody using successfully now? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sherman, Paul R. INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: # of datafiles per tablespace
Having 500mb, and then 4 50mb data files is over killed. Have multiple files per tablespace is generally good pratice and should make them same size. We have limited the database files to 2G for just one reason. That reason is that if you have to recover a database or move to another box, it is easier to manage them in terms of the disk size of file system on that target box--just in case the target box file system size could not fit the large file. -Original Message- Sent: Tuesday, March 05, 2002 5:59 AM To: Multiple recipients of list ORACLE-L Ah, but we use partitioning. However, the design you described is slightly flawed me thinks. I had to do something similar at the last job and what we did is have a separate tablespace for each month, which in turn produces a separate data file of course. Not that there was anything wrong in what you said per say its just that it really does not simulate partitioning if they are all in the same tablespace. It would be purely a load balancing thing. That being said, I am not really anticipating a load balance problem on this server. Not saying its not possible, I am just not anticipating it. But with 9i it would be fairly easy to reorganize after the fact if I do experience it. -Original Message- Sent: Tuesday, March 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Not using the RBS tablespace as the tablespace of discussion because it has special requirements and can create a lot of discussion. I can fore see a reason for using multiple datafiles in a tablespace. Lets say that you have a large table than contains information based on dates. you load the table with data each year and at the years end you resize the datafile to eliminate the unused space. Then you create another datafile for the tablespace to use for the next years data and load the data for the new year. The new data is still part of the same table and tablespace but in a separate datafile. It could be a method of creating partitions when you can't afford the option or it is not available to you (pre 8). Then you would eliminate some of the bottlenecks with the IO to the drives if the datafiles are on different drives. The users would see an improvement in response time if the were querying different date based data. Also the multiple datafile concept could be used during the backup/restore process. The user could have limits to the max tape size available but still want to backup the database. I know that it could take a lot of tapes to backup a 70GIG database when your tape machine has a 2GIG limit on the tape capacity. They do still exist. ROR mª¿ªm >>> [EMAIL PROTECTED] 03/04/02 09:28PM >>> no reason. I can see creating multiple files under those conditions only because you want to keep files to a specific size. Now, I did once find that the rollback datafiles were a bottleneck on a system I had. So we built TWO rollback tablespaces, with datafiles on different mount points etc and the rollback segments divided between the two tablespaces. cleared up that bottleneck like a dream other than that though.. why? --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > OK, I know we had the debate already but lets have another go at it. > > Say you got a tablespace, lets call it RBS and its for rollbacks. > Now, for what reason would you create a 500M file and 4 50M files > for this puppy as opposed to just one file. I just cannot see the > reasoning > for this at all. None. Natta. Zilch. > > So educate me please if someone out there knows a legit reason they > would do this. > > Lets assume for the sake of argument that disk size and mount point > size is not a limitation. Space available to me on any one mount > point > is unlimited. > > ___ > Kimberly Smith > Portland, OR > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yo
RE: alter index rebuild online
Works great on 9.0.1 david David B. Wagoner Database Administrator Arsenal Digital Solutions Worldwide, Inc. 8000 Regency Parkway, Suite 110 Cary, NC 27511-8582 Tel. (919) 466-6723 Fax (919) 466-6783 Mobile (919) 225-4962 [EMAIL PROTECTED] http://www.arsenaldigital.com/ *** NOTICE *** This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, 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 the sender by phone or email and delete this e-mail message from your computer. Thank you. -Original Message- Sent: Tuesday, March 05, 2002 11:43 AM To: Multiple recipients of list ORACLE-L I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online' I got corrupted indexes. I saw on metalink that it's supposed to be fixed by 8.1.7.1 - anybody using successfully now? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: David Wagoner INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 command to display total disk capacity
Hi, To see the size of all disks and partitions (SCSI and IDE): PHS7:/proc $ cat partitions major minor #blocks name 8 02202244 sda 8 12200873 sda1 8164406935 sdb 8174401778 sdb1 8324406935 sdc 8334401778 sdc1 3 0 14668416 hda 3 11951866 hda1 3 2 1 hda2 3 5 128488 hda5 3 6 12586896 hda6 3649770544 hdb 365 1 hdb1 3699767457 hdb5 sda = size of the first SCSI disk. sda1 = size of the first partition on the sda disk. hda = size of the first IDE disk. hda = size of the first partition on the ide disk. HIH, Antonio Belloni "Marin Dimitrov" To: Multiple recipients of list ORACLE-L @sirma.bg> cc: Sent by: Subject: Re: Linux command to display total disk [EMAIL PROTECTED]capacity m 05/03/02 13:13 Please respond to ORACLE-L - Original Message - > Does someone know what command can be used to display total capacity of disk > drive? I can use command "df -k" but it breaks partitions apart so I have > to add them up. I need command just display a total. > for an IDE drive do: cat /proc/ide/xxx/capacity ...where xxx is the disk drive u're interested in (hda, hdb,...). The size returned is in 512b blocks for SCSI it's not that easy hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
alter index rebuild online
I'm still back on 8.1.6 and when I tried to use 'alter index rebuild online' I got corrupted indexes. I saw on metalink that it's supposed to be fixed by 8.1.7.1 - anybody using successfully now? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Shaw John-P55297 INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Sun Cluster and VCS failover
We have Sun Cluster 2.2 2 node cluster, 1 Sun E6500 (14 CPUs) and 1 Sun E5500 (11 CPUs), Oracle 8 and EMC Symmetrics storage. It takes about 3 minutes for failover of 200+GB database. Michele -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Monday, March 04, 2002 4:24 PMTo: Multiple recipients of list ORACLE-LSubject: Sun Cluster and VCS failover Situation: Sun Cluster, or VERITAS Cluster. Oracle 8, 8i, or 9i 2 node Sun E6500s w/ 8 CPUs If the primary node fails, how long does it take before a user is able to connect to the secondary node, and continue their activity? I'm sure reality, and marketing times are different... I'm really interested in reality times, but at this point either would be nice. Thanks!! Nick
TOAD and 9i
I just downloaded the free version of TOAD (6.3.11.1g) and it works without any errors on 9i. (9.0.1 on XP Prof. / DELL 8200). Ken Janusz, CPIM
Dedicated process memory - NT
I'm trying to get a handle on the amount of memory allocated to a dedicated server process using NT. From having examined manuals to to begin with the terminology seems to be inconsistent. There appear to be interchangeable references to PGA and UGA and also to Dedicated Server Process memory and Shadow Process Memory. Are these pairs one in the same?. Anyway apart from my personal confusion re previous I'd like to find out what memory is allocated on a server confgured to use dedicated server process. From Appendix B in the 8i Rel 2 Win NT Admin manual I though it would be 335K. However I have "heard" that in reality this is actually 2Mb. Can anyone give me the fact's please and reference sources for same too pleez!. - Seán O' Neill Organon (Ireland) Ltd. [subscribed: digest mode] This message, including attached files, may contain confidential information and is intended only for the use by the individual and/or the entity to which it is addressed. Any unauthorized use, dissemination of, or copying of the information contained herein is not allowed and may lead to irreparable harm and damage for which you may be held liable. If you receive this message in error or if it is intended for someone else please notify the sender by returning this e-mail immediately and delete the message. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: O'Neill, Sean INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 command to display total disk capacity
Disk capacity is relevant to partition. Your df -k could show 10 partitions, this could be 10 1 drive, or 10. You might find what you need in fdisk, but use it with caution if you aren't a unix admin. -Original Message- Sent: Tuesday, March 05, 2002 9:59 AM To: Multiple recipients of list ORACLE-L Does someone know what command can be used to display total capacity of disk drive? I can use command "df -k" but it breaks partitions apart so I have to add them up. I need command just display a total. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 8.1.7 patch 2 or 3?
Thanks Mike, I'll keep an eye out for it. Lee -Original Message- Sent: 05 March 2002 15:29 To: Multiple recipients of list ORACLE-L Lee, Be aware of bug 2220597. I believe metalink identifies other 64bit OS's, but I've experience it on Tru64 5.1 (1885). Not sure if there is a bug fix available yet. Mike Hand Polaroid Corp -Original Message- Sent: Friday, March 01, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Anyone aware of 8.1.7.3 for Oracle on Tru64 ?? I haven't seen this available on OTN/Metalink and as we are upgrading our DBs at the moment I might as well go to that if its out there. TIA Lee -Original Message- Sent: 28 February 2002 17:19 To: Multiple recipients of list ORACLE-L Its surprising that a vendor goes down to the 4th digit in terms of support/nosupport. If its any help, we've been running 8.1.7.3 (solaris) since the patch came out and have not encountered any problems hth connor --- "Xiaohong Yang (Sharon)" <[EMAIL PROTECTED]> wrote: > Hi, > > I am managing a software that uses a set of 8 oracle > databases. I am > preparing to upgrade all my databases from 8.1.6.3.0 > to 8.1.7.0.0 then > apply a patch to the oracle software installation > after the upgrade. The > software that uses these databases are only > certified on patch 2 level at > the time of release. Since now the patchset 3 for > 817 is available, I > would like to get advice in whether to apply patch 3 > instead of patch 2. > Same amount of work, more benefits. The only thing > is that the application > vendor does not officially support the patch3. > > platform: Sun Solaris 2.8 > Oracle EE server 8.1.6.3.0 > > Any input is appreciated. > > Xiaohong Yang (Sharon) > Center for Bioinfomatics > UNC > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Xiaohong Yang (Sharon) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
Re: Linux command to display total disk capacity
- Original Message - > Does someone know what command can be used to display total capacity of disk > drive? I can use command "df -k" but it breaks partitions apart so I have > to add them up. I need command just display a total. > for an IDE drive do: cat /proc/ide/xxx/capacity ...where xxx is the disk drive u're interested in (hda, hdb,...). The size returned is in 512b blocks for SCSI it's not that easy hth, Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Names server
Hello All I saw some remarks about updating tnsnames on many desktops. Why would you have tnsnames in every machine? I put our client software on a central server, with the tnsnames. One update to the tnsnames in the server apply to all. Installing for a new PC is importing the registry entries and add two paths to the search list, done in two minutes. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Karniotis, Stephen [SMTP:[EMAIL PROTECTED]] > Sent: Tue, March 05, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with everyone. Oracle Names saved many days/months of maintenance > time in migrating new TNSNAMES to over 3 desktops. The only gotchas > with ON was the creation of a separate Administrative database and 24x7 > maintenance of it. With the new extensibility features not requiring a > database, that job was made much easier. > > However, the move to LDAP will benefit you even more because all you need > to > do is put an entry in the directory server for the instances and "magic" > occurs. I personally hate the concept of the TNSNAMES file because if > violates the "knowledge" security standard of knowing what databases are > within the environment. Any savvy user can figure out how to hack in once > they have that kind of information. > > Thank You > > Stephen P. Karniotis > Technical Alliance Manager > Compuware Corporation > Direct: (248) 865-4350 > Mobile: (248) 408-2918 > Email:[EMAIL PROTECTED] > Web: www.compuware.com > > -Original Message- > Sent: Monday, March 04, 2002 6:08 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Names server > > I agree with you Jared. On the last job we had TNSNAMES files out to > everyones work station . got to be a pain. Installed Names, created > the right files . bingo, all worked . Very easy. > > -Original Message- > Sent: Monday, March 04, 2002 4:29 PM > To: Multiple recipients of list ORACLE-L > > > Completely removing names from Oracle would be a mistake IMO. > > Reason: Name is fairly easy to implement, LDAP is anything but. > > Jared > > > > > > "Freeman, Robert " <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/04/02 01:38 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: Names server > > > Names server is depreciated in 9i, but still there. > They were going to remove it, but I think there was a bit of a backlash, > so > they have delayed > the removal. > OID (LDAP) is the replacement. > > We use names server here, have found it to be pretty stable and reduced > tnsnames.ora > administration nicely. > > RF > > > Robert G. Freeman - Oracle8i OCP > Oracle DBA Technical Lead > CSX Midtier Database Administration > > The Cigarette Smoking Man: Anyone who can appease a man's conscience can > take his freedom away from him. > > > > -Original Message- > Sent: Monday, March 04, 2002 3:53 PM > To: Multiple recipients of list ORACLE-L > > > Names server will be obsolete in 9i, I think. > > -Original Message- > Sent: Monday, March 04, 2002 11:33 AM > To: Multiple recipients of list ORACLE-L > > > Hi ALL: > Is any one using names server out there? How the it works? Any infor > are wellcome. > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Freeman, Robert > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (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: Kevin Lange > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (
i-Mac and Oracle.
Hi, I have heard and saw a demo on the top of the line laptop from Apple, that you can download jdeveloper from the Oracle Technet web site. Get the Linux version. suppose to run something like ./jdeveloper with no modifications. This might be a start for using the iMac with Oracle. Who did the demo, Joe Greenwald did, President of ODK www.odkinc.com Oracle Apps has a certified client for Mac's. I think you need Mac OS X 10.1 and at least 128 m of memory. Perhaps someday someone will get the linux version to run on Mac OS 10. of the database maybe 9i. Best, -john -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peterson, John/COR INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: # of datafiles per tablespace
500 M for batch transactions? -- Chris J. Guidry P.Eng. EE ATCO Electric, Metering Services Phone: (780) 420-4142 Fax: (780) 420-3854 Email: [EMAIL PROTECTED] > -Original Message- > From: Rachel Carmichael [SMTP:[EMAIL PROTECTED]] > Sent: Monday, March 04, 2002 07:28 PM > To: Multiple recipients of list ORACLE-L > Subject: Re: # of datafiles per tablespace > > no reason. I can see creating multiple files under those conditions > only because you want to keep files to a specific size. > > Now, I did once find that the rollback datafiles were a bottleneck on a > system I had. So we built TWO rollback tablespaces, with datafiles on > different mount points etc and the rollback segments divided between > the two tablespaces. > > cleared up that bottleneck like a dream > > > other than that though.. why? > > > --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > > OK, I know we had the debate already but lets have another go at it. > > > > Say you got a tablespace, lets call it RBS and its for rollbacks. > > Now, for what reason would you create a 500M file and 4 50M files > > for this puppy as opposed to just one file. I just cannot see the > > reasoning > > for this at all. None. Natta. Zilch. > > > > So educate me please if someone out there knows a legit reason they > > would do this. > > > > Lets assume for the sake of argument that disk size and mount point > > size is not a limitation. Space available to me on any one mount > > point > > is unlimited. > > > > ___ > > Kimberly Smith > > Portland, OR > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Kimberly Smith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like subscribing). > > > __ > Do You Yahoo!? > Yahoo! Sports - sign up for Fantasy Baseball > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Guidry, 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).
RE: # of datafiles per tablespace
I am sure its been said in the notes I have not read yet but, my biggest reason for having the multiple files is to have multiple drives. Each file on a different drive means that the access to the file can be spread out. Therefore you can have multiple processes accessing the files at the same time with reduced io contention. -Original Message- Sent: Monday, March 04, 2002 7:23 PM To: Multiple recipients of list ORACLE-L OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M files for this puppy as opposed to just one file. I just cannot see the reasoning for this at all. None. Natta. Zilch. So educate me please if someone out there knows a legit reason they would do this. Lets assume for the sake of argument that disk size and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle 8.1.7 patch 2 or 3?
Lee, Be aware of bug 2220597. I believe metalink identifies other 64bit OS's, but I've experience it on Tru64 5.1 (1885). Not sure if there is a bug fix available yet. Mike Hand Polaroid Corp -Original Message- Sent: Friday, March 01, 2002 3:23 AM To: Multiple recipients of list ORACLE-L Anyone aware of 8.1.7.3 for Oracle on Tru64 ?? I haven't seen this available on OTN/Metalink and as we are upgrading our DBs at the moment I might as well go to that if its out there. TIA Lee -Original Message- Sent: 28 February 2002 17:19 To: Multiple recipients of list ORACLE-L Its surprising that a vendor goes down to the 4th digit in terms of support/nosupport. If its any help, we've been running 8.1.7.3 (solaris) since the patch came out and have not encountered any problems hth connor --- "Xiaohong Yang (Sharon)" <[EMAIL PROTECTED]> wrote: > Hi, > > I am managing a software that uses a set of 8 oracle > databases. I am > preparing to upgrade all my databases from 8.1.6.3.0 > to 8.1.7.0.0 then > apply a patch to the oracle software installation > after the upgrade. The > software that uses these databases are only > certified on patch 2 level at > the time of release. Since now the patchset 3 for > 817 is available, I > would like to get advice in whether to apply patch 3 > instead of patch 2. > Same amount of work, more benefits. The only thing > is that the application > vendor does not officially support the patch3. > > platform: Sun Solaris 2.8 > Oracle EE server 8.1.6.3.0 > > Any input is appreciated. > > Xiaohong Yang (Sharon) > Center for Bioinfomatics > UNC > > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Xiaohong Yang (Sharon) > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). = Connor McDonald http://www.oracledba.co.uk (mirrored at http://www.oradba.freeserve.co.uk) "Some days you're the pigeon, some days you're the statue" __ Do You Yahoo!? Everything you'll ever need on one web page from News and Sport to Email and Music Charts http://uk.my.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Connor=20McDonald?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the messa
OS-dependent parameters (was: Secret maximum for INITRANS?)
I sometimes think that every os-dependent parameter in Oracle is secret. Oracle doesn't publish that information, and the OS vendors usually have no idea or are not likely to publish that info either. 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] -Original Message- Sent: Tuesday, March 05, 2002 9:13 AM To: Multiple recipients of list ORACLE-L Subject:Re: Secret maximum for INITRANS? I've found the note. It wasn't what I remembered, it was worse. I've just re-run a test on 9.0.1.2 that shows an interesting issue: create table t1 (n1 number, v1 varchar2(10)); create index i1 on t1(n1) pctfree 0 initrans 10; insert into t1 select rownum,'x' from all_objects where rownum <= 3000; validate index i1; select leaf_blk_len from index_stats; This shows leaf_blk_len = 3904 on my 4K blocks - follow this with a block dump, and you find that the ITL has a total length of 2 on leaf blocks, despite the demand for initrans 10. alter index rebuild; validate index i1; select leaf_blk_len from index_stats; This shows leaf_blk_len = 3712 on my 4K blocks - follow this with a block dump, and you find that the ITL has a total length of 10 as required. Comment: don't expect INITRANS to be obeyed if you do an array insert into an empty table until you have proved that it is actually obeyed. There are no doubt more tests you could do to pursue this one and find out exactly when things go wrong. My starting assumption is that it only goes wrong on a new, or truncated, table. Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: 05 March 2002 08:26 | |Nice to know the actual strategy. | |I came across an oddity some time ago |when trying to work this one out by setting |silly values for INITRANS. This would be |(correctly) ignored on a 'create index', and |then obeyed on a 'rebuild index' with the |result that the index got bigger. I think |it was 8.1.5 - it doesn't reproduce in 8.1.7.3 | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Number / 0
Title: RE: Number / 0 Sinardy You are trying to create a function based index. To do so you need the query rewrite privilege The index will still fail with a divide by 0 error (don't know why you are dividing by zero) AS USER create index wrong_logic on john(income/0) * ERROR at line 1: ORA-01031: insufficient privileges AS SYS SQL> connect internal Connected. SQL> grant query rewrite to user; AS USER SQL> create index wrong_logic on john(income/0); create index wrong_logic on john(income/0) * ERROR at line 1: ORA-01476: divisor is equal to zero 1* create index wrong_logic on john(income/4) SQL> / Index created. HTH John -Original Message- From: Sinard Xing [mailto:[EMAIL PROTECTED]] Sent: 05 March 2002 08:38 To: Multiple recipients of list ORACLE-L Subject: Number / 0 Hi guys, This is my test: SQL> desc emp Name Null? Type - EMPNO NOT NULL CHAR(3) NAME VARCHAR2(10) INCOME NUMBER(5) SQL> create index no_logic on emp(income); Index created. SQL> drop index no_logic; Index dropped. SQL> create index wrong_logic on emp(income/0); create index wrong_logic on emp(income/0) * ERROR at line 1: ORA-01031: insufficient privileges I don't understand why Oracle throw such exception (reply). Do you have any idea what is Oracle doing when Oracle find out number / 0 Sinardy = This electronic message contains information from the mmO2 plc Group which may be privileged or confidential. The information is intended to be for the use of the individual(s) or entity named above. If you are not the intended recipient be aware that any disclosure, copying, distribution or use of the contents of this information is prohibited. If you have received this electronic message in error, please notify us by telephone or email (to the numbers or address above) immediately. =
RE: # of datafiles per tablespace
Hi Kim, Ahamed Alomari (Oracle8i and Unix Performance Tuning p142-143)discusses this in more detail. However I don't think this is more relevant with the Async IO and multiple DB Writers. But this is a serious issue in older versions (oracle 7 and below) because the number of Asnyc IO thread requests were limited by a kernel constant (forgot the name btw) and exceeding this fills the alert logs with "Out of Async IO requests". This restriction was lifted in Oracle 8.0.3 and I think this is no more a problem. IIRC the number was 200 (200 requests per process) Best Regards, K Gopalakrishnan Bangalore, INDIA -Original Message- Smith Sent: Tuesday, March 05, 2002 5:48 AM To: Multiple recipients of list ORACLE-L Do you know of a web site where I could research particular thought on? I have not seen anything like that in my research. Thanks. -Original Message- [EMAIL PROTECTED] Sent: Monday, March 04, 2002 8:53 PM To: Multiple recipients of list ORACLE-L In a UNIX system it is better to have more small size datafiles than a few or one large datafile: The reason is that UNIX aquires an exclusive file write lock and therefore if you use multiple files you will avoid a situation where multiple simultaneous writes to data files become serialized and consequently reduce I/O performance: For example instead of one 2GB Data file , split it into 8 250mb: By the way I am addressing OLTP type systems with this e-mail -- 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: K Gopalakrishnan INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Linux command to display total disk capacity
Does someone know what command can be used to display total capacity of disk drive? I can use command "df -k" but it breaks partitions apart so I have to add them up. I need command just display a total. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: LOBs SPACE ?
Assuming that the lob itself is in another place, I seem to remember that the pointer in the row is 37 bytes. Yechiel Adar, Mehish Computer Services [EMAIL PROTECTED] > -Original Message- > From: Seema Singh [SMTP:[EMAIL PROTECTED]] > Sent: Mon, March 04, 2002 4:43 PM > To: Multiple recipients of list ORACLE-L > Subject: LOBs SPACE ? > > Hi > How much space occupied by LOB column of any tables? > Thx > -Seema > > > _ > Chat with friends online, try MSN Messenger: http://messenger.msn.com > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Seema Singh > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-8?Q?=E0=E3=F8_=E9=E7=E9=E0=EC?= INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Names server
I agree with everyone. Oracle Names saved many days/months of maintenance time in migrating new TNSNAMES to over 3 desktops. The only gotchas with ON was the creation of a separate Administrative database and 24x7 maintenance of it. With the new extensibility features not requiring a database, that job was made much easier. However, the move to LDAP will benefit you even more because all you need to do is put an entry in the directory server for the instances and "magic" occurs. I personally hate the concept of the TNSNAMES file because if violates the "knowledge" security standard of knowing what databases are within the environment. Any savvy user can figure out how to hack in once they have that kind of information. Thank You Stephen P. Karniotis Technical Alliance Manager Compuware Corporation Direct: (248) 865-4350 Mobile: (248) 408-2918 Email: [EMAIL PROTECTED] Web:www.compuware.com -Original Message- Sent: Monday, March 04, 2002 6:08 PM To: Multiple recipients of list ORACLE-L Subject:RE: Names server I agree with you Jared. On the last job we had TNSNAMES files out to everyones work station . got to be a pain. Installed Names, created the right files . bingo, all worked . Very easy. -Original Message- Sent: Monday, March 04, 2002 4:29 PM To: Multiple recipients of list ORACLE-L Completely removing names from Oracle would be a mistake IMO. Reason: Name is fairly easy to implement, LDAP is anything but. Jared "Freeman, Robert " <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 03/04/02 01:38 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Names server Names server is depreciated in 9i, but still there. They were going to remove it, but I think there was a bit of a backlash, so they have delayed the removal. OID (LDAP) is the replacement. We use names server here, have found it to be pretty stable and reduced tnsnames.ora administration nicely. RF Robert G. Freeman - Oracle8i OCP Oracle DBA Technical Lead CSX Midtier Database Administration The Cigarette Smoking Man: Anyone who can appease a man's conscience can take his freedom away from him. -Original Message- Sent: Monday, March 04, 2002 3:53 PM To: Multiple recipients of list ORACLE-L Names server will be obsolete in 9i, I think. -Original Message- Sent: Monday, March 04, 2002 11:33 AM To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Freeman, Robert INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kevin Lange INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Karniotis, Stephen INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED
RE: # of datafiles per tablespace
Ah, but we use partitioning. However, the design you described is slightly flawed me thinks. I had to do something similar at the last job and what we did is have a separate tablespace for each month, which in turn produces a separate data file of course. Not that there was anything wrong in what you said per say its just that it really does not simulate partitioning if they are all in the same tablespace. It would be purely a load balancing thing. That being said, I am not really anticipating a load balance problem on this server. Not saying its not possible, I am just not anticipating it. But with 9i it would be fairly easy to reorganize after the fact if I do experience it. -Original Message- Sent: Tuesday, March 05, 2002 4:58 AM To: Multiple recipients of list ORACLE-L Not using the RBS tablespace as the tablespace of discussion because it has special requirements and can create a lot of discussion. I can fore see a reason for using multiple datafiles in a tablespace. Lets say that you have a large table than contains information based on dates. you load the table with data each year and at the years end you resize the datafile to eliminate the unused space. Then you create another datafile for the tablespace to use for the next years data and load the data for the new year. The new data is still part of the same table and tablespace but in a separate datafile. It could be a method of creating partitions when you can't afford the option or it is not available to you (pre 8). Then you would eliminate some of the bottlenecks with the IO to the drives if the datafiles are on different drives. The users would see an improvement in response time if the were querying different date based data. Also the multiple datafile concept could be used during the backup/restore process. The user could have limits to the max tape size available but still want to backup the database. I know that it could take a lot of tapes to backup a 70GIG database when your tape machine has a 2GIG limit on the tape capacity. They do still exist. ROR mª¿ªm >>> [EMAIL PROTECTED] 03/04/02 09:28PM >>> no reason. I can see creating multiple files under those conditions only because you want to keep files to a specific size. Now, I did once find that the rollback datafiles were a bottleneck on a system I had. So we built TWO rollback tablespaces, with datafiles on different mount points etc and the rollback segments divided between the two tablespaces. cleared up that bottleneck like a dream other than that though.. why? --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > OK, I know we had the debate already but lets have another go at it. > > Say you got a tablespace, lets call it RBS and its for rollbacks. > Now, for what reason would you create a 500M file and 4 50M files > for this puppy as opposed to just one file. I just cannot see the > reasoning > for this at all. None. Natta. Zilch. > > So educate me please if someone out there knows a legit reason they > would do this. > > Lets assume for the sake of argument that disk size and mount point > size is not a limitation. Space available to me on any one mount > point > is unlimited. > > ___ > Kimberly Smith > Portland, OR > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the H ELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists
RE: # of datafiles per tablespace
I had the opportunity to work with a very good sys admin. We used raw on an EMC Sym and managed it all with Veritas. We both decided to keep our datafiles no bigger than 1GB regardless of TS size and at least 4 datafiles per TS. We used 36GB drives in our Sym, each divided into 9GB LUNs. Our rational was that we could isolate IO hotspots and move 1GB chunks around quickly and that we'd have a much better chance of finding a LUN available with at least 1GB free. Ofcourse, our DB was much smaller (300GB vs 1TB) but I believe our stratgey worked quite well. I guess you should go with whatever works best for you in your environment. mkb --- Gene Sais <[EMAIL PROTECTED]> wrote: > I use 10gb datafiles for a 1tb db and also back up > using Legato. Thinking about using Rman :) > > >>> [EMAIL PROTECTED] 03/05/02 03:18AM >>> > We use 4Gb datafiles here as the norm without any > problems at all and those > datafiles are all backed up with Legato. No problems > whatsoever. > > Lee > > > -Original Message- > Sent: 05 March 2002 03:33 > To: Multiple recipients of list ORACLE-L > > > That being said is there anything wrong with having > one 4G data > file for a tablespace. I personally cannot think of > any. There > were the days when 2G was the limit but that sure > isn't the case > anymore. > > The only thing I can think of is for backups. > However, I am always > going to backup on at least the tablespace level so > if I have > one file or multiple files I still need to get them > all. I don't > know if RMAN has some special feature that turns out > it makes sense > to backup just one data file of a tablespace that > has multiple > data files but I sure can't think of any good > reason. > > I just randomly picked RBS but I am seeing the same > case on > data tablespaces as well. > > -Original Message- > Carmichael > Sent: Monday, March 04, 2002 6:29 PM > To: Multiple recipients of list ORACLE-L > > > no reason. I can see creating multiple files under > those conditions > only because you want to keep files to a specific > size. > > Now, I did once find that the rollback datafiles > were a bottleneck on a > system I had. So we built TWO rollback tablespaces, > with datafiles on > different mount points etc and the rollback segments > divided between > the two tablespaces. > > cleared up that bottleneck like a dream > > > other than that though.. why? > > > --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > > OK, I know we had the debate already but lets have > another go at it. > > > > Say you got a tablespace, lets call it RBS and its > for rollbacks. > > Now, for what reason would you create a 500M file > and 4 50M files > > for this puppy as opposed to just one file. I > just cannot see the > > reasoning > > for this at all. None. Natta. Zilch. > > > > So educate me please if someone out there knows a > legit reason they > > would do this. > > > > Lets assume for the sake of argument that disk > size and mount point > > size is not a limitation. Space available to me > on any one mount > > point > > is unlimited. > > > > ___ > > Kimberly Smith > > Portland, OR > > [EMAIL PROTECTED] > > > > -- > > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > > -- > > Author: Kimberly Smith > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 > FAX: (858) 538-5051 > > San Diego, California-- Public Internet > access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an > E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > > the message BODY, include a line containing: UNSUB > ORACLE-L > > (or the name of mailing list you want to be > removed from). You may > > also send the HELP command for other information > (like subscribing). > > > __ > Do You Yahoo!? > Yahoo! Sports - sign up for Fantasy Baseball > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (858) 538-5051 > San Diego, California-- Public Internet > access / Mailing Lists > > To REMOVE yourself from this mailing list, send an > E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of > 'ListGuru') and in > the message BODY, include a line containing: UNSUB > ORACLE-L > (or the name of mailing list you want to be removed > from). You may > also send the HELP command for other information > (like subscribing). > -- > Please see the official ORACLE-L FAQ: > http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: > (85
Re: # of datafiles per tablespace
Using Sql Backtrack for backups, you are able execute the backups of multiple datafiles in parallel. Therefore, it will be faster to backup 4-1g files rather than 1-4g file if you have the necessary hardware in place. 4:58 AM PST Please respond to [EMAIL PROTECTED] Sent by:[EMAIL PROTECTED] To:"Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> cc: Hi Kathy, The only thing I can think of for your original question is a bad guess on the file size. They guessed 500 mb, ran out of file space, added a 50 mb file to the Tablespace, ran out again added 50 mb again. never ran out again. Reading other dba's minds is so much fun :-) John [EMAIL PROTECTED] wrote: That being said is there anything wrong with having one 4G data file for a tablespace. I personally cannot think of any. There were the days when 2G was the limit but that sure isn't the case anymore. The only thing I can think of is for backups. However, I am always going to backup on at least the tablespace level so if I have one file or multiple files I still need to get them all. I don't know if RMAN has some special feature that turns out it makes sense to backup just one data file of a tablespace that has multiple data files but I sure can't think of any good reason. I just randomly picked RBS but I am seeing the same case on data tablespaces as well. -Original Message- Carmichael Sent: Monday, March 04, 2002 6:29 PM To: Multiple recipients of list ORACLE-L no reason. I can see creating multiple files under those conditions only because you want to keep files to a specif ic size. Now, I did once find that the rollback datafiles were a bottleneck on a system I had. So we built TWO rollback tablespaces, with datafiles on different mount points etc and the rollback segments divided between the two tablespaces. cleared up that bottleneck like a dream other than that though.. why? --- Kimberly Smith <[EMAIL PROTECTED]> wrote: OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M files for this puppy as opposed to just one file. I just cannot see the reasoning for this at all. None. Natta. Zilch. So educate me please if someone out there knows a legit reason they would do this. Lets assume for the sake of argument that disk size and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Tracy Rahmlow INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Replication trouble
Hi, We are running Oracle 8.1.7.2.0 with Solaris 8. (Sparc) We are using read-only snaphots with multiple groups (one/schema), replication every minute. Simple 'select *' replication. One of the snapshot process seems to stall and all access to one of the tables in the actual group is blocked (any select hangs forever). Killing the snapshot job connection (alter session kill) frees the system/table. There is a trace file with >>> WAITED TOO LONG FOR A ROW CACHE ENQUEUE LOCK! <<< . We have seen this with different applications (Java) and on different systems. In these cases the replication was on the same database (but that could be because we have not run as many tests in a distributed environment = target production configuration). So no db link involved in this case. There is no normal locks on the tables. Any advice ? Regards HEnrik -- --- E-mail :[EMAIL PROTECTED] Fax +46 (0)8 410 78 501 -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Henrik Ekenber INET: [EMAIL PROTECTED]>" <[EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: # of data files per tablespace
For our OLTP systems, we standardize on all data files to be 2GB (basically for each data file we have additional two backup locations as well). Then we use whatever amount we need and keep remaining so that data file can be extended up to 2GB when required. It has been working well for us, and it is consistent for prod/dev/acpt/blah/blah etc. Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 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. *2
RE: # of datafiles per tablespace
True, but its a rare case that I need to restore just one data file. That being said, it would not be to much different with those sizes. A 10G and a 2G you might notice it... -Original Message- [EMAIL PROTECTED] Sent: Monday, March 04, 2002 9:48 PM To: Multiple recipients of list ORACLE-L And yeah!!! Restore. Imagine the loss on one datafile of 700 Mb, and one of 50Mb. Raj Rajesh Rao To: [EMAIL PROTECTED] March 05, 2002 cc: 12:45 AM Subject: RE: # of datafiles per tablespace(Document link: Rajesh Rao) If it were a data or an index tablespace, laying out a tablespace across multiple datafiles could help in striping data or partitioning. And as Kirti said, could be to balance the I/O across multiple disks. Raj "Deshpande, Kirti" rizon.com> cc: Sent by: Subject: RE: # of datafiles per tablespace [EMAIL PROTECTED] March 04, 2002 10:33 PM Please respond to ORACLE-L Other than I/O load balancing.. I can't see any other reason. But again, why those tiny 50MB files? Are these on the same disk? I hope not.. If there is no I/O bottleneck issues, I would build just one 700MB file. And then monitor how it works out.. - Kirti -Original Message- Sent: Monday, March 04, 2002 7:23 PM To: Multiple recipients of list ORACLE-L OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M files for this puppy as opposed to just one file. I just cannot see the reasoning for this at all. None. Natta. Zilch. So educate me please if someone out there knows a legit reason they would do this. Lets assume for the sake of argument that disk size and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: # of datafiles per tablespace
FWIW, there is a strong case for keeping consistent datafile sizes, similar to the argument for extent sizes. This makes for easier file exchanges for hot to not-so-hot disks, or copying the database to a new system. And segment extent size should be kept in mind, i.e., you don't want to be adding 500Mb files to your tablespace with segment extent size of 128Mb. That gives you about 23% wasted space. Mike -Original Message- OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M files for this puppy as opposed to just one file. I just cannot see the reasoning for this at all. None. Natta. Zilch. So educate me please if someone out there knows a legit reason they would do this. Lets assume for the sake of argument that disk size and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hand, Michael T INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: # of datafiles per tablespace
However, if all the disks that you are spreading the files out among are stripped you lose that advantage do you not? We strip then mirror, so we have multiple big strips and partition against that. -Original Message- [EMAIL PROTECTED] Sent: Monday, March 04, 2002 9:48 PM To: Multiple recipients of list ORACLE-L If it were a data or an index tablespace, laying out a tablespace across multiple datafiles could help in striping data or partitioning. And as Kirti said, could be to balance the I/O across multiple disks. Raj "Deshpande, Kirti" rizon.com> cc: Sent by: Subject: RE: # of datafiles per tablespace [EMAIL PROTECTED] March 04, 2002 10:33 PM Please respond to ORACLE-L Other than I/O load balancing.. I can't see any other reason. But again, why those tiny 50MB files? Are these on the same disk? I hope not.. If there is no I/O bottleneck issues, I would build just one 700MB file. And then monitor how it works out.. - Kirti -Original Message- Sent: Monday, March 04, 2002 7:23 PM To: Multiple recipients of list ORACLE-L OK, I know we had the debate already but lets have another go at it. Say you got a tablespace, lets call it RBS and its for rollbacks. Now, for what reason would you create a 500M file and 4 50M files for this puppy as opposed to just one file. I just cannot see the reasoning for this at all. None. Natta. Zilch. So educate me please if someone out there knows a legit reason they would do this. Lets assume for the sake of argument that disk size and mount point size is not a limitation. Space available to me on any one mount point is unlimited. ___ Kimberly Smith Portland, OR [EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Deshpande, Kirti INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: # of datafiles per tablespace
Do you know of a web site where I could research particular thought on? I have not seen anything like that in my research. Thanks. -Original Message- [EMAIL PROTECTED] Sent: Monday, March 04, 2002 8:53 PM To: Multiple recipients of list ORACLE-L In a UNIX system it is better to have more small size datafiles than a few or one large datafile: The reason is that UNIX aquires an exclusive file write lock and therefore if you use multiple files you will avoid a situation where multiple simultaneous writes to data files become serialized and consequently reduce I/O performance: For example instead of one 2GB Data file , split it into 8 250mb: By the way I am addressing OLTP type systems with this e-mail -- 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: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Number / 0
Pardon my expression, but Why in the world are you dividing by zero? Raj __ Rajendra Jamadagni MIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *2 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. *2
Re[2]: Secret maximum for INITRANS?
Yes, and that's exactly what I was suspecting. Thanks for the quick confirmation. -rje KG> I guess you are looking in 'itc' in block dumps which shows the KG> ITL Count. KG> And yes.. There is an upper bound for number of ITLs based on the KG> block size. The transaction slots (and other headers) can not use KG> the more than 50% of the space available for data in the data KG> block. Each ITL will take 24 bytes of space in variable header KG> part of the data block. KG> In 2K block (2048) 50 % is 1024 Bytes. In this we can not use the KG> first 48 bytes (fixed headers in cache layer and TX data layers KG> uses them. So the space available for ITLs will be 976 bytes. KG> So you can get round (976/24) ~41 ITL slots for 2K block size. If KG> you set INITRANS more than 41 they are simply ignored and only 41 KG> ITLS are created in that block. RE> I'm still messing with my enqueue waits on an insert. I'm now able to RE> recreate it on a test database by throwing enough simultaneous inserts RE> at my table. I was going to make sure which of the tables/indexes was RE> actually causing the waits by individually raising the INITRANS above RE> what they would naturally expand to, and see how the waiting sessions RE> responded. RE> I was hitting it with 50 simultaneous inserts and usually had 10 RE> sessions go into an enqueue wait until the 40 sessions committed or RE> rolled back. So I was going though the indexes and then tables RE> raising the INITRANS to 50 to see which one(s) made a difference. RE> None of them made a difference. RE> So I dumped blocks that had been populated only during this exercise. RE> Invariably, there were 0x29 Itl slots. Is there something out there RE> that would limit the Itl entries to 41 even when MAXTRANS=255? Is RE> there some secret bound based on block size? Ours is 2k (which I RE> figure is part of the problem). RE> Other vital stats: 8.0.5 on Solaris 2.7. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robert Eskridge INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Secret maximum for INITRANS?
I've found the note. It wasn't what I remembered, it was worse. I've just re-run a test on 9.0.1.2 that shows an interesting issue: create table t1 (n1 number, v1 varchar2(10)); create index i1 on t1(n1) pctfree 0 initrans 10; insert into t1 select rownum,'x' from all_objects where rownum <= 3000; validate index i1; select leaf_blk_len from index_stats; This shows leaf_blk_len = 3904 on my 4K blocks - follow this with a block dump, and you find that the ITL has a total length of 2 on leaf blocks, despite the demand for initrans 10. alter index rebuild; validate index i1; select leaf_blk_len from index_stats; This shows leaf_blk_len = 3712 on my 4K blocks - follow this with a block dump, and you find that the ITL has a total length of 10 as required. Comment: don't expect INITRANS to be obeyed if you do an array insert into an empty table until you have proved that it is actually obeyed. There are no doubt more tests you could do to pursue this one and find out exactly when things go wrong. My starting assumption is that it only goes wrong on a new, or truncated, table. Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: [EMAIL PROTECTED] <[EMAIL PROTECTED]> Date: 05 March 2002 08:26 | |Nice to know the actual strategy. | |I came across an oddity some time ago |when trying to work this one out by setting |silly values for INITRANS. This would be |(correctly) ignored on a 'create index', and |then obeyed on a 'rebuild index' with the |result that the index got bigger. I think |it was 8.1.5 - it doesn't reproduce in 8.1.7.3 | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: # of datafiles per tablespace
Not using the RBS tablespace as the tablespace of discussion because it has special requirements and can create a lot of discussion. I can fore see a reason for using multiple datafiles in a tablespace. Lets say that you have a large table than contains information based on dates. you load the table with data each year and at the years end you resize the datafile to eliminate the unused space. Then you create another datafile for the tablespace to use for the next years data and load the data for the new year. The new data is still part of the same table and tablespace but in a separate datafile. It could be a method of creating partitions when you can't afford the option or it is not available to you (pre 8). Then you would eliminate some of the bottlenecks with the IO to the drives if the datafiles are on different drives. The users would see an improvement in response time if the were querying different date based data. Also the multiple datafile concept could be used during the backup/restore process. The user could have limits to the max tape size available but still want to backup the database. I know that it could take a lot of tapes to backup a 70GIG database when your tape machine has a 2GIG limit on the tape capacity. They do still exist. ROR mª¿ªm >>> [EMAIL PROTECTED] 03/04/02 09:28PM >>> no reason. I can see creating multiple files under those conditions only because you want to keep files to a specific size. Now, I did once find that the rollback datafiles were a bottleneck on a system I had. So we built TWO rollback tablespaces, with datafiles on different mount points etc and the rollback segments divided between the two tablespaces. cleared up that bottleneck like a dream other than that though.. why? --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > OK, I know we had the debate already but lets have another go at it. > > Say you got a tablespace, lets call it RBS and its for rollbacks. > Now, for what reason would you create a 500M file and 4 50M files > for this puppy as opposed to just one file. I just cannot see the > reasoning > for this at all. None. Natta. Zilch. > > So educate me please if someone out there knows a legit reason they > would do this. > > Lets assume for the sake of argument that disk size and mount point > size is not a limitation. Space available to me on any one mount > point > is unlimited. > > ___ > Kimberly Smith > Portland, OR > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the H ELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ron Rogers INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: # of datafiles per tablespace
Hi Kathy, The only thing I can think of for your original question is a bad guess on the file size. They guessed 500 mb, ran out of file space, added a 50 mb file to the Tablespace, ran out again added 50 mb again. never ran out again. Reading other dba's minds is so much fun :-) John [EMAIL PROTECTED] wrote: That being said is there anything wrong with having one 4G datafile for a tablespace. I personally cannot think of any. Therewere the days when 2G was the limit but that sure isn't the caseanymore. The only thing I can think of is for backups. However, I am alwaysgoing to backup on at least the tablespace level so if I haveone file or multiple files I still need to get them all. I don'tknow if RMAN has some special feature that turns out it makes senseto backup just one data file of a tablespace that has multipledata files but I sure can't think of any good reason.I just randomly picked RBS but I am seeing the same case ondata tablespaces as well.-Original Message-CarmichaelSent: Monday, March 04, 2002 6:29 PMTo: Multiple recipients of list ORACLE-Lno reason. I can see creating multiple files under those conditionsonly because you want to keep files to a specif ic size.Now, I did once find that the rollback datafiles were a bottleneck on asystem I had. So we built TWO rollback tablespaces, with datafiles ondifferent mount points etc and the rollback segments divided betweenthe two tablespaces.cleared up that bottleneck like a dreamother than that though.. why?--- Kimberly Smith <[EMAIL PROTECTED]> wrote: OK, I know we had the debate already but lets have another go at it.Say you got a tablespace, lets call it RBS and its for rollbacks.Now, for what reason would you create a 500M file and 4 50M filesfor this puppy as opposed to just one file. I just cannot see thereasoningfor this at all. None. Natta. Zilch.So educate me please if someone out there knows a legit reason theywould do this.Lets assume for the sake of argument that disk size and mount pointsize is not a limitation. Space available to me on any one mountpointis unlimited.___Kimberly SmithPortland, OR[EMAIL PROTECTED]-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Kimberly Smith INET: [EMAIL PROTECTED]Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051San Diego, California-- Public Internet access / MailingListsTo 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). __Do You Yahoo!?Yahoo! Sports - sign up for Fantasy Baseballhttp://sports.yahoo.com
RE: EXTENTS?
yowch! that tickles --- "Farnsworth, Dave" <[EMAIL PROTECTED]> wrote: > >-someone shoot me > > Bang!! As the dart with the suction cup firmly attaches to Rachel's > forehead. > > ;o) > > -Original Message- > Sent: Monday, March 04, 2002 8:23 PM > To: Multiple recipients of list ORACLE-L > > > sigh... > > someone shoot me. I am spending WAY too much time being unemployed > these days. > > extents are made up of blocks. > > now I'll shut up before I embarrass myself anymore :) > > Rachel > > > --- [EMAIL PROTECTED] wrote: > > > and I was off as well, if your extent size is less than the > > blocksize > > > then you can have more than one extent in a block (divide the > block > > > size by the extent size and round DOWN) > > > > Huh? > > > > Jared > > > > > > > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > > Sent by: [EMAIL PROTECTED] > > 03/04/02 12:13 PM > > Please respond to ORACLE-L > > > > > > To: Multiple recipients of list ORACLE-L > > <[EMAIL PROTECTED]> > > cc: > > Subject:RE: EXTENTS? > > > > > > nick, you're thinking segments not extents. > > > > and I was off as well, if your extent size is less than the > blocksize > > then you can have more than one extent in a block (divide the block > > size by the extent size and round DOWN) > > > > in general though, extents are not usually sized as small as the > > database block size > > > > > > --- Nick Wagner <[EMAIL PROTECTED]> wrote: > > > I'm going to say 1. I don't think you can have multiple tables in > > the > > > same > > > DB block. > > > > > > -Original Message- > > > Sent: Monday, March 04, 2002 10:19 AM > > > To: Multiple recipients of list ORACLE-L > > > > > > > > > Hi > > > If DB block size is 8k then how many extents in one db block? > > > Thanks > > > -Seema > > > > > > > > > > > > _ > > > Join the world's largest e-mail service with MSN Hotmail. > > > http://www.hotmail.com > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Seema Singh > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) > 538-5051 > > > San Diego, California-- Public Internet access / Mailing > > > Lists > > > > > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and > in > > > the message BODY, include a line containing: UNSUB ORACLE-L > > > (or the name of mailing list you want to be removed from). You > may > > > also send the HELP command for other information (like > > subscribing). > > > > > > > > > __ > > Do You Yahoo!? > > Yahoo! Sports - sign up for Fantasy Baseball > > http://sports.yahoo.com > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Rachel Carmichael > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > > > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > __ > Do You Yahoo!? > Yahoo! Sports - sign up for Fantasy Baseball > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED
RE: # of datafiles per tablespace
I use 10gb datafiles for a 1tb db and also back up using Legato. Thinking about using Rman :) >>> [EMAIL PROTECTED] 03/05/02 03:18AM >>> We use 4Gb datafiles here as the norm without any problems at all and those datafiles are all backed up with Legato. No problems whatsoever. Lee -Original Message- Sent: 05 March 2002 03:33 To: Multiple recipients of list ORACLE-L That being said is there anything wrong with having one 4G data file for a tablespace. I personally cannot think of any. There were the days when 2G was the limit but that sure isn't the case anymore. The only thing I can think of is for backups. However, I am always going to backup on at least the tablespace level so if I have one file or multiple files I still need to get them all. I don't know if RMAN has some special feature that turns out it makes sense to backup just one data file of a tablespace that has multiple data files but I sure can't think of any good reason. I just randomly picked RBS but I am seeing the same case on data tablespaces as well. -Original Message- Carmichael Sent: Monday, March 04, 2002 6:29 PM To: Multiple recipients of list ORACLE-L no reason. I can see creating multiple files under those conditions only because you want to keep files to a specific size. Now, I did once find that the rollback datafiles were a bottleneck on a system I had. So we built TWO rollback tablespaces, with datafiles on different mount points etc and the rollback segments divided between the two tablespaces. cleared up that bottleneck like a dream other than that though.. why? --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > OK, I know we had the debate already but lets have another go at it. > > Say you got a tablespace, lets call it RBS and its for rollbacks. > Now, for what reason would you create a 500M file and 4 50M files > for this puppy as opposed to just one file. I just cannot see the > reasoning > for this at all. None. Natta. Zilch. > > So educate me please if someone out there knows a legit reason they > would do this. > > Lets assume for the sake of argument that disk size and mount point > size is not a limitation. Space available to me on any one mount > point > is unlimited. > > ___ > Kimberly Smith > Portland, OR > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please
RE: LIKE and % operator
I would try select * from sonusrpt where upper(subject) like '%GENERAL%'; Might be a case issue w/ subject - if the word is General as you state above, you are searching for general below. Good Luck -Original Message- Sent: Monday, March 04, 2002 3:33 PM To: Multiple recipients of list ORACLE-L I am running oracle8i on solaris8. I have a word ( General ) in my column named "subject", I try to run SQL using LIKE and % to grep any data having the word ( General ) but it displayed no rows selected. Does someone have any idea why? Below is my SQL I used. SQL> select * from sonusrpt where subject like '%general%'; no rows selected. Thanks, David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nguyen, David M INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Michael Cupp INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: EXTENTS?
>-someone shoot me Bang!! As the dart with the suction cup firmly attaches to Rachel's forehead. ;o) -Original Message- Sent: Monday, March 04, 2002 8:23 PM To: Multiple recipients of list ORACLE-L sigh... someone shoot me. I am spending WAY too much time being unemployed these days. extents are made up of blocks. now I'll shut up before I embarrass myself anymore :) Rachel --- [EMAIL PROTECTED] wrote: > > and I was off as well, if your extent size is less than the > blocksize > > then you can have more than one extent in a block (divide the block > > size by the extent size and round DOWN) > > Huh? > > Jared > > > > > > Rachel Carmichael <[EMAIL PROTECTED]> > Sent by: [EMAIL PROTECTED] > 03/04/02 12:13 PM > Please respond to ORACLE-L > > > To: Multiple recipients of list ORACLE-L > <[EMAIL PROTECTED]> > cc: > Subject:RE: EXTENTS? > > > nick, you're thinking segments not extents. > > and I was off as well, if your extent size is less than the blocksize > then you can have more than one extent in a block (divide the block > size by the extent size and round DOWN) > > in general though, extents are not usually sized as small as the > database block size > > > --- Nick Wagner <[EMAIL PROTECTED]> wrote: > > I'm going to say 1. I don't think you can have multiple tables in > the > > same > > DB block. > > > > -Original Message- > > Sent: Monday, March 04, 2002 10:19 AM > > To: Multiple recipients of list ORACLE-L > > > > > > Hi > > If DB block size is 8k then how many extents in one db block? > > Thanks > > -Seema > > > > > > > > _ > > Join the world's largest e-mail service with MSN Hotmail. > > http://www.hotmail.com > > > > -- > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > -- > > Author: Seema Singh > > INET: [EMAIL PROTECTED] > > > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > > San Diego, California-- Public Internet access / Mailing > > Lists > > > > > To REMOVE yourself from this mailing list, send an E-Mail message > > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > > the message BODY, include a line containing: UNSUB ORACLE-L > > (or the name of mailing list you want to be removed from). You may > > also send the HELP command for other information (like > subscribing). > > > > > __ > Do You Yahoo!? > Yahoo! Sports - sign up for Fantasy Baseball > http://sports.yahoo.com > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Rachel Carmichael > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > > > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Farnsworth, Dave INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-505
Error in PRO*C - EXEC ORACLE OPTION (MAXLITERAL=2000)
hello , I am getting a syntax error no PCC-W-02044 ,CMD-LINE,Illegal or out of range value for option for the line below in my program: EXEC ORACLE OPTION (MAXLITERAL=2000) any solution for the same?? thanks. _ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bhavin INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Any Oracle Tool
SQLExpert - Leccotech / Cool-Tools (;p) http://www.cool-tools.co.uk TOAD - Toadsoft / Quest http://www.toadsoft.com SQL Navigator (?) - Quest http://www.quest.com PL/SQL Developer - All Round Automations http://www.allroundautomations.com Rapid SQL - Embarcadero http://www.embarcadero.com ... ... To name a few.. Personally I'd recommend SQLExpert (but I may be a little bias ;P) It gives you a variable/parameter lookup function whilst debugging - no typos! 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: 05 March 2002 10:04 To: Multiple recipients of list ORACLE-L Hi All I am facing a lot of problems in testing Stored Procedures and Functions. I have many functions which requires a lot of parameters to be passed. Even a small mistake make me lot of retype. Again testing everything against requires a lot of testing data. If any good UI is available it makes easier even to taste functions and Enter Data. I ll be very much glad if any information is passed . Thanks in Advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Leith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
AW: Any Oracle Tool
Hi Nadu, We use PLSQL-Developer and TOAD. Both are very nice tools. TOAD you can get free. Here are teh Web-Links. http://www.allroundautomations.nl/plsqldev.html http://www.toadsoft.com/downld.html free version http://www.quest.com/toad/ HTH Volker Schoen E-Mail: mailto:[EMAIL PROTECTED] http://www.inplan.de -Ursprüngliche Nachricht- Von: Nandu Garg [mailto:[EMAIL PROTECTED]] Gesendet: Dienstag, 5. März 2002 11:04 An: Multiple recipients of list ORACLE-L Betreff: Any Oracle Tool Hi All I am facing a lot of problems in testing Stored Procedures and Functions. I have many functions which requires a lot of parameters to be passed. Even a small mistake make me lot of retype. Again testing everything against requires a lot of testing data. If any good UI is available it makes easier even to taste functions and Enter Data. I ll be very much glad if any information is passed . Thanks in Advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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).
Any Oracle Tool
Hi All I am facing a lot of problems in testing Stored Procedures and Functions. I have many functions which requires a lot of parameters to be passed. Even a small mistake make me lot of retype. Again testing everything against requires a lot of testing data. If any good UI is available it makes easier even to taste functions and Enter Data. I ll be very much glad if any information is passed . Thanks in Advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Nandu Garg INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Number / 0 (solve)
Hi, Connect sys For the creation of a function-based index in your own schema, you must be granted the CREATE INDEX and QUERY REWRITE system privileges. To create the index in another schema or on another schema's tables, you must have the CREATE ANY INDEX and GLOBAL QUERY REWRITE privileges. You must have the following initialization parameters defined to create a function-based index: QUERY_REWRITE_INTEGRITY must be set to TRUSTED QUERY_REWRITE_ENABLED must be set to TRUE COMPATIBLE must set to 8.1.0.0.0 or a greater value The result : SQL> create index myfindex on emp(income/0); create index myfindex on emp(income/0) * ERROR at line 1: ORA-01476: divisor is equal to zero Sinardy -Original Message- Sent: 05 March 2002 16:38 To: Multiple recipients of list ORACLE-L Hi guys, This is my test: SQL> desc emp Name Null?Type - EMPNO NOT NULL CHAR(3) NAME VARCHAR2(10) INCOME NUMBER(5) SQL> create index no_logic on emp(income); Index created. SQL> drop index no_logic; Index dropped. SQL> create index wrong_logic on emp(income/0); create index wrong_logic on emp(income/0) * ERROR at line 1: ORA-01031: insufficient privileges I don't understand why Oracle throw such exception (reply). Do you have any idea what is Oracle doing when Oracle find out number / 0 Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Names server
Works nicely for us. It was a bit flakey before we had a region database, but is rock solid now. I installed OID for a 'play' recently, and after considerable pain I finally got the GUI running, only to find that what was on the screen made absolutely no sense to me whatsoever. RTFM'ing had a similar effect. -- David Lord -Original Message- Sent: 04 March 2002 19:33 To: Multiple recipients of list ORACLE-L Hi ALL: Is any one using names server out there? How the it works? Any infor are wellcome. ** This message (including any attachments) is confidential and may be legally privileged. If you are not the intended recipient, you should not disclose, copy or use any part of it - please delete all copies immediately and notify the Hays Group Email Helpdesk at [EMAIL PROTECTED] Any information, statements or opinions contained in this message (including any attachments) are given by the author. They are not given on behalf of Hays unless subsequently confirmed by an individual other than the author who is duly authorised to represent Hays. A member of the Hays plc group of companies. Hays plc is registered in England and Wales number 2150950. Registered Office Hays House Millmead Guildford Surrey GU2 4HJ. ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lord, David - CSG INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Clash of the DBs in eWeek
- Original Message - > > I have also an other question. > Do you you why they did not test postgressql ? > I bet they failed to run it on NT (not a trivial task) Marin "...what you brought from your past, is of no use in your present. When you must choose a new path, do not bring old experiences with you. Those who strike out afresh, but who attempt to retain a little of the old life, end up torn apart by their own memories. " -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Marin Dimitrov INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Secret maximum for INITRANS?
Nice to know the actual strategy. I came across an oddity some time ago when trying to work this one out by setting silly values for INITRANS. This would be (correctly) ignored on a 'create index', and then obeyed on a 'rebuild index' with the result that the index got bigger. I think it was 8.1.5 - it doesn't reproduce in 8.1.7.3 Jonathan Lewis http://www.jlcomp.demon.co.uk Now running 3-day intensive seminars http://www.jlcomp.demon.co.uk/seminar.html Host to The Co-Operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.html Author of: Practical Oracle 8i: Building Efficient Databases -Original Message- To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> Date: 05 March 2002 03:05 | |And yes.. There is an upper bound for number of ITLs based on the block |size. |The transaction slots (and other headers) can not use the more than 50% of |the |space available for data in the data block. Each ITL will take 24 bytes of |space |in variable header part of the data block. | -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jonathan Lewis INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: # of datafiles per tablespace
We use 4Gb datafiles here as the norm without any problems at all and those datafiles are all backed up with Legato. No problems whatsoever. Lee -Original Message- Sent: 05 March 2002 03:33 To: Multiple recipients of list ORACLE-L That being said is there anything wrong with having one 4G data file for a tablespace. I personally cannot think of any. There were the days when 2G was the limit but that sure isn't the case anymore. The only thing I can think of is for backups. However, I am always going to backup on at least the tablespace level so if I have one file or multiple files I still need to get them all. I don't know if RMAN has some special feature that turns out it makes sense to backup just one data file of a tablespace that has multiple data files but I sure can't think of any good reason. I just randomly picked RBS but I am seeing the same case on data tablespaces as well. -Original Message- Carmichael Sent: Monday, March 04, 2002 6:29 PM To: Multiple recipients of list ORACLE-L no reason. I can see creating multiple files under those conditions only because you want to keep files to a specific size. Now, I did once find that the rollback datafiles were a bottleneck on a system I had. So we built TWO rollback tablespaces, with datafiles on different mount points etc and the rollback segments divided between the two tablespaces. cleared up that bottleneck like a dream other than that though.. why? --- Kimberly Smith <[EMAIL PROTECTED]> wrote: > OK, I know we had the debate already but lets have another go at it. > > Say you got a tablespace, lets call it RBS and its for rollbacks. > Now, for what reason would you create a 500M file and 4 50M files > for this puppy as opposed to just one file. I just cannot see the > reasoning > for this at all. None. Natta. Zilch. > > So educate me please if someone out there knows a legit reason they > would do this. > > Lets assume for the sake of argument that disk size and mount point > size is not a limitation. Space available to me on any one mount > point > is unlimited. > > ___ > Kimberly Smith > Portland, OR > [EMAIL PROTECTED] > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.com > -- > Author: Kimberly Smith > INET: [EMAIL PROTECTED] > > Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 > San Diego, California-- Public Internet access / Mailing > Lists > > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). __ Do You Yahoo!? Yahoo! Sports - sign up for Fantasy Baseball http://sports.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kimberly Smith INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). The information contained in this communication is confidential, is intended only for the use of the recipient named above, and may be legally privileged. If the reader of this message is not the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please re-send this communication to the sender and delete the original message or any copy of it from your computer system. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Robertson Lee - lerobe INET: [EMAIL PROTECTED] Fat City Network Services-- (
Number / 0
Hi guys, This is my test: SQL> desc emp Name Null?Type - EMPNO NOT NULL CHAR(3) NAME VARCHAR2(10) INCOME NUMBER(5) SQL> create index no_logic on emp(income); Index created. SQL> drop index no_logic; Index dropped. SQL> create index wrong_logic on emp(income/0); create index wrong_logic on emp(income/0) * ERROR at line 1: ORA-01031: insufficient privileges I don't understand why Oracle throw such exception (reply). Do you have any idea what is Oracle doing when Oracle find out number / 0 Sinardy -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Sinard Xing INET: [EMAIL PROTECTED] Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051 San Diego, California-- Public Internet access / Mailing Lists To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
