-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
List of oracle default users and their password. After creating the database one may want to change the password for… READ MORE
From v$fixed_view_definition one can find the definitions of V$views which may one in understand them. Example: SQL> set pages 0… READ MORE
There are few scripts that can be used to generate AWR HTML or text reports. @?/rdbms/admin/awrrpt.sql – It is an… READ MORE
|
Using dbms_workload_repository.modify_snapshot_settings, one can modify retention, interval, and topnsql. READ MORE
Using this SQL one can find the snapshot interval and snapshot retention. SQL> SELECT extract(day from snap_interval) *24*60+extract(hour from snap_interval)… READ MORE
|
http://www.oracle.com/technology/support/tech/sql_plus/htdocs/sub_var9.html READ MORE
|
Using the example below one can include instance name in the spool filename when using SQL*Plus SQL> set termout off… READ MORE
Using sysdatabases one can create script various scripts one of the useful is to create script to backup all databases.… READ MORE
By executing the store procedure sp_spaceused ‘<table>’ one can find the space used by a table. The store procedure returns… READ MORE
Using procedures in DBMS_STATS package one can backup statistics and restore them. Assumes the user scott already has access to… READ MORE
Using ALTER SYSTEM RESET one can delete parameter from spfile if the parameter is in the spfile. Example: — shows… READ MORE
In 10g using dbms_flashback one can flashback using timestamp or SCN. If a user accidentally deletes rows or updates rows… READ MORE
|
To turn on trace for a specific event. exec dbms_system.set_ev(<SID>, <serial#>, <event>, 8, ''); Example: Enable trace at level 8… READ MORE
|
Using dbms_system.set_int_param_in_session, one can set max_dump_file_size of a running session. In the example it sets trace file to 100MB exec… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 