-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
General Database Script
Most of the time, when GoldenGate extract runs without a hitch, and the GoldenGate monitor displays no anomalies or slowness,… READ MORE
Here is an example how to stop and start the Distribution Services in GoldenGate Microservices using a REST API. READ MORE
Using the following PL/SQL code one can find average size of a row in a table, the following code samples… READ MORE
|
Using v$filestat one can find the physical reads and writes to datafiles it also includes reads done by RMAN. So… READ MORE
I use this script to clean up all the log and trace file from each host.. You can schedule a… READ MORE
This script will delete files modified more than 14 days ago and have file name that begin with daily_backup ,… READ MORE
— compile public synonym that are invalid Select ‘alter public synonym ‘||object_name||’ compile;’ From dba_objects Where status <> ‘VALID’ And… READ MORE
SQL>grant select on dba_objects to <username>; SQL>conn <username>/<password> SET PAGESIZE 0 SET LONG 100000 SET LONGCHUNKSIZE 10000 SET LINESIZE 1000… READ MORE
|
CREATE OR REPLACE TRIGGER sys.session_trace_on– to be created by sys userAFTER LOGON ON databaseDECLAREmachinename VARCHAR2(64);osuserid VARCHAR2(30);ora_username VARCHAR2(30) DEFAULT NULL;os_username VARCHAR2(30);v_sid… READ MORE
To see current stats of your session, one can run the following query. SELECT a.name, b.value FROM v$statname a, v$mystat… READ MORE
By having a logon trigger in a database one can monitor or audit OS user, programs, DB users, time users… READ MORE
If you are doing migrating to a new filesystem and moving files, it may be a good idea to check… READ MORE
Killing the rman main process from the command line doesn’t immediately kill the rman sessions using the script below which… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 