What column differentiates the V$ views to the GV$ views and
how?
Answer Posted / 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 |
Post New Answer View All Answers
How to start SQL Server in minimal configuration mode?
Typically, where is the conventional directory structure chosen for Oracle binaries to reside?
What the different topologies in which replication can be configured? : sql server DBA
Oracle client is not able to connect to Oracle server although tnsnames.ora file has valid enteries. Oracle error message is “ cannot resolve net service name”. Mention any three reasons.
suppose you want to audit specific activities on sensitive data. How can you achieve that?
Does transparent data encryption provide encryption when transmitting data across network? : sql server DBA
how can you process messages in order asynchronously?
What are the different types of indexes available in sql server? : sql server DBA
what are the differences of where and if in SAS?
I have A,B,C servers.i want to 3 servers jobs move to D server(target server)..how? note: i said that take the backup of msdb and restore to the target server..he said while restoring jobs replaced. what is the solution
Where would you look for errors from the database engine?
What are the high-availability solutions in sql server and differentiate them briefly? : sql server DBA
List out some of the requirements to setup a sql server failover cluster.? : sql server DBA
Define the SGA and: How you would configure SGA for a mid-sized OLTP environment? What is involved in tuning the SGA?
which background process invoke at the time of upgradation tell me???