GitHub - ka10k/oracle-administration-scripts: Scripts for Oracle Database maintanance

Branches Tags

Name		Name	Last commit message	Last commit date
Latest commit History 1 Commit
ALL SYSTEM VIEWS DESCRIPTION		ALL SYSTEM VIEWS DESCRIPTION
AUDIT		AUDIT
Agent12c		Agent12c
Distributed transactions		Distributed transactions
FORMS		FORMS
Free space		Free space
GitHub		GitHub
INDEXES		INDEXES
IO		IO
Index recreation		Index recreation
JOBS		JOBS
KILL_MIS_SESSIONS		KILL_MIS_SESSIONS
LAST CALL SESSIONS		LAST CALL SESSIONS
LOGON_PASSWORD		LOGON_PASSWORD
LOG_MINER		LOG_MINER
LONG_OPERATIONS		LONG_OPERATIONS
RECYCLE_BIN		RECYCLE_BIN
RESTORE EXPIRED PASSWORD		RESTORE EXPIRED PASSWORD
SEVICE DESK BACKUP		SEVICE DESK BACKUP
SHARED_POOL BUFFER_CACHE		SHARED_POOL BUFFER_CACHE
SIPKZ partitions		SIPKZ partitions
SIP_IBS sessions limit		SIP_IBS sessions limit
START		START
SYSDATE		SYSDATE
TEMP		TEMP
TIMEZONES		TIMEZONES
TRACE		TRACE
UNDO		UNDO
add_datafiles_redologs		add_datafiles_redologs
audit ddl		audit ddl
buffer		buffer
controlfile		controlfile
find session comes from dblink		find session comes from dblink
gather_stats		gather_stats
java host command		java host command
java host for PHP RTKOM		java host for PHP RTKOM
locks		locks
non_partitioned_to_partitioned		non_partitioned_to_partitioned
password		password
profile_session_limit		profile_session_limit
rman		rman
scripts_from_MDBO		scripts_from_MDBO
sql_plan_baseline		sql_plan_baseline
startip nn		startip nn
stats		stats
targusKTP		targusKTP
tempfiles		tempfiles
unwrap_full		unwrap_full
wallet		wallet
who locked account		who locked account
x$		x$
Архивная БД		Архивная БД
ЗАКРЫТИЕ		ЗАКРЫТИЕ
Партицирование таблиц		Партицирование таблиц
СТАРТ2КОМ		СТАРТ2КОМ
Сессии занимающие пакет		Сессии занимающие пакет
подмена плана запроса		подмена плана запроса
Displays IO information.sql		Displays IO information.sql
Displays the contents of the v$diag_info view.sql		Displays the contents of the v$diag_info view.sql
Provides information to help tune the MEMORY_TARGET parameter.sql		Provides information to help tune the MEMORY_TARGET parameter.sql
1.JPG		1.JPG
ASM_ADD_DB_FILES.sql		ASM_ADD_DB_FILES.sql
ASM_free_space.sql		ASM_free_space.sql
AUDIT.sql		AUDIT.sql
AWR.sql		AWR.sql
DATABASE_PROPERTIES.sql		DATABASE_PROPERTIES.sql
DB_SIZE.sql		DB_SIZE.sql
DB_USERS_EXCEPT_SYSTEM_USERS.sql		DB_USERS_EXCEPT_SYSTEM_USERS.sql
DROP PARTITIONS.sql		DROP PARTITIONS.sql
Freespace_tablespace.sql		Freespace_tablespace.sql
GENERATE_DATAFILES.sql		GENERATE_DATAFILES.sql
GENERATE_PARTITIONS.sql		GENERATE_PARTITIONS.sql
GET_TRACE.sql		GET_TRACE.sql
KILL_SESSIONS_LOOP.sql		KILL_SESSIONS_LOOP.sql
KILL_SESSIONS_LOOP2.sql		KILL_SESSIONS_LOOP2.sql
NLS_PARAMETERS.sql		NLS_PARAMETERS.sql
PGA sessions.sql		PGA sessions.sql
PGA_USAGE.sql		PGA_USAGE.sql
POTENTIAL_FREE_DATAFILES_SPACE.sql		POTENTIAL_FREE_DATAFILES_SPACE.sql
SIPKZ ADDpartitions.sql		SIPKZ ADDpartitions.sql
SIPUR system datafile.txt		SIPUR system datafile.txt
STARTIP increase seq.sql		STARTIP increase seq.sql
TB_SERVICES.txt		TB_SERVICES.txt
TEMP_USAGE.sql		TEMP_USAGE.sql
TEMP_USAGE_BY_USERS.sql		TEMP_USAGE_BY_USERS.sql
Top_cpu_sql.sql		Top_cpu_sql.sql
UNDO_SIZE_OPTIMIZATION.sql		UNDO_SIZE_OPTIMIZATION.sql
add_data_files.sql		add_data_files.sql
alalyze.sql		alalyze.sql
alert_log.sql		alert_log.sql
alert_log_1min.sql		alert_log_1min.sql
archivelog_sequence.sql		archivelog_sequence.sql
buffer_cache.sql		buffer_cache.sql
changeto_automatic_memory_management.sql		changeto_automatic_memory_management.sql
control and datafiles.sql		control and datafiles.sql
create old user SIP_W.sql		create old user SIP_W.sql
create_constraint_after_impdp.sql		create_constraint_after_impdp.sql
dba_jobs_runing.sql		dba_jobs_runing.sql
dblink_debdb.sql		dblink_debdb.sql
debdb_user_debtors.sql		debdb_user_debtors.sql