-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
|
In 10g SMON gathers information on columns that are used in predicates and updates them in COL_USAGE$. Here is the… READ MORE
|
Using dbms_workload_repository.create_snapshot() one can create AWR snapshot. Example: Creates the snapshot and returns the snap id. If ‘ALL’ is not… READ MORE
— view to monitor space usage by different occupants and procedure to move the feature to a different tablespace. SQL>… READ MORE
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
“Control what I can control”
~ Alex Lima
Alex Lima 