-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
If AUDIT_TRAIL is not set to NONE then using the following SQL one can find the statements that have auditing… READ MORE
In the view v$session there are columns that can tell if parallel DDL, DML, Query is enabled/disabled. PDML_ENABLED and PDML_STATUS… READ MORE
|
PRAGMA EXCEPTION_INIT – allows one to map ORA- error and it can be raised in PL/SQL code. The SQL Error… READ MORE
One can automate taking of snapshots of STATSPACK by executing DBMS_JOB or by scheduling it through crontab. Schedule automatic STATSPACK… READ MORE
One can truncate data in STATSPACK or delete range of snaps stored. To truncate STATSPACK data Using $ORACLE_HOME/rdbms/admin/sptrunc.sql, one can… READ MORE
When passing method_opt as 'FOR ALL COLUMNS SIZE 1', it means no histogram is collected for columns on the table(s).… READ MORE
The following java standalone program can be used to change Oracle password. It uses the OCI calls to change the… READ MORE
|
— The following anonymous PL/SQL code can be used to generate a script which can be run to generate AWR… READ MORE
See the oldest statistics history available SQL> SELECT DBMS_STATS.GET_STATS_HISTORY_AVAILABILITY FROM DUAL; GET_STATS_HISTORY_AVAILABILITY ————————————————————————— 25-OCT-11 10.00.55.093000000 PM -07:00 See the stats… READ MORE
Shows in this scenrio there are backup of stats that exists for SCOTT.TEST table SQL> select * FROM DBA_TAB_STATS_HISTORY where… READ MORE
To view output from 10053 using the following link one can download software which allows one to review the output… READ MORE
Ran into following issue were accidentally the datafile was removed before dropping the tablespace. If not fixed this can cause… READ MORE
|
# Displays information of all volume group, in the following example vb_TESTDB_data1 is one of the oracle filesystem /home/oracle $… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 