SQLTXPLAIN, also known as SQLT, is a tool provided by Oracle Server Technologies Center of Expertise – ST CoE. SQLT inputs one SQL statement and outputs a set of diagnostics files. These files are commonly used to diagnose SQL statements performing poorly. SQLT connects to the database and collects execution plans, Cost-based Optimizer CBO statistics, schema objects metadata, performance statistics, configuration parameters, and similar elements that influence the performance of the SQL being analyzed.
SQLT provides 5 main methods:
- XTRACT Method
- XECUTE Method
- XTRXEC Method
- XTRSBY Method
- XPLAIN Method
How to Download SQLT.
All About the SQLT Diagnostic Tool (Doc ID 215187.1). Download it to any directory and unzip.
[oracle@localhost ~]$ ls sqlt_latest.zip sqlt_latest.zip [oracle@localhost ~]$ unzip sqlt_latest.zip Archive: sqlt_latest.zip creating: sqlt/ creating: sqlt/doc/ inflating: sqlt/doc/sqlt_changes.html creating: sqlt/input/ creating: sqlt/input/sample/ inflating: sqlt/input/sample/db_link.sql creating: sqlt/input/sample/minidb/ inflating: sqlt/input/sample/minidb/create_order_entry_db.sql inflating: sqlt/input/sample/minidb/create_user.sql inflating: sqlt/input/sample/minidb/large_test.sql inflating: sqlt/input/sample/minidb/medium_test.sql inflating: sqlt/input/sample/minidb/small_test.sql inflating: sqlt/input/sample/plsql1.sql inflating: sqlt/input/sample/script1.sql inflating: sqlt/input/sample/script2.sql inflating: sqlt/input/sample/script3.sql inflating: sqlt/input/sample/script4.sql inflating: sqlt/input/sample/sql1.sql inflating: sqlt/input/sample/sql2.sql inflating: sqlt/input/sample/sql3.sql inflating: sqlt/input/sample/sql4.sql inflating: sqlt/input/sample/sql5.sql creating: sqlt/install/ extracting: sqlt/install/install.sql extracting: sqlt/install/setup.sql inflating: sqlt/install/sqcinternal.sql inflating: sqlt/install/sqcobj.sql inflating: sqlt/install/sqcommon1.sql inflating: sqlt/install/sqcparameters.sql inflating: sqlt/install/sqcpkg.sql inflating: sqlt/install/sqcpkga.pkb inflating: sqlt/install/sqcpkga.pks inflating: sqlt/install/sqcpkgc.pkb inflating: sqlt/install/sqcpkgc.pks inflating: sqlt/install/sqcpkgd.pkb inflating: sqlt/install/sqcpkgd.pks inflating: sqlt/install/sqcpkge.pkb inflating: sqlt/install/sqcpkge.pks inflating: sqlt/install/sqcpkgh.pkb inflating: sqlt/install/sqcpkgh.pks inflating: sqlt/install/sqcpkgi.pkb inflating: sqlt/install/sqcpkgi.pks inflating: sqlt/install/sqcpkgm.pkb inflating: sqlt/install/sqcpkgm.pks inflating: sqlt/install/sqcpkgr.pkb inflating: sqlt/install/sqcpkgr.pks inflating: sqlt/install/sqcpkgs.pkb inflating: sqlt/install/sqcpkgs.pks inflating: sqlt/install/sqcpkgt.pkb inflating: sqlt/install/sqcpkgt.pks inflating: sqlt/install/sqcreate.sql inflating: sqlt/install/sqcsilent.sql inflating: sqlt/install/sqcsilent2.sql inflating: sqlt/install/sqcusr.sql inflating: sqlt/install/sqcval0.sql inflating: sqlt/install/sqcval1.sql inflating: sqlt/install/sqcval2.sql inflating: sqlt/install/sqcval3.sql inflating: sqlt/install/sqcval4.sql inflating: sqlt/install/sqcval5.sql inflating: sqlt/install/sqcval6.sql inflating: sqlt/install/sqcvw.sql inflating: sqlt/install/sqdefparams.sql inflating: sqlt/install/sqdobj.sql inflating: sqlt/install/sqdold.sql inflating: sqlt/install/sqdrop.sql inflating: sqlt/install/sqdusr.sql inflating: sqlt/install/sqplcodetype.sql inflating: sqlt/install/sqseed.sql inflating: sqlt/install/squtltest.sql inflating: sqlt/install/tacobj.sql inflating: sqlt/install/tacommon1.sql inflating: sqlt/install/tacpkg.sql inflating: sqlt/install/tacpkge.pkb inflating: sqlt/install/tacpkge.pks inflating: sqlt/install/tacpkgg.pkb inflating: sqlt/install/tacpkgg.pks inflating: sqlt/install/tacpkgi.pkb inflating: sqlt/install/tacpkgi.pks inflating: sqlt/install/tacpkgp.pkb inflating: sqlt/install/tacpkgp.pks inflating: sqlt/install/tacpkgr.pkb inflating: sqlt/install/tacpkgr.pks inflating: sqlt/install/tacpkgt.pkb inflating: sqlt/install/tacpkgt.pks inflating: sqlt/install/tacpkgx.pkb inflating: sqlt/install/tacpkgx.pks inflating: sqlt/install/tacreate.sql inflating: sqlt/install/tacusr.sql inflating: sqlt/install/tacvw.sql inflating: sqlt/install/tadobj.sql inflating: sqlt/install/tadrop.sql inflating: sqlt/install/tadusr.sql inflating: sqlt/install/tasqdirset.sql inflating: sqlt/install/tautltest.sql extracting: sqlt/install/uninstall.sql creating: sqlt/run/ inflating: sqlt/run/sqldx.sql inflating: sqlt/run/sqlhc.sql inflating: sqlt/run/sqlhcxec.sql inflating: sqlt/run/sqltcommon1.sql inflating: sqlt/run/sqltcommon10.sql inflating: sqlt/run/sqltcommon11.sql inflating: sqlt/run/sqltcommon12.sql inflating: sqlt/run/sqltcommon13.sql inflating: sqlt/run/sqltcommon2.sql inflating: sqlt/run/sqltcommon3.sql inflating: sqlt/run/sqltcommon4.sql inflating: sqlt/run/sqltcommon5.sql inflating: sqlt/run/sqltcommon6.sql inflating: sqlt/run/sqltcommon7.sql inflating: sqlt/run/sqltcommon8.sql inflating: sqlt/run/sqltcommon9.sql inflating: sqlt/run/sqltcompare.sql inflating: sqlt/run/sqltgetfile.sql inflating: sqlt/run/sqltrcanlzr.sql inflating: sqlt/run/sqltrcaset.sql inflating: sqlt/run/sqltrcasplit.sql inflating: sqlt/run/sqltrcaxtr.sql inflating: sqlt/run/sqltxecute.sql inflating: sqlt/run/sqltxplain.sql inflating: sqlt/run/sqltxprexc.sql inflating: sqlt/run/sqltxprext.sql inflating: sqlt/run/sqltxtract.sql inflating: sqlt/run/sqltxtrone.sql inflating: sqlt/run/sqltxtrsby.sql inflating: sqlt/run/sqltxtrset.sql inflating: sqlt/run/sqltxtrxec.sql inflating: sqlt/sqlt_instructions.html inflating: sqlt/sqlt_instructions.txt creating: sqlt/utl/ inflating: sqlt/utl/10053.sql inflating: sqlt/utl/bde_chk_cbo.sql inflating: sqlt/utl/coe_gen_sql_patch.sql inflating: sqlt/utl/coe_gen_sql_profile.sql inflating: sqlt/utl/coe_load_sql_baseline.sql inflating: sqlt/utl/coe_load_sql_profile.sql inflating: sqlt/utl/coe_xfr_sql_profile.sql inflating: sqlt/utl/flush.sql inflating: sqlt/utl/flush_cursor.sql creating: sqlt/utl/mon/ inflating: sqlt/utl/mon/0_mon_readme.txt inflating: sqlt/utl/mon/1_mon_repository.sql inflating: sqlt/utl/mon/2_mon_capture.sql inflating: sqlt/utl/mon/3_mon_reports.sql inflating: sqlt/utl/mvhcdr.sql inflating: sqlt/utl/plan.sql inflating: sqlt/utl/profiler.sql inflating: sqlt/utl/pxhcdr.sql inflating: sqlt/utl/sel.sql inflating: sqlt/utl/sel_aux.sql creating: sqlt/utl/spm/ inflating: sqlt/utl/spm/alter_spb.sql inflating: sqlt/utl/spm/coe_load_sql_baseline.sql inflating: sqlt/utl/spm/create_spb_from_awr.sql inflating: sqlt/utl/spm/create_spb_from_cur.sql inflating: sqlt/utl/spm/create_spb_from_sts.sql inflating: sqlt/utl/spm/create_sts_from_awr.sql inflating: sqlt/utl/spm/create_sts_from_cur.sql inflating: sqlt/utl/spm/display_awr.sql inflating: sqlt/utl/spm/display_cur.sql inflating: sqlt/utl/spm/display_spb.sql inflating: sqlt/utl/spm/display_sts.sql inflating: sqlt/utl/spm/drop_cur.sql inflating: sqlt/utl/spm/drop_spb.sql inflating: sqlt/utl/spm/drop_sts.sql inflating: sqlt/utl/spm/evolve_spb.sql inflating: sqlt/utl/spm/imp_and_unpack_spb.sql inflating: sqlt/utl/spm/imp_and_unpack_sts.sql inflating: sqlt/utl/spm/pack_and_exp_spb.sql inflating: sqlt/utl/spm/pack_and_exp_sts.sql inflating: sqlt/utl/spm/readme.txt inflating: sqlt/utl/sqltcdirs.sql inflating: sqlt/utl/sqlthistfile.sql inflating: sqlt/utl/sqlthistpurge.sql inflating: sqlt/utl/sqltimp.sql inflating: sqlt/utl/sqltimpdict.sql inflating: sqlt/utl/sqltimpfo.sql inflating: sqlt/utl/sqltlite.sql inflating: sqlt/utl/sqltmain.sql inflating: sqlt/utl/sqltprofile.sql inflating: sqlt/utl/sqltq.sql inflating: sqlt/utl/sqltresetstatementid.sql inflating: sqlt/utl/sqltupgdbahistash.sql inflating: sqlt/utl/sqlt_parameters.sql creating: sqlt/utl/xgram/ inflating: sqlt/utl/xgram/sqlt_common1.sql inflating: sqlt/utl/xgram/sqlt_delete_column_hgrm.sql inflating: sqlt/utl/xgram/sqlt_delete_hgrm_bucket.sql inflating: sqlt/utl/xgram/sqlt_delete_schema_hgrm.sql inflating: sqlt/utl/xgram/sqlt_delete_table_hgrm.sql inflating: sqlt/utl/xgram/sqlt_display_column_stats.sql inflating: sqlt/utl/xgram/sqlt_insert_hgrm_bucket.sql inflating: sqlt/utl/xgram/sqlt_set_bucket_size.sql inflating: sqlt/utl/xgram/sqlt_set_column_hgrm.sql inflating: sqlt/utl/xgram/sqlt_set_min_max_values.sql creating: sqlt/utl/xhume/ inflating: sqlt/utl/xhume/create_xhume_script.sql inflating: sqlt/utl/xhume/drop_user_objects.sql inflating: sqlt/utl/xhume/install.sql inflating: sqlt/utl/xhume/readme.txt inflating: sqlt/utl/xhume/sqltdiffstats.sql inflating: sqlt/utl/xhume/sqltrstobj.sql inflating: sqlt/utl/xhume/uninstall.sql inflating: sqlt/utl/xhume/user_objects.sql inflating: sqlt/utl/xhume/xhume.pkb inflating: sqlt/utl/xhume/xhume.pks creating: sqlt/utl/xplore/ inflating: sqlt/utl/xplore/create_xplore_script.sql inflating: sqlt/utl/xplore/drop_sys_views.sql inflating: sqlt/utl/xplore/drop_user_objects.sql inflating: sqlt/utl/xplore/install.sql inflating: sqlt/utl/xplore/readme.txt inflating: sqlt/utl/xplore/sys_views.sql inflating: sqlt/utl/xplore/uninstall.sql inflating: sqlt/utl/xplore/user_objects.sql inflating: sqlt/utl/xplore/xplore.pkb inflating: sqlt/utl/xplore/xplore.pks [oracle@bde11dbadm01 ~]$ ls sqlt_latest.zip sqlt_latest.zip [oracle@bde11dbadm01 ~]$ unzip sqlt_latest.zip Archive: sqlt_latest.zip creating: sqlt/ creating: sqlt/doc/ inflating: sqlt/doc/sqlt_changes.html creating: sqlt/input/ creating: sqlt/input/sample/ inflating: sqlt/input/sample/db_link.sql creating: sqlt/input/sample/minidb/ inflating: sqlt/input/sample/minidb/create_order_entry_db.sql inflating: sqlt/input/sample/minidb/create_user.sql inflating: sqlt/input/sample/minidb/large_test.sql inflating: sqlt/input/sample/minidb/medium_test.sql inflating: sqlt/input/sample/minidb/small_test.sql inflating: sqlt/input/sample/plsql1.sql inflating: sqlt/input/sample/script1.sql inflating: sqlt/input/sample/script2.sql inflating: sqlt/input/sample/script3.sql inflating: sqlt/input/sample/script4.sql inflating: sqlt/input/sample/sql1.sql inflating: sqlt/input/sample/sql2.sql inflating: sqlt/input/sample/sql3.sql inflating: sqlt/input/sample/sql4.sql inflating: sqlt/input/sample/sql5.sql creating: sqlt/install/ extracting: sqlt/install/install.sql extracting: sqlt/install/setup.sql inflating: sqlt/install/sqcinternal.sql inflating: sqlt/install/sqcobj.sql inflating: sqlt/install/sqcommon1.sql inflating: sqlt/install/sqcparameters.sql inflating: sqlt/install/sqcpkg.sql inflating: sqlt/install/sqcpkga.pkb inflating: sqlt/install/sqcpkga.pks inflating: sqlt/install/sqcpkgc.pkb inflating: sqlt/install/sqcpkgc.pks inflating: sqlt/install/sqcpkgd.pkb inflating: sqlt/install/sqcpkgd.pks inflating: sqlt/install/sqcpkge.pkb inflating: sqlt/install/sqcpkge.pks inflating: sqlt/install/sqcpkgh.pkb inflating: sqlt/install/sqcpkgh.pks inflating: sqlt/install/sqcpkgi.pkb inflating: sqlt/install/sqcpkgi.pks inflating: sqlt/install/sqcpkgm.pkb inflating: sqlt/install/sqcpkgm.pks inflating: sqlt/install/sqcpkgr.pkb inflating: sqlt/install/sqcpkgr.pks inflating: sqlt/install/sqcpkgs.pkb inflating: sqlt/install/sqcpkgs.pks inflating: sqlt/install/sqcpkgt.pkb inflating: sqlt/install/sqcpkgt.pks inflating: sqlt/install/sqcreate.sql inflating: sqlt/install/sqcsilent.sql inflating: sqlt/install/sqcsilent2.sql inflating: sqlt/install/sqcusr.sql inflating: sqlt/install/sqcval0.sql inflating: sqlt/install/sqcval1.sql inflating: sqlt/install/sqcval2.sql inflating: sqlt/install/sqcval3.sql inflating: sqlt/install/sqcval4.sql inflating: sqlt/install/sqcval5.sql inflating: sqlt/install/sqcval6.sql inflating: sqlt/install/sqcvw.sql inflating: sqlt/install/sqdefparams.sql inflating: sqlt/install/sqdobj.sql inflating: sqlt/install/sqdold.sql inflating: sqlt/install/sqdrop.sql inflating: sqlt/install/sqdusr.sql inflating: sqlt/install/sqplcodetype.sql inflating: sqlt/install/sqseed.sql inflating: sqlt/install/squtltest.sql inflating: sqlt/install/tacobj.sql inflating: sqlt/install/tacommon1.sql inflating: sqlt/install/tacpkg.sql inflating: sqlt/install/tacpkge.pkb inflating: sqlt/install/tacpkge.pks inflating: sqlt/install/tacpkgg.pkb inflating: sqlt/install/tacpkgg.pks inflating: sqlt/install/tacpkgi.pkb inflating: sqlt/install/tacpkgi.pks inflating: sqlt/install/tacpkgp.pkb inflating: sqlt/install/tacpkgp.pks inflating: sqlt/install/tacpkgr.pkb inflating: sqlt/install/tacpkgr.pks inflating: sqlt/install/tacpkgt.pkb inflating: sqlt/install/tacpkgt.pks inflating: sqlt/install/tacpkgx.pkb inflating: sqlt/install/tacpkgx.pks inflating: sqlt/install/tacreate.sql inflating: sqlt/install/tacusr.sql inflating: sqlt/install/tacvw.sql inflating: sqlt/install/tadobj.sql inflating: sqlt/install/tadrop.sql inflating: sqlt/install/tadusr.sql inflating: sqlt/install/tasqdirset.sql inflating: sqlt/install/tautltest.sql extracting: sqlt/install/uninstall.sql creating: sqlt/run/ inflating: sqlt/run/sqldx.sql inflating: sqlt/run/sqlhc.sql inflating: sqlt/run/sqlhcxec.sql inflating: sqlt/run/sqltcommon1.sql inflating: sqlt/run/sqltcommon10.sql inflating: sqlt/run/sqltcommon11.sql inflating: sqlt/run/sqltcommon12.sql inflating: sqlt/run/sqltcommon13.sql inflating: sqlt/run/sqltcommon2.sql inflating: sqlt/run/sqltcommon3.sql inflating: sqlt/run/sqltcommon4.sql inflating: sqlt/run/sqltcommon5.sql inflating: sqlt/run/sqltcommon6.sql inflating: sqlt/run/sqltcommon7.sql inflating: sqlt/run/sqltcommon8.sql inflating: sqlt/run/sqltcommon9.sql inflating: sqlt/run/sqltcompare.sql inflating: sqlt/run/sqltgetfile.sql inflating: sqlt/run/sqltrcanlzr.sql inflating: sqlt/run/sqltrcaset.sql inflating: sqlt/run/sqltrcasplit.sql inflating: sqlt/run/sqltrcaxtr.sql inflating: sqlt/run/sqltxecute.sql inflating: sqlt/run/sqltxplain.sql inflating: sqlt/run/sqltxprexc.sql inflating: sqlt/run/sqltxprext.sql inflating: sqlt/run/sqltxtract.sql inflating: sqlt/run/sqltxtrone.sql inflating: sqlt/run/sqltxtrsby.sql inflating: sqlt/run/sqltxtrset.sql inflating: sqlt/run/sqltxtrxec.sql inflating: sqlt/sqlt_instructions.html inflating: sqlt/sqlt_instructions.txt creating: sqlt/utl/ inflating: sqlt/utl/10053.sql inflating: sqlt/utl/bde_chk_cbo.sql inflating: sqlt/utl/coe_gen_sql_patch.sql inflating: sqlt/utl/coe_gen_sql_profile.sql inflating: sqlt/utl/coe_load_sql_baseline.sql inflating: sqlt/utl/coe_load_sql_profile.sql inflating: sqlt/utl/coe_xfr_sql_profile.sql inflating: sqlt/utl/flush.sql inflating: sqlt/utl/flush_cursor.sql creating: sqlt/utl/mon/ inflating: sqlt/utl/mon/0_mon_readme.txt inflating: sqlt/utl/mon/1_mon_repository.sql inflating: sqlt/utl/mon/2_mon_capture.sql inflating: sqlt/utl/mon/3_mon_reports.sql inflating: sqlt/utl/mvhcdr.sql inflating: sqlt/utl/plan.sql inflating: sqlt/utl/profiler.sql inflating: sqlt/utl/pxhcdr.sql inflating: sqlt/utl/sel.sql inflating: sqlt/utl/sel_aux.sql creating: sqlt/utl/spm/ inflating: sqlt/utl/spm/alter_spb.sql inflating: sqlt/utl/spm/coe_load_sql_baseline.sql inflating: sqlt/utl/spm/create_spb_from_awr.sql inflating: sqlt/utl/spm/create_spb_from_cur.sql inflating: sqlt/utl/spm/create_spb_from_sts.sql inflating: sqlt/utl/spm/create_sts_from_awr.sql inflating: sqlt/utl/spm/create_sts_from_cur.sql inflating: sqlt/utl/spm/display_awr.sql inflating: sqlt/utl/spm/display_cur.sql inflating: sqlt/utl/spm/display_spb.sql inflating: sqlt/utl/spm/display_sts.sql inflating: sqlt/utl/spm/drop_cur.sql inflating: sqlt/utl/spm/drop_spb.sql inflating: sqlt/utl/spm/drop_sts.sql inflating: sqlt/utl/spm/evolve_spb.sql inflating: sqlt/utl/spm/imp_and_unpack_spb.sql inflating: sqlt/utl/spm/imp_and_unpack_sts.sql inflating: sqlt/utl/spm/pack_and_exp_spb.sql inflating: sqlt/utl/spm/pack_and_exp_sts.sql inflating: sqlt/utl/spm/readme.txt inflating: sqlt/utl/sqltcdirs.sql inflating: sqlt/utl/sqlthistfile.sql inflating: sqlt/utl/sqlthistpurge.sql inflating: sqlt/utl/sqltimp.sql inflating: sqlt/utl/sqltimpdict.sql inflating: sqlt/utl/sqltimpfo.sql inflating: sqlt/utl/sqltlite.sql inflating: sqlt/utl/sqltmain.sql inflating: sqlt/utl/sqltprofile.sql inflating: sqlt/utl/sqltq.sql inflating: sqlt/utl/sqltresetstatementid.sql inflating: sqlt/utl/sqltupgdbahistash.sql inflating: sqlt/utl/sqlt_parameters.sql creating: sqlt/utl/xgram/ inflating: sqlt/utl/xgram/sqlt_common1.sql inflating: sqlt/utl/xgram/sqlt_delete_column_hgrm.sql inflating: sqlt/utl/xgram/sqlt_delete_hgrm_bucket.sql inflating: sqlt/utl/xgram/sqlt_delete_schema_hgrm.sql inflating: sqlt/utl/xgram/sqlt_delete_table_hgrm.sql inflating: sqlt/utl/xgram/sqlt_display_column_stats.sql inflating: sqlt/utl/xgram/sqlt_insert_hgrm_bucket.sql inflating: sqlt/utl/xgram/sqlt_set_bucket_size.sql inflating: sqlt/utl/xgram/sqlt_set_column_hgrm.sql inflating: sqlt/utl/xgram/sqlt_set_min_max_values.sql creating: sqlt/utl/xhume/ inflating: sqlt/utl/xhume/create_xhume_script.sql inflating: sqlt/utl/xhume/drop_user_objects.sql inflating: sqlt/utl/xhume/install.sql inflating: sqlt/utl/xhume/readme.txt inflating: sqlt/utl/xhume/sqltdiffstats.sql inflating: sqlt/utl/xhume/sqltrstobj.sql inflating: sqlt/utl/xhume/uninstall.sql inflating: sqlt/utl/xhume/user_objects.sql inflating: sqlt/utl/xhume/xhume.pkb inflating: sqlt/utl/xhume/xhume.pks creating: sqlt/utl/xplore/ inflating: sqlt/utl/xplore/create_xplore_script.sql inflating: sqlt/utl/xplore/drop_sys_views.sql inflating: sqlt/utl/xplore/drop_user_objects.sql inflating: sqlt/utl/xplore/install.sql inflating: sqlt/utl/xplore/readme.txt inflating: sqlt/utl/xplore/sys_views.sql inflating: sqlt/utl/xplore/uninstall.sql inflating: sqlt/utl/xplore/user_objects.sql inflating: sqlt/utl/xplore/xplore.pkb inflating: sqlt/utl/xplore/xplore.pks [oracle@bde11dbadm01 ~]$ ls sqlt_latest.zip sqlt_latest.zip [oracle@bde11dbadm01 ~]$ unzip sqlt_latest.zip Archive: sqlt_latest.zip creating: sqlt/ creating: sqlt/doc/ inflating: sqlt/doc/sqlt_changes.html creating: sqlt/input/ creating: sqlt/input/sample/ inflating: sqlt/input/sample/db_link.sql creating: sqlt/input/sample/minidb/ inflating: sqlt/input/sample/minidb/create_order_entry_db.sql inflating: sqlt/input/sample/minidb/create_user.sql inflating: sqlt/input/sample/minidb/large_test.sql inflating: sqlt/input/sample/minidb/medium_test.sql inflating: sqlt/input/sample/minidb/small_test.sql inflating: sqlt/input/sample/plsql1.sql inflating: sqlt/input/sample/script1.sql inflating: sqlt/input/sample/script2.sql inflating: sqlt/input/sample/script3.sql inflating: sqlt/input/sample/script4.sql inflating: sqlt/input/sample/sql1.sql inflating: sqlt/input/sample/sql2.sql inflating: sqlt/input/sample/sql3.sql inflating: sqlt/input/sample/sql4.sql inflating: sqlt/input/sample/sql5.sql creating: sqlt/install/ extracting: sqlt/install/install.sql extracting: sqlt/install/setup.sql inflating: sqlt/install/sqcinternal.sql inflating: sqlt/install/sqcobj.sql inflating: sqlt/install/sqcommon1.sql inflating: sqlt/install/sqcparameters.sql inflating: sqlt/install/sqcpkg.sql inflating: sqlt/install/sqcpkga.pkb inflating: sqlt/install/sqcpkga.pks inflating: sqlt/install/sqcpkgc.pkb inflating: sqlt/install/sqcpkgc.pks inflating: sqlt/install/sqcpkgd.pkb inflating: sqlt/install/sqcpkgd.pks inflating: sqlt/install/sqcpkge.pkb inflating: sqlt/install/sqcpkge.pks inflating: sqlt/install/sqcpkgh.pkb inflating: sqlt/install/sqcpkgh.pks inflating: sqlt/install/sqcpkgi.pkb inflating: sqlt/install/sqcpkgi.pks inflating: sqlt/install/sqcpkgm.pkb inflating: sqlt/install/sqcpkgm.pks inflating: sqlt/install/sqcpkgr.pkb inflating: sqlt/install/sqcpkgr.pks inflating: sqlt/install/sqcpkgs.pkb inflating: sqlt/install/sqcpkgs.pks inflating: sqlt/install/sqcpkgt.pkb inflating: sqlt/install/sqcpkgt.pks inflating: sqlt/install/sqcreate.sql inflating: sqlt/install/sqcsilent.sql inflating: sqlt/install/sqcsilent2.sql inflating: sqlt/install/sqcusr.sql inflating: sqlt/install/sqcval0.sql inflating: sqlt/install/sqcval1.sql inflating: sqlt/install/sqcval2.sql inflating: sqlt/install/sqcval3.sql inflating: sqlt/install/sqcval4.sql inflating: sqlt/install/sqcval5.sql inflating: sqlt/install/sqcval6.sql inflating: sqlt/install/sqcvw.sql inflating: sqlt/install/sqdefparams.sql inflating: sqlt/install/sqdobj.sql inflating: sqlt/install/sqdold.sql inflating: sqlt/install/sqdrop.sql inflating: sqlt/install/sqdusr.sql inflating: sqlt/install/sqplcodetype.sql inflating: sqlt/install/sqseed.sql inflating: sqlt/install/squtltest.sql inflating: sqlt/install/tacobj.sql inflating: sqlt/install/tacommon1.sql inflating: sqlt/install/tacpkg.sql inflating: sqlt/install/tacpkge.pkb inflating: sqlt/install/tacpkge.pks inflating: sqlt/install/tacpkgg.pkb inflating: sqlt/install/tacpkgg.pks inflating: sqlt/install/tacpkgi.pkb inflating: sqlt/install/tacpkgi.pks inflating: sqlt/install/tacpkgp.pkb inflating: sqlt/install/tacpkgp.pks inflating: sqlt/install/tacpkgr.pkb inflating: sqlt/install/tacpkgr.pks inflating: sqlt/install/tacpkgt.pkb inflating: sqlt/install/tacpkgt.pks inflating: sqlt/install/tacpkgx.pkb inflating: sqlt/install/tacpkgx.pks inflating: sqlt/install/tacreate.sql inflating: sqlt/install/tacusr.sql inflating: sqlt/install/tacvw.sql inflating: sqlt/install/tadobj.sql inflating: sqlt/install/tadrop.sql inflating: sqlt/install/tadusr.sql inflating: sqlt/install/tasqdirset.sql inflating: sqlt/install/tautltest.sql extracting: sqlt/install/uninstall.sql creating: sqlt/run/ inflating: sqlt/run/sqldx.sql inflating: sqlt/run/sqlhc.sql inflating: sqlt/run/sqlhcxec.sql inflating: sqlt/run/sqltcommon1.sql inflating: sqlt/run/sqltcommon10.sql inflating: sqlt/run/sqltcommon11.sql inflating: sqlt/run/sqltcommon12.sql inflating: sqlt/run/sqltcommon13.sql inflating: sqlt/run/sqltcommon2.sql inflating: sqlt/run/sqltcommon3.sql inflating: sqlt/run/sqltcommon4.sql inflating: sqlt/run/sqltcommon5.sql inflating: sqlt/run/sqltcommon6.sql inflating: sqlt/run/sqltcommon7.sql inflating: sqlt/run/sqltcommon8.sql inflating: sqlt/run/sqltcommon9.sql inflating: sqlt/run/sqltcompare.sql inflating: sqlt/run/sqltgetfile.sql inflating: sqlt/run/sqltrcanlzr.sql inflating: sqlt/run/sqltrcaset.sql inflating: sqlt/run/sqltrcasplit.sql inflating: sqlt/run/sqltrcaxtr.sql inflating: sqlt/run/sqltxecute.sql inflating: sqlt/run/sqltxplain.sql inflating: sqlt/run/sqltxprexc.sql inflating: sqlt/run/sqltxprext.sql inflating: sqlt/run/sqltxtract.sql inflating: sqlt/run/sqltxtrone.sql inflating: sqlt/run/sqltxtrsby.sql inflating: sqlt/run/sqltxtrset.sql inflating: sqlt/run/sqltxtrxec.sql inflating: sqlt/sqlt_instructions.html inflating: sqlt/sqlt_instructions.txt creating: sqlt/utl/ inflating: sqlt/utl/10053.sql inflating: sqlt/utl/bde_chk_cbo.sql inflating: sqlt/utl/coe_gen_sql_patch.sql inflating: sqlt/utl/coe_gen_sql_profile.sql inflating: sqlt/utl/coe_load_sql_baseline.sql inflating: sqlt/utl/coe_load_sql_profile.sql inflating: sqlt/utl/coe_xfr_sql_profile.sql inflating: sqlt/utl/flush.sql inflating: sqlt/utl/flush_cursor.sql creating: sqlt/utl/mon/ inflating: sqlt/utl/mon/0_mon_readme.txt inflating: sqlt/utl/mon/1_mon_repository.sql inflating: sqlt/utl/mon/2_mon_capture.sql inflating: sqlt/utl/mon/3_mon_reports.sql inflating: sqlt/utl/mvhcdr.sql inflating: sqlt/utl/plan.sql inflating: sqlt/utl/profiler.sql inflating: sqlt/utl/pxhcdr.sql inflating: sqlt/utl/sel.sql inflating: sqlt/utl/sel_aux.sql creating: sqlt/utl/spm/ inflating: sqlt/utl/spm/alter_spb.sql inflating: sqlt/utl/spm/coe_load_sql_baseline.sql inflating: sqlt/utl/spm/create_spb_from_awr.sql inflating: sqlt/utl/spm/create_spb_from_cur.sql inflating: sqlt/utl/spm/create_spb_from_sts.sql inflating: sqlt/utl/spm/create_sts_from_awr.sql inflating: sqlt/utl/spm/create_sts_from_cur.sql inflating: sqlt/utl/spm/display_awr.sql inflating: sqlt/utl/spm/display_cur.sql inflating: sqlt/utl/spm/display_spb.sql inflating: sqlt/utl/spm/display_sts.sql inflating: sqlt/utl/spm/drop_cur.sql inflating: sqlt/utl/spm/drop_spb.sql inflating: sqlt/utl/spm/drop_sts.sql inflating: sqlt/utl/spm/evolve_spb.sql inflating: sqlt/utl/spm/imp_and_unpack_spb.sql inflating: sqlt/utl/spm/imp_and_unpack_sts.sql inflating: sqlt/utl/spm/pack_and_exp_spb.sql inflating: sqlt/utl/spm/pack_and_exp_sts.sql inflating: sqlt/utl/spm/readme.txt inflating: sqlt/utl/sqltcdirs.sql inflating: sqlt/utl/sqlthistfile.sql inflating: sqlt/utl/sqlthistpurge.sql inflating: sqlt/utl/sqltimp.sql inflating: sqlt/utl/sqltimpdict.sql inflating: sqlt/utl/sqltimpfo.sql inflating: sqlt/utl/sqltlite.sql inflating: sqlt/utl/sqltmain.sql inflating: sqlt/utl/sqltprofile.sql inflating: sqlt/utl/sqltq.sql inflating: sqlt/utl/sqltresetstatementid.sql inflating: sqlt/utl/sqltupgdbahistash.sql inflating: sqlt/utl/sqlt_parameters.sql creating: sqlt/utl/xgram/ inflating: sqlt/utl/xgram/sqlt_common1.sql inflating: sqlt/utl/xgram/sqlt_delete_column_hgrm.sql inflating: sqlt/utl/xgram/sqlt_delete_hgrm_bucket.sql inflating: sqlt/utl/xgram/sqlt_delete_schema_hgrm.sql inflating: sqlt/utl/xgram/sqlt_delete_table_hgrm.sql inflating: sqlt/utl/xgram/sqlt_display_column_stats.sql inflating: sqlt/utl/xgram/sqlt_insert_hgrm_bucket.sql inflating: sqlt/utl/xgram/sqlt_set_bucket_size.sql inflating: sqlt/utl/xgram/sqlt_set_column_hgrm.sql inflating: sqlt/utl/xgram/sqlt_set_min_max_values.sql creating: sqlt/utl/xhume/ inflating: sqlt/utl/xhume/create_xhume_script.sql inflating: sqlt/utl/xhume/drop_user_objects.sql inflating: sqlt/utl/xhume/install.sql inflating: sqlt/utl/xhume/readme.txt inflating: sqlt/utl/xhume/sqltdiffstats.sql inflating: sqlt/utl/xhume/sqltrstobj.sql inflating: sqlt/utl/xhume/uninstall.sql inflating: sqlt/utl/xhume/user_objects.sql inflating: sqlt/utl/xhume/xhume.pkb inflating: sqlt/utl/xhume/xhume.pks creating: sqlt/utl/xplore/ inflating: sqlt/utl/xplore/create_xplore_script.sql inflating: sqlt/utl/xplore/drop_sys_views.sql inflating: sqlt/utl/xplore/drop_user_objects.sql inflating: sqlt/utl/xplore/install.sql inflating: sqlt/utl/xplore/readme.txt inflating: sqlt/utl/xplore/sys_views.sql inflating: sqlt/utl/xplore/uninstall.sql inflating: sqlt/utl/xplore/user_objects.sql inflating: sqlt/utl/xplore/xplore.pkb inflating: sqlt/utl/xplore/xplore.pks [oracle@localhost ~]$
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Skant Gupta’s LinkedIn: www.linkedin.com/in/skantali/
Joel Perez’s LinkedIn: Joel Perez’s Profile
Anuradha’s LinkedIn: Anuradha’s Profile
LinkedIn Group: Oracle Cloud DBAAS
Facebook Page: OracleHelp
