Re: .ldf files

Yes, this is most likely your transaction log, and it is not intended to be
analyzable. It is for SQL Server's own internal purposes. There are some 3rd
party tools available which can analyze the contents, such as

http://www.red-gate.com/products/SQL_Log_Rescue/

and

http://www.lumigent.com/products/le_sql.html

--
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com

"mfm" <mfm@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:F937D3DE-463A-45F8-9FC6-CB78605552FD@xxxxxxxxxxxxxxxx

Is the .ldf file the tranasction log, and if so,
How can I analyze the contents of the .ldf file?

Relevant Pages

Dependencies and invalidations.
... In Oracle RDBMS 10.2 it is practically impossible to invalidate a PL/SQL ... create table emp1 as select * from emp; ... analyze table emp1 compute statistics for table for all indexed columns; ... SQL> create table emp1 as select * from emp; ...
(comp.databases.oracle.server)
Re: A potential bug (infinite loop) in Oracle: querying v$access
... SQL> CONNECT / AS SYSDBA ... Insufficient privileges to analyze an object in Fixed Ob ... I found Metalink doc ID 272479.1, ...
(comp.databases.oracle.server)
Oracle Optmizer does not use the right index (Oracle 9.2.0.6)
... SQL> create index tab1ind1 on tab1 ... SQL> analyze table tab1 compute statistics; ... Execution Plan ... Should be using index tab1ind1. ...
(comp.databases.oracle.server)
Re: A potential bug (infinite loop) in Oracle: querying v$access
... SQL> CONNECT / AS SYSDBA ... Insufficient privileges to analyze an object in Fixed Ob ... I then checked a production database, ...
(comp.databases.oracle.server)
Re: Using Flattened table COSTLIER than using JOINS with the SETUP tables.
... analyze table ... compute statistics or better ... SQL> SHOW PARAMETER BLOCK and then check against avg_row_len? ...
(comp.databases.oracle.tools)