top button
Flag Notify
    Connect to us
      Site Registration

Site Registration

Do we have any system table in oracle where log on session is maintained for user

+5 votes
359 views
Do we have any system table in oracle where log on session is maintained for user
posted Jan 4, 2014 by Neeraj Pandey

Share this question
Facebook Share Button Twitter Share Button LinkedIn Share Button

1 Answer

0 votes

I believe you are looking for the currently loggedin user into Oracle database.

select distinct osuser, username from v$session;

Try the following link for more detail
http://arjudba.blogspot.in/2008/05/how-to-find-user-who-is-connected-to.html

answer Jan 5, 2014 by Luv Kumar
Similar Questions
+1 vote

Do we have any users of Php say 5.6 on a FreeBSD 10.3 system installed from ports?

If so, can you get in touch with me? I'm trying to install pear and not having much luck, getting an error about a missing peclcmd.php file and a zlib extension that make is complaining about but which is in my php install.

+2 votes

I want to genarate a csv report from the data of a table, can i do this without creating a directory.

0 votes

The system log (/var/log/messages) of a CentOS 7.2 system has frequently-repeated message line pairs like:

Jul 18 14:00:01 localhost systemd: Started Session 307 of user root.
Jul 18 14:00:01 localhost systemd: Starting Session 307 of user root.

where the session number increases each time.

Looking around on this, e.g. Red Hat Bugzilla bug 727315, it looks like it's when crond starts a task; it looks like it might be fixed - I would think that would be in CentOS but don't know how to find/compare the Fedora and CentOS systemd versions to know for sure.

I found a post on a workaround - in /etc/systemd/system.conf to change the line:

#LogLevel=info

to:

LogLevel=notice

I did that and rebooted, and it has stopped the messages.

I'm worried though that this may have knocked out something of actual interest from the syslog.

So my question is, is there a better way? A way that info messages could go to some other log, or better yet, a way that those particular "session" messages, and only those, could go to some other log or be filtered out?

...