Information Technology Tutorials

English & Turkish Database, Application, Operating System, Network, Artifical Intelligence, Programming Languages Tutorials & Useful Scripts

Oracle
SQL Server
- SQL Server
- SQL Server Türkçe
Application
Operating System
Artifical Intelligence
Programming
- C
- C++
- C#
- Oracle SQL
- Android
- PL/SQL
- Java
- Javascript
- HTML
- XML
Network
About Us

Oracle DBA Scripts

Oracle Oracle DBA Scripts

How to Find Active And Inactive User Sessions in Oracle

April 10, 2019April 10, 2019 Mehmet Salih Deveci 0 Comments Find Active User Sessions in Oracle, find oracle load, find oracle performance load, How to Find Active And Inactive User Sessions in Oracle, How to Find Active User Sessions in Oracle, MEHMET SALİH DEVECİ, Oracle active session history, oracle active session load, oracle active session load profile, Oracle Average Active Session Load, oracle dba scripts, oracle last_call_et, oracle monitoring scripts, Oracle Performance scripts, Oracle Performance TOP SQL, Oracle Performance TOP SQL Scripts, oracle scripts, Oracle TOP SQL script, oracle Wait Event, useful oracle scripts, Wait Event Scripts

Hi, You should list all User sessions ( Active and inactive ) in the Oracle database in case of Performance

Oracle Oracle DBA Scripts

How to Move Tables and Indexes Another Tablespace in Oracle

April 6, 2019 Mehmet Salih Deveci 0 Comments database tutorial, goldengate tutorial, how to move indexes from one tablespace to another, How to move table from one tablespace to another in oracle, How to Move Tables and Indexes Another Tablespace in Oracle, How to Move Tables Another Tablespace in Oracle, how to move tables from one tablespace to another, How to move tables in different tablespaces, it tutorial, linux tutorial, MEHMET SALİH DEVECİ, Move a table from one tablespace to another oracle, Move index from one tablespace to another tablespace, move indexes to the new tablespace, Move table from one tablespace to another tablespace, Move tables & indexes to different tablespace, Oracle alter table move tablespace, oracle Move table from one tablespace to another tablespace, oracle move table to another tablespace, oracle rebuild index, oracle rebuild index new tablespace, oracle tutorial, programming language tutorial, sql server tutorial

Hi, Sometimes you need moving tables and indexes to the new tablespace in Oracle.

Oracle Oracle DBA Scripts

How to Move Tables Another Tablespace in Oracle

April 6, 2019April 6, 2019 Mehmet Salih Deveci 0 Comments database tutorial, goldengate tutorial, How to move table from one tablespace to another in oracle, How to Move Tables Another Tablespace in Oracle, how to move tables from one tablespace to another, How to move tables in different tablespaces, it tutorial, linux tutorial, MEHMET SALİH DEVECİ, Move a table from one tablespace to another oracle, Move table from one tablespace to another tablespace, Move tables & indexes to different tablespace, Oracle alter table move tablespace, oracle Move table from one tablespace to another tablespace, oracle move table to another tablespace, oracle tutorial, programming language tutorial, sql server tutorial

Hi, Sometimes you need moving tables to new tablespace in Oracle.

Oracle Oracle DBA Scripts

How to Kill Oracle Datapump Import Job

April 6, 2019 Mehmet Salih Deveci 0 Comments data pump, data pump export import, datapump export, datapump export import, datapump impdp expdp, datapump import, dba_datapump_jobs, deveci, export import, how to backup schema oracle, how to backup table oracle, how to kill export oracle, how to kill import, how to kill import oracle, How to Kill Oracle Datapump Export Job, How to Kill Oracle Datapump Import Job, how to kill oracle process, kill expdp oracle, MEHMET SALİH DEVECİ, oracle, Oracle 12c, oracle 18c, Oracle Data pump, oracle expdp, Oracle Export import, oracle export table, oracle impdp, Oracle import table, oracle kill export job, Oracle RMAN, oracle stop export, Oracle Support, oracle table backup, oracle table export, oracle table import, RMAN, SALİH DEVECİ, stop expdp oracle, stop export oracle, what is datapump

Hi, When you start import in Oracle database with impdp command, you may want to kill or stop these jobs.

Oracle Oracle DBA Scripts

How to Monitor RMAN Backup and Long Operations in Oracle

April 5, 2019 Mehmet Salih Deveci 0 Comments How to Monitor Long Operations in Oracle How to Monitor RMAN Backup and Long Operations in Oracle, How to Monitor RMAN Backup, How to Monitor RMAN Backup and Long Operations in Oracle, MEHMET SALİH DEVECİ, monitor oracle backup, Oracle 19c, Oracle 19c Cloud database, Oracle 19c error codes, oracle dba scripts, oracle long operations, oracle monitoring scripts, Oracle Performance scripts, oracle rman backup monitor, oracle rman completion time, oracle rman monitor, oracle scripts, Oracle TOP SQL script, oracle V$SESSION_LONGOPS, oracle Wait Event, useful oracle scripts, V$SESSION_LONGOPS

Hi, If you have big database about more than 1 TB, then your backup and export operations are taking long

Oracle Oracle DBA Scripts

Oracle Kill Session Scripts -4

