Database Administration (MOSC)

MOSC Banner

User logon trigger

edited Nov 21, 2011 5:42AM in Database Administration (MOSC) 3 comments

I found the note 454088.1 on this site for create logon trigger and the log table. I do have one question though.

The create table statement as follows doesn't seem to have a primary key or unique field. Thus, cannot have indexes.

CREATE TABLE LOGONLOG(os_user varchar2(30),
user_name varchar2(30),
logon_time date,
session_user varchar2(30),
ip_address varchar2(15),
program varchar2(30));

If I were to query this table later on, will it generate lots of overhead hence jeopardize the performance of database?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center