15,086 reputation
12553
bio website google.com
location Manchester, United Kingdom
age 37
visits member for 3 years, 2 months
seen 5 hours ago

Oracle DBA, Unix admin.

Available for employment! ;)


7h
comment Oracle: built in SQL pretty-print?
If the given SQL will correctly parse ok in your current database, you might be able to use DBMS_SQL.PARSE to get it into the shared pool without executing it, then use DBMS_METADATA to pretty print it. Obviously won't work if the statement won't parse in the current session due to missing objects.
19h
comment Whats is the maximum size a relational database can handle before considering switching to a NoSQL database
An Oracle database can be 8 Exabytes (Tb->Pb->) in size if using 32k blocks and big file tablespaces. It's not the size that matters, it's what. you do with it that counts.
22h
comment How to check state of oracle databse
Look in the alert log to see what the exact problem is when you attempt to start it
1d
comment Slow running Oracle query caused by unnecessary full table scan
Are stats up to data on both tables? Any histograms? What's the cardinality of the data?
1d
comment Why connection in sqldeveloper to machine in the same network fails?
Is the hostname present in DNS? More than likely not
1d
comment Oracle 11.2 restore DB to a specific point
How much data is going to change? This is the most important thing, as it affects the decision to use flashback
1d
comment Script to automatically Identify tablespaces above threshold and bring it back to below threshold value
Plan tablespace growth ahead and set the tablespaces to AUTOEXTEND accordingly
1d
comment Query that was working on MySQL is not working on PostgreSQL
What's the data type of location_id? Why is an integer in quotes?
Mar
28
comment optimisation for 4million + records
Impossible to help you without a query explain, and list of current indexes.
Mar
27
comment can we create a user defined groups with different users and different schemas in oracle11 g
They're called roles in Oracle. Read the documentation. docs.oracle.com/cd/B19306_01/network.102/b14266/admusers.htm
Mar
26
comment How can I quickly detect that connectivity between two linked servers has been restored?
Sounds like the wrong question is being asked, given how the functionality works
Mar
26
comment MySQL silently replaces UTF chars with literal question marks
MySQL is a mess. But most RDBMSes wouldn't complain about all of this - garbage in, garbage out
Mar
25
comment MSQL bin-log location is not being updated
I guess you've not restarted MySQL?
Mar
25
comment Populating a table with data from a table that has the historical data on columns (SQL/plSQL 10g)
I'm voting to close this question as off-topic because the OP has shown zero effort
Mar
24
comment trying to a lag a column in SQLite
3.2 billion rows in sqlite... crikey. Might be better off whacking them temporarily into an RDBMS
Mar
24
comment Return Distinct Set of Values Based on MAX Date
Why's this tagged with mysql if you're using Oracle?
Mar
24
comment MySQL General error: 126 Incorrect key file for table '/tmp/#sql_27e6_0.MYI'; try to repair it'
You're doing an ORDER BY. It has to sort the entire table of 2 million records before giving you the first 1000. That's why
Mar
24
comment MySQL General error: 126 Incorrect key file for table '/tmp/#sql_27e6_0.MYI'; try to repair it'
How much free disk space do you have in /tmp ?
Mar
24
comment Unable to open display to specific user in Red Hat 6.4
I'm voting to close this question as off-topic because it should be on superuser
Mar
23
comment RMAN Performance Problems following Platinum Patching on Exadata DB
Google for the oracle-l mailing list and ask there - there's loads of Exadata people on the list & they may have seen this before