what are the roles & resonsibilities of dba in dataware housing



what database activities normal DBA should monitor
and control on dataware housing is it(dataware housing) needs any extra database knowledge
Posted On: Wednesday 7th of November 2012 06:41:07 AM Total Views:  146
View Complete with Replies

RELATED TOPICS OF Oracle PROGRAMMING LANGUAGE




Simulation training for 8i - What are the advantages and/or disadvantages?

Simulation training for Oracle 8i - What are the advantages and/or disadvantages of simulations
VIEWS ON THIS POST

92

Posted on:

Wednesday 7th November 2012
View Replies!

What SQL_TEXTs are using the Temporary TS ?

How can i know, what are the SQL_Texts of the statements that are using the Temporary TS We are using this one: SELECT s.username, u."USER", u.tablespace, u.contents, u.extents, u.blocks, a.sql_text, u.sqladdr, u.sqlhash FROM v$session s, v$sort_usage u, v$sql a WHERE s.SADDR = u.SESSION_ADDR and a.hash_value = u.sqlhash and u.contents = 'TEMPORARY' Is this one right or not Do you have another one (Related to the thread i posted earlier: When the Temporary Tablespace is used )
VIEWS ON THIS POST

114

Posted on:

Wednesday 7th November 2012
View Replies!

What objects are nessasary to analyze

Hi Folks, what objects we have to analyze I mean only analyze tables is enough, or other objects we have to analyze. I am planing to analyze only tables. Is it create any new problems.
VIEWS ON THIS POST

259

Posted on:

Wednesday 7th November 2012
View Replies!

SharePointPortal Server -- oracle web part ????

I am currently doing a project on Microsoft sharePoint Portal Server, which is a Document Management Software from Microsoft. It has various content sources and can also search through RDBMS like Sql and Oralce. Does anyone know how to go about querying through the database and returning the results for search query in SPPS \t\t Also are there any Oralce Web Parts available \t\t thnakx regards ICEMAN
VIEWS ON THIS POST

197

Posted on:

Wednesday 7th November 2012
View Replies!

shared_pool_reserved_min_alloc obselete in 8.1.6???

I'm not sure if the shared_pool_reserved_min_alloc parameter is obseleted in 8.1.6. If anyone knows, please reply. I really appreciate it.
VIEWS ON THIS POST

218

Posted on:

Wednesday 7th November 2012
View Replies!

Sharedpool fragmentation

