-
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
|
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
In SQL Server snapshot can be created which creates a point in time read-only copy of any database. The amount… 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
|
http://www.ibm.com/developerworks/aix/library/au-dutta_cmds.html Here are some of the commands How many processors does my system have? To display the number of processors… READ MORE
In Oracle Using MINUS and UNION ALL one can compare 2 tables to find differences in data in the tables.… READ MORE
Information on sysjobhistory Information on sysjobs — shows job history with the most recent one to show the most recent… READ MORE
http://www.dba-oracle.com/t_x$ksmlru_x$ksmsp_shared_pool_monitoring.htm READ MORE
“Control what I can control”
~ Alex Lima
Alex Lima 