Flashback, Flashing Back A Table….

genernal

So we continue in this post talking about Flashback. In this post, we shall see what’s Flashback of a table is all about. With the Flashback of the table, even if the table is logically corrupted, we can recover the table using the Undo data. To illustrate, let’s create a table and insert some data […]

Read more >

Flasbhack Table…..

genernal

As we have been discussing Flashback technology, in this post, we shall see how it helps in getting a table recovered after being dropped. A very common mistake that happens in the database environments is that someone would drop a table. Now that table drop is not a wrong command. Thus, if the user has […]

Read more >

Flashback, DBA’s Best Friend….

genernal

I just finished teaching a DBA class and surprisingly, few of the participants , despite having experience in the database administration, hadn’t really touched Flashback technology in a great detail. Though it’s not a new topic but I thought, let me write about it to make sure that more DBA’s are aware of this. Biggest […]

Read more >

DBA’s Be Quicker, Use Aliases….

genernal

I have been using aliases in Linux from a long time. But I was teaching a class today and some students asked me to explain it(it was a basic database administration class for newbies). So it’s more a reference about the aliases. Aliases are short forms of the long commands that one may use in […]

Read more >

PMAN Background Process….

genernal

This is for my own reference later on. I totally forgot about the PMAN(Process Manager) background process. It’s a background OS process and manages several background processes including shared servers, pooled servers, and job queue processes. It’s available in database instances, ASM instances and in ASM Proxy instances. PMAN monitors, spawns, and stops the following […]

Read more >

Installing VNC Server In OCI VM….

genernal

So I am now trying to set up few of test machines in OCI environment. A lot can be done using the Putty but for some tasks, or even for just ease of use, having a GUI access is required. So I was searching for the setup and fortunately, I found this <iframe width=”560″ height=”315″ […]

Read more >