Take the 2-minute tour ×
Unix & Linux Stack Exchange is a question and answer site for users of Linux, FreeBSD and other Un*x-like operating systems.. It's 100% free, no registration required.

I installed oracle-xe-11.2.0-1.0.x86_64.rpm on Fedora 17-64-bit. I was wondering why it is very slow, for example when I want to connect to it using Oracle SQL Developer or JDBC in my web application.

Are there any configuration for Fedora or Oracle Express 11 to improve my performance?

I mention that my machine specification is good (8GB RAM , Core i5 CPU).

I installed an Oracle Express on Windows using VirtualBox and when I wanted to connect to it from my Fedora it was slow but when I connected to it locally (in Windows) it connected very fast!

share|improve this question
    
Please don't cross-post (Same Q on SO: stackoverflow.com/questions/14009677/…). Also you'll need to explain in more detail what "slow" means. What exactly is taking a lot of time? –  Mat Dec 23 '12 at 8:42
    
I cross-post this question because it relate to this site and i wanted both user of sited see my question. –  Saeed Zarinfam Dec 23 '12 at 9:04
2  
Well don't. It's off-topic on Stack Overflow anyway. And without any more details, it's not answerable. –  Mat Dec 23 '12 at 9:05
    
when i wanted to connect to it using "Oracle SQL Developer", it took about 1 minute. –  Saeed Zarinfam Dec 23 '12 at 9:06
    
People spend careers learning how to optimize databases, it is a hard topic. The first thing you could do is be more specific; how big is the DB, how many reads/writes per second? How many clients? etc. etc. Since you're using oracle you should be able to find a consultant easily enough if money is not a concern. –  Steve Kemp Dec 23 '12 at 9:24

1 Answer 1

up vote 1 down vote accepted

I disabled "firewall" and "SELinux Default Enforcing" and then the problem was solved. I also added Device name (or host name, e.g. saeed-pc) into hosts file (located in /etc/hosts):

127.0.0.1       localhost.localdomain localhost saeed-pc
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.