meta user
network profile
| bio | website | google.com |
|---|---|---|
| location | Peak District National Park, United Kingdom | |
| age | 35 | |
| visits | member for | 1 year, 4 months |
| seen | 6 hours ago | |
| stats | profile views | 609 |
Oracle DBA, Unix admin.
Available for employment.
|
2d |
comment |
How to quickly startup/shutdown Oracle 11? dbstart and dbshut don't startup/shutdown EM, so you can't even compare it with the OPs script. In fact, if you look at the source for dbstart/dbshut it actually uses sqlplus to do its work in the same way as the custom script in the question, which in itself means it's impossible for dbstart to be faster. I'm guessing your "custom" tests were performed first, which pulled everything into cache thus making your dbstart test faster. Feel free to prove me wrong! My try: pastebin.com/E0yAVuJ0 Not a great deal of difference. Incomparable. |
|
2d |
reviewed | Approve suggested edit on Is there a standard way to use common data and procedures across multiple databases? |
|
2d |
reviewed | Approve suggested edit on Migration of create statement from SQL Server to MySQL |
|
2d |
reviewed | Approve suggested edit on Tablespace on ephemeral storage |
|
2d |
comment |
Why is dynamic pivoting not supported? I'll flip the question back to you... How would you go about parsing any query that contained a pivoted view with a dynamic number of columns? How would you reference these columns, as they are unnamed? You'd also have to hard parse every single query involving the view every time they were executed, maybe in several stages after the numbers of columns in the resultset that makes the view are known - hiw would you even deal with that? It'd perform like a dog, for starters... |
|
2d |
comment |
Oracle Grid Control Do you already have GC deployed and how well do you know it? |
|
May 21 |
reviewed | Approve suggested edit on sql-server-2008-r2 tag wiki excerpt |
|
May 21 |
reviewed | Approve suggested edit on SQL Server Alert Based On Severity Level Not Working |
|
May 21 |
comment |
How to fix error: Connection is busy with results for another hstmt (SQL-HY000) What kind of client is connecting? |
|
May 21 |
reviewed | Approve suggested edit on SQL Server TDE - add master key and certificate |
|
May 21 |
answered | Need an Oracle query to get the Oracle Home directory for a particular instance |
|
May 20 |
awarded | Constituent |
|
May 20 |
answered | can rman backup a subset of a table |
|
May 20 |
comment |
can rman backup a subset of a table No, it works at the block level. |
|
May 20 |
comment |
Finding oracle physical database filesselect * from dba_data_files, then you need the control files and the init.ora/spfile. You really need a DBA to do this for you though .... |
|
May 20 |
comment |
Connecting To Oracle with D2K & PHP Impossible without some kind of Oracle client, be it the full client or thin client. |
|
May 20 |
comment |
Adding a column at a specific position using DBMS_REDEFINITION @DavidAldridge Agreed. No doubt there's an ORM that requires the order, or some other hideousness involved! Maybe some beautiful SELECT * FROM ... :) |
|
May 20 |
comment |
Appending data from one program to the other using batch commands What are you calling SQL*Plus from? A shell script? A C prog? |
|
May 20 |
comment |
ODBC - how to set up ODBC driver for 2 languages (for different code page) ODBC talking to which RDBMS? |
|
May 19 |
comment |
Is Logical Fragmentation Meaningful in the age of huge SANs? I'll add that this is something that frustrates me these days - 10 years ago I'd dictate tablespace mappings (I'm an Oracle DBA) to clients and tell them what storage to buy for a hybrid OLTP/reporting system. I knew what disks they had and what configurations (RAID 5 for boring stuff, 0+1 for perf etc). Now, you're lucky if the "storage admin" even knows what has been presented to your DB host. Don't even get me started on thin provisioning! Anyway, SQL Server Question, so I'll leave it to the SQL Server people :) |
