All posts in category 'Oracle Scripts'

• View unified audit report - oracle database script

  
  September 06, 2019

  AODBA
  View unified audit report - oracle database script
  View unified audit report Oracle database script
  Read More

• View privileges granted to an user - oracle database script

  
  September 06, 2019

  AODBA
  View privileges granted to an user - oracle database script
  View privileges granted Oracle database script User
  Read More

• View dataguard message or errors - oracle database script

  
  September 06, 2019

  AODBA
  View dataguard message or errors - oracle database script
  View dataguard message Oracle database script Errors
  Read More

• View container db information - oracle database script

  
  September 06, 2019

  AODBA
  View container db information - oracle database script
  View container db information Oracle database script
  Read More

• View all scheduler schedules - oracle database script

  
  September 06, 2019

  AODBA
  View all scheduler schedules - oracle database script
  Oracle database script Scheduler schedules View
  Read More

• View acl information - oracle database script

  
  September 06, 2019

  AODBA
  View acl information - oracle database script
  View acl information Oracle database script
  Read More

• User creation details in user$ table - oracle database script

  
  September 06, 2019

  AODBA
  User creation details in user$ table - oracle database script
  Oracle database script User creation details User Table
  Read More

• Unified audit policies present in db - oracle database script

  
  September 06, 2019

  AODBA
  Unified audit policies present in db - oracle database script
  Unified audit policies present Oracle database script Db
  Read More

• Top index sizes of table/schema - oracle database script

  
  September 06, 2019

  AODBA
  Top index sizes of table/schema - oracle database script
  Top index sizes Oracle database script Table Schema
  Read More

• Temp tablespace details in multitenant - oracle database script

  
  September 06, 2019

  AODBA
  Temp tablespace details in multitenant - oracle database script
  Temp tablespace details Oracle database script Multitenant
  Read More

• Target list monitored by oem - oracle database script

  
  September 06, 2019

  AODBA
  Target list monitored by oem - oracle database script
  Target list monitored Oracle database script Oem
  Read More

• Tablespace quota for a user - oracle database script

  
  September 06, 2019

  AODBA
  Tablespace quota for a user - oracle database script
  Oracle database script Tablespace quota User
  Read More

• Tablespace info in multitenant - oracle database script

  
  September 06, 2019

  AODBA
  Tablespace info in multitenant - oracle database script
  Oracle database script Tablespace info Multitenant
  Read More

• Table_exists_action option with impdp - oracle database script

  
  September 06, 2019

  AODBA
  Table_exists_action option with impdp - oracle database script
  Oracle database script Table_exists_action option Impdp
  Read More

• Stop/start oms in cloud control - oracle database script

  
  September 06, 2019

  AODBA
  Stop/start oms in cloud control - oracle database script
  Oracle database script Start oms Cloud control Stop
  Read More

• Stop/start mrp process in standby - oracle database script

  
  September 06, 2019

  AODBA
  Stop/start mrp process in standby - oracle database script
  Start mrp process Oracle database script Stop Standby
  Read More

• Stop/start agent in oem cloud control - oracle database script

  
  September 06, 2019

  AODBA
  Stop/start agent in oem cloud control - oracle database script
  Oracle database script Oem cloud control Start agent Stop
  Read More

• Stop and start pluggable db - oracle database script

  
  September 06, 2019

  AODBA
  Stop and start pluggable db - oracle database script
  Start pluggable db Oracle database script Stop
  Read More

• Status of pdbs in multitenant - oracle database script

  
  September 06, 2019

  AODBA
  Status of pdbs in multitenant - oracle database script
  Oracle database script Status Pdbs Multitenant
  Read More

• Statements audited in oracle

  
  September 06, 2019

  AODBA
  Statements audited in oracle
  Statements audited Oracle
  Read More

• Sqlfile option with impdp - oracle database script

  
  September 06, 2019

  AODBA
  Sqlfile option with impdp - oracle database script
  Oracle database script Sqlfile option Impdp
  Read More

• Space usage by lob column - oracle database script

  
  September 06, 2019

  AODBA
  Space usage by lob column - oracle database script
  Oracle database script Space usage Lob column
  Read More

• Show history of pdbs - oracle database script

  
  September 06, 2019

  AODBA
  Show history of pdbs - oracle database script
  Oracle database script Show history Pdbs
  Read More

• Set local_listener in db - oracle database script

  
  September 06, 2019

  AODBA
  Set local_listener in db - oracle database script
  Oracle database script Set local_listener Db
  Read More

• Services associated with pdbs - oracle database script

  
  September 06, 2019

  AODBA
  Services associated with pdbs - oracle database script
  Oracle database script Services associated Pdbs
  Read More

• Scheduler shell script in dbms_scheduler - oracle database script

  
  September 06, 2019

  AODBA
  Scheduler shell script in dbms_scheduler - oracle database script
  Scheduler shell script Oracle database script Dbms_scheduler
  Read More

• Scheduler job detail in cdb - oracle database script

  
  September 06, 2019

  AODBA
  Scheduler job detail in cdb - oracle database script
  Scheduler job detail Oracle database script Cdb
  Read More

• Rename/move a datafile - oracle database script

  
  September 06, 2019

  AODBA
  Rename/move a datafile - oracle database script
  Oracle database script Rename Move Datafile
  Read More

• Rename tablespace in oracle db

  
  September 06, 2019

  AODBA
  Rename tablespace in oracle db
  Rename tablespace Oracle db
  Read More

• Privileges audited in database - oracle database script

  
  September 06, 2019

  AODBA
  Privileges audited in database - oracle database script
  Oracle database script Privileges audited Database
  Read More

• Plugins installed on oms server - oracle database script

  
  September 06, 2019

  AODBA
  Plugins installed on oms server - oracle database script
  Oracle database script Plugins installed Oms server
  Read More

• Occupants usage in sysaux tablespace - oracle database script

  
  September 06, 2019

  AODBA
  Occupants usage in sysaux tablespace - oracle database script
  Oracle database script Sysaux tablespace Occupants usage
  Read More

• Object with mix or lowercase name - oracle database script

  
  September 06, 2019

  AODBA
  Object with mix or lowercase name - oracle database script
  Oracle database script Lowercase name Object Mix
  Read More

• Move lob segment to another tablespace - oracle database script

  
  September 06, 2019

  AODBA
  Move lob segment to another tablespace - oracle database script
  Oracle database script Move lob segment Another tablespace
  Read More

• Move aud$ table to new tablespace - oracle database script

  
  September 06, 2019

  AODBA
  Move aud$ table to new tablespace - oracle database script
  Oracle database script New tablespace Move aud Table
  Read More

• Monitor standby background process - oracle database script

  
  September 06, 2019

  AODBA
  Monitor standby background process - oracle database script
  Monitor standby background process Oracle database script
  Read More

• Monitor scheduler jobs - oracle database script

  
  September 06, 2019

  AODBA
  Monitor scheduler jobs - oracle database script
  Oracle database script Monitor scheduler jobs
  Read More

• Monitor recovery progress in standby db - oracle database script

  
  September 06, 2019

  AODBA
  Monitor recovery progress in standby db - oracle database script
  Oracle database script Monitor recovery progress Standby db
  Read More

• Monitor lag in standby including rac - oracle database script

  
  September 06, 2019

  AODBA
  Monitor lag in standby including rac - oracle database script
  Standby including rac Oracle database script Monitor lag
  Read More

• Modify scan listener port - oracle database script

  
  September 06, 2019

  AODBA
  Modify scan listener port - oracle database script
  Modify scan listener port Oracle database script
  Read More

• Managing columns of table - oracle database script

  
  September 06, 2019

  AODBA
  Managing columns of table - oracle database script
  Oracle database script Managing columns Table
  Read More

• Manage listener in oracle

  
  September 06, 2019

  AODBA
  Manage listener in oracle
  Manage listener Oracle
  Read More

