cancel
Showing results for 
Search instead for 
Did you mean: 

ORacleDb

ORacleDb

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?

5 REPLIES
Asif Sharif
Honored Contributor

Re: ORacleDb

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
Acclaimed Contributor

Re: ORacleDb

>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
Advisor

Re: ORacleDb

check the execution plan of your query. there's a good chance it executes a full table scan.
Steven E. Protter
Exalted Contributor

Re: ORacleDb

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
Steven E Protter
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
T G Manikandan
Honored Contributor

Re: ORacleDb

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.