Oracle 11g consulting

Closed

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!

Skills: Database Administration, Oracle

See more: why google is better, looking for dba oracle, rds database, amazon db, RDS, oracle queries, oracle administration, one consulting, IT consulting, google exec, Database oracle, house inside, slow queries, oracle dba needed, amazon rds, compare price ebay amazon, database questions answers, compare prices ebay amazon software, oracle database 11g, compare windows azure amazon, experienced oracle dba, oracle consulting, records database similar, compare prices ebay amazon, database similar records

Project ID: #4015499

Awarded to:

sstanojevic

I have a lot of experience with Oracle, both as a DBA and developer, and especially enjoy performance optimizations. I'd be happy to answer your questions. See my Private Message for more details. cheers sam

$50 USD / hour
(4 Reviews)
2.7

22 freelancers are bidding on average $30/hour for this job

nibiranijum

Hi, I am oracle certified developer and dba expert with more than 5 years of experience. I can provide you expert suggestion. Please have a look on my profile. Rgds, Shafiq

$25 USD / hour
(9 Reviews)
4.7
charlerasmus

I have more than a decade experience in database technologies.

$35 USD / hour
(1 Review)
3.3
saurabhapandey

I am ready to work.

$25 USD / hour
(1 Review)
2.4
hitgon

DBA Expert

$25 USD / hour
(1 Review)
1.0
indika762

I have over 8 years experience in working with Oracle databases in 24*7 production environment. I am immediately available to start the work.

$25 USD / hour
(0 Reviews)
0.0
bennas14

a task like this is part of my day to day tasks where I deal with large tables and loads and dynamic SQL produced by applications.

$35 USD / hour
(0 Reviews)
0.0
AskPaddy

Hi I have started new in freelancer, i have 8 years of work experience as Oracle DBA and Oracle performance tunning expert.Worked on banking and telecom databases and provided root cause analysis for many major issues More

$25 USD / hour
(0 Reviews)
0.0
aduenas28

Hi, I am oracle certified developer and dba expert with more than 5 years of experience. I can provide you expert suggestion. Please have a look on my profile.

$35 USD / hour
(0 Reviews)
0.0
orayoda

Your query is running slow because the Oracle optimizer chooses a bad execution plan or an index is missing. This is not difficult to fix. I have experience with very large data where tables have billions of rows.

$50 USD / hour
(0 Reviews)
0.0
tjosh52

I have many years of oracle experience starting with 7.5 and so far up to version 12. I have seen the optimizer grow and morph into what it is today. I can help you understand the ins and outs on what a data load can More

$30 USD / hour
(0 Reviews)
0.0
QP31oh5NZ

We are freelance software developers. If you contact me I can give a quote for your project and we can discuss the details. <b><i>Removed by Admin</i></b>

$37.5 USD / hour
(0 Reviews)
0.0
sthakur8964

Hello, I am interested in working with you on oracle 11g consulting requirement, thank you, Sandeep

$25 USD / hour
(0 Reviews)
0.0
brianburditt

I have over 12 years experience with Oracle which is heavy in data management as I have designed and developed both OLTP and OLAP systems. The largest of which has in excess of one billion records in it's largest tabl More

$35 USD / hour
(0 Reviews)
0.0
puppett

Hi. I'm experienced Oracle DBA from Minsk, Belarus. I've got more than 5 years of extensive experience administering production databases. So I have reach mix of experience and theoretical knowledge. Also, last ye More

$25 USD / hour
(0 Reviews)
2.4
Webspirits

Hi, Oracle Expert is ready to offer consultancy as per your requirement. Please check your PMB for more details. Regards, Deepee ETS

$50 USD / hour
(0 Reviews)
0.0
enderson90

Dear sir we are enderson group of company we have a very good team plz contact us. Thanks and regards

$25 USD / hour
(0 Reviews)
0.0
amip1987

Hi boss, i can hep you. I have Oracle certification. Thanks

$30 USD / hour
(0 Reviews)
0.0
zahid857

Hi, I have more than nine years' experience in Databases field especially in Oracle and MySQL I've following expertise in Oracle 1- Oracle Database Administration on *nix and windows 2- Strong knowledge of SQL More

$25 USD / hour
(0 Reviews)
0.0
drpaso

I am an experienced DBA and can help you understand the basics of the oracle optimizer and the statistics and can help you with your doubts any time.

$25 USD / hour
(0 Reviews)
0.0
btwidt

Greetings, I am Oracle guru and have been performance tuning Oracle environments and SQL for over 20 years. I would love to help out and can quickly and competently answer your questions. I will send you answer to y More

$25 USD / hour
(0 Reviews)
0.0