Pinned Repositories
A-Demo-Checking-Execution-Plan-of-Querying-COUNT-table
Using 4 separate procedures to quickly create 4 different 'TEST' tables, after querying COUNT(*|1|id|flag) on all tables next to checking their real execution plans.
A-Demo-Spending-Time-of-Querying-COUNT-table
Using 3 tables ("cnt_method", "tab_stru" and "cnt_spd_time"), some procedures dynamically creating test table, a special function and another procedure to build this pretty interesting demo.
db-appdev-vm
Database Application Development Virtual Machine
Linux-Shell-Scripts
A variety of Linux Shell Scripts I wrote over the years in particular Oracle.
ODRIS
The first letter abbreviation of Oracle Database Routine Inspection Shell and SQL Script.
oracle-script-lib
Library of oracle dba scripts
Oracle-SQL-Scripts
Miscellaneous Oracle SQL Scripts I wrote over the years covering Performance, Statistics and Routine inspection etc.
PL-SQL-For-DBAs
Some daily/routine PL/SQL scripts For DBAs.
PL-SQL-For-Developers
Some daily/routine PL/SQL scripts For Developers.
Visualizing-Oracle-Performance-Data-By-Graph
I finished a project about how to visualize oracle performance data by graph in recent two months (2021.11 - 2021.12).
guestart's Repositories
guestart/Oracle-SQL-Scripts
Miscellaneous Oracle SQL Scripts I wrote over the years covering Performance, Statistics and Routine inspection etc.
guestart/Visualizing-Oracle-Performance-Data-By-Graph
I finished a project about how to visualize oracle performance data by graph in recent two months (2021.11 - 2021.12).
guestart/Linux-Shell-Scripts
A variety of Linux Shell Scripts I wrote over the years in particular Oracle.
guestart/ODRIS
The first letter abbreviation of Oracle Database Routine Inspection Shell and SQL Script.
guestart/A-Demo-Spending-Time-of-Querying-COUNT-table
Using 3 tables ("cnt_method", "tab_stru" and "cnt_spd_time"), some procedures dynamically creating test table, a special function and another procedure to build this pretty interesting demo.
guestart/oracle-script-lib
Library of oracle dba scripts
guestart/A-Demo-Checking-Execution-Plan-of-Querying-COUNT-table
Using 4 separate procedures to quickly create 4 different 'TEST' tables, after querying COUNT(*|1|id|flag) on all tables next to checking their real execution plans.
guestart/db-appdev-vm
Database Application Development Virtual Machine
guestart/oramon
Oracle I/O latency monitor
guestart/PL-SQL-For-DBAs
Some daily/routine PL/SQL scripts For DBAs.
guestart/shell-tutorial
guestart/tcpdump
parse tcpdump files for NFS latency
guestart/PL-SQL-For-Developers
Some daily/routine PL/SQL scripts For Developers.
guestart/A-demo-with-secure-copying-RMAN-EXP-DP-backup-files-to-another-server
Some versatile SHELL scripts for periodically secure copying RMAN and EXP[DP] backup files via full and incremental content to another server.