It is not easy task to manually deal with too many jobs. So to overcome with this this scenario oracle database provides advanced job scheduling capabilities through Oracle Scheduler. The DBMS_SCHEDULER package provides a collection of scheduling functions and procedures that are callable from any PL/SQL program.
Using...
How to Lock/Unlock Table Statistics in Oracle
There are a number of cases were you want to lock the table statistics for example, if you have a highly volatile tables or intermediate table, where the volume of data changes drastically over a relatively short period of time or if you want a table not be analyzed by automatic statistics job but analyze it...
Script to Start Oracle Database Automatically on Linux
From Oracle 10gR2 onward RAC clusterware automatically start and stop the ASM and Oracle database instances and listeners, so the following procedures are not necessary. But for the single instance where the RAC is not being used, this script will allow you to automate the startup and shutdown of oracle databases...
How to Gather Statistics on Large Partitioned Tables in Oracle
It is difficult to gather stats on large partition tables which is huge in size, specially in core domain like telecom sectors where customers has to maintain call detail records in a partitioned table which are very big and huge in size.
For such tables we use to gather statistics of one partition which we...
Oracle Expdp/Impdp - Datapump Interview Questions/FAQs
Q1. How to export only ddl/metadata of a table?
Ans: you can use CONTENT=METADATA_ONLY parameter during export.
Q2: Which memory area used by datapump process?
Ans: streams_pool_size. If streams_pool_size is zero 0 then probably you will get memory related error. Please check this parameter and set...
How to Find and Remove Table Fragmentation in Oracle Database
Introduction
In this article I will discuss about table fragmentation, which cause slowness and a wastage of space. Fragmentation is a common...
Subscribe to:
Posts (Atom)