Systems Engineering and RDBMS

Archive for March 5th, 2007

Undocumented parameters in Oracle

Posted by decipherinfosys on March 5, 2007

We had talked about one of the undocumented parameters in Oracle before in one of our blog posts. Here is a SQL to get all the undocumented parameters and their session and instance values:

REM Show all the un-documented init.ora parameters with their current settings

COLUMN parameter HEAD ‘Parameter’ FORMAT a37
COLUMN description HEAD ‘Description’ FORMAT a50 WORD_WRAPPED
COLUMN session_value HEAD ‘Session|Value’ FORMAT a10
COLUMN instance_value HEAD ‘Instance|Value’ FORMAT a10

SELECT a.ksppinm as parameter,
a.ksppdesc as description,
b.ksppstvl as session_value,
c.ksppstvl as instance_value
FROM x$ksppi a,
x$ksppcv b,
x$ksppsv c
WHERE a.indx = b.indx
AND a.indx = c.indx
AND a.ksppinm LIKE ‘/_%’ escape ‘/’
ORDER BY a.ksppinm


Please work with Oracle support before putting any of these in production environment. Jonathan Lewis’s book has a very good description on some of the key ones so you might want to read up on that as well.

Posted in Oracle | Leave a Comment »

Daylight Savings Time 2007 patches for Oracle, SQL Server and DB2 LUW

Posted by decipherinfosys on March 5, 2007

This is in continuation to the Daylight Savings Time ( DST ) 2007 patch blog posts that we have done for the Exchange servers (patch and confirming the install). RDBMS rely on the OS clock to get the current date and time so for all your OS’s you would need the patch. For the RDBMS, read along the information below and follow the links to the vendor’s site for their KB articles to get the patches.

MS SQL Server: If you are running SQL Server, then you should read Microsoft’s KB 931975. Bottom line is the update to the OS, in addition if you are running Notification Services, then there is a SQL script that needs to be run in order to update the data in the NSTimeZoneDstOffsets table.

Oracle: If you are running Oracle, then you would need to apply the DST patches that have been released by Oracle. Oracle technology Network has more information available at this URL.

DB2 LUW: If you are running DB2 LUW, then look at the information provided by IBM at this URL.

Posted in DB2 LUW, News, Oracle, SQL Server, Technology | Leave a Comment »

Confirming Installation of the Microsoft Daylight Savings Time Patch

Posted by decipherinfosys on March 5, 2007

Unsure if the Microsoft daylight savings time patch (KB931836) has been successfully installed on your machine?

The easiest way to confirm that the patch has been applied is through the Windows Update utility. Simply go to Start -> Windows Update. This will launch your Internet browser and take you to the Windows Update homepage.

On the left-hand side of the homepage you will see a list of Options. Select the first option – ‘Review your update history’. This will present you with a list of those updates that have been applied to that particular machine. For example, on a Windows 2003 Server machine you will look for the following entry in the list of patches: Update for Windows Server 2003 (KB931836). The following screen-shot shows exactly how this entry appears in the list – in this example it is the sixth item on the list:

KB931836 Screenshot

The procedure for checking for the presence of this patch on Windows 2000 and Windows XP machines is exactly the same as it is for Windows 2003. However, the name of the entry in the patch list will vary slightly depending on the operating system. Also, using Windows Update in the manner described above can be useful in finding any other patch installed on a system.

Posted in Windows | Leave a Comment »