GitHub - geekcomputers/Oracle-SQL: My Oracle related SQL Scripts

1 Branch 0 Tags

Name	Name	Last commit message	Last commit date
Latest commit geekcomputers A simple procedure to show open cursors Oct 1, 2013 77b3a54 · Oct 1, 2013 History 45 Commits
README	README	Details of my Oracle Scripts	Feb 6, 2012
active_rollback.sql	active_rollback.sql	Shows active rollback activity	Jun 11, 2013
ascii.sql	ascii.sql	Shows all the ACII characters	Jun 11, 2013
client_info.sql	client_info.sql	Shows client connections to the database	Jun 16, 2013
db_buffer_hr.sql	db_buffer_hr.sql	Display buffer cache hit ratio	Jun 16, 2013
db_cache_advice.sql	db_cache_advice.sql	Shows whether or not to change the setting for DB_CACHE	Jun 16, 2013
db_report.sql	db_report.sql	Gives very basic information on the database	Jun 16, 2013
dbfile_seqread.sql	dbfile_seqread.sql	Shows the waits for dbfile_sequential_reads	Jun 16, 2013
dbfile_seqread_object.sql	dbfile_seqread_object.sql	Shows the object causing the waits	Jun 16, 2013
dbv_list.sql	dbv_list.sql	Creates a spool file of database files you can then use to use DBV ut…	Jun 16, 2013
ddl_extract.sql	ddl_extract.sql	Extracts the DDL statement for the object when the parameters are pas…	Jun 16, 2013
dump_env.sql	dump_env.sql	Creates a procedure to gather some environment information, both OS a…	Feb 24, 2012
kill_oracle.sh	kill_oracle.sh	This will kill all the oracle processes associated with a given sid	Jun 6, 2012
last5.sql	last5.sql	Displays the last 5 extents at the end of the datafile	Feb 29, 2012
litersql.sql	litersql.sql	Identify statements that could benefit converting to using bind varia…	Feb 24, 2012
log_switches.sql	log_switches.sql	Shows log switches in the database	Jun 14, 2013
maxshrink.sql	maxshrink.sql	Displays the size your datafiles can be shrunk to, it also generates …	Feb 17, 2012
monitor_cursors.sql	monitor_cursors.sql	Shows the current cursors open and the maximum allowed	Oct 1, 2013
need_to_pin.sql	need_to_pin.sql	Shows if certain objects could be pinned to improve performance	Feb 17, 2012
oracle_connection.sh	oracle_connection.sh	This will show all of the client connections to the database	Jun 6, 2012
pga_cache_advice.sql	pga_cache_advice.sql	Shows whether or not to change the setting for PGA_AGGREGATE_TARGET	Feb 17, 2012
proc_datafiles.sql	proc_datafiles.sql	how all the datafiles and there sizes for the given tablespace name	Jun 17, 2013
proc_extents.sql	proc_extents.sql	Creates a procedure to show the largest free extent in each tablespace	Jun 14, 2013
proc_free_bytes.sql	proc_free_bytes.sql	Show all the free bytes in the given tablespace	Jun 17, 2013
proc_last_change.sql	proc_last_change.sql	This Creates two procedures, one shows all users and the last time th…	Feb 14, 2012
proc_open_cursors.sql	proc_open_cursors.sql	A simple procedure to show open cursors	Oct 1, 2013
proc_sessions.sql	proc_sessions.sql	Shows a count of active/inactive sessions, plus the sid, serial# etc …	Feb 15, 2012
proc_show_events.sql	proc_show_events.sql	SQL to create a procedure to show events in the database	Jun 10, 2013
proc_table_pk.sql	proc_table_pk.sql	Create a procedure you can call to check the primary key for a table …	Jun 17, 2013
proc_update_mail.sql	proc_update_mail.sql	Procedure with Update and email	Jun 10, 2013
rebuild_indexes.sql	rebuild_indexes.sql	Use to rebuild all the indexes on a given table	Jun 11, 2013
redo_log_switches.sql	redo_log_switches.sql	Show the redo log switching in the database, two different ways to di…	Jun 17, 2013
rollback_extensions.sql	rollback_extensions.sql	Shows roll back segment extensions to show if they are sized correctly	Feb 24, 2012
search_long.sql	search_long.sql	Two Examples to search the long text field in DBA_VIEWS	Feb 29, 2012
show_events.sql	show_events.sql	SQL to show what events are set in the database	Jun 10, 2013
tab_desc.sql	tab_desc.sql	Gives a full description of the table, including all constraints, ind…	Feb 24, 2012
tableinfo.sql	tableinfo.sql	Displays everything assocaited with a given table	Feb 29, 2012
test_table.sql	test_table.sql	Creates a test table and inserts 1000 rows	Jun 6, 2012
tp_stats.sql	tp_stats.sql	Procedure to gather a users stale statistics and create a scheduled j…	Jun 14, 2013
unix_process.sql	unix_process.sql	Shows which program etc is running in Oracle when you pass it a UNIX PID	Feb 14, 2012
user_privs.sql	user_privs.sql	Show user privileges	Jun 28, 2013