I used the following query, which has been recomended in metalink. select decode( sign(ksmchsiz - 812), -1, (ksmchsiz - 16) / 4, decode( sign(ksmchsiz - 4012), -1, trunc((ksmchsiz + 11924) / 64), decode( sign(ksmchsiz - 65548), -1, trunc(1/log(ksmchsiz - 11, 2)) + 238, 254 ) ) ) bucket, sum(ksmchsiz) free_space, count(*) free_chunks, trunc(avg(ksmchsiz)) average_size, max(ksmchsiz) biggest from sys.x$ksmsp where inst_id = userenv('Instance') and ksmchcls = 'free' group by decode( sign(ksmchsiz - 812), -1, (ksmchsiz - 16) / 4, decode( sign(ksmchsiz - 4012), -1, trunc((ksmchsiz + 11924) / 64), decode( sign(ksmchsiz - 65548), -1, trunc(1/log(ksmchsiz - 11, 2)) + 238, 254 ) ) ) / Here is the result. BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 6 37840 946 40 40 8 24144 503 48 48 10 31528 563 56 56 12 21760 340 64 64 14 27504 382 72 72 16 30080 376 80 80 18 13640 155 88 88 20 11808 123 96 96 22 44200 425 104 104 24 41664 372 112 112 26 58800 490 120 120 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 28 34048 266 128 128 30 38216 281 136 136 32 56736 394 144 144 34 41344 272 152 152 36 47840 299 160 160 38 61320 365 168 168 40 28688 163 176 176 42 24656 134 184 184 44 31296 163 192 192 46 29000 145 200 200 48 33696 162 208 208 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 50 46872 217 216 216 52 54880 245 224 224 54 40136 173 232 232 56 63600 265 240 240 58 47616 192 248 248 60 52992 207 256 256 62 38544 146 264 264 64 37536 138 272 272 66 56280 201 280 280 68 65952 229 288 288 70 50024 169 296 296 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 72 63232 208 304 304 74 53664 172 312 312 76 55040 172 320 320 78 50512 154 328 328 80 90720 270 336 336 82 47816 139 344 344 84 55968 159 352 352 86 54360 151 360 360 88 49680 135 368 368 90 71440 190 376 376 92 51840 135 384 384 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 94 64288 164 392 392 96 39600 99 400 400 98 57936 142 408 408 100 67808 163 416 416 102 54696 129 424 424 104 1728 4 432 432 106 12320 28 440 440 108 5824 13 448 448 110 912 2 456 456 112 6032 13 464 464 114 1888 4 472 472 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 116 3360 7 480 480 118 6832 14 488 488 120 2480 5 496 496 122 1512 3 504 504 124 2560 5 512 512 126 2600 5 520 520 128 9504 18 528 528 130 3216 6 536 536 132 3808 7 544 544 134 2208 4 552 552 136 3360 6 560 560 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 138 2840 5 568 568 140 4032 7 576 576 142 19272 33 584 584 144 5328 9 592 592 146 3600 6 600 600 148 4256 7 608 608 150 4928 8 616 616 152 8112 13 624 624 154 61304 97 632 632 156 10880 17 640 640 158 11016 17 648 648 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 160 13120 20 656 656 162 16600 25 664 664 164 15456 23 672 672 166 47600 70 680 680 168 15136 22 688 688 170 32016 46 696 696 172 20416 29 704 704 174 25632 36 712 712 176 18720 26 720 720 178 21112 29 728 728 180 22080 30 736 736 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 182 9672 13 744 744 184 3008 4 752 752 186 6080 8 760 760 188 4608 6 768 768 190 2328 3 776 776 192 10976 14 784 784 194 9504 12 792 792 196 15200 19 800 800 198 516312 639 808 808 199 84360 100 843 872 200 128160 142 902 936 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 201 69576 72 966 1000 202 97296 94 1035 1064 203 36336 33 1101 1128 204 47680 41 1162 1192 205 80464 66 1219 1256 206 42688 33 1293 1320 207 48856 36 1357 1384 208 86568 61 1419 1448 209 84440 57 1481 1512 210 57128 37 1544 1576 211 53320 33 1615 1640 BUCKET FREE_SPACE FREE_CHUNKS AVERAGE_SIZE BIGGEST ---------- ---------- ----------- ------------ ---------- 245 5042032 1332 3785 3816 246 5521008 1434 3850 3880 247 7810432 1990 3924 3944 248 7968936 2004 3976 4008 249 11397224 2812 4053 4104 250 310776 75 4143 4992 251 16600 2 8300 8368 150 rows selected. but I can not interpret the same. From the below rsult how to confirm that there is no fragmentation or there is!!! Another question, when I spool, i can not see the command with the result. Shall I have to set any env I want sql commands and output both!!! forgive me for this one - reagards
VIEWS ON THIS POST

86

Posted on:

Wednesday 7th November 2012
View Replies!

Shared Pool Size threshold

Currently the shared pool size is 168 MB and the hit ratio is 78%. Can u advice me on how to increase the shared pool size to arrive >90% hit ratio
VIEWS ON THIS POST

87

Posted on:

Wednesday 7th November 2012
View Replies!

Shared Pool setttings in init file

all.. Oracle 817/Sun 5.8 I changed my Shared pool settings from 4MB to 16MB in OEM. After making the changes, OEM prompted me to restart the Database which i did thru OEM. NExt, i went to Sun Command prompt and opened the init file to see if the values are updated. But init file still has shared_pool_size = 4194304 How do i know if the DB is using 16MB or 4MB ...also..do i have to make the changes again in init file ... I do see 2 init files ...one in $ORACLE_HOME/dbs/cquest/initcquest.ora and other in /opt/oracle/oradata/mnt1/app/oracle/admin/cquest/initcquest.ora.
VIEWS ON THIS POST

145

Posted on:

Wednesday 7th November 2012
View Replies!

Shared Pool cache Hit % ratio!

Hi all! I have a query: 1.How should we tune SHARED_POOL_SIZE cache Hit ratio! What should be the Percentage of cache Hit ratio for SHARED pool. Is there any particular select query for it! 2.Would deleting innumerable Trace files occupying unnecessary disk space create any impact on the Production/development Database! 3.Does configuring SHARED_POOL_SIZE automatically allocates required memory to Data Dictionary cache,Library Cache,Shared Sql Area!
VIEWS ON THIS POST

67

Posted on:

Wednesday 7th November 2012
View Replies!

Shared pool

I had run this query on my database and got the following SQL> select to_number(v$parameter.value)value, v$sgastat.bytes, 2 (v$sgastat.bytes/v$parameter.value)*100 "Percent Free" 3 from v$sgastat,v$parameter 4 where v$sgastat.name = 'free memory' 5 and v$parameter.name = 'shared_pool_size'; Shared Pool Size Free Bytes Percent Free ---------------- ---------------- ------------ 29,000,000 2,878,876 9.92715862 Can someone please assist me with this problem. i am made to believe that the shared pool is small. To what value should I set the shared pool
VIEWS ON THIS POST