• Manage dbms_schedulerjobs - oracle database script

  
  September 06, 2019

  AODBA
  Manage dbms_schedulerjobs - oracle database script
  Oracle database script Manage dbms_schedulerjobs
  Read More

• Manage acls in oracle

  
  September 06, 2019

  AODBA
  Manage acls in oracle
  Manage acls Oracle
  Read More

• Make index invisible - oracle database script

  
  September 06, 2019

  AODBA
  Make index invisible - oracle database script
  Oracle database script Make index invisible
  Read More

• Log information for all scheduler jobs - oracle database script

  
  September 06, 2019

  AODBA
  Log information for all scheduler jobs - oracle database script
  Oracle database script Scheduler jobs Log information
  Read More

• Last log applied/received - oracle database script

  
  September 06, 2019

  AODBA
  Last log applied/received - oracle database script
  Oracle database script Last log applied Received
  Read More

• Is the database is a multitenant or not - oracle database script

  
  September 06, 2019

  AODBA
  Is the database is a multitenant or not - oracle database script
  Oracle database script Database Multitenant
  Read More

• Index rebuild in oracle

  
  September 06, 2019

  AODBA
  Index rebuild in oracle
  Index rebuild Oracle
  Read More

• History of all scheduler job runs - oracle database script

  
  September 06, 2019

  AODBA
  History of all scheduler job runs - oracle database script
  Scheduler job runs Oracle database script History
  Read More

• Grant table/column privilege to user - oracle database script

  
  September 06, 2019

  AODBA
  Grant table/column privilege to user - oracle database script
  Oracle database script Grant table Column privilege User
  Read More

• Get standby redo log info - oracle database script

  
  September 06, 2019

  AODBA
  Get standby redo log info - oracle database script
  Get standby redo log info Oracle database script
  Read More

• Get oms/agent url details - oracle database script

  
  September 06, 2019

  AODBA
  Get oms/agent url details - oracle database script
  Oracle database script Agent url details Get oms
  Read More

• Get oms repository details - oracle database script

  
  September 06, 2019

  AODBA
  Get oms repository details - oracle database script
  Get oms repository details Oracle database script
  Read More

• Get ddl of a scheduler job - oracle database script

  
  September 06, 2019

  AODBA
  Get ddl of a scheduler job - oracle database script
  Oracle database script Scheduler job Get ddl
  Read More

• Find tables with lob seg in db - oracle database script

  
  September 06, 2019

  AODBA
  Find tables with lob seg in db - oracle database script
  Oracle database script Lob seg Find tables Db
  Read More

• Find nested tables in db - oracle database script

  
  September 06, 2019

  AODBA
  Find nested tables in db - oracle database script
  Oracle database script Find nested tables Db
  Read More

• Find dependents of an object - oracle database script

  
  September 06, 2019

  AODBA
  Find dependents of an object - oracle database script
  Oracle database script Find dependents Object
  Read More

• Find column usage statistics - oracle database script

  
  September 06, 2019

  AODBA
  Find column usage statistics - oracle database script
  Find column usage statistics Oracle database script
  Read More

• Find chained rows in table - oracle database script

  
  September 06, 2019

  AODBA
  Find chained rows in table - oracle database script
  Oracle database script Find chained rows Table
  Read More

• Find active services in db - oracle database script

  
  September 06, 2019

  AODBA
  Find active services in db - oracle database script
  Oracle database script Find active services Db
  Read More

• Expdp/impdp with parallel option - oracle database script

  
  September 06, 2019

  AODBA
  Expdp/impdp with parallel option - oracle database script
  Oracle database script Parallel option Impdp Expdp
  Read More

• Expdp/impdp for tables - oracle database script

  
  September 06, 2019

  AODBA
  Expdp/impdp for tables - oracle database script
  Oracle database script Tables Impdp Expdp
  Read More

• Expdp/impdp for schemas - oracle database script

  
  September 06, 2019

  AODBA
  Expdp/impdp for schemas - oracle database script
  Oracle database script Schemas Impdp Expdp
  Read More

• Expdp with query clause - oracle database script

  
  September 06, 2019

  AODBA
  Expdp with query clause - oracle database script
  Oracle database script Query clause Expdp
  Read More

• Expdp with compression parameter - oracle database script

  
  September 06, 2019

  AODBA
  Expdp with compression parameter - oracle database script
  Oracle database script Compression parameter Expdp
  Read More

• Expdp to multiple directories - oracle database script

  
  September 06, 2019

  AODBA
  Expdp to multiple directories - oracle database script
  Oracle database script Multiple directories Expdp
  Read More

• Expdp to asm diskgroup - oracle database script

  
  September 06, 2019

  AODBA
  Expdp to asm diskgroup - oracle database script
  Expdp Oracle database script Asm diskgroup
  Read More

• Exclude/include option in expdp - oracle database script

  
  September 06, 2019

  AODBA
  Exclude/include option in expdp - oracle database script
  Oracle database script Include option Expdp Exclude
  Read More

• Estimate space require for index creation - oracle database script

  
  September 06, 2019

  AODBA
  Estimate space require for index creation - oracle database script
  Oracle database script Estimate space require Index creation
  Read More

• Enable/disable/drop a dbms_job - oracle database script

  
  September 06, 2019

  AODBA
  Enable/disable/drop a dbms_job - oracle database script
  Oracle database script Enable Drop Disable
  Read More

• Enable/disable triggers of a schema - oracle database script

  
  September 06, 2019

  AODBA
  Enable/disable triggers of a schema - oracle database script
  Oracle database script Disable triggers Schema Enable
  Read More

• Enable/disable em express 12c - oracle database script

  
  September 06, 2019

  AODBA
  Enable/disable em express 12c - oracle database script
  Disable em express 12c Oracle database script Enable
  Read More

• Enable tracing for a listener - oracle database script

  
  September 06, 2019

  AODBA
  Enable tracing for a listener - oracle database script
  Oracle database script Enable tracing Listener
  Read More

• Enable pure unified auditing 12c - oracle database script

  
  September 06, 2019

  AODBA
  Enable pure unified auditing 12c - oracle database script
  Enable pure unified auditing 12c Oracle database script
  Read More

• Enable auditing in database - oracle database script

  
  September 06, 2019

  AODBA
  Enable auditing in database - oracle database script
  Oracle database script Enable auditing Database
  Read More

• Enable auditing for datapump jobs - oracle database script

  
  September 06, 2019

  AODBA
  Enable auditing for datapump jobs - oracle database script
  Oracle database script Enable auditing Datapump jobs
  Read More

• Enable audit for sys operations - oracle database script

  
  September 06, 2019

  AODBA
  Enable audit for sys operations - oracle database script
  Oracle database script Sys operations Enable audit
  Read More

• Drop tablespace in oracle db

  
  September 06, 2019

  AODBA
  Drop tablespace in oracle db
  Oracle db Drop tablespace
  Read More

• Drop a schedule - oracle database script

  
  September 06, 2019

  AODBA
  Drop a schedule - oracle database script
  Oracle database script Schedule Drop
  Read More

• Drop a pluggable database - oracle database script

  
  September 06, 2019

  AODBA
  Drop a pluggable database - oracle database script
  Oracle database script Pluggable database Drop
  Read More

• Definition of job in dbms_jobs - oracle database script

  
  September 06, 2019

  AODBA
  Definition of job in dbms_jobs - oracle database script
  Oracle database script Job Definition Dbms_jobs
  Read More

• Default users in oracle 12c

  
  September 06, 2019

  AODBA
  Default users in oracle 12c
  Oracle 12c Default users
  Read More

• Currently connected pdb name - oracle database script

  
  September 06, 2019

  AODBA
  Currently connected pdb name - oracle database script
  Currently connected pdb name Oracle database script
  Read More

