| what is this error, i never got this before [message #62849] |
Thu, 19 August 2004 05:24  |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
select count(*) from some_table
*
ERROR at line 1:
ORA-03113: end-of-file on communication channel
what is the reason for that above error?
and i aslo got another error while inserting data into the same table the Error is: ORA-03001: unimplemented feature.
help me, i never got these errors
|
|
|
|
| Re: what is this error, i never got this before [message #62850 is a reply to message #62849] |
Thu, 19 August 2004 05:55  |
dilip kumar
Messages: 111
Registered: December 2003
|
Senior Member |
|
|
the reason for the error is if the oracle server dosen't allocate sufficient buffers to hold your data in SGA it will simply disconnects your session from the instance or if sufficient space is not allocated for sort operation then also it will display same error
messages
The table on which your writing a query(select/dml)
is having large volume of data
if this is the case reorganize the table to the different tablespace or do export and import operation
or increase the buffer cache area
it will work
Regards
D.Dilip
|
|
|
|
| Re: what is this error, i never got this before [message #62854 is a reply to message #62850] |
Thu, 19 August 2004 06:28 |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
Thanks a lot, yes the table is monster table on our box, it has more than 90 columns and about 5 million records and a lob field.
I am using 8172 version.
nls_sort
sort_area_size 1000000
sort_area_retained_size 1000000
sort_multiblock_read_count 2
so what are the recommanded values, using HP11, 4 CPUS BOX
Thanks a lot again
|
|
|
|
| How much I should Increase my Sort Area Size? [message #62865 is a reply to message #62850] |
Fri, 20 August 2004 06:45 |
Kapil
Messages: 145
Registered: May 2002
|
Senior Member |
|
|
Thanks a lot, yes the table is monster table on our box, it has more than 90 columns and about 5 million records and a lob field.
I am using 8172 version.
nls_sort
sort_area_size 1000000
sort_area_retained_size 1000000
sort_multiblock_read_count 2
so what are the recommanded values, using HP11, 4 CPUS BOX
Thanks a lot again
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
