-
Subscribe
Subscribed
Already have a WordPress.com account? Log in now.
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
To change database to archivelog or noarchivelog mode the database has to be in mount stage. If one tries to… READ MORE
In 8i and 9i archiver process doesn’t automatically startup when database is archive log mode so using the SQL below… READ MORE
Note: Along with user mode the following termination option can be specified ROLLBACK AFTER integer, ROLLBACK IMMEDIATE, NO_WAIT when changing… READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 