Teradata Forums / Teradata / Teradata Database / Is there any query which will tell me..... / Latest PostsInstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 15:37:34 GMT20RE: Is there any query which will tell me.....http://www.teradata.com/teradataforum/Topic11873-9-1.aspxthey are in the view session.Mon, 16 Jun 2008 10:54:08 GMTywjcjjRE: Is there any query which will tell me.....http://www.teradata.com/teradataforum/Topic11873-9-1.aspxhow come we dont have qrylog and qrylogsql tables? We are using Teradata V2R5. We have table call DBQLogTbl, but the data is not as current time. It may have one day delay. Teradata manager can see all the current running sessions.Mon, 16 Jun 2008 10:28:39 GMTywjcjjRE: Is there any query which will tell me.....http://www.teradata.com/teradataforum/Topic11873-9-1.aspxIn the like clause pass the databaseName.TableNameEg.: '%DatabaseName.TableName%'Mon, 16 Jun 2008 05:56:39 GMTMeemRE: Is there any query which will tell me.....http://www.teradata.com/teradataforum/Topic11873-9-1.aspxTry this...SELECT *FROM (SELECT QueryID, UserName FROM DBC.qrylog) QL, (SELECT QueryID, SQLTextInfo FROM DBC.QrylogSql WHERE SQLTextInfo like ' ') QLSWHEREQL.QueryId= QLS.QueryId;Mon, 16 Jun 2008 05:53:10 GMTMeemIs there any query which will tell me.....http://www.teradata.com/teradataforum/Topic11873-9-1.aspxIs there any query which will tell me who all are using a particular table?Suppose i am inserting into a table A and someone else is selecting data from A at the same time .Can i get the information who all are accessing that table(here A)Mon, 16 Jun 2008 02:42:39 GMTprakhar