Helpforce provides free 24/7 online technical support

Yellowfin is set to redefine what BI users and IT Departments willexpect from Business Intelligence vendors Leading Business Intelligence software provider, Yellowfin, todayannounced it would be launching its milestone release on May 5th,2010.
Yellowfin 5.0 is set to redefine what BI users and IT Departments willexpect from BI vendors. With faster deployment and faster analytics,Yellowfin 5.0 is set to establish new BI standards, all the extrafunctionality is integrated and three simple steps a.... read more

Greetings All, I'm struggling with this one.
I'm trying to structure a query for MySQL 3.23.
SELECT * FROM jos_liveshoutbox_temp WHERE id > 20 AND name=me ORname=cathy What I need to get is * WHERE id's > 20 from me and from cathy.
What I'm getting from the above query is only * from cathy.
It would be great if you could work MySQL queries like math: SELECT * FROM jos_liveshoutbox_temp WHERE id > 21 AND (name=cathyOR name=client) Does anybody have any solution? I'.... read more

Hello, You are welcome to test a new great tool for Oracle spClientMonitor.
spClientMonitor provides Oracle database administrators and Oracletuning experts with a convenient and powerful framework to monitor andtrace SQL performance of end users applications accessing Oracledatabases through the TCP/IP network. spClientMonitor enables you towatch the SQL performance from the end-user or target applicationpoint of view. This approach allows you to quickly resolve SQL relatedperformance issues wh.... read more

Hi all, I want to measure oracle (11i) on a regular base doing the sametransaction (inquiry on the same item or something like it) every fewminutes.
Is there any tool to automate and reproduce transactions on a screenmeasuring the start and end time of each transaction? I had one once (veeeery long time ago) on 10.7 but want to monitor ona 11i platform now.
Many thanks in advance.
Ronald.

Hello all - I am beginning to get into transactions and am a little stuck. I haveread the manuals online, but haven't been able to wrap my head aroundthem. I haven't found a good example of what I'm trying to do.
I have some PHP code where I insert a row into a parent table, andthen insert an arbitrary number of rows into the child table. If Ican't insert all of the child rows, I want to rollback all of theinserts. The issues I'm having: 1. How to get the id of the new row .... read more

My linux box(rhel as 4) where oracle instance is located is showingnearly 100 memory utilization (using top command). Changing resourcelimit using 'ulimit' is not showing any significant improvements.Howcan i fix the upper limit of memory utilization.Oracle version is9.2.0.5 Thanks and regards

Hi All, I have a query as below Update AlmEvtTbl SET State = 2 where AlmEvtId in (SELECT/*+ FIRST_ROWS */ AlmEvtSysPeView.AlmEvtId FROM AlmEvtSysPeView where(AlmEvtSysPeView.ParentCustId=0 ANDAlmEvtSysPeView.TimeStamp >= TO_DATE('2004-12-06 18:30:00', 'YYYY-MM-DDHH24:MI:SS')and AlmEvtSysPeView.TimeStamp <= TO_DATE('2004-12-09 18:29:59','YYYY-MM-DD HH24:MI:SS') ANDAlmEvtSysPeView.State <> 3)AND ROWNUM < 2000 If I remove the FIRST_ROWS hint from the .... read more

Strange question. But can somebody shed some light on the internalworkings of an unique index? 1. Insert 1 row into a table with an unique index on it.
2. Old data and index blocks that the insert statement touched aremove to rollback segment.
3. ORALCE enforces the uniqueness due to the index. How? By doing afull scaning on the table column and the index?4. Insert another row into the table. How does ORACLE enforce theuniqueness? ORACLE does not need to look up the rollback segment tocheck for .... read more

Can someone explain why the following query will return 80 records: SELECT DISTINCT c.caseid FROM cases c LEFT JOIN casespecialty cs ON c.caseid = cs.caseid LEFT JOIN examspecialty es ON c.caseid = es.caseid WHERE (cs.uid = 86 OR es.uid = 86) but when c.caseid is wrapped with Count() the query will return 225: SELECT DISTINCT Count(c.caseid) FROM cases c LEFT JOIN casespecialty cs ON c.caseid = cs.caseid LEFT JOIN examspecialty es ON c.caseid = es.caseid WHERE (cs.uid = 86 OR es.uid = 86) The .... read more

Hi, I have a (still theoretical) question.
I'll have two database instances (9.2.0.x) which are used together via database links and distributed transactions. These two databases are no copies but different parts of a product.
How can I ensure synchronous backups? An example: Database A goes down and I restore it. How can I bring the database B into a state, where it is synchron to the restored database A again? Best regards,Peter

Back in the days of Oracle 7 when they used to send you a complete manual set every time you upgraded, or even just requested a patch, the RDBMS manual set was about 30 long ( a foot for the metrically challenged among us.) How long is the 10g manual set? Can you even get a physical set of manuals anymore? For those who can't read a usenet post unless it has a version number in it - 10.2.0.1.

I'm trying to create this table at the command line and get an error: mysql> create table events( -> id INTEGER, -> session_id INTEGER, -> user_id INTEGER, -> when TIMESTAMP, -> eventtype_id INTEGER, -> dataint INTEGER, -> data_id INTEGER -> );ERROR 1064 (42000): You have an error in your SQL syntax; check themanual that corresponds to your MySQL server version for the rightsyntax to use near 'when TIMESTAMP,eventtype_id INTEGER,dataint .... read more

Hi all, I would like to know under what conditions that I(a 4th year undergraduate student at Trinity CollegeDublin, Ireland) student may (or may not) use Oracledatabase products for a degree project? The intended use is for a project which will notcontinue past June 2010. The project will not bedeployed to the public nor commercially and no feesof any sort will be charged to anyone who does useit - use will be restricted to fellow students (testing)and staff (grading).
I would be grateful if a.... read more

Hello, I got a table with timestaps and some data, spanned over years. I canaverage over minutes, hours etc using such an expression (this is for1 hour average) SELECT TIME, AVG( UNCORRECTED ) FROM hourlydata GROUP BY truncate( ( ( TIME_TO_SEC( TIME ) +86400 * TO_DAYS( TIME ) ) / ( 3600 ) ), 0 )ORDER BY TIME but I also need to average across month/ few months and also years,that is, something which has a variable lengths. Please advise me howI could do that in SQL.

Hello guys When installing Oracle, one finds that there are number ofauthorized users in addition to sys, system and scott. what are theirdefault passwords and roles? Thanks in advanceDebashish

eDiscover

Click the logo to go back to the main page

Databases

Search eDiscover

Categories