LVC stands for Live Virtual Class – this is how we call our courses done interactively over the internet. At Oracle University, we have a fine crew of people who take care that the attendees (as well as the instructor, sometimes) are not impacted by technical problems. This can be e.g. connectivity issues, browser incompatibilities, questions how to deal with the learning platform WebEx or which way to choose to access the remote lab (more...)
Description The Average Active Sessions (AAS) metric is a very good indicator of the database activity. This metric represents the number of sessions, either working or waiting for a resource at a specific point in time. Idle sessions are not included in the calculation of this metric. To calculate AAS, we need another metric called [...]
I was troubleshooting a performance problem few days ago. The database the problem was experienced on was recently migrated from Oracle 10.2.0.4 to Oracle 22.214.171.124.
Long story short, the problem was described as performance of a query that scans two or more partitions in a table is much worse compared to combined performances of queries accessing each of the partitions separately.
After a short investigation I narrowed down the (more...)
Here is my experiences with installing Forms and Reports 126.96.36.199.0 on Red Hat 6 (64-bit) using Java 7.
- Download the software
- Prepare the OS
- Install Java
- Patch Java
- Install Weblogic server 10.3.6
- Install the latest Weblogic PSU
- Using WebLogic Server with JDK 7
- Install Forms/Reports version 188.8.131.52.0
- Patch Forms/Reports
- Configure Forms/Reports
- Homes overview
- Verifying the installation
- Missing boot.properties
- Moving Applications home
- Set (more...)
Description This query returns the top 10 sessions from v$active_session_history. The result is ordered by total resources consumed by the session including I/O, WAITS and CPU Be careful, this view is part of the diagnostic pack, you should not query this view if you don’t have license for it. top 10 sessions from v$active_session_history [crayon-5342de6f40853631954834/] [...]
One of my presentations at Collaborate 14 this year revolves around how many different ways there are to monitor Oracle Golden Gate. As I was putting the presentation together, I was listing out the different ways for monitoring. I have covered a few of the ways already in earlier posts. What I want to show you here is how to execute a simple “info all” command and see the results from (more...)
Last week I was lucky enough to be presenting at the UKOUG AIM SIG. There was a decent enough crowd in attendance and there were some really interesting talks and some really good speakers. In particularly I found Chris Lawless speaking on replication a particularly engaging speaker, and Dave Webster really held the audiences attention late in day.
I was giving a presentation on the new features available to you with 12c ASM. The presentation (more...)
GPO (Grupo de Profissionais Oracle) Portal : http://www.profissionaloracle.com.br/gpo
Article link : Oracle Database 12c - What happens during CDB startup if one the PDB has a media problem?
I noticed something for the first time tonight when I was playing around in the Enkitec lab – something that I have been doing wrong for a while. When working in the lab, I often rely on the crsctl command to shut down the entire cluster stack for me. It’s really easy to use “crsctl stop cluster -all” followed by “dcli -l root -g ~/dbs_group /u01/app/184.108.40.206/grid/bin/crsctl stop crs” to get everything down (more...)
If you don't have a Diagnostics / Tuning Pack license the options you have for doing that are quite limited, and the approach, as demonstrated in the tutorial, has several limitations and shortcomings.
Here is the video:
If you want to reproduce or play around with (more...)
At times, just a little idea and support can do just wonders for a very large community. And that’s the same happened this year when I was talking to Murali Vallath about the user-groups and participation of Oracle professionals in India in Oracle related events organized in India by All India Oracle Users Group(AIOUG) (formed and managed by Murali only). As India is such a large country, it’s not possible for everyone to come from (more...)
With the exception of a 5+ hour layover in Amsterdam, the trip home was pretty straight forward. I flew to Amsterdam with Lonneke Dikmans, Ronald Luttikhuizen and Roel Hartman. During my rather excessive layover, I played catchup with all the internet stuff I missed during the trip…
I must say OUGN 2014 was a pretty cool event all round! The speaker lineup was incredible. The location (on a boat) was fun. I’ve not done (more...)
I had 31.9 GB free and OUI through error about disk space. Fair enough cause it also proposed a parameter to ignore it. Current version of GI (220.127.116.11) occupied around 25 GB so i though it will be OK (more...)
Understanding the implications of DFOs / DFO Trees is important as prerequisite for understanding some of the effects (more...)