What column differentiates the V$ views to the GV$ views and
how?
Answers were Sorted based on User's Feedback
Answer / mahesh
GV$ view is a global view of v$. GV$ view contains on extra
column called Inst_ID which indicates the instance ID of
ordered query. This ID is useful for session tracking.
| Is This Answer Correct ? | 16 Yes | 1 No |
Answer / shrinidhi
The INST_ID column which indicates the instance in a RAC environment the information came from.
| Is This Answer Correct ? | 3 Yes | 1 No |
Answer / krishna
GV$ view is a global view of v$. GV$ view contains on extra
column called Inst_ID which indicates the instance ID of
ordered query. This ID is useful for session tracking.
| Is This Answer Correct ? | 0 Yes | 0 No |
I have kept recovery catalog on same target database and taken backup of target DB to disk. deleted the target DB & tried to restore and revoer DB using the backup on disk but it is not possible, how do we restore & recover DB
what r the types of backup?
when we login sql editor using username and password then it says this error "could not resolve service name" then what can we do at client side.( here thing is tnsnames.ora file is ok till yesterday and worked well, but now it giving error.
What are the different types of database compression introduced in sql server 2008? : sql server DBA
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 to copy(migrate) the database one server to another server without using expdp/impdp how it is possible.
what is a crs resource?
How would you begin to troubleshoot an ORA-3113 error?
What is replication? : sql server DBA
what is the purpose of catlaog in oracle rman?
How do you find out from the RMAN catalog if a particular archive log has been backed-up?
How many packages we have in db
Oracle (3259)
SQL Server (4518)
MS Access (429)
MySQL (1402)
Postgre (483)
Sybase (267)
DB Architecture (141)
DB Administration (291)
DB Development (113)
SQL PLSQL (3330)
MongoDB (502)
IBM Informix (50)
Neo4j (82)
InfluxDB (0)
Apache CouchDB (44)
Firebird (5)
Database Management (1411)
Databases AllOther (288)