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

Oracle DBA, Unix admin.

Available for employment! ;)


3h
reviewed Close How to interract with my database?
3h
reviewed Close Cassandra- Data modelling for UserProfilie
3h
reviewed Close Increment the value of an entire column
15h
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.
1d
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.
1d
reviewed Close Why do maintenance plans exist as a feature?
1d
reviewed Close Warm Standby Using Point-In-Time Recovery (PITR) - Was it sucessful?
1d
reviewed Close Best way to insert html content into clob column in oracle
1d
reviewed Close Query issue for login page in asp.net?
1d
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
revised stored procedure not working
added 152 characters in body
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
2d
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?
2d
reviewed Approve VACUUM FULL fails with 'ERROR: Check free disk space'
2d
reviewed Leave Closed Guidance in creating a database for parks division attendance data
2d
reviewed No Action Needed Get the latest record and count them with time interval
2d
reviewed No Action Needed SQL Query challenge