1 Star 1 Fork 0

冯际成/Oracle_SQL_Scripts

加入 Gitee
与超过 1200万 开发者一起发现、参与优秀开源项目,私有仓库也完全免费 :)
免费加入
该仓库未声明开源许可证文件(LICENSE),使用请关注具体项目描述及其代码上游依赖。
克隆/下载
贡献代码
同步代码
取消
提示: 由于 Git 不支持空文件夾,创建文件夹后会生成空的 .keep 文件
Loading...
README

Oracle_SQL_Scripts

SQL Scripts Related to Oracle. Most of them work on 10g+ and some on 12c. There are some scripts that get information from Recovery Catalog as well, so you have to be connected to catalog.

Please note some script have been taken from others who have opened sourced it (for example the more popular ones like snapper from Tanel and xplan_ash from Randolf, etc..) and some are my own. This is just a curated list that I have put together that I use from day to day.

Due to the sheer number of scripts, it was hard for me to remember name of every single script so I created another script(help.sql) to keep track of all the other script.

Once logged into a database(10g+), you can run @help.sql as shown below. Here I am looking for anything(like statement) that has "sess" in the script name.

alt text

Quick description of what each column mean above.

MY SCRIPT NAME = obviously the script name itself

DESCRIPTION = short description of what the script is suppose to do

INPUT = any input required when running the script. In the above screen shot, if we were to run "perf_session_wait", we would need to pass in the session ID(SID)

Next example shows running help file and searching for anything that has "users" in the script name.

alt text

Next example shows running help file and searching for anything that has "trend" in the script name.

alt text

Next example shows running help file but we hit enter(no input) and that will spit out all the script names (300+)

alt text

Please note that the help.sql file is not being updated automatically, if we were to add a new script to this repo we will have to manually go in and update the help.sql file to put in the script name, description and if any input is required or not. I am sure that part can be automated as well.

空文件

简介

取消

发行版

暂无发行版

贡献者

全部

近期动态

不能加载更多了
马建仓 AI 助手
尝试更多
代码解读
代码找茬
代码优化
1
https://gitee.com/sapall/Oracle_SQL_Scripts.git
git@gitee.com:sapall/Oracle_SQL_Scripts.git
sapall
Oracle_SQL_Scripts
Oracle_SQL_Scripts
master

搜索帮助