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.

Keahlian: Administrasi Basis Data, Pengembangan Database, Java, Oracle, SQL

Lihat lebih lanjut: 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

Tentang Pemberi kerja:
( 0 ulasan ) Hyd, India

ID Proyek: #17829783

9 freelancer menawar dengan rata-rata ₹1250 untuk pekerjaan ini

₹1750 INR dalam 1 hari
(7 Ulasan)
₹1550 INR dalam 2 hari
(3 Ulasan)

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 Lebih banyak

₹1500 INR dalam 1 hari
(1 Ulasan)

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 Lebih banyak

₹1300 INR dalam 1 hari
(0 Ulasan)

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 dalam 1 hari
(0 Ulasan)

• 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 dalam 1 hari
(0 Ulasan)

I have 20 plus experience in Oracle.

₹1500 INR dalam 3 hari
(0 Ulasan)

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

₹1300 INR dalam 3 hari
(0 Ulasan)
₹1150 INR dalam 1 hari
(0 Ulasan)