Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
Showing results for 
Search instead for 
Did you mean: 




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
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
#sar -d 5 5

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:

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


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.

Steven E Protter
Owner of ISN Corporation
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.