Recent content by snayak

Hi, I've batch jobs running which inserts into a several tables millions of rows & later there is another batch job which queries these records & pushes them into legacy systems. For eg The time gap between insert into a table & selecting from the same table is around 6-8 hours. Every run I...

If you want to run both Linux & windows at the same time then use vmware. Regards

Hi Dima, Actually the session keeps running for more than 2 days if not for killing the OS process, I have never seen the session coming out from that spin. Thanks, Regards.

Hi All, Wondering anyone has faced this issue. A query which usually completes in 2hours, but when interupted like alter system kill session or closing the sqlplus i.e rebooting my client, the v$session status field shows KILLED i.e. I get message as ora-31 marked for kill. This never...

Hi All, I would like to get understanding on the below issue. 1. They have an instance 8.1.7.4 32bit version on 32bit kernel mode running at the moment on 64bit hardware. They want to know whether they can install 9.2.0.x 64bit on 32bit kernel mode on a 64bit hardware. 2. Secondly if...

Hi Dima, Thanks for the response. I feel that way as when I remove the create database command from there & run only the catalog from the script its slow Thanks, With regards

Hi , Just wondering has anyone come across when catalog is run within the create database as a script takes around 5hours whereas running directly from sqlplus takes just 10min. Please help. For eg : Create a script a.sh wherein has Create database ....... @catalog.sql....... Takes...

Just my 2 cents , I feel you have to look into the area of freelist for the table.

Hi, I want to plot the graph for cpu used in hour , hence I queried the table stats$sysstat and got the logons current and cpu used by session by subtracting from the previous snapshot i.e. Cpu used by session : 584439144 Logons current : 530 Hence I divided the cpu used...

Hi, Anybody has any idea how to clear the 8 open responses as shown below in oracle alert . ALPPIM module: Response Processor +---------------------------------------------------------------------------+ Current system time is 24-MAR-2003 17:50:12...

Hi , Good Day. Anyone has experience of cloning multinode to multinode cloning of oracle Apps 11.0.3 . Please help. Thanks, in advance. Thanks, With kind regards

Hi Annihilannic, Yes I have put the entry as 1.2.3.4(IPaddress of my smtp server) smtpserver mailhost Is there anything else I need to check. Thanks, With regards

Hi, There are no error messages in /var/log/syslog as well it just says accepted for delivery but the mail never reaches. How do I change the smtp mail server configuration for mailx command. Thanks, With regards

Hi, Just wanted to know , can alter table move command can be used to move to the same tablespace and get rid of fragmentation ? i.e. if the table is in say tablespace named users and I issue the command eg: alter table t move tablespace users; Please help. Thanks, With regards

Hi, There is no error as such mailx command accepts the message and delivers but on the other end it doesnt receive .Any log which I can check . Please help. Thanks, With regards