helma.vinke's articles:

Items(21) /3 Next >> Last >|

How to create an execution log of SQL statements? 0 35 (9/14/2010 11:00:56 AM) comp.databases.ms-sqlserver Hello everyone, I am looking for a way to store the runtimes of reports or SQL statements, for trend watching. What i need is some identifier (sql_ID or reportname) , start and end time ( with date). A sort of... Helma

Future of Oracle RDBMS? 11 205 (3/21/2010 11:49:36 PM) comp.databases.oracle.server I wonder what your thoughts are about the future of the Oracle RDBMS. I read a lot of sentiment on the web against Oracle - and I see that several of my coworkers are affected too. Reasons are for example: ... Helma

A modern DBA is mentored by a database. 12 30 (9/2/2009 9:58:42 AM) comp.databases.oracle.server Quote: Oracle continued its focus on improving productivity for database administrators in Release 2, according to Townsend, by adding a new compression "advisor" that tells people how much storage they can sa... Helma

Death of the DBA 56 40 (8/19/2009 12:14:13 PM) comp.databases.oracle.server What the biggest threat for the Oracle DBA? ... Helma

Business Objects performance 11 23 (7/8/2009 9:17:16 AM) comp.databases.oracle.server Greetings, I need to improve the performance of Business Objects reports. Whenever I look when the database is on it knees there is a B.O. report running which causes it. For trendanalysis and tuningsimpact, ... Helma

What tools do you use for healthchecking? 10 32 (2/17/2009 10:47:28 AM) comp.databases.oracle.server Hi, For the earlymorning check, I am working with self made scripts here that run overnight and check for things like space in the database, security, backup ran ok, duplicates to testenvironments, errorlogche... Helma

formula for OPTIMIZER_INDEX_COST_ADJ 6 29 (12/11/2008 3:12:48 PM) comp.databases.oracle.server Hello *, I am now looking at setting the optimizer_index_cost_adj. I read that a nice starting point would be to look at the ratio of the dbfile sequential read vs the scattered read (see http://www.evdbt.com/... Helma

Crash recovery after shutdown immediate? 5 31 (12/9/2008 9:05:47 AM) comp.databases.oracle.server Hello *, Odd problem i had after i had shut down the database (immediate) and made a media copy. After restoring and opening with resetlogs, the database stated it wanted a recovery. After i did a recover unti... Helma

how to cast ORA-22905 away? 2 55 (12/8/2008 1:41:13 PM) comp.databases.oracle.server SQL> SELECT * FROM TABLE(dbms_xplan.display ('PLAN_TABLE','p10','BASIC')); SELECT * FROM TABLE(dbms_xplan.display('PLAN_TABLE','p10','BASIC')) * ERROR at line 1: ORA-22905: cannot access rows fro... Helma

problem creating tracefile level12 5 30 (11/24/2008 4:31:56 PM) comp.databases.oracle.server hello everyone, I'm trying to create a level 12 trace for a surtain process. After finding out the sid and serial, i try: exec dbms_system.set_ev (si=>19, se=>1423,ev=>10046,le=12,nm=>NULL) or the above with... Helma

helma.vinke's replies:

Items(62) /7 Next >> Last >|

How to Install ASM on a Linux single HDD PC? 6 66 (5/19/2009 8:05:44 AM) comp.databases.oracle.server Hi all Is there any tutorials about install Oracle 10g ASM on a Redhat Linux PC with only one harddisk. I want the details with installation commands. Thank you. Jia Lu ... Roka100 (103)

how can i eliminate burleson's stuff from google search results? 32 32 (5/20/2009 4:40:38 AM) comp.databases.oracle.server All, posts from dba-oracle.com tend to rank relatively high in google search. is there some setting I can use to eliminate those from the result set? thanks! ... spampail (1)

Business Objects performance 11 23 (7/8/2009 9:17:16 AM) comp.databases.oracle.server Greetings, I need to improve the performance of Business Objects reports. Whenever I look when the database is on it knees there is a B.O. report running which causes it. For trendanalysis and tuningsimpact, ... helma.vinke (125)

problem with get data statement 1 40 (7/9/2009 2:01:19 PM) comp.databases.oracle.server Hi everyone, I am having a hard time running a get data statement in SPSS. It appears that there could be a problem with the SQL driver. I am clueless as to how to approach this. The syntax and error message a... elodie.gillain (23)

Newbie: 10g or 11g? 2 42 (7/24/2009 9:28:16 PM) comp.databases.oracle.server Hello everyone, Reading through everyone's posts I want to first thank you for what I've learned already. I'm hoping someone might have an opinion about where to start with certification. Would you suggest st... russkiel (1)

ASSM bug: slow INSERT after uncomitted DELETE 34 22 (8/7/2009 10:35:46 AM) comp.databases.oracle.server In my previous post I mentioned ASSM bug (present in 10.2.0.4) that makes single-row INSERT extremely slow when table contains large uncomitted DELETE. Here is the test case: Tests were run on AIX 5.3 (64-bit)... ca111026 (28)

Does everyone hate DBConsole as much as me? (rant) 6 42 (8/18/2009 3:29:46 PM) comp.databases.oracle.server I don't rant often, but I have to vent. IMHO the dbconsole is a piece of crapware and I'm really pissed that they replaced the at-least-useable java based Enterprise Manager with it. It seems that I spend 1/2... gs (80)

Collecting statistics for large established database 5 31 (8/19/2009 11:25:31 AM) comp.databases.oracle.server Let's say we have a relatively large database (2 TB or more). It is being used by an application that went live more than 3 years ago, so historic (transactional) tables contain more than 1000 days worth of dat... vsevolod.afanassiev (47)

Death of the DBA 56 40 (8/19/2009 12:14:13 PM) comp.databases.oracle.server What the biggest threat for the Oracle DBA? ... helma.vinke (125)

A modern DBA is mentored by a database. 12 30 (9/2/2009 9:58:42 AM) comp.databases.oracle.server Quote: Oracle continued its focus on improving productivity for database administrators in Release 2, according to Townsend, by adding a new compression "advisor" that tells people how much storage they can sa... helma.vinke (125)