• Create/drop synonyms - oracle database script

  
  September 06, 2019

  AODBA
  Create/drop synonyms - oracle database script
  Oracle database script Drop synonyms Create
  Read More

• Create/drop database link - oracle database script

  
  September 06, 2019

  AODBA
  Create/drop database link - oracle database script
  Oracle database script Drop database link Create
  Read More

• Create/drop database link - oracle database script

  
  September 06, 2019

  AODBA
  Create/drop database link - oracle database script
  Oracle database script Drop database link Create
  Read More

• Create user in oracle

  
  September 06, 2019

  AODBA
  Create user in oracle
  Create user Oracle
  Read More

• Create unified audit policy - oracle database script

  
  September 06, 2019

  AODBA
  Create unified audit policy - oracle database script
  Create unified audit policy Oracle database script
  Read More

• Create tablespace in oracle db

  
  September 06, 2019

  AODBA
  Create tablespace in oracle db
  Oracle db Create tablespace
  Read More

• Create static listener for oracle db

  
  September 06, 2019

  AODBA
  Create static listener for oracle db
  Create static listener Oracle db
  Read More

• Create db link w/o modifying tnsnames.ora - oracle database script

  
  September 06, 2019

  AODBA
  Create db link w/o modifying tnsnames.ora - oracle database script
  Create db link w Oracle database script Modifying tnsnames Ora
  Read More

• Create and scheduler a scheduler job - oracle database script

  
  September 06, 2019

  AODBA
  Create and scheduler a scheduler job - oracle database script
  Oracle database script Scheduler job Scheduler Create
  Read More

• Create /alter profile in database - oracle database script

  
  September 06, 2019

  AODBA
  Create /alter profile in database - oracle database script
  Oracle database script Alter profile Database Create
  Read More

• Copy scheduler job from one user to other - oracle database script

  
  September 06, 2019

  AODBA
  Copy scheduler job from one user to other - oracle database script
  Oracle database script Copy scheduler job One user
  Read More

• Connect to user without knowing password - oracle database script

  
  September 06, 2019

  AODBA
  Connect to user without knowing password - oracle database script
  User without knowing password Oracle database script Connect
  Read More

• Compile invalid objects - oracle database script

  
  September 06, 2019

  AODBA
  Compile invalid objects - oracle database script
  Oracle database script Compile invalid objects
  Read More

• Common user/role in cdb - oracle database script

  
  September 06, 2019

  AODBA
  Common user/role in cdb - oracle database script
  Oracle database script Common user Role Cdb
  Read More

• Cluster parameter in rac - oracle database script

  
  September 06, 2019

  AODBA
  Cluster parameter in rac - oracle database script
  Rac Oracle database script Cluster parameter
  Read More

• Checkpoint time of datafiles - oracle database script

  
  September 06, 2019

  AODBA
  Checkpoint time of datafiles - oracle database script
  Oracle database script Checkpoint time Datafiles
  Read More

• Check undo mode in multitenant db (oracle 12.2)

  
  September 06, 2019

  AODBA
  Check undo mode in multitenant db (oracle 12.2)
  Check undo mode Oracle 12 Multitenant db 2
  Read More

• Check the syntax of rman commands - oracle database script

  
  September 06, 2019

  AODBA
  Check the syntax of rman commands - oracle database script
  Oracle database script Rman commands Syntax Check
  Read More

• Check encryption wallet status - oracle database script

  
  September 06, 2019

  AODBA
  Check encryption wallet status - oracle database script
  Check encryption wallet status Oracle database script
  Read More

• Check db role(primary/standby) - oracle database script

  
  September 06, 2019

  AODBA
  Check db role(primary/standby) - oracle database script
  Oracle database script Check db role Standby Primary
  Read More

• Change sysman pwd in oem cloud - oracle database script

  
  September 06, 2019

  AODBA
  Change sysman pwd in oem cloud - oracle database script
  Oracle database script Change sysman pwd Oem cloud
  Read More

• Change default tablespace of user - oracle database script

  
  September 06, 2019

  AODBA
  Change default tablespace of user - oracle database script
  Oracle database script Change default tablespace User
  Read More

• Audit records of an user - oracle database script

  
  September 06, 2019

  AODBA
  Audit records of an user - oracle database script
  Oracle database script Audit records User
  Read More

• Alter an user - oracle database script

  
  September 06, 2019

  AODBA
  Alter an user - oracle database script
  Oracle database script User Alter
  Read More

• All scheduler windows - oracle database script

  
  September 06, 2019

  AODBA
  All scheduler windows - oracle database script
  Oracle database script Scheduler windows
  Read More

• Add/drop/alter datafile - oracle database script

  
  September 06, 2019

  AODBA
  Add/drop/alter datafile - oracle database script
  Oracle database script Alter datafile Drop Add
  Read More

• Add/drop tempfile - oracle database script

  
  September 06, 2019

  AODBA
  Add/drop tempfile - oracle database script
  Oracle database script Drop tempfile Add
  Read More

• Xplain plan of sql_id from cursor - oracle database script

  
  September 05, 2019

  AODBA
  Xplain plan of sql_id from cursor - oracle database script
  Oracle database script Xplain plan Sql_id Cursor
  Read More

• Xplain plan of sql_id from awr - oracle database script

  
  September 05, 2019

  AODBA
  Xplain plan of sql_id from awr - oracle database script
  Oracle database script Xplain plan Sql_id Awr
  Read More

• Xplain plan of a sql statement - oracle database script

  
  September 05, 2019

  AODBA
  Xplain plan of a sql statement - oracle database script
  Oracle database script Xplain plan Sql statement
  Read More

• Xplain plan of a sql baseline - oracle database script

  
  September 05, 2019

  AODBA
  Xplain plan of a sql baseline - oracle database script
  Oracle database script Xplain plan Sql baseline
  Read More

• View/modify stats retention - oracle database script

  
  September 05, 2019

  AODBA
  View/modify stats retention - oracle database script
  Oracle database script Modify stats retention View
  Read More

• View/modify awr retention - oracle database script

  
  September 05, 2019

  AODBA
  View/modify awr retention - oracle database script
  Oracle database script Modify awr retention View
  Read More

• View timezone info in db - oracle database script

  
  September 05, 2019

  AODBA
  View timezone info in db - oracle database script
  View timezone info Oracle database script Db
  Read More

• View hidden parameter setting - oracle database script

  
  September 05, 2019

  AODBA
  View hidden parameter setting - oracle database script
  View hidden parameter setting Oracle database script
  Read More

• Utilization of current redo log ( in % ) - oracle database script

  
  September 05, 2019

  AODBA
  Utilization of current redo log ( in % ) - oracle database script
  Oracle database script Current redo log Utilization
  Read More

• Upgrade statistics in db - oracle database script

  
  September 05, 2019

  AODBA
  Upgrade statistics in db - oracle database script
  Oracle database script Upgrade statistics Db
  Read More

• Truncate partitions - oracle database script

  
  September 05, 2019

  AODBA
  Truncate partitions - oracle database script
  Oracle database script Truncate partitions
  Read More

• Tracing all session of a user - oracle database script

  
  September 05, 2019

  AODBA
  Tracing all session of a user - oracle database script
  Oracle database script User Tracing Session
  Read More

• Top sql queries using literal values - oracle database script

  
  September 05, 2019

  AODBA
  Top sql queries using literal values - oracle database script
  Top sql queries using literal values Oracle database script
  Read More

• Top running queries from ash - oracle database script

  
  September 05, 2019

  AODBA
  Top running queries from ash - oracle database script
  Top running queries Oracle database script Ash
  Read More

• Top query with high elapsed time - oracle database script

  
  September 05, 2019

  AODBA
  Top query with high elapsed time - oracle database script
  Oracle database script High elapsed time Top query
  Read More

