===> Should have expert knowledge in Oracle table partitioning and performance tuning
For purging sub-partitions, we shall have purge profiles.
We have around 2000 bank's... should be distributed among the purge profiles...
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.
9 freelancer đang chào giá trung bình ₹1250 cho công việc này
• 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