How would you determine how much sort space is used by a user session? - The V$SORT_USAGE shows the active sorts in the database; it shows the space used, username, SQL address, and hash value. It also provides the number of EXTENTS and number of BLOCKS used by each sort session, and the username. The V$SORT can be joined with V$SESSION or V$SQL to obtain more information on the session or the SQL statement causing the sort.

CoolInterview.com - World's Largest Collection of Interview Questions & Answers, FAQs, queries, sample papers, exam papers, dumps, what, why, how, where, when questions

OneStopTesting.com - Testing EBooks, Tutorials, Articles, Jobs, Training Institutes etc.
OneStopGate.com - Gate EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopMBA.com - MBA EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopIAS.com - IAS EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopSAP.com - SAP EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.
OneStopGRE.com - of GRE EBooks, Tutorials, Articles, FAQs, Jobs, Training Institutes etc.

Sponsored Links

Interview Questions

INTERVIEW QUESTIONS

ORACLE

DETAILS

Question: How would you determine how much sort space is used by a user session?

Answer:
The V$SORT_USAGE shows the active sorts in the database; it shows the space used, username, SQL address, and hash value. It also provides the number of EXTENTS and number of BLOCKS used by each sort session, and the username. The V$SORT can be joined with V$SESSION or V$SQL to obtain more information on the session or the SQL statement causing the sort.

Category	Oracle Interview Questions & Answers - Exam Mode / Learning Mode
Rating	(0.2) By 8472 users
Added on	7/7/2010
Views	68538
Rate it!

Question: How would you determine how much sort space is used by a user session?

Answer:

The V$SORT_USAGE shows the active sorts in the database; it shows the space used, username, SQL address, and hash value. It also provides the number of EXTENTS and number of BLOCKS used by each sort session, and the username. The V$SORT can be joined with V$SESSION or V$SQL to obtain more information on the session or the SQL statement causing the sort.
Source: CoolInterview.com

If you have the better answer, then send it to us. We will display your answer after the approval.

Rules to Post Answers in CoolInterview.com:-

There should not be any Spelling Mistakes.

There should not be any Gramatical Errors.

Answers must not contain any bad words.

Answers should not be the repeat of same answer, already approved.

Answer should be complete in itself.

	Related Questions	View Answer
	Which parameter specified in the DEFAULT STORAGE clause of CREATE TABLESPACE cannot be altered after creating the tablespace?	View Answer
	What are the recommended INITIAL and NEXT values for a temporary tablespace, to reduce fragmentation?	View Answer
	Which statement is true regarding the SYSTEM tablespace? A. Can be me made read only. B. Can be offline. T C. Data files can be renamed. D. Data files cannot be resized	View Answer
	14. Which statement is false? A. Dictionary-managed temporary tablespace can be made permanent. B. The size of the locally managed temporary tablespace file cannot be changed. C. Once created, the extent management of a tablespace cannot be altered. D. A locally managed permanent tablespace cannot be made temporary.	View Answer
	13. The database block size is 4KB. You created a tablespace using the following command. CREATE TABLESPACE USER_DATA DATAFILE ‘C:/DATA01.DBF’; If you create an object in the database without specifying any storage parameters, what will be the size of the third extent that belongs to the object?	View Answer
	Which command is used to enable the auto-extensible feature for a file, if the file is already part of a tablespace?	View Answer
	How would you drop a tablespace if the tablespace were not empty?	View Answer
	Which operation is permitted on a read – only tablespace?	View Answer
	When does the SMON process automatically coalesce the tablespaces?	View Answer
	Create a statement that will add a member /logs/redo22.log to log file group 2.	View Answer
	Which parameter is used to limit the number of dirty buffers in the buffer cache, thereby limiting the time required for instance recovery?	View Answer
	List the steps needed to rename a redo log file.	View Answer
	If you need to have your archive log files named with the log sequence numbers as arch_0000001, arch_0000002, and so on (zero filled, fixed width), what should be the value of the LOG_ARCHIVE_FORMAT parameter?	View Answer
	Querying which view will show whether automatic archiving is enabled?	View Answer
	What packages are associated with the LogMiner utility?	View Answer
	Which two parameters cannot be used together to specify the archive destination?	View Answer
	What happens if you issue the following command? ALTER DATABASE ADD LOGFILE (‘/logs/file1’ REUSE, ‘/logs/file2’ REUSE)	View Answer
	If you have two redo log groups with four members each, how many disks does Oracle recommend to keep the redo log files?	View Answer
	What are the valid status codes in the V$LOGFILE view?	View Answer
	How many ARCn processes can be associated with an instance?	View Answer

Please Note: We keep on updating better answers to this site. In case you are looking for Jobs, Pls Click Here Vyoms.com - Best Freshers & Experienced Jobs Website.

View All Oracle Interview Questions & Answers - Exam Mode / Learning Mode