Home » RDBMS Server » Server Administration » Questions..?
Questions..? [message #180466] Mon, 03 July 2006 12:52 Go to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
hi,

i had an interview and they asked some questions which i dont have...

can u plz answer those..

1.what is the significance of cost and card in explain plan..?
2.when the database is in shared server , how to configure RMAN..?
3.what is Opatch and its use..?

plz help..

[Updated on: Mon, 03 July 2006 12:53]

Report message to a moderator

Re: Questions..? [message #180467 is a reply to message #180466] Mon, 03 July 2006 13:04 Go to previous messageGo to next message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
Questions 1 and 3: Please search the forum. Answered many times.
Question 2: No surprise. Documentation has very specific entries for this.

http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96566/rcmconfg.htm#450732
Re: Questions..? [message #180468 is a reply to message #180467] Mon, 03 July 2006 13:10 Go to previous messageGo to next message
balavignesh
Messages: 180
Registered: March 2005
Senior Member
Plz give the links for the answers for the questions 1 and 3..

i did nt get it from the forums
Re: Questions..? [message #180470 is a reply to message #180468] Mon, 03 July 2006 13:21 Go to previous message
Mahesh Rajendran
Messages: 10708
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/ex_plan.htm#838
http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96533/ex_plan.htm#17522

	
COST
Cost of the operation as estimated by the optimizer's cost-based
 approach. For statements that use the rule-based approach, this 
column is null. Cost is not determined for table access 
operations. The value of this column does not have any particular
 unit of measurement; it is merely a weighted value used to 
compare costs of execution plans. The value of this column is a 
function of the CPU_COST and IO_COST columns.

CARDINALITY
Estimate by the cost-based approach of the number of rows accessed by the operation.

[Updated on: Mon, 03 July 2006 13:22]

Report message to a moderator

Previous Topic: how to copy a schema
Next Topic: oracle 10g installation problem
Goto Forum:
  


Current Time: Sun Jan 26 15:45:04 CST 2025