-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
— shows what options are enabled SQL> select parameter FROM v$option where value = 'TRUE'; PARAMETER —————————————————————- Partitioning Objects Advanced… READ MORE
control_file_record_keep_time – the value indicates number of days before reusable record is overwritten, if set to 0 reusable record is… READ MORE
— backup control file in binary format to a file named /tmp/x.ctl, it will preserve the backup information of the… READ MORE
LogMiner can be used to recover data and audit database, it has 2 packages one of them named “DBMS_LOGMNR_D” to… READ MORE
Using timing feature on SQL*Plus one can monitor elapsed time. Example: — start timer with the name monitor_timing, name is… READ MORE
|
Lesson on learning how to write batch scripts to automate on Windows http://www.allenware.com/icsw/icswidx.htm READ MORE
|
Using the step below one can find the locks on the table by looking for object id. Example: Window 1:… READ MORE
|
http://www.orafaq.com/node/854 SQL from the link above URL to find blocking SQL select s1.username || '@' || s1.machine || ' (… READ MORE
One of the reason why invalid rowid can occur is if there is a truncate that occurs in between when… READ MORE
To display compatibility levels that can be set, 60 – 6.0, 65 – 6.5, 70 – 7.0, 80 – SQL… READ MORE
In SQL Server snapshot can be created which creates a point in time read-only copy of any database. The amount… READ MORE
Using the steps below one can change the location of the datafiles in SQLServer for user databases and tempdb. 1)… READ MORE
In Oracle there is CREATE TABLE…AS to backup table into a new table and the syntax on SQL Server is… READ MORE
DBCC CHECKDB requires some amount of temporary space, to find the amount of space required in advance using ESTIMATEONLY option… READ MORE
http://arjudba.blogspot.com/2008/05/globalnames-and-globalname-in-oracle.html To view and change global_name 22:53:34 system@TESTPRD> select * FROM global_name; GLOBAL_NAME ——————————————————————————- TESTPRD.WORLD 22:53:43 system@TESTPRD> ALTER DATABASE RENAME… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 