ORacleDb

[muralikrishna]

Hi

i am having 1crore record in my oracle DB. My ram size 4gb.If i fire any query like select statments i am getting result very slow . Is it i need to increase RAM size or any issue?

[Asif Sharif]

Hi Murali,

First of all check your memory, if there is any bottleneck in memory and system is utilizing it heavily then you need to increase the memory.

Check with these commands.

#swapinfo -tam
#vmstat
#sar -d 5 5

Regards,
Asif Sharif

[Dennis Handly]

>i am having 1 crore

This isn't an English and it isn't a SI unit prefix:
http://physics.nist.gov/cuu/Units/prefixes.html

[SSCHAER]

check the execution plan of your query. there's a good chance it executes a full table scan.

[Steven E. Protter]

Shalom,

http://www.hpux.ws/?p=6

Collect some data.

Before making decisions, check utilization. You may be able to improve performance with some kernel adjustments or reducing demand in the oracle SGA configuration.

SEP

[T G Manikandan]

You need to narrow it down to see what is causing the issue:

But being that the query is fetching 1 crore rows, you need to probably work more with query first:

YOu need to check if you have indexers defined and you can perform an explain plan for the query to find out the query execution cost and time.