1204 is o.k, 1205 logs more detailed information. I have had those trace flags on for about a month. I havent seen any performance degradation due to those trace flags...

What kind of Trace flags R u planning to turn on?

Steve, I think his database is in...

So even if u SHRINK ur file, it will grow back to 7 GB again later on. U should make sure the queries running have transactions closed i.e. for every...

That is really high number. It means the transaction that was active at that time when u ran DBCC OPENTRAN is taking up around 7 GB of log space when...

It means your transaction is no longer active now. What is the size of your Log file now? Can u post the results of Following two queries too?

[Code]

DBCC SQLPERF(LogSpace) --To...

When u run DBCC OPENTRAN, your result should be displayed as following:

Where the Bold one is ur SPID

Transaction information for database 'master'.

Oldest active transaction:

SPID (server process ID) :...

Do a search on ur computer by filename tnsnames.ora, u will find "SERVICE_NAME" in there

DBCC OPENTRAN also gives u SPID. U can find that query using following

[Code]

DECLARE @HANDLE BINARY(20)

SELECT @HANDLE = sql_handle from sys.sysprocesses where spid = (yourSPID)

SELECT text FROM ::fn_get_sql(@handle)

[/code]

DBCC OPENTRAN also gives u SPID. U can find that query using following

[Code]

DECLARE @HANDLE BINARY(20)

SELECT @HANDLE = sql_handle from sys.sysprocesses where spid = (yourSPID)

SELECT text FROM ::fn_get_sql(@handle)

[\code]

Like SQLDBA had said before, there r transactions in ur database that need that kind of log space to perform actions. Maybe u have long running queries in ur server.

I would say for one time purposes, Import/Export wizard

doug turner (5/21/2009)

---

Thanks for the replies, folks. I've watched this log file grow from 1.4Gb to to 1.9Gb in about 2 hrs. So, if I change it to...

1)You can get the service name from your .ORA file (Where ever ur Oracle installation folder is) or if click on ur if u click on databases on ur enterprisemanager...

1)Taking Log Backups at regular intervals.: After...