• Top cpu consuming sessions - oracle database script

  
  September 05, 2019

  AODBA
  Top cpu consuming sessions - oracle database script
  Top cpu consuming sessions Oracle database script
  Read More

• Table statistics history - oracle database script

  
  September 05, 2019

  AODBA
  Table statistics history - oracle database script
  Table statistics history Oracle database script
  Read More

• Table not having index on fk column - oracle database script

  
  September 05, 2019

  AODBA
  Table not having index on fk column - oracle database script
  Oracle database script Fk column Table Index
  Read More

• Stop/start cluster in rac standalone. - oracle database script

  
  September 05, 2019

  AODBA
  Stop/start cluster in rac standalone. - oracle database script
  Oracle database script Start cluster Rac standalone Stop
  Read More

• Stop/start a service - oracle database script

  
  September 05, 2019

  AODBA
  Stop/start a service - oracle database script
  Oracle database script Stop Start Service
  Read More

• Stop and start instance using srvctl - oracle database script

  
  September 05, 2019

  AODBA
  Stop and start instance using srvctl - oracle database script
  Start instance using srvctl Oracle database script Stop
  Read More

• Stop and start db using srvctl - oracle database script

  
  September 05, 2019

  AODBA
  Stop and start db using srvctl - oracle database script
  Start db using srvctl Oracle database script Stop
  Read More

• Stop and start crs - oracle database script

  
  September 05, 2019

  AODBA
  Stop and start crs - oracle database script
  Oracle database script Start crs Stop
  Read More

• Sqls doing full table scan - oracle database script

  
  September 05, 2019

  AODBA
  Sqls doing full table scan - oracle database script
  Oracle database script Full table scan Sqls
  Read More

• Sql tuning advisor for sql_id from cursor - oracle database script

  
  September 05, 2019

  AODBA
  Sql tuning advisor for sql_id from cursor - oracle database script
  Sql tuning advisor Oracle database script Sql_id Cursor
  Read More

• Spool sql query output to html - oracle database script

  
  September 05, 2019

  AODBA
  Spool sql query output to html - oracle database script
  Spool sql query output Oracle database script Html
  Read More

• Split partition online(12cr2 only) - oracle database script

  
  September 05, 2019

  AODBA
  Split partition online(12cr2 only) - oracle database script
  Split partition online Oracle database script 12cr2
  Read More

• Space used to store stats - oracle database script

  
  September 05, 2019

  AODBA
  Space used to store stats - oracle database script
  Oracle database script Store stats Space used
  Read More

• Set env variables using srvctl - oracle database script

  
  September 05, 2019

  AODBA
  Set env variables using srvctl - oracle database script
  Set env variables using srvctl Oracle database script
  Read More

• Sessions holding library cache lock - oracle database script

  
  September 05, 2019

  AODBA
  Sessions holding library cache lock - oracle database script
  Sessions holding library cache lock Oracle database script
  Read More

• Sessions accessing an object - oracle database script

  
  September 05, 2019

  AODBA
  Sessions accessing an object - oracle database script
  Oracle database script Sessions accessing Object
  Read More

• Session login history from ash - oracle database script

  
  September 05, 2019

  AODBA
  Session login history from ash - oracle database script
  Session login history Oracle database script Ash
  Read More

• Segments with high physical read - oracle database script

  
  September 05, 2019

  AODBA
  Segments with high physical read - oracle database script
  Oracle database script High physical read Segments
  Read More

• Script to monitor temp tablespace usage - oracle database script

  
  September 05, 2019

  AODBA
  Script to monitor temp tablespace usage - oracle database script
  Monitor temp tablespace usage Oracle database script Script
  Read More

• Script to monitor tablespace usage - oracle database script

  
  September 05, 2019

  AODBA
  Script to monitor tablespace usage - oracle database script
  Monitor tablespace usage Oracle database script Script
  Read More

• Script to find active sessions in database - oracle database script

  
  September 05, 2019

  AODBA
  Script to find active sessions in database - oracle database script
  Find active sessions Oracle database script Script Database
  Read More

• Scn to timestamp and viceversa - oracle database script

  
  September 05, 2019

  AODBA
  Scn to timestamp and viceversa - oracle database script
  Oracle database script Viceversa Timestamp Scn
  Read More

• Run shared pool advisory - oracle database script

  
  September 05, 2019

  AODBA
  Run shared pool advisory - oracle database script
  Run shared pool advisory Oracle database script
  Read More

• Run sga target advisory - oracle database script

  
  September 05, 2019

  AODBA
  Run sga target advisory - oracle database script
  Run sga target advisory Oracle database script
  Read More

• Rman tablespace backup run block - oracle database script

  
  September 05, 2019

  AODBA
  Rman tablespace backup run block - oracle database script
  Rman tablespace backup run block Oracle database script
  Read More

• Rman incremental db backup run block script - oracle database script

  
  September 05, 2019

  AODBA
  Rman incremental db backup run block script - oracle database script
  Rman incremental db backup run block script Oracle database script
  Read More

• Rman full database backup script - oracle database script

  
  September 05, 2019

  AODBA
  Rman full database backup script - oracle database script
  Rman full database backup script Oracle database script
  Read More

• Rman datafile(s) backup run block - oracle database script

  
  September 05, 2019

  AODBA
  Rman datafile(s) backup run block - oracle database script
  Oracle database script Backup run block Rman datafile
  Read More

• Restore archivelog from rman tape - oracle database script

  
  September 05, 2019

  AODBA
  Restore archivelog from rman tape - oracle database script
  Oracle database script Rman tape Restore archivelog
  Read More

• Rename a partition - oracle database script

  
  September 05, 2019

  AODBA
  Rename a partition - oracle database script
  Oracle database script Rename Partition
  Read More

• Relocate a service - oracle database script

  
  September 05, 2019

  AODBA
  Relocate a service - oracle database script
  Oracle database script Service Relocate
  Read More

• Recover dropped table with rman 12c - oracle database script

  
  September 05, 2019

  AODBA
  Recover dropped table with rman 12c - oracle database script
  Recover dropped table Oracle database script Rman 12c
  Read More

• Recover a dropped table - oracle database script

  
  September 05, 2019

  AODBA
  Recover a dropped table - oracle database script
  Oracle database script Dropped table Recover
  Read More

• Queries causing high physical read - oracle database script

  
  September 05, 2019

  AODBA
  Queries causing high physical read - oracle database script
  Queries causing high physical read Oracle database script
  Read More

• Purge recyclebin in database - oracle database script

  
  September 05, 2019

  AODBA
  Purge recyclebin in database - oracle database script
  Oracle database script Purge recyclebin Database
  Read More

• Purge old awr snapshots - oracle database script

  
  September 05, 2019

  AODBA
  Purge old awr snapshots - oracle database script
  Purge old awr snapshots Oracle database script
  Read More

• Publish pending stats - oracle database script

  
  September 05, 2019

  AODBA
  Publish pending stats - oracle database script
  Publish pending stats Oracle database script
  Read More

• Pga usage by sessions - oracle database script

  
  September 05, 2019

  AODBA
  Pga usage by sessions - oracle database script
  Oracle database script Pga usage Sessions
  Read More

• Oracle license usage info

  
  September 05, 2019

  AODBA
  Oracle license usage info
  Oracle license usage info
  Read More

• Oracle db is 32bit or 64 bit?

  
  September 05, 2019

  AODBA
  Oracle db is 32bit or 64 bit?
  Oracle db 64 bit 32bit
  Read More

• Open database link information - oracle database script

  
  September 05, 2019

  AODBA
  Open database link information - oracle database script
  Open database link information Oracle database script
  Read More

• Objects locked by library cache - oracle database script

  
  September 05, 2019

  AODBA
  Objects locked by library cache - oracle database script
  Oracle database script Objects locked Library cache
  Read More

