Re: stress testing

2004-01-05 Thread tjambu_fatcity
Hi Tim Tony Jambu here. Saw your posting to Oracle-l with regards to your sp_vmstat.sh script. I am not sure if know but I write a regular hints & tips column for Select Journal. I read your article and would like to mention your script and point people to the script. Do you mind if I mention it

Re: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-24 Thread tjambu_fatcity
Thanks for sharing that Pete ta tony At 02:39 AM 24/10/2003 -0800, you wrote: >>>So who found out this vulnerability? David Litchfield? Aaron Newman? >>>I know it is a bit silly to ask but does anyone know how >>>to exploit this vulnerability? Send it to me directly if you dont want to >>>reply

RE: Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-24 Thread tjambu_fatcity
Hi Mike Here it is again.  Let me know if you can read it. ta tony At 08:54 AM 23/10/2003 -0800, Vergara, Michael (TEM) wrote: Tony:   I did not receive the attachment clearly.  Can you re-send it or cite the source?   Thanks, Mike   -Original Message- From: [EMAIL PROTECTED] [mailto:[EMA

Do not connect Oracle DB to the Internet. Oracle Alert #59

2003-10-23 Thread tjambu_fatcity
Important:  Please read the following Oracle Alert. We strongly recommend that you do not connect the Oracle Database directly to the Internet. Got your attention?  That is what is in the Alert.  These alerts are beginning to come all too often.  Sounds just like Microsoft's software, yeah? Buffe

Re: OraPerf account

2003-09-18 Thread tjambu_fatcity
ation on the site >but am not getting any email from them. > >I need to try something out in the next day and would appreciate >it if someone could provide me with an account and passw**d >to upload my files. > >If you are so kind as to let me have yours, you can send it

Re: Anyone have a copy of DUL ??

2003-09-18 Thread tjambu_fatcity
Juan I have the URL that you can get a copy from but you need access to Oracle's network.  Wrote about it in Select Journal. In 1999 - I wrote: DUL - Data recovery UnLoader DUL or Data recovery UnLoader is a utility that that will generate either a data file or an Oracle Export file by reading

OraPerf account

2003-09-18 Thread tjambu_fatcity
passw**d to upload my files. If you are so kind as to let me have yours, you can send it to me directly at tjambu_fatcity @ yahoo.com.au(Remove spaces) Thanks to tony -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: INET: [EMAIL PROTECTED] Fat City Network

Re: How to extract data directly from a datafile ?

2003-09-18 Thread tjambu_fatcity
Hi Juan For which platform do you want it for? Not saying I have it! ;-) ta tony At 12:19 AM 17/09/2003 -0800, Juan Miranda wrote: We need to extract the data of a datafile directly, because we don´t have the rest of the database (other tablespaces, controlfile, etc).   Are there some utility lik

Replication options Was: SharePlex info

2003-08-22 Thread tjambu_fatcity
Hi there In the past few weeks, there have been lots of discussion about HA, data replication and using Shareplex, dataguard, Streams, logical & physical standby.  As most of you have found out each has it own pros and cons.  You also need two sets of Database licences and Shareplex licences.  Th

Re: Is Pete Sharman Missing?

2003-08-16 Thread tjambu_fatcity
Spoke to Pete last week. he has been on leave and in the process of finding his way in his new office. He is back in Oz. Do you have his email address? ta tony At 10:29 AM 16/08/2003 -0800, you wrote: >Anyone hear anything out of Pete Sharman in the last two weeks? If you see >or hear from hi

Object programming with Oracle 9i

2003-08-16 Thread tjambu_fatcity
hi object/relational developers Please bear with me if I am not using the right terminology. Am intending on using java to access to the underlying relational tables. Was thinking of exposing the database to java using Object views over the relational views. Trying to isolate the complexity of

RE: Q. To RAC or go vertical

2003-08-14 Thread tjambu_fatcity
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 1

RE: Q. To RAC or go vertical

2003-08-14 Thread tjambu_fatcity
Thanks matt Understand where you are coming from. But one of my issue is the performance required to carry out batch extracts. If RAC was able to slice the job up and share it across all nodes, that would be great ala Oracle10G (wont go there now). WRT to TCO - RAC on Linux on Intel is the o

RE: Q. To RAC or go vertical

2003-08-10 Thread tjambu_fatcity
Hi Jared Yes I have read his article and also Dave Ensor's thoughts in it. I personally am not convinced and am looking for reasons why I should go with RAC other than fault tolerance given the risk involve in being one of the 1st few genuine pigs. I probably say, I would go with single instanc

RE: Q. To RAC or go vertical

2003-08-05 Thread tjambu_fatcity
Stephen I agree with your comments re scalability vs fault tolerance. Actually the configuration I am looking at is 16 CPUS. So it is either one domain (vertical) of 16 CPUS or 4 nodes of 4 CPUs each or 2 nodes of 8 CPUS each. And on top of this I have to cater for a Standby environment as well.

Q. To RAC or go vertical

2003-08-05 Thread tjambu_fatcity
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 hous

Re: International User Community

2003-06-09 Thread tjambu_fatcity
Also AUSOUG (Australian OUG) www.ausoug.org ta tony At 08:04 AM 09/06/2003 -0800, you wrote: While not trying to sound like this is coming off like a shameless plug, because it isn't... I have an Apps book going to publisher in a couple weeks and they want to do PR.  To that end, they have ask

SQL Problem - Merging Result sets

2003-03-26 Thread tjambu_fatcity
Hi all I have a question which is probably easy for some of you but it is 21:00 and my mind is not working. Would appreciate it if someone can point me in the right direction. version is 8i so no ANSI OUTER JOIN. I have 4 tables: master_tab, ID is PK detail_tab_A, ID is FK detail_tab_B

Oracle Licences Req on Intel Xeon CPU

2003-03-23 Thread tjambu_fatcity
Hi all For those that are running or intending on running Oracle on Intel's Xeon CPU, the following information may be of interest to you. The Xeon CPU has a feature called Hyper Threading with double the number of registers. This feature when turned will present to the Operating Systems an ad

Re: Important - Oracle Pricing on Standby/DR/Failover databases

2003-01-16 Thread tjambu_fatcity
Hi Kip I think you got the gist of it. In regards to your Q on DR, I assume that SunGuard and IBM is a DR facility hosted by them. How would you be recovering your database? Tapes? Then that should be OK. Filesystem replication or one of Oracle's features? Then you have to get another set

Re: Important - Oracle Pricing on Standby/DR/Failover databases

2003-01-16 Thread tjambu_fatcity
Hi Rachel Good to hear from you.  I am always on the list.  Just being a lurker. I am surprise that you are paying for a standby if the standby DB is not being used at the same time as the Pri.  By standby, do you mean something like Oracle replication or Dataguard where you are using Oracle's ut

RE: Important - Oracle Pricing on Standby/DR/Failover databases

2003-01-16 Thread tjambu_fatcity
Ethan This 10 day grace only applies to Clusters/Failovers not Standbys. So unless your DR is in a Global Cluster you can't apply the 10 days grace. As for a Hot standby DR site where the server is larger than the Primary server, I would think it reasonable to pay for the size of the Primary. B

RE: Important - Oracle Pricing on Standby/DR/Failover databases

2003-01-16 Thread tjambu_fatcity
Tom At 05:14 AM 16/01/2003 -0800, you wrote: >Jared, > >why doesn't it seem right? Because if you use filesystem replication, the standby/DR server does not have Oracle up and running. Oracle does not come into the equation at all. ta tony _ / |Tony Jambu, Database&Web

Re: Important - Oracle Pricing on Standby/DR/Failover databases

2003-01-15 Thread tjambu_fatcity
Hi Jared I have a reply from someone who does not want to be identified. This is his case.  His company tried reasoning and discussing it with Oracle and even tried a compromised (which I would not be happy with) He company put forward to Oracle to pay for the full licence on the production serve

Important - Oracle Pricing on Standby/DR/Failover databases

2003-01-15 Thread tjambu_fatcity
Hi All For those sites with either a standby, DR or failover database, the following information is very important to you.  You could be in breach of Oracle's Licensing agreement and could cost you $100,000s if not millions $$ (Read the summary at the end if you want to skip the details) In the