Oracle FAQ defines temp table space as follows: Temporary tablespaces are used to manage space for database sort operations and for storing global temporary tables. For example, if you join two large tables, and Oracle cannot do the sort in memory, space will be allocated in a temporary tablespace for doing the sort o...
I have a query to monitor SGA (non-)utilisation: select sum(bytes)/1024/1024 " SGA Free " from v$sgastat where name='free memory'; That's great, but I need more detail about what exactly is using the space. Essentially, I'm looking for clues to tell me more precisely what might be wrong with this (rather large application). select * f...
we can use time in a unix environment to see how long something took... shell> time some_random_command real 0m0.709s user 0m0.008s sys 0m0.012s is there an equivalent for recording memory usage of the process(es)? in particular i'm interested in peak allocation. ...
What's the easiest method people have found to monitor memcached on Windows? One method I've tried, which works decently: telnet into the memcached port (11211) and enter the "stats" command. You'll get back a listing like this: stats STAT pid 2816 STAT uptime 791 STAT time 1225918895 STAT version 1.2.1 STAT pointer_size 32 STAT curr_i...
Hello, I am looking for a google-analytics-style map creating app or api based on visitor IP addresses, any suggestions? thanks, nicoperez ...
I have a Rails application where users can set up their domains and publish content onto them. I need to collect public traffic statistics such as pageview count etc. One good example of this feature is flickr usage statistics i can see as a customer. The question is what is the best way to collect usage information. Should it be done b...
I am building stats for my users and dont wish the visits from bots to be counted. Now I have a basic php with mysql increasing 1 each time the page is called. But bots are also added to the count. Does anyone can think of a way? Mainly is just the major ones that mess things up. Google, Yahoo, Msn, etc. ...
I got many datasources (postgres database, logfiles) containing statistic data or containing data from which you can calculate statistic data. Im searching for a application where you can design new reports / outputs (graphs, tables etc) without using a programing language but using a gui. You should be able to save these queries and r...
I've been tasked with implementing Google Analytics inside our (ASP.NET) application. Here is the scenario: A single web-site on one domain Multiple companies all use this single website Statistics need to be collected on a per company basis as well as the whole Report access needs to be allocated on a per company basis or for all (Wou...
We've got a site that shows some content in iframes loaded from another domains. What I'd like to do is setup some Goals to track if this stuff is clicked, is this possible to track these clicks? I know that this content us outside our domain but is it still in the dom? ...
I have a website with multiple pages. All of the pages have an embedded IFRAME in them (always the same iframe src). My problem is that the iframe contains some statistical tracking code, (like statcounter), and statcounter only shows the name of the iframe as the page being visited. Is it possible somehow to include a few lines of jav...
Hi all, I'm trying to SELECT the visitors of my site per month for the current year. For every different IP/user_agent combination there will be added a row per minute. To track the hits and the unique visitors. My scheme looks like this: CREATE TABLE `stats` ( `id` int(11) unsigned NOT NULL auto_increment, `domain` varchar(4...
Does Windows XP (and up) store how long it has been... ...since the system booted? ...running since install? ...in hours/minutes since current used logged on? ...in total hours the user has been logged on? Thanks. ...
We have a site that is serving some RSS feeds, and we'd like to know how many people is subscribed to each one, without using a system like FeedBurner to serve them. The original approach to figuring this out was basically logging requests, and then getting the number of unique IP's that had requested each feed. However, if I get 1 mill...
We want to start analyzing usage of our various Subversion repositories, which is something I know is stored in our Apache logs. The problem is that I don't know of any tools out there for doing this. If, for example, I want to get a listing per repository of "There were X1 checkins and Y1 checkouts on day W1, X2 checkouts and Y2 checkin...
I want to make stats for my website. One thing I want to do is to know how many people bookmark my website. What's the best way to do that without a survey? ...
I currently have a web application and wish to add certain statistics to the site. These statistics would be in addition to web statistics. I can easily log certain events to a file via log4j. Is there something I can add that will investigate the data and format it in a human readable way (chart or table)? The application is running i...
1) long to wide question: I have a dataset with 3 columns: person, event, frequency. If the frequency is zero, the row is not in the table. Is there a simple way using basic R functions or libraries to convert this table to wide format, with one row per person and one column per event with the frequency as the value in table. 2) rattl...
Here is the real world issue that we are solving. We have some rather large data sets that need to be aggregated and summarized in real time with a number of filters and formulas applied to them. It works fine to apply these to each record in real time when the data set is less than 50,000 records but as we approach 100,000 and then 100+...
I have a Django site segmented into different city and neighborhood sub-sections. I want to serve an RSS feed for each. Easy. Problem is I wanted to use Feedburner for stats, monetization etc but each feed would need to be split out manually into its own feedburner URL. There are hundreds of cities and neighborhoods. I have to roll my ow...