Search results for query: *

Guys, Thank you so much for all the ideas you've contributed. I applied Sys suggestion and the saving time was cut to 1 hour but i think it's still a long processing. That's why i'm still hoping for more valuable ideas from all of you regarding this matter. Thank you Rommel

guys, The insert is running through an application and comitting every row inserted. I have 15 indexes, 3 triggers and one primary key constraint. I don't need to disable these because of some application concerns. I'm accessing the database in same machine. Thanks

hi, I inserted 30000 records to a 30 column file and it took 2 hours to save. Any ideas on how to tune my database in order to reduce the 2 hour saving time. I'm using personal oracle 9i for windows 98. Thank you so much Rommel

ask your dba to grant you an exp_full_database and imp_full_database roles. Hope this would help

sem, Sorry i forgot to tell you that we are using 8.05 and i understand there is no statspack included only utlbstat.sql and utlestat.sql. thanks, Rommel

hi! can anybody pls. tell me where can i download a free oracle statspack. Thanks, Rommel

Will oracle data guard be set up using a 8.05 database? Any clarification please... thanks, Rommel

Hi! Any suggestions/ideas on how to replicate server A to server B using my archive logs. I'm using 8.05 in WIN2K. Thanks, Rommel

Hi!, I've just installed my Oracle 8.05 in win2003 and it seems the database is running and there is no problem as of now. But, I doubt this installation will not give me problems in the future because as far as i know 8.05 is only supported by oracle in Windows Nt version. Any enlightenment...

Thanks dave... you're such a great help in this forum keep up the good work. Rommel

hi! Pls. send me a script on how to find the average row size of a particular table. I'm using oracle 8.05 thanks

Mufasa, What i mean of tablespace is not growing is its percentage of space usage. I initially set the tablespace to 2GB and for 2 months now the space being utilized by the table assigned to that tablespace is still 320Mb. The currently the total number of rows is 2.1 million. Any...

Good day to all oracle gurus! I have a table which i assigned to a tablespace and its indexes was also assigned to a separate tablespace. For 2 months now, i noticed that the table's tablespace is not growing but the index tablespaces of that table is the only one growing. Is this normal? or Is...

hi, edit your tnsnames.ora by changing the host=ip address of the database, i think that would solve your problem.

hi! Any ideas what this message means "kccrsz: expanded controlfile section 11 from 447 to 825 records requested to grow by 365 record(s); added 27 block(s) of records" i got this from our alert log. I'm using oracle 8.05 in win2003. thanks, Rommel

Hi, Any ideas on what table view am i going to use when i want to know what table is being use by a particular user. thanks, Rommel

Dima, No, i have not encounter such message what i need is, is there a standard value in setting up the SORT_AREA_SIZE. thanks, Rommel

Hi! Any ideas on how to size the SORT_AREA_SIZE, i have more than 100 users connected to the database whick is 8.05 in win2003. thanks, Rommel

thanks guys, you're all excellent always, rommel

hi, Can anybody tell me the command in editing the initialization parameter dynamically. I'm using oracle 8.05 in win2k. thanks, rommel