In oracle database we have different techniques for performance optimization like Indexing on column, partitioning on large table , apply hints in case of wrong execution plan,check the dependency,stays on table,table lock situation