8i Buffer Headers Dump & touch count

From: K Gopalakrishnan <kaygopal_at_yahoo.com>
Date: Wed, 6 Sep 2000 23:25:15 -0700 (PDT)
Message-Id: <10611.116372@fatcity.com>

Hello !

I have been trying to figure out the 8i Buffer cache middle point insertion by buffer dumps. Here is the dump for a buffer and the corresponding X$ table entry.

      BUF#        TS#      CLASS  MODE_HELD        TCH
       TIM

---------- ---------- ---------- ---------- ----------

8186 2 19 0 2541 407631476

8174 0 11 0 2517 407631476

8177 2 15 0 2517 407631476

8185 2 17 0 2516 407631476

      8187          2         21          0       2515
 407631474

Here is the dump for that buffers:

BH #8185 (0x815b9e78) file#: 3 rdba: 0x00c00084
(3/132) class 17 ba: 0x8360c800

  set: 1, dbwrid: 0
  hash: [815e8a48,815e8a48], lru: [815b9df8,815b9f08]   LRU flags:
  ckptq: [NULL] fileq: [NULL]
  st: XCURRENT, md: NULL, rsop: 0x0, tch: 2512   flags: gotten_in_current_mode block_written_once redo_since_read
  L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]
BH #8186 (0x815b9f00) file#: 3 rdba: 0x00c00106
(3/262) class 19 ba: 0x8360d000

  set: 1, dbwrid: 0
  hash: [815f0a40,815f0a40], lru: [815b9e80,815b9f90]   LRU flags:
  ckptq: [NULL] fileq: [NULL]
  st: XCURRENT, md: NULL, rsop: 0x0, tch: 2537   flags: gotten_in_current_mode block_written_once redo_since_read
  L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]
BH #8187 (0x815b9f88) file#: 3 rdba: 0x00c00188
(3/392) class 21 ba: 0x8360d800

  set: 1, dbwrid: 0
  hash: [815f8a38,815f8a38], lru: [815b9f08,815ba018]   LRU flags:
  ckptq: [NULL] fileq: [NULL]
  st: XCURRENT, md: NULL, rsop: 0x0, tch: 2511   flags: gotten_in_current_mode
  L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]
BH #8188 (0x815ba010) file#: 1 rdba: 0x0040008f
(1/143) class 1 ba: 0x8360e000

  set: 1, dbwrid: 0
  hash: [815e2bb8,815e2bb8], lru: [815b9f90,815ba128]   LRU flags:
  ckptq: [NULL] fileq: [NULL]
  st: XCURRENT, md: NULL, rsop: 0x0, tch: 8   L:[0x0.0.0] H:[0x0.0.0] R:[0x0.0.0]

The question here is i want to figure out the position of a buffer in the hash chain at any given point of time. How do i trace that?

The buffer header dump does NOT show the position and anyway i can get the position of a buffer in X$entry or at a higher level dump???

Warm Regards,
K Gopalakrishnan
Bangalore, INDIA

Do You Yahoo!?
Yahoo! Mail - Free email you can access from anywhere! http://mail.yahoo.com/

From: "magesh" <magesh_at_garoo.ne.jp>
Date: Thu, 7 Sep 2000 15:29:44 +0900
Subject: Oracle Database Startup/Shutdown

This is a multi-part message in MIME format.

------=_NextPart_000_002D_01C018E0.73202000 Content-Type: text/plain;

charset="iso-2022-jp"
Content-Transfer-Encoding: 7bit

Hi all

My oracle database running on RH Linux 6.2 , I want to make the script for Automatically startup/shutdown the oracle database when linux server is start/shutdown.
Do you guys having script for this / Any suggestion please ..

Thanx
Magesh

------=_NextPart_000_002D_01C018E0.73202000 Content-Type: text/html;

charset="iso-2022-jp"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-2022-jp" =

http-equiv=3DContent-Type>

<META content=3D"MSHTML 5.00.2919.6307" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial size=3D2>
<DIV><FONT face=3DArial size=3D2>Hi all</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>&nbsp;&nbsp; My oracle database running =

on RH Linux=20
6.2 , I want  to make the script for Automatically startup/shutdown = the=20
oracle database when linux server  is start/shutdown.</FONT></DIV> <DIV><FONT face=3DArial size=3D2>Do you guys having script for this / = Any suggestion=20
please ..</FONT></DIV>

<DIV>&nbsp;</DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2>Thanx </FONT></DIV>
<DIV><FONT face=3DArial size=3D2>Magesh</FONT></DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV>
<DIV></FONT><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial size=3D2></FONT>&nbsp;</DIV></BODY></HTML>

------=_NextPart_000_002D_01C018E0.73202000--

From: burak.koc_at_intertech.com.tr (Burak Koc) Date: Thu, 7 Sep 2000 09:34:53 +0300
Subject: RE: Import/Export with data containing portuguese characters

u can define like this
NLS_LANG=AMERICAN_TURKEY.WE8ISO8859P9
export NLS_LANG
yes u should do it for both users

-----Original Message-----
From: root_at_fatcity.com [mailto:root_at_fatcity.com]On Behalf Of ALEMU Abiy Sent: Thursday, September 07, 2000 9:35 AM To: Multiple recipients of list ORACLE-L Subject: RE: Import/Export with data containing portuguese characters

How can you define the NLS_LANG parameter in the .profile file ? With the Received on Thu Sep 07 2000 - 01:25:15 CDT