Home » RDBMS Server » Server Administration » Oracle Question
Oracle Question [message #59639] Wed, 10 December 2003 23:48 Go to next message
harish jain
Messages: 3
Registered: December 2003
Junior Member
1. What is the difference between UGA and PGA?
2. What is the size of Control file and which initialization parameter indicates it?
3. Which of the index type either unique or non-unique
first sort on the data and then on ROWID?
4. What is the format of ROWID?

Report message to a moderator

Re: Oracle Question [message #59644 is a reply to message #59639] Thu, 11 December 2003 05:10 Go to previous messageGo to next message
Thiru
Messages: 1089
Registered: May 2002
Senior Member
1.UGA is part of PGA for dedicated server processes.The fixed part of UGA resides in Shared pool and the variable part resides in large pool,if present , otherwise in the shared pool of the SGA.

2. You can get the size of the controlfile from the OS.Also see http://www.orafaq.net/msgboard/server/messages/21134.htm for info about control_file_record_keep_time.

3.In case of non-unique indexes(ie where a key value has multiple entries), the entries are stored in the leaf blocks in the ROWID order.Also when returning multiple rows with identical value,the rows are sorted in ascending order of ROWID. Default sorting order is (key,rowid)

4.http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96524/c13datyp.htm#6538

-Thiru

Report message to a moderator

Re: Oracle Question [message #60960 is a reply to message #59639] Wed, 17 March 2004 01:18 Go to previous message
jitendra
Messages: 11
Registered: January 2002
Junior Member
Dear
i want to data conversion Tally to oracle . My data in Tally software but i want use D2k/oracle ERP .i need a data of tally .How can transfer data tally to oracle

Report message to a moderator

Previous Topic: LOG_ARCHIVE_MIN_SUCCEED_DEST
Next Topic: SQLNET.ora
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 12:40:51 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.