Re: image storage confusion ??
Not to mention, backups can take a REALLY long time, unless you backup the raw volume image, in which case you can only restore at the filesystem level. On Tue, 2002-12-03 at 14:44, Connor McDonald wrote: Exactly. We had a system that used to drag emails (from qmail so each mail was a file) into clobs in the database. After a year or so we had about 15 million emails in the database - no problems at all. Then one day the some idiot (aka me) put a new version of the program in which successfully loaded the clob but (to cut a long story short) started replicating the email files left, right and centre...It took literally days to clean up millions of (zero byte size) files...after which point that file system needed to be rebuilt anyway, the directory structure was in such a mess Cheers Connor --- [EMAIL PROTECTED] wrote: Arup, What Connor may have been referring to is the inefficiency of managing 20 million files in a filesystem. That's a lot of inodes ( assuming unix ). It's a bit much for a filesystem to deal with. Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 07:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: image storage confusion ?? Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego,
RE: image storage confusion ?? -- UUDECODE
As Cary as mentioned, there's some new goodies in v9. In our case, the controlling of attachments etc is done before processing into the db. I can't remember the specifics (read: I'm no longer at that site) but we found some shareware (mimencode? + a few other little things) we separated encoded emails into separate files which then got processed into separate lobs. Cheers Connor --- MacGregor, Ian A. [EMAIL PROTECTED] wrote: Were doing the same thing with mail between collaborators on one of our physics projects. But the volume is small, just unDer 250,000 so far. Did the mail ou were saving contain attachments, and if so did you write any code to break off the attachment uudecode it and place it in a blob? If so, I am keenly interested in that code. Is there a publicly available package to do uuencode and uudecode? Ian MacGregor Stanford Linear Accelerator Center [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 11:44 AM To: Multiple recipients of list ORACLE-L Exactly. We had a system that used to drag emails (from qmail so each mail was a file) into clobs in the database. After a year or so we had about 15 million emails in the database - no problems at all. Then one day the some idiot (aka me) put a new version of the program in which successfully loaded the clob but (to cut a long story short) started replicating the email files left, right and centre...It took literally days to clean up millions of (zero byte size) files...after which point that file system needed to be rebuilt anyway, the directory structure was in such a mess Cheers Connor --- [EMAIL PROTECTED] wrote: Arup, What Connor may have been referring to is the inefficiency of managing 20 million files in a filesystem. That's a lot of inodes ( assuming unix ). It's a bit much for a filesystem to deal with. Jared Arup Nanda [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 07:14 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: image storage confusion ?? Connor, I seem to think otherwise. Storing 100 GB of image is not necessarily a pretty proposition either when you consider hot backups and archived log generation, etc. I presume you are concerned about the management of the image files considering the sheer volume of it. But that's precisely what BFILE is expected to help with. The images are in a file ssytem and the pointers are in the database and that's managed pretty well. However I do concede tht this might pose a problem on two fronts - (1) Security - beign on filesystem anyone can potentially see these. However this is not necesarily a concern at all sites. Good OS security can prevent this. (2) Backup - the ssy admin has to explicitly backup all these files. This, again, may not be that bad when you store your files on a single filesystem and a backup software can be easily programmed to check only the changed files, based on timestamp. Just my two cents. Arup Nanda - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 7:39 AM Managing 20mil of anything (images/text/etc) in a file system isn't a nice proposition. Go with the database hth connor --- oraora oraora [EMAIL PROTECTED] wrote: Guys , i posted this already and this time my question is a bit different . I have to store 20,000,000 images of 5k each either in DB ( on win2k) or linux o/s file system. the images are to be displayed over mobile phones.so the time to retrieve the images should be minimum. for this to be achieved , i am confused , whether the images should be stored in o/s file system or in the DB ? --selecting a file from linux o/s file system --- or --querying it from oracle DB ( on win2k) --- which of the above will be faster ? all these will be done with java . this being condition , i would like to know ur suggestion guys. my DB is oracle 8.1.6 on Win2k. TIA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: oraora oraora INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line
RE: ORA-1653: unable to extend table - Why?
Hmm...not sure if this is what's biting you, but if you're out of ITL slots on the block, Oracle will move to the next block on the free list. If all the blocks on the free list have filled ITLs, Oracle will add an extent to the free list. I don't suppose you have MAXTRANS set to 1 or some other very low number? If so, and with concurrent inserts happening, it's possible that you could be allocating more blocks to the free list, even if there are tons of blocks already on the free list, simply due to the ITL shortage. (Note that this is why you'll never see mode 4 TX enqueue waits on insert to a table.) If MAXTRANS isn't really low, and if you're not doing direct-load (APPEND hint) inserts, then I'm stumped. -Mark On Tue, 2002-12-03 at 17:09, Fink, Dan wrote: Hmm...Why didn't they ask for your buffer cache hit ratio? Seriously, I've pondered this and it comes down to a question. What would cause a transaction not to use blocks on the freelist? If a transaction cannot use these blocks, then it must allocate new space. If the transaction is set up so as to allocate space above the HWM, we have the same scenario. Are there transactions that are allocating blocks off the freelist? How deep will a transaction read the freelist to find an open block before giving up and allocating space? Are the inserts of such size that they would not fit into the space in the blocks on the freelist? I don't know the answers, but it seems that the questions may offer some clues. I can't wait to find out the real answer! -Original Message- Sent: Tuesday, December 03, 2002 1:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can
RE: SLA Trigger/Procedure
Mark, I didn't mean to turn this in to a tool discussion, I merely tried to point out the down side to the original idea, due to not *fully* checking availability, by showing what tools typically do. Sorry Mark -Original Message- Richard Sent: 03 December 2002 21:45 To: Multiple recipients of list ORACLE-L Kirti, Nice script for checking availability. May I remind everyone that you get an additional free check by running this on a different physical host - you are then checking physical host availability and at least some degree of network connectivity as well. I still think my original suggestion has some merit - Ethan was talking about some functionality to indicate service levels and track uptime/downtime, whereas we seem to have steered the discussion into a database availability monitoring tool. Still, it's been a good discussion with a lot of valid comments by everyone involved. Deshpande, Kirti kirti.deshpande@ve To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] rizon.comcc: Sent by: Subject: RE: SLA Trigger/Procedure [EMAIL PROTECTED] 04/12/2002 03:59 Please respond to ORACLE-L Tool? I have a tool. Want to buy? ;) It's a simple script that connects (actually attempts to connect with a fake id/pw) to the target DB (on Windows, HP-Alpha/VMS, UNIX) over Oracle Net. Scans for the ORA- errors and we know if the DB is accessible or not, as well as if Listener is responding. No need for any 'special' ids to run 'select stuff from dual', which in itself can be expensive (depending on the DB version). I think I had posted this script a few times before. Here it is again. Customize it to suit you requirements to send page/emails/update table etc...: (btw -- Steve Adams has an elaborate version that checks for a few more things. Check his web site) #!/usr/bin/ksh # # dbcheck : Script to check if database is up and accessible # # Author : Kirti Deshpande #--- echo Enter Name of the Database SID to check if it is accessible read DB sqlplus -s EOF /tmp/$$.1 whenever sqlerror exit aaa/aaa@$DB exit; EOF egrep 'ORA-121|ORA-01034' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is _NOT_ Accessible\n else grep 'ORA-01017' /tmp/$$.1 /dev/null if [[ $? = 0 ]] then echo - '$DB' is UP and Accessible\n else echo - '$DB' is _NOT_ Accessible\n fi fi rm /tmp/$$.1 # --- End of File - Kirti -Original Message- Sent: Tuesday, December 03, 2002 4:14 AM To: Multiple recipients of list ORACLE-L Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) 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- Richard Sent: 03 December 2002 02:14 To: Multiple recipients of list ORACLE-L Perhaps there is a poor mans way of doing this. The startup trigger could fire a procedure that inserts a row into a table and then sleeps for 1 minute before doing the same again. Effectively it would create a ping in the table, which you could then analyze / graph to display uptimes. The next logical step would be to increase the intelligence of the procedure. The table storing the statistic could consist of two columns - uptime and downtime. When the startup trigger fires it creates a new row in the table with both uptime and downtime set to sysdate. It then sleeps for a minute before updating downtime for the most recent record (either remember a primary key or search
OT: Toasters
As a bit of light relief John Carry on til the end for the SAP toaster If IBM made toasters ... They would want one big toaster where people bring bread to be submitted for overnight toasting. IBM would claim a worldwide market for five, maybe six toasters. If Xerox made toasters ... You could toast one-sided or double-sided. Successive slices would get lighter and lighter. The toaster would jam your bread for you. If Radio Shack made toasters ... The staff would sell you a toaster, but not know anything about it. Or you could buy all the parts to build your own toaster. If Oracle made toasters ... They'd claim their toaster was compatible with all brands and styles of bread, but when you got it home you'd discover the Bagel Engine was still in development, the Croissant Extension was three years away, and that indeed the whole appliance was just blowing smoke. If Sun made toasters ... The toast would burn often, but you could get a really good cuppa Java. Does DEC still make toasters?... They made good toasters in the '80s, didn't they? If Hewlett-Packard made toasters ... They would market the Reverse Toaster, which takes in toast and gives you regular bread. If Tandem made toasters ... You could make toast 24 hours a day, and if a piece got burned the toaster would automatically toast you a new one. If Thinking Machines made toasters ... You would be able to toast 64,000 pieces of bread at the same time. If Cray made toasters ... They would cost $16 million but would be faster than any other single-slice toaster in the world. If the NSA made toasters ... Your toaster would have a secret trap door that only the NSA could access in case they needed to get at your toast for reasons of national security. If Sony made toasters ... The ToastMan, which would be barely larger than the single piece of bread it is meant to toast, can be conveniently attached to your belt. If Timex made toasters ... They would be cheap and small quartz-crystal wrist toasters that take a licking and keep on toasting. If Fisher Price made toasters ... Baby's First Toaster would have a hand-crank that you turn to toast the bread that pops up like a Jack-in-the-box. And, of course: If Microsoft made toasters ... Every time you bought a loaf of bread, you would have to buy a toaster. You wouldn't have to take the toaster, but you'd still have to pay for it anyway. Toaster'95 would weigh 15000 pounds (hence requiring a reinforced steel countertop), draw enough electricity to power a small city, take up 95% of the space in your kitchen, would claim to be the first toaster that lets you control how light or dark you want your toast to be, and would secretly interrogate your other appliances to find out who made them. Everyone would hate Microsoft toasters, but nonetheless would buy them since most of the good bread only works with their toasters. If Apple made toasters ... It would do everything the Microsoft toaster does, but 5 years earlier. If SAP made toasters, the manual to run the toaster would be approximately 10,000 pages long. The toaster would come with 2,500 switches which would all have to be set in an exact pattern and in a precise sequence in order to toast specific kinds of bread. Each pattern would be established by SAP's experts as the Best Practices method of toasting that kind of bread. It would take a team of basis and functional contractors about 1 year to configure the toaster in the best manner, and then another 6 months to test it. In the mean time, your entire family would need to attend extensive training classes on how to use the new toaster. In order to support end users and consultants, MIT would establish a list-serv for people to post questions and answers regarding toaster set-up and operation. Of course, the online help would randomly pop up in German. But once it was running, you'd get the best toast in the world. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: oracle precompiler in O 9.2
thank you very much for the reply. now my problem seems to be that I didn't install appropriately - but I couldn't find any hint on metalink. find a short summary of my situation - actually the same on linux or SunOS9: === $sqlplus / as sysdba SQL*Plus: Release 9.2.0.1.0 - Production on Mi Dez 4 10:51:48 2002 Copyright (c) 1982, 2002, Oracle Corporation. All rights reserved. Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.1.0 - 64bit Production With the Partitioning, OLAP and Oracle Data Mining options JServer Release 9.2.0.1.0 - Production co-db oracle 9.2.0.1.0 ~/product/9.2.0.1.0 $ which proc no proc in /usr/ccs/bin /usr/bin etc /usr/openwin/bin . /u01/product/9.2.0.1.0/bin /u01/bin . /usr/local/bin $ pwd /u01/product/9.2.0.1.0 $ echo $ORACLE_HOME /u01/product/9.2.0.1.0 co-db oracle 9.2.0.1.0 ~/product/9.2.0.1.0 $ find . -name proc ./inventory/filemap/rdbms/demo/lobs/proc ./rdbms/demo/lobs/proc co-db oracle 9.2.0.1.0 ~/product/9.2.0.1.0 === hope this sheds some light on my problem. thank you in advance for furhter hints kr [EMAIL PROTECTED] 12/03/02 17:20 PM SQL exit Disconnected from Oracle9i Enterprise Edition Release 9.2.0.2.0 - 64bit Production With the Partitioning, Real Application Clusters, OLAP and Oracle Data Mining options JServer Release 9.2.0.2.0 - Production oraclei@elara-ABC1 oraclei@elara-ABC1 which proc /usr/opt/oracle/current/bin/proc 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! -Original Message- Sent: Tuesday, December 03, 2002 5:44 AM To: Multiple recipients of list ORACLE-L hello to everybody I'm desperately looking for precompiler e.g. proc in the installation of O 9.2. can't find libproc2.a is the message when I try do creat. doesn't seem to be an installation issue, because no kind of installation offers the(se) file(s). precompilers did exist in 9.0.1 - but they don't exist any more in 9.2.0 neither SunOS nor LINUX. has anybody any idea? thanks in advance -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Markus Reger INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Import Table from Full Backup
I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Sr. Oracle DBA Position- Must be 8i and 9i Certified-
Title: RE: Sr. Oracle DBA Position- Must be 8i and 9i Certified- You can also register with the Boston Globe to get an e-mail listing Oracle job ads in the Boston area. I use it as a gauge of how well things are going in the market south of the border. At one point there were a dozen or more Oracle positions (about a year and half ago), about3 -6 months ago I actually received some blank e-mails, things seem to be picking up a bit again, I am seeing 4 - 6 per e-mail now. 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-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Tuesday, December 03, 2002 7:45 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Sr. Oracle DBA Position- Must be 8i and 9i Certified- Does a 24x7 DB demand a higher salary than a 9am-5pm DB? -Original Message- From: OraStaff [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Subject: Sr. Oracle DBA Position- Must be 8i and 9i Certified- Great opportunity for a Sr. Oracle DBA with 8i AND 9i certification to join this software industry leader in Charlotte, North Carolina. Base salary is in the 90-120K range and depends on experience. Relocation Assistance is provided. PLEASE Do Not send your resume for this position UNLESS you have the skills outlined below for this position. Please Do Not send your resume unless you have a stable work history. Candidates whose work history includes frequent job changes connot be considered. If you are employed by a consulting company you must have a long term project history. This is a full time staff position so no sub-contractors or third parties please. NO H-1B candidates please. Interested candidates will be required to complete a company questionnaire that must be submitted with the resume. *Description of duties: Production support of operations required to maintain 7x24 database/application availability. Logical Design and Physical Design in support of Production/Development Database operations and support in Solaris/Linux ORACLE 8i/9i environment. Essential Functions: Backup/recovery, RMAN, Performance tuning, Shell scripting in Korn and Bourne Shells. ORACLE Internet Directory, ORACLE Enterprise Manager, development/documentation of standards and procedures. ORACLE DBA duties to include user management data exports and imports, writing ORACLE scripts, general monitoring of system performance. Assisting users with SQL and PL/SQL needs in day-to-day operations and implementation of logical designs. * Requirements: -Oracle 8i and 9i Certification -7+Years in IT -5+ years of Production Oracle DBA experience..including 8i and 9i -Knowledge of OPS/RAC, OEM -Proficient with SQL, PL/SQL, unix shell scritping -Expert understanding of Oracle architecture -Full understanding of Database concepts -Knowledge of relational database design -Must be a Self-starter. For immediate consideration, please email your resume as an attachment to: OraStaff, Inc. Email: [EMAIL PROTECTED] Phone: 1-800-549-8502. Please Use Job Code: One/Charlotte/Certified DBA/Carol We pay referral fees. So please contact me if you know of anyone who would be qualified/interested in the positiondescribed above- if it is not a match for your skills. Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: OraStaff INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: move some records of some tables
Hello Murat Export has a parameter Query that allow you to specify selection criteria for exporting a subset of records from the table. Import also has parameter Ignore=y and then the import ignore the error of the create table statement and append the imported records into an existing table. So you can export the selected records only from your tables and import them to the seconds DB. HTH Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Monday, December 02, 2002 1:43 PM Hi, what's the best method to move some rows of some tables of a user from one database to another database on another server? I need a step by step document to achieve this. Thanks, Murat -- Bu e-posta sadece yukarida isimleri belirtilen kisiler arasinda ozel haberlesme amacini tasimaktadir. Size yanlislikla ulasmissa lutfen mesaji geri gonderiniz ve sisteminizden siliniz. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. bu mesajin icerigi ile ilgili olarak hic bir hukuksal sorumlulugu kabul etmez. This e-mail communication is intended for the private use of the persons named above. If you received this message in error, please immediately notify the sender and delete it from your system. Rt.Net Internet Hizmetleri Pazarlama ve Ticaret A.S. does not accept legal responsibility for the contents of this message. -- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: MURAT BALKAS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: ORA-1653: unable to extend table - Why?
I always overlook things, so I'll just ask and hope it isn't already on the thread: Exactly what kind of activity is going on against this wonderful table? Is this table placed in an LMT? If yes, is it a Uniform LMT? Could you trace the processes/users doing stuff to the table so that we could see if there's contention for ITL slots or other such things? Mogens Mark J. Bobak wrote: Hmm...not sure if this is what's biting you, but if you're out of ITL slots on the block, Oracle will move to the next block on the free list. If all the blocks on the free list have filled ITLs, Oracle will add an extent to the free list. I don't suppose you have MAXTRANS set to 1 or some other very low number? If so, and with concurrent inserts happening, it's possible that you could be allocating more blocks to the free list, even if there are tons of blocks already on the free list, simply due to the ITL shortage. (Note that this is why you'll never see mode 4 TX enqueue waits on insert to a table.) If MAXTRANS isn't really low, and if you're not doing direct-load (APPEND hint) inserts, then I'm stumped. -Mark On Tue, 2002-12-03 at 17:09, Fink, Dan wrote: Hmm...Why didn't they ask for your buffer cache hit ratio? Seriously, I've pondered this and it comes down to a question. What would cause a transaction not to use blocks on the freelist? If a transaction cannot use these blocks, then it must allocate new space. If the transaction is set up so as to allocate space above the HWM, we have the same scenario. Are there transactions that are allocating blocks off the freelist? How deep will a transaction read the freelist to find an open block before giving up and allocating space? Are the inserts of such size that they would not fit into the space in the blocks on the freelist? I don't know the answers, but it seems that the questions may offer some clues. I can't wait to find out the real answer! -Original Message- Sent: Tuesday, December 03, 2002 1:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay
RE: Help with Java
Alex - And the funny part is that the person who nailed the solution, Steve Ollig, also works for us and isn't a part of our official Java initiative. Do you think he'll ever get good enough to be sent to Java training? -Original Message- Sent: Tuesday, December 03, 2002 4:20 PM To: Multiple recipients of list ORACLE-L My condolences to you. On Tue, 3 Dec 2002, DENNIS WILLIAMS wrote: John - I forwarded your message to one of our newly-trained Java programmers. He replied with: The code is incomplete, how are they handling the connection. Obviously the while loops are messing each other up. There are multiple ways of handling this. If I see the complete code I can be more specific. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Tuesday, December 03, 2002 12:25 PM To: Multiple recipients of list ORACLE-L All, I am beginning the journey into JAVA and have hit an odd behavior (well, probably not, but I can't see any reason for it). I am building a list of tablespaces and the datafiles that belong to them. The open to the database is working fine. When I use: ResultSet myTablespaces = myStatement.executeQuery( SELECT tablespace_name + FROM dba_tablespaces + WHERE contents = 'PERMANENT' ); while (myTablespaces.next()) { // retrieve the user from the row in the ResultSet using the // getString() method ct = ct + 1; String tablespace = myTablespaces.getString(1); System.out.println(Tablespace + ct + is: + tablespace); } myTablespace.close(); I am generating a list of tablespaces and the output is as expected. When I add a second result set, the first datafile of the first tablespace returns and then the program completes: ResultSet myTablespaces = myStatement.executeQuery( SELECT tablespace_name + FROM dba_tablespaces + WHERE contents = 'PERMANENT' ); while (myTablespaces.next()) { // retrieve the user from the row in the ResultSet using the // getString() method ct = ct + 1; String tablespace = myTablespaces.getString(1); System.out.println(Tablespace + ct + is: + tablespace); ResultSet myDataFiles = myStatement.executeQuery( SELECT file_name + FROM dba_data_files + WHERE tablespace_name = ' + tablespace + ' ); while (myDataFiles.next()) { String filename = myDataFiles.getString(1); System.out.println( + filename); } myDataFiles.close(); } myTablespaces.close(); Anybody with some Java experience have any insite? As always, TIA, John P Weatherman Database Administrator Replacements Ltd. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: John Weatherman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alex INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
RE: Import Table from Full Backup
Hi, you can recover a tablespace to a point in time. That's the only option you would have using RMAN. Regards, Mike Hately -Original Message- Sent: 04 December 2002 11:54 To: Multiple recipients of list ORACLE-L I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: SLA Trigger/Procedure
So do a select from a view based on sys.x$dual. That does not have cause LIO. I checked a few months ago. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Tuesday, December 03, 2002 4:32 PM and that select 'PING' from dual is very costly. I believe Gaja, Cary, Anjo, and a few others (who were nice enough to include me on the thread) determined that before 9i Oracle takes about 5 LIOs to do a select anything from dual. I think it went down to either 3 or 4 in 9i but that's still VERY costly. Dan Fink has that discussion summarized on his site: http://www.optimaldba.com/internals/oraint_dual.html Rachel --- Mark Leith [EMAIL PROTECTED] wrote: Yup, got that covered :) If I may add another point. When dealing with SLA's, you not only have to show that the database has been servicing users that are connected (showing database uptime), but also that users can also *connect* to the database as well (the listener is servicing requests). If you were to go about this with a trigger/procedure that inserts in to a table, then this doesn't show that the database was available to everybody. Typically what we do with monitoring tools is a connect on ping, so when we are checking availability of a database we do a full connect, then select 'PING' from dual;. If there are any errors along the way we search for the error code, and deal with the appropriate alerts (TNS = Listener problem, ORA = Database problem). Of course, the problem with doing it this way, is that you are going to have to write platform dependant scripts (batches for NT, shell type scripts for Unix), and not have a one for all with a database based solution. Go buy a tool. Let it write to a table/file, alert you AND make the coffee for when you get there! ;) 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- Richard Sent: 03 December 2002 02:14 To: Multiple recipients of list ORACLE-L Perhaps there is a poor mans way of doing this. The startup trigger could fire a procedure that inserts a row into a table and then sleeps for 1 minute before doing the same again. Effectively it would create a ping in the table, which you could then analyze / graph to display uptimes. The next logical step would be to increase the intelligence of the procedure. The table storing the statistic could consist of two columns - uptime and downtime. When the startup trigger fires it creates a new row in the table with both uptime and downtime set to sysdate. It then sleeps for a minute before updating downtime for the most recent record (either remember a primary key or search for max(uptime)). This would be much easier to understand when the database was stopped / started. Of course depending on your accuracy requirement, granularity could be changed to every 5 minutes, 10 minutes, whatever. Hopefully that gives some ideas though. Of course the 3rd party monitors that Jared mentions are worth considering if the database is considered critical. In that case the number one requirement is probably the ability to page / SMS / email when it sees the database is down. Regards, Mark. Jared.Still@ra disys.comTo: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: Re: SLA Trigger/Procedure om 03/12/2002 12:13 Please respond to ORACLE-L Ethan, That records the startup times, but does not record the time that the database was unavailable. What's needed is a 3rd party monitor that is not dependent on the database being up to record metrics. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 02:33 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:SLA Trigger/Procedure Just a thought here for a script I think would be handy but I haven't had time to write. It is would be a simple procedure you could call to get the service level for a particular database. I suppose you would have to have some sort of way of defining normal outage windows. Basically a startup trigger would log the times in a table. You should also check the startup time
Re: Import Table from Full Backup
In order to use rman to restore a single table you have to restore the tablespace to a clone and then export the table you need and import it to the 'real' database. So yes, it can be done! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 6:53 AM I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ruth Gramolini INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Open Source Security Comes Under Fire
Rodd, Where do you see evidence that Ziff-Davis is owned by Microsoft? The links seem to lead to a UK publishing firm. www.ziffdavis.com -- http://www.willisstein.com/ -- www.emac.com Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, November 27, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Go figure. This was published on a ZiffDavis news site. ZD is either majority or wholly owned by Microsoft. Do you suppose there might be a bit of a slant there? Rodd Holman On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote: Patrice - Amazing how these things happen. A few weeks ago a report listed Microsoft products as among the worst security risks. Microsoft immediately attacked the report. Then by an amazing coincidence, an impartial organization releases a report stating that Microsoft's greatest competitor, the free people, are actually the greatest security risk. Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry hired the private eye to get some proof that they were just shills for Microsoft, and the guy was caught dumpster diving? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 27, 2002 8:24 AM To: Multiple recipients of list ORACLE-L FYI. http://www.eweek.com/article2/0,3959,720533,00.asp http://www.eweek.com/article2/0,3959,720533,00.asp 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Table from Full Backup
Both RMAN and manual methods exist but they're tacky...Basically you create a new database, recover just the appropriate datafiles, export the data and then do what you want with it... hth connor --- Hately, Mike (NESL-IT) [EMAIL PROTECTED] wrote: Hi, you can recover a tablespace to a point in time. That's the only option you would have using RMAN. Regards, Mike Hately -Original Message- Sent: 04 December 2002 11:54 To: Multiple recipients of list ORACLE-L I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Title: RE: Red Buttons is a fine comedian and actor. He won an Academy Award and Golden Globe. Still I can't see how he can HELP in this case. Oh - you said Button not Buttons. Nevermind. Jerry Whittle ASIFICS DBA NCI Information Systems Inc. [EMAIL PROTECTED] 618-622-4145 -Original Message- From: Jeremy Pulcifer [SMTP:[EMAIL PROTECTED]] The answer to your problem: The Red Button. You're welcome! -Original Message- From: Tinu !@#!^% [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 3:29 AM To: Multiple recipients of list ORACLE-L Subject: HELP
RE: Import Table from Full Backup
I'd agree that you can achieve the same result. I think I'd argue that it's not a feature of RMAN though. I can also take that restored table, spool it a text file and edit it using MS Word but I wouldn't claim that RMAN can generate Word files. Mind you, this is probably word class pedantry on my part =) Cheers, Mike -Original Message- Sent: 04 December 2002 13:34 To: Multiple recipients of list ORACLE-L In order to use rman to restore a single table you have to restore the tablespace to a clone and then export the table you need and import it to the 'real' database. So yes, it can be done! Ruth - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Open Source Security Comes Under Fire
David Coursey, one of their Editors/Columnists made the disclaimer some time back when he was comparing different software offerings of some type. He mentioned that MS had some type of ownership in them or their parent company. I don't recall which. Rodd On Wed, 2002-12-04 at 08:03, Boivin, Patrice J wrote: Rodd, Where do you see evidence that Ziff-Davis is owned by Microsoft? The links seem to lead to a UK publishing firm. www.ziffdavis.com -- http://www.willisstein.com/ -- www.emac.com Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, November 27, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Go figure. This was published on a ZiffDavis news site. ZD is either majority or wholly owned by Microsoft. Do you suppose there might be a bit of a slant there? Rodd Holman On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote: Patrice - Amazing how these things happen. A few weeks ago a report listed Microsoft products as among the worst security risks. Microsoft immediately attacked the report. Then by an amazing coincidence, an impartial organization releases a report stating that Microsoft's greatest competitor, the free people, are actually the greatest security risk. Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry hired the private eye to get some proof that they were just shills for Microsoft, and the guy was caught dumpster diving? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 27, 2002 8:24 AM To: Multiple recipients of list ORACLE-L FYI. http://www.eweek.com/article2/0,3959,720533,00.asp http://www.eweek.com/article2/0,3959,720533,00.asp 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] Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Import Table from Full Backup
Sorry, as Kirti pointed to me the product belong to BMC. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 1:53 PM I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ora-600 [2103] (oracle 8172/aix 4.3.3.0)
Hi, We've hit Ora-600 [2103] on a production database (oracle 8172/aix 4.3.3.0). We already have aix patch IX 81863. According to Oracle support, it's caused by IO contention. Anybody has faced this one ? = Stéphane Paquette DBA Oracle et DB2, consultant entrepôt de données Oracle and DB2 DBA, datawarehouse consultant [EMAIL PROTECTED] __ Lèche-vitrine ou lèche-écran ? magasinage.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: =?iso-8859-1?q?Stephane=20Paquette?= INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Open Source Security Comes Under Fire
Ok, thanks. After trying to follow the trail of owners, I think tracking who owns what is a full-time job... Pat. -Original Message- Sent: Wednesday, December 04, 2002 11:14 AM To: Multiple recipients of list ORACLE-L David Coursey, one of their Editors/Columnists made the disclaimer some time back when he was comparing different software offerings of some type. He mentioned that MS had some type of ownership in them or their parent company. I don't recall which. Rodd On Wed, 2002-12-04 at 08:03, Boivin, Patrice J wrote: Rodd, Where do you see evidence that Ziff-Davis is owned by Microsoft? The links seem to lead to a UK publishing firm. www.ziffdavis.com -- http://www.willisstein.com/ -- www.emac.com Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, November 27, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Go figure. This was published on a ZiffDavis news site. ZD is either majority or wholly owned by Microsoft. Do you suppose there might be a bit of a slant there? Rodd Holman On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote: Patrice - Amazing how these things happen. A few weeks ago a report listed Microsoft products as among the worst security risks. Microsoft immediately attacked the report. Then by an amazing coincidence, an impartial organization releases a report stating that Microsoft's greatest competitor, the free people, are actually the greatest security risk. Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry hired the private eye to get some proof that they were just shills for Microsoft, and the guy was caught dumpster diving? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 27, 2002 8:24 AM To: Multiple recipients of list ORACLE-L FYI. http://www.eweek.com/article2/0,3959,720533,00.asp http://www.eweek.com/article2/0,3959,720533,00.asp 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] Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Single-task message waits
But since my case is a single package running, there's no end-user interaction. If I understand you correctly, then I'm only collecting response time. I guess I never thought of it in those terms for non-interactive executions. If that's the case, then aren't the waits worth investigating? Or am I off track here? Just trying to get a handle on this in case a miracle happens and I actually get to attend a Hotsos Clinic... :) Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Single-task message waits But if a so-called idle event is consuming end-user response time, then it *is* something to worry about. The problem with the so-called idle events is that when you see lots of time rack up to them in v$system_event, you can't know whether the time has tallied there because of end-user inactivity or because of some other reason... So in the context where you've collected diagnostic data to include both end-user response time and end-user idle time, you *have to* ignore the idle events; you have no other choice. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Gopalakrishnan Sent: Tuesday, December 03, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Rick: ANjo Kolk classifies this wait event under one of the IDLE wait events.i.e nothing to worry if you see them in excessive. Best Regards, K Gopalakrishnan -Original Message- Sent: Tuesday, December 03, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Hey all, Does anyone have an idea as to how to tackle single-task message waits on 8.1.7? The most I could find on this is that it may have to do with Context indexes, which are referenced in the massive package I'm helping test with a developer. I'd really like to drop the amount of waits I'm seeing on this because it accounts for ~300-400ms/sec wait according to Spotlight. I had a 10046 trace running too, but I'm having problems setting max_dump_file_size for another process, so I only have 10MB worth of logfile (about 3 minutes of a 30 minute process). But that's another post. :) TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Table from Full Backup
The 9i RMAN method is nicer, as the DUPLICATE TARGET DATABASE command now has a SKIP TABLESPACES clause... Both RMAN and manual methods exist but they're tacky...Basically you create a new database, recover just the appropriate datafiles, export the data and then do what you want with it... hth connor --- Hately, Mike (NESL-IT) [EMAIL PROTECTED] wrote: Hi, you can recover a tablespace to a point in time. That's the only option you would have using RMAN. Regards, Mike Hately -Original Message- Sent: 04 December 2002 11:54 To: Multiple recipients of list ORACLE-L I think that SQLBackTrack from Precise can restore a table from a backup. Of course you will need to backup with it, not Rman. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Saturday, November 30, 2002 12:39 AM Hi Listers, Is it true that I can do an import of a table from a full backup that was done with RMAN? That was a comment I heard today and doesn't make sense to me, any comments? Saludos, Veronica Levin Enriquez Compañía Cervecera de Nicaragua -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Veronica Levin INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Yechiel Adar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Hately, Mike (NESL-IT) INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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:INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services -- --- To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information
Re: Recipe for application design to run on RAC
Whoa! Tim, thanks a lot for sharing this. Quite an insight. So SELECTs are not a concern. INSERTs are a come and see DBA thing (physical design issue). DELETEs are relatively infrequent and many get translated into UPDATE (logical as opposed to physical delete). Application partitioning as you clearly explained in your email... Would it be closer to a logical or physical design? Seems like something that data modeler/architect should be aware of. So in a sense all modeler needs to worry about is UPDATEs as far as future physical implementation for RAC is concerned? The reason I get stuck on phys vs logical here is because client I am with has a clear separation between the two. It's not only different people that deal with it, but in fact different vendors. soapbox Some background (I probably should've included it in my original post): Mission critical system to replace around 30 small in-house developed apps and do some business re-engineering as we go :( Data modeling is done by one vendor, development by another (don't ask), DB support and maintenance are left for internal DBA staff One of the conditions that CTO office mentioned to the modeling company is to keep HA requirements (not really defined yet - but that's another story) in mind. Ok, they turn around bring the data model and declare that they not only kept it in mind, but in fact their model is RAC aware. Well I can't describe how happy damanagement is - such a successful choice they made (to pick this particular company)! But the curious side of me wonders how this data model is different from the one designed for a single node DB? /soapbox And another thing. Tim, you explained clearly how application should be assessed for non-RAC to RAC migration. In my case however application exists mostly on paper (not taking into account these 30 micky mouse apps - the new system suppose to cover much more than that). 1) I guess simulation would be one way to estimate SQL statements of the app and make a decision on whether it can scale on RAC well or not. (And BTW simulation might be worth the trouble irrespective of whether we use RAC or we don't) But frankly so far I've seen prototyping or simulation for the sake of sizing, capacity planning, understanding DML and query profiles, critical tx, memory footprint required etc, etc... only in James Moorle book :( That is not prototyping for the sake of getting client involved at the early development stages - that's been done with all new apps here. And not benchmarking of already existing application, but the one that hasn't been developed yet. 2) More importantly simulation is obviously the most expensive of all alternatives. Analytical modeling of some sort would be much more welcomed by damanagement. What would be your take on this? How new essentially designed from scratch app can be assessed if it can scale well on RAC? Thanks again for your help! --- Tim Gorman [EMAIL PROTECTED] wrote: To be more precise, the real problems in application-partitioning for OPS/RAC are UPDATE, SELECT ... FOR UPDATE, and DELETE statements due to their WHERE clauses... A SELECT statement does not force exclusive access to a database block and so does not directly cause contention for a block in OPS/RAC. An INSERT statement also does not cause contention on tables because the use of FREELIST GROUPS can keep blocks utilized by different instances separate from one another. If the INSERT is inserting a monotonically-ascending data value into an associated index, then contention on the highest-value leaf block can be reduced by using REVERSE indexes. If the INSERT is not inserting monotonically-ascending data values into any indexes, then contention during parallel cache management between indexes should be minimal. So SELECTs are inherently benign and INSERT operations can be controlled with mechanisms to prevent inter-instance contention for blocks. It is the UPDATE, SELECT ... FOR UPDATE, and DELETE statements which truly require consideration in making an OPS/RAC-based application scaleable. If these statements, which operate on database blocks according to their respective WHERE clauses generated by application logic, do not have some form of awareness of assignment of certain data values to specific database instances, then one can expect problems in scaling. Neither OPS nor RAC has any mechanism to minimize contention between instances for block buffers (as with INSERT statements), so it is up to the application itself (which controls the generation of the WHERE clause) to segregate the application somehow. Whether it is by major application module (i.e. sales and marketing versus order entry and inventory versus general ledger, etc) as Boris had illustrated, or by some other mechanism (i.e. all customers whose names start with A-M on one node, all whose names start with N-Z on the other node, etc), the application
RE: Toasters
And And... if Enron had made toasters... The toast would have come out crooked, and later 'magically' shred itself into croutons! : Shiva -Original Message- Sent: Wednesday, December 04, 2002 3:39 AM To: Multiple recipients of list ORACLE-L As a bit of light relief John Carry on til the end for the SAP toaster If IBM made toasters ... They would want one big toaster where people bring bread to be submitted for overnight toasting. IBM would claim a worldwide market for five, maybe six toasters. If Xerox made toasters ... You could toast one-sided or double-sided. Successive slices would get lighter and lighter. The toaster would jam your bread for you. If Radio Shack made toasters ... The staff would sell you a toaster, but not know anything about it. Or you could buy all the parts to build your own toaster. If Oracle made toasters ... They'd claim their toaster was compatible with all brands and styles of bread, but when you got it home you'd discover the Bagel Engine was still in development, the Croissant Extension was three years away, and that indeed the whole appliance was just blowing smoke. If Sun made toasters ... The toast would burn often, but you could get a really good cuppa Java. Does DEC still make toasters?... They made good toasters in the '80s, didn't they? If Hewlett-Packard made toasters ... They would market the Reverse Toaster, which takes in toast and gives you regular bread. If Tandem made toasters ... You could make toast 24 hours a day, and if a piece got burned the toaster would automatically toast you a new one. If Thinking Machines made toasters ... You would be able to toast 64,000 pieces of bread at the same time. If Cray made toasters ... They would cost $16 million but would be faster than any other single-slice toaster in the world. If the NSA made toasters ... Your toaster would have a secret trap door that only the NSA could access in case they needed to get at your toast for reasons of national security. If Sony made toasters ... The ToastMan, which would be barely larger than the single piece of bread it is meant to toast, can be conveniently attached to your belt. If Timex made toasters ... They would be cheap and small quartz-crystal wrist toasters that take a licking and keep on toasting. If Fisher Price made toasters ... Baby's First Toaster would have a hand-crank that you turn to toast the bread that pops up like a Jack-in-the-box. And, of course: If Microsoft made toasters ... Every time you bought a loaf of bread, you would have to buy a toaster. You wouldn't have to take the toaster, but you'd still have to pay for it anyway. Toaster'95 would weigh 15000 pounds (hence requiring a reinforced steel countertop), draw enough electricity to power a small city, take up 95% of the space in your kitchen, would claim to be the first toaster that lets you control how light or dark you want your toast to be, and would secretly interrogate your other appliances to find out who made them. Everyone would hate Microsoft toasters, but nonetheless would buy them since most of the good bread only works with their toasters. If Apple made toasters ... It would do everything the Microsoft toaster does, but 5 years earlier. If SAP made toasters, the manual to run the toaster would be approximately 10,000 pages long. The toaster would come with 2,500 switches which would all have to be set in an exact pattern and in a precise sequence in order to toast specific kinds of bread. Each pattern would be established by SAP's experts as the Best Practices method of toasting that kind of bread. It would take a team of basis and functional contractors about 1 year to configure the toaster in the best manner, and then another 6 months to test it. In the mean time, your entire family would need to attend extensive training classes on how to use the new toaster. In order to support end users and consultants, MIT would establish a list-serv for people to post questions and answers regarding toaster set-up and operation. Of course, the online help would randomly pop up in German. But once it was running, you'd get the best toast in the world. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Baswannappa, Shiva INET: [EMAIL PROTECTED] Fat City Network Services--
Oracle 8i Certification Will Terminate When???
I have been looking at the Oracle web site for the termination date of Oracle 8i certification tests. There is nothing there. Only Oracle 8. Rumor has had it that there is a termination date. Does anyone have an authoritative answer? = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Single-task message waits
If... 1) you're collecting time consumption data for ONLY the session you care about, AND 2) you're collecting the data for a time interval [t0,t1] that includes ONLY response time that you care about eliminating, ...then the waits are worth investigating. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Rich Sent: Wednesday, December 04, 2002 9:54 AM To: Multiple recipients of list ORACLE-L But since my case is a single package running, there's no end-user interaction. If I understand you correctly, then I'm only collecting response time. I guess I never thought of it in those terms for non-interactive executions. If that's the case, then aren't the waits worth investigating? Or am I off track here? Just trying to get a handle on this in case a miracle happens and I actually get to attend a Hotsos Clinic... :) Thanks, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 9:34 PM To: Multiple recipients of list ORACLE-L Subject: RE: Single-task message waits But if a so-called idle event is consuming end-user response time, then it *is* something to worry about. The problem with the so-called idle events is that when you see lots of time rack up to them in v$system_event, you can't know whether the time has tallied there because of end-user inactivity or because of some other reason... So in the context where you've collected diagnostic data to include both end-user response time and end-user idle time, you *have to* ignore the idle events; you have no other choice. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Gopalakrishnan Sent: Tuesday, December 03, 2002 6:54 PM To: Multiple recipients of list ORACLE-L Rick: ANjo Kolk classifies this wait event under one of the IDLE wait events.i.e nothing to worry if you see them in excessive. Best Regards, K Gopalakrishnan -Original Message- Sent: Tuesday, December 03, 2002 3:10 PM To: Multiple recipients of list ORACLE-L Hey all, Does anyone have an idea as to how to tackle single-task message waits on 8.1.7? The most I could find on this is that it may have to do with Context indexes, which are referenced in the massive package I'm helping test with a developer. I'd really like to drop the amount of waits I'm seeing on this because it accounts for ~300-400ms/sec wait according to Spotlight. I had a 10046 trace running too, but I'm having problems setting max_dump_file_size for another process, so I only have 10MB worth of logfile (about 3 minutes of a 30 minute process). But that's another post. :) TIA, Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Open Source Security Comes Under Fire
Okay, since I provided the original remark that provoked this line of discussion, let me clarify. The organization I was asking whether they were a shill for Microsoft is the Aberdeen Group, the people that did the report that made Microsoft look great and Linux look bad. I don't think it matters which news organization reports the findings, since Aberdeen is a fairly prominent organization. I did a search and found the name of the organizations that Oracle had investigated. Here is the news excerpt: Oracle hired Investigative Group International to probe two research organizations, the Independence Institute and the National Taxpayers Union. The company sought to verify links between Microsoft and the organizations during its antitrust trial--and even tried to buy trash from another research group with close ties to Microsoft. Oracle told Bloomberg News today it discovered that the two organizations were misrepresenting themselves as independent advocacy groups when they were in fact funded by Microsoft. Oracle said the company hired the detective agency because the organizations were releasing studies supporting Microsoft during the antitrust trial. The financial ties between the organizations were reported by The Wall Street Journal and The Washington Post. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 8:04 AM To: Multiple recipients of list ORACLE-L Rodd, Where do you see evidence that Ziff-Davis is owned by Microsoft? The links seem to lead to a UK publishing firm. www.ziffdavis.com -- http://www.willisstein.com/ -- www.emac.com Regards, Patrice Boivin Systems Analyst (Oracle Certified DBA) -Original Message- Sent: Wednesday, November 27, 2002 3:27 PM To: Multiple recipients of list ORACLE-L Go figure. This was published on a ZiffDavis news site. ZD is either majority or wholly owned by Microsoft. Do you suppose there might be a bit of a slant there? Rodd Holman On Wed, 2002-11-27 at 10:23, DENNIS WILLIAMS wrote: Patrice - Amazing how these things happen. A few weeks ago a report listed Microsoft products as among the worst security risks. Microsoft immediately attacked the report. Then by an amazing coincidence, an impartial organization releases a report stating that Microsoft's greatest competitor, the free people, are actually the greatest security risk. Somebody refresh my memory -- wasn't it the Aberdeen Group that Larry hired the private eye to get some proof that they were just shills for Microsoft, and the guy was caught dumpster diving? Dennis Williams DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, November 27, 2002 8:24 AM To: Multiple recipients of list ORACLE-L FYI. http://www.eweek.com/article2/0,3959,720533,00.asp http://www.eweek.com/article2/0,3959,720533,00.asp 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] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Rodd Holman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boivin, Patrice J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing
RE: Single-task message waits
Hey Cary, Yes and Yes. Which brings me back to my original question: How do I go about tracking down single-task message waits? Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Single-task message waits If... 1) you're collecting time consumption data for ONLY the session you care about, AND 2) you're collecting the data for a time interval [t0,t1] that includes ONLY response time that you care about eliminating, ...then the waits are worth investigating. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Toasters
I saw a video clip on our National News show here in Canada last night (The National), they talked about corruption at Enron, etc. Apparently the accounting consulting firms are still lobbying to let them continue negotiating consulting contracts with firms they are supposed to be auditing at arms' length. The news item included a video from Enron, which emphasized that integrity was their prime motivator, and you see the top 3 executives in the video who have since been indicted. I am probably naive, it was surprising to see people act normally (even proudly) as if nothing untoward was taking place. If you are interested and can view video clips, you can go to http://www.cbc.ca/news/ and look in the right-hand column, under Multimedia to see the clips. Regards, Patrice Boivin (Canada) -Original Message- Sent: Wednesday, December 04, 2002 11:54 AM To: Multiple recipients of list ORACLE-L And And... if Enron had made toasters... The toast would have come out crooked, and later 'magically' shred itself into croutons! : Shiva -Original Message- Sent: Wednesday, December 04, 2002 3:39 AM To: Multiple recipients of list ORACLE-L As a bit of light relief John Carry on til the end for the SAP toaster If IBM made toasters ... They would want one big toaster where people bring bread to be submitted for overnight toasting. IBM would claim a worldwide market for five, maybe six toasters. If Xerox made toasters ... You could toast one-sided or double-sided. Successive slices would get lighter and lighter. The toaster would jam your bread for you. If Radio Shack made toasters ... The staff would sell you a toaster, but not know anything about it. Or you could buy all the parts to build your own toaster. If Oracle made toasters ... They'd claim their toaster was compatible with all brands and styles of bread, but when you got it home you'd discover the Bagel Engine was still in development, the Croissant Extension was three years away, and that indeed the whole appliance was just blowing smoke. If Sun made toasters ... The toast would burn often, but you could get a really good cuppa Java. Does DEC still make toasters?... They made good toasters in the '80s, didn't they? If Hewlett-Packard made toasters ... They would market the Reverse Toaster, which takes in toast and gives you regular bread. If Tandem made toasters ... You could make toast 24 hours a day, and if a piece got burned the toaster would automatically toast you a new one. If Thinking Machines made toasters ... You would be able to toast 64,000 pieces of bread at the same time. If Cray made toasters ... They would cost $16 million but would be faster than any other single-slice toaster in the world. If the NSA made toasters ... Your toaster would have a secret trap door that only the NSA could access in case they needed to get at your toast for reasons of national security. If Sony made toasters ... The ToastMan, which would be barely larger than the single piece of bread it is meant to toast, can be conveniently attached to your belt. If Timex made toasters ... They would be cheap and small quartz-crystal wrist toasters that take a licking and keep on toasting. If Fisher Price made toasters ... Baby's First Toaster would have a hand-crank that you turn to toast the bread that pops up like a Jack-in-the-box. And, of course: If Microsoft made toasters ... Every time you bought a loaf of bread, you would have to buy a toaster. You wouldn't have to take the toaster, but you'd still have to pay for it anyway. Toaster'95 would weigh 15000 pounds (hence requiring a reinforced steel countertop), draw enough electricity to power a small city, take up 95% of the space in your kitchen, would claim to be the first toaster that lets you control how light or dark you want your toast to be, and would secretly interrogate your other appliances to find out who made them. Everyone would hate Microsoft toasters, but nonetheless would buy them since most of the good bread only works with their toasters. If Apple made toasters ... It would do everything the Microsoft toaster does, but 5 years earlier. If SAP made toasters, the manual to run the toaster would be approximately 10,000 pages long. The toaster would come with 2,500 switches which would all have to be set in an exact pattern and in a precise sequence in order to toast specific kinds of bread. Each pattern would be established by SAP's experts as the Best Practices method of toasting that kind of bread. It would take a team of basis and functional contractors about 1 year to configure the toaster in the best manner, and then another 6 months to test it. In the mean time, your entire family would need to attend extensive training classes on how to use the new toaster. In order to support end users and consultants, MIT would establish a list-serv for people to post questions and answers regarding toaster set-up and operation. Of course, the online help
RE: Oracle 8i Certification Will Terminate When???
Peter, I don't think a date has been announced yet. When they do state a date they give 6 months notice though John -Original Message- Sent: 04 December 2002 15:59 To: Multiple recipients of list ORACLE-L I have been looking at the Oracle web site for the termination date of Oracle 8i certification tests. There is nothing there. Only Oracle 8. Rumor has had it that there is a termination date. Does anyone have an authoritative answer? = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Peter Barnett INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Semi-OT: Pics from OracleWorld
Cool, thanks Connor. Next week I will be dining with some of the other erstwhile (other than email) members of this list, past and present. I'm planning to take my Digital Camera, better go pop it into my suitcase now. Jared Connor McDonald [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 12:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Semi-OT: Pics from OracleWorld Apologies for the delay (the digital camera died on the trip over) so apologies as well for the picture quality (all taken with a throwaway disposable camera). But, here they are... the rough bunch that is the Oracle Fatcity-L crew in San Francisco. http://www.oracledba.co.uk/sanfran.htm Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Oracle 8i Certification Will Terminate When???
I went to the Oracle Certification page and looked at the NEWS and the FAQ. Both had mentions of the retirement of various tracks but neither mentioned the retirement of the 8i track. The abscense of an announcement on the official web site would indicate to me that it has not been announced yet. John Peter Barnett wrote: I have been looking at the Oracle web site for the termination date of Oracle 8i certification tests. There is nothing there. Only Oracle 8. Rumor has had it that there is a termination date. Does anyone have an authoritative answer? = Pete Barnett Lead Database Administrator The Regence Group [EMAIL PROTECTED] __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ora NT DBA INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Are Oracle courses required for Oracle Certification now?
Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Import Table from Full Backup
Title: RE: Import Table from Full Backup From: Hately, Mike (NESL-IT) [mailto:[EMAIL PROTECTED]] I'd agree that you can achieve the same result. I think I'd argue that it's not a feature of RMAN though. I can also take that restored table, spool it a text file and edit it using MS Word but I wouldn't claim that RMAN can generate Word files. *roll eyes* Mind you, this is probably word class pedantry on my part =) As the question was can it be done, not is it a feature of, I'd say, yes indeed ;-)
Including properties in URL string
I have a need to use a Secure Thin JDBC Connection from a 3rd party product to a Oracle 9i database. The 3rd party product will only allow me to specify a URL, User and Password for the connection. So, I would like to be able to specify a URL like the following: jdbc:oracle:thin:@myhost:1521:mydb?user=abcpassword=xyzoracle.net.encrypti on_client=REQUIRED But, if I attempt this I get the following error: java.sql.SQLException: invalid arguments in call When working with other JDBC drivers in the past I have been able to pass properties in the URL String, but the Oracle driver doesn't appear to allow this. Is it possible to pass properties in the URL String when using the Oracle JDBC thin driver? Perhaps I'm not using the correct syntax! Thanks, Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Vaughn, Rick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
No triggers, no snapshots. Thanks for the thougth though. Jay -Original Message- Sent: Tuesday, December 03, 2002 2:34 PM To: Multiple recipients of list ORACLE-L Hum. My last thought would are there triggers or snapshots defined on the table? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/03/2002 08:18 AM Please respond to ORACLE-L Ron, Good idea, but DEGREE=1 There are two indexes, but they are in a different tablespace (which has plenty of free space available and did not give an error). Next extent size is 25M but, as mentioned, it shouldn't have needed a new extent. I'm still at a loss... Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks should be used, unless he is doing a direct path insert which will only use space above the HWM. Richard Ji -Original Message- Sent: Friday, November 29, 2002 2:05 PM To: Multiple recipients of list ORACLE-L did u coalesced the tablespaces? -Original Message- Sent: sexta-feira, 29 de Novembro de 2002 17:59 To: Multiple recipients of list ORACLE-L Okay, I can't figure this one out. Earlier this week I got an ORA-1653: unable to extend table on a really big table. However this was just after I had deleted
Re: Oracle 9iR2 on Red Hat 8.0
If you've installed Oracle 9i on RH 8.0, please let me know. Also, please let me know of any difficulties and workarounds you may have encountered. Just put a new 40Gig HD in my laptop, and wondering if I can install RH 8.0, or should use 7.2. Jared: I put together some notes when I installed 9.2.0 on RH7.3. I think that RH8 is probably similar. http://iheavy.com/~shull/files/ora9i_inst_notes.txt HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
freelist groups is 1 -Original Message- Sent: Tuesday, December 03, 2002 9:59 PM To: Multiple recipients of list ORACLE-L What is the FREELIST GROUPS for the table? Waleed -Original Message- Sent: Tuesday, December 03, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't want the table to extent at all since he just deleted 2 million rows so there are plenty of space within the segment itself. Those free blocks
RE: ORA-1653: unable to extend table - Why?
The activity is almost all inserts (there is also some minimal update activity on two CHAR(1) columns later, but it was failing on the inserts). Looking at it, I'm surprised that I have freelists=1 since so much of the activity is insert related. I should probably increase that even if it doesn't help with this problem since it should improve insert performance. I guess the next step is to do a 10046 or statspack report the next time the insert is running. That might not be for a few weeks though (next time I'm certain of is 2nd week of January). It's not in a LMT, but I am using uniform extents. Thanks for all the suggestions, Jay -Original Message- Sent: Wednesday, December 04, 2002 7:49 AM To: Multiple recipients of list ORACLE-L I always overlook things, so I'll just ask and hope it isn't already on the thread: Exactly what kind of activity is going on against this wonderful table? Is this table placed in an LMT? If yes, is it a Uniform LMT? Could you trace the processes/users doing stuff to the table so that we could see if there's contention for ITL slots or other such things? Mogens Mark J. Bobak wrote: Hmm...not sure if this is what's biting you, but if you're out of ITL slots on the block, Oracle will move to the next block on the free list. If all the blocks on the free list have filled ITLs, Oracle will add an extent to the free list. I don't suppose you have MAXTRANS set to 1 or some other very low number? If so, and with concurrent inserts happening, it's possible that you could be allocating more blocks to the free list, even if there are tons of blocks already on the free list, simply due to the ITL shortage. (Note that this is why you'll never see mode 4 TX enqueue waits on insert to a table.) If MAXTRANS isn't really low, and if you're not doing direct-load (APPEND hint) inserts, then I'm stumped. -Mark On Tue, 2002-12-03 at 17:09, Fink, Dan wrote: Hmm...Why didn't they ask for your buffer cache hit ratio? Seriously, I've pondered this and it comes down to a question. What would cause a transaction not to use blocks on the freelist? If a transaction cannot use these blocks, then it must allocate new space. If the transaction is set up so as to allocate space above the HWM, we have the same scenario. Are there transactions that are allocating blocks off the freelist? How deep will a transaction read the freelist to find an open block before giving up and allocating space? Are the inserts of such size that they would not fit into the space in the blocks on the freelist? I don't know the answers, but it seems that the questions may offer some clues. I can't wait to find out the real answer! -Original Message- Sent: Tuesday, December 03, 2002 1:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why?
Re: Are Oracle courses required for Oracle Certification now?
You are not required to take the expensive course if: 1) You are upgrading from 7 8 or 8i certification. 2) You took your very first 9i certification exam before Sept 1, 2002 3) You are only shooting for the Associate certification level. -- Lyndon Tiu Quoting Kieran Murray [EMAIL PROTECTED]: Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Ora 29540 error
Title: Ora 29540 error I get the following when trying to use the utl_tcp package on 8.1.7 database. The following error has occurred: ORA-29540: class oracle/plsql/net/TCPConnection does not exist ORA-06512: at SYS.UTL_TCP, line 537 ORA-06512: at SYS.UTL_TCP, line 199 ORA-06512: at SYS.UTL_SMTP, line 102 ORA-06512: at SYS.UTL_SMTP, line 121 ORA-06512: at KIVA.RP_SEND_MAIL, line 51 ORA-06512: at line 5 What is missing from the database in order for that to run? Thanks for any help. Randy R. Pace Development Team Leader Accela, Inc. 9662 South 700 East Sandy UT, 84070 Tel: 801 495 9300 Fax: 801 495 9301 www.accela.com http://www.accela.com
Re: Semi-OT: Pics from OracleWorld
oh God, remind me to break that camera ! --- [EMAIL PROTECTED] wrote: Cool, thanks Connor. Next week I will be dining with some of the other erstwhile (other than email) members of this list, past and present. I'm planning to take my Digital Camera, better go pop it into my suitcase now. Jared Connor McDonald [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 12:34 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Semi-OT: Pics from OracleWorld Apologies for the delay (the digital camera died on the trip over) so apologies as well for the picture quality (all taken with a throwaway disposable camera). But, here they are... the rough bunch that is the Oracle Fatcity-L crew in San Francisco. http://www.oracledba.co.uk/sanfran.htm Cheers Connor = Connor McDonald http://www.oracledba.co.uk http://www.oaktable.net GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he will sit in a boat and drink beer all day __ 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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.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 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Title: RE: Are Oracle courses required for Oracle Certification now? My understanding it is true for 9i but not for the upgrade test for 9i so I am feverishly getting certified (okay not so feverishly) in 8i so I can do the upgrade path. Question is: When do the 8i tests expire? -Original Message- From: Kieran Murray [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 12:25 PM To: Multiple recipients of list ORACLE-L Subject: Are Oracle courses required for Oracle Certification now? Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Oracle 8i Certification Will Terminate When???
I'm barely done with my 9i certification track and I'm hearing of 10i coming out soon. All's too fast! -- Lyndon Tiu Quoting [EMAIL PROTECTED]: Peter, I don't think a date has been announced yet. When they do state a date they give 6 months notice though John -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
Title: RE: I believe that is the easiest/cleanest way to restore from patches esp. when you don't know what those patches contain. -Original Message- From: Scott Stefick [mailto:[EMAIL PROTECTED]] Sent: Tuesday, December 03, 2002 2:21 PM To: Multiple recipients of list ORACLE-L Subject: Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
MAXTRANS is set to 255. Thanks anyway :) -Original Message- Sent: Wednesday, December 04, 2002 3:54 AM To: Multiple recipients of list ORACLE-L Hmm...not sure if this is what's biting you, but if you're out of ITL slots on the block, Oracle will move to the next block on the free list. If all the blocks on the free list have filled ITLs, Oracle will add an extent to the free list. I don't suppose you have MAXTRANS set to 1 or some other very low number? If so, and with concurrent inserts happening, it's possible that you could be allocating more blocks to the free list, even if there are tons of blocks already on the free list, simply due to the ITL shortage. (Note that this is why you'll never see mode 4 TX enqueue waits on insert to a table.) If MAXTRANS isn't really low, and if you're not doing direct-load (APPEND hint) inserts, then I'm stumped. -Mark On Tue, 2002-12-03 at 17:09, Fink, Dan wrote: Hmm...Why didn't they ask for your buffer cache hit ratio? Seriously, I've pondered this and it comes down to a question. What would cause a transaction not to use blocks on the freelist? If a transaction cannot use these blocks, then it must allocate new space. If the transaction is set up so as to allocate space above the HWM, we have the same scenario. Are there transactions that are allocating blocks off the freelist? How deep will a transaction read the freelist to find an open block before giving up and allocating space? Are the inserts of such size that they would not fit into the space in the blocks on the freelist? I don't know the answers, but it seems that the questions may offer some clues. I can't wait to find out the real answer! -Original Message- Sent: Tuesday, December 03, 2002 1:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert.
RE: ORA-1653: unable to extend table - Why?
Yes, these are definitely the questions to be asking. And some of the freelist blocks are being written to since we had another insert run night before last and the number of freelist blocks declined somewhat although more extents were also claimed in the new datafile. So sometimes it's writing to the freelist blocks and sometimes it isn't. I'm confused. Jay -Original Message- Sent: Tuesday, December 03, 2002 5:09 PM To: Multiple recipients of list ORACLE-L Hmm...Why didn't they ask for your buffer cache hit ratio? Seriously, I've pondered this and it comes down to a question. What would cause a transaction not to use blocks on the freelist? If a transaction cannot use these blocks, then it must allocate new space. If the transaction is set up so as to allocate space above the HWM, we have the same scenario. Are there transactions that are allocating blocks off the freelist? How deep will a transaction read the freelist to find an open block before giving up and allocating space? Are the inserts of such size that they would not fit into the space in the blocks on the freelist? I don't know the answers, but it seems that the questions may offer some clues. I can't wait to find out the real answer! -Original Message- Sent: Tuesday, December 03, 2002 1:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the
RE: Recipe for application design to run on RAC
Title: RE: Recipe for application design to run on RAC H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference. Schema1 users have tns entry for db1 and fail over to db2 Schema2 users have a preference for db2 with a fail over to db1 This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application. None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine. Like I mentioned this is not a good example ... but this is how we did it in one of our major application. 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! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
Re: Ora 29540 error
Install the JVM...see MetaLink Note:156477.1 Jeff Herrick On Wed, 4 Dec 2002, Randy Pace wrote: I get the following when trying to use the utl_tcp package on 8.1.7 database. The following error has occurred: ORA-29540: class oracle/plsql/net/TCPConnection does not exist ORA-06512: at SYS.UTL_TCP, line 537 ORA-06512: at SYS.UTL_TCP, line 199 ORA-06512: at SYS.UTL_SMTP, line 102 ORA-06512: at SYS.UTL_SMTP, line 121 ORA-06512: at KIVA.RP_SEND_MAIL, line 51 ORA-06512: at line 5 What is missing from the database in order for that to run? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Single-task message waits
Rich, Well, at least we've cleared up the whether. Now the question turns to the why. Once you have identified a program's dominant response time contributor, solving any optimization problem degenerates to a very simple strategy: 1. Reduce the number of times the dominant contributor's services are required. 2. Reduce the duration per service call of the dominant contributor. I expect that #2 will be difficult to do in this case, because I'd expect that the single-task driver is probably the fastest conceivable way that two pieces of client-server code can communicate (they're after all in the same executable). Your leverage is probably #1. It's the old adage: Q: What's the fastest way to do X? A: Don't. Find out whether your process is making more database calls than it needs to be making. Investigate the usual suspects: SQL that doesn't use bind variables and therefore has to be parsed more often than it should be parsed, one-row-at-a-time manipulation instead of using arrays and bulk features, and so on. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Rich Sent: Wednesday, December 04, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Hey Cary, Yes and Yes. Which brings me back to my original question: How do I go about tracking down single-task message waits? Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Single-task message waits If... 1) you're collecting time consumption data for ONLY the session you care about, AND 2) you're collecting the data for a time interval [t0,t1] that includes ONLY response time that you care about eliminating, ...then the waits are worth investigating. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cary Millsap INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: SLA Trigger/Procedure
Don't forget to handle connection attempts that hang and never return. Jared Post, Ethan [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/03/2002 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: SLA Trigger/Procedure I agree what is needed is something very generic that could monitor the uptime of pretty much any process. After giving this more thought and always liking to keep things simple here is the direction I might eventually head. The logic below would result in a log file that shows all unscheduled outage periods. You would have to ensure it runs at regular intervals. (NOT VERY PRETTY, BUT SIMPLE ENOUGH) Files Required: * Control file that has crontab like entries which define periods that are either outages or times when database is expected to be running. Script Workings: * Run command/script which returns 0 or 1 (0=thingy not running, 1=thingy running) use separate command/script to log into database, grep for process etc... If (( 0 )) check control file to see if thingy should be running if suppose to be running store time trigger flag (cat time to flag file) if not suppose to be running if flag unscheduled outage was triggered but has rolled into an scheduled outage period log start and end time for outage reset flag fi fi else if flag thingy is back up log start and end time for outage reset flag fi fi -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Post, Ethan INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Title: RE: Are Oracle courses required for Oracle Certification now? From: Kieran Murray [mailto:[EMAIL PROTECTED]] Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray Why are you surprised? Remember that this program is run out of Oracle University. They've a vested interest in getting folks into their classes. From : http://www.oracle.com/education/certification/ Hands-On Course Requirement Beginning September 1, 2002, Oracle University will require that all candidates pursuing the Oracle9i DBA Certified Professional credential must attend one instructor-led course either inclass or online to receive certified status. To meet the requirement, candidates must attend a course offered at an Oracle University center or at an Oracle Authorized Education Center or Partner.
RE: Are Oracle courses required for Oracle Certification now?
This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE:
I got to thinking a little more about this. If you have an oraInventory directory under your product directory, I think you need to back that one up too ... at least it wouldn't hurt. -Original Message- Sent: Wednesday, December 04, 2002 12:14 PM To: Multiple recipients of list ORACLE-L I believe that is the easiest/cleanest way to restore from patches esp. when you don't know what those patches contain. -Original Message- Sent: Tuesday, December 03, 2002 2:21 PM To: Multiple recipients of list ORACLE-L Gurus, I was just given a project to maintain a Computerized Maintenance Management System. When I asked the companies support staff how to roll back patches in the backend Oracle Database (Ver. 8174), they said that there was no way to do this. I'm guessing I could use logminer just incase a patch doesn't work. Would this be a good solution, or are there other (better) ways of safeguarding myself when it comes to patching? Obviously, I will be applying the patches to a test instance first, but I don't want to have to go back to restore from a backup if the patch causes unexpected issues. TIA! ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott Stefick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Lee INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
how to modify query
Title: Ora 29540 error Hi, Following code works in sql server but IF NOT EXISTS dosn't work in oracle how can we modify this code so that it should work on both sql server and oracleif not exists ( select col1 from t_suspended_txn wherecol2='A'begin insert into t_suspended_txn select'A','B' end Thanks --Harvinder
Slightly Off Topic Question
I need some help running an Oracle education CDROM. I am taking the 9i Certification course via CDROM for 1Z0-007. I attempt to start the installed CDROM with Start/ Run. I go to the D: drive and it automatically selects autorun.exe. When I hit run is asks if I want help? If I say no, then nothing happens. If I say yes it goes to the Duckware web site so I can download winopen.exe. I downloaded this file. So how do I use winopen.exe? There are no instructions in the literature on how do this. Also, how do I use I.E. in kiosk mode? I tried the instructions from Duckware and it didn't work. I'm using I.E. 6.0. Thanks much and have a good day, Ken Janusz
RE: ORA-1653: unable to extend table - Why?
What is the average row length? Waleed -Original Message- Sent: Wednesday, December 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L freelist groups is 1 -Original Message- Sent: Tuesday, December 03, 2002 9:59 PM To: Multiple recipients of list ORACLE-L What is the FREELIST GROUPS for the table? Waleed -Original Message- Sent: Tuesday, December 03, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there are many smaller free extents that can be coalesced. But that still doesn't solve Jay's problem. Because he doesn't
RE: ORA-1653: unable to extend table - Why?
1895 -Original Message- Sent: Wednesday, December 04, 2002 2:34 PM To: Multiple recipients of list ORACLE-L What is the average row length? Waleed -Original Message- Sent: Wednesday, December 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L freelist groups is 1 -Original Message- Sent: Tuesday, December 03, 2002 9:59 PM To: Multiple recipients of list ORACLE-L What is the FREELIST GROUPS for the table? Waleed -Original Message- Sent: Tuesday, December 03, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed. --- Richard Ji [EMAIL PROTECTED] wrote: Coalescing might help if there
Export from Oracle 8 to Oracle 7
Hi all Can I export from a Release 8.1.7.0.0 oracle db to a Release 7.1.4.1.1? Is there a setting in the export utility to be backward compatible with V7? Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Single-task message waits
Hey Cary, No magic bullet? I was afraid you were going to say that. :) I see that there are some parsing issues from the first of many 10046 traces. Most of these high-parsing statements are generated by Oracle when a Context index is used in a query. The good news, if TKPROF output can be believed, is that the total time spent in all parses is 35 seconds out of 52 minutes elapsed, so I hadn't planned on spending any more time here. As for the one-row-at-a-time manipulation part, well... Implicit cursors within cursors within cursors. We've removed a few where we could, but unfortunately a rewrite probably isn't going to happen for this project. We're still learning to be good SQL coders while dealing with crappy data layouts from the 80s. Thanks for your input! And thanks for the 10046 paper on hotsos.com! :) Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 12:54 PM To: Multiple recipients of list ORACLE-L Subject: RE: Single-task message waits Rich, Well, at least we've cleared up the whether. Now the question turns to the why. Once you have identified a program's dominant response time contributor, solving any optimization problem degenerates to a very simple strategy: 1. Reduce the number of times the dominant contributor's services are required. 2. Reduce the duration per service call of the dominant contributor. I expect that #2 will be difficult to do in this case, because I'd expect that the single-task driver is probably the fastest conceivable way that two pieces of client-server code can communicate (they're after all in the same executable). Your leverage is probably #1. It's the old adage: Q: What's the fastest way to do X? A: Don't. Find out whether your process is making more database calls than it needs to be making. Investigate the usual suspects: SQL that doesn't use bind variables and therefore has to be parsed more often than it should be parsed, one-row-at-a-time manipulation instead of using arrays and bulk features, and so on. Cary Millsap Hotsos Enterprises, Ltd. http://www.hotsos.com Upcoming events: - Hotsos Clinic, Dec 9-11 Honolulu - Hotsos Clinic 101, Jan 7-9 Knoxville - Steve Adams's Miracle Master Class, Jan 13-15 Copenhagen - 2003 Hotsos Symposium, Feb 9-12 Dallas -Original Message- Rich Sent: Wednesday, December 04, 2002 10:59 AM To: Multiple recipients of list ORACLE-L Hey Cary, Yes and Yes. Which brings me back to my original question: How do I go about tracking down single-task message waits? Thanks! Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA -Original Message- From: Cary Millsap [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 10:14 AM To: Multiple recipients of list ORACLE-L Subject: RE: Single-task message waits If... 1) you're collecting time consumption data for ONLY the session you care about, AND 2) you're collecting the data for a time interval [t0,t1] that includes ONLY response time that you care about eliminating, ...then the waits are worth investigating. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jesse, Rich INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Are Oracle courses required for Oracle Certification now?
Hi Lyndon, Well I don't know about your setup, but I can connect just fine with the connect string you listed below on Win2K, Oracle 9.2. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 12/4/2002 2:09 PM, Lyndon Tiu [EMAIL PROTECTED] wrote: This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
How do you startup shutdown the database on NT/W2K ? As I am able to, from the DOS Command Prompt set oracle_sid=orcl sqlplus /nolog connect / as sysdba startup pfile=initorcl.ora or shutdown immediate Just fine, at least with O 9.2 -Original Message- Sent: Wednesday, December 04, 2002 14:10 To: Multiple recipients of list ORACLE-L This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cornio, Georgette Ms USACFSC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Something that might be of use
We often need to refresh test and development databases with exports that have extent sizing a lot bigger that what we want. In test and ESPECIALLY dev, space and file system availability often require us to just get something working without regard for performance. In these cases, extent sizing in the exports often prevents us from loading even a row-less import into the test/dev database. The following C program was written to deal with those situations. I have used it enough that I think I can go ahead and toss it out to the world. The program is functional but not necessarily elegant. Of course, no guarantees about anything are made. If you make any improvements, I would be most appreciative if you sent them. == SNIP == SNIP == SNIP == SNIP == SNIP == SNIP == /*** ** This was hastily written by Stephen Lee because we've ** ** been needing something like this real bad for a while. ** ** If you leave the section that opens the files commented, ** ** then the syntax would be something like: ** ** modify_extents dumpfile modified_dump_file ** **** ** Even though this has been tested against enough exports** ** that it seems to work OK, I do have some nagging doubts** ** about how universally compatible it is. I do make some** ** assumptions about the text in an export dump file and ** ** about the size of a character in that file.** **** ** This program changes the INITIAL and NEXT extent size ** ** specification in the dump file to a fixed size. You can ** ** edit this value in the program, prior to compiling it. ** **** ** It is acknowledged that this is a rather bare-bones** ** program, but it needed to written in a hurry. Enhancement ** ** of the program is left as an exercise for the reader. ** ***/ #include sys/types.h #include sys/stat.h #include sys/param.h #include sys/signal.h #include sys/fault.h #include sys/syscall.h #include sys/procfs.h #include dirent.h #include fcntl.h #include stdio.h #include stdlib.h #include string.h #include unistd.h #include pwd.h #include math.h #include time.h #include termios.h #include signal.h #include ctype.h #include netdb.h /** Include the kitchen sink too **/ /* BEGIN MAIN **/ int main (int argc, char **argv, char **envp) { int in, out, bytes_read, diddle, match = 0, create = 0; char read_buf[57344], write_buf[65536], diddler; // Note that the following strings contain a space. That is important. char *s0 = CREATE ; char *s1 = ALTER ; char *s8 = INITIAL ; char *s9 = NEXT ; int s0_len = strlen(s0); int s1_len = strlen(s1); int s8_len = strlen(s8); int s9_len = strlen(s9); int i, j0, j1, j8, j9, x, skip = 0; /*** ** Un-comment this section and use the open statements if you want to hard-code ** the paths, or if you want to use something like argv[1] and argv[2]. if( (in = open(/export/oracle/admin/FTLP/exp/test.dmp, O_RDONLY)) 0 ) { printf(\nFailed to open input file.\n); return 1; } if( (out = open(/export/oracle/admin/FTLP/exp/modified.dmp, O_RDWR|O_CREAT|O_TRUNC)) 0 ) { printf(\nFailed to open output file.\n); return 1; } fchmod(out, 0600); / /* Use the dup commands if you want to use command-line redirection as in: * program_name input_file output_file ***/ in = dup(0); out = dup(1); /** ** The following loop reads bytes from the input file and copies them to the output file. ** While it is doing this, it is looking for matches to the strings defined in s0, s1, etc. ** S0 and s1 define when we have found the beginning of a CREATE or ALTER command and ** should start looking for the strings INITIAL and NEXT. When those strings are found, ** and we verify that they are followed by a number, then the numeric data is replaced by ** the new characters. Then any following numeric data is skipped until we get to the ** next space. We write the output buffer every time we read a new input buffer. ** We continue this until the entire input file has been read. ** The reason for the CREATE and ALTER searches is to throw in a quart or two of paranoia. ** This requires that both strings CREATE/ALTER and INITIAL/NEXT to be present. I suppose ** there some chance that we could have these strings present,
RE: Ora 29540 error
Randy, I don't think the JVM is missing. try installing the $ORACLE_HOME/plsql/jlib/plsql.jar file using sqlloader. the class files from this file are what are missing. hope this helps Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, December 04, 2002 2:10 PM To: Multiple recipients of list ORACLE-L Install the JVM...see MetaLink Note:156477.1 Jeff Herrick On Wed, 4 Dec 2002, Randy Pace wrote: I get the following when trying to use the utl_tcp package on 8.1.7 database. The following error has occurred: ORA-29540: class oracle/plsql/net/TCPConnection does not exist ORA-06512: at SYS.UTL_TCP, line 537 ORA-06512: at SYS.UTL_TCP, line 199 ORA-06512: at SYS.UTL_SMTP, line 102 ORA-06512: at SYS.UTL_SMTP, line 121 ORA-06512: at KIVA.RP_SEND_MAIL, line 51 ORA-06512: at line 5 What is missing from the database in order for that to run? -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jeff Herrick INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recipe for application design to run on RAC
Title: RE: Recipe for application design to run on RAC So when I access the fantasy football league on the espn web site-I go to schema2 because my team(s) are losing :-) I guess thats what I get when I picked a group of guys that are all on the injured reserve Seriously though--What if 50% of the blocks of data for schema1 are "owned" by db2? do you eventually see where ownership is transferred to the "active" node, reducedcache fusion activity and then transfer of blocks? Do the users on schema1 have to use the data on schema2 at all? I'm trying to see if not only are the users logically partitioned-but if your schemas offer any data partitioning to align with the schema1 and schema2 thanks! Greg -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 2:05 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Recipe for application design to run on RAC H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference. Schema1 users have tns entry for db1 and fail over to db2 Schema2 users have a preference for db2 with a fail over to db1 This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application. None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine. Like I mentioned this is not a good example ... but this is how we did it in one of our major application. 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!
Re: Are Oracle courses required for Oracle Certification now?
Alan, I think what Lyndon meant is this SQLNET.AUTHENTICATION_SERVICES thing on MS Win that toggles your ability to connect with the syntax described. Comment it out and you might see something like ORA-1031 --- Alan Davey [EMAIL PROTECTED] wrote: Hi Lyndon, Well I don't know about your setup, but I can connect just fine with the connect string you listed below on Win2K, Oracle 9.2. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 12/4/2002 2:09 PM, Lyndon Tiu [EMAIL PROTECTED] wrote: This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L
Re: Oracle 9iR2 on Red Hat 8.0
Thanks Sean. I installed 9iR2 on both my laptop and a desktop, both running RH 8.0. Pretty straightforward, except for the usual failure in linking intermedia. I would have thought they would fix that by now. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/04/2002 09:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:Re: Oracle 9iR2 on Red Hat 8.0 If you've installed Oracle 9i on RH 8.0, please let me know. Also, please let me know of any difficulties and workarounds you may have encountered. Just put a new 40Gig HD in my laptop, and wondering if I can install RH 8.0, or should use 7.2. Jared: I put together some notes when I installed 9.2.0 on RH7.3. I think that RH8 is probably similar. http://iheavy.com/~shull/files/ora9i_inst_notes.txt HTH, Sean -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Title: RE: Are Oracle courses required for Oracle Certification now? if the DOS command prompt doesn't work, try starting it at the services level. -Original Message- From: Cornio, Georgette Ms USACFSC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 12:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Are Oracle courses required for Oracle Certification now? How do you startup shutdown the database on NT/W2K ? As I am able to, from the DOS Command Prompt set oracle_sid=orcl sqlplus /nolog connect / as sysdba startup pfile=initorcl.ora or shutdown immediate Just fine, at least with O 9.2 -Original Message- Sent: Wednesday, December 04, 2002 14:10 To: Multiple recipients of list ORACLE-L This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cornio, Georgette Ms USACFSC INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB
Re: Are Oracle courses required for Oracle Certification now?
Hmmm. So it's a config issue then. I will certainly poke around a bit more. See what happens if you send a Unix person to do a Windows job : I'm 100% sure though that setting up Oracle on NT to work like Oracle onUnix is different so it is still possible that a bunch of OCP Unix Oracle DBA's could not setup a W2K Oracle database properly - tainting the OCP name in the process, ouch. -- Lyndon Tiu Quoting Alan Davey [EMAIL PROTECTED]: Hi Lyndon, Well I don't know about your setup, but I can connect just fine with the connect string you listed below on Win2K, Oracle 9.2. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 12/4/2002 2:09 PM, Lyndon Tiu [EMAIL PROTECTED] wrote: This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send
Re: how to modify query
Harvinder, Let's see what we can come up with: insert into t_suspended_txn select 'A', 'B' from dual where exists (select col1 from t_suspended_txn where col2 = 'A') Although I don't honestly know if dual exists in SQL Server (in Oracle it's a single row, single column table - you could easily create a dual in SQL Server), otherwise: insert into t_suspended_txn select distinct 'A', 'B' from t_suspended_txn where col2 = 'A' This would work but might do an unnecessarily large sort if t_suspended_txn contains many rows, otherwise: insert into t_suspended_txn select 'A', 'B' from t_suspended_txn where col2 = 'A' and rownum = 1 Although again, I don't know if SQL Server supports rownum as a pseudo column. Hopefully I've given enough ideas to find something that works though. Cheers, Mark. Harvinder Singh Harvinder.Singh@Metr To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] aTech.com cc: Sent by:Subject: how to modify query [EMAIL PROTECTED] 05/12/2002 06:04 Please respond to ORACLE-L Hi, Following code works in sql server but IF NOT EXISTS dosn't work in oracle how can we modify this code so that it should work on both sql server and oracle if not exists ( select col1 from t_suspended_txn where col2 ='A' begin insert into t_suspended_txn select 'A' , 'B' end Thanks --Harvinder Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Are Oracle courses required for Oracle Certification now?
Dennis, IIRC you receive certificate from Oracle only after completion of all 5 exams. Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 4:13 PM Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services
Experiences with global temp tables
Hi All, Oracle 8.1.6, NT 4.0, Forms/Reports 6i, Has anyone had any trouble using global temp tables in above environment or elsewhere where it cause Oracle to complete lock up. Only way out was to kill oracle.exe...not a good thing. I have found some postings on MetaLink that may be related supposely fixed in 9i. Comments please! Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: ORA-1653: unable to extend table - Why?
Kirti, Thanks for suggesting the Note, I'm reading it now. I tried replying to you directly but my thank you was blocked by your company's spam filter. I'm really curious to know what key word flagged it as spam. Oracle? Jay -Original Message- Sent: Wednesday, December 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L freelist groups is 1 -Original Message- Sent: Tuesday, December 03, 2002 9:59 PM To: Multiple recipients of list ORACLE-L What is the FREELIST GROUPS for the table? Waleed -Original Message- Sent: Tuesday, December 03, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when pctincrease != 0, or has that changed? My understand could be outdated. With LMT one doesn't have to worry about it. Have a Happy Thanksgiving. PS, I am in New York too, would love to meet you in person some time. Have you talked to Priscilla lately? Richard Ji -Original Message- Sent: Friday, November 29, 2002 5:29 PM To: Multiple recipients of list ORACLE-L how would coalescing help even if there were a lot of smaller free extents? Oracle would do the coalesce automatically, there would be no difference between manually coalescing or allowing Oracle to do it when a new extent was needed.
RE: Recipe for application design to run on RAC
I know I know (he says jumping up and down) Just did the 9i New Features class. The answer is lazy dynamic remastering. Over time, resources are gradually moved to the instance that is using them. More quotes from the manual: Should an instance leave the group, the background processes only remaster resources from the departing instance. Similarly, when a new instance joins the group, the resources are gradually remastered, adapting to the cluster workload. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 2:30 PM To: Multiple recipients of list ORACLE-L So when I access the fantasy football league on the espn web site-I go to schema2 because my team(s) are losing :-) I guess thats what I get when I picked a group of guys that are all on the injured reserve Seriously though--What if 50% of the blocks of data for schema1 are owned by db2? do you eventually see where ownership is transferred to the active node, reduced cache fusion activity and then transfer of blocks? Do the users on schema1 have to use the data on schema2 at all? I'm trying to see if not only are the users logically partitioned-but if your schemas offer any data partitioning to align with the schema1 and schema2 thanks! Greg -Original Message- Sent: Wednesday, December 04, 2002 2:05 PM To: Multiple recipients of list ORACLE-L H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference. Schema1 users have tns entry for db1 and fail over to db2 Schema2 users have a preference for db2 with a fail over to db1 This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application. None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine. Like I mentioned this is not a good example ... but this is how we did it in one of our major application. 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
When you say at least with O 9.2, does this mean we cannot do this in 8i ? We have 8i on EnTee and WinTuKee. Thanks. -- Lyndon Tiu Quoting Cornio, Georgette Ms USACFSC [EMAIL PROTECTED]: How do you startup shutdown the database on NT/W2K ? As I am able to, from the DOS Command Prompt set oracle_sid=orcl sqlplus /nolog connect / as sysdba startup pfile=initorcl.ora or shutdown immediate Just fine, at least with O 9.2 -Original Message- Sent: Wednesday, December 04, 2002 14:10 To: Multiple recipients of list ORACLE-L This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Cornio, Georgette Ms USACFSC INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of
RE: Are Oracle courses required for Oracle Certification now?
I certainly did not get anything after each exam, only after each level. I got the OCA level certificate and a letter from some Veep two weeks after I completed the second 9i exam (which I'm happy to say I did before the Sept. 1, 2002 deadline !!!). -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author:
RE: Recipe for application design to run on RAC
Title: RE: Recipe for application design to run on RAC Greg, FantasyFootball is a different beast and is not hosted on this database. This one deals with live scores and the bottomline ... g. There are only few tables that are shared by both schema, 50% ownership .. hasn't happened yet. We used to see huge global CR issues, but then it turned out to be a AIX issue and Oracle has a workaround for that (most unlikely parameter db_file_multiblock_read_count needs to be reduced). So far what we have seen is undeniably there is global cache traffic, but it isn't like some of our other instances. This way, each side of RAC gets a nice powerful machine to itself, all the resources to itself and is capable of handling at-least 5 times the load we put on it before it breaks a sweat. 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! -Original Message- From: Loughmiller, Greg [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 3:30 PM To: Multiple recipients of list ORACLE-L Subject: RE: Recipe for application design to run on RAC So when I access the fantasy football league on the espn web site-I go to schema2 because my team(s) are losing :-) I guess thats what I get when I picked a group of guys that are all on the injured reserve Seriously though--What if 50% of the blocks of data for schema1 are owned by db2? do you eventually see where ownership is transferred to the active node, reduced cache fusion activity and then transfer of blocks? Do the users on schema1 have to use the data on schema2 at all? I'm trying to see if not only are the users logically partitioned-but if your schemas offer any data partitioning to align with the schema1 and schema2 thanks! Greg *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1
RE: Are Oracle courses required for Oracle Certification now?
Title: RE: Are Oracle courses required for Oracle Certification now? I haveused the service level stuff also,but wanted to figure out the DOS Sqlplus stuff, soif there is a problem with the database, and need to do a startup mount or a recovery, or do all those nice command level stuff that was in svrmgr, I have NO idea how you would do those from the service level. -Original Message-From: Nick Wagner [mailto:[EMAIL PROTECTED]]Sent: Wednesday, December 04, 2002 16:59To: Multiple recipients of list ORACLE-LSubject: RE: Are Oracle courses required for Oracle Certification now? if the DOS command prompt doesn't work, try starting it at the services level. -Original Message- From: Cornio, Georgette Ms USACFSC [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 12:27 PM To: Multiple recipients of list ORACLE-L Subject: RE: Are Oracle courses required for Oracle Certification now? How do you startup shutdown the database on NT/W2K ? As I am able to, from the DOS Command Prompt set oracle_sid=orcl sqlplus /nolog connect / as sysdba startup pfile=initorcl.ora or shutdown immediate Just fine, at least with O 9.2 -Original Message- Sent: Wednesday, December 04, 2002 14:10 To: Multiple recipients of list ORACLE-L This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked "do you mean everyone that takes a class from you will be logging on". He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL
Re: Export from Oracle 8 to Oracle 7
David: You always want to use the older export utility when exporting from an older DB version, and use the new import untility to import into the newer database. To export from an 8.1.7 database, use the export utility from the version 7 database and export using a link to the new database (exp sys/pwd@linkname) I've done this from an 8.1.7 database into a 7.3.4 database. Don't know that it will work with 7.1.4, but you can try. Good luck! Barb (feel free to call at 303-892-5384) "Bartolo, David" [EMAIL PROTECTED] wrote: Hi allCan I export from a Release 8.1.7.0.0 oracle db to a Release 7.1.4.1.1?Is there a setting in the export utility to be backward compatible with V7?ThanksDavid-- Please see the official ORACLE-L FAQ: http://www.orafaq.com-- Author: Bartolo, DavidINET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now
Re: Are Oracle courses required for Oracle Certification now?
OK. Thanks. -- Lyndon Tiu Quoting Boris Dali [EMAIL PROTECTED]: Alan, I think what Lyndon meant is this SQLNET.AUTHENTICATION_SERVICES thing on MS Win that toggles your ability to connect with the syntax described. Comment it out and you might see something like ORA-1031 --- Alan Davey [EMAIL PROTECTED] wrote: Hi Lyndon, Well I don't know about your setup, but I can connect just fine with the connect string you listed below on Win2K, Oracle 9.2. -- Alan Davey [EMAIL PROTECTED] 212-604-0200 x106 On 12/4/2002 2:09 PM, Lyndon Tiu [EMAIL PROTECTED] wrote: This is unfortunate or maybe just it's just an urban legend? Hands on training, may it be $$$ or self taught at home is necessary. But $$$ is definitely not a requirement. I use Oracle at work and do more Oracle at home for my certs. I am able to log-in to Oracle on Linux and Solaris. Oracle WinNT/2K is another story since you cannot really use: sqlplus /nolog connect / as sysdba startup as you would on Unix. Maybe this is what ticked the instructor off - a bunch of Unix Oracle guys can't log into Oracle on NT? -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Alan Davey INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting
RE: ORA-1653: unable to extend table - Why?
I guess this is reason. pct_used and pct_free are very closed. after the deletion if the pct_free is just below 75% it will join the free list. Suppose the block header is Y bytes. And you have pct_free = 10% and pct_used = 75%, this means if a block is 30% free (70% used) it will have (4096 - Y ) * (90 - 70) = less than 800 bytes for insertion before reaching pct_free. And you have the average row length = 1895, so most of the allocations will fail. The problem is very small block size in comparison to row size and high pct_used. For now lower your pct_used. HTH Waleed -Original Message- Sent: Wednesday, December 04, 2002 3:39 PM To: Multiple recipients of list ORACLE-L 1895 -Original Message- Sent: Wednesday, December 04, 2002 2:34 PM To: Multiple recipients of list ORACLE-L What is the average row length? Waleed -Original Message- Sent: Wednesday, December 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L freelist groups is 1 -Original Message- Sent: Tuesday, December 03, 2002 9:59 PM To: Multiple recipients of list ORACLE-L What is the FREELIST GROUPS for the table? Waleed -Original Message- Sent: Tuesday, December 03, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all presenting :) I saw Priscilla about a month ago, haven't talked with her since. Rachel --- Richard Ji [EMAIL PROTECTED] wrote: Rachel, What I mean to say is when there are a lot of contiguous smaller free extents. Then coalesce will produce a larger free extent so Jay wouldn't have to add a datafile for his table to grow. On the automatically coalescing part, I believe SMON will only coalesce when
RE: Export from Oracle 8 to Oracle 7
Title: RE: Export from Oracle 8 to Oracle 7 Just use an Oracle7 client to do the exp -Original Message- From: Bartolo, David [mailto:[EMAIL PROTECTED]] Sent: Wednesday, December 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L Subject: Export from Oracle 8 to Oracle 7 Hi all Can I export from a Release 8.1.7.0.0 oracle db to a Release 7.1.4.1.1? Is there a setting in the export utility to be backward compatible with V7? Thanks David -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bartolo, David INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Are Oracle courses required for Oracle Certification now?
Yah. That's what we do on EnTee/WinTuKee. Also, on DOS prompt: oradim -startup -sid=SID -pfile=PFILE PATH But on EnTee, I think you can't do, at least I couldn't, maybe someone has tried this and it worked for them 8i on NT4/W2K: sqlplus /nlolog connect / as sysdba startup nomount create database database_name can you? ?? -- Lyndon Tiu Quoting Nick Wagner [EMAIL PROTECTED]: if the DOS command prompt doesn't work, try starting it at the services level. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Database up longer that host?
Give the man a cigar. (virtual one of course :) That is what I was looking for and makes unix uptime and db_uptime.sql report a compatible time frame. Thanks Jared. Stephen [EMAIL PROTECTED] 12/03/02 04:02PM Try: col uptime format a40 head 'UPTIME' select to_char(sysdate,'hh:miam') || ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, ' || trunc( (sysdate - trunc(sysdate)) *24 ,0) || ':' -- hours || trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', ' -- minutes || s.user_count || ' users' uptime from v$instance i, ( select count(*) user_count from v$session where username is not null ) s / Stephen Andert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 07:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database up longer that host? Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example up 4 days, 21:08 hours. In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen [EMAIL PROTECTED] 12/02/02 07:43PM You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED]
RE: ORA-1653: unable to extend table - Why?
Sorry, I've just seen these stats: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 My message completely contradicts with that fact, so forget about it except if the statistics are wrong. Too weird! let's know what you find. Is it partitioned? What is the extent size? Waleed -Original Message- Sent: Wednesday, December 04, 2002 5:49 PM To: Multiple recipients of list ORACLE-L I guess this is reason. pct_used and pct_free are very closed. after the deletion if the pct_free is just below 75% it will join the free list. Suppose the block header is Y bytes. And you have pct_free = 10% and pct_used = 75%, this means if a block is 30% free (70% used) it will have (4096 - Y ) * (90 - 70) = less than 800 bytes for insertion before reaching pct_free. And you have the average row length = 1895, so most of the allocations will fail. The problem is very small block size in comparison to row size and high pct_used. For now lower your pct_used. HTH Waleed -Original Message- Sent: Wednesday, December 04, 2002 3:39 PM To: Multiple recipients of list ORACLE-L 1895 -Original Message- Sent: Wednesday, December 04, 2002 2:34 PM To: Multiple recipients of list ORACLE-L What is the average row length? Waleed -Original Message- Sent: Wednesday, December 04, 2002 12:49 PM To: Multiple recipients of list ORACLE-L freelist groups is 1 -Original Message- Sent: Tuesday, December 03, 2002 9:59 PM To: Multiple recipients of list ORACLE-L What is the FREELIST GROUPS for the table? Waleed -Original Message- Sent: Tuesday, December 03, 2002 3:50 PM To: Multiple recipients of list ORACLE-L Just for grins, here's the level of support I'm getting on my Oracle TAR: -- You had stated earlier: 1/ After reanalyzing the table I saw the following stats in DBA_TABLES: num_freelist_blocks: 2266966 avg_space_freelist_blocks: 3895 Unless I'm misreading this I should have had over 8Gig available for inserts. 2/ I've had to add another data file and it has already grown to 600 Meg. If the table is only 600 mb, then there is no way that it can have 8 gb of free space. Since you have a lot of blocks with some free space, you may want to export and import the table back to re-org the table... -- Someone should inform these people that a table can consist of more than one datafile... -Original Message- Sent: Tuesday, December 03, 2002 11:54 AM To: Multiple recipients of list ORACLE-L I had one thought. The Freelist parameter for this table is only set to 1. Is it possible that if it gets tied up with contention for the freelist that it grabs a new extent? I see that some of these blocks are being written to, the num_freelist_blocks is now down to 2095705. But the new data file has grown to 600 Meg. I've opened a TAR to see what Oracle says but I'm not encouraged by the first question they sent me (which was asking to query dba_free_space). Jay -Original Message- Sent: Monday, December 02, 2002 6:14 PM To: Multiple recipients of list ORACLE-L One thing I haven't seen mentioned yet is what degree of parallelism is defined for the table? What is the next extent size set to? If the table is paralleled, EACH parallel worker will grab a next extent sized segment. (Been bit by this a few times...) How many indexes and are they in the same tablespace? Ron Thomas Hypercom, Inc [EMAIL PROTECTED] Each new user of a new system uncovers a new class of bugs. -- Kernighan JayMiller@TDWater house.comTo: [EMAIL PROTECTED] Sent by: cc: [EMAIL PROTECTED] Subject: RE: ORA-1653: unable to extend table - Why? 12/02/2002 02:04 PM Please respond to ORACLE-L Yep, I agree that coalescing is irrelevant in my current situation. In any event there was no free space until I added the additional datafile but there was the 8gig of space on the freelists. Jay -Original Message- Sent: Friday, November 29, 2002 8:54 PM To: Multiple recipients of list ORACLE-L Richard, if pctincrease is zero, and there are a large number of contiguous smaller extents, SMON will not automatically coalesce the tablespace. However, whether or not SMON does an automatic coalesce, if you need an extent that is larger than any of the small ones, Oracle will coalesce those smaller extents to make the one you need. so Jay would not have needed to add a datafile no matter what, if he was not doing a direct path insert. As for meeting in person there is a user group meeting on Dec 12 (check www.nyoug.org for details). You can meet me, and more importantly you can meet Tim Gorman, Dan Fink, Arup Nanda and Anita Bardeen, also of this list. They are all
RE: Are Oracle courses required for Oracle Certification now?
Are you getting a sheet after each exam showing how many you got correct for each section and your overall score? I received that sheet at the testing center after each exam. Other than that, you won't get anything from Oracle until you finish your final exam. It took me about a month to get my packet. At 01:13 PM 12/4/02 -0800, you wrote: Lyndon - I have completed 2 of the 5 Oracle8i exams. Hey - when I took each exam, the testing organization says that I should receive something from Oracle within a couple of weeks. Got nothing. Should I be worried? Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 1:10 PM To: Multiple recipients of list ORACLE-L Hey William, Why are you 40% OCP - does this mean you are an OCA? When did you take your very first 9i certification exam? If you took it before Sept. 1, 2002, the you're a 50% OCP. -- Lyndon Tiu Quoting DENNIS WILLIAMS [EMAIL PROTECTED]: My instructor in a recent Oracle Education class said that there were a couple of smart alecs that caused quite a stir within Oracle. After receiving their OCP, they couldn't log into a database, and claimed it was because they had never actually used Oracle. The instructor indicated that the new requirement (9i I believe) would require you to take at least one class. I asked do you mean everyone that takes a class from you will be logging on. He just grinned. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 11:25 AM To: Multiple recipients of list ORACLE-L Hey people! A friend of mine was just asking me about getting Oracle certified (I completed the Oracle 8i cerfication exams last year), he told me that to his knowledge Oracle requires that you've done Oracle courses before you can be certified now. I knew nothing about this, but can't believe Oracle would so blatantly make you take their over-priced courses. But maybe I'm just naive. Cheers, Kieran Murray CardBASE Technologies Limited® BIM House Crofton Road Dun Laoghaire Co Dublin -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Kieran Murray INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Lyndon Tiu INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). ** Scott Stefick UNIX Systems Administrator Oracle Certified Professional DBA Wm. Rainey Harper College 847.925.6130 ** --
DB corruption question
With Oracle 8.1.7, Solaris 8 OS. I have a shared storage device for storing all my datafiles, control files, redo logs, archive logs, etc.. everything except for the ORACLE_HOME and Oracle binaries. If I have the file system and database mounted to one machine, and have a fully open, available database running. What happens if someone else tries to mount the same files to another machine and start up the same database on it. (No OPS or RAC involved) I get the following error on the on thesecond machine... SVRMGR ORACLE instance started. Total System Global Area 272359584 bytes Fixed Size 73888 bytes Variable Size 88678400 bytes Database Buffers 183427072 bytes Redo Buffers 180224 bytes Database mounted. SVRMGR ORA-00283: recovery session canceled due to errors ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' ORA-01207: file is more recent than controlfile - old controlfile SVRMGR alter database open * ORA-01122: database file 1 failed verification check ORA-01110: data file 1: '/fs1/oradata/db1/system01_raw.dbf' ORA-01207: file is more recent than controlfile - old controlfile SVRMGR Server Manager complete. EXITING 1 Unable to start Oracle instance Will this corrupt the database? Will it harm/corrupt the original instance? What happens if someone tries to recover it at this point? Does it make a difference whether its a RAW or cooked file system? Any help is appreciated! Nick
RE: Database up longer that host?
Thanks, but I'd rather have a nice shot of Scotch. :) Jared Stephen Andert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/04/2002 03:39 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database up longer that host? Give the man a cigar. (virtual one of course :) That is what I was looking for and makes unix uptime and db_uptime.sql report a compatible time frame. Thanks Jared. Stephen [EMAIL PROTECTED] 12/03/02 04:02PM Try: col uptime format a40 head 'UPTIME' select to_char(sysdate,'hh:miam') || ' up ' || trunc( (sysdate - startup_time) ,0) || ' days, ' || trunc( (sysdate - trunc(sysdate)) *24 ,0) || ':' -- hours || trunc( (sysdate - trunc(sysdate,'hh')) *24*60 ,0 ) || ', ' -- minutes || s.user_count || ' users' uptime from v$instance i, ( select count(*) user_count from v$session where username is not null ) s / Stephen Andert [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 12/02/2002 07:58 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: Subject:RE: Database up longer that host? Govind, Actually, what I want it the same format as I have, I just want the numbers to match (or fall within) the numbers reported by the unix uptime command for example up 4 days, 21:08 hours. In my case, the unix uptime is saying the host was last restarted after the database startup_time reported in v$instance. Stephen [EMAIL PROTECTED] 12/02/02 07:43PM You may use following query will give you the uptime in hours and in minutes. select sysdate, startup_time, round( (sysdate - startup_time) *24*60 ,0 ) uptime_in_minutes, round( (sysdate - startup_time) *24 ,0) uptime_in_hours from v$instance SYSDATESTARTUP_TIME UPTIME_IN_MINUTES UPTIME_IN_HOURS -- -- - --- 20021202203918 20021202044608 953 16 Hope this is what you wanted. -Original Message- Sent: Monday, December 02, 2002 8:34 PM To: Multiple recipients of list ORACLE-L On Mon, 2 Dec 2002, Stephane Faroult wrote: Stephen Andert wrote: I use a script named db_uptime.sql (I think I got it from the list here) to calculate how long the database has been up. The output compares nicely to the unix uptime command. I hope that the query doesn't come from the list, because it is wrong. The error is to apply floor() before multiplying by 24 or 60 - you have tremendous rounding errors. My own database has not been up long enough to be 100% sure about it but I believe the following to be correct : Hi: Neither of the scripts works for me. Try this? select 'Host Name : '||host_name|| chr(10)|| 'Instance Name : '||instance_name|| chr(10)|| 'Uptime : ' ||floor(xx)||'days ' || floor( 24 * (xx - floor(xx)) ) || 'hours ' || round( 60 * (24 * xx - floor(24 * xx))) || 'minutes ' from ( select host_name,instance_name ,(sysdate-STARTUP_TIME) xx from v$instance ) / Meg Crocker -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Meg Crocker INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: [EMAIL PROTECTED] INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Stephen Andert INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of
RE: Recipe for application design to run on RAC
Dennis, I hate to see do all this jumping up and down but the dynamic re-mastering feature was not implemented in 9i. There is a view called V$GCSPFMASTER_INFO that is supposed to show which node was the master, which node is currently the master and how many times the resource has been re-mastered, but the view is never populated. This is one those if it's in the Doc. it may have been true in the past, It may be true now or it may true in the future. This one of those in the future features. Scott --- DENNIS WILLIAMS [EMAIL PROTECTED] wrote: I know I know (he says jumping up and down) Just did the 9i New Features class. The answer is lazy dynamic remastering. Over time, resources are gradually moved to the instance that is using them. More quotes from the manual: Should an instance leave the group, the background processes only remaster resources from the departing instance. Similarly, when a new instance joins the group, the resources are gradually remastered, adapting to the cluster workload. Dennis Williams DBA, 40%OCP Lifetouch, Inc. [EMAIL PROTECTED] mailto:[EMAIL PROTECTED] -Original Message- Sent: Wednesday, December 04, 2002 2:30 PM To: Multiple recipients of list ORACLE-L So when I access the fantasy football league on the espn web site-I go to schema2 because my team(s) are losing :-) I guess thats what I get when I picked a group of guys that are all on the injured reserve Seriously though--What if 50% of the blocks of data for schema1 are owned by db2? do you eventually see where ownership is transferred to the active node, reduced cache fusion activity and then transfer of blocks? Do the users on schema1 have to use the data on schema2 at all? I'm trying to see if not only are the users logically partitioned-but if your schemas offer any data partitioning to align with the schema1 and schema2 thanks! Greg -Original Message- Sent: Wednesday, December 04, 2002 2:05 PM To: Multiple recipients of list ORACLE-L H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference. Schema1 users have tns entry for db1 and fail over to db2 Schema2 users have a preference for db2 with a fail over to db1 This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application. None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine. Like I mentioned this is not a good example ... but this is how we did it in one of our major application. 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: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Scott INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Recipe for application design to run on RAC
Thanks, Raj. H... it is probably not an good example ... Why not? On the contrary. I am sure damanagement here would love to here this. Besides it fully supports Oracle's statement that application can be migrated to RAC as is (as I think Hemant mentioned). Wait... did you say 9i? release 2? recently? - may be it's a Christmas magic that made it happen for you? (although those sceptical might say that it had to do with your careful app partitioning/segmentation rather than a festive season) On a more serious note the following guidelines look interesting: http://download-west.oracle.com/docs/cd/A97630_01/rac.920/a96600/migrate.htm#1013313 Migrate to RAC ... unless your application was specifically designed to not use cluster database processing. I wonder why would somebody do that? --- Jamadagni, Rajendra [EMAIL PROTECTED] wrote: H... it is probably not an good example but we too have a (couple of) mission critical app (affects on air production) running on 9i RAC. One of which has two major schema. We logically partitioned the application such that, for two groups of people 9accessing one schema each) we gave them a preference. Schema1 users have tns entry for db1 and fail over to db2 Schema2 users have a preference for db2 with a fail over to db1 This effectively allows us to do load balance, they don't share too much data, so traffic through interconnect is manageable. If need be, we just shutoff listener on one side, and everyone fails over to the other side while we can perform maintenance. All their applications are written in VB, JAVA so they handle fail over from within application. None of the people involved in the design worried about which side of RAC they will be on and how the DML activity affects etc etc. They designed a plain application with a good design and it is working fine. Like I mentioned this is not a good example ... but this is how we did it in one of our major application. Raj __ Rajendra JamadagniMIS, ESPN Inc. Rajendra dot Jamadagni at ESPN dot com Any opinion expressed here is personal and doesn't reflect that of ESPN Inc. QOTD: Any clod can have facts, but having an opinion is an art! *This e-mail message is confidential, intended only for the named recipient(s) above and may contain information that is privileged, attorney work product or exempt from disclosure under applicable law. If you have received this message in error, or are not the named recipient(s), please immediately notify corporate MIS at (860) 766-2000 and delete this e-mail message from your computer, Thank you.*1 __ Post your free ad now! http://personals.yahoo.ca -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Boris Dali INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Recipe for application design to run on RAC
comments inline... - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, December 04, 2002 8:53 AM Whoa! Tim, thanks a lot for sharing this. Quite an insight. So SELECTs are not a concern. Well, not directly. They do not directly cause buffers to move around. But they can cause a PCM lock to be downgraded from exclusive to shared, thus forcing the instance which had the lock in exclusive-mode to request that it be returned to exclusive. Thus, while the block doesn't leave the Buffer Cache while it's lock is downgraded, it still induces some fiddling back and forth between the instances... INSERTs are a come and see DBA thing (physical design issue). Yes. Prior to 9i, the mechanisms to use are FREELIST GROUPS. Very much eliminates inter-instance contention during INSERTs in OPS... Though I haven't had a chance to play with it yet, the bitmap-oriented 9i replacement for freelists and freelist groups, called automated segment-space mgmt or ASSM, is apparently still only half-baked, purportedly producing all kinds of unexpected results in space wastage and other things. So, in 9iRAC, you might still want to consider using FREELIST GROUPS over ASSM. Again, just my uninformed opinion based on hearsay... DELETEs are relatively infrequent and many get translated into UPDATE (logical as opposed to physical delete). Well, both DELETEs and UPDATEs have the same characteristics from a cache-coherency perspective, so it's six-of-one, half-dozen-the-other... Application partitioning as you clearly explained in your email... Would it be closer to a logical or physical design? I've always tried to use the word segregation as opposed to partitioning, though I slip up occasionally. The word partitioning makes people think about the Partitioning option, which is definitely not intended. There is no relationship between Oracle's Partitioning option and the type of application segregation I'm trying to describe. There are two ways to avoid the latency resulting from OPS pinging or RAC cache-fusion: by happenstance or by planning. Well, actually there are three ways: use OPS/RAC on OpenVMS and neither OPS pinging nor RAC cache-fusion will result in latency. But let's assume that is not an option for you and consider just the other two ways... By happenstance, I mean just hoping that relatively random activity from multiple instances against the same datafiles avoids two (or more) instances wanting the same block for insert, update, or delete. This is pretty rare, but I'm sure it can happen. After all, even a blind dog finds a bone occasionally... By planning, essentially you want your application to somehow enforce that sessions on a database instance only UPDATE or DELETE rows that were INSERTed by that instance. That way, the block buffers are never pinged or cache-fusion shipped to another database instance. There may be some fiddling of the parallel cache-management (PCM) locks if other instances want to read those blocks, but that is less of a concern. So, however your application logic or business practices can ensure that blocks are UPDATEd or DELETEd by the instance from which they were INSERTed, that is what is necessary. Perhaps you can dedicate certain database sessions to specific groups of data (i.e. application module or groups of customers). That doesn't necessarily work all the time; take Oracle Apps as an example, where all application modules inevitably meet in the Application Object Library (AOL) and Foundation (FND) schemas. The surest way I've seen to segregate parts of an application is by making use of data routing capabilities in the middle-tier application-server or transaction-processing monitor layer. If the middle-tier is capable of data-routing, then you can identify each user transaction by the data values and route the transaction to a session connected to one database instance or the other. This is the surest way to accomplish perfect segregation of different database blocks to different instances, when the end-users can't do it. This is usually the case with interactive, OLTP environments. Of course, another way to route transactions is by forcing such rules of application segregation during INSERT, UPDATE, and DELETE by careful data-routing during batch processing. This is the way that it can be implemented for data warehouses... Seems like something that data modeler/architect should be aware of. So in a sense all modeler needs to worry about is UPDATEs as far as future physical implementation for RAC is concerned? Both should be aware, but the decision to include middleware capable of data-routing when designing an OLTP application is usually up to the architect more than the data modeler, I think. Setting up batch processes to perform the data-routing functionality for DW applications is usually up to application developers, I think. The data modeler might have some say
Online Index Rebuild Tuning
Folks, I know that when creating indexes a couple of settings such as SORT_AREA_SIZE can have a big impact on duration. What settings apply during online rebuilds? Are the rules the same? What tips do you have? Basically we have some very large indexes in an OLTP system (several indexes are across ~250m rows, several GB in physical storage) which have fairly low density due to deletes and updates. In looks like the time has come to rebuild then to gain some performance. Any other suggestions regarding tricks to avoid this, etc would be greatly appreciated. Thanks, Mark. PS: If you going to suggest things which are version specific we're dealing with 8.1.7.4 on Solaris. Privileged/Confidential information may be contained in this message. If you are not the addressee indicated in this message (or responsible for delivery of the message to such person), you may not copy or deliver this message to anyone. In such case, you should destroy this message and kindly notify the sender by reply e-mail or by telephone on (61 3) 9612-6999. Please advise immediately if you or your employer does not consent to Internet e-mail for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of Transurban City Link Ltd shall be understood as neither given nor endorsed by it. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Mark Richard INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Something that might be of use
Hi Stephen The program is functional but not necessarily elegant. Of course, no guarantees about anything are made. If you make any improvements, I would be most appreciative if you sent them. If you need this sort of thing you might consider having a look at the freeware DBATool. It is designed to do exactly what your program does - but it has GUI interface and a lot finer control over the manipulation of the DDL. You can independently change or remove every component of a tables storage clause independently and can even use wild cards. For example: all tables get 1M extents except for tables like XYZ% which get 100K extents except for tables XYZ1 and XYZ2 which get 10K extents. You can also put OR REPLACES automatically on packages procs etc, reset sequences to known starting values, and change the target of DB links. Its all driven by rules - so once you set it up you can save and reload the rules anytime you need them. DBATool: http://www.DataBee.com/dt_home.htm Regards Dale [EMAIL PROTECTED] We often need to refresh test and development databases with exports that have extent sizing a lot bigger that what we want. In test and ESPECIALLY dev, space and file system availability often require us to just get something working without regard for performance. In these cases, extent sizing in the exports often prevents us from loading even a row-less import into the test/dev database. The following C program was written to deal with those situations. I have used it enough that I think I can go ahead and toss it out to the world. The program is functional but not necessarily elegant. Of course, no guarantees about anything are made. If you make any improvements, I would be most appreciative if you sent them. -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).