Ratan Kumar

Ranch Hand
+ Follow
since Jul 19, 2006
Merit badge: grant badges
For More
Cows and Likes
Cows
Total received
0
In last 30 days
0
Total given
0
Likes
Total received
0
Received in last 30 days
0
Total given
0
Given in last 30 days
0
Forums and Threads
Scavenger Hunt
expand Ranch Hand Scavenger Hunt
expand Greenhorn Scavenger Hunt

Recent posts by Ratan Kumar

Hi,

I have a conflict in the cell name. So my intention is either to rename the existing cell or create a new cell altogether.

Please tell me which is the better way. and which give me the starting steps for any of the solution

Thanks
14 years ago
Hi,

I have an application running on unix machine with me

i access it by the url

http://xxx.xxx.xxx.xxx:9080/abc

how can i replace this 'xxx.xxx.xxx.xxx:9080' by some name ...eg:test

so that i can now access it by

http://test/abc


Thanks
14 years ago
Hi

Can somebody who has done this help me with upgrading WAS 6.1.0.0 ND to 6.1.0.15 ND on solaris.

1. What all I need to download? fix pack and the update installer?
2. Can somebody provide me all the steps? as to run the installables from which location. how to backup the current configuration and if any precautions to be taken.

Thanks
14 years ago
Hi

Can some one please tell me with the steps to update IBM WAS ND 6.1.0.0 to 6.1.0.15 on solaris..like what should i do once i download the fix pack

Thanks

15 years ago
Hi

I uninstalled an application...but it gave some timeout error while doing that., but got uninstalled from console.

Now i am trying to install application, but on browsing..its not able to create the temp/upload folder inside dmgr.

Please help !!!
15 years ago
Hi

Thanks for the reply. Yes, table 1 is only for the staging purpose and later the data in it gets deleted..

I was wondering if i do the validations in the java program , there will be hit on the performance due to mmuch i/o being done. And so I am thinking it would be good to do that in plsql.

Thanks
Hi

I need a solution in the present set of conditions without using sqlloader. Also the flow should be table 1 and then table 2.

Please suggest which is the better way..validation check in java program or the plsql code? (performance wise)

Thanks
[ October 10, 2008: Message edited by: Ratan Kumar ]
Hi,

I have an input file full of records. I need to perform some validation on data in this file and then load the data into the table 1 and then from table 1 to table 2. Later the data from table 1 gets deleted.

Java program loads the file into table 1. Then plsql loads table 2 from table 1.

I would like know which is the best place to do this validation.

1) should I perform validations on input file in java program which loading the records into table 1?

or

2) should I first load the table 1 using the java program with the data from file as it is. And perform validations in plsql while loading table 2 from table 1?

Which is the best way performance wise?

Thanks
Hello, Thanks for your reply. I googled and arrived to the same conclusion.
Thanks again
15 years ago
Hello

I wanted to know if the installable for WAS 6.1 Base is different from WAS 6.1 Network Deployment installable?

The requirement is WAS 6.1 ND, but I was supplied WAS 6.1 Base software. Can that work for me using some plugin ND installable or do i specifically need to get the WAS 6.1 ND ?

Platform - Sun Solaris

Thanks
15 years ago
Hi,

I am getting this error "ORA-04030 out of process memory" for a particular oracle process again and again. It runs on a 64 bit server and oracle 10.2.0.x

This process seems to start and slowly use a lot of resources and then fails.

please suggest some solution

anything i can do with the parameters in init.ora? sga, pga?? can ram be a problem for this unix system? any patch for oracle 10.2.0.x ?
15 years ago
Does oracle plsql has PROBIT function? is there any way i can implement it?
15 years ago
can we deploy ear in tomcat? If not..then which free server is available for that? is JBoss an option?

Thanks
15 years ago
Hi,

I have a select query which uses GROUP BY and HAVING clause performing selct over 3 million records.

In oracle 10g one version (i think rel 2), the explain plan shows HASH GROUP BY and this query runs very fast.

In oracle 10g another version (i think rel 1), the explain plan shows SORT GROUP BY and this query takes hours.

Pls suggest what should i do? Is there any hint that can make the query use HASH GROUP BY instead of SORT GROUP BY.
Or is there any other option that i should try?

Thanks in advance.
15 years ago
It worked.

Had to use html:hidden for that

c:set gave some error and i could not reset as i am using dynaactionform and dont want to subclass it.

Thanks for your help
16 years ago