RE: Implementing different document types with different attribut
Attributes for documents? Here are few of many possibilities: 1) @#$! 2) Stupid 3) Unintelligible 3) Illiterate 4) Unclear 5) CYA 6) Inscrutable 7) Laughable 8) Meaningless 9) PHB-ish -- Mladen Gogala Oracle DBA -Original Message- Mercadante, Thomas F Sent: Thursday, August 07, 2003 10:54 AM To: Multiple recipients of list ORACLE-L Tim, Can you provide some examples of the attributes for the different document types? If I were designing something, I would look for common attributes among all the documents to see if they can be contained within the same table. There would be one column within that table that would indicate what type of document it is. The other way to go would be to create one table for each type of document. Lets say we are talking about Word, PDF and HTML documents. You could create one table for each type of document, and store whatever info you need in each table. I think we all are guessing in the dark here. We need more info from you to be able to help you. Tom Mercadante Oracle Certified Professional -Original Message- Sent: Thursday, August 07, 2003 10:45 AM To: Multiple recipients of list ORACLE-L attributes attribute is a specific part of an index-file, but those attributes are different for all document types -Original Message- Sent: donderdag 7 augustus 2003 16:15 To: Multiple recipients of list ORACLE-L attributes What do you have as an example of an "attribute"? "Vernaillen Tim" @xgs.be> cc: Sent by: Subject: Implementing different document types with different attributes ml-errors 08/07/2003 09:34 AM Please respond to ORACLE-L Hello I've an installation/implementation question! We've to analyse 50 document types, in total those 50 has 70 different attributes. We don't want to put all those document types into one table, because more than the half (35) of the attributes are not always used for each document type. This will have to much disk space for each record, if most of the fields are just blank. Has anyone suggestions how to build our table-structure? I've heart something about FlexFields, what are they? Takes every field diskspace, even if it's blank (null)? Thanks in advance for the response! Tim -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Thomas Day INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Vernaillen Tim INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mercadante, Thomas F INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, prin
RE: Consolidating Servers
Title: RE: Consolidating Servers David, Can you create the clone from a production backup as a standby database? Then when it's time to switch over, just apply the last few archive logs from production, turn the clone on, and test. This way you can do most of the cloning at your convenience. We did this when we were moving database storage from the east coast to the west. Henry -Original Message-From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]On Behalf Of David WagonerSent: Wednesday, August 06, 2003 3:34 PMTo: Multiple recipients of list ORACLE-LSubject: RE: Consolidating Servers This is exactly what I am working on right now! We have to consolidate down from about 5 servers to 2 (Prod. and Test/Dev.). My approach is to just move (clone) the DBs first. That's a job in itself, considering that the production DBs need to be moved during weekend hours. Leave original DB on original server just in case something fails. Take a cold backup, move files to new server, rebuild control file from trace to create clone. Point apps at clone and test. If all is well, archive original DB to tape for a month or two to be safe. By the way, this required me to install 4 versions of Oracle (8.1.7 to 9.2.0.3) in 4 Oracle Homes on the new Production server. Upgrading all to 9iR2 is another project. Best regards, David B. Wagoner Database Administrator Arsenal Digital Solutions -Original Message- From: Eberhard, Jeff [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 06, 2003 2:29 PM To: Multiple recipients of list ORACLE-L Subject: Consolidating Servers Just got out of a meeting with my manager. He had just finished meeting with our Oracle rep and has finally figured out that we don't have enough licenses (I've always asked him what we have and he's never shared it with me, always just "I've gotten it taken care of"). We have 80 and with our current/potential configuration we are going to need 300. Anyways, to save money he decides that we need to take our databases and consolidate them to two or three servers (from 7). Most of the database are fairly small (100-300Meg) so shouldn't be too bad. Actually it should be pretty fun (if I didn't already have 5 full-time jobs to do). Anyone had to do the same thing? What are some concerns? Should I shoot for the moon and upgrade them all to 9i at the same time or have several versions (7.3, 8.0, 8.1.7) on the same server? Any comments would be greatly appreciated. Thanks, Jeff -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Eberhard, Jeff INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RAC DBCA hangs while creating cluster database
Hi Listers, I am trying to set up a two-node RAC on Windows 2000 Advanced Server on Proliant DL 580 Servers. I am following the metalink document 178882.1 and Harrison B. Redhouse’s document DIY Multi-Node RAC on a single Windows PC downloaded from www.oaktable.net. I am having two separate nodes and hence there was no need to use VMvare to simulate two nodes as mentioned in Harrison B. Redhouse’s document. I ran through all the steps as mentioned in both the documents. But when I am using DBCA to install cluster database on the first node I am getting the following error when I click FINISH button: The filepath S:\Oradata\CLUST\CWMLITE01.DBF is invalid. Please check the permissions. I have stopped and restarted the GSD service. I have also installed the Oracle 9.2.0.3 patch and created the listener successfully. I am trying to install the cluster database through the command Dbca –datafiledestination S:\oradata. I am able to see the shared disk from both the disk manager and Windows explorer. I am really stuck up with this problem. Any pointers as to what am I missing would be highly appreciated. Looking forward to hear from any of you soon. Thanks and Regards, Ranganath MailFiler [RK-7ARFH54]
Re: quick suggestions for tuning ?
But his BCHR is 99.57% ! On Sun, 2003-08-10 at 07:44, Connor McDonald wrote: > Its not really rocket science here... > > CPU is at the top of the timed event - and what causes > CPU (or is the most common cause) - logical I/O. 54 > million consistent gets later down in the report > probably a bit of a giveaway there :-) > > Next section in the report is some nice queries that > use up 4 or so million buffer gets. Good ones to > start with... As you've already noticed, no bind > variables. > > Then some other miscellaneous things - look at how > much free memory you have in most of your pools "SGA > breakdown difference" - might be able to use that > better elsewhere. > > cheers > connor > > > --- Prem Khanna J <[EMAIL PROTECTED]> wrote: > Guys, > > > > I have attached statspack report here. > > The ENV is Oracle 9.2.0.3 / Win2k AS - SP3. > > > > 1.Can you tell me which INIT parameters are to be > > changed > > which will give improved performance ? > > > > 2.can someone give a rough idea about where the > > bottlenecks are ? > > > > I read the doc "228913.1 - Systemwide Tuning using > > STATSPACK Reports" > > and gave a try with YAPP also. > > > > Bind vars are to be used - that is one i found out > > from statspack > > report. > > > > just new to statspack and so i'm seeking ur > > suggestions. > > > > Regards, > > Jp. > > > > > ATTACHMENT part 2 application/octet-stream > > > = > Connor McDonald > web: http://www.oracledba.co.uk > web: http://www.oaktable.net > email: [EMAIL PROTECTED] > > "GIVE a man a fish and he will eat for a day. But TEACH him how to fish, and...he > will sit in a boat and drink beer all day" > > > Want to chat instantly with your online friends? Get the FREE Yahoo! > Messenger http://uk.messenger.yahoo.com/ > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > 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.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: Q. To RAC or go vertical
.. though now that I've read the original post ( missed it somehow ) I would say that you may just want a bigger box. See Mogen's article "You Probably Don't Need RAC" at selectonline.org. You may want to ask Mogens for an alternative version of the article, in fact, I think you should. Jared Jared Still <[EMAIL PROTECTED]> Sent by: [EMAIL PROTECTED] 08/05/2003 08:44 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Q. To RAC or go vertical While fault tolerance is certainly one of the features of RAC, it isn't correct to say that it is not also for scalability. Buy a bigger box? That works fine until you're in the biggest box you can get, then what? I realize that it's a small market segment that requires that kind of hardware, but it still exists. Sun has been testing a cluster of 15k servers with RAC, ostensibly for scalability. Some nodes are populated with 78 CPU's and 288 Gig of RAM. ( yes, that is correct ). Jared On Tue, 2003-08-05 at 07:54, Stephen Lee wrote: > > I think the point of RAC is fault tolerance, not scalability. If it's > performance you want then you want a bigger box, not more boxes. 8 CPUs is > not big. You sure don't need the expensive hardware if all you want to run > is 8 CPUs. It would be better to go with a smaller frame and use the money > you save to get more CPUs and additional I/O capacity. For example, instead > of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans > to push the E12K out to its limits in the future. Don't forget to consider > the backup requirements of a 5 - 10 TByte database. Another consideration, > I think, is that those big, fancy boxes require additional sys admin skills. > > -Original Message- > Hi All > > I would like to ask for your thoughts on whether to RAC or just go vertical > (more cpu) > > Background > > Txn - OLTP like txn during day but batch extracts at night and > very big batch extract periodically > Data Volume - 5-10 TByte > Data volatility - 99 % of data is very much like a ware house (unchanged) > other 1% is read/update/delete/insert > > Options > 1. Say a very large server like a HP Superdome or SUN E12000 > with 8 CPUs > Server already exist so cost is in obtaining additional CPU/Blades > ie Traditional Server using plain old vanilla Oracle EE > - can still increase head room. > - batch programs can utilise all 8 CPUs > - storage system need not cater for clustering > > 2, Same large server like a HP Superdome or SUN E12000 but partitioned > into two. Each with 4 CPU. > Oracle RDBMS + RAC option > - storage server need to cater for cluster config > - max performance for batch is with 4 CPUs only > > > Which would you prefer and why. I am not convinced with the RAC option. > Now > if I was going with cheaper Intel servers like Dell servers with 4 CPUS > each, and > purchase say 4 nodes of 4 cpus each, that would be a different story. In > this case > I have the equipment and ability to grow vertically. > > ta > tony > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > 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). > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jared Still INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'Li
RE: Q. To RAC or go vertical
The 15k was simply a node in a cluster. Jared [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] 08/05/2003 10:24 AM Please respond to ORACLE-L To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> cc: Subject:RE: Q. To RAC or go vertical Hi Jared Was that a cluster of Sun E15ks or A single E15K of clustered domains within itself? The reason I mention the E12k and HP Superdome was that the equipment is already available. All I need is to purchase additional CPUS. I am trying to enquire as to what people have commissioned with 10TB database using RAC vs single large boxes. If you read some of the postings about RAC on Solaris, there are lots of issues with it. How true one of these that said that you do not get the scalability after 2 nodes and on the 4th node it degrades to about below 50%. This is specifically on Solaris. ta tony At 07:44 AM 05/08/2003 -0800, you wrote: >While fault tolerance is certainly one of the features of RAC, >it isn't correct to say that it is not also for scalability. > >Buy a bigger box? That works fine until you're in the biggest >box you can get, then what? I realize that it's a small market >segment that requires that kind of hardware, but it still exists. > >Sun has been testing a cluster of 15k servers with RAC, ostensibly >for scalability. Some nodes are populated with 78 CPU's and 288 >Gig of RAM. ( yes, that is correct ). > >Jared > > >On Tue, 2003-08-05 at 07:54, Stephen Lee wrote: >> >> I think the point of RAC is fault tolerance, not scalability. If it's >> performance you want then you want a bigger box, not more boxes. 8 CPUs is >> not big. You sure don't need the expensive hardware if all you want to run >> is 8 CPUs. It would be better to go with a smaller frame and use the money >> you save to get more CPUs and additional I/O capacity. For example, instead >> of E12K with 8 CPUs, get 4810 with 12 CPUs -- unless you have definite plans >> to push the E12K out to its limits in the future. Don't forget to consider >> the backup requirements of a 5 - 10 TByte database. Another consideration, >> I think, is that those big, fancy boxes require additional sys admin skills. >> >> -Original Message- >> Hi All >> >> I would like to ask for your thoughts on whether to RAC or just go vertical >> (more cpu) >> >> Background >> >> Txn - OLTP like txn during day but batch extracts at night and >> very big batch extract periodically >> Data Volume - 5-10 TByte >> Data volatility - 99 % of data is very much like a ware house (unchanged) >> other 1% is read/update/delete/insert >> >> Options >> 1. Say a very large server like a HP Superdome or SUN E12000 >> with 8 CPUs >> Server already exist so cost is in obtaining additional CPU/Blades >> ie Traditional Server using plain old vanilla Oracle EE >> - can still increase head room. >> - batch programs can utilise all 8 CPUs >> - storage system need not cater for clustering >> >> 2, Same large server like a HP Superdome or SUN E12000 but partitioned >> into two. Each with 4 CPU. >> Oracle RDBMS + RAC option >> - storage server need to cater for cluster config >> - max performance for batch is with 4 CPUs only >> >> >> Which would you prefer and why. I am not convinced with the RAC option. >> Now >> if I was going with cheaper Intel servers like Dell servers with 4 CPUS >> each, and >> purchase say 4 nodes of 4 cpus each, that would be a different story. In >> this case >> I have the equipment and ability to grow vertically. >> >> ta >> tony >> -- >> Please see the official ORACLE-L FAQ: http://www.orafaq.net >> -- >> 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). >> > > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.net >-- >Author: Jared Still > INET: [EMAIL PROTECTED] > >Fat City Network Services-- 858-538-5051 http://www.fatcity.com >San Diego, California-- Mailing list and web hosting services >- >To REMOVE yourself from this mailing list, send an E-Mail message >to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in >the message BODY, include a line containing: UNSUB ORACLE-L >(or the name of mailing list you want to be removed from). You may >also sen
Re: Unix process tree
Title: Unix process tree Redhat AS 2.1 at least has something, probably others as well. It's "pstree" if I recall correctly. Also, ps has some options to print process dependencies out. Tanel. - Original Message - From: Jeremy Bainbridge-Smith To: Multiple recipients of list ORACLE-L Sent: Tuesday, August 05, 2003 5:49 AM Subject: Unix process tree Hi Team Firstly apologies for a slightly OT question. Solaris has a great little command called "ptree" which given a process id as an argument, will present a tree of all the process' related to the given process id. Question: Is there a similar command for Linux? Cheers Jeremy Jeremy Bainbridge-Smith Database Administrator Hamilton City Council Ph. +64 7 838 6428 Mob. +64 21 894481 ~~~
questions - kernel parameters - Red Hat 2.1 Advanced Server
Hi - I just finshed an install on Linux 2.1 Advanced server using the installation document of Oracle 9.2 for Linux/Intel avialable on technet. I ended up doing this for the kernel paramters echo 250 3200 100 128 > sem echo 2147483648 > shmax echo 65536 > /proc/sys/fs/file-max echo 1024 65000 > /proc/sys/net/ipv4/ip_local_port_range ulimit -u 16384 skipped SHMMNI because it was already 4096 Starting on page 2.19 of the doc - it indicates how to do SEMMSL ,SMMNS, SMEOPM, SEMMNI as above with "sem". in the /proc/sys/kernel virtual filesystem. Then it says you can do the shared memory pamater as in the "shmax' example. After that it says to set the process limit by using ulimit -u. And now.. to the questions Then it has a list of the minimum values of parameters required to run 9i with a single datbase instance on Linux. My first problem is, I don't understand how to set 3 of these. They don't exist in the /proc/sys/kernel filesystem. SEMMNI ( taken care of above).. SEMMNS (taken care of above). SEMOPM (taken care of above) SEMMSL (taken care of above) SHMMAX (taken care of above) SHMMIN shoudl be 1 (hot to set this?) - I have no shmmin in /proc/sys/kernel SHMMNI should be 100 was already 4096 so skipped it SHMSEG should be 4096 (how to set this?) - I also have no shmseg in /proc/sys/kernel SHMVMX should be 32767 (how to set this?) - and I have no shmvmx in /proc/sys/kernel So there are those 3 questions - and then the following - "Write a script to initialize these values during system startup, and include the script in your system init files".. Now - I guess the script looks similar to the lines I pasted at the top of the email - but where does it go? This may be a bit of a Linux newbie question but aren't there various run levels so wouldn't where I place the initilization stuff matter how the box is configured? Do I just make a little bash script? What is preferred and where should it go? Lastly - do any of these require a recompile of the kernel or not? Can they all be set safely on boot? Thanks.. Appreciate any help, Doug C. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Doug INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Poor performance after moving Extempore database from 7.3.4 to 8.1.7
We recently upgraded an application (Extempore) database from Oracle 7.3.4 to 8.1.7. The clients say the test database, still on Oracle 7.3.4 is much faster than the production database, now on 8.1.7. The server is newer and faster on the production database. The Oracle init parameters are pretty much identical. When I access the database through SQL*PLUS or TOAD, the response is instantaneous. The app uses an ODBC connection which is also 8.1.7. I have tried attaching the tables in MS Access through ODBC. This too is instantaneous. Any ideas? Ron Smith -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Smith, Ron L. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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 take sql*loader trace
Hi All, I'm loading a set of data into one of my schema. And wanted to take the trace files also. I tried the follwoing. 1. Identified the sid,serila# for the sql*loader session. 2. used the follwoing, exec sys.dbms_system.set_sql_trace_in_session(19,11250,TRUE); but this is not generation any trace files. But if I trun my system to sql_trace=TRUE, I'm able to collect the trace details. I don't want to do this. I want to take the trace only for the sql*loader session. How do i do that. TIA, Senthil. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Senthil Kumar INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: quick suggestions for tuning ?
Thanks a lot Connor. Apart from bind vars.,LIO is a big issue here. 54 million consistent gets. does it mean that db_cache_size (700M) is small ? any good docs or links regarding LIO and how to deal with it ? Can u explain me Connor ? Regards, Jp. >From: Connor McDonald <[EMAIL PROTECTED]> >Subject: Fwd: Re: quick suggestions for tuning ? >Date: 10-08-2003 23:44:25 >Its not really rocket science here... >CPU is at the top of the timed event - and what causes >CPU (or is the most common cause) - logical I/O. 54 >million consistent gets later down in the report >probably a bit of a giveaway there :-) >Next section in the report is some nice queries that >use up 4 or so million buffer gets. Good ones to >start with... As you've already noticed, no bind >variables. >Then some other miscellaneous things - look at how >much free memory you have in most of your pools "SGA >breakdown difference" - might be able to use that >better elsewhere. >cheers >connor -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Prem Khanna J INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: URGENT: Trying to duplicate database from cold backup - auxi
Title: RE: URGENT: Trying to duplicate database from cold backup - auxi I am with ya. -Original Message- From: Freeman Robert - IL [mailto:[EMAIL PROTECTED]] Sent: Tuesday, August 05, 2003 5:44 PM To: Multiple recipients of list ORACLE-L Subject: RE: URGENT: Trying to duplicate database from cold backup - auxi >> BTW, I just waited till afterhours brought the database down, copied >> the file and cloned the easy way. I love RMAN, but truth be told, I still find the old manual method of cloning a database to be easier somehow. Must be an old fogie. RF -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Freeman Robert - IL INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 http://www.fatcity.com San Diego, California -- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: Event 10235
Hi! This event is meant for detectiong heap corruptions, by doing additional checks when allocating/deallocating memory. (It affects heap manager). When set on level 2 it does some check of heap structure when freeing it (level 1) + when allocating/deallocating memory in heap, the memory is filled with junk (level 2). I assume it's because, when you have complete junk in your heap (not some leftover from other session) you'll more likely have a crash in case of some mispointing pointer, thus detecting problems earlier. So, it's for diagnostics, and you should remove it, especially when on decent Oracle version. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 8:19 PM > One of our databases has the 10235 (level 2) event set. Unfortunately, the Metalink doc is very sparse (barely more than oerr). It mentions that it protects internal memory management structures. What I am needing are reasons why this event would be set. Anyone have experience with this event and what some of the motivations were? > > Dan -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
RE: License Question
Harvinder, You should call you Oracle sales rep. All pricing is negotiable depending on whether it is end-of-quarter, how close mars is in alignment with earth,etc. Also, always try to negotiate education credits,etc. I have found end-of-quarter is best, they all like that trip to Hawaii...seen it too many times. Rick DENNIS WILLIAMS <[EMAIL PROTECTED]To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> UCH.COM> cc: Sent by: Subject: RE: License Question [EMAIL PROTECTED] .com 08/11/2003 04:04 PM Please respond to ORACLE-L Harvinder - I've never seen a price attached to the client. Dennis Williams DBA, 80%OCP, 100% DBA Lifetouch, Inc. [EMAIL PROTECTED] -Original Message- Sent: Monday, August 11, 2003 11:54 AM To: Multiple recipients of list ORACLE-L Hi, One of our client is using 8.1.7 database server. We have install 9.2 client version on one of application server to connect to database. Do the client have to buy oracle 9i client(or they need to buy complete 9i server edition) and does anyone know how much it cost for 1 license of oracle 9i client? Thanks --Harvinder -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Harvinder Singh INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (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: Capacity Planning Methods?
I also grab freespace from dba_free_space, dump it into a table, and watch the deltas there, too. It helps for watching less predictable object growth, like perhaps with an index. Although my procedure is tablespace-oriented, so it won't give detail as to exactly what's doing all the growing. If you'd like, I could post the smallish 68-line procedure and the table create that I use to do this. There are perhaps better ways of doin g this, but it works for me in 8.1.7 on dictionary managed tablespaces. Rich Rich Jesse System/Database Administrator [EMAIL PROTECTED] Quad/Tech Inc, Sussex, WI USA > -Original Message- > From: DENNIS WILLIAMS [mailto:[EMAIL PROTECTED] > Sent: Monday, August 11, 2003 4:49 PM > To: Multiple recipients of list ORACLE-L > Subject: RE: Capacity Planning Methods? > > > David > I analyze the tables each week primarily to populate NUM_ROWS in > USER_TABLES. I use ANALYZE TABLE because that works better in > 8.1.6. Then I > save the data to a separate table along with the date I did > it. The primary > rows are schema_name (if there is more than one schema of > interest), date, > num_rows, chained_rows, blocks. Whatever suits your purposes. > Then I can go > back and see the pattern of growth over time. > > > > Dennis Williams > DBA, 80%OCP, 100% DBA > Lifetouch, Inc. > [EMAIL PROTECTED] > > -Original Message- > Sent: Monday, August 11, 2003 4:24 PM > To: Multiple recipients of list ORACLE-L > > > > How do you guys collect capacity planning metrics, such as DB size? > > Do you use StatsPack, Oracle OEM, others? I'm interested in > an efficient > method to track DB growth in GB month over month. > > > Best regards, > > David B. Wagoner > Database Administrator > -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- 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).
TNS errors
Hi everyone, Been a very long time since I posted, but finally running into a problem. New system: Win 2k Server, Citrix XPe, Powerbuilder 5.0 App, Oracle 8i. If I run the Powerbuilder executable on the server, it connects to Oracle just fine. When I try to connect using Citrix (from this machine or a different machine) on the same network, I get TNS-12560, When I look at the nmi.log, I see: Fatal NI connect error 12560, connecting to: (DESCRIPTION=(ADDRESS=(PROTOCOL=BEQ)(PROGRAM=ORACLE)(ARGV0=ORACLEFIRST)(ARGS ='(DESCRIPTION=(LOCAL=YES)(ADDRESS=(PROTOCOL=beq)))'))(CONNECT_DATA=(CID=(PR OGRAM=c:\oracle\ora81\bin\dbsnmp.exe)(HOST=SUNRISE-SAMS)(USER=SYSTEM VERSION INFORMATION: TNS for 32-bit Windows: Version 8.1.7.0.0 - Production Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production Time: 07-AUG-2003 10:48:22 Tracing not turned on. Tns error struct: nr err code: 0 ns main err code: 12560 TNS-12560: TNS:protocol adapter error ns secondary err code: 0 nt main err code: 530 TNS-00530: Protocol adapter error nt secondary err code: 2 nt OS err code: 0 I'm STILL a newbie, you would think that after 5 years of managing my rinky dink database, I'd know something, but... Anyway, can anyone help me to resolve this problem? Yes, I will turn tracing on as soon as I figure out how to for DBSNMP. Thanks, Ken Hitchcox PS Hi Rachael C still have DBA101 on my desk. -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ken Hitchcox INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Opatch
I'm trying to use opatch and receive the following error [EMAIL PROTECTED] $ opatch apply PERL5LIB=; export PERL5LIB /usr/local/bin/perl /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPat ch/opatch.pl apply Can't call method "build_option_details" on an undefined value at /opt/oracle/admin/general/patchsets/opatch/patch2617419/OPatch/opatch_modules/Apply.pm line 2299. ORACLE_HOME is correctly set, PATH is correct as well. Any idea what the problem may be. Every opatch command fails with the above error including such things as opatch -version. Ian MacGregor Stanford Linear Accelerator Center -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: MacGregor, Ian A. INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
Re: 100 instances on same server !!!
Now , what is your server configuration ? windows , sun , hp ?? memory ?? -ak - Original Message - From: Dilip Patel To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 3:54 PM Subject: Re: 100 instances on same server !!! Thanks for the replies so far. Considering the fact that my database is tiny ( just around 3 GB ), How many of them can work on same server? I can just test with 5 instances, with limited hardware. Will the CPUs be able to take load of 100 instances? Is it worth experimenting this? I am on 8.1.7.4 and the application is already built. I stand no chance of changing the code. That is why using individual schemas for individual users is not an option. Right now I am just asked if 100 instances can run on same server and I dont have solid answer. Just on side note, can I ask, What is the maximum number of instances anyone has ever worked/heard being installed with in same server? Thanks again. Dilip. - Original Message - From: AK To: Multiple recipients of list ORACLE-L Sent: Thursday, August 07, 2003 11:54 AM Subject: Re: What books recommended for Data Modeling ? 100 instances woh . If you are in 9i look at possibilities like contextor label security . or creating another schema .-ak- Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]>Sent: Wednesday, August 06, 2003 9:24 PM> I have not heard installing hundred database instances on same server.> Maybe you should think creating one instance, and then hundred schemas in> it.>> Guang>> On Wed, 6 Aug 2003, Dilip Patel wrote:>> > Hi All,> > Need some suggestions/Input.> >> > My application database is 8.1.7, NOARCHIVELOG, WIN200,> > total size 4 GB, more of single user OLTP client-server application.> >> > Now the customer wants to give training on this application to hundredtrainees> > at a time. For this he wants to install hundred database instances onsame> > server machine, which *each* will be accessed simultaneously from 100different> > client workstations.> >> > The reasons for installing all instances on same machine are> > - to avoid re-installing databases on 100 workstations after each roundof> > training.> > - No user should see any other user's data.> >> > Please suggest if this approach is feasible or is it at all possible.Tested this with upto 5 instances, and> > it seems to work. The customer is willing to upgrade to any hardwareneeded for> > this setup.> >> > Thanks in advance for your time.> >> > Dilip.> >>> -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net> -- > Author: Guang Mei> INET: [EMAIL PROTECTED]>> Fat City Network Services -- 858-538-5051 http://www.fatcity.com> San Diego, California -- Mailing list and web hosting services> -> To REMOVE yourself from this mailing list, send an E-Mail message> to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in> the message BODY, include a line containing: UNSUB ORACLE-L> (or the name of mailing list you want to be removed from). You may> also send the HELP command for other information (like subscribing).>-- Please see the official ORACLE-L FAQ: http://www.orafaq.net-- Author: AK INET: [EMAIL PROTECTED]Fat City Network Services -- 858-538-5051 http://www.fatcity.comSan Diego, California -- Mailing list and web hosting services-To REMOVE yourself from this mailing list, send an E-Mail messageto: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and inthe message BODY, include a line containing: UNSUB ORACLE-L(or the name of mailing list you want to be removed from). You mayalso send the HELP command for other information (like subscribing).
RE: last column in a table is added with a DEFAULT
Title: RE: last column in a table is added with a DEFAULT I understand that part. What the programmer is saying that you can not add the last column to a table with a default value. Does that sound reasonable? thanks, Raj. David. -Original Message-From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]Sent: Thursday, August 07, 2003 1:25 PMTo: Multiple recipients of list ORACLE-LSubject: RE: last column in a table is added with a DEFAULT as soon as you add a column all depending code goes invalid, the dependency checking process doesn't discriminate about the default value. Raj Rajendra dot Jamadagni at nospamespn dot com All Views expressed in this email are strictly personal. QOTD: Any clod can have facts, having an opinion is an art ! -Original Message- From: Ehresmann, David [mailto:[EMAIL PROTECTED]] Sent: Thursday, August 07, 2003 1:09 PM To: Multiple recipients of list ORACLE-L Subject: last column in a table is added with a DEFAULT Has anybody ever heard of this? I have a developer saying this is an oracle bug. It caused some packages to go invalid. "The error seems to be related to a bug in oracle caused when the last column in a table is added with a default." David Ehresmann -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Ehresmann, 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: Merge patches
As a general rule, one off patches are applied only at the direct request >From oracle support. If you need a silver bullet (merge patch), you have to ask for that. If not, wait for the next patchset. I hear that 9.2.0.4 is just around the corner. -- Mladen Gogala Oracle DBA -Original Message- Tanel Poder Sent: Monday, August 11, 2003 2:45 PM To: Multiple recipients of list ORACLE-L Hi! I think most of people here have applied several one-off patches successfully, at least I have. But the issue is, as the name says, the one-off patches are only for fixing a certain bit of behaviour, they havent been tested in heavy-loaded envrionments where they could affect each other. But eventually these one-offs make their way to patchsets, which are stress tested for reliability. So, you are on your own risk when going with multiple one-offs, but in my experience it has worked. Others may have different experience, though.. Tanel. - Original Message - To: "Multiple recipients of list ORACLE-L" <[EMAIL PROTECTED]> Sent: Monday, August 11, 2003 8:59 PM > OK, maybe I'm going crazy or senile, but I seem to recall Oracle > stating that if you needed to apply more than 1 patch, you would need > to request a merge patch. I think this was about a year ago and > caused us to downgrade a database to resolve a problem since the > turn-around time for the merge patch was not going to beet our > requirements. > > Does anyone else remember this? Are they still doing this or can > multiple 1-off patches be applied now? > > Stephen > > -- > Please see the official ORACLE-L FAQ: http://www.orafaq.net > -- > 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.net -- Author: Tanel Poder INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Note: This message is for the named person's use only. It may contain confidential, proprietary or legally privileged information. No confidentiality or privilege is waived or lost by any mistransmission. If you receive this message in error, please immediately delete it and all copies of it from your system, destroy any hard copies of it and notify the sender. You must not, directly or indirectly, use, disclose, distribute, print, or copy any part of this message if you are not the intended recipient. Wang Trading LLC and any of its subsidiaries each reserve the right to monitor all e-mail communications through its networks. Any views expressed in this message are those of the individual sender, except where the message states otherwise and the sender is authorized to state them to be the views of any such entity. - -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Mladen Gogala INET: [EMAIL PROTECTED] Fat City Network Services-- 858-538-5051 http://www.fatcity.com San Diego, California-- Mailing list and web hosting services - To REMOVE yourself from this mailing list, send an E-Mail message to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).