• Objects causing latch contention - oracle database script

  
  September 05, 2019

  AODBA
  Objects causing latch contention - oracle database script
  Objects causing latch contention Oracle database script
  Read More

• Objects causing flushing of shared pool - oracle database script

  
  September 05, 2019

  AODBA
  Objects causing flushing of shared pool - oracle database script
  Oracle database script Objects causing flushing Shared pool
  Read More

• Non-partitioned to partitioned online(12cr2 only) - oracle database script

  
  September 05, 2019

  AODBA
  Non-partitioned to partitioned online(12cr2 only) - oracle database script
  Oracle database script Partitioned online Partitioned Non
  Read More

• Mutex sleep in database - oracle database script

  
  September 05, 2019

  AODBA
  Mutex sleep in database - oracle database script
  Oracle database script Mutex sleep Database
  Read More

• Move voting disk to new diskgroup - oracle database script

  
  September 05, 2019

  AODBA
  Move voting disk to new diskgroup - oracle database script
  Oracle database script Move voting disk New diskgroup
  Read More

• Move partition to new tablespace - oracle database script

  
  September 05, 2019

  AODBA
  Move partition to new tablespace - oracle database script
  Oracle database script New tablespace Move partition
  Read More

• Mount/dismount asm diskgroups - oracle database script

  
  September 05, 2019

  AODBA
  Mount/dismount asm diskgroups - oracle database script
  Oracle database script Dismount asm diskgroups Mount
  Read More

• Monitor undo tablespace usage - oracle database script

  
  September 05, 2019

  AODBA
  Monitor undo tablespace usage - oracle database script
  Monitor undo tablespace usage Oracle database script
  Read More

• Monitor rollback transactions - oracle database script

  
  September 05, 2019

  AODBA
  Monitor rollback transactions - oracle database script
  Oracle database script Monitor rollback transactions
  Read More

• Monitor rman backup progress - oracle database script

  
  September 05, 2019

  AODBA
  Monitor rman backup progress - oracle database script
  Monitor rman backup progress Oracle database script
  Read More

• Monitor parallel queries - oracle database script

  
  September 05, 2019

  AODBA
  Monitor parallel queries - oracle database script
  Oracle database script Monitor parallel queries
  Read More

• Monitor index usage - oracle database script

  
  September 05, 2019

  AODBA
  Monitor index usage - oracle database script
  Oracle database script Monitor index usage
  Read More

• Monitor asm diskgroup i/o - oracle database script

  
  September 05, 2019

  AODBA
  Monitor asm diskgroup i/o - oracle database script
  Oracle database script Monitor asm diskgroup
  Read More

• Monitor asm disk rebalance - oracle database script

  
  September 05, 2019

  AODBA
  Monitor asm disk rebalance - oracle database script
  Monitor asm disk rebalance Oracle database script
  Read More

• Modify moving window baseline size - oracle database script

  
  September 05, 2019

  AODBA
  Modify moving window baseline size - oracle database script
  Modify moving window baseline size Oracle database script
  Read More

• Modify asm user password - oracle database script

  
  September 05, 2019

  AODBA
  Modify asm user password - oracle database script
  Modify asm user password Oracle database script
  Read More

• Merge partition - oracle database script

  
  September 05, 2019

  AODBA
  Merge partition - oracle database script
  Oracle database script Merge partition
  Read More

• Manual backup of ocr and list backups - oracle database script

  
  September 05, 2019

  AODBA
  Manual backup of ocr and list backups - oracle database script
  Oracle database script Manual backup List backups Ocr
  Read More

• Manage mgmtdb in 12c rac - oracle database script

  
  September 05, 2019

  AODBA
  Manage mgmtdb in 12c rac - oracle database script
  Oracle database script Manage mgmtdb 12c rac
  Read More

• Make a partition ready only(12cr2) - oracle database script

  
  September 05, 2019

  AODBA
  Make a partition ready only(12cr2) - oracle database script
  Oracle database script Partition ready Make 12cr2
  Read More

• Lock/unlock statistics - oracle database script

  
  September 05, 2019

  AODBA
  Lock/unlock statistics - oracle database script
  Oracle database script Unlock statistics Lock
  Read More

• List flashback restore points - oracle database script

  
  September 05, 2019

  AODBA
  List flashback restore points - oracle database script
  List flashback restore points Oracle database script
  Read More

• Latch type and sql hash value - oracle database script

  
  September 05, 2019

  AODBA
  Latch type and sql hash value - oracle database script
  Sql hash value Oracle database script Latch type
  Read More

• Kill snipped session in db - oracle database script

  
  September 05, 2019

  AODBA
  Kill snipped session in db - oracle database script
  Oracle database script Kill snipped session Db
  Read More

• Kill all sessions of a sql_id - oracle database script

  
  September 05, 2019

  AODBA
  Kill all sessions of a sql_id - oracle database script
  Oracle database script Sql_id Sessions Kill
  Read More

• Kill all session of a user - oracle database script

  
  September 05, 2019

  AODBA
  Kill all session of a user - oracle database script
  Oracle database script User Session Kill
  Read More

• I/o usage of each tempfile - oracle database script

  
  September 05, 2019

  AODBA
  I/o usage of each tempfile - oracle database script
  Oracle database script Usage Tempfile
  Read More

• Installed rdbms components - oracle database script

  
  September 05, 2019

  AODBA
  Installed rdbms components - oracle database script
  Oracle database script Installed rdbms components
  Read More

• How to change asm sys password - oracle database script

  
  September 05, 2019

  AODBA
  How to change asm sys password - oracle database script
  Change asm sys password Oracle database script
  Read More

• How far we can flashback - oracle database script

  
  September 05, 2019

  AODBA
  How far we can flashback - oracle database script
  Oracle database script Flashback Far
  Read More

• Get statistics preference setting - oracle database script

  
  September 05, 2019

  AODBA
  Get statistics preference setting - oracle database script
  Get statistics preference setting Oracle database script
  Read More

• Get sql_text from sid - oracle database script

  
  September 05, 2019

  AODBA
  Get sql_text from sid - oracle database script
  Oracle database script Get sql_text Sid
  Read More

• Get sql_profile of a sql_id - oracle database script

  
  September 05, 2019

  AODBA
  Get sql_profile of a sql_id - oracle database script
  Oracle database script Get sql_profile Sql_id
  Read More

• Get size of the database - oracle database script

  
  September 05, 2019

  AODBA
  Get size of the database - oracle database script
  Oracle database script Get size Database
  Read More

• Get sid from os pid - oracle database script

  
  September 05, 2019

  AODBA
  Get sid from os pid - oracle database script
  Oracle database script Os pid Get sid
  Read More

• Get row_count of partitions of a table - oracle database script

  
  September 05, 2019

  AODBA
  Get row_count of partitions of a table - oracle database script
  Oracle database script Get row_count Table Partitions
  Read More

• Get redo log member info - oracle database script

  
  September 05, 2019

  AODBA
  Get redo log member info - oracle database script
  Get redo log member info Oracle database script
  Read More

• Get parallel query detail - oracle database script

  
  September 05, 2019

  AODBA
  Get parallel query detail - oracle database script
  Get parallel query detail Oracle database script
  Read More

• Get os pid from sid - oracle database script

  
  September 05, 2019

  AODBA
  Get os pid from sid - oracle database script
  Oracle database script Get os pid Sid
  Read More

• Get olr info in rac - oracle database script

  
  September 05, 2019

  AODBA
  Get olr info in rac - oracle database script
  Oracle database script Get olr info Rac
  Read More

• Get node info using olsnodes - oracle database script

  
  September 05, 2019

  AODBA
  Get node info using olsnodes - oracle database script
  Get node info using olsnodes Oracle database script
  Read More

• Get interface info in rac - oracle database script

  
  September 05, 2019

  AODBA
  Get interface info in rac - oracle database script
  Oracle database script Get interface info Rac
  Read More

