Problem solve Get help with specific problems with your technologies, process and projects.

Log file to check WAN/LAN use and checking server hard disks

Though these questions are not directly related to database, they are important to databases.

1. I want to generate a log file to know which users(WAN & LAN) logged in and when. Also, I want to know what they did? Can you suggest a script?

2. I want to check my server hard disks. Is there anything that is the counterpart of Windows Scandisk?
The only command I know of to determine who is logged on is the "who -u" command. To determine who is logged on to the Oracle database, who can use the following sql: select s.sid, s.serial#, s.osuser, s.machine, s.schemaname, s.type, p.spid from v$session s, v$process p where

s.paddr = p.addr and
s.type != 'BACKGROUND' and
s.osuser is not null
order by s.sid, s.osuser, s.process;

To determine what they did, from the UNIX or database level, you will have to turn on auditing.

To check disks on unix you use the fdisk command. Check the man pages for the appropriate flags.

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.