Home
About Me
Step by Step My Oracle Guide
Finny's Oracle Blog
My experience, findings and thoughts in my daily work with Oracle products..
Stay updated via RSS
Certification
Categories
Basics
(1)
Day to day Activities
(5)
DBA Useful Scripts
(20)
RMAN Backup and Recovery
(4)
Step by Step My Oracle Guide
(6)
Blog Stats
95,870 hits
Recent Posts
Duplicating Database using RMAN:-
To Find table has any mview dependent
To find the index associated with table
Drop and Recreate Online Redolog File in oracle
Oracle database Architecture
Recent Comments
Sunny on
How to kill oracle data pump…
Mukesh on
How to kill oracle data pump…
Roberto Sánchez
on
How to kill oracle data pump…
Roberto Sánchez
on
How to kill oracle data pump…
sudheer on
Steps for Cloning Oracle datab…
Archives
March 2020
August 2016
May 2015
June 2014
May 2014
October 2013
July 2013
June 2013
May 2013
April 2013
March 2013
Calender
April 2013
M
T
W
T
F
S
S
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
« Mar
May »
Meta
Register
Log in
Entries feed
Comments feed
WordPress.com
Query to count failed log in attempts
Posted: April 3, 2013 in
DBA Useful Scripts
Tags:
failed login
,
failed login attempts
,
FAILED_LOGIN_ATTEMPTS
,
lcount
,
oracle
,
profile
0
— to count failed log in attempts:
SELECT name, lcount FROM user$ WHERE lcount <> 0;
Share this:
Twitter
Facebook
Like
Loading...
Related
Leave a comment
Cancel reply
Δ
Script to extract the Tablespace create script from your Database
Script to extract create users script from the database for all the users
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here:
Cookie Policy
Comment
Reblog
Subscribe
Subscribed
Finny's Oracle Blog
Sign me up
Already have a WordPress.com account?
Log in now.
Finny's Oracle Blog
Customize
Subscribe
Subscribed
Sign up
Log in
Copy shortlink
Report this content
View post in Reader
Manage subscriptions
Collapse this bar
%d