69

Posted on:

Wednesday 7th November 2012
View Replies!

Shared pool

How is the data written into Library cache and Dictionary cache Is it the server process \t
VIEWS ON THIS POST

73

Posted on:

Wednesday 7th November 2012
View Replies!

Shared memory realm already exists

Hi Guys, I have created three databases(acc,hacc &tacc)in 9i and it was working fine. When i restarted the machine and try to connect to acc using sqlplus acc/acc@acc it throwing an error 'Shared memory realm already exsts'. Could any help me out pls..
VIEWS ON THIS POST

171

Posted on:

Wednesday 7th November 2012
View Replies!

SGA versus sharedpool

Hi , I am on 10.2.0.4 and I have a quick question to clear out my doubt. when we use SGA_TARGET, we would let Oracle to manage its own memory so we don't need to specify the size for shared_pool, is it correct 1. why from time to time, I have been reading and noticed that sga_target is used and shared_pool is also used and I bit confused. 2. there is a sql statement that was executed over 5 million times over the period of the batch job was ran, it is used bind variable, I wonder if there is anything esle that we can do to make it run faster.
VIEWS ON THIS POST

220

Posted on:

Wednesday 7th November 2012
View Replies!

Where Oracle Errors are Stored ?

Where the Oracle Errors are stored any object from which i can get information of each and every oracle error. Or it is stored in some other format or external file. DBA_ERRORS only stores the current errors for any objects. but i want to get all the oracle error list. Any idea.
VIEWS ON THIS POST

81

Posted on:

Wednesday 7th November 2012
View Replies!

What are the Issues in Migration from oracle 8i to oracle 10g

Can you let me know what are the issues that i face when i migrate from oracle 8i to oracle 10g. I will be very thankful if you give me a list of issues that you faced in your past experience while migrating from 8i to 10g
VIEWS ON THIS POST

133

Posted on:

Wednesday 7th November 2012
View Replies!

Where are those views coming from

Checking Database today , Found lots of view [TABLE_NAME]_BASE [TABLE_NAME]_BPKC [TABLE_NAME]_CONF [TABLE_NAME]_BASE [TABLE_NAME]_LOCK [TABLE_NAME]_PKC [TABLE_NAME]_PKD [TABLE_NAME]1 ..... Where are those views coming from Those views looks like generated by system
VIEWS ON THIS POST

156

Posted on:

Wednesday 7th November 2012
View Replies!

what patches are applied ?

Can one see what patches are applied to Oracle With the Unix "what" command one can see what patches are applied to an executable. The Oracle implementation of what is owhat. The owhat command does not work for HP-UX 11. What command must be used instead
VIEWS ON THIS POST

279

Posted on:

Wednesday 7th November 2012
View Replies!

Transparent Gateway for MS SQL for 9.0.1

Can anyone tell me where I can get this software from I was led to believe it was part of the 9.0.1 CD Pack for Microsoft Windows but it doesnt appear to part of it. Do I have to purchase another piece of software or can I download it from somewhere Anyone know\t
VIEWS ON THIS POST

123

Posted on:

Wednesday 7th November 2012
View Replies!

rman and flash recovery area

We are using RMAN to perform oracle 9i database backups on disk. These backups are then moved to tape susing Tivoli Storage Manager using OS backup. With this approach we are eliminating need to integrate RMAN and TSM as well as additional license cost. Oracle 10g has "Flash Recovery Area(FRA)" to hold recovery related files (e.g. backups, archived logs etc.) on disks. I was wondering whether we will be still able to use our old backup methods with flash recovery area. e.g. if I have 7 day retention period. Day 1: Incr. backup (level 0) + Incr. backup 1(level 1), Backup FRA on tape Day 2: Incr. backup (level 0) + Incr. backup 2(level 1), Backup FRA on tape ........ Day 8: Incr. backup (level 0) + Incr. backup 8(level 1), Backup FRA on tape On Day 8, My Day 1 backup becomes obsolete and removed from fash recovery area to make space for other files. However, I still have OS level backup done using TSM for Day 1. So, If I need to recover my DB as of Day 1, I can restore OS level backup. But where should it be restored (Flash Recovery Area or other file system) how do I tell RMAN to use this backup
VIEWS ON THIS POST

275

Posted on:

Wednesday 7th November 2012
View Replies!

Retention Software

Does anyone know of a software product that can be set up to log into the database and delete old records from the database on a regular schedule. For example, I want records deleted from table a,b, and c that are more then 90 days old. Or I want records deleted out of another database where col1 = ' y' and the record is more then a day old. Is there a software product that can do this automatically
VIEWS ON THIS POST

53

Posted on:

Wednesday 7th November 2012
View Replies!