-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
By querying msdb.dbo.backupset and msdb.obackupmediafamily one can see backup history like start and end time, type of backup, location of… READ MORE
|
To use oradebug one first needs to connect to a session using the process id or ora pid. One can… READ MORE
http://dioncho.wordpress.com/tag/copy_table_stats/ READ MORE
One of the ways to extend the password of an expiring account is to change the profile of the user.… READ MORE
To disable to trigger that are enabled in cases when loading data manually in a particular schema or table can… READ MORE
|
As RMAN needs a consistent view of the control file it takes a backup of the controlfile by creating a… READ MORE
Using the following PL/SQL code one can find average size of a row in a table, the following code samples… READ MORE
|
Table structure in Oracle SQL> desc scott.oracletable; Name Null? Type —————————————– ——– ———- TRANSDATE NOT NULL DATE SEQUENCE_NO NOT NULL… READ MORE
Now Oracle has a quick way to find users with detault password. SQL> SELECT * FROM dba_users_with_defpwd; And here is… READ MORE
|
Using dbms_lob.getlength(column name) one can find the length of the LOB (CLOB/BLOB/BFILE) data type. Example: SQL> SELECT dbms_lob.getlength(lob_column) FROM scott.lob_table;… READ MORE
Using ANALYZE TABLE owner.table_name COMPUTE STATISTICS one can find if the table has chained rows. Example: — analyze again SQL>… READ MORE
|
Using v$filestat one can find the physical reads and writes to datafiles it also includes reads done by RMAN. So… 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
“Control what I can control”
~ Alex Lima
Alex Lima 