Infrastructure at your Service

Tag

Oracle Archives - Page 56 of 57 - Blog dbi services

Oracle Team

Troubleshooting: ORA-29283 when oracle is member of a group with read/write privileges

By | Database management | 7 Comments

Recently, I worked on an Oracle database migration for a customer and I faced a strange behavior when accessing a file stored on the file system of the Oracle database. The database has been migrated on a new server, and consolidated with existing databases. Several jobs are running into the database and need to access the file system to read or write some files. A particular file is received daily from a remote job over…

Read More
Franck Pachot

Oracle Partitioned Sequences – a future new feature in 12c?

By | Database management, Oracle | 6 Comments

By Franck Pachot . Disclaimer: I’ll talk about an undocumented feature that appeared in Oracle 12c – undocumented except if you consider that being exposed in DBA_SEQUENCES as the PARTITION_COUNT is a kind of documentation. So, as the syntax is not documented (I got it only by guessing), you should not use it in production: there are probably some reasons why Oracle did not expose an interresting feature like that.

Read More
Franck Pachot

Oracle et Dbvisit Replicate pour migrer sans arrĂȘt de service… et sans stress

By | Hardware & Storage, Oracle | No Comments

By Franck Pachot . Je viens d’assister au Webinar Zero Downtime Migration pour Oracle, prĂ©sentĂ© par Chris Lawless qui est rĂ©cemment passĂ© de Product Manager Golden Gate Ă  Product Manager Dbvisit.  Je vais dĂ©tailler ici un point trĂšs important Ă©voquĂ© par Chris Lawless. La migration par rĂ©plication n’est pas seulement envisagĂ©e pour Ă©viter un arrĂȘt de service. ArrĂȘt nĂ©cĂ©ssaire lors de la migration proprement dite (qui peut aller de quelques minutes Ă  plusieurs heures en…

Read More
Franck Pachot

Archivelog deletion policy for Standby Database in Oracle Data Guard

By | Database Administration & Monitoring, Oracle | 46 Comments

By Franck Pachot . Do you use ARCHIVELOG DELETION POLICY TO APPLIED ON ALL STANDBY for your Oracle databases in Data Guard? Maybe you also use the Fast Recovery Area as archive log destination. That’s good practice! But did you ever check that it works as expected? What I mean is this: The archived logs that you don’t need are reclaimable by the FRA when space is needed And the archived logs that are required…

Read More
Franck Pachot

Sockets, Cores, Virtual CPU, Logical CPU, Hyper-Threading: What is a CPU nowadays?

By | Application integration & Middleware, Oracle | 8 Comments

By Franck Pachot . Because people know that I really like Oracle AWR reports, they send them to me from time to time. Here is one I have received for Christmas with the following question: ‘Since our AIX server is virtualized, the response times are 4x longer. I feel that we are CPU bound, but cpu usage is mostly idle. Is there something hidden?’ It is a question that is frequently raised with virtualized environments….

Read More
Oracle Team

UKOUG Day 4: Oracle Cloud Control 12c for DBAs

By | Technology Survey | No Comments

Today’s first session was a round table session with Andrew Bullock, Director of Application and systems management at Oracle. The main result of this session was that the main people using Enterprise Manager Cloud Control 12c were DBA and not so much system or Weblogic Administrators. It appears also that not so many DBA have realized in production the upgrade from Grid Control 11g to Cloud Control 12c, because in case of a huge number…

Read More
Nicolas Jardot

UKOUG Tech13: Optimizer & SQL statements – hint or not hint that’s the question

By | Technology Survey | No Comments

It’s the final day of Tech13, less sessions but still good topics. Mainly about the Oracle’s optimizer: looking at the execution plans and a debate about hinting SQL statements. I will focus on the hint topic in this blog. Due to trip planning it’s a much shorter day, less time for attending sessions and less time for blogging. I will focus on the debate between Tony Hasler and Jonathan Lewis about how the optimizer takes…

Read More
Oracle Team

UKOUG Day 3: PL/SQL hints by Tom Kyte & Oracle Active Data Guard

By | Technology Survey | No Comments

Today’s first session I assisted was presented by Tom Kyte. He talked about SQL topics we surely do not know. The first topic concerned the possibility of using the plsql_warning clause with the PL/SQL compiler. This feature exists since version 10.1 but is not widely used. The different values you can define for the plsql_warning with a classical alter session command are: Severe: code might cause unexpected errors or wrong results Performance: code might cause…

Read More
Nicolas Jardot

UKOUG Tech13: Day 2 – PL/SQL performance, Pluggable database API and so on

By | Technology Survey | No Comments

Tech13 – Day 2: 11 different streams with 3 dedicated to the databases. Many interesting topics and it’s sometimes hard to choose to which session attend. I tried to keep an eye on sessions about performances. I was interested on more than 6 sessions for that day but I can’t speak of all. PL/SQL performance Timothy Hall, blogger from oracle-base.com was speaking about improving the performance of PL/SQL calls from SQL. It’s not always easy…

Read More
Nicolas Jardot

Oracle Open World 2013: Final day – Database as a service and replication fundamentals

By | Technology Survey | No Comments

My final day at Oracle OpenWorld 2013, less sessions and less people but still a big day after almost one week in San Francisco. In this blog I’ll focus on the private cloud with databases as service and the fundamentals about replication. To conclude on Oracle OpenWorld, I would say that there are three big news – more on these at the end of this posting. On Thursday, there are less people in the sessions…

Read More