I am working on a project that requires me to get the name of the program during the logon process to the database.
“What an ideal place for a logon trigger!”, I said to myself.
I thought the task would be quite simple, just get the SYS_CONTEXT(’USERENV’,'SESSIONID’) and use that to query v$session. I know that v$session.audsid is not unique as the background processes are “0″ while other
We were delighted to see so many people turn up for our Open World session - Inside the 11g Optimizer - so early on Tuesday morning! A lot of people have been asking where they can find more information on the topics covered especially the demos that w…
One of the new things that shipped with the OBIEE 10.1.3.4 release was a new set of sample data, and a set of reports and dashboards that show off the more advanced features of OBIEE. If you download and install OBIEE now, this is the sample set of data and reports that you get instead [...]
I just downloaded and installed osdm
Have a look at my first screen of the ERD generated from my Scott schema
addthis_url = ‘http%3A%2F%2Flaurentschneider.com%2Fwordpress%2F2008%2F10%2Foracle-sql-developer-data-modeling.html’;
addthis_title = ‘Oracle+SQL+Developer+Data+Modeling’;
addthis_pub = ”;
I received an email a litle while ago with an unusual problem. It said:
“One of the jobs which used to take more than one hour to complete is now completing in less than 10 minutes. Neither the application developer nor we (the DBA’s) made *any* changes in the environment/code/database. I can’t work out why [...]
I recently spent a rather pleasant day at the scottish conference of the ukoug. This was held at the Radisson SAS Hotel just by the central rail station and split into a number of streams, from management through to dba. The organisation of the event was excellent, particularly given the fact that some of the infrastructure for various exhibitors didn’t actually arrive until about 3 in the morning of the day of the event.
I was there primarily to give one of my newer presentations Is Oracle Smarter than Your DBA?, which isn’t actually intended as a snub to your DBA team, but rather a plea for more traditional dbas to consider smartly using the automation features, and enterprise management offering from Oracle to reduce the amount of time spent in mundane routine checks and actions, so that the expensive and well trained brains of your DBAs can be devoted to high value actvities, for example design advice, rather than easily automated maintenance - for example adding datafiles. I’ll also be giving this presentation, but hopefully in a much more polished manner at the annual conference in Birmingham. The current version is shown below (may take some time to load.)
So, I’m speaking at the Communities Exchange conference in San Jose today, filling in for Paul. It’s been a bit of a whirlwind since he announced last week that he couldn’t make it. Hence the lack of content here. Anyway, looks to be an interesting conference, only 45 attendees, small on purpose. I hope to [...]
What is Cloud Computing and why is it such a big deal? Lewis will be giving a demo of Oracle in the cloud. He will show you how to sign up for your own Amazon AWS account and how to run an Oracle instance in the cloud.
What is Cloud Computing and why is it such a big deal? Lewis will be giving a demo of Oracle in the cloud. He will show you how to sign up for your own Amazon AWS account and how to run an Oracle instance in the cloud.
My last post might have left people with a negative view of the Gold Coast, so I hope this post goes some what to change that. Here is the view from my window.
From 2008_GoldCoast
Here’s a view up the beach.
From 2008_GoldCoast
Here’s a view down the beach.
From 2008_GoldCoast
Pretty awesome…
Cheers
Tim…