Tweaking LLVM Obfuscator + quick look into some of LLVM internals.
In this topic we are not talking about grid or Oracle RAC yet, but this item is here. So, having proficiency in using the GI to manage a database (and we are still talking about standalone server) means to me “Oracle Restart“.
When installing grid infrastructure for a standalone, we get some utilities to set up and manage the oracle databases. The main utility for this is srvctl. The bright side for us is that the binary is much more simple, with just a few options.
I kicked off an expdp with the following parameters. I set the filesize parameter but forgot to set the dumpfile parameter to match:
How many rows will you return from a single table query if you include the predicate
rownum > 2
in the where clause.
Warning: this IS a catch question
To make it easier and avoid ambiguity, you may assume the table is the standard SCOTT.EMP table.
This posting was prompted by noticing a note that Dominic Brooks posted a few months ago.
seems to have grown too large. This database is held on a Windows 2003
Server. I need someone to tell me how to extract the data from the
large datafile without starting the database OR extend the allowed size
for the file on Windows so that I can start db.
Starting the db from a command window, I get:
>> CMD window >>
C:\Program Files\MySQL\MySQL Server 5.0\bin>mysql
With the release of Exadata X5 Oracle introduced elastic configurations and changed the process on how the initial configuration is performed. Back before you had to run applyconfig.sh which would go across the nodes and change all the settings according to your config. This script has now evolved and it’s called applyElasticConfig.sh which is part of OEDA (onecommand). During one of the recent deployments I ran into the below problem:
"Expectations is the place you must always go to before you get to where you're going. Of course,
some people never go beyond Expectations, but my job is to hurry them along whether they like it or not."
- Norton Juster, The Phantom Tollbooth
From time to time I find a situation where a developer believes that:
The fsfreeze command, is used to suspend and resume access to a file system. This allows consistent snapshots to be taken of the filesystem. fsfreeze supports Ext3/4, ReiserFS, JFS and XFS.
A filesystem can be frozen using following command:
Now if you are writing to this filesystem, the process/command will be stuck. For example, following command will be stuck in D (UNINTERUPTEBLE_SLEEP) state:
So this is it – the last article in my mini-series on understanding flash. This is the bit where I draw it all together in a neat conclusion that makes you think, “Yes! That was worth reading”. No pressure eh?
In a previous blog post I showed you how to take a JSON data file and to load it into your Oracle Schema using R. To do this I used ROracle to connect to the database and jsonlite to do the JSON processing of the data.Alternatives to using ROracle would be RODBC, RJDBC and DBI. So you could use one of these to connect to the database.