Questão 676936

Task

Description

Time (mins)

Complexity (steps)

SQL

Server

Oracle

SQL

Server

Oracle

Installation and Simple “Out-of-Box” Setup Tasks

1

Install db / software / out-of-box setup

12.7

20.2

5

2

2

Create 2nd database server / instance

13.2

6.5

6

3

3

Setup proactive monitoring

1

0.5

2

1

Category Sub-Total

26.9

27.2

13

6

% difference -- (SS - Oracle) / SS^*

-1%

54%

DBA Workday Savings

0%

3%

Day-to-Day Datasbas e Administration Tasks

4

Create user with roles, privileges

0.7

0.7

1

1

5

Create tablespace / filegroup

0.8

0.5

2

1

6

Add space to database

0.5

0.5

1

1

7

Create table

0.5

0.7

1

1

8

Create index

0.5

0.5

1

1

9

Reclaim space due to fragmented data

3.7

2

3

2

10

Load data from text file

3.5

4.3

2

4

Category Sub-Total

10.2

9.2

11

11

% difference -- (SS - Oracle) /SS^*

10%

0%

DBA Workday Savings

3%

0%

Backup and Recover Tasks

11

Configure and perform full backup

3.2

0

3

0

12

Recover dropped table

6.3

0.3

7

2

13

Recover data file

6.8

7.7

1

1

14

Recover from erroneous transaction

6.3

3.3

7

5

Category Sub-Total

22.6

11.3

18

8

% difference -- (SS - Oracle) / SS^*

50%

56%

DBA Worday Savings

7%

8%

Performance Diagnostics and Tuning Tasks

15

Diagnose performance problem

12

2

3

1

16

Tune resource - intensive SQL

10

2

5

2

17

Tune memory

0

1.3

0

2

Category Sub-Total

22

5.3

8

5

% difference -- (SS - Oracle) / SS^*

76%

38%

DBA Workday Savings

20%

10%

Overall Total

81.7

53

50

30

% difference -- (SS - Oracle) /SS*

35%

40%

Total DBA Workday Savings

30%

20%