PL/SQL coder needed for one time freelance work.

zł90-750 PLN

Status

Publicerad

ungefär sex år sedan

zł90-750 PLN

Betalning vid leverans

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

Project ID: 16472700

Om projektet

19 anbud

Distansprojekt

Senaste aktivitet sex år sedan

Ute efter att tjäna lite pengar?

E-postadress

Fördelar med att lägga anbud hos Freelancer

Ange budget och tidsram

Få betalt för ditt arbete

Beskriv ditt förslag

Det är gratis att registrera sig och att lägga anbud på uppdrag

Tilldelad till:

@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 Om 1 dag

0,0

(0 omdömen)

0,0

19 frilansar lägger i genomsnitt anbud på zł475 PLN för detta uppdrag

@AuspCluster

A proposal has not yet been provided

zł211 PLN Om 2 dagar

5,0

(1 omdöme)

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 Om 5 dagar

5,0

(1 omdöme)

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 Om 10 dagar

5,0

(1 omdöme)

0,6

@mirlamontesdeoc

A proposal has not yet been provided

zł466 PLN Om 3 dagar

0,0

(0 omdömen)

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 Om 3 dagar

0,0

(0 omdömen)

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 Om 14 dagar

0,0

(0 omdömen)

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 Om 1 dag

0,0

(0 omdömen)

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 Om 3 dagar

0,0

(0 omdömen)

0,0

@punitinfotechsol

A proposal has not yet been provided

zł211 PLN Om 3 dagar

0,0

(0 omdömen)

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 Om 3 dagar

0,0

(0 omdömen)

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 Om 5 dagar