March 30, 2019April 5, 2019 Mehmet Salih Deveci 0 Comments blocking_session oracle, dba_hist_active_sess_history, dba_objects, gv$lock, gv$session, how to Kill Session in Oracle, kill session oracle, lock script, MEHMET SALİH DEVECİ, ORA error solution, ORA errors, Oracle 19c, Oracle 19c error codes, oracle blocking session, oracle blocking session script, Oracle DBA query, Oracle DBA script, oracle dba scripts, Oracle DBA useful script, oracle kill active session, oracle kill background sessions, oracle kill inactive session, Oracle Kill Session Scripts, oracle last_call_et, oracle lock script, oracle monitoring scripts, oracle scripts, oracle v$sql_monitor, useful oracle scripts, v$sql_monitor

Hi, Sometimes application developers or client offers you to kill any session or sessions group like SQL Net Client, or

Oracle Oracle DBA Scripts

Oracle 12c List Components Installed

March 18, 2019 Mehmet Salih Deveci 0 Comments check oracle components, deveci, installed components oracle, JServer JAVA Virtual Machine, List Components Installed oracle, list oracle components, MEHMET SALİH DEVECİ, OLAP Analytic Workspace, oracle, Oracle 12c, oracle 12c install, Oracle 12c installation, Oracle 12c List Components Installed, oracle components check, Oracle database 12c, oracle installed components, Oracle Multimedia, Oracle netca, oracle silent install, Oracle Support, Oracle Text, Oracle Workspace Manager, SALİH DEVECİ

Hi, You should know that which components are installed in your Oracle database as Oracle DBA.

Oracle Oracle DBA Scripts

Oracle Dataguard Monitoring Scripts -4

March 17, 2019April 2, 2019 Mehmet Salih Deveci 0 Comments Dataguard Monitoring Script, Dataguard Script, MEHMET SALİH DEVECİ, Oracle Dataguard Monitoring Script, Oracle Dataguard Monitoring Scripts, oracle dba scripts, oracle monitoring scripts, oracle scripts, oracle V$ARCHIVED_LOG, oracle V$ARCHIVE_GAP, oracle v$bgprocess, oracle v$database, oracle v$dataguard_stats, oracle v$managed_standby, oracle v$recovery_progress, useful oracle scripts, v$recovery_progress

Hi, Dataguard should be monitored everytime by Oracle DBA.

Oracle Oracle DBA Scripts

Oracle Dataguard Stop Start

March 17, 2019 Mehmet Salih Deveci 0 Comments ALTER DATABASE RECOVER MANAGED STANDBY DATABASE DISCONNECT FROM SESSION, ALTER DATABASE RECOVER MANAGED STANDBY DATABASE USING CURRENT LOGFILE DISCONNECT FROM SESSION;, Dataguard Monitoring Script, Dataguard Script, dataguard start oracle, dataguard stop oracle, dataguard stop start, MEHMET SALİH DEVECİ, mrp process start stop, mrp process start stop oracle, Oracle Dataguard Monitoring Script, Oracle Dataguard Monitoring Scripts, Oracle Dataguard Stop Start, oracle dba scripts, oracle monitoring scripts, oracle mrp process, oracle scripts, oracle V$ARCHIVED_LOG, oracle V$ARCHIVE_GAP, oracle v$bgprocess, oracle v$database, oracle v$dataguard_stats, oracle v$managed_standby, oracle v$recovery_progress, useful oracle scripts, v$dataguard_stats, v$recovery_progress

Hi, You should stop and start your dataguard sometimes in case of need.

Oracle Oracle DBA Scripts

Oracle Archivelog Delete

March 16, 2019 Mehmet Salih Deveci 0 Comments archive log files, Archive Logs, archive mode, delete archivelog all backed up, delete archivelog oracle, delete archivelog until time, delete archivelog until time 'sysdate -1', delete noprompt force archivelog all, how to delete archivelog oracle, LGWR, log switch, online backup, Online Redo log Files, Oracle architecture, oracle archivelog delete, oracle database architecture, oracle delete archivelog, query archive logs, query redo logs, redo log, Redo log buffer, Redo log Files, redo log switch

Hi, Oracle database is archiving redo log group files if database is in archivelog mode.

← Previous

SEARCH IN BLOG

Follow Us On LinkedIn & Twitter

LinkedIn
Twitter

Subscribe IT Tutorial via Email

Enter your email address to subscribe to IT Tutorial

Email Address

Categories

Top Posts & Pages

Oracle Dataguard Monitoring Scripts -1
Oracle Dataguard Monitoring Scripts -3
Oracle Dataguard Monitoring Scripts -2
Oracle Dataguard Monitoring Scripts -4
Oracle RMAN ( Recovery Manager ) Backup Tutorials -1
Oracle RMAN ( Recovery Manager ) Backup Tutorials -2
Oracle RMAN ( Recovery Manager ) Backup Tutorials -3
Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -1
Oracle RMAN ( Recovery Manager ) Backup Tutorials -4
Oracle RMAN ( Recovery Manager ) Restore Recover Tutorials -2

Recent Posts

Android Programlama -8
Android Programlama -7
How to Start Oracle Weblogic Server
Solaris(x86 64) Disk Partition
Solaris root ssh connectivity

Copyright © 2019 Information Technology Tutorials. All rights reserved.
Theme: ColorMag by ThemeGrill. Powered by WordPress.