Find Jobs
Hire Freelancers

Database tuning required

$10-30 AUD

Completed
Posted over 8 years ago

$10-30 AUD

Paid on delivery
I am running on Oracle 11gR2 database on a Windows 10 64 bit machine. There is 32gb RAM. I am running a large sql script which is returning a error message ORA-04030: out of process memory when trying to allocate 1012 bytes (kxs-heap-c,kghsstk). I am running the same script on a smaller machine with only 16GB of RAM and it runs fine. Would like an experienced DBA one to have a look and see what is the issue and resolve.
Project ID: 8475712

About the project

20 proposals
Remote project
Active 9 yrs ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs
Awarded to:
User Avatar
Hi, I'm certified Oracle DBA and Oracle developer since 2000. You can contact with me at any moment to discuss your task.
$111 AUD in 1 day
4.9 (10 reviews)
4.6
4.6
20 freelancers are bidding on average $56 AUD for this job
User Avatar
Hi, I am 12+ years experienced Database Programmer at CMMI-5 level company. I am Personally working on : RDBMS : MS Access,Oracle,MySQL, MSSQL Server 7.0/2000/2008R2 and Onwards. Database Tools : Database Configuration Assistant, Database Migration Assistant,SQL/Oracle Trace, EXP/IMP, SQL*Loader, RMAN. ETL Tool: Informatica, SSIS,data-stage Let me know when can we discuss
$111 AUD in 1 day
4.0 (38 reviews)
5.7
5.7
User Avatar
Hello, I have been working with a MNC based company since last ~ 5 years, as an IT BI DWH Professional. The project is a BI DWH project which covers 3 layers of BI (ETL, Data warehouse & Reporting) and helped me in nourishing my talent in all the technologies around these 3 layers. Below are some key areas of my skills: • Expert on SQL Server, Oracle and MS Access Databases • Expert in BO XI, Cognos and SQL Server Reporting Service (SSRS) • Expert in & designing & Implementation of end to end ETL Process using Informatica & SSIS Tools • Expert in Designing Qlikview Dashboard BI Solution • Expert in ER & Dimension Data modeling • Complete Command on PL/SQL concept e.g. Procedures, Functions, packages and complex queries. • Basic knowledge of Unix Shell scripting • Web Development using Java, CSS, and HTML ,PHP & Java Script • Expert in excel Macro • Expert in C & C ++ Programming I have experience in all the above areas and during my project work I have completed all of the above tasks. As a Freelancer also I have worked in few of the above areas where I got a chance and delivered the best. I had conducted Informatica & DWH training for a US based training organization from Nov’14 to Dec’14. We recently started our own company “Point5Nyble Your Needs, Our Dream”. We always work to provide Best Delivery with 100 % customer satisfaction Would be looking forward to work on this opportunity and will ensure to deliver best. Regards, Point5Nyble Ashish Seth
$35 AUD in 1 day
4.8 (36 reviews)
4.9
4.9
User Avatar
Hi this is bhargava expert in oracle . i am ready to provide quick and efficient solution . Thanks Bhargava
$40 AUD in 1 day
4.9 (20 reviews)
4.1
4.1
User Avatar
Hello my friends, I tink that is only a parameters issue , I can confirm this if you send me the alert,lof file of you database. I will try diagnostic the problem before that you accept any bids. Regards
$100 AUD in 1 day
5.0 (16 reviews)
4.1
4.1
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
5.0 (3 reviews)
3.0
3.0
User Avatar
Dear, I have more than 10 Years as Oracle Database Admin. This Job is like walking in the park for me Regards
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I am in Sydney and working for one of the biggest banks in Australia as Senior Oracle DBA. I have many years of Oracle Database Administration experience and I am an Oracle Certified Professional. The error you mentioned could be due to several reasons. I can have a look at various things in the database and figure out the cause. thanks and regards, Vinod
$300 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
Database Administrator with advanced knowledge working with Oracle databases on the most UNIX, Lin and windwos
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Recent college graduate in the US with focus in database design and development. Will be able to finish the problem in one day as long as problem is how you described. Looking forward to hearing back from you. Thanks!
$77 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$20 AUD in 3 days
0.0 (0 reviews)
0.0
0.0
User Avatar
An experienced IT engineer with Oracle Database , Application Server (Apache Tomcat) skills. Having the ability to take the technical lead in projects and supporting technical implementation whilst working on multiple products. Currently working in a demanding production project support environment managing large volumes of business critical data. A committed team player, self motivated with the ability to communicate at all levels.
$15 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have handled many cases similar to your error. I will solve this error in one day. Hope to work with you.
$30 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
I have lots of experience of Query / Process optimization that I had performed in one of the largest bank in Pakistan i.e. United Bank Limited for its core banking system. I ensure optimal solution with no errors i.e. before and after results will be compared thoroughly.
$74 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$23 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$15 AUD in 2 days
0.0 (0 reviews)
0.0
0.0
User Avatar
A proposal has not yet been provided
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
• More than 12Years of total experience in various fields. • More than 8 Years of experience in Oracle 11i/R12 Applications (Oracle EBS) DBA. • Strong experience in Installation, Setup, Training, Implementation, Upgrade, Customization & Product Support of Oracle Applications (R12(12.0,12.1 and 12.2), 11.5.10, 11.5.9) as well Oracle RAC expertise, SOA, Peoplesoft 9 and Fusion Installation and Oracle VM
$25 AUD in 1 day
0.0 (0 reviews)
0.0
0.0
User Avatar
Hi, I'm an experienced DB Admin, but this is my first one as a freelancer, hence the lowest bid. The notified error, ORA-04030, occurs due to the default memory management parameters. This can be very easily sorted out, may be temporarily till the time you execute your script or perhaps as a permanent solution. Cheerz.
$10 AUD in 1 day
0.0 (0 reviews)
0.0
0.0

About the client

Flag of AUSTRALIA
Terrigal, Australia
5.0
11
Payment method verified
Member since Dec 14, 2014

Client Verification

Thanks! We’ve emailed you a link to claim your free credit.
Something went wrong while sending your email. Please try again.
Registered Users Total Jobs Posted
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Loading preview
Permission granted for Geolocation.
Your login session has expired and you have been logged out. Please log in again.