OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » information (oracle 8 )

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

information [message #653513]

Fri, 08 July 2016 16:07

ceciaide
Messages: 8
Registered: April 2016
Location: mexico

Junior Member

how to get the information

access by day in BD
Users registered
concurrent accessse per day
Transactions per second
Transactions per day
Transactions Per week

on oracle version 8.1.7.4.0

thanks

Report message to a moderator

Re: information [message #653514 is a reply to message #653513]

Fri, 08 July 2016 18:19

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

you need to define your terms.

>access by day in BD
what specifically is considered an "access" & how is it measured?

>Users registered
What does above mean & how is it measured?

>concurrent accessse per day
What is a "concurrent access" & how is it measured?
What concurrent with what?

>Transactions per second
What indicates start & end of any single transaction?
If you have a reporting application that only ever issues SELECT, is this a single transaction, more than 1 transaction (how many), or no transaction?

>Transactions per day
>Transactions Per week
see above

you need to answer all the questions above before we can know how to solve your problem.

Report message to a moderator

Re: information [message #653516 is a reply to message #653514]

Sat, 09 July 2016 01:04

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

... also you need to provide feedback to your topic even, and I'd say especially, if you get or find an answer or a solution elsewhere, if you want to continue to get help from people who spent time to help you.

Report message to a moderator

Re: information [message #653561 is a reply to message #653514]

Mon, 11 July 2016 10:22

ceciaide
Messages: 8
Registered: April 2016
Location: mexico

Junior Member

hello
BlackSwan

I try to create a script to obtain information from the database version 8

how many users access a day to the database

select count(*) "Users" from dba_users;

how many users have the database

select SESSIONS_CURRENT "Users_Current" from v$license;

only need to find the script to obtain the information.
Access by day
Transactions per second
Transactions per day
Transactions Per week

i find a script similar

set heading off
COLUMN short_name format a20
COLUMN per_sec format 999,999,999,990
select lpad(short_name, 20, ' ') short_name, per_sec
from
    (select short_name, max(decode(typ, 1, value*60*60*24)) per_sec, max(m_rank) m_rank
       from
        (select /*+ use_hash(s) */
                m.short_name, s.value * coeff value, typ, m_rank
           from v$sysmetric s,
               (
                select 'Logons Per Sec' metric_name, 'Access by day: ' short_name, 1 coeff, 1 typ, 11 m_rank from dual union all
                select 'User Transaction Per Sec' metric_name, 'Transacc. by day: ' short_name, 1 coeff, 1 typ, 14 m_rank from dual) m
          where m.metric_name = s.metric_name
            and s.intsize_csec > 5000
            and s.intsize_csec < 7000)
      group by short_name)
 order by m_rank;

select lpad(short_name, 20, ' ') short_name, per_sec
from
    (select short_name, max(decode(typ, 1, value*60*60*24*7)) per_sec, max(m_rank) m_rank
       from
        (select /*+ use_hash(s) */
                                m.short_name, s.value * coeff value, typ, m_rank
           from v$sysmetric s,
               (
                select 'User Transaction Per Sec' metric_name, 'Transacc.by week: ' short_name, 1 coeff, 1 typ, 14 m_rank from dual) m
          where m.metric_name = s.metric_name
            and s.intsize_csec > 5000
            and s.intsize_csec < 7000)
      group by short_name)
 order by m_rank;

but it does not work
because the version is 8

Report message to a moderator

Re: information [message #653562 is a reply to message #653561]

Mon, 11 July 2016 10:30

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

If you want help you MUST provide feedback in your previous topic.

And you MUST provide your Oracle version with 4 decimals.

Report message to a moderator

Re: information [message #653563 is a reply to message #653562]

Mon, 11 July 2016 10:59

ceciaide
Messages: 8
Registered: April 2016
Location: mexico

Junior Member

hello

the version: 8.1.7.4.0

the information

only need to find the script to obtain the information.
Access by day
Transactions per second
Transactions per day
Transactions Per week

im find to script similar but does not work for the version oracle 8

set heading off
COLUMN short_name format a20
COLUMN per_sec format 999,999,999,990
select lpad(short_name, 20, ' ') short_name, per_sec
from
    (select short_name, max(decode(typ, 1, value*60*60*24)) per_sec, max(m_rank) m_rank
       from
        (select /*+ use_hash(s) */
                m.short_name, s.value * coeff value, typ, m_rank
           from v$sysmetric s,
               (
                select 'Logons Per Sec' metric_name, 'Access by day: ' short_name, 1 coeff, 1 typ, 11 m_rank from dual union all
                select 'User Transaction Per Sec' metric_name, 'Transacc. by day: ' short_name, 1 coeff, 1 typ, 14 m_rank from dual) m
          where m.metric_name = s.metric_name
            and s.intsize_csec > 5000
            and s.intsize_csec < 7000)
      group by short_name)
 order by m_rank;

select lpad(short_name, 20, ' ') short_name, per_sec
from
    (select short_name, max(decode(typ, 1, value*60*60*24*7)) per_sec, max(m_rank) m_rank
       from
        (select /*+ use_hash(s) */
                                m.short_name, s.value * coeff value, typ, m_rank
           from v$sysmetric s,
               (
                select 'User Transaction Per Sec' metric_name, 'Transacc.by week: ' short_name, 1 coeff, 1 typ, 14 m_rank from dual) m
          where m.metric_name = s.metric_name
            and s.intsize_csec > 5000
            and s.intsize_csec < 7000)
      group by short_name)
 order by m_rank;

Report message to a moderator

Re: information [message #653564 is a reply to message #653563]

Mon, 11 July 2016 11:01

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

So this is version 8i and not 8.
And we are still waiting for your feedback in your previous topic.

Report message to a moderator

Re: information [message #653565 is a reply to message #653564]

Mon, 11 July 2016 11:24

ceciaide
Messages: 8
Registered: April 2016
Location: mexico

Junior Member

hello Michel Cadot

I'm not very familiar with the oracle 8.

can you tell me what information you require to continue.

thanks

Report message to a moderator

Re: information [message #653566 is a reply to message #653565]

Mon, 11 July 2016 11:33

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

You can read all 8i at URL below

http://www.oracle.com/pls/tahiti/homepage

I went directly from V7.3.4.5 to V9 without ever deploying 8i in Production

Report message to a moderator

Re: information [message #653567 is a reply to message #653565]

Mon, 11 July 2016 12:12

Michel Cadot
Messages: 68645
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

ceciaide wrote on Mon, 11 July 2016 18:24

hello Michel Cadot
...
can you tell me what information you require to continue.
...

A feedback and solution there.

Report message to a moderator

Re: information [message #653569 is a reply to message #653565]

Mon, 11 July 2016 12:58

EdStevens
Messages: 1376
Registered: September 2013

Senior Member

ceciaide wrote on Mon, 11 July 2016 11:24

hello Michel Cadot

I'm not very familiar with the oracle 8.

A lot of people are not very familiar with Oracle 8. It has been out of support for decades. It the rest of your technology stack (hardware, OS, applications) equally old?

Report message to a moderator

Re: information [message #653574 is a reply to message #653513]

Mon, 11 July 2016 14:21

John Watson
Messages: 8931
Registered: January 2010
Location: Global Village

Senior Member

You will be able to get the information you need from statspack. You do have statspack in your release. Detail of how to use it is in the file $ORACLE_HOME/rdbms/admin/spdoc.txt

Report message to a moderator

Re: information [message #653589 is a reply to message #653567]

Mon, 11 July 2016 16:32

ceciaide
Messages: 8
Registered: April 2016
Location: mexico

Junior Member

hello Michel Cadot

im complete de feedback and solution.

thanks

Report message to a moderator

Previous Topic:	PL/SQL error
Next Topic:	Query: select id where max(value) - possible?

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 24 23:09:12 CDT 2024