Community, Events

GUOB Tech Day 2016: Review!

 , , ,

Hi guys!

As you know, last week I was in 7th edition of GUOB Tech Day, in São Paulo/Brazil, part of OTN LA Tour. As it use to be, it was a great experience. As usual, after an opening with Oracle and OTN speech we had some parallel sessions, so I unfortunately had to choose only a few of them. But it think I made a good selection. Here is the list:

More“GUOB Tech Day 2016: Review!”

Database, Shell Scripts

ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases

 , , , , ,

As you know, since 11g we have a Automatic Diagnostic Repository (ADR). To better manage it, we also have a Command-line Interface, called ADRCI.
ADR contains all diagnostic information for database (logs, traces, incidents, problems, etc).

adr1

ADR Structure

More“ADRCI Retention Policy and Ad-Hoc Purge Script for all Bases”

Shell Scripts

“tail -f” vs “tail -F”: Do you know the difference?

 ,

Hi all!
Do you know the difference between “tail -f” and “tail -F”?

duvida

Ok, don’t feel bad. It’s very difficult to find someone who knows… And with a reason, I can’t find any link explaining this by Googling.
It’s possible that I don’t know how to search it too. But I searched as I’d search if I didn’t know that… And couldn’t find anything about…

Let’s take a look on –help, so:

More““tail -f” vs “tail -F”: Do you know the difference?”

Database, Errors and Bugs, SQL | PLSQL

ORA-01950 On Insert but not on Create Table

 , , ,

Sounds weird creating table does not raise any error, but inserting a correct tuple in this table raise a permission error, right? Just take a look:

SQL> create table matheusdba.table_test(a number) tablespace TEST_TABLESPACE;
Table created.
SQL> insert into matheusdba.table_test values (1);
insert into matheusdba.table_test values (1)
*
ERROR at line 1:
ORA-01950: no privileges on tablespace 'TEST_TABLESPACE'

More“ORA-01950 On Insert but not on Create Table”

Community, Events

Oracle OpenWorld Latin America 2016 : Review

 , ,

Hi Folks!
As I told you here, last 28, 29 and 30th I was at Oracle OpenWorld LA 2016, in São Paulo/SP – Brazil.
Before my considerations, I’d like to remember that some presentation materials used by speakers are available at here.

There was a lot of sessions, so the review for is as short as possible for each one of them:

More“Oracle OpenWorld Latin America 2016 : Review”

Database, Errors and Bugs

Alert Log: “Private Strand Flush Not Complete” on Logfile Switch

 , , , , ,

Hi all!
Just a curiosity: Have you ever noticed in a database alert log the occourance of the following message for every logfile switch:

Thread 1 cannot allocate new log, sequence 9281
Private strand flush not complete
  Current log# 5 seq# 9280 mem# 0: /db/u5001/oradata/GREPORADB/redo05a.log
Thread 1 advanced to log sequence 9281 (LGWR switch)
  Current log# 6 seq# 9281 mem# 0: /db/u5001/oradata/GREPORADB/redo06a.log

More“Alert Log: “Private Strand Flush Not Complete” on Logfile Switch”