Re: OT: Solaris: Finding the cause for disk space growth
i normally go to the mount point (ie highest level dir for that disk) and issue: du -k | sort -n that way you see where the space is going in descending sequence good luck, steve "Naveen, Nahata (IE10)" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/23/2004 03:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: OT: Solaris: Finding the cause for disk space growth Hi All, Sorry for an OT question, but nowhere else to go. Pretty new to Solaris so might be a naive question. Need a pointer on how to do this. The disk space in the machine is constantly decreasing. And I want to know which files/directories are growing. Is there any way to find out? Regards Naveen
RE: Re: parallel index creation again:in which case, can we use p
tom, if the process is IO bound (ie consumes little cpu) then you can achieve a lot. thanks, steve "Mercadante, Thomas F" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/12/2003 02:23 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Re: parallel index creation again:in which case, can we use p If you only have one CPU, then is parallel either not supported, or simply a waste of time? I actually thought it was not supported. If you only have one CPU, what do you expect to gain? Tom Mercadante Oracle Certified Professional -Original Message- Sent: Wednesday, February 12, 2003 12:54 PM To: Multiple recipients of list ORACLE-L p My experience shows that a parallel degree of less than 4 is nearly always slower than serial. I would recommend tring parallel degree of 4. -Original Message- Sent: Wednesday, February 12, 2003 10:59 AM To: Multiple recipients of list ORACLE-L parallel with single cpu env? Michael Ivanov, Hi, Thanks for your reply. In fact, I builded the index several times like, and the result is persistent across difference test case: So, I think buffer is not the cause of the parallel execution slower. But I really do not get other parameter to tune:( SQL> set term on timing on echo on feedback on SQL> alter session set sort_area_size = 1; Session altered. Elapsed: 00:00:00.01 SQL> create index idx_serial on viewcount( SID_LIST) nologging parallel (degree 2) tablespace pqind; Index created. Elapsed: 00:18:01.36 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.16 SQL> SQL> create index idx_serial on viewcount( SID_LIST) nologging tablespace pqind; Index created. Elapsed: 00:06:48.04 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.06 SQL> SQL> create index idx_serial on viewcount( SID_LIST) nologging parallel (degree 2) tablespace pqind; Index created. Elapsed: 00:14:51.92 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.13 SQL> SQL> create index idx_serial on viewcount( SID_LIST) nologging; Index created. Elapsed: 00:06:26.23 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.06 SQL> SQL> create index idx_serial on viewcount( SID_LIST) nologging parallel (degree 2) tablespace pqind; Index created. Elapsed: 00:14:44.58 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.13 SQL> SQL> create index idx_serial on viewcount( SID_LIST) nologging tablespace pqind; Index created. Elapsed: 00:06:49.09 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.07 SQL> SQL> create index idx_serial on viewcount( SID_LIST) nologging parallel (degree 2) tablespace pqind; Index created. Elapsed: 00:14:46.79 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.14 SQL> SQL> create index idx_serial on viewcount( SID_LIST) nologging tablespace pqind; Index created. Elapsed: 00:06:44.51 SQL> drop index idx_serial; Index dropped. Elapsed: 00:00:00.07 Regards zhu chao msn:[EMAIL PROTECTED] www.happyit.net www.cnoug.org(China Oracle User Group) === 2003-02-12 18:40:00 ,you wrote£º=== >Dear Chao. >Did you try change order of index's creating- first noparallel, second with parallel. I think you will look other results. > >> hi, dba friends: >> some paper said, pqo should only be used in SMP machines, while others >> say, We can also use pqo in uniprocessor machines in some case. I am trying >> to use parallel index creation in the following env: >> >> Dell 1650 with 3 scsi160 disks and 1 CPU and 2G memory. >> Oracle 9.2 >> Table contains 2200 records,1.2GB >> Table tablespace contains 3 datafiles , 400M, 400M and 600M, on seperate 3 >> disks. Index tablespace contains 3 datafiles, 200M, 200M and 200M on >> seperate 3 disks. >> >> >> SQL> set term on timing on echo on feedback on >> SQL> alter session set sort_area_size = 1; >> Session altered. >> Elapsed: 00:00:00.01 >> SQL> create index idx_serial on viewcount( SID_LIST) nologging parallel >> (degree 2) tablespace pqind; Index created. >> Elapsed: 00:18:01.36 >> SQL> drop index idx_serial; >> Elapsed: 00:00:00.16 >> SQL> create index idx_serial on viewcount( SID_LIST) nologging tablespace >> pqind; Elapsed: 00:06:48.04 >> This machine is exclusived used my me and It seems that PQO is rather >> slower than single thread. So is it still possible to use PQO on single >> processor machines? Please share your experience and idear. >> Thanks. >> >> Wait event like: >> >> Top 5 Timed Events >> ~~ >> Total Event Waits Time (s) >> Ela Time --
Re: database file sizes....more of smaller size or less of larger size?
i generally will not permit a file to exceed 2 gig for reasons of managability. eg since a file is the smallest recovery unit, i want something small enough so that i can easily recover it without incurring too much downtime. if i need to move some files around, 2 gig is small enough so that i can do it in parallel if need be it may be difficult to find space for a very large file in the event that you need to clone it for some reason. thanks, steve Rachel Carmichael <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/12/2003 02:04 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: database file sizesmore of smaller size or less of larger size? the ever popular answer "it depends" how large are the tables you are storing in these datafiles? Is this a data warehouse where you will be storing massive amounts of data? (1000 2GB datafiles to store one table's worth of data is somewhat obscene) Is it a large database? Heavily used? OLTP? I'm not making fun, it's just that a blanket statement "what are the pros and cons" just doesn't make sense --- [EMAIL PROTECTED] wrote: > Hi DBAs, > > Oracle 8.1.7 WinNT > > I would like pros/cons on datafile sizes. It is better to have more > of less > size or less with larger sizes and why? > > Thanks > Rick > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > Author: > INET: [EMAIL PROTECTED] > > Fat City Network Services -- 858-538-5051 http://www.fatcity.com > San Diego, California -- Mailing list and web hosting services > - > To REMOVE yourself from this mailing list, send an E-Mail message > to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in > the message BODY, include a line containing: UNSUB ORACLE-L > (or the name of mailing list you want to be removed from). You may > also send the HELP command for other information (like subscribing). > __ Do you Yahoo!? Yahoo! Shopping - Send Flowers for Valentine's Day http://shopping.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Rachel Carmichael INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: multiple oracle homes
maybe multi-user oracle homes would be a problem for stuff that's in oracle base such as the inventory. during an install/upgrade this common data needs to be updated. i suppose i would work ok if u were careful with permissions, but it would be just one more thing to go wrong. thanks, steve Ray Stell <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 02/07/2003 01:19 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re: multiple oracle homes On Fri, Feb 07, 2003 at 07:54:24AM -0800, DENNIS WILLIAMS wrote: > Ray - My 2 cents worth. Don't ever use another username besides Oracle. Had > a bad experience :-) Would you mind expanding on that, other people say the multiple userid idea works for them. They may be surprised one day, I can imagine. I can imagine blowing one's foot off the other way, also. Thanks. === Ray Stell [EMAIL PROTECTED] (540) 231-4109 KE4TJC 28^D -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ray Stell INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Making dispatchers re-read tnsnames.ora?
jeremiah, some good points. we use onames becuase we have many workstations spread thru out our org (we are a med center/university) to which we dont have access. not only do we not have access to them, we dont even know where they are or how many there are. we also have the problem that some local adminstrators of these workstations load oracle clients that create their own tnsnames files (i guess they are using canned vendored apps) and in so doing stomp all over our tnsnames file. all we do now is to ensure these admins have a copy of our sqlnet.ora file (which specifies to look at tnsnames & then onames in its search order) which they make sure is in the current TNS_ADMIN directory so, in our case, its not feasible to distribute the tnsnames file. thanks, steve Jeremiah Wilton <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/30/2003 07:30 PM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: RE: Making dispatchers re-read tnsnames.ora? Well, my first objection to ONames was just in the context of solving my problem. Dispatchers cache addresses for outgoing connections, whether they cache them from tnsnames.ora or ofrom Oracle Names. Or so I understand it. If someone knows differently about Names then I would like to hear about it. As for the limitations of names... Yes, you can have the local host caching of directory entries. My objection is more to adding a new service with added equipment and expense where flat files actually do a better job. Sitations with very high connection rates pose a problem. Using a pool of application servers, there may be a need for multiple listeners to handle the load if a connection pooling technology is not in the picture. In such a situation it is helpful for purpises of scalability and availability to segregate a large number of app servers into "cells" of, say, 10 or 20 servers each. You want each of these cells to be inidividually maintainable, and to be able to be put in and taken out of service independently, so that overall aailability for the application base is always maintained. In the cell model, a listener or set of listeners is created FOR EACH CELL. The TNS entries vary from cell to cell for that one service, because they specify different listeners. The advantages to doing this are many. With a cell out of service, you can take down a listener for whatever reason with no impact to the running application. And if a listener or set of listeners becomes saturated, the majority of inbound connections are unaffected by the problem, thus limiting the scope of a fault. AFAIK, you can't really do this in ONames without making up a different service name for every cell's listeners. Now, say your service is so important that you don't want all the back-office Duke Nukem and Doom sessions saturating the network and interfering with the application traffic. In reaction, you create a totally separate dedicated network for the most important systems in the company to communicate with the database server. You add a network interface card with its own IP addfress, but you leave the old one there so that the back office people can make occasional database queries. Naturally you will want separate listeners servicing the "importantnet" than service the old office LAN. In ONames, you would again have to name the same database's services on different networks differently. So then I ask, what advantage is there to Names? You can change things in a central location. There are no files to push around. Well, pushing files isn't really bad once you have a good set of scripts to do it. And flat files are a really reliable sevice. If you screw up a tnsnames.ora file change, you can catch the mistake by just testing with TNS_ADMIN, rather than taking down the whole company by fatfingering an ONames change. So in short, why again do I want yet another service that needs to be available (or the local caching up to date) to keep people connecting to my databases (especialy if I have to set up a separate service name for every little special situation)? -- Jeremiah Wilton http://www.speakeasy.net/~jwilton On Thu, 30 Jan 2003, Jesse, Rich wrote: > Not that ONames doesn't have it's shortcomings, but I'm not sure how ONames > is a single point of failure. Even in our little 35-alias ONames repository > with only the root region, we have a secondary Names Server. With local > checkpoint files, the repository is not required for continuous access, so > there's no SPoF there. > > Could you expound a bit on that, Jeremiah? > > Thanks, > Rich > > > Rich Jesse System/Database Administrator > [EMAIL PROTECTED] Quad/Tech International, Sussex, WI USA > > > -Original Message- > Sent: Thursday, January 30, 2003 10:10 AM > To: Multiple recipients of list ORACLE-L > > > On Thu, 30 Jan 20
Re: data migration strategies
vijaya, the ideal way of limiting down time is to design a process that : 1) unload the legacy databases while they are available to users 2) load the oracle database 3) shtudown legacy systems 4) unload ONLY the changes from the legacy databases that were made since the unload in step 1 (insert,update & delete triggers an legacy tables canbe used to id changes since last unload) 5) load the oracle database note that steps 4 & 5 can be iteratively (ofcourse without the shutdown) until the amount of data remaining is manageable since it is often difficult to identify changes from a certain point in time (this has to done at the application level) the above steps may not be possible. But often times you can take this approach for some of your data, there by reducing some of the downtime of the conversion. you need to determine which tables will be on the critical path. ie which are your largest tables. for the very large tables find some way of logically splitting them into smaller chunks that can be unloaded in parallel be sure the network connectivity between you machines is at its optimum. if the network speed is the bottleneck, parallelism will not help you. it may be worth your while to have the machines physically connected with multiple NICs you need to design a process and run it to determine where you bottlenecks are so that they can be addressed piping is also a useful tool to reduce data transfer times. for example, send the unload (eg bcp) output to stdout and pipe that directly into the sqlldr process. timing is important. take advantage of index build time to transfer other table data into oracle (especially useful if the network is you bottle neck) design you big oracle tables such that partitions are indendent of each other (ie no global indexes) so that they can loaded & indexes built indepednently of each other have multiple temp tablesapces that reside on different controllers that each loader/index builder will also help i could go on forever. what to do really depends on teh specifics of your system. but you will need to test & try different techniques to determine whta works best for you btw, i dont know of any doc (other than the std oracle docs) that may help you good luck, steve "Vijaya Chander V.S" <[EMAIL PROTECTED]> 01/30/2003 11:57 PM To: <[EMAIL PROTECTED]> cc: Subject: Hi Stephen Evans Hi Stephen Evans, Thank you for your earlier response to the migration issue.Here i want to eloborate this specific requirement so that you can advise us more.The requirement goes like this: We have a Sybase database and one non-proprietory DB in our old system and these two database are being used by multiple applications. Now a new application was built which has all the features of old applications with some enhancements which works on Oracle 9i DB(New DB). Our task is to migrate the data from Sybase and non-proprietory DB's to Oracle. 1.An important thing is that the data models of all the 3 DB's are different, i.e., column data in in old DB's may not go into same table in new DB, it may go into other table's column. 2. Some objects like procedures/functions/packages need to be moved into new DB. These are some sugggestions/solutions for the above requirement: Sybase to Oracle 1. Oracle Migration Work Bench(OMWB) is very good at transferring objects & data from sybase to oracle. Its a free tool from Oracle and if needed we can download it for testing. 2. Another option is to use Bulk Copy utility(BCP) to get the data out of Sybase into some flat files, then use SQL*Loader to get the data into some Oracle staging tables. Then use pl/sql procs to move the data to it's final destination. Non-proprietory DB to Oracle If we need to migrate from non-proprietory db to oracle then writing some programs in non-proprietory language which can dump data into files and then using SQL*Loader to get the data into the production tables. Please give your suggestions like which is better way of doing it as we need to do this migration with very less downtime. Can we parallelyze this process of data loading. If yes how? Please forward some pointers like documents or URL's to howto go about this migration and how much effort goes into it. > Regards, > Vijaya Chander V.S > Oracle DBA > Infosys Technologies Limited > -Original Message- From: Stephen Evans [mailto:[EMAIL PROTECTED]] Sent: Thursday, January 30, 2003 PM 07:25 To: Multiple recipients of list ORACLE-L Subject: Re: data migration strategies vijaya, partition your bigger tables so that they can be loaded by sqlldr via direct path in parallel
Re: data migration strategies
vijaya, partition your bigger tables so that they can be loaded by sqlldr via direct path in parallel drop indexes (especially global indexes) before loading do some testing first to determine optimum number of parallel streams from a cpu usage standpoint and an io contention standpoint. try and separate segments that are loaded in parallel by disk & controller consider striping (raid 1+0) across 7 devices or so. good luck, steve "Vijaya Chander V.S" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/30/2003 03:58 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: data migration strategies Hi, Thank you for your responses. What kind of strategies should be followed while migrating data from Sybase to Oracle and non-propriatory databases to Oracle so that the down time is as low as possible. The Sybase database size is 2TB and other DB's total make up to 400GB any pointers will be helpful to us... regards, Vijaya Chander V.S -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vijaya Chander V.S INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Re[2]: undo tablespace
breno, i believe the 'no logging' option only applies to data that is direct loaded into your tables therefore, you may be able to bypass logging if you used sqlldr or 'create table as select' good luck, steve "Breno A. K. Magnago" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/29/2003 09:09 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Re[2]: undo tablespace Mike, I asked it because I have a problem. Any insert data in UNDO tablespace generate insert in REDO Files. Is is correct ? When I execute a high procedure, many inserts in UNDO tablespace ocurres, so many inserts in REDO´s are genereate. I want to avoid this REDO´s generation. My tables and indexes are in NOLOGGING, but I high value of REDO are generate (100 MB each 20 minutes). It is desnecessary. Oracle 9i / NT -- Breno A. K. Magnago mailto:[EMAIL PROTECTED] Mercantil de Alimentos Soares Wednesday, January 29, 2003, 10:29:15 AM, you wrote: HMNI> Breno, HMNI> There's no way to do this because it's the central pillar of Oracle's read HMNI> consistency mechanism. HMNI> It's possible to minimise or suppress redo but undo is out of your control. HMNI> regards, HMNI> Mike Hately HMNI> -Original Message- HMNI> Sent: 29 January 2003 11:39 HMNI> To: Multiple recipients of list ORACLE-L HMNI> I have a high procedure (many INSERT's and UPDATE´s). HMNI> This procedure generate insert's in UNDO TableSpace for rollback. HMNI> I want to know if exists any way for don´t generate insert´s in UNDO HMNI> Tablespace. HMNI> Oracle 9i / NT HMNI> Thanks. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Breno A. K. Magnago INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: migration from Sybase to Oracle
vijay, oracle has a free product call 'Oracle Migration Workbench' that i understand is very good at transferring objects & data from sybase to oracle. however, i do believe that schemas (ie table structures) need to be the same - or at least will be created the same in the oracle database. you could possibly use this product to at leastget your data into oracle & then massage it into your new structures. good luck, steve "Vijaya Chander V.S" <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 01/29/2003 07:49 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: migration from Sybase to Oracle Hi Everyone, We need to migrate data from a Sybase DB to Oracle 9i DB and both the data models defer a lot. Is there any tool available for this kind of migration. Can we do this migration with out any tool. If yes please let me know like how should we go about this migration. If there are any websites/ checklist on effort estimation till implementation please share with me. Thanks in advance. Regards, Vijay -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vijaya Chander V.S INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Installer does not run on Win 2k Service Pack 3
this sounds weird, but i heard that installs will not work via terminal services for 8.1.7 good luck, steve [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 01/16/2003 09:08 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject: Installer does not run on Win 2k Service Pack 3 Hi DBAs, Has anyone had trouble installing Oracle 8.x on Win 2k Service Pack 3?. When I tried installing 8.1.6 and 8.1.7 the installer does not start. Oracle 9.x installs fine. I do not know if it related to SP3 or not as I was able to install on similar server with SP 2. Thanks Rick -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
