Message-Id: <10611.116372@fatcity.com> From: K Gopalakrishnan Date: Wed, 6 Sep 2000 23:25:15 -0700 (PDT) Subject: 8i Buffer Headers Dump & touch count 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" 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

Hi all

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.

Do you guys having script for this / = Any suggestion=20 please ..

Thanx

Magesh

------=_NextPart_000_002D_01C018E0.73202000-- ------------------------------ From: burak.koc@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@fatcity.com [mailto:root@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