-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
Using the following steps one can setup vim/gvim to run on windows. 1) Add the following new variable VIM on… READ MORE
|
Using “tracefile_identifier” Oracle will add that to the name of the user’s trace filename so the file can easily be… READ MORE
In “ALTER SYSTEM” one can include a comment which gets recorded in the spfile and also in v$parameter as shown… READ MORE
|
Using dbms_xplan.display_cursor one can see the execution plan of a SQL statement. The function takes following 3 parameters. SQL_ID (VARCHAR2)… READ MORE
The following shows how to add in a table a new column that is NOT NULL when a table already… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 