Viewing 15 posts - 2,506 through 2,520 (of 3,060 total)
doug.williams (6/1/2009)(Oracle 9i is still alive and well)
Actually, Oracle 7 is still alive and well 😀
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.June 1, 2009 at 2:31 pm
vivek (5/30/2009)
Still waiting for any suggestation.
Trace the query.
Compare execution plans, wait events.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 30, 2009 at 5:17 pm
First the good news...
Described scenario is a text book case of a single star-schema datamart with a single FACT table in the center surrounded by DIMension tables.
Now the not so...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 30, 2009 at 5:11 pm
Partitioning is a useful resource if properly done -if not it has the potential of becoming you worst nightmare.
Partitioning strategy should at least help in one of the cases below:
1)...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 29, 2009 at 7:00 am
berto (5/29/2009)Partition1
tableA_May
tableB_May
partiotion2
tableA_June
tableB_June
Hard to follow...
Do you really want to create partitions using pieces of different tables?
Imagine TableA and TableB are actually a piece of Genoa Salami and a piece of Pepperoni.
When...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 29, 2009 at 6:45 am
Yes!
Here is how you do it.
1- Pre-create the database in your "target" server -so you make all decisions about storage.
2- Force-restore over the pre-created database -so datafiles go to the...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 2:48 pm
Look at "log shipping" -that's a SQL Server managed process that would do exactly what you are looking for.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 2:36 pm
Krasavita (5/28/2009)
I created instances and I can connect to them locally,but I can connect remotly
Are you prefixing the named-instance properly?
Connection string for named instances should look like HOST_NAME\INSTANCE_NAME
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 2:08 pm
Are jobs running T-SQL scripts? look at the code, specifically "use" statements.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 2:03 pm
Brad Allison (5/28/2009)
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 1:25 pm
If query takes only 4 seconds on Oracle side I would say connectivity is the issue.
Here is how you can trace Oracle side of the query...
Set your environment... e.g. ORACLE_HOME...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 1:14 pm
David Benoit (5/28/2009)
Can you backup to and restore from the external hard drive? If so, that seems like the safest and least painful way of doing this.
:w00t: flashback!
Brilliant post!...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 1:09 pm
Shall I understand query takes 4 seconds on Oracle but 1 minute 45 seconds to return when over a link?
How much data does the query returns?
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 1:03 pm
I personally don't like surrogate keys; when possible I prefer to use meaningful -natural keys.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 12:18 pm
I would take a full backup of "source" database,
move the dump file to an external disk drive,
ship the external drive to "target" location,
plug the external disk drive on "target"...
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.May 28, 2009 at 12:14 pm
Viewing 15 posts - 2,506 through 2,520 (of 3,060 total)