• Get installed sqlpatches in db - oracle database script

  
  September 05, 2019

  AODBA
  Get installed sqlpatches in db - oracle database script
  Oracle database script Get installed sqlpatches Db
  Read More

• Get disktimeout values - oracle database script

  
  September 05, 2019

  AODBA
  Get disktimeout values - oracle database script
  Oracle database script Get disktimeout values
  Read More

• Get ddl of privileges granted to user - oracle database script

  
  September 05, 2019

  AODBA
  Get ddl of privileges granted to user - oracle database script
  Oracle database script Privileges granted Get ddl User
  Read More

• Get ddl of all tablespaces - oracle database script

  
  September 05, 2019

  AODBA
  Get ddl of all tablespaces - oracle database script
  Oracle database script Get ddl Tablespaces
  Read More

• Get database uptime - oracle database script

  
  September 05, 2019

  AODBA
  Get database uptime - oracle database script
  Oracle database script Get database uptime
  Read More

• Get database incarnation info - oracle database script

  
  September 05, 2019

  AODBA
  Get database incarnation info - oracle database script
  Get database incarnation info Oracle database script
  Read More

• Get cpu memory info of db server - oracle database script

  
  September 05, 2019

  AODBA
  Get cpu memory info of db server - oracle database script
  Get cpu memory info Oracle database script Db server
  Read More

• Get cluster_interconnect details - oracle database script

  
  September 05, 2019

  AODBA
  Get cluster_interconnect details - oracle database script
  Oracle database script Get cluster_interconnect details
  Read More

• Get bind values of a sql_id - oracle database script

  
  September 05, 2019

  AODBA
  Get bind values of a sql_id - oracle database script
  Oracle database script Get bind values Sql_id
  Read More

• Get background process details - oracle database script

  
  September 05, 2019

  AODBA
  Get background process details - oracle database script
  Get background process details Oracle database script
  Read More

• Get asm diskgroup details - oracle database script

  
  September 05, 2019

  AODBA
  Get asm diskgroup details - oracle database script
  Get asm diskgroup details Oracle database script
  Read More

• Get asm disk info - oracle database script

  
  September 05, 2019

  AODBA
  Get asm disk info - oracle database script
  Get asm disk info Oracle database script
  Read More

• Get alert log location in db - oracle database script

  
  September 05, 2019

  AODBA
  Get alert log location in db - oracle database script
  Get alert log location Oracle database script Db
  Read More

• Get active sid of a pl/sql object - oracle database script

  
  September 05, 2019

  AODBA
  Get active sid of a pl/sql object - oracle database script
  Oracle database script Get active sid Sql object Pl
  Read More

• Get acl details in database - oracle database script

  
  September 05, 2019

  AODBA
  Get acl details in database - oracle database script
  Get acl details Oracle database script Database
  Read More

• Ger row_count of all the tables of a schema - oracle database script

  
  September 05, 2019

  AODBA
  Ger row_count of all the tables of a schema - oracle database script
  Oracle database script Ger row_count Tables Schema
  Read More

• Generate resize datafile script - oracle database script

  
  September 05, 2019

  AODBA
  Generate resize datafile script - oracle database script
  Generate resize datafile script Oracle database script
  Read More

• Generate multiple awr report - oracle database script

  
  September 05, 2019

  AODBA
  Generate multiple awr report - oracle database script
  Generate multiple awr report Oracle database script
  Read More

• Generate addm report - oracle database script

  
  September 05, 2019

  AODBA
  Generate addm report - oracle database script
  Oracle database script Generate addm report
  Read More

• Gather stats for schema - oracle database script

  
  September 05, 2019

  AODBA
  Gather stats for schema - oracle database script
  Oracle database script Gather stats Schema
  Read More

• Gather stats for a table - oracle database script

  
  September 05, 2019

  AODBA
  Gather stats for a table - oracle database script
  Oracle database script Gather stats Table
  Read More

• Flush a sql query from cursor - oracle database script

  
  September 05, 2019

  AODBA
  Flush a sql query from cursor - oracle database script
  Oracle database script Sql query Flush Cursor
  Read More

• Flashback query as of timestamp - oracle database script

  
  September 05, 2019

  AODBA
  Flashback query as of timestamp - oracle database script
  Oracle database script Flashback query Timestamp
  Read More

• Flashback db using restore point - oracle database script

  
  September 05, 2019

  AODBA
  Flashback db using restore point - oracle database script
  Flashback db using restore point Oracle database script
  Read More

• Flashback area usage info - oracle database script

  
  September 05, 2019

  AODBA
  Flashback area usage info - oracle database script
  Flashback area usage info Oracle database script
  Read More

• Flashback a table to point in time - oracle database script

  
  September 05, 2019

  AODBA
  Flashback a table to point in time - oracle database script
  Oracle database script Time Table Point
  Read More

• Flashback a procedure/package - oracle database script

  
  September 05, 2019

  AODBA
  Flashback a procedure/package - oracle database script
  Oracle database script Procedure Package Flashback
  Read More

• Find who locked your account - oracle database script

  
  September 05, 2019

  AODBA
  Find who locked your account - oracle database script
  Oracle database script Locked Find Account
  Read More

• Find waitevents in database - oracle database script

  
  September 05, 2019

  AODBA
  Find waitevents in database - oracle database script
  Database Oracle database script Find waitevents
  Read More

• Find top disk_reads by an user - oracle database script

  
  September 05, 2019

  AODBA
  Find top disk_reads by an user - oracle database script
  Oracle database script Find top disk_reads User
  Read More

• Find the temp usage of sessions - oracle database script

  
  September 05, 2019

  AODBA
  Find the temp usage of sessions - oracle database script
  Oracle database script Temp usage Sessions Find
  Read More

• Find the table partition keys - oracle database script

  
  September 05, 2019

  AODBA
  Find the table partition keys - oracle database script
  Table partition keys Oracle database script Find
  Read More

• Find the locked objects - oracle database script

  
  September 05, 2019

  AODBA
  Find the locked objects - oracle database script
  Oracle database script Locked objects Find
  Read More

• Find the grid version - oracle database script

  
  September 05, 2019

  AODBA
  Find the grid version - oracle database script
  Oracle database script Grid version Find
  Read More

• Find the cluster name in rac - oracle database script

  
  September 05, 2019

  AODBA
  Find the cluster name in rac - oracle database script
  Oracle database script Cluster name Rac Find
  Read More

• Find sql baseline info from sql_id - oracle database script

  
  September 05, 2019

  AODBA
  Find sql baseline info from sql_id - oracle database script
  Find sql baseline info Oracle database script Sql_id
  Read More

• Find sessions generating undo - oracle database script

  
  September 05, 2019

  AODBA
  Find sessions generating undo - oracle database script
  Find sessions generating undo Oracle database script
  Read More

• Find sessions generating alot of redo - oracle database script

  
  September 05, 2019

  AODBA
  Find sessions generating alot of redo - oracle database script
  Redo Oracle database script Find sessions generating lot
  Read More

• Find queries triggered from a procedure - oracle database script

  
  September 05, 2019

  AODBA
  Find queries triggered from a procedure - oracle database script
  Oracle database script Find queries triggered Procedure
  Read More

• Find optimal undo retention size - oracle database script

  
  September 05, 2019

  AODBA
  Find optimal undo retention size - oracle database script
  Find optimal undo retention size Oracle database script
  Read More

• Find ocr and vd location - oracle database script

  
  September 05, 2019

  AODBA
  Find ocr and vd location - oracle database script
  Oracle database script Vd location Find ocr
  Read More

• Find long running operations - oracle database script

  
  September 05, 2019

  AODBA
  Find long running operations - oracle database script
  Find long running operations Oracle database script
  Read More

• Find locks present in database - oracle database script

  
  September 05, 2019

  AODBA
  Find locks present in database - oracle database script
  Find locks present Oracle database script Database
  Read More

