PL/SQL coder needed for one time freelance work.

zł90-750 PLN

Käynnissä

Julkaistu

noin 6 vuotta sitten

zł90-750 PLN

Maksettu toimituksen yhteydessä

I am an individual and work as an IT professional myself. This is a quick one time requirement and a simple and straight forward task. I need someone to write a script to generate alerts for long running sqls from Oracle database and send it via email with the following information. - Capture distinct long running sql ids > 30 mins elapsed time - Provide sql execution history with hash value changes - Provide explain plan for each hash value - Capture the tables involved in the sqls - If not partitioned, provide table level stats info(stale or not) - If partitioned, provide table level stats info(stale or not) and info - - Regarding any partitions or subpartitions only if their stale - Provide dba_tab_modifications info on the stale tables, partitions or subpartitions The coder should also be willing to explain parts of the script if requested.

Coding

Database Administration

Database Development

Database Programming

Oracle

Projektin tunnus (ID): 16472700

Tietoa projektista

19 ehdotukset

Etäprojekti

Aktiivinen 6 vuotta sitten

Haluatko ansaita rahaa?

Sähköpostiosoite

Freelancerin tarjouskilpailun edut

Aseta budjettisi ja aikataulu

Saa maksu työstäsi

Kuvaile ehdotustasi

Rekisteröinti ja töihin tarjoaminen on ilmaista

Myönnetty käyttäjälle:

@tudorantohi

I am an Oracle OCE expert 12 and I already have these scripts created. I accept paypal. The way to look into stale stats is much easier. The rest is pretty easy...

zł500 PLN 1 päivässä

0,0

(0 arvostelua)

0,0

19 freelancerit tarjoavat keskimäärin zł475 PLN tätä projektia

@AuspCluster

A proposal has not yet been provided

zł211 PLN 2 päivässä

5,0

(1 arvostelu)

1,5

@pratik123

Hey let’s have discussions around requirement. I am sure I can work on same as I have 13 years of playlist development experience. Looking forward to contact you soon.

zł666 PLN 5 päivässä

5,0

(1 arvostelu)

1,6

@rarruda1988

Good afternoon! Currently working with Business Intelligence, where my job is to turn data into relevant information and present it in reports and dashboards. I work daily with multiple data sources at the same time to analyze the information, see what are duplicates, if a request is in all systems, then I believe that I am fit for the project. Software used: Builder Dashboards and Reports: Tableau, Power B.I ETL(Data processing) Integration Services and Pentaho Data Integration Databases: Oracle,SQL Server, MySQL Best regards.

zł466 PLN 10 päivässä

5,0

(1 arvostelu)

0,6

@mirlamontesdeoc

A proposal has not yet been provided

zł466 PLN 3 päivässä

0,0

(0 arvostelua)

0,0

@evgenyshebanin

I am freelancing database acrhitect and BI analyst with more than 18 years of experience in designing, implementing and maintaining reporting solutions and data integration platforms for financial reporting systems. My database stack consists of design, development and fine-tuning of data models, procedural code and data integration scripts across Oracle (20 years), MySQL (3 years), PostgreSQL (2 years). My ETL stack comprises visual tools Talend (3 years), ODI (2 years), IBM Datastage (2 years), scripting tools Perl (4 years), Python (3 years) and database native loaders of Oracle (10 years) and PostgreSQL (2 years). My technology experience comprises following - Custom PL/SQL devlopment in Oracle, daily tasks for already 20 years - Front-development with Oracle Forms 6i, 10g, 11g, daily tasks for already 12 years - Report design with Oracle Reports (6i and 10g) and Oracle XML Publisher, for already 12 years - Oracle peformance tuning tasks, for already 12 years • ETL jobs design in Talend, ODI, Datastage. Happy to help you with your needs in Oracle Reports - have a good experience with Crystal Reports as well.

zł450 PLN 3 päivässä

0,0

(0 arvostelua)

0,0

@ShadaniDBA

Half part I will complete immediately like long running queries and explain plan , later scrits coding I will need some times.

zł500 PLN 14 päivässä

0,0

(0 arvostelua)

0,0

@ellislax23

Hi I am a software engineer with a strong expertise in sql. I write queries, stored procedures and reports using SSMS and SSRS everyday at my day job. Let’s talk more about what all you have and what you need to so I can get started for you.

zł555 PLN 1 päivässä

0,0

(0 arvostelua)

0,0

@msa5aa73d4ac4375

I have 4 years of experience in oracle apps & i have worked on similar requirement for alerts, i have generated explain plans earlier also

zł466 PLN 3 päivässä

0,0

(0 arvostelua)

0,0

@punitinfotechsol

A proposal has not yet been provided

zł211 PLN 3 päivässä

0,0

(0 arvostelua)

0,0

@AnujRana25

I am currently working as a PLSQL developer in a reputed organization for more than 2.5 years and worked on many complex items as part of my everyday task

zł466 PLN 3 päivässä

0,0

(0 arvostelua)

0,0

@datotahost

Hi, Please let me know what you like to have in call then we can come on pricing or complete detail or maintenance service will be provided for monthly

zł666 PLN 5 päivässä