sho_stat_lvl()
{
######################################################################
# This will show some interesting stuff from v$statistics_level;
######################################################################
sqlplus -s "/ as sysdba" <
set pages 200
PROMPT
PROMPT Show the statistics level in the database
PROMPT
set lines 120
set pages 66
SELECT statistics_name, activation_level, system_status
FROM v\$statistics_level;
-- spool off
EOF
}
sho_indx()
######################################
# List the indexes
######################################
{
sqlplus -s "/ as sysdba" <
set lines 120
set pages 66
select index_name from dba_indexes
order by index_name;
spool off
EOF
}
This is the library for the pre-install setup for Linux against Oracle
This can have functions for 11g as well as 12c, I decided combine them into one library
Here is a link to Steve Karem's website discussing 12c new features Oracle Alchemist.com
AWR Stuff
http://www.askmaclean.com/archives/script-awr-trending.html
Role Transition Best Practices MAA White Paper