topic Re: Pass ur comments in Operating System - HP-UX

Pass ur comments

prem_4 — Tue, 08 Jul 2003 06:02:09 GMT

What do u infer from the following ?

1. Number of Database dropped
2. Number of Database created
3. Configuration details

Re: Pass ur comments

Massimo Bianchi — Tue, 08 Jul 2003 06:19:35 GMT

Hi,

Referring to oracle: someone is playing too much with databases, they aren't created so easily every day and then dropped

Referring to MSSqlserver: again as upper, but i know that in MS this misuse is more widespread.

In general...

Looks like someone is trying to determine a reference for billing, but i would use number of tables dropped/created, instead of databases. The configuration detail could be for detemining the resource needed.

But honestly is very obscure.

My finally inference is: "Someone has drunk without me :)"

Massimo

Re: Pass ur comments

Radim Jarosek — Tue, 08 Jul 2003 06:23:10 GMT

Hi,

could you be more specific ?

Radim

Re: Pass ur comments

twang — Tue, 08 Jul 2003 06:47:40 GMT

Drop database: My previous experience on this is to handle Block Corruptions.

Recreate database:
If you are creating a second database, be sure to use a new database name.

Configuration details: How to Configure the Database with SSL Using a DN Certificate.
Configure the Oracle Database Configuration Files (listener.ora, sqlnet.ora, tnsnames.ora)

Re: Pass ur comments

prem_4 — Tue, 08 Jul 2003 07:19:21 GMT

hi radim,

just tell me what u feel or how u infer when look at the following values:

1. Number of tables/database dropped
2. Number of tables/database created
3. Most queried table
4. Most used database

Re: Pass ur comments

Massimo Bianchi — Tue, 08 Jul 2003 07:26:51 GMT

Hi,
now it has more sense.

You are searching for a set/subset of performance indicator, for a server or for a specific database (most queried tables) ?

Massimo

Re: Pass ur comments

twang — Tue, 08 Jul 2003 07:47:07 GMT

In addition, for Most queried table
- Oracle introduced a facility in release 8i to monitor table modifications. This facility can be enabled using the ALTER TABLE MONITORING command. The approximate number of rows updated, inserted to, and deleted from each monitored table is counted. The modification counts are maintained in a special data structure in the SGA and flushed to a table in the data dictionary by SMON periodically (every 3 hours under release 8.1) and at instance shutdown. The DBA_TAB_MODIFICATIONS view can be queried to see these modification counts.

Re: Pass ur comments

Massimo Bianchi — Tue, 08 Jul 2003 07:52:47 GMT

Hi,
Twang, i think he/she refers to Mysql, looking at the other question posted.

Am I right ?
Massimo

Re: Pass ur comments

prem_4 — Tue, 08 Jul 2003 08:09:08 GMT

hi Bianchi,
U are right! i am presently working with MySql, but i want the comments to be more general; the way an end-user may infer it!

To be very precise in what way does these values help an administrator or any other person who manages the database.

Re: Pass ur comments

Massimo Bianchi — Tue, 08 Jul 2003 08:49:46 GMT

Hi,
asking here for end-user opinion is a little controverse.

I think a few of us are "end user", most are admins, with a logic that is sometimes totally different.

The number you proposed can help in understand what are the tables/databases most used, and so the ones that need:

- more attention from sysadmins
- more tuning
- more hardware if load is growing

If you are looking for inter-database performance indicators, then it is another question.

I can talk about Oracle, but i don't know enough others databases to tell the crucial points, or even the proper terminology.

Massimo

Re: Pass ur comments

Massimo Bianchi — Tue, 08 Jul 2003 12:11:49 GMT

nobody there ?

was i frightening with my considerations ?

Massimo

Re: Pass ur comments

prem_4 — Tue, 08 Jul 2003 15:20:13 GMT

thank u massimo! i was off for a break!

that was indeed helpul hints!

if i ask u , how u wanna have a database monitor to work for u ? what would be ur answer.

how can it serve ur purpose.?

Re: Pass ur comments

Radim Jarosek — Tue, 08 Jul 2003 15:25:23 GMT

Hi,

I agree with you Massimo.

From my point of view, point 1. and 2. are nothing say values for admins.

Points 3. a 4. are better to find some bottleneck on database. And of course each database have proc and cons.

Radim

Re: Pass ur comments

vasundhara — Wed, 09 Jul 2003 06:09:56 GMT

As an end user, I feel Number of databases as number of database instances that are created and the configuration of each instance. How frequntly a table is queried and how many tables are created/ dropped in each instance of the database.