FTS Script

I felt most folks looking for full-table scans were not getting the full picture and created my own script to pick up the operations I felt went into this category. [code language=”sql”] #!/bin/ksh sqlplus -s "/ as sysdba" <<EOF spool fts_MRC.log set linesize 200 set pagesize 66 col operation format a13 col object_name format a32 […]