Re: RE: What is gethit and pinhit!

From: Cyril Thankappan <cyril_thank_at_rediffmail.com>
Date: 27 Dec 2000 19:11:08 -0000
Message-Id: <10723.125369@fatcity.com>

Hi.
can somebody please 'confirm' to me
my concepts of 'consitent gets' 'db block gets'

                'current block'

Please

Thanks
------------- Original Message -------------- "Steve Adams" <steve.adams_at_ixora.com.au> wrote: To:Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> From:"Steve Adams" <steve.adams_at_ixora.com.au> Date:Wed, 27 Dec 2000 04:45:47 -0800
Subject:RE: What is gethit and pinhit!

Hi Mohan,

This link may help.
http://www.ixora.com.au/q+a/0011/08200945.htm

@   Regards,
@   Steve Adams
@   http://www.ixora.com.au/
@   http://www.christianity.net.au/

-----Original Message-----
Sent: Friday, 22 December 2000 23:16
To: Multiple recipients of list ORACLE-L

Hi,

In Oracle 8 Tuning book by Ault & others, while discussing UTLBSTAT & UTLESTAT, they talk of gets, gethit, pins pinhit. I couldn't understand what gethit and pinhit mean. Can someone please tell me what it is?

Regards,
Mohan
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Ramamohan B N
INET: ramamohan.bn_at_tatainfotech.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Steve Adams
INET: steve.adams_at_ixora.com.au

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------

Chat with your friends as soon as they come online. Get Rediff Bol at http://bol.rediff.com

From: Brian Wisniewski <brian_wisniewski_at_yahoo.com> Date: Wed, 27 Dec 2000 11:43:41 -0800 (PST) Subject: interMedia, bfile and blob

The very little I've done with images was back on 7.1 using raw's so this is pretty much new to me.

I've been given the task to create a new database (8.1.6 or 8.1.7, not sure yet) which will be used for storing images of checks, front and back, and a small amount of information about them. The database will be accessed and displayed by a Lotus Domino web server. There will be ~100 million rows and given the size of the images it is guestimated the size of the database to initially be about 4 terabytes.

From what I've read it appears the interMedia option is the easiest way

I'm a DBA but this is going to be the first Oracle database for the developers I know I'm going to be right in the middle of this so I might as well find out as much as I can upfront.

Also for those of you who've stored binary data what is your preferred method of storage, blob or bfile? Any performance considerations of one over the other? I'm leaning towards blob so the images are backed up when the database is and purged when I drop off older partitions.

Thanks - Brian

Do You Yahoo!?
Yahoo! Shopping - Thousands of Stores. Millions of Products. http://shopping.yahoo.com/

From: Dennis Taylor <ismgr_at_pctc.com>
Date: Wed, 27 Dec 2000 12:24:05 -0800
Subject: Re: remsh question

That looks to me like ORACLE_HOME not correctly defined. sqlplus executable can't find the .msb files. For the record, my sp1us.msb file is in $ORACLE_HOME/splplus/mesg (on linux)

At 10:35 AM 12/27/00 -0800, you wrote:

>>>>

<excerpt>remsh question

<smaller>Hello - </smaller>

<smaller>Everything hit the fan here but to keep this email short: Does anyone recognize this error in remsh?</smaller>

<fontfamily><param>Courier</param><smaller>dbab backup1:/oracle/local>remsh prod -n "/oracle/local/sql/test.ksh" </smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>Message file sp1<<lang>.msb not found</smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>Error 6 initializing SQL*Plus</smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>prod IS an alias and is correct. remsh is working in other parts of this script.</smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>I get the same error if I am oracle or root. </smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>There is nothing in the man pages that eludes to what this error is. </smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>I can't do this with su - oracle -c from root either. It fails. It thinks that the -n is part of the su command, and double quoting it helps none, either.</smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>usage: remsh host [ -l login ]

[ -n ] command                           </smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>logout</smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>backup1:/opt/omni/lbin# </smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>Any suggestions, thoughts, random jabs are appreciated. The jabs may help me realize that I should snap out of this.</smaller></fontfamily>

<fontfamily><param>Courier</param><smaller>Thanks everyone</smaller></fontfamily>

<bold><smaller><smaller>Lisa Rutland Koivu</smaller></smaller></bold>

<smaller><smaller>Oracle Database Administrator</smaller></smaller>

<smaller><smaller>4850 North State Road 7</smaller></smaller>

<smaller><smaller>Suite G104</smaller></smaller>

<smaller><smaller>Fort Lauderdale, FL 33319</smaller></smaller>

<italic><smaller><smaller>"The information contained herein does not express the opinion or position of Qode.com and cannot be attributed to or made binding upon Qode.com."</smaller></smaller></italic>

</excerpt>

---

Dennis Taylor

---

Don't worry about people stealing your ideas.  If your ideas

are any good, you'll have to ram them down people's throats.


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

 From: "Eric D. Pierce" <PierceED_at_csus.edu>
 Date: Wed, 27 Dec 2000 13:40:55 -0800
 Subject: OT/ Re: Re[2]: you are insufferably sanctimonious

Absolutely. I just though the idea that I was promoting
that kind of "globalism" was so bizarre, that I'd post
my response to "correct the record" in case others had
somehow gotten the same impression.

(I could have happily posted similar material from a 
buddhist, or sufi perspective.)

regards,
ep


On 27 Dec 2000, at 7:05, dgoulet_at_vicr.com wrote:

Date sent:      	Wed, 27 Dec 2000 07:05:37 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
From:           	dgoulet_at_vicr.com
Subject:        	Re[2]: you are insufferably sanctimonious

> 
> Would it be too much to ask those involved to take this off-line (namely leave
> the list out of it).






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

 From: "Eric D. Pierce" <PierceED_at_csus.edu>
 Date: Wed, 27 Dec 2000 13:55:27 -0800
 Subject: Re: Oracle events

http://www.evdbt.com/
-
http://www.evdbt.com/library.htm
-
http://www.evdbt.com/event.pdf

On 27 Dec 2000, at 7:11, Ruth Gramolini wrote:

Date sent:      	Wed, 27 Dec 2000 07:11:39 -0800
To:             	Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
From:           	"Ruth Gramolini" <rgramolini_at_tax.state.vt.us>
Subject:        	Re: Oracle events

> How do you find Tim Gorman's website?

Received on Wed Dec 27 2000 - 13:11:08 CST