All Scripts at one place

Category Description Script
DB Admin
DBAD: Database size in TBs DBAD_DB_Size_TBs.sql
DBAD: Database size in GBs DBAD_DB_Size_GBs.sql
DBAD: Database size in MBs DBAD_DB_Size_MBs.sql
DBAD: Tablespaces Used and free in MBs and % in MBs DBAD_Tblspc_Used_Fee_MB_%.sql
DBAD: Tablespace usage history DBAD Tblspc Usage History.sql
DBAD: Given tablespace datafile/s used auto max GBs DBAD_Tblspc_DFile Dtls_GBs.sql
DBAD: Given tablespace datafile/s used auto max MBs DBAD_Tblspc_DFile Dtls_MBs.sql
DBAD: All information about locking/blocking, wait etc. DBAD_Lock_Block_Info_n_Sol.sql
DBAD: IMP scripts to see Reports, Stats and many more. DBAD_Inbuilt_Scripts_n_Usage.sql
DBAD: Drop all objects from a schema before refresh. DBAD_Drop_All_Obj_of_Schm.sql
DB Backup and   Recovery
BKP: expdp/impdp directory, SCN, timestamp and consistent BKP_directory_SCN_timestmp_const.
BKP: expdp/impdp estimate the dump size without real export. BKP_dump_size_without_exp
BKP: expdp/impdp full database BKP_Full_DB
BKP: expdp/impdp full database without password BKP_Full_DB_without_pwd 
BKP: expdp/impdp complete reference BKP_Complete_ref 
Performance 
Perf: List Hit Ratios, Roolback Seg wait and Dispatcher workload  Perf_Ratios_RSW_DW.sql
Perf: List all info about all users like osuer, machine, prg etc.  Per_All_sessions_All_Info.sql
ASM
ASM script to see the used disk space ASM Disk Used Space.sql
ASM to check the disks details within a disk group ASM_Disks_In_Disk_Group.sql
ASM List of ASM files and its volume details ASM_File_n_Volume_Info.sql
ASM Disk Performance Metric ASM_Disk_Perf_Metric.sql
RAC
RAC: List all locked objects for all instances in RAC  RAC_All_Locked_Objects.sql
RAC: List details for sessions wait from all instances in RAC.  RAC_Sessions_Waits.sql
RAC: List memory allocation to all sessions in whole RAC.  RAC_Sessioins_Mem_Alloc.sql
RAC: List all info about all users as osuer, machine, prg etc in RAC  RAC_All_Sessions_All_Info.sql
RAC: List info of all long operations in whole RAC  RAC_Sessions_Long_Runn.sql
High Availability
HA: Scripts to check if archive logs are being shipped and applied to standby.  HA_Arc_App_Check.sql
E-Business-Suite
Workflow Mailer
WFM: Script to check service status. WFM_service_status.sql
WFM: Script to check notification mailer status. WFM_mailer_status.sql
WFM: Script to stop notification mailer. WFM_mailer_stop.sql
WFM: Script to start notification mailer. WFM_mailer_start.sql
Weblogic
WEBL: Scripts to start/stop Weblogic  WEBL_Scripts_Start_Stop_Webl

August 7, 2017 · Sanjay · No Comments
Posted in: 3. All Scripts

12C Multitenant Architecture

Please click the image to see in full screen.

12c_Multitenant_Architecture

July 21, 2017 · Sanjay · No Comments
Posted in: 9. DB 12c

12c Database architecture

Please click the image to see in full screen.

12c_Database_Architecture

July 21, 2017 · Sanjay · No Comments
Posted in: 9. DB 12c

12c Database new features

  1. How to install Oracle database 12c.
  2. 12c Backup up new features.
  3. 12c Recovery new features.
  4. 12c Performance new features.
  5. 12c High availability new features.
  6. 12c New Parameters with details.
  7. 12c Deprecated parameters.
  8. 12c Administration new features.
  9. 12c Quick reference..
  10. 12c Multitenant architecture in detail.
  11. 12c Database architecture.
  12. Best of the rest.

July 21, 2017 · Sanjay · No Comments
Posted in: 9. DB 12c