Viewing 15 posts - 2,221 through 2,235 (of 3,060 total)
oh boy 😀
1- the statement that reads "only managers can manage a department" does not holds true in the real world. In the real world you are going to...
_____________________________________
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.January 20, 2010 at 7:00 am
Welcome to the Oracle world... there is not such a thing as Temp DB in Oracle but we do have Temp tablespaces sitting on the same Oracle instance.
In regards to...
_____________________________________
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.January 20, 2010 at 6:50 am
oh yes! very interesting indeed.
I found the article as interesting as the theory that Grand Cannyon was an alien mining operation is 😀 which everybody knows is true,...
_____________________________________
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.January 20, 2010 at 6:41 am
David Portas (1/20/2010)
PaulB-TheOneAndOnly (1/20/2010)
When I say 1-1 relationship I'm not saying 1-0/1; I'm saying 1-1 and I insist that a 1-1 relationship most certainly means something is deadly wrong.
What is...
_____________________________________
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.January 20, 2010 at 6:34 am
Too litle and vague information to support any serious advise.
What does your DBA says about it?
_____________________________________
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.January 20, 2010 at 6:24 am
David Portas (1/20/2010)
PaulB-TheOneAndOnly (1/19/2010)
1) A design that ends up with two or more tables having a 1-1 relationship most of the time means something is wrong.
Why?
It is true that such...
_____________________________________
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.January 20, 2010 at 6:09 am
ORA-01652 does not signals timeout but the inability to extend a temporary segment a.k.a. tablespace full 🙂
Oracle error stack is certainly pointing to affected tablespace, it could be either...
_____________________________________
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.January 20, 2010 at 6:02 am
Yes I have a backup
Question is... which recovery model is in place?
Is it Full or Bulk-logged?... in the affirmative case Lynn's suggestion e.g. taking a tail-log backup - would...
_____________________________________
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.January 19, 2010 at 11:09 am
Yes, cast() it.
_____________________________________
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.January 19, 2010 at 8:35 am
May I ask what is the rationale behind such a consolidation project?
The most active/queried to-be-consolidated table represents less than 10% of total data volume... why would somebody add to this...
_____________________________________
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.January 19, 2010 at 8:34 am
A dimension table should describe a single attribute in a fact table - is this the case?
_____________________________________
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.January 19, 2010 at 8:19 am
Two thoughts...
1) A design that ends up with two or more tables having a 1-1 relationship most of the time means something is wrong.
2) No physical design should include n-n...
_____________________________________
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.January 19, 2010 at 8:16 am
This is home work, isn't it? - nothing wrong about that.
If you really want to get a grasp of it do this...
Entity-Relationships
- Identify your entities - draw it!
- Identify...
_____________________________________
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.January 19, 2010 at 8:06 am
I would start by gathering fresh performance statistics on affected tables and indexes ... it is not unseen that new RDBMS engines does not like performance stats gathered with previous...
_____________________________________
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.January 19, 2010 at 7:46 am
amitabhssinha (1/19/2010)
Your suggestion please.
My suggestion would be... please answer my questions 😀
Here they are...
- how many rows are stored on DATE_SAMPLE table?
- how many rows is supposed to retrieve...
_____________________________________
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.January 19, 2010 at 7:32 am
Viewing 15 posts - 2,221 through 2,235 (of 3,060 total)