FazBrowse GitHub Viewer
|
Trending
|
URL:
|
Home
Tools:
[Download Repo ZIP]
[View Raw Code]
[Original HTTPS Page]
Oracle-Database-Scripts/failover_stats.sql at main · co360/Oracle-Database-Scripts · GitHub
Uh oh!
There was an error while loading.
Please reload this page
.
co360
/
Oracle-Database-Scripts
Public
forked from
fatdba/Oracle-Database-Scripts
Notifications
You must be signed in to change notification settings
Fork
0
Star
0
Code
Pull requests
0
Actions
Projects
Security and quality
0
Insights
Additional navigation options
Code
Pull requests
Actions
Projects
Security and quality
Insights
Expand file tree
Breadcrumbs
Oracle-Database-Scripts
/
failover_stats.sql
Copy path
More file actions
More file actions
Latest commit
History
History
History
11 lines (10 loc) · 400 Bytes
Breadcrumbs
Oracle-Database-Scripts
/
failover_stats.sql
Copy path
File metadata and controls
11 lines (10 loc) · 400 Bytes
Raw
Copy raw file
Download raw file
Open symbols panel
Edit and raw actions
1
2
3
4
5
6
7
8
9
10
11
set
lines
140
col fo_time format a20
col fo_pdt format a20
col fo_reason format a80
col min_ago format
9999
select
LAST_FAILOVER_TIME fo_time
,to_char(new_time(to_date(LAST_FAILOVER_TIME,
'
MM/DD/YYYY HH24:MI:SS
'
),
'
GMT
'
,
'
PDT
'
),
'
MM/DD/YYY HH24:MI:SS
'
) fo_pdt
,(
sysdate
-
to_date(LAST_FAILOVER_TIME,
'
MM/DD/YYYY HH24:MI:SS
'
))
*
24
*
60
min_ago
,LAST_FAILOVER_REASON fo_reason
from
V$FS_FAILOVER_STATS;
Back
|
FazBrowse Home
|
New Git URL