Κλειστό

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.

Ικανότητες: Διαχείριση Βάσεων Δεδομένων, Κατασκευή Βάσης Δεδομένων, Java, Oracle, SQL

Περισσότερα: 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

Σχετικά με τον Εργοδότη:
( 0 αξιολογήσεις ) Hyd, India

Ταυτότητα Εργασίας: #17829783

9 freelancers κάνουν προσφορές κατά μέσο όρο ₹1250 για αυτή τη δουλειά

₹1750 INR σε 1 μέρα
(7 Αξιολογήσεις)
3.5
₹1550 INR σε 2 μέρες
(3 Αξιολογήσεις)
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 Περισσότερα

₹1500 INR σε 1 μέρα
(1 Κριτική)
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 Περισσότερα

₹1300 INR σε 1 μέρα
(0 Αξιολογήσεις)
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 σε 1 μέρα
(0 Αξιολογήσεις)
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 σε 1 μέρα
(0 Αξιολογήσεις)
0.0
subi8952

I have 20 plus experience in Oracle.

₹1500 INR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
niranjanalakh

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

₹1300 INR σε 3 μέρες
(0 Αξιολογήσεις)
0.0
₹1150 INR σε 1 μέρα
(0 Αξιολογήσεις)
0.0