• Find duplicate rows in table - oracle database script

  
  September 05, 2019

  AODBA
  Find duplicate rows in table - oracle database script
  Oracle database script Find duplicate rows Table
  Read More

• Find current running sqls - oracle database script

  
  September 05, 2019

  AODBA
  Find current running sqls - oracle database script
  Find current running sqls Oracle database script
  Read More

• Find column usage statistics - oracle database script

  
  September 05, 2019

  AODBA
  Find column usage statistics - oracle database script
  Find column usage statistics Oracle database script
  Read More

• Find buffer cache usage - oracle database script

  
  September 05, 2019

  AODBA
  Find buffer cache usage - oracle database script
  Oracle database script Find buffer cache usage
  Read More

• Find blocking sessions - oracle database script

  
  September 05, 2019

  AODBA
  Find blocking sessions - oracle database script
  Oracle database script Find blocking sessions
  Read More

• Find blocking sessions from ash - oracle database script

  
  September 05, 2019

  AODBA
  Find blocking sessions from ash - oracle database script
  Oracle database script Find blocking sessions Ash
  Read More

• Find active transactions in db - oracle database script

  
  September 05, 2019

  AODBA
  Find active transactions in db - oracle database script
  Oracle database script Find active transactions Db
  Read More

• Export import statistics - oracle database script

  
  September 05, 2019

  AODBA
  Export import statistics - oracle database script
  Oracle database script Export import statistics
  Read More

• Execution detail of a sql_id in cursor - oracle database script

  
  September 05, 2019

  AODBA
  Execution detail of a sql_id in cursor - oracle database script
  Oracle database script Execution detail Sql_id Cursor
  Read More

• Execute runcluvfy.sh for rac precheck - oracle database script

  
  September 05, 2019

  AODBA
  Execute runcluvfy.sh for rac precheck - oracle database script
  Oracle database script Rac precheck Execute runcluvfy Sh
  Read More

• Enable/disable db/instance using srvctl - oracle database script

  
  September 05, 2019

  AODBA
  Enable/disable db/instance using srvctl - oracle database script
  Oracle database script Instance using srvctl Disable db Enable
  Read More

• Enable/disable autorestart of crs - oracle database script

  
  September 05, 2019

  AODBA
  Enable/disable autorestart of crs - oracle database script
  Oracle database script Disable autorestart Enable Crs
  Read More

• Enable tracing for asmcmd - oracle database script

  
  September 05, 2019

  AODBA
  Enable tracing for asmcmd - oracle database script
  Oracle database script Enable tracing Asmcmd
  Read More

• Enable tracing for a listener - oracle database script

  
  September 05, 2019

  AODBA
  Enable tracing for a listener - oracle database script
  Oracle database script Enable tracing Listener
  Read More

• Enable trace for srvctl commands - oracle database script

  
  September 05, 2019

  AODBA
  Enable trace for srvctl commands - oracle database script
  Oracle database script Srvctl commands Enable trace
  Read More

• Enable trace for rman - oracle database script

  
  September 05, 2019

  AODBA
  Enable trace for rman - oracle database script
  Oracle database script Enable trace Rman
  Read More

• Enable trace for a sql_id - oracle database script

  
  September 05, 2019

  AODBA
  Enable trace for a sql_id - oracle database script
  Oracle database script Enable trace Sql_id
  Read More

• Enable trace for a session - oracle database script

  
  September 05, 2019

  AODBA
  Enable trace for a session - oracle database script
  Oracle database script Enable trace Session
  Read More

• Enable incremental stats collection - oracle database script

  
  September 05, 2019

  AODBA
  Enable incremental stats collection - oracle database script
  Enable incremental stats collection Oracle database script
  Read More

• Enable flashback for database - oracle database script

  
  September 05, 2019

  AODBA
  Enable flashback for database - oracle database script
  Oracle database script Enable flashback Database
  Read More

• Enable block change tracking - oracle database script

  
  September 05, 2019

  AODBA
  Enable block change tracking - oracle database script
  Enable block change tracking Oracle database script
  Read More

• Enable archivelog mode in standalone db - oracle database script

  
  September 05, 2019

  AODBA
  Enable archivelog mode in standalone db - oracle database script
  Oracle database script Enable archivelog mode Standalone db
  Read More

• Dropping partition 11g/12c - oracle database script

  
  September 05, 2019

  AODBA
  Dropping partition 11g/12c - oracle database script
  Oracle database script Dropping partition 11g 12c
  Read More

• Drop asm diskgroup - oracle database script

  
  September 05, 2019

  AODBA
  Drop asm diskgroup - oracle database script
  Oracle database script Drop asm diskgroup
  Read More

• Drop an asm disk - oracle database script

  
  September 05, 2019

  AODBA
  Drop an asm disk - oracle database script
  Oracle database script Asm disk Drop
  Read More

• Drop a sql profile - oracle database script

  
  September 05, 2019

  AODBA
  Drop a sql profile - oracle database script
  Oracle database script Sql profile Drop
  Read More

• Drop a sql baseline - oracle database script

  
  September 05, 2019

  AODBA
  Drop a sql baseline - oracle database script
  Oracle database script Sql baseline Drop
  Read More

• Disable/enable sql profile - oracle database script

  
  September 05, 2019

  AODBA
  Disable/enable sql profile - oracle database script
  Oracle database script Enable sql profile Disable
  Read More

• Disable/enable all triggers of schema - oracle database script

  
  September 05, 2019

  AODBA
  Disable/enable all triggers of schema - oracle database script
  Oracle database script Triggers Schema Enable
  Read More

• Dictionary cache hit ratio - oracle database script

  
  September 05, 2019

  AODBA
  Dictionary cache hit ratio - oracle database script
  Dictionary cache hit ratio Oracle database script
  Read More

• Delete statistics - oracle database script

  
  September 05, 2019

  AODBA
  Delete statistics - oracle database script
  Oracle database script Delete statistics
  Read More

• Delete archive older than 1 day - oracle database script

  
  September 05, 2019

  AODBA
  Delete archive older than 1 day - oracle database script
  Oracle database script Delete archive older 1 day
  Read More

• Db optimizer processing rate - oracle database script

  
  September 05, 2019

  AODBA
  Db optimizer processing rate - oracle database script
  Db optimizer processing rate Oracle database script
  Read More

• Database growth per month - oracle database script

  
  September 05, 2019

  AODBA
  Database growth per month - oracle database script
  Database growth per month Oracle database script
  Read More

• Current sga usage - oracle database script

  
  September 05, 2019

  AODBA
  Current sga usage - oracle database script
  Oracle database script Current sga usage
  Read More

• Create/drop flashback restore point - oracle database script

  
  September 05, 2019

  AODBA
  Create/drop flashback restore point - oracle database script
  Drop flashback restore point Oracle database script Create
  Read More

• Create sql baseline from cursor cache - oracle database script

  
  September 05, 2019

  AODBA
  Create sql baseline from cursor cache - oracle database script
  Oracle database script Create sql baseline Cursor cache
  Read More

• Create password file in asm dg - oracle database script

  
  September 05, 2019

  AODBA
  Create password file in asm dg - oracle database script
  Oracle database script Create password file Asm dg
  Read More

• Create baselines for all sqls of a schema - oracle database script

  
  September 05, 2019

  AODBA
  Create baselines for all sqls of a schema - oracle database script
  Oracle database script Create baselines Sqls Schema
  Read More

• Create asm disk in Linux using oracleasm

  
  September 05, 2019

  AODBA
  Create asm disk in Linux using oracleasm
  Linux using oracleasm Create asm disk
  Read More

• Copy asm file to remote asm instance - oracle database script

  
  September 05, 2019

  AODBA
  Copy asm file to remote asm instance - oracle database script
  Remote asm instance Oracle database script Copy asm file
  Read More

