Function library called apex_common.ksh (rename it later)
Functions include currently:
######################################################
# SECTION
# Initialize section
# and test functions
#
# mrctest
# root_setup
# init_apex
######################################################
# SECTION GENERAL DB
# Initialize section
# and test functions
#
# db_fixes_ver
######################################################
# SECTION APEX SPECIFIC
# Initialize section and test functions
#
# apex_hc
# lst_db - needs init_apex fn executed first
# lst_db_all
# lst_db_full
# count_db
# count_cls
# count_mch
# find_db
# find_mch
# find_cls
#########################
# Utility
#
# cnt_yn
# gen_srv_lst
# gen_srv_lst_verbose
# lst_type_hm ()
# lst_type_dir ()
# lst_db_apex_id ()
# db_rec_parm()
# db_psu
# sho_env - THIS MAY BE DUPLICATE
# sho_alias - THIS MAY BE DUPLICATE
# ins_audit_old ()
#################################################################
# ASM Section
#
# asm_disk
# asm_disk_sysasm
# sho_asm_disk
# asm_unbal
# asm_dsk_sze
# asm_0002
# asm_disk_ops
# asm_test
######################################
# Utility section #2
#
# chk_sqlp
# next_menu
# chk_sys_pass
# run_sql_statement
# dir_chk
# dir_chk_cr
# remote_connect
# db_switch
######################################################################
# Utility section #3
#
# initialize
# init_mrc
# gen_db_lst
# crs_srv_lst_cfg
# crs_sho_srv_cfg_home
# crs_sho_srvctl_cfg
# crs_sho_srvctl_stat
# crs_sho_srvctl_db_stat
# test_vip
# ocr_chk
# find_db_02
#####################################################################
# Utility functions
#
# save_env
# sho_env
# rest_env
# disp_inst
# rest_save
# chk_db_nm2dblst
# sho_insts
# chg_inst
# chk_db_running
# get_crs_clust_name
# insertMCH_InCentralRepository
# updt_mch_InCentralRepository
# mch_InCentralRepository
# get_inst_details
# insertInst_InCentralRepository
# inst_InCentralRepository
# get_db_details
# update_mach_details
# update_db_details
# cpu_usage_02
# sho_db_details
# updt_db_InCentralRepository
# db_InCentralRepository
# insertDB_InCentralRepository
# insertDB_APEX
# mrc_readdb
# mrc_upd_disk
###########################################################
# Cluster functions
#
# cls_qa_chk () - Cluster QA check
# cls_qa_upd () - Update the cluster record
# cls_qa_rev ()
# cls_rec_disp ()
# db_qa_chk ()
# db_qa_upd()
# db_qa_rev()
# sho_db_ver() - Show database version
# find_db2()
# sho_cls()
# sho_apex_db
# sho_apex_app
###########################################################
# DB Utility
#
# db_ind_size
# db_size_comp
# db_size
# db_loop_inst - Loop through the database instances
# db_stub - Stub function
# dashboard - This is the dashboard function
# menu_sel_text
###########################################################
# ORAchk section
# init_orachk - Sets up the variables needed for running the ORAchk stuff
# start_orachk - Starts ORAchk daemon
# get_all_parms_orachk - Shows all of the parms for ORAchk
# status_orachk - Shows the status of ORAchk
# stop_orachk - Stops the ORAchk daemon
# version_orachk - Shows the version of ORAchk
# all_orachk
# orachk --help
###########################################################
# dcli_ver
# dcli_hlp
# init_exp
# init_exp_scp
# BatchExpert
# Batch_Expert_scp
# dir_cr_apex
# dir_cr_cls
# ins_audit
# clustat
# sho_webdb
# sho_dir
# init_oem
# oem_stat_agt
# oem_stat_agt_hb
# oem_stat_sched
# oem_stat_sched_db
# tblspc_used
# enable_bct
# use_lrg_pgs
# fts_mrc
# lst_dba_users
# lst_any_apex_users
# lst_dba_sys_privs
# add_tgt
# huge_pages
# sho_huge_pages
# sho_alias
# sho_memory
# sho_sysctl
# must_gather
# usage_mg
awr_stats_mrc_fn.ksh - Is the function that uses the functions listed below
# awr_set_env
# awr_get_ver
# awr_inst_no
# awr_dbid
# awr_max_snap
# awr_min_snap
# awr_stat_10 - AWR Stats for Oracle version 10g
# awr_stat_11 - AWR Stats for Oracle version 11g
# awr_stat_12 - AWR Stats for Oracle version 12c
main_menu
menu_02
menu_03 -
menu_perftune - Performance tuning menu
menu_tmplt - menu template
test_load - test load function from the DPODS project
sess_trc - Session trace could be very useful
trnc_tbl - Truncate table function
sho_const - Shows the contraints
buff_blast - This will clear the buffer for the SGA
cannot_use_thi_sql_id_mrc() - Needs some work
find_sql_ids - Find SQL IDs
sho_plan_sql_id - Shows the plan from a SQL ID
Sho_db_param - Shows the current database parameters
Sho_dbid - shows the current database dbid
sho_dbid_fn.ksh - Script that uses the function
chg_awr_days - takes 2 parameters, db_id and retention value in minutes
chk_fra - Check and sho the FRA space
sho_dir_s20 - show the directory for scripts from
chk_interconn - Check the interconnect
chk_interconn_fn.ksh - Script that uses the function
chk_svcs - check the services of a database
#################################################
DDL_COMMON.ksh
#################################################
lst_objs_all
lst_objs_schm - List all objects by schema, schema is the parameter
lst_objs_schm_tbls - uses the LIKE
lst_objs_PIPER
test_conn_user - test what they can read as $1 user, $2 pword
cnt_CST_L01_OWNER
cnt_PIPER_D11_OWNER
qry_template_function
lst_users
lst_all_users
drp_app_users
sho_users
sho_quotas
sho_sessions
sho_session_02
chg_quota_PIPER_D11_OWNER
chg_pword_PIPER_D11_STAGING
chg_pword_all_PIPER_D11
qry_01_test
qry_02_test
qry_03_test
qry_04_test
qry_05_test
qry_06_test
qry_07_test
qry_08_test
chg_pword_all_CST_L01
chg_pword_all_MISITE
chg_pwd
obj_cnt
grant_piper_d11_user_role
cr_ctrl_hst_tab
cr_cntrl_tab - original function NOT USED anymore
test_ctrl_tab
sho_stg_tbl_cnt
sho_tbl_cnt_core
sho_trigger_cnt
sho_seq
grnt_role
test_conn_user
test_conn_core_tbl
cr_dba_gg_tst_usr
cr_dba_gg_tst_objs
sho_gg_test_tbl
test_gg_ins
test_gg_upd
gg_stat
gg_start_extr
gg_cr_extr_parm
gg_cr_repl_parm
test_gg_del
cr_180_trunc
cr_180_stats
test_query_11
gg_chk_ddl
sho_roles
sho_all_db_roles - Shows all roles in the database
cp_ddl_com
sho_db_param
sho_svcs
const
cp_piper_dev
cp_piper_exa_TT
cp_piper_exa_PD
cp_piper_ddl_com_dev
DBADMIN_APEX.ksh
AWR Stuff
http://www.askmaclean.com/archives/script-awr-trending.html
Role Transition Best Practices MAA White Paper
Votedisk Internals OracleInAction
Kerry Osbourne in-memory database
Oracle Multitenant is a new option for Oracle Database 12c Enterprise Edition that helps customers reduce IT costs by simplifying consolidation, provisioning, upgrades, and more. It is supported by a new architecture that allows a multitenant container database to hold many pluggable databases. And it fully complements other options, including Oracle Real Application Clusters and Oracle Active Data Guard. An existing database can be simply adopted, with no change, as a pluggable database; and no changes are needed in the other tiers of the application. The benefits of Oracle Multitenant are brought by implementing a pure deployment choice. The following list calls out the most compelling examples.
Adaptive Query Optimization
The new groundbreaking adaptive query optimization in Oracle Database 12c enables the Optimizer to make runtime adjustments to execution plans and to discover additional information that can lead to better statistics.