skip to main
|
skip to sidebar
oracle blog
Friday, June 20, 2008
How to cleanup the FGA log table?
SQL> truncate table fga_log$;
SQL> delete from fga_log$ where timestamp# < sysdate-14;
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Blog Archive
►
2016
(5)
►
July
(5)
►
2012
(2)
►
September
(1)
►
February
(1)
►
2011
(3)
►
December
(1)
►
July
(1)
►
March
(1)
►
2010
(4)
►
November
(1)
►
October
(1)
►
September
(1)
►
June
(1)
►
2009
(8)
►
September
(1)
►
August
(1)
►
July
(1)
►
March
(1)
►
February
(2)
►
January
(2)
▼
2008
(12)
►
July
(1)
▼
June
(1)
How to cleanup the FGA log table?
►
April
(1)
►
March
(4)
►
February
(2)
►
January
(3)
►
2007
(40)
►
December
(2)
►
November
(1)
►
October
(3)
►
September
(3)
►
August
(2)
►
July
(4)
►
June
(4)
►
May
(13)
►
April
(3)
►
February
(2)
►
January
(3)
Labels
advisors
(1)
ajax
(1)
archivelog
(2)
audit
(2)
bfile
(1)
block corruption
(1)
change sid
(1)
control files
(1)
cssd
(1)
cursors
(1)
data pump
(6)
dataguard
(1)
dblinks
(1)
ddl
(3)
dgbroker
(1)
distributed
(1)
execution plan
(3)
export
(1)
fga
(1)
globalization settings
(3)
grants
(1)
grid agent
(1)
invalid objects
(1)
jquery
(1)
killing sessions
(1)
korn
(1)
library cache
(1)
LOB
(1)
lobs
(1)
locks
(3)
materialized views
(1)
migration
(1)
oracle
(64)
oracle 10g
(4)
oracle 11g
(1)
outlines
(1)
parallel query
(1)
perl
(1)
prefetch
(1)
privileges
(2)
rac
(3)
recovery
(1)
rich text editors
(1)
rman
(3)
security
(1)
shared server
(2)
spfile
(2)
sql*loader
(1)
sqlplus
(1)
ssl certificate
(1)
statistics
(3)
tar
(1)
tarantula
(1)
temp tablespaces
(2)
tom kyte book
(1)
tracing sessions
(6)
triggers
(1)
undo
(1)
unix
(2)
users
(1)
useful links
Tanel Poder's blog
Tim Hall's ORACLE-BASE
Jonathan Lewis blog
jQuery - makes DHTML simple
No comments:
Post a Comment