Oracle 11g consulting

IN PROGRESS
Bids
24
Avg Bid (USD)
$31 / hr
Project Budget (USD)
$25 - $50 / hr

Project Description:
I have an Oracle 11G database. I'm looking for an experienced Oracle 11G DBA to answer some questions as needed and provide Oracle knowledge.

For example, we have a large table with millions (30-50) of rows. After a batch of records are inserted, queries are very slow (20 min). After executing the below:
EXEC dbms_stats.gather_schema_stats('db', cascade=>TRUE); Queries run in few seconds. Why?

Another example, there is a DB on Amazon RDS Oracle, another one hosted in-house. RDS one performs better even though on similar OS/hardware. How can we compare the param config to make in-house like RDS config?

I'll have questions similar to above and the skilled DBA will provide the answers. It's not something you can just google, if you don't know Oracle inside/out please don't bother bidding.

Thanks!

Hours of work: Unspecified Project Duration: 1 - 4 weeks Skills required:
Database Administration, Oracle
About the employer:
Verified
Public Clarification Board
Bids are hidden by the project creator. Log in as the employer to view bids or to bid on this project.
You will not be able to bid on this project if you are not qualified in one of the job categories. To see your qualifications click here.


$25 / hr
Hours: 20 hr/ week
$35 / hr
Hours: 20 hr/ week
Hire sstanojevic
$50 / hr
Hours: 5 hr/ week
$25 / hr
Hours: 5 hr/ week
Hire hitgon
$25 / hr
Hours: 4 hr/ week
Hire bennas14
$35 / hr
Hours: 6 hr/ week
Hire indika762
$25 / hr
Hours: 40 hr/ week
$25 / hr
Hours: 20 hr/ week
Hire aduenas28
$35 / hr
Hours: 5 hr/ week
Hire orayoda
$50 / hr
Hours: 2 hr/ week