How would you determine the time zone under which a database
was operating?
Answer Posted / daid kumar
select * from V$NLS_Parameters
it show the Time Zone Format
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
. I have my backup RMAN script called "backup_rman.sh". I am on the target database. My catalog username/password is rman/rman. My catalog db is called rman. How would you run this shell script from the o/s such that it would run as a background process?
how can you generate profile of pl/sql applications to identify performance bottlenecks?
If you are given access to a sql server, how do you find if the sql instance is a named instance or a default instance? : sql server DBA
internal architecture
what are the differences of where and if in SAS?
what is a user-defined lock?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
how can you record information about current session?
What would you do with an "in-doubt" distributed transaction?
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
what is the diffrence between core dba and apps dba?
What is the difference between clustered and non-clustered index? : sql server DBA
what is the use of ocr?
what is ora 24313?what is the procedure to exclude that error?
What are the differences in clustering in sql server 2005 and 2008 or 2008 r2? : sql server DBA