-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
One can view the password change history by querying oracle’s internal table SYS.USER_HISTORY$, note this table gets updated only if… 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
undefine usr db col usr new_value usr col db new_value db set termout off select lower(user) usr, instance_name db from… 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
There are couple of ways of finding if the database was started with spfile or pfile. One way would be… 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
Today, due to a network issue the host (Solaries) lost contact with the NetApp filer and it corrupted some datafiles… READ MORE
Here is a simple script to extract the DB Links DDL with the encripted password. SET LONG 9000 — to… READ MORE
SQL> SELECT le.leseq “Current log sequence No”, 100*cp.cpodr_bno/le.lesiz “Percent Full”, cp.cpodr_bno “Current Block No”, le.lesiz “Size of Log in Blocks”… READ MORE
Get current total TEMP tablespace currently allocated, used and free: SELECT A.tablespace_name tablespace, D.mb_total, SUM (A.used_blocks * D.block_size) / 1024… READ MORE
Nice way to extract the DDL for all tablepaces.. This also can be used for other objects as well. SQL>set… READ MORE
Duplicating a Database using RMAN – (UNIX / Linux) PMMPRD to PMMQA1 Pre-requisites A valid full database backup of the… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 