- Community Home
- >
- Servers and Operating Systems
- >
- Operating Systems
- >
- Operating System - HP-UX
- >
- Re: Count no. of record for a specific period of t...
Categories
Company
Local Language
Forums
Discussions
Forums
- Data Protection and Retention
- Entry Storage Systems
- Legacy
- Midrange and Enterprise Storage
- Storage Networking
- HPE Nimble Storage
Discussions
Discussions
Discussions
Forums
Forums
Discussions
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
- BladeSystem Infrastructure and Application Solutions
- Appliance Servers
- Alpha Servers
- BackOffice Products
- Internet Products
- HPE 9000 and HPE e3000 Servers
- Networking
- Netservers
- Secure OS Software for Linux
- Server Management (Insight Manager 7)
- Windows Server 2003
- Operating System - Tru64 Unix
- ProLiant Deployment and Provisioning
- Linux-Based Community / Regional
- Microsoft System Center Integration
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Discussion Boards
Community
Resources
Forums
Blogs
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 04:12 PM
тАО10-16-2003 04:12 PM
Count no. of record for a specific period of time !!
I would like to do some capacity planning work and therefore would like to create some automated scripts on Oracle database (8i) to get the no. of record update/inserted in descrete period e.g. 0:00 - 1:00; 1:00 - 2:00 etc from a statistics table.
The table has the following fields
- Job_id
- No. of records updated/inserted
- start_time
- end_time
It is quite simple if the job starts and stops within a perdefined range of measurement e.g. 0:00 - 1:00.
However, some of the jobs will start within the 0:00 - 1:00 range and finished in 1:00 - 2:00 range or even in 2:00 - 3:00 and so on, I would like to distribute the no. of record update/inserted on minutes basis and divided by the whole duration and then assign the appropriate % of records in different time ranges.
Any idea to accomplish this task ? Or any other suggestion for this kind of exercise !!
Much appreciated for your advice,
Cheers,
Chris
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 04:31 PM
тАО10-16-2003 04:31 PM
Re: Count no. of record for a specific period of time !!
http://forums1.itrc.hp.com/service/forums/questionanswer.do?threadId=228893
SEP
Owner of ISN Corporation
http://isnamerica.com
http://hpuxconsulting.com
Sponsor: http://hpux.ws
Twitter: http://twitter.com/hpuxlinux
Founder http://newdatacloud.com
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 06:02 PM
тАО10-16-2003 06:02 PM
Re: Count no. of record for a specific period of time !!
For analysing you can use the SQL TRACE utility.
THere are many scripts which are inbuilt such as
UTLESTAT.SQL
SQLUTLCHAIN.SQL
UTLDTREE.SQL inside the $ORACLE_HOME/rdbms/admin dir.
Also there is a utility called capacity planner which comes along with the Oracle Diagnostics pack.
check the metalink for more information on that.
Do check the attache as what is capacity planner and how to use it.
Revert
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-16-2003 08:20 PM
тАО10-16-2003 08:20 PM
Re: Count no. of record for a specific period of time !!
-
Please clarify further (with a more detailed example if possible)
-
Do you want to write a SQL statement to count the number of records or write a package to perform this operation?
-
thank you
Yogeeraj
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2003 02:46 AM
тАО10-17-2003 02:46 AM
Re: Count no. of record for a specific period of time !!
I think I am looking for a simple sql to solve this problem. However, not sure a simple SQL can fullfil the requirement.
Details:
We are running data warehouse and the night batch will be started on the midnight and will be finished around the morning (9:00) on average.
Since we are going to measure the loading of the system. We will capture the system statistics like CPU, memory and disk I/O (vmstat, sar iostat etc)throughout the whole data loading period.
In the same token, we have to associate how many data has been updated/inserted/delete during the data loading process (The whole cycle of the data loading process is divided into many small jobs and will be started when the required source files are ready - the readiness of source files is fluctuated from day to day) and in decrete period (This is the period of measurement) of time. e.g. start time > 0:00 and end time <= 1:00; start time > 1:00 and end time <= 2:00 etc.
In some cases, when the job is started in one measuring period (e.g. >0:00 and <=1:00) and it may finished in another measuring period (e.g. >2:00 and <=3:00 or even >3:00 and <=4:00 etc). Now I have difficulties in how this can be done through either simple SQL or procedure / package.
Many Thanks,
Chris,
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-17-2003 02:51 AM
тАО10-17-2003 02:51 AM
Re: Count no. of record for a specific period of time !!
(a)system.aud$
(b)V$ tables
Create a trigger on system.aud$ by turning on auditing. Then grab the number of records from V$SESSION table.
Just a thought.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
тАО10-22-2003 11:12 AM
тАО10-22-2003 11:12 AM
Re: Count no. of record for a specific period of time !!
to record the insert progress what i usually do is i keep running an insert into a temporary table from another session while putting a dbms_lock.sleep(t) . and then just query the temporary table as below
select l_cnt,next_idn,to_char(l_tme,'mm/dd/yyyy hh24:mi:ss') date1, (next_idn-l_cnt) row_s
from
(select l_cnt,l_tme,lead(l_cnt) over(order by l_tme) next_idn from p4k_1 )
where (next_idn-l_cnt) <>0
if you have audit columns on the table you can implement it in similar way for update .
Hope this helps .
Cheers!