• Copy archive from asm to mount point - oracle database script

  
  September 05, 2019

  AODBA
  Copy archive from asm to mount point - oracle database script
  Oracle database script Mount point Copy archive Asm
  Read More

• Clock synchronization status in rac - oracle database script

  
  September 05, 2019

  AODBA
  Clock synchronization status in rac - oracle database script
  Oracle database script Clock synchronization status Rac
  Read More

• Cleanup orphaned datapump jobs - oracle database script

  
  September 05, 2019

  AODBA
  Cleanup orphaned datapump jobs - oracle database script
  Cleanup orphaned datapump jobs Oracle database script
  Read More

• Check stale stats - oracle database script

  
  September 05, 2019

  AODBA
  Check stale stats - oracle database script
  Oracle database script Check stale stats
  Read More

• Check open cursors - oracle database script

  
  September 05, 2019

  AODBA
  Check open cursors - oracle database script
  Oracle database script Check open cursors
  Read More

• Check cluster component status - oracle database script

  
  September 05, 2019

  AODBA
  Check cluster component status - oracle database script
  Check cluster component status Oracle database script
  Read More

• Characterset info of database - oracle database script

  
  September 05, 2019

  AODBA
  Characterset info of database - oracle database script
  Oracle database script Characterset info Database
  Read More

• Change asm rebalance power - oracle database script

  
  September 05, 2019

  AODBA
  Change asm rebalance power - oracle database script
  Change asm rebalance power Oracle database script
  Read More

• Buffer cache hit ratio - oracle database script

  
  September 05, 2019

  AODBA
  Buffer cache hit ratio - oracle database script
  Buffer cache hit ratio Oracle database script
  Read More

• Backup archivelogs using rman - oracle database script

  
  September 05, 2019

  AODBA
  Backup archivelogs using rman - oracle database script
  Backup archivelogs using rman Oracle database script
  Read More

• Backup archive between 2 sequence number - oracle database script

  
  September 05, 2019

  AODBA
  Backup archive between 2 sequence number - oracle database script
  Oracle database script 2 sequence number Backup arcapache hive
  Read More

• Archive generation per hour - oracle database script

  
  September 05, 2019

  AODBA
  Archive generation per hour - oracle database script
  Archive generation per hour Oracle database script
  Read More

• Alter/disable a sql plan baseline - oracle database script

  
  September 05, 2019

  AODBA
  Alter/disable a sql plan baseline - oracle database script
  Sql plan baseline Oracle database script Disable Alter
  Read More

• Add/remove instance using srvctl - oracle database script

  
  September 05, 2019

  AODBA
  Add/remove instance using srvctl - oracle database script
  Remove instance using srvctl Oracle database script Add
  Read More

• Add/remove db using srvctl - oracle database script

  
  September 05, 2019

  AODBA
  Add/remove db using srvctl - oracle database script
  Remove db using srvctl Oracle database script Add
  Read More

• Add/remove a service - oracle database script

  
  September 05, 2019

  AODBA
  Add/remove a service - oracle database script
  Oracle database script Service Remove Add
  Read More

• Adding partitions 11g/12c - oracle database script

  
  September 05, 2019

  AODBA
  Adding partitions 11g/12c - oracle database script
  Oracle database script Adding partitions 11g 12c
  Read More

• 10053 optimizer trace - oracle database script

  
  September 05, 2019

  AODBA
  10053 optimizer trace - oracle database script
  Oracle database script 10053 optimizer trace
  Read More

• Script to alter all users passwords in Oracle

  
  March 04, 2015

  AODBA
  Script to alter all users passwords in Oracle
  All Alter Dba Oracle
  Read More

• Script to list if tablespace is in backup mode in Oracle

  
  January 16, 2015

  AODBA
  Script to list if tablespace is in backup mode in Oracle
  Backup Mode Oracle Status
  Read More

• Script to list all your tables with LOB, LONG and LONG RAW data types in ORacle

  
  January 16, 2015

  AODBA
  Script to list all your tables with LOB, LONG and LONG RAW data types in ORacle
  Database Objects
  Read More

• Script to list Oracle tablespace usage

  
  January 16, 2015

  AODBA
  Script to list Oracle tablespace usage
  Dba List oracle Oracle Script
  Read More

• Script to list hidden parameters in Oracle

  
  January 16, 2015

  AODBA
  Script to list hidden parameters in Oracle
  Database Dba Hidden List
  Read More

• Script to find schema size in Oracle

  
  January 16, 2015

  AODBA
  Script to find schema size in Oracle
  Database Dba Oracle Schema size
  Read More

• Script to Extract Role granted Privileges in Oracle

  
  January 16, 2015

  AODBA
  Script to Extract Role granted Privileges in Oracle
  Database Dba Extract Grants
  Read More

• Script to check for default password in Oracle

  
  January 16, 2015

  AODBA
  Script to check for default password in Oracle
  Check Database Dba Default
  Read More

• Oracle Script to check what standby logs are being used

  
  January 14, 2015

  AODBA
  Oracle Script to check what standby logs are being used
  Check Data guard Dba Logs
  Read More

• Script to find last RMAN backup executed in Oracle

  
  January 13, 2015

  AODBA
  Script to find last RMAN backup executed in Oracle
  Backup Database Full Oracle
  Read More

• Script to Estimate Oracle RMAN backup

  
  January 13, 2015

  AODBA
  Script to Estimate Oracle RMAN backup
  Database Full backup Oracle Rman
  Read More

• Oracle Script to list RMAN backup work done so far.

  
  January 13, 2015

  AODBA
  Oracle Script to list RMAN backup work done so far.
  Read More

• Oracle Script to list space usage per data file

  
  January 08, 2015

  AODBA
  Oracle Script to list space usage per data file
  Database Datafile Free Oracle
  Read More

• Oracle Script to create dynamic kill command

  
  January 08, 2015

  AODBA
  Oracle Script to create dynamic kill command
  Database Kill Oracle Script
  Read More

• Oracle Script to Check for Data dictionary corruption

  
  January 07, 2015

  AODBA
  Oracle Script to Check for Data dictionary corruption
  Check Corruption Data Dictionary
  Read More

• Script Drop all temp datafiles

  
  December 23, 2014

  AODBA
  Script Drop all temp datafiles
  Alter Database Oracle Script
  Read More

• List top SQL statements in Oracle

  
  November 25, 2014

  AODBA
  List top SQL statements in Oracle
  List Oracle Query Top
  Read More

• Find Top Disk reads for a User in Oracle

  
  November 25, 2014

  AODBA
  Find Top Disk reads for a User in Oracle
  Admin Database Dba Oracle
  Read More

• Find Top Disk Reads in Oracle

  
  November 25, 2014

  AODBA
  Find Top Disk Reads in Oracle
  Database Oracle Script
  Read More

• Uptime Script

  
  November 24, 2014

  AODBA
  Uptime Script
  Database Dba Oracle
  Read More

• Script to List all Datafiles and Tablespaces

  
  November 24, 2014

  AODBA
  Script to List all Datafiles and Tablespaces
  Read More

• Script to find Database size in Oracle

  
  November 24, 2014

  AODBA
  Script to find Database size in Oracle
  Size
  Read More

• Oracle Script to unload/load a table

  
  November 24, 2014

  AODBA
  Oracle Script to unload/load a table
  Load Oracle Script Script load
  Read More

• Oracle Script to Clone User

  
  November 24, 2014

  AODBA
  Oracle Script to Clone User
  Clone User
  Read More

• Oracle Full Secutiry Database Audit

  
  November 24, 2014

  AODBA
  Oracle Full Secutiry Database Audit
  Admin Audit Database Dba
  Read More

• Object Dependency Report

  
  November 24, 2014

  AODBA
  Object Dependency Report
  Constraints Database Dba Objects
  Read More