Cerrado

Oracle table(range) partition with sub-partition strategy ..

===> Should have expert knowledge in Oracle table partitioning and performance tuning

NOTE: Confidential

--------------------------------

For purging sub-partitions, we shall have purge profiles.

We have around 2000 bank's... should be distributed among the purge profiles...

purge profile

30 days...

60 days...

90 days...

we shall have column retprofile as sub-partition & continue with partition key as "createdate".

We need to evaluate the queries response time and query execution plan for the new table

The query which includes only the partition key

Query with partition + sub-partition key

Query without partition + sub-partition key

Query with joining other tables. ( application queries)

Decide on partition strategy based on the query performance stats

a. Non-partition table

b. Partition table

c. Partition & sub-partition

&&&&&& AND ...

Should have expert practical knowledge Oracle performance tuning ( AWR, ADDM, ASH reports), long-running query tuning

NOTE: Good to have knowledge in - ant builds , WBI , Jetty , WAS.

Habilidades: Administración de bases de datos, Desarrollo de base de datos, Java, Oracle, SQL

Ver más: table partitioning in oracle 11g, range partition in oracle, list partition in oracle, advantages and disadvantages of table partitioning in oracle, how to query partition table in oracle, oracle partitioning license, oracle table partitioning best practices, oracle partitioning 12c, java create xml oracle table, display table range days php, mysql generate table range dates, oracle table diagram, decimal numbers jsp oracle table, vba convert table range, oracle encryption range queries, project oracle table diagram, parsing xml oracle table, oracle table insert script, code convert table range, excel convert table range

Información del empleador:
( 0 comentarios ) Hyd, India

Nº del proyecto: #17829783

9 freelancers están ofertando el promedio de ₹1250 para este trabajo

₹1750 INR en 1 día
(7 comentarios)
3.5
₹1550 INR en 2 días
(3 comentarios)
3.0
hammadabbasi01

Oracle RDBMS and EBS Certified professional with over 11 years’ experience in a wide range of environments and have used Oracle versions 9.0 through to 12c on different operating systems. Troubleshooting, tuning, backu Más

₹1500 INR en 1 día
(1 comentario)
1.0
sitanmishra

As i have gone through your initial requirements and have understood that you need an excellent developer for design and development of your website application and i am confident to deliver you the best desired result Más

₹1300 INR en 1 día
(0 comentarios)
0.0
rpjantonio

Hi, I can help you - I will do it for you cheaper as the freelancer allows , but I will need a review. Thanks, Rogerio

₹600 INR en 1 día
(0 comentarios)
0.0
vamsimynene

• Around 9.5 years of Strong development experience with Oracle PL/SQL, UNIX shell scripting and 3 Years in Informatics power center. I will be able to provide

₹600 INR en 1 día
(0 comentarios)
0.0
subi8952

I have 20 plus experience in Oracle.

₹1500 INR en 3 días
(0 comentarios)
0.0
niranjanalakh

Having 10+ years of DBA experience and through knowledge about partitioning and Performance Tuning Approach .

₹1300 INR en 3 días
(0 comentarios)
0.0
₹1150 INR en 1 día
(0 comentarios)
0.0