Re: Performance problem with Oracle server

Xho pretty much said it all, and to the point.

One addition: I was thinking along the line of statspack: take a
snapshot, let the db
and programs run, take one more snapshot, *and compare the two
snapshots*.

What you have here, is data from instance startup onwards; Xho used the
phrase "at this level of granularity". Very politely put. I'd say:
there is none.

Compare this (your) query (as of 10:00 this morning) to this query, as
of 10:10 this morning.

Regards,
Frank van Bortel

.

Relevant Pages

  • Re: Comparing old and new state data in an object?
    ... After a certain amount of processing, ... > compare after a particular event occurs. ... The snapshot is conceptually a different problem space ... way to identify [HistorySnapshot], such as a timestamp or a sequence ...
    (comp.object)
  • Re: Creating Single Snapshot Files for Multiple Records
    ... This query selects the records based on the ticks in the checkbox, and it sounds like you already have that part sorted. ... And we also assume that there is an ID field or some such in the query, and hence the report, so let's suppose this field is called MyPK. ... Dim rst As DAO.Recordset ... Each snapshot is given a specific name for identification purposes. ...
    (microsoft.public.access.modulesdaovba)
  • RE: [Full-Disclosure] Windows Registry Analzyer
    ... Use RegMon for real-time Reg watching and try this product for Snapshot ... RegShot is a small registry compare utility that allows you to quickly ... >> Anyone know of any free tools to analyze what changes have ...
    (Full-Disclosure)
  • Re: Avoiding generating redo logs
    ... trying to save your own manufactured snapshot. ... Every time the query runs, it will be on the current at the time data. ... How come they are okay with the subsequent reads of the data, ... exact committed transactions at the time of the initial query? ...
    (comp.databases.oracle.server)
  • Re: Exporting Report to Snapshot - ODBC Error
    ... Well, that helped, but not with the issue with the ODBC error, the report ... runs much faster, I also changed the Recordset Snapshot to Snapshot, and ... still get the error after the report has been run and once I try to export. ... >> change anything affecting this query. ...
    (microsoft.public.access.reports)