{"id":33692,"date":"2023-05-03T02:38:43","date_gmt":"2023-05-03T02:38:43","guid":{"rendered":"https:\/\/www.devopsschool.com\/blog\/?p=33692"},"modified":"2023-05-03T02:38:45","modified_gmt":"2023-05-03T02:38:45","slug":"oracle-tutorials-list-of-oralce-commands-for-every-oracle-administrator","status":"publish","type":"post","link":"https:\/\/www.devopsschool.com\/blog\/oracle-tutorials-list-of-oralce-commands-for-every-oracle-administrator\/","title":{"rendered":"Oracle Tutorials: List of oralce commands for every Oracle Administrator"},"content":{"rendered":"\n
    \n
  1. SQL*Plus – The command line interface for executing SQL and PL\/SQL commands.<\/li>\n\n\n\n
  2. RMAN (Recovery Manager) – The Oracle tool for backup and recovery of databases.<\/li>\n\n\n\n
  3. EXPDP (Export Data Pump) – The command used to export data from a database.<\/li>\n\n\n\n
  4. IMPDP (Import Data Pump) – The command used to import data into a database.<\/li>\n\n\n\n
  5. SQL Loader – The command line utility used to load data from flat files into Oracle tables.<\/li>\n\n\n\n
  6. ADDM (Automatic Database Diagnostic Monitor) – A tool for diagnosing performance issues in the database.<\/li>\n\n\n\n
  7. ASH (Active Session History) – A tool for monitoring and diagnosing performance issues in real-time.<\/li>\n\n\n\n
  8. AWR (Automatic Workload Repository) – A tool for collecting and storing database performance statistics.<\/li>\n\n\n\n
  9. TKPROF – A tool used to analyze Oracle trace files generated by SQL tracing.<\/li>\n\n\n\n
  10. ORAchk – A tool for performing system checks and generating reports for Oracle databases.<\/li>\n\n\n\n
  11. SQL Tuning Advisor – A tool for identifying and recommending SQL statement optimizations.<\/li>\n\n\n\n
  12. SQL Access Advisor – A tool for recommending the creation of indexes and materialized views.<\/li>\n\n\n\n
  13. Statspack – A tool for collecting and storing performance statistics for analysis.<\/li>\n\n\n\n
  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.<\/li>\n\n\n\n
  15. Data Pump Import – A utility used to import database objects and data from a dump file set into a target database.<\/li>\n\n\n\n
  16. ADRCI – A tool for managing Oracle Database diagnostic data.<\/li>\n\n\n\n
  17. Opatch – A tool used for patching Oracle software.<\/li>\n\n\n\n
  18. SRVCTL – A tool for managing Oracle Real Application Clusters (RAC).<\/li>\n\n\n\n
  19. CRSCTL – A tool for managing Oracle Clusterware.<\/li>\n\n\n\n
  20. EMCTL – A command line tool for managing Oracle Enterprise Manager.<\/li>\n<\/ol>\n","protected":false},"excerpt":{"rendered":"","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_kad_post_transparent":"","_kad_post_title":"","_kad_post_layout":"","_kad_post_sidebar_id":"","_kad_post_content_style":"","_kad_post_vertical_padding":"","_kad_post_feature":"","_kad_post_feature_position":"","_kad_post_header":false,"_kad_post_footer":false,"_kad_post_classname":"","_joinchat":[],"footnotes":""},"categories":[2],"tags":[],"class_list":["post-33692","post","type-post","status-publish","format-standard","hentry","category-uncategorised"],"_links":{"self":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/33692","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/comments?post=33692"}],"version-history":[{"count":1,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/33692\/revisions"}],"predecessor-version":[{"id":33693,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/posts\/33692\/revisions\/33693"}],"wp:attachment":[{"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/media?parent=33692"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/categories?post=33692"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.devopsschool.com\/blog\/wp-json\/wp\/v2\/tags?post=33692"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}