Đã Đóng

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.

Kĩ năng: Quản trị cơ sở dữ liệu, Phát triển cơ sở dữ liệu, Java, Oracle, SQL

Xem nhiều hơn: 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

Về Bên Thuê:
( 0 nhận xét ) Hyd, India

ID dự án: #17829783

9 freelancer đang chào giá trung bình ₹1250 cho công việc này

₹1750 INR trong 1 ngày
(7 Nhận xét)
3.5
₹1550 INR trong 2 ngày
(3 Nhận xét)
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 Thêm

₹1500 INR trong 1 ngày
(1 Nhận xét)
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 Thêm

₹1300 INR trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
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 trong 1 ngày
(0 Nhận xét)
0.0
subi8952

I have 20 plus experience in Oracle.

₹1500 INR trong 3 ngày
(0 Nhận xét)
0.0
niranjanalakh

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

₹1300 INR trong 3 ngày
(0 Nhận xét)
0.0
₹1150 INR trong 1 ngày
(0 Nhận xét)
0.0