Uncategorised

Oracle Tutorials: List of oralce commands for every Oracle Administrator

May 3, 2023 Leave a Comment
  1. SQL*Plus – The command line interface for executing SQL and PL/SQL commands.
  2. RMAN (Recovery Manager) – The Oracle tool for backup and recovery of databases.
  3. EXPDP (Export Data Pump) – The command used to export data from a database.
  4. IMPDP (Import Data Pump) – The command used to import data into a database.
  5. SQL Loader – The command line utility used to load data from flat files into Oracle tables.
  6. ADDM (Automatic Database Diagnostic Monitor) – A tool for diagnosing performance issues in the database.
  7. ASH (Active Session History) – A tool for monitoring and diagnosing performance issues in real-time.
  8. AWR (Automatic Workload Repository) – A tool for collecting and storing database performance statistics.
  9. TKPROF – A tool used to analyze Oracle trace files generated by SQL tracing.
  10. ORAchk – A tool for performing system checks and generating reports for Oracle databases.
  11. SQL Tuning Advisor – A tool for identifying and recommending SQL statement optimizations.
  12. SQL Access Advisor – A tool for recommending the creation of indexes and materialized views.
  13. Statspack – A tool for collecting and storing performance statistics for analysis.
  14. Data Pump Export – A utility used to export database objects and data into a set of operating system files called a dump file set.
  15. Data Pump Import – A utility used to import database objects and data from a dump file set into a target database.
  16. ADRCI – A tool for managing Oracle Database diagnostic data.
  17. Opatch – A tool used for patching Oracle software.
  18. SRVCTL – A tool for managing Oracle Real Application Clusters (RAC).
  19. CRSCTL – A tool for managing Oracle Clusterware.
  20. EMCTL – A command line tool for managing Oracle Enterprise Manager.
Rajesh Kumar
Follow me
Latest posts by Rajesh Kumar (see all)
Subscribe
Notify of
guest
0 Comments
Inline Feedbacks
View all comments
0
Would love your thoughts, please comment.x
()
x