1. Skip to Menu
  2. Skip to Content
  3. Skip to Footer>

Expert Sessions!

Security Bulletin - MSSQL - GDR / QFE / SP

31 July 2012

Written by Prakash Palani

 

Microsoft releases security patches on a regular basis, it is imperative for every database administrator to check the Microsoft security bulletin once a month and apply the security patches applicable (on a regular interval) to the product used in your landscape. This blog is about outlining the information like finding the latest applicable security patch and the way forward.

 

 

Read Article

Transaction Log Full - SNAP_NO_NEW_ENTRY

31 July 2012

Written by Prakash Palani

Problem Statement : In one of the SAP BW production system, we noticed that 45.6% of transaction log was used, when we reported it to the functional team, they came back saying there are no dataloads/heavy transactions running in the system. This reaction from functional team triggered a question that is "Why in the world, the transaction log space does not get freed up even after performing the transaction log backup at regular intervals (15 minutes).

 

Read Article

R3trans could not connect to database after upgrading to Oracle 11g

31 July 2012

Written by Vijayasarathy S

 

Symptom:

 

After upgrading the SRM system database to Oracle 11G (11.2.0.3), R3trans could not connect to database with the error message mentioned below. Even after changing the schema and system password, the issue did not get resolved.

 

Read Article

Tablespace Monitoring and Alerting Script

31 July 2012

Written by Prakash Palani

 

Script to Monitor Oracle Tablespace

Here is the script that can help you monitor the tablespace and alert when the threshold value is reached, it involves three different (Oracle, MS-DOS and VBScript) development techniques. Once you are done with the creation of the script, you may use the windows scheduler to run the script at a pre-defined interval. Make sure that you are able to connect to the database from the pc/server where you are planning to run all these scripts.

 

Read Article

Datafile Table Relation

31 July 2012

Written by Prakash Palani

Which datafile contains my table in Oracle? How do I find it out

You can use the below query to find out the datafile in which a particular table is stored, this is an interesting topic when you get into issues like block corruption.

SQL> select a.segment_name, a.tablespace_name, b.file_name from dba_extents a, dba_data_files b where a.file_id = b.file_id and a.segment_name='VBAK';

{fcomment} {flike}

Share

Datafile Table Relation

Latest Articles

  1. No Service for System SAP (1999-11-30 00:00:00)
  2. WebUI Not Starting (1999-11-30 00:00:00)
  3. WebUI Not Starting (1999-11-30 00:00:00)
  4. No RFC Destination for SID (2014-05-15 10:20:15)
  5. SQL 2005 Installation - number of CPUs is not a power of 2 (2014-01-03 04:59:23)

FollowUs on Twitter

SAP Web Dispatcher

SAP Web Dispatcher

Defining Backup Strategy

Defining Backup Strategy

Security Patch Strategy

Defining Security Patch Strategy

RCA Setup Guide

RCA Setup Guide for BI SBOP (BOBJ)

End-To-End SSL Setup

End-To-End SSL Setup Guide for Web Dispatcher