Year: 2005

Monitoring free memory in Large Pool and Shared pool on OracleMonitoring Free Memory in Large Pool and Shared Pool (Oracle)by Avnish Rastogi The below process was developed to monitor free memory in shared pool and large pool proactively. Lack of memory in these two pools will cause Oracle to generate ORA-4031. Another reason for ORA-4031…

nnnnnGet CD Key and MDAC Version from SQL Server 2000 – ExtremeExperts: How can I find the SQL Server CD key I used to install? It would be great to get this information from my desktop. Answer: As said the easy way is to get to the remote machines registry key settings and search for…

nnnnnUsing Excel to Pull Data from SQL ServernUsing Excel to Pull Data from SQL ServernMichael SchmalznnBefore I start, I want to emphasize that this example uses Excel for the functionality as opposed to Enterprise Manager or any of the SQL Server User Interface functionality. In the first article that I wrote about getting data from…