Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!sdd.hp.com!zaphod.mps.ohio-state.edu!rpi!uupsi!sunic!ugle.unit.no!nuug!fdmetd!petter From: petter@fdmetd.uucp (Petter Henrik Hansen) Newsgroups: comp.databases Subject: Oracle,buffer cache tables Keywords: Where are they? Message-ID: <772@fdmetd.uucp> Date: 22 Feb 91 14:46:09 GMT Organization: Fellesdata a.s, Oslo, Norway Lines: 26 Oracle V6.0.31 (NCR) The tables SYS.X$KCBRBH and SYS.X$KCBCBH does not exist when I try to check all SYS's tables. I have set the correct parameters in the init.ora file, and I can access the tables as SYS, but I can't grant select on them to SYSTEM. Question: 1. Where does these tables reside? In the SGA area only? 2. How do I grant select on these tables to other users? 3. Has anyone heard about products that automaticly can recommend new parameters for the database? Petter Henrik Hansen, Fellesdata a.s, P.O. Box 248, 0212 OSLO 2, NORWAY Phone : +47 2 52 84 02 Fax : +47 2 52 85 10 E-mail : ...!mcsun!nuug!fdmetd!petter or petter@fdmetd.uucp Brought to you by Super Global Mega Corp .com