Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What column differentiates the V$ views to the GV$ views and how ?

April 26, 2017column

0

Posted

What column differentiates the V$ views to the GV$ views and how ?

2 Answers

0

Posted

view answer • Give the stages of instance startup to a usable state where normal users may access it.

0

10 Posted

• 17. How would you go about generating an EXPLAIN plan? • 18. How would you go about increasing the buffer cache hit ratio? • 19. Explain an ORA-01555 • 20. Explain the difference between $ORACLE_HOME and $ORACLE_BASE. • 21. How would you determine the time zone under which a database was operating? • 22. Explain the use of setting GLOBAL_NAMES equal to TRUE. • 23. What command would you use to encrypt a PL/SQL application? • 24. Explain the difference between a FUNCTION, PROCEDURE and PACKAGE. • 25. Explain the use of table functions. • 26. Name three advisory statistics you can collect. • 27. Where in the Oracle directory tree structure are audit traces placed? • 28. Explain materialized views and how they are used. • 29. When a user process fails, what background process cleans up after it? • 30. What background process refreshes materialized views? • 31. How would you determine what sessions are connected and what resources they are waiting for? • 32. Describe what redo logs are.