- 14
- 17 164
Oracle database help
Registrace 30. 10. 2017
expdp start stop attach resume job
how to start stop and resume and restart datapump export job
zhlédnutí: 512
Video
database creation 11gR2 using dbca step by step
zhlédnutí 122Před 6 lety
database creation 11gR2 using dbca step by step
11gR2 database software installation step by step
zhlédnutí 20Před 6 lety
11gR2 database software installation step by step
sql query processing in oracle database
zhlédnutí 4,6KPřed 6 lety
sql query processing in oracle database
Lock and Unlock table statistics in Oracle Database
zhlédnutí 1,7KPřed 6 lety
Lock and Unlock table statistics in Oracle Database
oracle sql performance analyzer
zhlédnutí 1,3KPřed 6 lety
compares the performance of the statements in a tuning set before and after a database change.
start and stop rac database
zhlédnutí 2,9KPřed 6 lety
Start and stop RAC 11g database using srvctl utility.
rac database ocr voting disk and olr
zhlédnutí 1,9KPřed 6 lety
Check ocr ,olr and voting disk location Check ocr and olr backup
Good explanation, could you pls share script
Helpful thanks
select MASTER_NODE from v$ges_resource;
This is very good demo on start stop db. Can you post some videos which will guide DBA to see 1. log/alert /error viewing 2. oracle monitoring tool usage (OEM) for db status, performance, error,log, long running qry
I use the following to display errors in the alert log from today. col ORIGINATING_TIMESTAMP for a18 set wrap off set lines 200 select INST_ID, ORIGINATING_TIMESTAMP, MESSAGE_TEXT from V$DIAG_ALERT_EXT where ORIGINATING_TIMESTAMP > sysdate - 1 and substr(ORIGINATING_TIMESTAMP,1,9)=to_char(sysdate,'DD-MON-YY') and message_text not like '%CONNECT_DATA%' and message_text not like '%service_update%' and message_text not like '%* ping *%' and message_text not like '% drop file %' and message_text not like '%ALTER SYSTEM ARCHIVE LOG%' and message_text not like '%RCHIV%' and message_text not like '%rchiv%' -- AND UPPER(message_text)LIKE UPPER('%%') order by ORIGINATING_TIMESTAMP;
Your voice is not audible
Not Up to the mark? Many things are not explained. If you are talking about a technical term in any explanation, You must be explain a brief about that particular thing you said. example You said "If PLAN EXISTS, then Soft Parse". Firstly please explain what plan you are talking about? Second thing you gave examples of dependency check, those examples are just only words. You have to give a proper explanation of those words too! Thank You
definitely agree with this
Nice explanation....keep it up....need more such good videos...
What about 12c not showing using ocssd
This video is really helpful to the new users.Thank you sir
Thank you.. Planning to upload more for AWS and Oracle DBA